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