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