private void LoadData()
{
try
{
_obj_Med_Scheme = new SMHR_EMP_MED_SCHEME();
_obj_Med_Scheme.Mode = 1;
_obj_Med_Scheme.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_Emp_Med_scheme(_obj_Med_Scheme);
RG_MED_SCHEME.DataSource = dt;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Emp_Med_Scheme", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
return;
}
}
private void Load_Med_Details()
{
try
{
_obj_Med_Scheme = new SMHR_EMP_MED_SCHEME();
_obj_Med_Scheme.Mode = 1;
_obj_Med_Scheme.SMHR_MED_ID = Convert.ToInt32(lbl_ID.Text);
//_obj_Med_Scheme.SMHR_MED_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);AS IT DOESN'T HAVE ANY COLUMN RELATED TO ORGANISATION
DataTable dt = BLL.get_Emp_Med_scheme_Details(_obj_Med_Scheme);
RG_MED_DETAILS.DataSource = dt;
RG_MED_DETAILS.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Emp_Med_Scheme", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
return;
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
lbl_ID.Text = Convert.ToString(e.CommandArgument);
_obj_Med_Scheme = new SMHR_EMP_MED_SCHEME();
_obj_Med_Scheme.Mode = 2;
_obj_Med_Scheme.SMHR_MED_ID = Convert.ToInt32(lbl_ID.Text);
_obj_Med_Scheme.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_Emp_Med_scheme(_obj_Med_Scheme);
if (dt.Rows.Count != 0)
{
LoadCombos();
ddl_BusinessUnit.SelectedIndex = ddl_BusinessUnit.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["SMHR_MED_BU_ID"]));
//ddl_BusinessUnit_SelectedIndexChanged(null, null);
LoadEmployees_Edit();
ddl_Employee.SelectedIndex = ddl_Employee.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["SMHR_MED_EMP_ID"]));
ddl_Period.SelectedIndex = ddl_Period.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["SMHR_MED_PERIOD_ID"]));
txt_IP_Av_Amt.Value = Convert.ToDouble(dt.Rows[0]["SMHR_MED_IP_AV_AMT"]);
txt_OP_Av_Amt.Value = Convert.ToDouble(dt.Rows[0]["SMHR_MED_OP_AV_AMT"]);
Load_Med_Details();
}
RMP_MED_SCHEME.SelectedIndex = 1;
ddl_BusinessUnit.Enabled = false;
ddl_Employee.Enabled = false;
ddl_Period.Enabled = false;
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Submit.Visible = false;
}
else
{
btn_Submit.Visible = true;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Emp_Med_Scheme", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
return;
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
try
{
if (lbl_ID.Text == string.Empty)
{
_obj_Med_Scheme = new SMHR_EMP_MED_SCHEME();
_obj_Med_Scheme.Mode = 5;
_obj_Med_Scheme.SMHR_MED_BU_ID = Convert.ToInt32(ddl_BusinessUnit.SelectedValue);
_obj_Med_Scheme.SMHR_MED_EMP_ID = Convert.ToInt32(ddl_Employee.SelectedValue);
_obj_Med_Scheme.SMHR_MED_PERIOD_ID = Convert.ToInt32(ddl_Period.SelectedValue);
_obj_Med_Scheme.SMHR_MED_IP_AV_AMT = Convert.ToDouble(txt_IP_Av_Amt.Value);
_obj_Med_Scheme.SMHR_MED_OP_AV_AMT = Convert.ToDouble(txt_OP_Av_Amt.Value);
_obj_Med_Scheme.SMHR_MED_CREATEDBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_Med_Scheme.SMHR_MED_CREATEDDATE = DateTime.Now;
_obj_Med_Scheme.SMHR_MED_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_Emp_Med_scheme(_obj_Med_Scheme);
if (dt.Rows.Count == 0)
{
_obj_Med_Scheme.Mode = 3;
bool status = BLL.set_Emp_Med_Scheme(_obj_Med_Scheme);
if (status == true)
{
BLL.ShowMessage(this, "Employee Medical Scheme Details Added Successfully");
LoadData();
RG_MED_SCHEME.DataBind();
RMP_MED_SCHEME.SelectedIndex = 0;
return;
}
else
{
BLL.ShowMessage(this, "An Error Occured while performing the request");
return;
}
}
else
{
BLL.ShowMessage(this, "Medical Scheme Details of Employee for this period is already defined");
return;
}
}
else
{
SMHR_EMPLOYEE _obj_smhr_employee = new SMHR_EMPLOYEE();
_obj_smhr_employee.OPERATION = operation.Select;
_obj_smhr_employee.EMP_ID = Convert.ToInt32(ddl_Employee.SelectedItem.Value);
//dt_Details = new DataTable();
_obj_smhr_employee.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_Employee(_obj_smhr_employee);
if (Convert.ToInt32(dt_Details.Rows[0]["EMP_STATUS"]) == 1)
{
BLL.ShowMessage(this, "Employee is Resigned.You can not update the record.");
return;
}
else if (Convert.ToInt32(dt_Details.Rows[0]["EMP_STATUS"]) == 2)
{
BLL.ShowMessage(this, "Employee is Relieved.You can not update the record.");
return;
}
else if (Convert.ToInt32(dt_Details.Rows[0]["EMP_STATUS"]) == 3)
{
BLL.ShowMessage(this, "Employee is Rehired.You can not update the record.");
return;
}
else
{
_obj_Med_Scheme = new SMHR_EMP_MED_SCHEME();
_obj_Med_Scheme.Mode = 4;
_obj_Med_Scheme.SMHR_MED_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Med_Scheme.SMHR_MED_BU_ID = Convert.ToInt32(ddl_BusinessUnit.SelectedValue);
_obj_Med_Scheme.SMHR_MED_EMP_ID = Convert.ToInt32(ddl_Employee.SelectedValue);
_obj_Med_Scheme.SMHR_MED_PERIOD_ID = Convert.ToInt32(ddl_Period.SelectedValue);
_obj_Med_Scheme.SMHR_MED_IP_AV_AMT = Convert.ToDouble(txt_IP_Av_Amt.Value);
_obj_Med_Scheme.SMHR_MED_OP_AV_AMT = Convert.ToDouble(txt_OP_Av_Amt.Value);
_obj_Med_Scheme.SMHR_MED_LASTMDFBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_Med_Scheme.SMHR_MED_ID = Convert.ToInt32(lbl_ID.Text);
_obj_Med_Scheme.SMHR_MED_LASTMDFDATE = DateTime.Now;
bool status = BLL.set_Emp_Med_Scheme(_obj_Med_Scheme);
if (status == true)
{
BLL.ShowMessage(this, "Employee Medical Scheme Details Updated Successfully");
LoadData();
RG_MED_SCHEME.DataBind();
RMP_MED_SCHEME.SelectedIndex = 0;
return;
}
else
{
BLL.ShowMessage(this, "An Error Occured while performing the request");
return;
}
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Emp_Med_Scheme", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
return;
}
}
