private void SetEmployeesPayroll()
{
if (Session["eprEmployeeIds"] != null && Session["eprCenterNo"] != null && Session["eprFromDate"] != null && Session["eprToDate"] != null && Session["eprRangeBy"] != null && Session["eprGroupByWeekend"] != null)
{
lblInvalidInput.Visible = false;
SygmaCenterNo = Convert.ToInt32(Session["eprCenterNo"]);
EmployeeIds = Session["eprEmployeeIds"].ToString();
RangeBy = Session["eprRangeBy"].ToString();
FromDate = Session["eprFromDate"].ToString();
ToDate = Session["eprToDate"].ToString();
isGroupByWeekending = Convert.ToBoolean(Session["eprGroupByWeekend"]);
isWeekendingRange = (RangeBy == "Week Ending") ? 1 : 0;
//dsEmployeesPayment = ATMDB.GetDataSet("up_p_EmployeesPaymentReport", 30, "538,2798,525,1593", "2014-08-09");
DataSet dsConfig = ATMDB.GetDataSet("up_p_getReportConfig", 11);
string storedproc = dsConfig.Tables[0].Rows[0][0].ToString();
dsEmployeesPayment = ATMDB.GetDataSet(storedproc, SygmaCenterNo, EmployeeIds, FromDate, ToDate, isWeekendingRange);
if (dsEmployeesPayment.Tables[0].Rows.Count > 0)
{
lblNoRecords.Visible = false;
DataSetHelper dsh = new DataSetHelper(dsEmployeesPayment);
if (isGroupByWeekending)
{
dsh.AddDistinctTable("Employees", 0, "WebDisplay", "EmployeeId", "WeekendingDate", "HireDate", "EffectiveHireDate", "ProgressionRate", "PayBandName");
dsh.AddDistinctTable("Routes", 0, "EmployeeId", "RouteNo", "DepartDate", "WeekendingDate");
}
else
{
dsh.AddDistinctTable("Employees", 0, "WebDisplay", "EmployeeId", "HireDate", "EffectiveHireDate", "ProgressionRate", "PayBandName");
dsh.AddDistinctTable("Routes", 0, "EmployeeId", "RouteNo", "DepartDate");
}
rptEmployees.DataSource = dsEmployeesPayment.Tables["Employees"];
rptEmployees.DataBind();
}
}
else
{
lblInvalidInput.Visible = true;
lblNoRecords.Visible = false;
}
}
