public IEnumerable <BookDataAccess.Books> Get()
{
using (BookDBEntities entities = new BookDBEntities())
{
return(entities.Books.ToList());
}
}
public BookDataAccess.Books Get(int id)
{
using (BookDBEntities entities = new BookDBEntities())
{
var entity = entities.Books.FirstOrDefault(e => e.Id == id);
if (entity == null)
{
throw new Exception("Not found!");
}
return(entity);
}
}
public string InsertProductType(ProductTypes productType)
{
try
{
BookDBEntities db = new BookDBEntities();
db.ProductTypes.Add(productType);
db.SaveChanges();
return(productType.Name + "was succesfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertProduct(Cart cart)
{
try
{
BookDBEntities db = new BookDBEntities();
db.Cart.Add(cart);
db.SaveChanges();
return(cart.DatePurchased + "was succesfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public List <products> GetAllProducts()
{
try
{
using (BookDBEntities db = new BookDBEntities()) {
List <products> products = (from x in db.products
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public products GetProduct(int id)
{
try
{
using (BookDBEntities db = new BookDBEntities())
{
products product = db.products.Find(id);
return(product);
}
}
catch (Exception e)
{
return(null);
}
}
///主视图
//
// GET: /Publisher/
public ActionResult Index()
{
PublisherModel model = new PublisherModel();
using (var db = new BookDBEntities())
{
List <Publisher> lstPublish = db.Publisher.ToList();
model.PublishList = lstPublish.Select(x => new SelectListItem()
{
Text = x.Name,
Value = x.ID.ToString()
});
}
return(View(model));
}
public string DeleteProduct(int id)
{
try
{
BookDBEntities db = new BookDBEntities();
ProductTypes productType = db.ProductTypes.Find(id);
db.ProductTypes.Remove(productType);
db.SaveChanges();
return(productType.Name + "was succesfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteProduct(int id)
{
try
{
BookDBEntities db = new BookDBEntities();
Cart cart = db.Cart.Find(id);
db.Cart.Remove(cart);
db.SaveChanges();
return(cart.DatePurchased + "was succesfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public List <products> GetProductsByType(int typeId)
{
try
{
using (BookDBEntities db = new BookDBEntities())
{
List <products> products = (from x in db.products
where x.TypeId == typeId
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public JsonResult GetBooksByPublishID(int id)
{
IEnumerable <BookModel> modelList = new List <BookModel>();
using (var db = new BookDBEntities())
{
List <Book> lstBooks = db.Book.Where(x => x.PublisherID == id).ToList();
modelList = lstBooks.Select(x => new BookModel()
{
Title = x.Title,
Author = x.Auther,
Price = x.Price,
Year = x.Year
});
}
return(Json(modelList, JsonRequestBehavior.AllowGet));
}
public BookDataAccess.Books Post(BookDataAccess.Books book)
{
try
{
using (BookDBEntities entities = new BookDBEntities())
{
var result = entities.Books.Add(book);
entities.SaveChanges();
return(result);
}
}
catch (Exception ex)
{
throw new Exception("Error cannot add this book", ex);
}
}
public string UpdateProduct(int id, products product)
{
try
{
BookDBEntities db = new BookDBEntities();
products p = db.products.Find(id);
p.Name = product.Name;
p.Price = product.Price;
p.TypeId = product.TypeId;
p.Description = product.Description;
p.Image = product.Image;
db.SaveChanges();
return(product.Name + "was succesfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public void Delete(int id)
{
try
{
using (BookDBEntities entities = new BookDBEntities())
{
var entity = entities.Books.FirstOrDefault(e => e.Id == id);
if (entity == null)
{
throw new Exception("Cannot delete book!");
}
entities.Books.Remove(entity);
entities.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("Cannot delete book", ex);
}
}
public string UpdateProduct(int id, Cart cart)
{
try
{
BookDBEntities db = new BookDBEntities();
Cart p = db.Cart.Find(id);
p.DatePurchased = cart.DatePurchased;
p.ClientID = cart.ClientID;
p.Amount = cart.Amount;
p.IsInCart = cart.IsInCart;
p.ProductID = cart.ProductID;
db.SaveChanges();
return(cart.DatePurchased + "was succesfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public BookDataAccess.Books Put(int id, BookDataAccess.Books book)
{
try
{
using (BookDBEntities entities = new BookDBEntities())
{
var entity = entities.Books.FirstOrDefault(e => e.Id == id);
if (entity == null)
{
throw new Exception("Error cannot update book");
}
entities.Entry(entity).CurrentValues.SetValues(book);
entities.SaveChanges();
return(entities.Entry(entity).Entity);
}
}
catch (Exception ex)
{
throw new Exception("Cannot update book", ex);
}
}
public DataAccess(BookDBEntities context)
{
this._context = context;
this.dbSet = context.Set <TEntity>();
}
