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