/// <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 Count . /// </summary> public int ProductCount() { int count = 0; using (var context = new WOW_Assignment_ProductDBEntities1()) { count = context.Products.Count(); } return(count); }
/// <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); }
/// <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); }