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