public static void createRequisition(List <RequisitionItem> reqItemList, string submitStaff_id, string type, string status) { Requisition newReq = new Requisition(); Staff fromStaff = StaffController.getStaffById(submitStaff_id); // use sample data to test newReq.Requisition_ID = "REQ" + DateTime.Now.ToString("yyyyMMddHHmmss"); newReq.SubmissionStaff_ID = submitStaff_id; // approve staff can be null , for test use sample data //newReq.ApprovedByStaff_ID = "STF0002"; newReq.Create_Date = DateTime.Now; newReq.RequisitonType = type; newReq.Status = status; using (InventorySysDBEntities cntx = new InventorySysDBEntities()) { cntx.Requisitions.Add(newReq); cntx.SaveChanges(); foreach (RequisitionItem reqItem in reqItemList) { reqItem.Requisition_ID = newReq.Requisition_ID; cntx.RequisitionItems.Add(reqItem); } cntx.SaveChanges(); } if (type != "Special") { SendNotificationController.SendNotificaition(fromStaff, newReq.Requisition_ID); } }
public static void ConfirmRecivedItems(string DI, List <DisbursementDetail> ddlist, string deptID) { Staff rep = new Staff(); using (InventorySysDBEntities cntx = new InventorySysDBEntities()) { rep = StaffController.getRepByDepID(deptID); //update disbursmentdetail foreach (DisbursementDetail dd in ddlist) { updateDisbursmentDetail(cntx, dd); updateItemTransReceived(cntx, deptID, dd); } //update disbursment Disbursement disbursment = cntx.Disbursements.Find(DI); disbursment.Receive_Date = DateTime.Now; disbursment.Status = "Received"; // update Requisition List <Requisition> reqList = getRequisitionsByDI(DI); foreach (Requisition req in reqList) { Requisition reqData = cntx.Requisitions.Find(req.Requisition_ID); reqData.Update_Date = DateTime.Now; reqData.Status = "Received"; } cntx.SaveChanges(); } SendNotificationController.SendNotificaition(rep, DI); }
//approve requisitions public void ApproveRequisition(string reqId, string managerID) { Staff frmStaff = StaffController.getStaffById(managerID); var t = from x in ctx.Requisitions where x.Requisition_ID == reqId select x; Requisition r = t.First(); r.Status = "Approved"; r.ApprovedByStaff_ID = managerID; r.Update_Date = DateTime.Now; ctx.SaveChanges(); SendNotificationController.SendNotificaition(frmStaff, r.Requisition_ID); }
//reject requisitions public static void RejectRequisition(string reqId, string managerID, string RejectReason) { Staff frmStaff = StaffController.getStaffById(managerID); using (InventorySysDBEntities cntx = new InventorySysDBEntities()) { var t = from x in cntx.Requisitions where x.Requisition_ID == reqId select x; Requisition r = t.First(); r.Status = "Rejected"; r.ApprovedByStaff_ID = managerID; r.Update_Date = DateTime.Now; r.Remark = RejectReason; cntx.SaveChanges(); SendNotificationController.SendNotificaition(frmStaff, r.Requisition_ID); } }