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);
}
}
