public ActionResult ManageDetails([Bind(Include = "SBillDetailID,SBillID,LabourID,Job,Qty,UnitPrice,QtyRec,QtySold")] SuppBillDet supplierBillDetail)
{
var objToSave = new SupplierBillDetail()
{
SBillDetailID = supplierBillDetail.SBillDetailID,
SBillID = supplierBillDetail.SBillID,
LabourID = supplierBillDetail.LabourID,
Job = supplierBillDetail.Job,
Qty = supplierBillDetail.Qty,
UnitPrice = supplierBillDetail.UnitPrice,
QtyRec = supplierBillDetail.QtyRec,
QtySold = supplierBillDetail.QtySold
};
base.BaseSave <SupplierBillDetail>(objToSave, supplierBillDetail.SBillDetailID > 0);
return(RedirectToAction("Details", new { id = supplierBillDetail.SBillID }));
}
public ActionResult Details([Bind(Include = "SBillDetailID,SBillID,LabourID,Job,Qty,UnitPrice,QtyRec,QtySold")] SupplierBillDetail supplierBillDetail)
{
var GetItem = db.FirstOrDefault <SupplierBillDetail>("Select * From SupplierBillDetail Where LabourID=@0 and SBillID =@0", supplierBillDetail.LabourID, supplierBillDetail.SBillID);
if (GetItem == null)
{
supplierBillDetail.QtyRec = 0;
ViewBag.Total = db.Fetch <SupplierBillDetail>("");
base.BaseSave <SupplierBillDetail>(supplierBillDetail, supplierBillDetail.SBillDetailID > 0);
}
else
{
db.Update("SupplierBillDetail", "SBillDetailID", new { Qty = GetItem.Qty + supplierBillDetail.Qty, UnitPrice = supplierBillDetail.UnitPrice }, GetItem.SBillDetailID);
}
return(RedirectToAction("Details", new { id = supplierBillDetail.SBillID }));
}
