protected void Page_Load(object sender, EventArgs e) { //--------------------------------Getting Disbursement id from session-------------------------------------------------// string id = Convert.ToString(Session["dId"]); int DisbursementID = Convert.ToInt32(id); LblIdD.Text = "DL" + DisbursementID.ToString("0000"); DisbursementList dL = DisbursementLogic.GetDisbursementList(DisbursementID); DisplaySignature(dL.Status, DisbursementID); //------------------------Getting RepresentaTive name------------------------------------------------------------------// detail = DisbursementLogic.GetDisbursementtextDetails(DisbursementID); LblRepresentativeNameD.Text = detail.RepresentativeName; //------------------------------Getting collectin point and date information-----------------------------------------// DateTime collectionDate = (DateTime)detail.CollectionDate; LblCollectionDateD.Text = collectionDate.ToString("dd/MM/yyyy"); cdetail = DisbursementLogic.GetDisbursementCollectionDetails(DisbursementID); LblCollectionPointD.Text = cdetail.CollectionPoint1; //----------------------------------Binding datagridview with disbursement details------------------------------------// detailList = DisbursementLogic.GetDisbursementDetails(DisbursementID); GridViewDisbursementDetails.DataSource = detailList; GridViewDisbursementDetails.DataBind(); }
protected int GetPendingRequestCount() { String dep = DisbursementLogic.GetCurrentDep(); List <RequisitionRecord> list = RequisitionLogic.ListAllRRBySpecificDeptAndStatus(dep, "Pending"); return(list.Count); }
protected void ChangeCollectionPointBtn_Click(object sender, EventArgs e) { try { int newcpid = Int32.Parse(CollectionPointRbtnl.SelectedValue); if (CurrentCollectionPointLbl.Text == DisbursementLogic.GetCurrentCPWithTimeByID(newcpid)) { statusMessage.Text = "The Collection Point is already " + CurrentCollectionPointLbl.Text; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } else { DisbursementLogic.UpdateCollectionPoint(DisbursementLogic.GetCurrentDep(), newcpid); CurrentCollectionPointLbl.Text = DisbursementLogic.GetCurrentCPWithTimeByID(Int32.Parse(DisbursementLogic.GetCurrentCPIDByDep(DisbursementLogic.GetCurrentDep()))); statusMessage.Text = "The Collection Point has been updated to " + CurrentCollectionPointLbl.Text; statusMessage.Visible = true; statusMessage.ForeColor = Color.Green; ChangeCollectionPointBtn.Enabled = true; } } catch { statusMessage.Text = "Please choose a collection point."; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } }
private void RetrieveDisbursementData() { List <CollectionPoint> pointList = DisbursementLogic.ListCollectionPoints(); int collectionId = DisbursementLogic.GetListofDepartments().Where(x => x.DeptID == DdlDept.SelectedValue).Select(x => x.CollectionPointID).FirstOrDefault(); LblCollectPoint.Text = pointList.Where(x => x.CollectionPointID == collectionId).Select(x => x.CollectionPoint1).FirstOrDefault(); LblDeptRep.Text = DisbursementLogic.GetDeptRepFullName(DdlDept.SelectedValue); string deptId = DdlDept.SelectedValue; List <InventoryRetrievalList> rList = InventoryLogic.GetListOfInventoryRetrival(deptId); if (rList.Count > 0) { GridViewDisbList.DataSource = rList; GridViewDisbList.DataBind(); GridViewDisbList.Visible = true; BtnCreateDis.Visible = true; statusMessage.Text = string.Empty; } else { GridViewDisbList.Visible = false; BtnCreateDis.Visible = false; statusMessage.ForeColor = Color.Red; statusMessage.Text = "No Disbursement Found for " + DdlDept.SelectedItem; } }
protected void BindDdl() { EmployeesDdl.DataSource = DisbursementLogic.GetAllEmployeeFullNamesFromDept(DisbursementLogic.GetCurrentDep()); EmployeesDdl.DataBind(); CalStartAddDelegate.SelectedDate = DateTime.Today; CalEndAddDelegate.SelectedDate = DateTime.Today; }
//-------------------------Filter by rep------------------------------------------------------------------------------// protected void BtnFindrep_Click(object sender, EventArgs e) { dsList = DisbursementLogic.GetDisbursementByRep(TxtRep.Text); GridViewDisbursement.DataSource = dsList; GridViewDisbursement.DataBind(); LblMsg.Visible = false; }
protected void BtnAddDept_Click(object sender, EventArgs e) { statusMessage.Visible = false; List <Department> dList = DisbursementLogic.GetListofDepartments(); string deptID = DdlDept.SelectedValue; if (deptID == "All") { BindGrid(dList); } else { dList = (List <Department>)Session["DepartmentList"]; Department selectItem = DisbursementLogic.GetListofDepartments().Where(x => x.DeptID == deptID).FirstOrDefault(); if (!CheckIfDepartmentNotExist(dList, selectItem)) { statusMessage.Text = "Department Already Added to List"; statusMessage.ForeColor = System.Drawing.Color.Red; statusMessage.Visible = true; return; } dList.Add(selectItem); Session["DepartmentList"] = dList; BindGrid(dList); } }
private void BindLabels(int disbursementId) { DisbursementList dL = DisbursementLogic.GetDisbursementList(disbursementId); string status = dL.Status; LblDisbId.Text = "DL" + disbursementId.ToString("0000"); LblColDate.Text = ((DateTime)dL.CollectionDate).ToString("d"); LblCollectPoint.Text = DisbursementLogic.GetCurrentCPWithTimeByID(dL.CollectionPointID); LblDeptRep.Text = dL.RepresentativeName; LblDeptName.Text = DisbursementLogic.GetListofDepartments().Where(x => x.DeptID == dL.DepartmentID).Select(x => x.DepartmentName).FirstOrDefault(); LblStatus.Text = dL.Status; switch (status) { case ("Collected"): { BtnCancelDis.Visible = false; LblCollectedBy.Visible = true; ImgSignature.ImageUrl = "http://localhost/Team12_SSIS/Images/" + "DL" + dL.DisbursementID + ".jpg"; ImgSignature.Visible = true; break; } case ("Pending Collection"): BtnCancelDis.Visible = true; break; default: BtnCancelDis.Visible = false; break; } }
public List <WCF_DisbursementListDetail> GetDisbursementListDetails(int disbursementId, string token) { //Check if user is authorizated to use this method. If is not authorized, it will return a json with -1 in the primary key if (!IsAuthanticateUser(token)) { List <WCF_DisbursementListDetail> wcf_UnAuthObj = new List <WCF_DisbursementListDetail>(); WCF_DisbursementListDetail wcfUnAuth = new WCF_DisbursementListDetail(); wcfUnAuth.DisbursementID = -1; wcf_UnAuthObj.Add(wcfUnAuth); return(wcf_UnAuthObj); } List <DisbursementListDetail> ddList = DisbursementLogic.GetDisbursementListDetails(disbursementId); List <WCF_DisbursementListDetail> wcf_ddlist = new List <WCF_DisbursementListDetail>(); foreach (DisbursementListDetail dd in ddList) { WCF_DisbursementListDetail wcfDd = new WCF_DisbursementListDetail(); wcfDd.ID = dd.ID; wcfDd.DisbursementID = dd.DisbursementID; wcfDd.ItemID = dd.ItemID; wcfDd.ActualQuantity = (int)dd.ActualQuantity; wcfDd.QuantityRequested = (int)dd.QuantityRequested; wcfDd.QuantityCollected = (int)dd.QuantityCollected; wcfDd.UOM = dd.UOM; wcfDd.Remarks = dd.Remarks == null ? " " : dd.Remarks; wcf_ddlist.Add(wcfDd); } return(wcf_ddlist); }
public List <WCF_DisbursementList> GetDisbursementList(string token) { //Check if user is authorizated to use this method. If is not authorized, it will return a json with -1 in the primary key if (!IsAuthanticateUser(token)) { List <WCF_DisbursementList> wcf_UnAuthObj = new List <WCF_DisbursementList>(); WCF_DisbursementList wcfUnAuth = new WCF_DisbursementList(); wcfUnAuth.DisbursementID = -1; wcf_UnAuthObj.Add(wcfUnAuth); return(wcf_UnAuthObj); } List <DisbursementList> dlist = DisbursementLogic.GetDisbursementList(); List <WCF_DisbursementList> wcf_Dlist = new List <WCF_DisbursementList>(); foreach (DisbursementList d in dlist) { WCF_DisbursementList wcfD = new WCF_DisbursementList(); wcfD.DisbursementID = d.DisbursementID; wcfD.DepartmentID = d.DepartmentID; wcfD.CollectionPointID = d.CollectionPointID; wcfD.CollectionDate = ((DateTime)d.CollectionDate).ToString("d"); wcfD.RepresentativeName = d.RepresentativeName; wcfD.Status = d.Status; wcfD.WCF_DisbursementListDetail = GetDisbursementListDetails(d.DisbursementID, internalSecertKey); wcf_Dlist.Add(wcfD); } return(wcf_Dlist); }
private void BindDeptDdl() { List <Department> deptList = DisbursementLogic.GetListofDepartments(); DdlDept.DataSource = deptList; DdlDept.DataBind(); DdlDept.SelectedIndex = 0; }
protected void BtnCancelDis_Click(object sender, EventArgs e) { int disbursementId = (int)Session["DisbId"]; DisbursementLogic.UpdateDisbursementStatus(disbursementId, "Cancelled"); statusMessage.ForeColor = Color.Green; statusMessage.Text = "Disbursement List DL" + disbursementId.ToString("0000") + " Cancelled."; BindLabels(disbursementId); }
protected void Page_Load(object sender, EventArgs e) { statusMessage = this.Master.FindControl("LblStatus") as Label; if (!IsPostBack) { statusMessage.Visible = false; //Show current rep CurrentRepLbl.Text = DisbursementLogic.GetDeptRepFullName(DisbursementLogic.GetCurrentDep()); BindDdl(); } }
private void BindGrid(int disbursementId) { List <DisbursementListDetail> dList = DisbursementLogic.GetDisbursementListDetails(disbursementId); GridViewDisbList.DataSource = dList; GridViewDisbList.DataBind(); BindLabels(disbursementId); GridViewDisbList.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { uList = DisbursementLogic.GetDisbursementForm(); var lastNlist = uList.Skip(Math.Max(0, uList.Count() - 10)).Take(10);; GridViewDisbursement.DataSource = lastNlist; GridViewDisbursement.DataBind(); LblMsg.Visible = false; } }
void BindControls() { List <Department> dList = DisbursementLogic.GetListofDepartments(); Department selectAll = new Department(); selectAll.DepartmentName = "All"; selectAll.DeptID = "All"; dList.Add(selectAll); DdlDept.DataSource = dList; DdlDept.DataBind(); DdlDept.SelectedIndex = dList.Count() - 1; }
//---------- Lim Chang Siang's Code Start Here ------------------// public List <string> GetUsersFromDept(string dept, string token) { //Check if user is authorizated to use this method. If is not authorized, it will return a json with -1 in the primary key if (!IsAuthanticateUser(token)) { List <string> wcf_UnAuthObj = new List <string>(); string wcfUnAuth = "-1"; wcf_UnAuthObj.Add(wcfUnAuth); return(wcf_UnAuthObj); } return(DisbursementLogic.GetFullNamesFromDept(dept)); }
public void TestGetCollectionPointNameAndId() { //This is english dept string currentDept = "ENGL"; //This should show the current CP Id - currently is 6. string currentCPByDept = DisbursementLogic.GetCurrentCPIDByDep(currentDept); Console.WriteLine(currentCPByDept); //This should show University Hospital, 11A.M string currentCPNameById = DisbursementLogic.GetCurrentCPWithTimeByID(Int32.Parse(currentCPByDept)); Console.WriteLine(currentCPNameById); }
protected void ShowCurrentDelegate() { MultiView1.ActiveViewIndex = 0; string currentdep = DisbursementLogic.GetCurrentDep(); DDelegateDetail currentdelegate = RequisitionLogic.GetLatestDelegate(currentdep); string currentdelegatename = RequisitionLogic.GetDelegateName(currentdelegate); DateTime currentdelegatestartdate = RequisitionLogic.GetDelegateStartDate(currentdelegate); DateTime currentdelegateenddate = RequisitionLogic.GetDelegateEndDate(currentdelegate); LblCurrentDelegate.Text = currentdelegatename; LblCurrentDelStartDate.Text = currentdelegatestartdate.ToShortDateString(); LblCurrentDelEndDate.Text = currentdelegateenddate.ToShortDateString(); }
//-------------------------filter by date range-----------------------------------------------------------------------// protected void BtnFindDate_Click(object sender, EventArgs e) { DateTime d1 = DateTime.ParseExact(Request.Form["datepicker"], "MM/dd/yyyy", CultureInfo.InvariantCulture); DateTime d2 = DateTime.ParseExact(Request.Form["datepicker2"], "MM/dd/yyyy", CultureInfo.InvariantCulture); string d0 = d1.ToString("yyyy-MM-dd"); string d = d2.ToString("yyyy-MM-dd"); dsList = DisbursementLogic.GetDisbursementByDate(d1, d2); GridViewDisbursement.DataSource = dsList; GridViewDisbursement.DataBind(); LblMsg.Visible = true; LblMsg.Text = "* Showing disbursement list " + "within the date range " + d0 + " and " + d; }
protected void CancelDelegationBtn_Click(object sender, EventArgs e) { string currentdep = DisbursementLogic.GetCurrentDep(); DDelegateDetail currentdelegate = RequisitionLogic.GetLatestDelegate(currentdep); string fullname = RequisitionLogic.GetDelegateName(currentdelegate); RequisitionLogic.CancelDelegate(currentdelegate); MultiView1.ActiveViewIndex = 2; BindDdl(); statusMessage.Text = fullname + "'s delegation has been cancelled."; statusMessage.Visible = true; statusMessage.ForeColor = Color.Green; }
public void UpdateDisbursementStatus(WCF_DisbursementList disbursementList, string token) { //Check if user is authorizated to use this method. If is not authorized, it will return a json with -1 in the primary key if (!IsAuthanticateUser(token)) { return; } DisbursementLogic.UpdateDisbursementStatus(disbursementList.DisbursementID, disbursementList.Status); DisbursementLogic dl = new DisbursementLogic(); foreach (WCF_DisbursementListDetail d in disbursementList.WCF_DisbursementListDetail) { dl.UpdateDisbursementListDetails(d.ID, d.QuantityCollected, d.Remarks); } }
protected void Page_Load(object sender, EventArgs e) { statusMessage = Master.FindControl("Lblstatus") as Label; if (!IsPostBack) { statusMessage.Visible = false; CollectionPointRbtnl.DataSource = DisbursementLogic.ListCollectionPoints(); CollectionPointRbtnl.DataTextField = "CollectionPoint1"; CollectionPointRbtnl.DataValueField = "CollectionPointID"; CollectionPointRbtnl.DataBind(); CurrentCollectionPointLbl.Text = DisbursementLogic.GetCurrentCPWithTimeByID(Int32.Parse(DisbursementLogic.GetCurrentCPIDByDep(DisbursementLogic.GetCurrentDep()))); } //else // ChangedLbl.Visible = true; }
protected void AssignRepBtn_Click(object sender, EventArgs e) { //Getting new representative name from dropdown list string newrepfullname = EmployeesDdl.SelectedValue; //Update new rep and delete old rep by passing in new representative name and current department DisbursementLogic.UpdateDeptRep(newrepfullname, DisbursementLogic.GetCurrentDep()); //Update current representative CurrentRepLbl.Text = DisbursementLogic.GetDeptRepFullName(DisbursementLogic.GetCurrentDep()); statusMessage.Text = newrepfullname + " has been assigned as the new representative."; statusMessage.Visible = true; statusMessage.ForeColor = Color.Green; BindDdl(); AssignRepBtn.Enabled = true; }
protected void BtnSearch_Click(object sender, EventArgs e) { string status = DdlStatus.SelectedValue; int colPointId = int.Parse(DdlColPoint.SelectedValue); DateTime collectionDate; List <DisbursementList> dList = status == "All" ? DisbursementLogic.GetListOfDisbursements() : DisbursementLogic.GetListOfDisbursements("Status", status); dList = colPointId == -1 ? dList : dList.Where(x => x.CollectionPointID == colPointId).ToList(); if ((DateTime.TryParseExact(Request.Form["datepicker"], "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out collectionDate))) { dList = dList.Where(x => x.CollectionDate == collectionDate).ToList(); } GridViewDisbList.DataSource = dList; GridViewDisbList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { statusMessage = this.Master.FindControl("LblStatus") as Label; if (!IsPostBack) { statusMessage.Visible = false; if (RequisitionLogic.HasDelegate(DisbursementLogic.GetCurrentDep())) { ShowCurrentDelegate(); } else { MultiView1.ActiveViewIndex = 2; BindDdl(); } } }
protected void BtnRetrieve_Click(object sender, EventArgs e) { string dept = DdlDept.SelectedValue; List <DisbursementList> dList; switch (dept) { case ("All"): dList = DisbursementLogic.GetListOfDisbursements(); break; default: dList = DisbursementLogic.GetListOfDisbursements("DepartmentID", dept); break; } GridViewDisbList.DataSource = dList; GridViewDisbList.DataBind(); }
protected void RemoveDeptHeadRoleFromUserWithDateCheck(object sender, System.Timers.ElapsedEventArgs e) { List <Department> depwithdelegateslist = new List <Department>(); List <Department> deplist = new List <Department>(); List <DDelegateDetail> delegatelist = new List <DDelegateDetail>(); List <DateTime> startdates = new List <DateTime>(); List <DateTime> enddates = new List <DateTime>(); using (SA45Team12AD entities = new SA45Team12AD()) { //get list of current delegates delegatelist = entities.DDelegateDetails.ToList(); deplist = entities.Departments.ToList(); foreach (Department u in deplist) { if (u.HasDelegate == 1) { depwithdelegateslist.Add(u); } } if (depwithdelegateslist != null) { foreach (Department u in depwithdelegateslist) { delegatelist.Add(RequisitionLogic.GetLatestDelegate(u.DeptID)); } foreach (DDelegateDetail u in delegatelist) { //get username for delegates string username = DisbursementLogic.GetUserName(u.DepartmentHeadDelegate, u.DepartmentID); //remove depthead role from user after checking period if (DateTime.Today > u.EndDate && Roles.IsUserInRole(username, "HOD")) { RequisitionLogic.RemoveDeptHeadRoleFromUser(u.DepartmentHeadDelegate, u.DepartmentID); Department department = entities.Departments.Where(x => x.DeptID == u.DepartmentID).First(); department.HasDelegate = 0; entities.SaveChanges(); } } } } }
protected void BtnEdit_Click(object sender, EventArgs e) { statusMessage.Visible = false; MultiView1.ActiveViewIndex = 1; string currentdep = DisbursementLogic.GetCurrentDep(); DDelegateDetail currentdelegate = RequisitionLogic.GetLatestDelegate(currentdep); string currentdelegatename = RequisitionLogic.GetDelegateName(currentdelegate); DateTime currentdelegatestartdate = RequisitionLogic.GetDelegateStartDate(currentdelegate); DateTime currentdelegateenddate = RequisitionLogic.GetDelegateEndDate(currentdelegate); CalStartEditDelegate.TodaysDate = currentdelegatestartdate; CalEndEditDelegate.TodaysDate = currentdelegateenddate; CalStartEditDelegate.SelectedDate = CalStartEditDelegate.TodaysDate; CalEndEditDelegate.SelectedDate = CalEndEditDelegate.TodaysDate; LblCurrentDelegateView2.Text = currentdelegatename; if (CalStartEditDelegate.SelectedDate < DateTime.Today) { CalStartEditDelegate.Enabled = false; } }
protected void GridViewDisbList_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow && (DisbursementList)e.Row.DataItem != null) { DisbursementList dL = (DisbursementList)e.Row.DataItem; string dept = DisbursementLogic.GetListofDepartments().Where(x => x.DeptID == dL.DepartmentID).Select(x => x.DepartmentName).FirstOrDefault(); string colPoint = DisbursementLogic.GetCurrentCPWithTimeByID(dL.CollectionPointID); Label lblDept = e.Row.FindControl("LblDept") as Label; if (lblDept != null) { lblDept.Text = dept; } Label lblColPoint = e.Row.FindControl("LblColPoint") as Label; if (lblColPoint != null) { lblColPoint.Text = colPoint; } } }