public void updateReqStatus(string reqId) //Update req status { Requisition r = context.Requisitions.Where(x => x.RequisitionID == reqId).First(); r.Status = "Received"; context.SaveChanges(); }
public void updateOutstnading(string itemNumber, string depId, int quantity) //To udate outstanding { OutstandingInfo o = context.OutstandingInfoes.Where(x => x.ItemNumber == itemNumber && x.DepartmentID == depId).FirstOrDefault(); o.Quantity = quantity; o.Status = "Pending"; context.SaveChanges(); }
public int activateDelegate(string empTitle, DateTime delegateStart, DateTime delegateEnd) { Employee e = getEmployeeByTitle(empTitle); e.Delegate = 1; e.DelegateStartDate = delegateStart; e.DelegateEndDate = delegateEnd; context.SaveChanges(); return(0); }
public void updateRequisitionStatus(string requisitionId, string status) { Requisition r = context.Requisitions.Where(x => x.RequisitionID == requisitionId).FirstOrDefault(); r.Status = status; if (status == "Approved") { r.ApprovalDate = DateTime.Today; } context.SaveChanges(); }
public int activateDelegate(string deptId, string empId, DateTime delegateStart, DateTime delegateEnd) { Employee h = getHeadByDepId(deptId); Employee e = getEmployeeById(empId); h.Delegate = 1; h.DelegateStartDate = delegateStart; h.DelegateEndDate = delegateEnd; e.Delegate = 1; context.SaveChanges(); return(0); }
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 Boolean updateStatusMan(string voId) { bool status = false; Adjustment vo = context.Adjustments.Where(x => x.VoucherID == voId).FirstOrDefault(); vo.AdjustmentStatus = "Approved"; vo.AuthorisedByManager = "Yes"; if (context.SaveChanges() > 0) { status = true; } else { status = false; } return(status); }
/*get delegated employee*/ public static void delegateEmp(string DeptId, string EmpName, string startDate, string endDate) { string EmpActName = EmpName.Replace("_", " "); Employee e = (from x in m.Employees where x.EmpName.Equals(EmpActName) && x.DepartmentID.Equals(DeptId) select x).First(); e.Delegate = 1; Employee e1 = (from x in m.Employees where x.DepartmentID.Equals(DeptId) && x.EmpTitle.Equals("Head") select x).First(); e1.Delegate = 1; e1.DelegateStartDate = Convert.ToDateTime(startDate); e1.DelegateEndDate = Convert.ToDateTime(endDate); m.SaveChanges(); }
public int assignDepRep(string empId) { Employee e = new Employee(); e = context.Employees.Where(x => x.EmpID.Equals(empId)).FirstOrDefault(); Department d = new Department(); d = context.Departments.Where(x => x.DepartmentID.Equals(e.DepartmentID)).FirstOrDefault(); d.RepID = empId; context.SaveChanges(); return(0); }
public static string ApproveRequisition(string comment, string reqId) { string update = "false"; Requisition r = (from x in m.Requisitions where x.RequisitionID.Equals(reqId) select x).First(); r.Status = "Approved"; r.CommentsByHead = comment; r.ApprovalDate = DateTime.Now; if (m.SaveChanges() > 0) { update = "true"; } else { update = "false"; } return(update); }
/*get update supplier*/ public int updateSupplier(InventoryStock item) { InventoryStock stock = getInventoryById(item.ItemNumber); stock.Supplier1 = item.Supplier1; stock.Supplier2 = item.Supplier2; stock.Supplier3 = item.Supplier3; stock.Price1 = item.Price1; stock.Price2 = item.Price2; stock.Price3 = item.Price3; context.SaveChanges(); return(1); }
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(); }
public static string updatePO(PurchaseOrder po) { var q = m.PurchaseOrders.Where(x => x.POID == po.POID).FirstOrDefault(); PurchaseOrder p = (PurchaseOrder)q; q.ApprovalDate = DateTime.Today; q.Status = po.Status; q.CommentsBySupervisor = po.CommentsBySupervisor; int updateStatus = m.SaveChanges(); if (updateStatus > 0) { return("Success"); } return("Fail"); }
public bool updateCollectionTime(string cp, string ct) { bool r = false; CollectionPointDetail d = new CollectionPointDetail(); d = (from x in context.CollectionPointDetails where x.CollectionPoint.Equals(cp) select x).First(); if (d != null) { d.CollectionTime = ct; context.SaveChanges(); r = true; } return(r); }
public bool updateCollectionPoint(string depId, string cp) { bool r = false; string id; Department d = new Department(); d = (from x in context.Departments where x.DepartmentID.Equals(depId) select x).First(); if (d != null) { id = getCollectionId(cp); d.CollectionPointID = id; context.SaveChanges(); r = true; } return(r); }
public void submitRequisition(Requisition requisition) { context.Requisitions.Add(requisition); context.SaveChanges(); }
public void updateDisList(List <ReadyForCollectionBO> rcboLst) { foreach (ReadyForCollectionBO rbo in rcboLst) { Disbursement d = (from x in context.Disbursements where x.DepartmentID == rbo.DepId && x.RequisitionID.Equals(rbo.ReqisitionId) && x.ItemNumber == rbo.ItemNumber select x).FirstOrDefault(); if (d != null) { d.Status = "Close"; d.DisbursementQuantity = rbo.DisbursedQuantity; context.SaveChanges(); OutstandingInfo q2 = (from x in context.OutstandingInfoes where x.DepartmentID.Equals(rbo.DepId) && x.ItemNumber.Equals(rbo.ItemNumber) select x).FirstOrDefault(); if (q2 != null) { int requestedQty = Convert.ToInt32(d.OrderQuantity); int dispQty = (int)rbo.DisbursedQuantity; //To read from text box //Check for outstanding status if (q2.Status != "Partial Received") { if ((requestedQty - dispQty) > 0) { q2.Quantity += (requestedQty - dispQty); } else if ((requestedQty - dispQty) < 0) { q2.Quantity -= (dispQty - requestedQty); } else { q2.Quantity = 0; } } else { if ((requestedQty - dispQty) > 0) { q2.Quantity = q2.PartialPendingQty + (requestedQty - dispQty); } else if ((requestedQty - dispQty) < 0) { q2.Quantity = q2.PartialPendingQty + (dispQty - requestedQty); } else { q2.Quantity = 0; } } if (q2.Quantity > 0) { q2.Status = "Pending"; } else { q2.Status = "Received"; } context.SaveChanges(); } } } }