MvcBookStore/Models/BookRepository.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
namespace MvcBookStore.Models
{
    public class BookRepository:IBookRepository
    {
        public IList<Books> GetAllBooks()
        { 
            using (Models.MvcBookStoreEntities db=new MvcBookStoreEntities ())
            {
                return db.Books.Include("Categories").Where(b => b.StatusMark == 1).ToList();
            }
        }
        public IList<Books> GetTopSellingBooks(int count)
        {
            using (Models.MvcBookStoreEntities db = new MvcBookStoreEntities())
            {
                return db.Books.Include("Categories").Where(b => b.StatusMark == 1).Take(count).ToList();
            }
        }
        public Books GetBooksById(int id)
        {
            using (Models.MvcBookStoreEntities db = new MvcBookStoreEntities())
            {
                return db.Books.Include("Categories").Single(b => b.BookId == id);
            }
        }
        public void DeleteBooksById(int id)
        {
            using (Models.MvcBookStoreEntities db = new MvcBookStoreEntities())
            {
                Books book = db.Books.Include("Categories").Single(b => b.BookId == id);
                book.StatusMark = 2;
                db.SaveChanges();
            }
        }
        public void UpdateBooks(Books book)
        {
            using (Models.MvcBookStoreEntities db = new MvcBookStoreEntities())
            {
                db.Books.Attach(book);
                db.Entry(book).State = EntityState.Modified;
                db.SaveChanges();
            }
        }
        public void AddToBooks(Books book)
        { 
          using (Models.MvcBookStoreEntities db = new MvcBookStoreEntities())
          {
              book.StatusMark = 1;
              db.Books.Add(book);
              db.SaveChanges();
          }
        }
    }
}