// GET: Product public ActionResult Index() { ProductBll bll = new ProductBll(); List <ComplexEntity <Product, ProductCategory> > objs = bll.GetProductWithCategory(); List <ProductModel> model = ProductModel.Convert(objs); return(View(model)); }
/// <summary> /// Get All Products. /// </summary> public List <ProductModel> GetAllProducts() { List <ProductModel> collection = new List <ProductModel>(); using (var context = new WOW_Assignment_ProductDBEntities1()) { collection.AddRange((context.Products.ToList().Select(a => ProductModel.Convert(a)))); } return(collection); }
/// <summary> /// Get Product. /// </summary> /// <param name="id"></param> public ProductModel GetProduct(int id) { ProductModel product = null; using (var context = new WOW_Assignment_ProductDBEntities1()) { var entity = context.Products.Where(a => a.ProductID == id).ToList().FirstOrDefault(); product = ProductModel.Convert(entity); } return(product); }
/// <summary> /// Add Product. /// </summary> /// <param name="model"></param> public bool AddProduct(ProductModel model) { outcome = false; using (var context = new WOW_Assignment_ProductDBEntities1()) { var entity = ProductModel.Convert(model); context.Products.Add(entity); outcome = context.SaveChanges() == 1; } return(outcome); }
/// <summary> /// Remove Product. /// </summary> /// <param name="model"></param> public bool RemoveProduct(ProductModel model) { outcome = false; using (var context = new WOW_Assignment_ProductDBEntities1()) { if (model != null) { var entity = ProductModel.Convert(model); context.Products.Attach(entity); context.Products.Remove(entity); outcome = context.SaveChanges() == 1; } } return(outcome); }
public async Task <ProductModel> AddAsync(ProductModel productModel) { var entity = await _context.Products.Where(p => p.Id == productModel.Id).FirstOrDefaultAsync(); Product product = productModel.Convert(entity); if (entity == null) { await _context.Products.AddAsync(product); } else { _context.Products.Update(product); } await _context.SaveChangesAsync(); return(await GetByIdAsync(product.Id)); }
/// <summary> /// Update Product. /// </summary> /// <param name="model"></param> public bool UpdateProduct(ProductModel model) { outcome = false; using (var context = new WOW_Assignment_ProductDBEntities1()) { if (model != null) { var entity = ProductModel.Convert(model); context.Products.Attach(entity); var entry = context.Entry(entity); entry.Property(p => p.Title).IsModified = true; entry.Property(p => p.Description).IsModified = true; entry.Property(p => p.ImageURL).IsModified = true; outcome = context.SaveChanges() == 1; } } return(outcome); }