public Boolean createAdjustmentVoucher(string vID, string empID, double totalPrice) { bool status = false; SA43Team2StoreDBEntities ctx = new SA43Team2StoreDBEntities(); Adjustment abo = new Adjustment(); abo.VoucherID = vID; abo.EmpID = empID; abo.AdjustmentStatus = "Pending"; abo.VoucherDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); abo.AuthorisedBySupervisor = "No"; abo.AuthorisedByManager = "No"; abo.TotalPrice = Convert.ToDecimal(totalPrice); ctx.Adjustments.Add(abo); if (ctx.SaveChanges() > 0) { status = true; } else { status = false; } return(status); }
public void createAdjustmentVoucherDetails(string adNum, string vID, string itemNum, string qty, string supp, string reason) { SA43Team2StoreDBEntities ctx = new SA43Team2StoreDBEntities(); AdjustmentDetail ad = new AdjustmentDetail(); ad.AdjustmentDetailsID = adNum; ad.VoucherID = vID; ad.ItemNumber = itemNum; ad.QuantityAdjustment = Convert.ToInt32(qty); ad.SupplierID = supp; ad.Reason = reason; ctx.AdjustmentDetails.Add(ad); ctx.SaveChanges(); }