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 GetSellingByReference(string reference)
{
DeliveryOrderHeaderViewModel model = SellingDataAccess.GetByReference(reference);
if (model != null)
{
string SellingDate = model.SellingDate.ToString("ddd, dd/MM/yyyy");
return(Json(new { success = true, data = model, SellingDate = SellingDate }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
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));
}
public static DeliveryOrderHeaderViewModel GetByReference(string reference)
{
DeliveryOrderHeaderViewModel result = new DeliveryOrderHeaderViewModel();
using (var db = new BuahSayurContext())
{
result = (from dOr in db.DeliveryOrders
join c in db.Customers
on dOr.Customer_Username equals c.Username into clf
from c in clf.DefaultIfEmpty()
where dOr.Reference == reference
select new DeliveryOrderHeaderViewModel
{
Id = dOr.Id,
Customer_Username = c.Username,
Reference = dOr.Reference,
SellingDate = dOr.SellingDate,
IsSent = dOr.IsSent,
IsReturned = dOr.IsReturned
}).FirstOrDefault();
}
return result;
}
