private void GetReport(DateTime StartDate, DateTime EndTime, int userid)
{
try
{
Attendance.BAL.Report obj = new Report();
DataSet ds = obj.GetPayrollReport(StartDate, EndTime, userid);
lblWeekPayrollReport.Text = "( " + StartDate.ToString("MM/dd/yyyy") + " - " + EndTime.ToString("MM/dd/yyyy") + " )";
GetEditHistory(StartDate, EndTime);
grdPayRoll.DataSource = ds.Tables[0];
grdPayRoll.DataBind();
}
catch (Exception ex)
{
}
}
//protected void btnSave_Click(object sender, EventArgs e)
//{
// try
// {
// DateTime dt = Convert.ToDateTime(ViewState["StartRptDt"]);
// DateTime EndDate = Convert.ToDateTime(ViewState["EndRptDt"]);
// Report obj = new Report();
// for (int i = 0; i < grdPayRollIndia.Rows.Count; i++)
// {
// comanyname.Text = CommonFiles.ComapnyName;
// string timezone = "";
// if (Convert.ToInt32(Session["TimeZoneID"]) == 2)
// {
// timezone = "Eastern Standard Time";
// }
// else
// {
// timezone = "India Standard Time";
// }
// DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone));
// //Atndence history
// Attendance.Entities.AttendenceInfo objInfo = new Attendance.Entities.AttendenceInfo();
// HiddenField hdnEmpuserid = (HiddenField)grdPayRollIndia.Rows[i].FindControl("hdnEmpuserid");
// Label lblWorkingDays = (Label)grdPayRollIndia.Rows[i].FindControl("lblWorkingDays");
// Label lblAttendDays = (Label)grdPayRollIndia.Rows[i].FindControl("lblAttendDays");
// Label lblLeaves = (Label)grdPayRollIndia.Rows[i].FindControl("lblLeaves");
// Label lblNoshow = (Label)grdPayRollIndia.Rows[i].FindControl("lblNoshow");
// Label lblLeavesAvailable = (Label)grdPayRollIndia.Rows[i].FindControl("lblLeavesAvailable");
// Label lblLeavesUsed = (Label)grdPayRollIndia.Rows[i].FindControl("lblLeavesUsed");
// Label lblPaidLeavesBalanced = (Label)grdPayRollIndia.Rows[i].FindControl("lblPaidLeavesBalanced");
// Label lblCalLeaves = (Label)grdPayRollIndia.Rows[i].FindControl("lblCalLeaves");
// objInfo.Mnth = Convert.ToInt32(dt.ToString("MM"));
// objInfo.Yr = Convert.ToInt32(dt.ToString("yyyy"));
// objInfo.EnterBy=Convert.ToInt32(Session["UserID"]);
// objInfo.EnterDate = ISTTime;
// objInfo.TotalCalLeaves1 = lblCalLeaves.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblCalLeaves.Text.ToString().Trim());
// objInfo.PaidLeavesUsed = lblLeavesUsed.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblLeavesUsed.Text.ToString().Trim());
// objInfo.PaidLeavesBalanced = lblPaidLeavesBalanced.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblPaidLeavesBalanced.Text.ToString().Trim());
// objInfo.PaidLeaves = lblLeavesAvailable.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblLeavesAvailable.Text.ToString().Trim());
// objInfo.NoShow = lblNoshow.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblNoshow.Text.ToString().Trim());
// objInfo.Leaves = lblLeaves.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblLeaves.Text.ToString().Trim());
// objInfo.WorkingDays = lblWorkingDays.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblWorkingDays.Text.ToString().Trim());
// objInfo.AttendDays = lblAttendDays.Text.ToString().Trim() == "" ? 0: Convert.ToSingle(lblAttendDays.Text.ToString().Trim());
// objInfo.Userid = Convert.ToInt32(hdnEmpuserid.Value);
// int AtnLogID = obj.SaveAttendanceHistory(objInfo);
// //Salary history
// Label lblCalSalary = (Label)grdPayRollIndia.Rows[i].FindControl("lblCalSalary");
// TextBox txtBonus = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtBonus");
// TextBox txtIncentives = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtIncentives");
// TextBox txtPrevUnpaid = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtPrevUnpaid");
// TextBox txtAdvancePaid = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtAdvancePaid");
// TextBox txtExpenses = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtExpenses");
// TextBox txtLoanDeduct = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtLoanDeduct");
// Label lblTotal = (Label)grdPayRollIndia.Rows[i].FindControl("lblTotal");
// Attendance.Entities.SalaryInfo objSal = new Attendance.Entities.SalaryInfo();
// objSal.AtnLogID = AtnLogID;
// objSal.CalSalary = lblCalSalary.Text.Trim() == "" ? 0 : Convert.ToSingle(lblCalSalary.Text.Trim());
// objSal.Bonus = txtBonus.Text.Trim() == "" ? 0 : Convert.ToSingle(txtBonus.Text.Trim());
// objSal.Incentives = txtIncentives.Text.Trim() == "" ? 0 : Convert.ToSingle(txtIncentives.Text.Trim());
// objSal.PrevUnpaid = txtPrevUnpaid.Text.Trim() == "" ? 0 : Convert.ToSingle(txtPrevUnpaid.Text.Trim());
// objSal.AdvancePaid = txtAdvancePaid.Text.Trim() == "" ? 0 : Convert.ToSingle(txtAdvancePaid.Text.Trim());
// objSal.Expenses = txtExpenses.Text.Trim() == "" ? 0 : Convert.ToSingle(txtExpenses.Text.Trim());
// objSal.LoanDeduct = txtLoanDeduct.Text.Trim() == "" ? 0 : Convert.ToSingle(txtLoanDeduct.Text.Trim());
// objSal.TotalPay = lblTotal.Text.Trim() == "" ? 0 : Convert.ToSingle(lblTotal.Text.Trim());
// objSal.Mnth = objInfo.Mnth;
// objSal.Years = objInfo.Yr;
// objSal.EnterBy = objInfo.EnterBy;
// objSal.EnteredDate = objInfo.EnterDate;
// string notes = "";
// if (txtBonus.Attributes["notes"] != null)
// {
// if (txtBonus.Attributes["notes"].ToString().Trim() != "")
// {
// notes = txtBonus.Attributes["notes"].ToString().Trim();
// notes += "<br>....................<br> Bonus enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtIncentives.Attributes["notes"] != null)
// {
// if (txtIncentives.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtIncentives.Attributes["notes"].ToString();
// notes += "<br>....................<br> Incentives enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtPrevUnpaid.Attributes["notes"] != null)
// {
// if (txtPrevUnpaid.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtPrevUnpaid.Attributes["notes"].ToString();
// notes += "<br>....................<br> Previous unpaid enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtAdvancePaid.Attributes["notes"] != null)
// {
// if (txtAdvancePaid.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtAdvancePaid.Attributes["notes"].ToString();
// notes += "<br>....................<br> Advance paid enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtExpenses.Attributes["notes"] != null)
// {
// if (txtExpenses.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtExpenses.Attributes["notes"].ToString();
// notes += "<br>....................<br> Expenses enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtLoanDeduct.Attributes["notes"] != null)
// {
// if (txtLoanDeduct.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtLoanDeduct.Attributes["notes"].ToString();
// notes += "<br>....................<br> Loan deduction enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// objSal.InternalNotes = notes;
// bool bnew = obj.SaveSalaryHistory(objSal);
// }
// bool final = obj.GetFinalPayrollDate(dt, Convert.ToInt32(ddlLocation.SelectedItem.Value), Convert.ToInt32(ddlShift.SelectedValue));
// if (final)
// {
// btnFinal.CssClass = "btn btn-small btn-warning disabled";
// btnSave.CssClass = "btn btn-small btn-warning disabled";
// btnFinal.Enabled = false;
// btnSave.Enabled = false;
// hdnFreeze.Value = "true"; ;
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "delEditLabelCss();", true);
// }
// else
// {
// btnFinal.CssClass = "btn btn-small btn-warning";
// btnSave.CssClass = "btn btn-small btn-warning";
// btnFinal.Enabled = true;
// btnSave.Enabled = true;
// hdnFreeze.Value = "false";
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "addEditLabelCss();", true);
// }
// DataTable dst = GetReportIndia(dt, EndDate, Convert.ToInt32(ddlLocation.SelectedValue), Convert.ToInt32(ddlShift.SelectedValue));
// lblWeekPayrollReport.Text = "( " + dt.ToString("MM/dd/yyyy") + " - " + EndDate.ToString("MM/dd/yyyy") + " )";
// GetEditHistory(dt, EndDate);
// // lblTotal.Text = "Employee record count: " + dst.Rows.Count.ToString().Trim();
// lblReportDate.Text = "Report generated at <b>" + Convert.ToDateTime(lblDate2.Text).ToString("MM/dd/yyyy hh:mm:ss tt") + "</b> by <b>" + Session["EmpName"].ToString().Trim() + "</b>";
// grdPayRollIndia.DataSource = dst;
// grdPayRollIndia.DataBind();
// Session["Indiapayroll"] = (DataTable)grdPayRollIndia.DataSource;
// grdPayRoll.DataSource = null;
// grdPayRoll.DataBind();
// btnSave.Visible = true;
// btnFinal.Visible = true;
// btnPrint.Visible = true;
// }
// catch (Exception ex)
// {
// }
//}
//protected void btnFinal_Click(object sender, EventArgs e)
//{
// try
// {
// Report obj = new Report();
// DateTime dt = Convert.ToDateTime(ViewState["StartRptDt"]);
// DateTime EndDate = Convert.ToDateTime(ViewState["EndRptDt"]);
// int locationID = Convert.ToInt32(ddlLocation.SelectedValue);
// for (int i = 0; i < grdPayRollIndia.Rows.Count; i++)
// {
// comanyname.Text = CommonFiles.ComapnyName;
// string timezone = "";
// if (Convert.ToInt32(Session["TimeZoneID"]) == 2)
// {
// timezone = "Eastern Standard Time";
// }
// else
// {
// timezone = "India Standard Time";
// }
// DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone));
// //Atndence history
// Attendance.Entities.AttendenceInfo objInfo = new Attendance.Entities.AttendenceInfo();
// HiddenField hdnEmpuserid = (HiddenField)grdPayRollIndia.Rows[i].FindControl("hdnEmpuserid");
// Label lblWorkingDays = (Label)grdPayRollIndia.Rows[i].FindControl("lblWorkingDays");
// Label lblAttendDays = (Label)grdPayRollIndia.Rows[i].FindControl("lblAttendDays");
// Label lblLeaves = (Label)grdPayRollIndia.Rows[i].FindControl("lblLeaves");
// Label lblNoshow = (Label)grdPayRollIndia.Rows[i].FindControl("lblNoshow");
// Label lblLeavesAvailable = (Label)grdPayRollIndia.Rows[i].FindControl("lblLeavesAvailable");
// Label lblLeavesUsed = (Label)grdPayRollIndia.Rows[i].FindControl("lblLeavesUsed");
// Label lblPaidLeavesBalanced = (Label)grdPayRollIndia.Rows[i].FindControl("lblPaidLeavesBalanced");
// Label lblCalLeaves = (Label)grdPayRollIndia.Rows[i].FindControl("lblCalLeaves");
// objInfo.Mnth = Convert.ToInt32(dt.ToString("MM"));
// objInfo.Yr = Convert.ToInt32(dt.ToString("yyyy"));
// objInfo.EnterBy = Convert.ToInt32(Session["UserID"]);
// objInfo.EnterDate = ISTTime;
// objInfo.TotalCalLeaves1 = lblCalLeaves.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblCalLeaves.Text.ToString().Trim());
// objInfo.PaidLeavesUsed = lblLeavesUsed.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblLeavesUsed.Text.ToString().Trim());
// objInfo.PaidLeavesBalanced = lblPaidLeavesBalanced.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblPaidLeavesBalanced.Text.ToString().Trim());
// objInfo.PaidLeaves = lblLeavesAvailable.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblLeavesAvailable.Text.ToString().Trim());
// objInfo.NoShow = lblNoshow.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblNoshow.Text.ToString().Trim());
// objInfo.Leaves = lblLeaves.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblLeaves.Text.ToString().Trim());
// objInfo.WorkingDays = lblWorkingDays.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblWorkingDays.Text.ToString().Trim());
// objInfo.AttendDays = lblAttendDays.Text.ToString().Trim() == "" ? 0 : Convert.ToSingle(lblAttendDays.Text.ToString().Trim());
// objInfo.Userid = Convert.ToInt32(hdnEmpuserid.Value);
// int AtnLogID = obj.SaveAttendanceHistory(objInfo);
// String strHostName = Request.UserHostAddress.ToString();
// string strIp = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
// bool bnewp = obj.UpdatePaidLeavesDetAfterFinalPayroll(objInfo, dt, strIp);
// //Salary history
// Label lblCalSalary = (Label)grdPayRollIndia.Rows[i].FindControl("lblCalSalary");
// TextBox txtBonus = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtBonus");
// TextBox txtIncentives = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtIncentives");
// TextBox txtPrevUnpaid = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtPrevUnpaid");
// TextBox txtAdvancePaid = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtAdvancePaid");
// TextBox txtExpenses = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtExpenses");
// TextBox txtLoanDeduct = (TextBox)grdPayRollIndia.Rows[i].FindControl("txtLoanDeduct");
// Label lblTotal = (Label)grdPayRollIndia.Rows[i].FindControl("lblTotal");
// Attendance.Entities.SalaryInfo objSal = new Attendance.Entities.SalaryInfo();
// objSal.AtnLogID = AtnLogID;
// objSal.CalSalary = lblCalSalary.Text.Trim() == "" ? 0 : Convert.ToSingle(lblCalSalary.Text.Trim());
// objSal.Bonus = txtBonus.Text.Trim() == "" ? 0 : Convert.ToSingle(txtBonus.Text.Trim());
// objSal.Incentives = txtIncentives.Text.Trim() == "" ? 0 : Convert.ToSingle(txtIncentives.Text.Trim());
// objSal.PrevUnpaid = txtPrevUnpaid.Text.Trim() == "" ? 0 : Convert.ToSingle(txtPrevUnpaid.Text.Trim());
// objSal.AdvancePaid = txtAdvancePaid.Text.Trim() == "" ? 0 : Convert.ToSingle(txtAdvancePaid.Text.Trim());
// objSal.Expenses = txtExpenses.Text.Trim() == "" ? 0 : Convert.ToSingle(txtExpenses.Text.Trim());
// objSal.LoanDeduct = txtLoanDeduct.Text.Trim() == "" ? 0 : Convert.ToSingle(txtLoanDeduct.Text.Trim());
// objSal.TotalPay = lblTotal.Text.Trim() == "" ? 0 : Convert.ToSingle(lblTotal.Text.Trim());
// objSal.Mnth = objInfo.Mnth;
// objSal.Years = objInfo.Yr;
// objSal.EnterBy = objInfo.EnterBy;
// objSal.EnteredDate = objInfo.EnterDate;
// string notes = "";
// if (txtBonus.Attributes["notes"] != null)
// {
// if (txtBonus.Attributes["notes"].ToString().Trim() != "")
// {
// notes = txtBonus.Attributes["notes"].ToString().Trim();
// notes += "<br>....................<br> Bonus enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtIncentives.Attributes["notes"] != null)
// {
// if (txtIncentives.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtIncentives.Attributes["notes"].ToString();
// notes += "<br>....................<br> Incentives enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtPrevUnpaid.Attributes["notes"] != null)
// {
// if (txtPrevUnpaid.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtPrevUnpaid.Attributes["notes"].ToString();
// notes += "<br>....................<br> Previous unpaid enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtAdvancePaid.Attributes["notes"] != null)
// {
// if (txtAdvancePaid.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtAdvancePaid.Attributes["notes"].ToString();
// notes += "<br>....................<br> Advance paid enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtExpenses.Attributes["notes"] != null)
// {
// if (txtExpenses.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtExpenses.Attributes["notes"].ToString();
// notes += "<br>....................<br> Expenses enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// if (txtLoanDeduct.Attributes["notes"] != null)
// {
// if (txtLoanDeduct.Attributes["notes"].ToString().Trim() != "")
// {
// notes += txtLoanDeduct.Attributes["notes"].ToString();
// notes += "<br>....................<br> Loan deduction enter by" + lblEmployyName.Text.Trim() + " at " + objSal.EnteredDate + "<br>";
// }
// }
// objSal.InternalNotes = notes;
// bool bnew = obj.SaveSalaryHistory(objSal);
// }
// bool bnewf = obj.FinalizePayrollReport(locationID, dt, Convert.ToInt32(Session["UserID"]),Convert.ToInt32(ddlShift.SelectedValue));
// bool final = obj.GetFinalPayrollDate(dt, Convert.ToInt32(ddlLocation.SelectedItem.Value), Convert.ToInt32(ddlShift.SelectedValue));
// if (final)
// {
// btnFinal.CssClass = "btn btn-small btn-warning disabled";
// btnSave.CssClass = "btn btn-small btn-warning disabled";
// btnFinal.Enabled = false;
// btnSave.Enabled = false;
// hdnFreeze.Value = "true"; ;
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "delEditLabelCss();", true);
// }
// else
// {
// btnFinal.CssClass = "btn btn-small btn-warning";
// btnSave.CssClass = "btn btn-small btn-warning";
// btnFinal.Enabled = true;
// btnSave.Enabled = true;
// hdnFreeze.Value = "false";
// // System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "addEditLabelCss();", true);
// }
// DataTable dst = GetReportIndia(dt, EndDate, Convert.ToInt32(ddlLocation.SelectedValue),Convert.ToInt32(ddlShift.SelectedValue));
// lblWeekPayrollReport.Text = "( " + dt.ToString("MM/dd/yyyy") + " - " + EndDate.ToString("MM/dd/yyyy") + " )";
// GetEditHistory(dt, EndDate);
// //lblTotal.Text = "Employee record count: " + dst.Rows.Count.ToString().Trim();
// lblReportDate.Text = "Report generated at <b>" + Convert.ToDateTime(lblDate2.Text).ToString("MM/dd/yyyy hh:mm:ss tt") + "</b> by <b>" + Session["EmpName"].ToString().Trim() + "</b>";
// grdPayRollIndia.DataSource = dst;
// grdPayRollIndia.DataBind();
// Session["Indiapayroll"] = (DataTable)grdPayRollIndia.DataSource;
// btnSave.Visible = true;
// btnFinal.Visible = true;
// btnPrint.Visible = true;
// grdPayRoll.DataSource = null;
// grdPayRoll.DataBind();
// //DataTable xmlDt = (DataTable)grdPayRollIndia.DataSource;
// //xmlDt.TableName = "Payslip";
// //xmlDt.WriteXml("/myxml.xml", true);
// }
// catch (Exception ex)
// {
// }
//}
private void GetReport(DateTime StartDate, DateTime EndTime, int userid, string Location,int shiftID)
{
try
{
Attendance.BAL.Report obj = new Report();
DataSet ds = obj.GetPayrollReport(StartDate, EndTime, userid, Location,shiftID);
lblWeekPayrollReport.Text = "( " + StartDate.ToString("MM/dd/yyyy") + " - " + EndTime.ToString("MM/dd/yyyy") + " )";
GetEditHistory(StartDate, EndTime);
if (ds.Tables[0].Rows.Count > 0)
{
lblTotal.Text = ds.Tables[0].Rows[0]["LocDescriptiom"].ToString().Trim() == "" ? "Employee record count: " + ds.Tables[0].Rows.Count.ToString().Trim() : ds.Tables[0].Rows[0]["LocDescriptiom"].ToString().Trim() + " location; Employee record count: " + ds.Tables[0].Rows.Count.ToString().Trim();
lblReportDate.Text = "Report generated at <b>" + Convert.ToDateTime(lblDate2.Text).ToString("MM/dd/yyyy hh:mm:ss tt") + "</b> by <b>" + Session["EmpName"].ToString().Trim() + "</b>";
grdPayRoll.DataSource = ds.Tables[0];
grdPayRoll.DataBind();
grdPayRollIndia.DataSource = null;
grdPayRollIndia.DataBind();
Session["Indiapayroll"] = (DataTable)grdPayRollIndia.DataSource;
dvNodata.Style["display"] = "none";
lblGrdNodata.Text = "";
}
else
{
lblTotal.Text = "";
lblReportDate.Text = "";
dvNodata.Style["display"] = "block";
lblGrdNodata.Text = "No data found";
grdPayRoll.DataSource = null;
grdPayRoll.DataBind();
grdPayRollIndia.DataSource = null;
grdPayRollIndia.DataBind();
}
}
catch (Exception ex)
{
}
}
private DataTable GetReportIndia(DateTime StartDate, DateTime EndTime, int userid, string Location, int shiftID)
{
DataTable dt = new DataTable();
try
{
Attendance.BAL.Report obj = new Report();
DataSet ds = obj.GetPayrollReport(StartDate, EndTime, userid, Location, shiftID);
dt = ds.Tables[0];
}
catch (Exception ex)
{
}
return dt;
}
private void GetReport(DateTime StartDate, DateTime EndTime, int userid)
{
try
{
Attendance.BAL.Report obj = new Report();
DataSet ds = obj.GetPayrollReport(StartDate, EndTime, userid);
lblWeekPayrollReport.Text = "( " + StartDate.ToString("MM/dd/yyyy") + " - " + EndTime.ToString("MM/dd/yyyy") + " )";
GetEditHistory(StartDate, EndTime);
lblTotal.Text = ds.Tables[0].Rows[0]["LocDescriptiom"].ToString().Trim()==""?"Employee record count: " + ds.Tables[0].Rows.Count.ToString().Trim(): ds.Tables[0].Rows[0]["LocDescriptiom"].ToString().Trim() +" location; Employee record count: " + ds.Tables[0].Rows.Count.ToString().Trim();
lblReportDate.Text="Report generated at <b>" + Convert.ToDateTime(lblDate2.Text).ToString("MM/dd/yyyy hh:mm:ss tt") + "</b> by <b>" + Session["EmpName"].ToString().Trim()+"</b>";
grdPayRoll.DataSource = ds.Tables[0];
grdPayRoll.DataBind();
}
catch (Exception ex)
{
}
}