public void Destroy(VievPRODUCTS product) { if (!UpdateDatabase) { var target = GetAll().FirstOrDefault(p => p.ProductID == product.ProductID); if (target != null) { GetAll().Remove(target); } } else { var entity = new Products(); entity.ProductID = product.ProductID; Entities.Products.Attach(entity); Entities.Products.Remove(entity); var orderDetails = Entities.Order_Details.Where(pd => pd.ProductID == entity.ProductID); foreach (var orderDetail in orderDetails) { Entities.Order_Details.Remove(orderDetail); } Entities.SaveChanges(); } }
public void Update(VievPRODUCTS product) { if (!UpdateDatabase) { var target = One(e => e.ProductID == product.ProductID); if (target != null) { target.ProductName = product.ProductName; target.UnitPrice = product.UnitPrice; target.UnitsInStock = product.UnitsInStock; target.Discontinued = product.Discontinued; if (product.CategoryID == null) { product.CategoryID = 1; } if (product.Category != null) { product.CategoryID = product.Category.CategoryID; } else { product.Category = new ViewCATEGORIES() { CategoryID = (int)product.CategoryID, CategoryName = Entities.Categories.Where(s => s.CategoryID == product.CategoryID).Select(s => s.CategoryName).First() }; } target.CategoryID = product.CategoryID; target.Category = product.Category; } } else { var entity = new Products(); entity.ProductID = product.ProductID; entity.ProductName = product.ProductName; entity.UnitPrice = product.UnitPrice; entity.UnitsInStock = (short)product.UnitsInStock; entity.Discontinued = product.Discontinued; entity.CategoryID = product.CategoryID; if (product.Category != null) { entity.CategoryID = product.Category.CategoryID; } Entities.Products.Attach(entity); Entities.Entry(entity).State = EntityState.Modified; Entities.SaveChanges(); } }
public void Create(VievPRODUCTS product) { if (!UpdateDatabase) { var first = GetAll().OrderByDescending(e => e.ProductID).FirstOrDefault(); var id = (first != null) ? first.ProductID : 0; product.ProductID = id + 1; if (product.CategoryID == null) { product.CategoryID = 1; } if (product.Category == null) { product.Category = new ViewCATEGORIES() { CategoryID = 1, CategoryName = "Beverages" }; } GetAll().Insert(0, product); } else { var entity = new Products(); entity.ProductName = product.ProductName; entity.UnitPrice = product.UnitPrice; entity.UnitsInStock = (short)product.UnitsInStock; entity.Discontinued = product.Discontinued; entity.CategoryID = product.CategoryID; if (entity.CategoryID == null) { entity.CategoryID = 1; } if (product.Category != null) { entity.CategoryID = product.Category.CategoryID; } Entities.Products.Add(entity); Entities.SaveChanges(); product.ProductID = entity.ProductID; } }
public ActionResult EditingPopup_Destroy([DataSourceRequest] DataSourceRequest request, VievPRODUCTS product) { if (product != null) { ServicePRODUCTS a = new ServicePRODUCTS(); a.Destroy(product); } return(Json(new[] { product }.ToDataSourceResult(request, ModelState))); }