public async Task <int> CreateProduct(PRODUCT model)
{
try
{
db.PRODUCTs.Add(model);
await db.SaveChangesAsync();
return(model.ProductID);
}
catch
{
return(0);
}
}
public async Task <int> CreateBrand(BRAND cate)
{
try
{
db.BRANDs.Add(cate);
await db.SaveChangesAsync();
return(cate.BrandID);
}
catch
{
return(0);
}
}
public async Task <bool> DeleteCustomer(int ID)
{
try
{
var cus = await db.CUSTOMERs.Where(x => x.CustomerID == ID).SingleOrDefaultAsync();
db.CUSTOMERs.Remove(cus);
await db.SaveChangesAsync();
return(true);
}
catch
{
return(false);
}
}
public async Task <int> AddOrderCustomer(int CustomerID, string name, string address, string phone, decimal total)
{
var order = new ORDER
{
CustomerID = CustomerID,
CustomerName = name,
CustomerAddress = address,
CustomerPhone = phone,
OrderStatusID = 1,
Total = total,
OrderDate = DateTime.Now
};
db.ORDERs.Add(order);
await db.SaveChangesAsync();
return(order.OrderID);
}
public async Task <int> CreateConfiguration(CONFIGURATION model)
{
try
{
if (db.PRODUCTs.FindAsync(model.ProductID) == null)
{
return(0);
}
db.CONFIGURATIONs.Add(model);
await db.SaveChangesAsync();
return(model.ConfigID);
}
catch
{
return(0);
}
}
public async Task <int> AddOrderDetail(int OrderID, int ProductID, int Quanity)
{
try {
var order = new ORDERDETAIL()
{
OrderID = OrderID,
ProductID = ProductID,
Quantity = Quanity
};
db.ORDERDETAILs.Add(order);
await db.SaveChangesAsync();
return(order.DetailID);
}
catch
{
return(0);
}
}