private void OpenRecord(string strSalaryType)
{
if (strSalaryType == "S")
{
lblMonth.Text = "Payslip for the Month of " + ddlMonth.SelectedItem.ToString().Trim() + ", " + ddlYear.SelectedValue.ToString().Trim();
}
else
{
lblMonth.Text = "Festival Allowance - " + ddlMonth.SelectedItem.ToString().Trim() + ", " + ddlYear.SelectedValue.ToString().Trim();
}
DataTable dt = new DataTable();
dt = (DataTable)objPayRptMgr.GetPayslipMonthlyGrossAndBenefits(lblEmpId.Text.Trim(), ddlMonth.SelectedValue.ToString().Trim(), ddlYear.SelectedValue.ToString().Trim(), strSalaryType);
grGrossandBenefits.DataSource = dt;
grGrossandBenefits.DataBind();
clsCashWord cal = new clsCashWord();
int nouOfRow = dt.Rows.Count;
if (string.IsNullOrEmpty(dt.Rows[nouOfRow - 1]["PAYAMT"].ToString().Trim()) == false)
{
lblTakaInWord.Text = "<b>In Words : </b>" + cal.getCashWord(Common.ReturnZeroForNull(dt.Rows[nouOfRow - 1]["PAYAMT"].ToString().Trim())); //nouOfRow.ToString();
}
dt.Rows.Clear();
lblRemarks.Text = objPayRptMgr.GetPayrollRemarksForPayslip(lblEmpId.Text.Trim(), ddlMonth.SelectedValue.ToString().Trim(), ddlYear.SelectedValue.ToString().Trim(), strSalaryType);
if (string.IsNullOrEmpty(lblRemarks.Text) == false)
{
lblRemarks.Text = "* " + lblRemarks.Text;
}
this.FormatGrossAndBenefitsGrid();
this.FormatDeductionGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strParams = Request.QueryString["params"];
string[] strVal = strParams.Split(',');
if (strVal[4].Trim() == "S")
{
lblMonth.Text = "Payslip for the Month of " + strVal[1] + ", " + strVal[2];
}
else
{
lblMonth.Text = "Festival Allowance - " + strVal[1] + " " + strVal[2];
}
// Get Employee Personal data
DataTable dtPersonal = objEmp.SelectEmpPayslipPersonalInfo(strVal[3].Trim());
if (dtPersonal.Rows.Count > 0)
{
lblID.Text = dtPersonal.Rows[0]["EmpId"].ToString().Trim();
lblName.Text = dtPersonal.Rows[0]["FULLNAME"].ToString().Trim();
lblGrade.Text = dtPersonal.Rows[0]["GradeName"].ToString().Trim();
lblJobTitle.Text = dtPersonal.Rows[0]["JobTitleName"].ToString().Trim();
lblBankAc.Text = dtPersonal.Rows[0]["BankAccNo"].ToString().Trim();
lblDesig.Text = dtPersonal.Rows[0]["DesigName"].ToString().Trim();
lblPostDiv.Text = dtPersonal.Rows[0]["PostingDivName"].ToString().Trim();
lblDept.Text = dtPersonal.Rows[0]["DeptName"].ToString().Trim();
lblPostDist.Text = dtPersonal.Rows[0]["PostingDistName"].ToString().Trim();
lblSalLoc.Text = dtPersonal.Rows[0]["SalLocName"].ToString().Trim();
lblPostPla.Text = dtPersonal.Rows[0]["PostingPlaceName"].ToString().Trim();
lblSalDiv.Text = dtPersonal.Rows[0]["SalSubLocName"].ToString().Trim();
}
DataTable dt = new DataTable();
dt = (DataTable)objPayRptMgr.GetPayslipMonthlyGrossAndBenefits(strVal[3].Trim(), strVal[0].Trim(), strVal[2].Trim(), strVal[4].Trim());
grGrossandBenefits.DataSource = dt;
grGrossandBenefits.DataBind();
clscashword cal = new clscashword();
int nouOfRow = dt.Rows.Count;
if (string.IsNullOrEmpty(dt.Rows[nouOfRow - 1]["PAYAMT"].ToString().Trim()) == false)
{
lblTakaInWord.Text = "<b>In Words : </b>" + cal.getCashWord(Common.ReturnZeroForNull(dt.Rows[nouOfRow - 1]["PAYAMT"].ToString().Trim())); //nouOfRow.ToString();
}
dt.Rows.Clear();
lblRemarks.Text = objPayRptMgr.GetPayrollRemarksForPayslip(strVal[3].Trim(), strVal[0].Trim(), strVal[2].Trim(), strVal[4].Trim());
if (string.IsNullOrEmpty(lblRemarks.Text) == false)
{
lblRemarks.Text = "* " + lblRemarks.Text;
}
this.FormatGrossAndBenefitsGrid();
this.FormatDeductionGrid();
}
}
protected void btnSendEmail_Click(object sender, EventArgs e)
{
string strRetText = "";
string strToAddr = "";
string strSubject = "";
string strBody = "";
string strFromAddr = Session["EMAILID"].ToString().Trim();
string strPayslipMonth = ddlMonth.SelectedItem.Text.Trim() + " " + ddlYear.SelectedValue.Trim();
string strSalType = chkBonus.Checked == true ? "B" : "S";
foreach (GridViewRow gRow in grEmployee.Rows)
{
CheckBox chkB = (CheckBox)gRow.Cells[0].FindControl("chkBox");
if (chkB.Checked == true)
{
this.ResetGridView(grGrossandBenefits, true);
this.ResetGridView(grDeduct, true);
this.ResetGridView(grNetPay, true);
grGrossandBenefits.DataSource = objPayRptMgr.GetPayslipMonthlyGrossAndBenefits(gRow.Cells[2].Text.Trim(), ddlMonth.SelectedValue.ToString(), ddlYear.SelectedValue.ToString(), strSalType);
grGrossandBenefits.DataBind();
//grDeduct.DataSource = objPayRptMgr.GetPayslipMonthlyDeductions(gRow.Cells[2].Text.Trim(), ddlMonth.SelectedValue.ToString(), ddlYear.SelectedValue.ToString(), strSalType);
//grDeduct.DataBind();
//grNetPay.DataSource = objPayRptMgr.GetPayslipMonthlyNetPay(gRow.Cells[2].Text.Trim(), ddlMonth.SelectedValue.ToString(), ddlYear.SelectedValue.ToString(), strSalType);
//grNetPay.DataBind();
lblRemarks.Text = objPayRptMgr.GetPayrollRemarksForPayslip(gRow.Cells[2].Text.Trim(), ddlMonth.SelectedValue.ToString(), ddlYear.SelectedValue.ToString(), strSalType);
if (string.IsNullOrEmpty(lblRemarks.Text) == false)
{
lblRemarks.Text = "* " + lblRemarks.Text;
}
this.FormatGrossAndBenefitsGrid();
this.FormatDeductionGrid();
strToAddr = gRow.Cells[7].Text.Trim();
if (chkBonus.Checked == true)
{
strSubject = "Festival Allowance - " + strPayslipMonth;
}
else
{
strSubject = "Payslip for the Month of " + strPayslipMonth;
}
strBody = " <pre style=" + "\"font-weight:bold;font-size:14px;font-family:Arial;\"" + "> " + "Save The Children " + " </pre> "
+ " <pre style=" + "\"font-size:12px;font-family:Arial;\"" + "> " + gRow.Cells[3].Text.Trim() + " </pre> "
+ " <pre style=" + "\"font-size:12px;font-family:Arial;\"" + "> " + gRow.Cells[5].Text.Trim() + " </pre> "
+ " <pre style=" + "\"font-size:12px;font-family:Arial;\"" + "> " + gRow.Cells[4].Text.Trim() + " </pre> "
+ " <pre style=" + "\"font-size:12px;font-family:Arial;\"" + "> " + "Employee ID: " + gRow.Cells[2].Text.Trim() + " </pre> "
+ " <pre> </pre>"
+ " <pre style=" + "\"font-size:12px;font-family:Arial;\"" + "> " + "Date of Issue : " + DateTime.Today.ToLongDateString() + " </pre> "
+ " <pre> </pre>"
+ " <pre style=" + "\"font-weight:bold;font-size:14px;font-family:Arial;\"" + "> " + strSubject + " </pre> "
+ " <pre> </pre>"
+ " <table style=" + "\"width:100%;\"" + "> "
+ " \n "
+ " <tr> "
+ " \n "
+ " <td style=" + "\"width:49%;vertical-align:top;\"" + "> "
+ " \n "
+ this.GetGridViewHTML(grGrossandBenefits)
+ " \n "
+ " </td> "
+ " \n "
+ " <td style=" + "\"width:49%;vertical-align:top;\"" + "> "
+ " \n "
+ this.GetGridViewHTML(grDeduct)
+ " <pre> </pre>"
+ this.GetGridViewHTML(grNetPay)
+ " <pre> </pre>"
+ lblRemarks.Text.Trim()
+ " </td> "
+ " \n "
+ " </tr> "
+ " \n "
+ " <tr> "
+ " \n "
+ " <td colspan=" + "\"2\"" + ">"
+ " \n "
+ " <pre> </pre>"
+ " <pre style=" + "\"font-size:12px;font-family:Arial;\"" + "> "
+ " Note: This is a computer generated payslip and does not require any signature. If any discrepancy is found please "
+ " inform HR Team within 7 days of the issuance. "
+ "</pre> "
+ " </td> "
+ " </tr> "
+ "\n "
+ " </table> "
+ " \n ";
strRetText = objMail.PayslipEmail(strFromAddr, strToAddr, strSubject, strBody, "");
if (strRetText == "N")
{
gRow.Cells[1].ForeColor = System.Drawing.Color.Red;
gRow.Cells[2].ForeColor = System.Drawing.Color.Red;
gRow.Cells[3].ForeColor = System.Drawing.Color.Red;
gRow.Cells[4].ForeColor = System.Drawing.Color.Red;
gRow.Cells[5].ForeColor = System.Drawing.Color.Red;
gRow.Cells[6].ForeColor = System.Drawing.Color.Red;
gRow.Cells[7].ForeColor = System.Drawing.Color.Red;
break;
}
chkB.Checked = false;
gRow.Cells[1].ForeColor = System.Drawing.Color.Green;
gRow.Cells[2].ForeColor = System.Drawing.Color.Green;
gRow.Cells[3].ForeColor = System.Drawing.Color.Green;
gRow.Cells[4].ForeColor = System.Drawing.Color.Green;
gRow.Cells[5].ForeColor = System.Drawing.Color.Green;
gRow.Cells[6].ForeColor = System.Drawing.Color.Green;
gRow.Cells[7].ForeColor = System.Drawing.Color.Green;
}
}
this.ResetGridView(grGrossandBenefits, false);
this.ResetGridView(grDeduct, false);
this.ResetGridView(grNetPay, false);
lblRemarks.Text = "";
if (strRetText == "N")
{
lblMsg.Text = "Failure in Sending Mail";
}
if (strRetText == "Y")
{
lblMsg.Text = "Payslip email has been sent successfully";
}
}