public static SellingResult Save(DeliveryOrderHeaderViewModel models)
{
SellingResult result = new SellingResult();
try
{
using (var db = new BuahSayurContext())
{
string newRef = GetNewReference();
result.Reference = newRef;
DeliveryOrder deliveryOrder = new DeliveryOrder
{
Id = 1,
Customer_Username = models.Customer_Username,
Reference = newRef,
SellingDate = models.SellingDate,
IsSent = false,
IsReturned = false
};
db.DeliveryOrders.Add(deliveryOrder);
foreach (var item in models.DeliveryDetails)
{
DeliveryOrderDetail deliveryDetail = new DeliveryOrderDetail
{
DeliveryOrder_Id = deliveryOrder.Id,
Item_Code = item.Item_Code,
Quantity = item.Quantity,
Price = item.Price,
Total = item.Quantity * item.Price
};
result.Total += (item.Quantity * item.Price);
db.DeliveryOrderDetails.Add(deliveryDetail);
// Update Stock
Item Stock = db.Items.Where(x => x.Code == item.Item_Code).FirstOrDefault();
if (Stock != null)
{
Stock.Stock = Stock.Stock - item.Quantity;
}
}
db.SaveChanges();
}
}
catch (Exception ex)
{
result.Success = false;
Message = ex.Message;
}
return result;
}
public ActionResult SaveSelling(DeliveryOrderHeaderViewModel models)
{
if (ModelState.IsValid)
{
SellingResult result = SellingDataAccess.Save(models);
if (result.Success)
{
return(Json(new { success = true, message = "Success", data = result }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = SellingDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { success = false, message = "Invalid Model State!" }, JsonRequestBehavior.AllowGet));
}
