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