public async Task <Requisition> SaveRequisitionForm(Requisition req, HttpSessionStateBase session) { req.status = "Submitted"; db.Requisitions.Add(req); await db.SaveChangesAsync(); EmailBusinessLogic emailBizLogic = new EmailBusinessLogic(); string receipient = req.approvalPerson; string sender = req.employee; string linkref = "http://" + ConstantsConfig.linkrefURLPartial + "/Requisition/ReqFormDetail?id=" + req.requisitionId; emailBizLogic.SendEmail("submitNewReq", receipient, sender, null, null, linkref); return(req); }
public bool SetRepresentative(string repname, HttpSessionStateBase session) { if (repname is null) { session["MessageBack"] = "Please choose an employee to represent"; return(false); } string[] emplist = (string[])session["AuthEmployeeList"]; if (!emplist.Contains(repname)) { session["MessageBack"] = "No such employee (" + repname + ") in this department"; return(false); } session["MessageBack"] = ""; string deptid = session["DepartmentID"].ToString(); DeptCollectionDetail deptDetails = db.DeptCollectionDetails.Where(x => x.departmentId == deptid).First(); string newrepID = new string(repname.Where(Char.IsDigit).ToArray()); string username = session["Username"].ToString(); string password = session["Password"].ToString(); string statusMessage = WebAccessSetRepresentative(username, password, newrepID); if (statusMessage == "Success") { deptDetails.representative = newrepID; EmailBusinessLogic emailBizLogic = new EmailBusinessLogic(); string sender = session["EmployeeID"].ToString(); string receipient = newrepID; emailBizLogic.SendEmail("assignRep", receipient, sender, null, null, null); } db.SaveChangesAsync(); return(true); }
public void DeliveryConfirmation(DeliverOrderViewModel dovm) { PurchaseOrder purchaseOrder = db.PurchaseOrders.Find(dovm.poNumber); purchaseOrder.remark = dovm.status; DeliveryOrder deliveryOrder = new DeliveryOrder(); deliveryOrder.doId = dovm.doNumber; deliveryOrder.poId = dovm.poNumber; deliveryOrder.deliveryDate = dovm.doDate; deliveryOrder.remark = dovm.deliverRemark; db.DeliveryOrders.Add(deliveryOrder); foreach (DeliverOrderViewModelDetail x in dovm.dovmdList) { DeliveryOrderDetail dod = new DeliveryOrderDetail(); dod.doId = dovm.doNumber; dod.itemId = x.itemNumber; dod.quantity = x.deliverQty; db.DeliveryOrderDetails.Add(dod); } db.SaveChangesAsync(); }
public async Task DisbursementAllocation(List <RetrievalListModel> validatedRetrievalListModels, HttpSessionStateBase session) { validatedRetrievalListModels.Sort(new RetrievalListComparerBySpecial()); Dictionary <string, string> departmentIDs = new Dictionary <string, string>(); string deptID = ""; int specCounter = 0; //Settle all Specials foreach (RetrievalListModel x in validatedRetrievalListModels) { specCounter++; //Disbursement is handled via departments Disbursement tempDisbursement = new Disbursement(); DateTime time = DateTime.Now; string timeStamp = time.ToString("yyyyMMddhhmmssffff"); string disburseID = ""; //only create disbursement if there is an allocation (no allocation no disbursement) if (x.allocateQty != 0) { if (departmentIDs.ContainsKey(x.department)) { disburseID = departmentIDs[x.department]; tempDisbursement.comment = tempDisbursement.comment == null ? "-" + x.requisitionID : tempDisbursement.comment + "-" + x.requisitionID; } else { tempDisbursement.disbursementId = "DIS-" + x.department + "-" + timeStamp; tempDisbursement.comment = x.requisitionID; tempDisbursement.disburseDate = time; tempDisbursement.status = "Awaiting Collection"; string repid = db.DeptCollectionDetails.Find(x.department).representative; tempDisbursement.repID = repid; db.Disbursements.Add(tempDisbursement); departmentIDs.Add(x.department, tempDisbursement.disbursementId); disburseID = tempDisbursement.disbursementId; } } if (x.requisitionID.Contains("Special")) { SpecialRequest tempSpecial = new SpecialRequest(); Requisition tempRequisition = new Requisition(); RequisitionDetail tempRequisitionDet = new RequisitionDetail(); //Fulfilling Special - Special will be removed from the retrieval processes // note Reqid to be lookuped since reqid is specialID for specials string reqID = db.SpecialRequests.Where(z => z.specialId == x.requisitionID).First().requisitionId; tempRequisition = db.Requisitions.Find(reqID); tempSpecial = db.SpecialRequests.Where(y => y.specialId == x.requisitionID && y.itemId == x.itemID).First(); tempSpecial.status = "Disbursed"; //trace back original requisition id to clear special flag tempRequisitionDet = db.RequisitionDetails.Where(z => z.requisitionId == reqID && z.itemId == x.itemID).First(); tempRequisitionDet.remark = tempRequisitionDet.remark == null ? "Fulfilled Qty:" + x.adjQty + " by " + disburseID : tempRequisitionDet.remark + " , Fulfilled Qty:" + x.adjQty + " by " + disburseID; //trace back special requisition to edit status and remark Requisition specialReq = db.Requisitions.Find("Special-" + reqID); specialReq.disbursementId = disburseID; specialReq.remark = specialReq.remark == null ? "Fulfilled by " + disburseID : specialReq.remark + " , Fulfilled by " + disburseID; specialReq.status = "Full Disburse"; specialReq.RequisitionDetails.First().remark = "Fulfilled Qty:" + x.adjQty + " by " + disburseID; //clear requisition if all reqdets are fulfiled if (tempRequisition.RequisitionDetails.Select(z => z.remark.Contains("Fulfilled")).Count() == tempRequisition.RequisitionDetails.Count) { tempRequisition.status = "Full Disburse"; tempRequisition.remark = tempRequisition.remark == null ? "Fully Fulfilled by " + disburseID : tempRequisition.remark + " , Fully Fulfilled by " + disburseID; } else { tempRequisition.status = "Partial Disburse"; tempRequisition.remark = tempRequisition.remark == null ? "Partially Fulfilled by " + disburseID : tempRequisition.remark + " , Fully Fulfilled by " + disburseID; } //Moving stock from inventory to disbursement Inventory invItem = db.Inventories.Where(y => y.itemId == x.itemID).First(); if (x.adjQty != null) { invItem.storeQuantity = invItem.storeQuantity - (int)x.adjQty; invItem.disburseQuantity = invItem.disburseQuantity + (int)x.adjQty; } else { invItem.storeQuantity = invItem.storeQuantity - x.allocateQty; invItem.disburseQuantity = invItem.disburseQuantity + x.allocateQty; } } else { SpecialRequest tempSpecial = new SpecialRequest(); Requisition tempRequisition = new Requisition(); RequisitionDetail tempRequisitionDet = new RequisitionDetail(); //Not special => retrieveQty can be lower than request int delta = 0; tempRequisitionDet = db.RequisitionDetails.Where(z => z.requisitionId == x.requisitionID && z.itemId == x.itemID).First(); tempRequisition = db.Requisitions.Where(z => z.requisitionId == x.requisitionID).First(); //full fulfillment if (tempRequisitionDet.retrieveQty >= tempRequisitionDet.requestQty) { if (tempRequisitionDet.retrieveQty == tempRequisitionDet.requestQty) { tempRequisitionDet.remark = tempRequisitionDet.remark == null ? "Fulfilled normally" : tempRequisitionDet.remark + " , Fulfilled normally"; } else { tempRequisitionDet.remark = tempRequisitionDet.remark == null ? "Over - Fulfilled by" + (tempRequisitionDet.retrieveQty - tempRequisitionDet.requestQty) : tempRequisitionDet.remark + " , Over - Fulfilled by" + (tempRequisitionDet.retrieveQty - tempRequisitionDet.requestQty); } } //adjustment result in partial / zero fulfillment else if (tempRequisitionDet.retrieveQty < tempRequisitionDet.requestQty) { //finds the delta - which goes to the special creation delta = tempRequisitionDet.requestQty - (int)tempRequisitionDet.retrieveQty; //create special for shortfall tempSpecial.itemId = x.itemID; tempSpecial.requestQty = delta; tempSpecial.requisitionId = x.requisitionID; tempSpecial.status = "Special"; tempSpecial.specialId = "Special-" + x.requisitionID + specCounter; tempRequisitionDet.remark = tempRequisitionDet.remark == null ? " Special created (ID:" + tempSpecial.specialId + ") for qty:" + delta : tempRequisitionDet.remark + " Special created (ID:" + tempSpecial.specialId + ") for qty:" + delta; db.SpecialRequests.Add(tempSpecial); //create special requisitions after settling the specials Requisition specialRequisition = new Requisition(); specialRequisition.approvalDate = tempRequisition.approvalDate; specialRequisition.approvalPerson = tempRequisition.approvalPerson; specialRequisition.departmentId = tempRequisition.departmentId; specialRequisition.employee = tempRequisition.employee; specialRequisition.remark = "Special created for " + tempRequisition.requisitionId + " Item : " + tempRequisitionDet.itemId + " Amount : " + delta; specialRequisition.requisitionId = "Special-" + tempRequisition.requisitionId + "-" + tempRequisitionDet.itemId; specialRequisition.requestDate = tempRequisition.requestDate; specialRequisition.status = "Special"; specialRequisition.RequisitionDetails = new List <RequisitionDetail>(); RequisitionDetail specialReqDet = new RequisitionDetail(); specialReqDet.adjustQty = delta; specialReqDet.requestQty = delta; specialReqDet.adjustQty = delta; specialReqDet.itemId = tempRequisitionDet.itemId; specialReqDet.requisitionId = specialRequisition.requisitionId; specialReqDet.remark = "Special"; specialRequisition.RequisitionDetails.Add(specialReqDet); db.Requisitions.Add(specialRequisition); } //adjust inventory as long as not zero retrieval if (tempRequisitionDet.retrieveQty != 0) { Inventory invItem = db.Inventories.Where(y => y.itemId == x.itemID).First(); invItem.storeQuantity = invItem.storeQuantity - (int)x.allocateQty; invItem.disburseQuantity = invItem.disburseQuantity + (int)x.allocateQty; //disbursement will also happen tempRequisition.disbursementId = disburseID; } } } await db.SaveChangesAsync(); //adjust status of Requisition status after adjustments to reqdetail foreach (KeyValuePair <string, string> kvp in departmentIDs) { List <Requisition> reqlist = db.Requisitions.Where(x => x.disbursementId == kvp.Value).ToList(); if (reqlist.Any()) { foreach (Requisition req in reqlist) { if (req.status != "Full Disburse") { if (req.RequisitionDetails.Where(y => y.remark.Contains("Fulfilled")).ToList <RequisitionDetail>().Count == req.RequisitionDetails.Count) { req.status = "Full Disburse"; req.remark = req.remark + " , Fully Fulfilled by " + kvp.Value; } else { req.status = "Partial Disburse"; req.remark = req.remark + " , Partially Fulfilled by " + kvp.Value; } } } } } await db.SaveChangesAsync(); EmailBusinessLogic emailBizLogic = new EmailBusinessLogic(); foreach (KeyValuePair <string, string> kvp in departmentIDs) { deptID = kvp.Key; string linkref = "http://" + ConstantsConfig.linkrefURLPartial + "/Disbursement/DisbursementDetailForRep?disburseID=" + kvp.Value; emailBizLogic.SendEmail("collectDisburse", null, null, deptID, null, linkref); } await Task.CompletedTask; }