public ActionResult ViewDisbursementList() { string username = Session["username"].ToString(); EmployeeDAO e = new EmployeeDAO(); int clerk_id = e.GetEmployeeByUsername(username).Id; DisbursementDAO d = new DisbursementDAO(); List <DisbursementVM> list = d.WebGetDisbursementsByClerk(clerk_id); CollectionPointDAO c = new CollectionPointDAO(); List <CollectionPoint> c_list = c.GetCollectionPointsByClerk(clerk_id); if (list != null) { foreach (DisbursementVM row in list) { foreach (CollectionPoint col in c_list) { if (col.Id == row.CollectionPointID) { row.CollectionPointName = col.Name; } } } } ViewData["c_list"] = c_list; return(View(list)); }
/***********************this confirm button simulates the scene after scanning QRcode (only for Test)**********************************/ /**********************To confirm specified dept disbursement**************************************************************/ protected void Button3_Click(object sender, EventArgs e) { int disburseID = Convert.ToInt32(ViewState["disburseID"]); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('you are generate the Disbursement " + disburseID + " ?')", true); //here should send message box yes or no DisbursementDAO disDAO = new DisbursementDAO(); //disburList ConfirmBtn.Enabled = false; disDAO.updateDisbursementStatus(Convert.ToInt32(ViewState["disburseID"]), "Completed"); disburseGridView.SelectedIndex = -1; disburseBindGrid(); disburseUpdatePanel.Update(); disburseItemGridView.DataSource = null; disburseItemGridView.DataBind(); //send email and notification to rep SA45_Team09_LogicUEntities context = new SA45_Team09_LogicUEntities(); string repID = context.Departments.Where(x => x.deptID == deptid).Select(x => x.repStaffID).ToList().First(); string repName = context.DeptStaffs.Where(x => x.staffID == repID).Select(x => x.staffName).ToList().First(); string confirmDate = DateTime.Now.ToShortDateString(); NotificationDAO nDAO = new NotificationDAO(); nDAO.addDeptNotification(repID, "Disbursement " + disburseID + " is confirmed on " + confirmDate, DateTime.Now); Email email = new Email(); email.sendConfirmedDisbursementEmailToRep(repName, confirmDate, disburseID.ToString()); }
public ActionResult Index(List <DisbursementViewModel> model) { List <Department> deps = DepartmentDAO.GetDepartmentsToDisburse(); ViewBag.depIdList = new SelectList(deps, nameof(Department.departmentId), nameof(Department.departmentName)); if (model != null && model.Count > 0) { if (model[0].departmentId != null) { ViewBag.depInfo = DepartmentDAO.GetDepartmentInfo(model[0].departmentId); } } if (!ModelState.IsValid) { return(View(model)); } bool bRes = DisbursementDAO.ConfirmDisbursement(model); //ModelState.Clear(); if (bRes) { return(RedirectToAction("Index")); } else { return(View("~/Views/Shared/Error.cshtml")); } }
public MResponse ApproveDisbursement(string deptId) { DisbursementDAO dao = new DisbursementDAO(); return(new MResponse() { Success = dao.ApproveDisbursement(deptId) }); }
public MResponse GetDisbursements(int clerkId) { List <MDisbursement> retrievals = new DisbursementDAO().GetDisbursementsByClerk(clerkId); return(new MResponseList <MDisbursement>() { ResList = retrievals }); }
protected void disburseItemBindGrid(int disburseID) { DisbursementDAO disDAO = new DisbursementDAO(); List <DisbursementCart> disburseItems = disDAO.getDisbursementItemByDisID(disburseID); ViewState["list"] = disburseItems; disburseItemGridView.DataSource = disburseItems; disburseItemGridView.DataBind(); }
public MResponse UpdateDisbursementInfo(int clerkId, string deptId, List <ItemRequest> items) { bool success = new DisbursementDAO().UpdateDisbursement(deptId, clerkId, items); return(new MResponseListAndObj <ItemRequest, CollectionPoint>() { Success = success }); }
public DepartmentRepresentativeController() { _disbursementDAO = new DisbursementDAO(); _employeeDAO = new EmployeeDAO(); _disbursementItemDAO = new DisbursementItemDAO(); _collectionPointDAO = new CollectionPointDAO(); _departmentDAO = new DepartmentDAO(); _notificationChannelDAO = new NotificationChannelDAO(); }
public HomeController() { _employeeDAO = new EmployeeDAO(); _collectionPointDAO = new CollectionPointDAO(); _notificationChannelDAO = new NotificationChannelDAO(); _requisitionDAO = new RequisitionDAO(); _delegationDAO = new DelegationDAO(); _departmentDAO = new DepartmentDAO(); _disbursementDAO = new DisbursementDAO(); _disbursementItemDAO = new DisbursementItemDAO(); }
public ActionResult ApproveDisbursement() { OutstandingDAO outstandingDAO = new OutstandingDAO(); string deptId = GetDeptId(Session["username"].ToString()); //foreach(var ir in itemRequestDAO.GetDisburseItems(deptId)) //{ // outstandingDAO.AddItemRequest(ir); // requestDAO.UpdateDisbursedDate(ir); //} DisbursementDAO dao = new DisbursementDAO(); dao.ApproveDisbursement(deptId); return(RedirectToAction("Disbursement")); }
public StoreManagerController() { _itemDAO = new ItemDAO(); _supplieritemDAO = new SupplierItemDAO(); _purchaseOrderDAO = new PurchaseOrderDAO(); _purchaseOrderDetailsDAO = new PurchaseOrderDetailsDAO(); _disbursementDAO = new DisbursementDAO(); _disbursementItemDAO = new DisbursementItemDAO(); _stockRecordDAO = new StockRecordDAO(); _notificationChannelDAO = new NotificationChannelDAO(); _requisitionDAO = new RequisitionDAO(); _requisitionItemDAO = new RequisitionItemDAO(); _categoryDAO = new CategoryDAO(); _departmentDAO = new DepartmentDAO(); }
public List <WCFDisbursementCart> getDisbursementItemByDisID(string disID_s) { int disID = Convert.ToInt32(disID_s); List <WCFDisbursementCart> ldiscart_wcf = new List <WCFDisbursementCart>(); DisbursementDAO disDAO = new DisbursementDAO(); List <DisbursementCart> ldc = new List <DisbursementCart>(); ldc = disDAO.getDisbursementItemByDisID(disID); foreach (var i in ldc) { WCFDisbursementCart wcfdiscart = new WCFDisbursementCart(i.ID, i.Description, i.Expected, i.Actual); ldiscart_wcf.Add(wcfdiscart); } return(ldiscart_wcf); }
public int confirmDisbursement(confirm_JSON confirm_json, string disID_url) { int disID = Int32.Parse(disID_url); string date_s = confirm_json.Scan_date;//put here in case string staffID = confirm_json.LoginID; DisbursementDAO disDAO = new DisbursementDAO(); try { disDAO.updateDisbursementStatus(disID, "Completed"); return(1); } catch (Exception e) { return(0); } }
public ActionResult EditDisbursementList() { string deptId = ""; List <ItemRequest> new_list = new List <ItemRequest>(); DisbursementDAO disbursementDAO = new DisbursementDAO(); foreach (string key in Request.Form.AllKeys) { if (Convert.ToString(key) == "deptId") { deptId = Convert.ToString(Request[key]); } else { ItemRequest item = new ItemRequest(); item.ItemId = Convert.ToString(key); item.ActualQty = Convert.ToInt32(Request[key]); new_list.Add(item); } } List <ItemRequest> old_list = disbursementDAO.GetDisburseItemsForRep(deptId); List <ItemRequest> list = new List <ItemRequest>(); foreach (var item in new_list) { foreach (var row in old_list) { if (item.ItemId == row.ItemId) { if (row.ActualQty - item.ActualQty != 0) { item.ActualQty = row.ActualQty - item.ActualQty; list.Add(item); } } } } int clerkId = (int)Session["userid"]; disbursementDAO.UpdateDisbursement(deptId, clerkId, list); return(RedirectToAction("ViewDisbursementList", "StoreClerk")); }
public MResponse GetDisbursementInfo(string deptId) { CollectionPoint point = new CollectionPointDAO().GetCollectionPointByDeptID(deptId); List <ItemRequest> list = new DisbursementDAO().GetDisburseItemsForRep(deptId); //bool showApproveButton = false; //if (list.Count() > 0) //{ // showApproveButton = DateTime.Today.DayOfWeek == DayOfWeek.Monday; //} return(new MResponseListAndObj <ItemRequest, CollectionPoint>() { ResObj = point, ResList = list, Success = true }); }
public ActionResult EditDisbursementList(string dept_id, string dept_name) { DisbursementDAO disbursementDAO = new DisbursementDAO(); CollectionPointDAO collectionPointDAO = new CollectionPointDAO(); CollectionPoint collectionPoint = collectionPointDAO.GetCollectionPointByDeptID(dept_id); List <ItemRequest> itemList = disbursementDAO.GetDisburseItemsForRep(dept_id); DisbursementVM disbursement = new DisbursementVM(); disbursement.DeptName = dept_name; disbursement.DeptId = dept_id; disbursement.CollectionPointName = collectionPoint.Name; disbursement.ItemList = itemList; return(View(disbursement)); }
// GET: Disbursement public ActionResult Index(string depId) { List <Department> deps = DepartmentDAO.GetDepartmentsToDisburse(); ViewBag.depIdList = new SelectList(deps, nameof(Department.departmentId), nameof(Department.departmentName), depId); List <DisbursementViewModel> model = new List <DisbursementViewModel>(); if (depId != null) { model = DisbursementDAO.GetDisbursement(depId); ViewBag.depInfo = DepartmentDAO.GetDepartmentInfo(depId); } return(View(model)); }
//private readonly NotificationChannelDAO _notificationChannelDAO; //private readonly EmployeeDAO _employeeDAO; public StoreClerkController() { this._disbursementDAO = new DisbursementDAO(); this._requisitionDAO = new RequisitionDAO(); this._requisitionItemDAO = new RequisitionItemDAO(); this._stockRecordDAO = new StockRecordDAO(); this._disbursementItemDAO = new DisbursementItemDAO(); this._purchaseOrderDAO = new PurchaseOrderDAO(); this._itemDAO = new ItemDAO(); this._statusDAO = new StatusDAO(); this._purchaseOrderDetailsDAO = new PurchaseOrderDetailsDAO(); this._employeeDAO = new EmployeeDAO(); this._collectionpointDAO = new CollectionPointDAO(); this._notificationChannelDAO = new NotificationChannelDAO(); this._notificationDAO = new NotificationDAO(); this._supplierItemDAO = new SupplierItemDAO(); //this._notificationChannelDAO = new NotificationChannelDAO(); //this._employeeDAO = new EmployeeDAO(); }
protected void disburseItemGridView_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = disburseItemGridView.Rows[e.RowIndex]; int actual = Int32.Parse((row.FindControl("Actual") as TextBox).Text); int expected = Int32.Parse((row.FindControl("Expected") as Label).Text); string itemID = (row.FindControl("itemIDLabel") as Label).Text; if (actual > expected) { disburseItemGridView.EditIndex = -1; disburseItemGridView.DataSource = (List <DisbursementCart>)ViewState["list"]; disburseItemGridView.DataBind(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('The quantity you entered cannot larger than needed amount!')", true); return; } if (Convert.ToInt32(ViewState["originQty"]) == actual) { disburseItemGridView.EditIndex = -1; disburseItemGridView.DataSource = (List <DisbursementCart>)ViewState["list"]; disburseItemGridView.DataBind(); } else { DisbursementDAO disDAO = new DisbursementDAO(); disDAO.savingActualQty(Convert.ToInt32(ViewState["disburseID"]), itemID, actual); disburseItemGridView.EditIndex = -1; List <DisbursementCart> ldc = (List <DisbursementCart>)ViewState["list"]; foreach (var i in ldc) { if (i.ID == itemID) { i.Actual = actual; break; } } disburseItemGridView.DataSource = (List <DisbursementCart>)ViewState["list"]; disburseItemGridView.DataBind(); } }
public List <WCFDisbursement> getDisbursementByDeptID(string deptID) { List <WCFDisbursement> ldis_wcf = new List <WCFDisbursement>(); DisbursementDAO disDAO = new DisbursementDAO(); List <Disbursement> ldis = new List <Disbursement>(); ldis = disDAO.getAwaitingDisbursementListByDeptID(deptID); foreach (var i in ldis)//add in disbursement list { WCFDisbursement wcfdis = new WCFDisbursement { DisID = i.disbursementID, DeptID = i.deptID, StoreStaffID = i.storeStaffID, DisDate = i.disburseDate, Status = i.status }; ldis_wcf.Add(wcfdis); } return(ldis_wcf); }
public List <DisbursementViewModel> GetDisbursement(string departmentId) { List <DisbursementViewModel> myModels = DisbursementDAO.GetDisbursement(departmentId); return(myModels); }
public bool ConfirmDisbursement([FromBody] List <DisbursementViewModel> myModels) { bool bRes = DisbursementDAO.ConfirmDisbursement(myModels); return(bRes); }