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>(); }