public bool CreateRequisition(Requisition modelReq) { bool isSuccessful = false; LogicUniStoreModel dbContext; try { dbContext = new LogicUniStoreModel(); dbContext.Database.Connection.Open(); using (var txn = dbContext.Database.BeginTransaction()) { //Create Adjustment and Items RequisitionDao dao = new RequisitionDao(dbContext); dao.Create(modelReq); RequisitionItemDao itemDao = new RequisitionItemDao(dbContext); foreach (RequisitionItem item in modelReq.RequisitionItems) { itemDao.addRequisitionItem(item); } txn.Commit(); isSuccessful = true; } dbContext.Database.Connection.Close(); } catch (Exception ex) { // throw; } return(isSuccessful); }
public ProcessReqController() { LogicUniStoreModel db = new LogicUniStoreModel(); RequisitionDao = new RequisitionDao(db); StockCardDao = new StockCardDao(db); RequisitionItemDao = new RequisitionItemDao(db); mainList = new Dictionary <Requisition, double>(); LockedItem = new Dictionary <int, int>(); }
public List <Requisition> GetRequisitionsByStatus(string status) { List <Requisition> lstReqs = null; RequisitionStatus val; if (Enum.TryParse(status, true, out val)) { lstReqs = new RequisitionDao().GetRequisitionListByStatus(val); } return(lstReqs); }
public CancelUpdatePendingApprovalController() { RequisitionDao = new RequisitionDao(); RequisitionItemDao = new RequisitionItemDao(); ItemDao = new ItemDao(); }
public void reapplyRequisition(int reqId, String remark, DateTime reqDate) { RequisitionDao.reapplyRequisition(reqId, remark, reqDate); }
public ReapplyRejectedController() { RequisitionDao = new RequisitionDao(); RequisitionItemDao = new RequisitionItemDao(); ItemDao = new ItemDao(); }
public ApproveRejectReqController() { RequisitionDao = new RequisitionDao(); }
public List <Requisition> GetRequestedRequisitionListHod(int depId) { return(RequisitionDao.GetRequestedRequisitionListHod(depId)); }
public List <RequisitionItem> getRequisitionItemList(int requisitionId) { return(RequisitionDao.GetRequisitionItemList(requisitionId)); }
public List <Requisition> GetApprovedRequisition(int depId) { return(RequisitionDao.GetApprovedRequisitionList(depId)); }
public CancelUpdateUnallocatedController() { RequisitionDao = new RequisitionDao(); riDao = new RequisitionItemDao(); iDao = new ItemDao(); }
public int GetApprovedRequistionCount() { return(RequisitionDao.GetApprovedRequisitionCount()); }
public List <RequisitionItem> GetRequisitionItems(int requisitionID) { return(RequisitionDao.GetRequisitionItemList(requisitionID)); }
//public Dictionary<Requisition, double> GetMainProcessReqList() //{ // LogicUniStoreModel db = new LogicUniStoreModel(); // List<Requisition> rList = db.Requisitions.Where(r => r.Status == RequisitionStatus.Approved.ToString()).ToList(); // foreach (var requisition in rList) // { // if (mainList.ContainsKey(requisition)) // { // continue; // } // int? unfullfilledItem = 0; // double percentage = 100; // // int countReqItem = requisition.RequisitionItems.Count(); // double progrssMeter = 0.0; // foreach (RequisitionItem item in requisition.RequisitionItems) // { // RequisitionItem rItem = RequisitionItemDao.db.RequisitionItems.Find(item.ReqItemID); // if (!lockedItemsCountForProcess.ContainsKey(rItem.SupplierItem.ItemID)) // { // lockedItemsCountForProcess.Add(rItem.SupplierItem.ItemID, 0); // } // int actualQuantityInStock = (StockCardDao.GetProductCountInStock(rItem.SupplierItem.ItemID) - lockedItemsCountForProcess[rItem.SupplierItem.ItemID]); // if ((actualQuantityInStock - rItem.NeededQuantity) >= 0) // { // lockedItemsCountForProcess[rItem.SupplierItem.ItemID] += rItem.NeededQuantity.Value; // rItem.ApprovedQuantity = rItem.NeededQuantity; // progrssMeter += 1; // } // else // { // lockedItemsCountForProcess[rItem.SupplierItem.ItemID] += actualQuantityInStock; // rItem.ApprovedQuantity = actualQuantityInStock; // unfullfilledItem += 1; // progrssMeter += (double)rItem.ApprovedQuantity / (double)rItem.NeededQuantity; // } // } // db.SaveChanges(); // //if (unfullfilledItem.Value == 0) // //{ // // percentage = 100; // //} // //else // //{ // // double value = (requisition.RequisitionItems.Count - Convert.ToDouble(unfullfilledItem)) / requisition.RequisitionItems.Count; // // percentage = value * 100; // //} // // mainList.Add(requisition, percentage); // mainList.Add(requisition, (progrssMeter / requisition.RequisitionItems.Count) * 100); // } // return mainList; //} internal Requisition GetRequisition(int requisitonID) { return(RequisitionDao.Find(requisitonID)); }
public List <Requisition> getRequestedRequisition(int requesterId) { return(RequisitionDao.GetRequestedRequisitionList(requesterId)); }
public void approveRequisition(int requisitionId, String remark) { RequisitionDao.approveRequisition(requisitionId, remark); }
public bool removeRequisition(int reqId) { return(RequisitionDao.Remove(reqId)); }
public void rejectRequisition(int requisitionId, String remark) { RequisitionDao.rejectRequisition(requisitionId, remark); }
public void updateRemark(int reqId, String remark) { RequisitionDao.updateRemark(reqId, remark); }
public RequestHistoryController() { RequisitionDao = new RequisitionDao(); }