protected void RadEmployee_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
rdpDateofJoiningScheme.SelectedDate = null;
radPensionIDNo.Text = string.Empty;
if (RadEmployee.SelectedIndex > 0)
{
_obj_Smhr_EMPPENSIONSCHEME = new SMHR_EMPPENSIONSCHEME();
_obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Get;
_obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEME_EMPID = Convert.ToInt32(RadEmployee.SelectedValue);
_obj_Smhr_EMPPENSIONSCHEME.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_PensionScheme(_obj_Smhr_EMPPENSIONSCHEME);
radPensionIDNo.Text = dt.Rows[0]["EMP_MEMBERID"].ToString();
//rdpDateofJoiningScheme.MinDate = Convert.ToDateTime("01/01/1900");
rdpDateofJoiningScheme.MinDate = Convert.ToDateTime(dt.Rows[0]["EMP_DOJ"]);
if (Convert.ToString(dt.Rows[0]["EMP_PENSION_DOJ"]) != "")
{
rdpDateofJoiningScheme.SelectedDate = Convert.ToDateTime(dt.Rows[0]["EMP_PENSION_DOJ"]);
rdpDateofJoiningScheme.Enabled = true;
}
else
{
rdpDateofJoiningScheme.Enabled = true;
rdpDateofJoiningScheme.SelectedDate = Convert.ToDateTime(dt.Rows[0]["EMP_DOJ"]);
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_employeescheme", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public void LoadGrid()
{
try
{
_obj_Smhr_EMPPENSIONSCHEME = new SMHR_EMPPENSIONSCHEME();
_obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Select;
_obj_Smhr_EMPPENSIONSCHEME.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = BLL.get_PensionScheme(_obj_Smhr_EMPPENSIONSCHEME);
Rg_MedicalClaim.DataSource = DT;
clearControls();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_employeescheme", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
clearControls();
_obj_Smhr_EMPPENSIONSCHEME = new SMHR_EMPPENSIONSCHEME();
_obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Get;
_obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEME_EMPID = Convert.ToInt32(e.CommandArgument);
//lblSchemeID.Text = _obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEMEID.ToString();
_obj_Smhr_EMPPENSIONSCHEME.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_PensionScheme(_obj_Smhr_EMPPENSIONSCHEME);
AssignvaluesToUserControl(dt);
ControlsEnableorDisable(false);
if (Convert.ToBoolean(dt.Rows[0]["IsRelievedEmp"]))
{
ControlsonRelievedEmp(false); //To enable/disable controls
}
else
{
ControlsonRelievedEmp(true); //To enable/disable controls
}
radPensionIDNo.Text = dt.Rows[0]["EMP_MEMBERID"].ToString();
rdpDateofJoiningScheme.MinDate = Convert.ToDateTime("01/01/1900");
rdpDateofJoiningScheme.SelectedDate = Convert.ToDateTime(dt.Rows[0]["EMP_PENSION_DOJ"]);
//rdpDateofJoiningScheme.Enabled = false;
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
Rm_CY_page.SelectedIndex = 1;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_employeescheme", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcb_Employee_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
DataTable dtEmpPensionDetails = new DataTable();
DataTable dtpf = new DataTable();
if (rcb_Employee.SelectedIndex != 0)
{
_obj_smhr_emp_payitems = new SMHR_EMP_PAYITEMS();
_obj_smhr_emp_payitems.SMHR_EMP_PAYITEMS_EMPID = Convert.ToInt32(rcb_Employee.SelectedValue);
_obj_smhr_emp_payitems.OPERATION = operation.Check;
_obj_smhr_emp_payitems.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_emp_payitems.BUID = Convert.ToInt32(rcb_BussinessUnit.SelectedValue);
// _obj_smhr_emp_payitems.SMHR_EMP_PAYITEMS_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_EmpDetails(_obj_smhr_emp_payitems);
if (dt.Rows.Count != 0)
{
RG_SalaryStruct.DataSource = dt;
RG_SalaryStruct.DataBind();
}
else
{
LoadEmptyData();
}
_obj_smhr_emp_payitems.OPERATION = operation.Select;
_obj_smhr_emp_payitems.SMHR_EMP_PAYITEMS_EMPID = Convert.ToInt32(rcb_Employee.SelectedValue);
_obj_smhr_emp_payitems.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt1 = BLL.get_EmpSalaryStruct(_obj_smhr_emp_payitems);
if (dt1.Rows.Count != 0)
{
rtxt_SalaryStruct.Text = Convert.ToString(dt1.Rows[0]["SALARYSTRUCT_CODE"]);
rtxt_Positions.Text = Convert.ToString(dt1.Rows[0]["POSITIONS_CODE"]);
rtxt_Basic.Text = Convert.ToString(dt1.Rows[0]["EMP_BASIC"]);
string strVal = Convert.ToString(dt1.Rows[0]["POSITIONS_ID"]);
getJob(strVal);
}
int i;
for (i = 0; i <= RG_SalaryStruct.Items.Count - 1; i++)
{
CheckBox chkChoose = new CheckBox();
TextBox txtgetVal = new TextBox();
RadNumericTextBox txtgetVal1 = new RadNumericTextBox();
Label lblPAYITEMNAME = new Label();
TextBox txtMRPID = new TextBox();
Label lblPAYITEM_ID = new Label();
chkChoose = RG_SalaryStruct.Items[i].FindControl("chk_Choose") as CheckBox;
txtgetVal = RG_SalaryStruct.Items[i].FindControl("txtNumber") as TextBox;
txtgetVal1 = RG_SalaryStruct.Items[i].FindControl("rntbAmount") as RadNumericTextBox;
lblPAYITEMNAME = RG_SalaryStruct.Items[i].FindControl("lblPAYITEMNAME") as Label;
lblPAYITEM_ID = RG_SalaryStruct.Items[i].FindControl("lblPAYITEM_ID") as Label;
txtMRPID = RG_SalaryStruct.Items[i].FindControl("txtMRPID") as TextBox;
if (lblPAYITEMNAME.Text == "Housing Allowance" || lblPAYITEMNAME.Text == "Housing_Allowance")
{
if (txtgetVal1.Text != string.Empty)
{
txtgetVal1.Enabled = false;
}
}
//if (Convert.ToString(txtgetVal.Text) != string.Empty)
//{
// if (dt.Rows.Count > 0)
// {
// chkChoose.Checked = true;
// }
//}
if (txtMRPID.Text == "22" || txtMRPID.Text == "23")
{
txtgetVal.Enabled = false;
_obj_Smhr_EMPPENSIONSCHEME = new SMHR_EMPPENSIONSCHEME();
_obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Check1;
_obj_Smhr_EMPPENSIONSCHEME.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEME_EMPID = Convert.ToInt32(rcb_Employee.SelectedValue);
dtpf = BLL.get_PensionScheme(_obj_Smhr_EMPPENSIONSCHEME);
if (dtpf.Rows.Count == 0)
{
txtgetVal.Text = string.Empty;
}
}
//if (lblPAYITEMNAME.Text == "Employer PF" || lblPAYITEMNAME.Text == "Employee PF" )
//{
// string str;
//}
//else
if (Convert.ToString(txtgetVal.Text) != string.Empty) //04042016
{
if (dt.Rows.Count > 0)
{
chkChoose.Checked = true;
}
else
{
chkChoose.Checked = false;
}
if (txtMRPID.Text == "22" || txtMRPID.Text == "23")
{
txtgetVal.Enabled = false;
}
else
{
txtgetVal.Enabled = true;
}
/*if (txtMRPID.Text == "22" || txtMRPID.Text == "23")
* {
* txtgetVal.Enabled = false;
*
* _obj_Smhr_EMPPENSIONSCHEME = new SMHR_EMPPENSIONSCHEME();
* _obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Check1;
* _obj_Smhr_EMPPENSIONSCHEME.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
* _obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEME_EMPID = Convert.ToInt32(rcb_Employee.SelectedValue);
*
* dtpf = BLL.get_PensionScheme(_obj_Smhr_EMPPENSIONSCHEME);
*
* if (dtpf.Rows.Count > 0)
* chkChoose.Checked = true;
* else
* chkChoose.Checked = false;
* }
* else
* txtgetVal.Enabled = true;*/
}
else
{
chkChoose.Checked = false;
txtgetVal.Enabled = true;
}
/*if ((lblPAYITEMNAME.Text == System.Configuration.ConfigurationSettings.AppSettings["EmployeePension"])
|| (lblPAYITEMNAME.Text == System.Configuration.ConfigurationSettings.AppSettings["EmployerPension"]))
|| {
||
|| }
||
|| if ((Convert.ToString(txtgetVal.Text) != string.Empty) || ((lblPAYITEMNAME.Text == emplPF) || (lblPAYITEMNAME.Text == emprPF)))
|| {
|| chkChoose.Checked = true;
||
|| if (((lblPAYITEMNAME.Text == System.Configuration.ConfigurationSettings.AppSettings["EmployeePension"])
|| (lblPAYITEMNAME.Text == System.Configuration.ConfigurationSettings.AppSettings["EmployerPension"])))
|| {
|| txtgetVal.Text = Convert.ToString(dtEmpPensionDetails.Rows[0]["PENSION_EMPLOYEE_VALUE"]);
|| }
|| }
|| else
|| {
|| chkChoose.Checked = false;
|| }*/
}
/*_obj_SMHR_PENSION_CONTRIBUTION = new SMHR_PENSION_CONTRIBUTION();
*
* _obj_SMHR_PENSION_CONTRIBUTION.OPERATION = operation.Available;
* _obj_SMHR_PENSION_CONTRIBUTION.LOGIN_ID = Convert.ToInt32(rcb_Employee.SelectedValue);
* _obj_SMHR_PENSION_CONTRIBUTION.PENSION_EMPTYPE = Convert.ToString(dt1.Rows[0]["EMP_EMPLOYEETYPE"]);
*
* dtEmpPensionDetails = BLL.get_PensionContribution(_obj_SMHR_PENSION_CONTRIBUTION);
*
* if (dtEmpPensionDetails.Rows.Count > 0 && RG_SalaryStruct.Items.Count > 0)
* {
* for (int k = 0; k < RG_SalaryStruct.Items.Count; k++)
* {
* CheckBox chkChoose = new CheckBox();
* Label lblPAYITEMNAME = new Label();
* TextBox txtNumber = new TextBox();
*
* chkChoose = RG_SalaryStruct.Items[k].FindControl("chk_Choose") as CheckBox;
* txtNumber = RG_SalaryStruct.Items[k].FindControl("txtNumber") as TextBox;
* lblPAYITEMNAME = RG_SalaryStruct.Items[k].FindControl("lblPAYITEMNAME") as Label;
*
* if ((lblPAYITEMNAME.Text == System.Configuration.ConfigurationSettings.AppSettings["EmployeePension"])
|| (lblPAYITEMNAME.Text == System.Configuration.ConfigurationSettings.AppSettings["EmployerPension"]))
|| //Convert.ToString(Configuration.AppSettings["EmployeePension"]))
|| {
|| chkChoose.Checked = true;
|| txtNumber.Text = Convert.ToString(dtEmpPensionDetails.Rows[0]["PENSION_EMPLOYEE_VALUE"]);
|| }
|| else
|| {
|| chkChoose.Checked = false;
|| txtNumber.Text = string.Empty;
|| }
|| }
||}*/
}
else
{
//RG_SalaryStruct.Visible = false;
rtxt_SalaryStruct.Text = string.Empty;
rtxt_Jobs.Text = string.Empty;
rtxt_Positions.Text = string.Empty;
rtxt_Basic.Text = string.Empty;
LoadEmptyData();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmemppayelements", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
return;
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
//RadComboBox RadBusinessUnit = (RadComboBox)BU1.FindControl("RadBusinessUnit");
if (!string.IsNullOrEmpty(RadBusinessUnit.SelectedItem.Text) && string.Compare(RadBusinessUnit.SelectedItem.Text, "Select", true) != 0)
{
//RadComboBox RadEmployee = (RadComboBox)BU1.FindControl("RadEmployee");
if (string.IsNullOrEmpty(RadEmployee.SelectedItem.Text) || string.Compare(RadEmployee.SelectedItem.Text, "Select", true) == 0)
{
BLL.ShowMessage(this, "Please select Employee");
return;
}
}
else
{
BLL.ShowMessage(this, "Please select Business Unit");
return;
}
_obj_Smhr_EMPPENSIONSCHEME = new SMHR_EMPPENSIONSCHEME();
//_obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEME_EMPID = BU1.EmployeeID;
_obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEME_EMPID = Convert.ToInt32(RadEmployee.SelectedValue);
_obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEME_JOINDATE = (DateTime)rdpDateofJoiningScheme.SelectedDate;
_obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEME_PENSIONID = Convert.ToString(radPensionIDNo.Text);
_obj_Smhr_EMPPENSIONSCHEME.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_EMPPENSIONSCHEME.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_EMPPENSIONSCHEME.CREATEDDATE = DateTime.Now;
_obj_Smhr_EMPPENSIONSCHEME.LASTMDFDATE = DateTime.Now;
_obj_Smhr_EMPPENSIONSCHEME.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
//To check if Pension joining date is before Employee_DOJ
_obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Check;
DateTime dtEmpDOJ = BLL.get_EmployeeDoj(_obj_Smhr_EMPPENSIONSCHEME);
if (Convert.ToDateTime(rdpDateofJoiningScheme.SelectedDate) < dtEmpDOJ)
{
BLL.ShowMessage(this, "Provident Fund Scheme Joining Date Must Be Greater Than Employee DOJ");
return;
}
//To check if pensionID already exists
_obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Check1;
bool isPensionIDExists = BLL.get_PensionID(_obj_Smhr_EMPPENSIONSCHEME);
if (isPensionIDExists)
{
BLL.ShowMessage(this, "Provident Fund ID already exists.");
return;
}
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
//_obj_Smhr_EMPPENSIONSCHEME.EMPPENSIONSCHEMEID = Convert.ToInt32(lblSchemeID.Text);
_obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Update;
if (BLL.set_PensionScheme(_obj_Smhr_EMPPENSIONSCHEME))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
break;
case "BTN_SAVE":
_obj_Smhr_EMPPENSIONSCHEME.OPERATION = operation.Insert;
if (BLL.set_PensionScheme(_obj_Smhr_EMPPENSIONSCHEME))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_CY_page.SelectedIndex = 0;
LoadGrid();
Rg_MedicalClaim.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_employeescheme", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
