public void BindgvReport()
{
PaySlipBl objPaySlipBl = new PaySlipBl();
ApplicationResult objResult = new ApplicationResult();
objResult = objPaySlipBl.Select_Employee_ForPaySlip((Session[ApplicationSession.TRUSTID]).ToString(),
ddlMonth.SelectedValue, ddlYear.SelectedValue, 1);
if (objResult != null)
{
gvReport1.DataSource = null;
gvReport.DataSource = null;
if (objResult.resultDT.Rows.Count > 0)
{
gvReport1.Visible = true;
gvReport.Visible = true;
divButtons.Visible = true;
lblTrustName.Text = "Navchetan English and Gujarati Medium School, Kharach.";
lblYear.Text = ddlYear.SelectedItem.Text;
lblMonth.Text = ddlMonth.SelectedItem.Text;
DataRow newrow1 = objResult.resultDT.NewRow();
newrow1[1] = "Total";
objResult.resultDT.Rows.Add(newrow1);
int i = 0;
foreach (DataColumn col in objResult.resultDT.Columns)
{
if (i != 0 && i != 1 && i != 2 && i != 3)
{
object sumObject;
sumObject = objResult.resultDT.Compute("Sum([" + col.ColumnName + "])", "");
objResult.resultDT.Rows[objResult.resultDT.Rows.Count - 1][i] = sumObject;
}
i++;
}
}
else
{
gvReport1.Visible = false;
gvReport.Visible = false;
divButtons.Visible = false;
pnlEmployeePayrollInfo.Visible = true;
lblErrMsg.Text = "No record Found";
divReport.Visible = false;
}
}
gvReport1.DataSource = objResult.resultDT;
gvReport.DataSource = objResult.resultDT;
gvReport.DataBind();
gvReport1.DataBind();
}
public void GeneratePayRoll()
{
PaySlipBl objPaySlipBl = new PaySlipBl();
ApplicationResult objResult = new ApplicationResult();
objResult = objPaySlipBl.Select_Employee_ForPaySlip((Session[ApplicationSession.TRUSTID]).ToString(), ddlMonth.SelectedValue, ddlYear.SelectedValue, 0);
if (objResult != null)
{
ViewState["Count"] = objResult.resultDT.Columns.Count;
if (objResult.resultDT.Rows.Count > 0)
{
DataRow newrow1 = objResult.resultDT.NewRow();
newrow1[1] = "Total";
objResult.resultDT.Rows.Add(newrow1);
int i = 0;
foreach (DataColumn col in objResult.resultDT.Columns)
{
if (i != 0 && i != 1 && i != 2 && i != 3)
{
object sumObject;
sumObject = objResult.resultDT.Compute("Sum([" + col.ColumnName + "])", "");
objResult.resultDT.Rows[objResult.resultDT.Rows.Count - 1][i] = sumObject;
}
i++;
}
}
gvtemp.DataSource = null;
gvtemp.DataSource = objResult.resultDT;
gvtemp.DataBind();
if (objResult.resultDT.Rows.Count > 0)
{
((CheckBox)gvtemp.Rows[objResult.resultDT.Rows.Count - 1].FindControl("chkChild")).Visible = false;
divButtons.Visible = true;
divEmployee.Visible = true;
gvtemp.Visible = true;
lblErrMsg.Visible = false;
}
else
{
gvtemp.Visible = false;
divButtons.Visible = false;
divEmployee.Visible = true;
lblErrMsg.Text = "No record Found";
}
}
}
public void BindgvReport()
{
PaySlipBl objPaySlipBl = new PaySlipBl();
ApplicationResult objResult = new ApplicationResult();
objResult = objPaySlipBl.Select_Employee_ForPaySlip((Session[ApplicationSession.TRUSTID]).ToString(),
ddlMonth.SelectedValue, ddlYear.SelectedValue, 1);
if (objResult != null)
{
gvReport1.DataSource = null;
gvReport.DataSource = null;
if (objResult.resultDT.Rows.Count > 0)
{
gvReport1.Visible = true;
gvReport.Visible = true;
divReport.Visible = true;
lblTrustName.Text = "VIDYUT BOARD VIDYALAYA, ENGLISH AND GUJARATI MEDIUM, Vadodara.";
lblYear.Text = ddlYear.SelectedItem.Text;
lblMonth.Text = ddlMonth.SelectedItem.Text;
DataRow newrow1 = objResult.resultDT.NewRow();
newrow1[1] = "Total";
objResult.resultDT.Rows.Add(newrow1);
int i = 0;
foreach (DataColumn col in objResult.resultDT.Columns)
{
if (i != 0 && i != 1 && i != 2 && i != 3)
{
object sumObject;
sumObject = objResult.resultDT.Compute("Sum([" + col.ColumnName + "])", "");
objResult.resultDT.Rows[objResult.resultDT.Rows.Count - 1][i] = sumObject;
}
i++;
}
gvReport1.DataSource = objResult.resultDT;
gvReport.DataSource = objResult.resultDT;
gvReport.DataBind();
gvReport1.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('No record Found.');", true);
//Response.Redirect("../PayRoll/EmployeePayRollReport.aspx");
ClearAll();
}
}
}
