private void LoadEmployees()
{
try
{
_obj_Smhr_ESIMASTER = new SMHR_ESIMASTER();
_obj_Smhr_ESIMASTER.Mode = 6;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_BUID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_ORGID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (dt.Rows.Count != 0)
{
rcm_employee.DataSource = dt;
rcm_employee.DataValueField = "EMP_ID";
rcm_employee.DataTextField = "EMPLOYEE_NAME";
rcm_employee.DataBind();
rcm_employee.Items.Insert(0, new RadComboBoxItem("Select"));
}
else
{
DataTable dt_Details = new DataTable();
rcm_employee.DataSource = dt_Details;
rcm_employee.DataBind();
rcm_employee.Items.Insert(0, new RadComboBoxItem("Select"));
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "DOWNLOADESI", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void LoadGrid()
{
try
{
_obj_Smhr_ESIMASTER = new SMHR_ESIMASTER();
_obj_Smhr_ESIMASTER.Mode = 1;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_ORGID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (dt.Rows.Count != 0)
{
Rg_ESI.DataSource = dt;
Rg_ESI.DataBind();
}
else
{
DataTable dt1 = new DataTable();
Rg_ESI.DataSource = dt1;
Rg_ESI.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "DOWNLOADESI", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadchildGrid()
{
try
{
SMHR_ESIMASTER _obj_Smhr_ESIMASTER = new SMHR_ESIMASTER();
_obj_Smhr_ESIMASTER.Mode = 7;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_BUID = Convert.ToInt32(rcmb_Busniessunit.SelectedItem.Value);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_CREATEDBY = Convert.ToInt32(rcmb_Perioddtls.SelectedValue);
dt_Information = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (dt_Information.Rows.Count != 0)
{
btn_Save.Visible = true;
btn_Finalise.Visible = true;
rg_Child.DataSource = dt_Information;
rg_Child.DataBind();
}
else
{
btn_Save.Visible = false;
btn_Finalise.Visible = false;
rg_Child.DataSource = dt_Information;
rg_Child.DataBind();
}
// checking whether particular period is finalised or not.
_obj_Smhr_ESIMASTER.Mode = 10;
_obj_Smhr_ESIMASTER.BUID = Convert.ToInt32(rcmb_Busniessunit.SelectedValue);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_MODIFIEDBY = Convert.ToInt32(rcmb_Perioddtls.SelectedValue);
dt_Information = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (dt_Information.Rows.Count > 0)
{
if (dt_Information.Rows[0][0].ToString() == "1")
{
BLL.ShowMessage(this, "the Selected Period is Finalised");
btn_Finalise.Visible = false;
btn_Save.Visible = false;
_obj_SMHR_ESIIMPORT.Mode = 2;
_obj_SMHR_ESIIMPORT.ESIIMPORT_PERIDEMLEMENTID = Convert.ToInt32(rcmb_Perioddtls.SelectedValue);
dt_Information = BLL.get_ESIimport(_obj_SMHR_ESIIMPORT);
rg_Child.DataSource = dt_Information;
rg_Child.DataBind();
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Esiexport", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
///IN THIS BASED ON Project_ID(COMMANDARGUMENT) ALL DATA WILL BE TAKEN TO DATATABLE THEN WE CAN BIND TO INDIVIDUAL FIELDS
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void lnk_edit_Command(object sender, CommandEventArgs e)
{
try
{
LoadCombos();
clearControls();
btn_Save.Visible = false;
btn_Cancel.Visible = true;
rcmb_BUI.Enabled = false;
_obj_Smhr_ESIMASTER = new SMHR_ESIMASTER();
_obj_Smhr_ESIMASTER.Mode = 2;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
DataTable DT = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (DT.Rows.Count != 0)
{
lbl_ESIDUMMYID.Text = Convert.ToString(DT.Rows[0]["SMHR_ESI_MASTER_ID"]);
rcmb_BUI.SelectedIndex = rcmb_BUI.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["SMHR_ESI_MASTER_BUID"]));
LoadEmployees();
rcm_employee.SelectedIndex = rcm_employee.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["SMHR_ESI_MASTER_EMPID"]));
RNT_IPNUMBER.Text = Convert.ToString(DT.Rows[0]["SMHR_ESI_MASTER_IPNO"]);
rtxt_IPName.Text = Convert.ToString(DT.Rows[0]["SMHR_ESI_MASTER_IPNAME"]);
//chk_Status.Checked = Convert.ToBoolean(DT.Rows[0]["SMHR_ESI_MASTER_STATUS"]);
int Status = Convert.ToInt32(DT.Rows[0]["SMHR_ESI_MASTER_STATUS"]);
rcmb_Status.SelectedIndex = rcmb_Status.FindItemIndexByValue(Convert.ToString(Status));
Is_Active = Convert.ToBoolean(Status);
lbl_ESI1.Visible = false;
lbl_ESI.Visible = true;
Rm_ESI_PAGE.SelectedIndex = 1;
}
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_update.Visible = false;
}
else
{
btn_update.Visible = true;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "DOWNLOADESI", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void LoadchildGrid()
{
try
{
SMHR_ESIMASTER _obj_Smhr_ESIMASTER = new SMHR_ESIMASTER();
_obj_Smhr_ESIMASTER.Mode = 7;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_BUID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value);
//_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_BUID = 0;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_CREATEDBY = Convert.ToInt32(rcm_fin_elem.SelectedItem.Value);
DataTable dt = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (dt.Rows.Count != 0)
{
btn_Save.Visible = true;
rg_importchild.DataSource = dt;
BTN_DOWNLOAD.Visible = true;
rg_importchild.DataBind();
}
else
{
DataTable dt1 = new DataTable();
btn_Save.Visible = false;
BTN_DOWNLOAD.Visible = false;
rg_importchild.DataSource = dt1;
rg_importchild.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_esiimport", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_update_Click(object sender, EventArgs e)
{
try
{
// checking whether ip number consists of 10 digits or not
if (RNT_IPNUMBER.Text.Length == 10)
{
_obj_Smhr_ESIMASTER = new SMHR_ESIMASTER();
_obj_Smhr_ESIMASTER.Mode = 8;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_IPNO = Convert.ToString(RNT_IPNUMBER.Text);
// as there should not be duplicate of ip number even for different organisations we are not passing orgid here
DataTable dt1 = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (dt1.Rows.Count > 0)
{
if (dt1.Rows[0][0].ToString() == "1")
{
// CHECKING IP NUMBER EXISTS FOR THE SAME EMPLOYEE OR NOT
if (dt1.Rows[0][1].ToString() != Convert.ToString(rcm_employee.SelectedValue))
{
BLL.ShowMessage(this, "IP Number is already in Use:");
return;
}
}
}
// SOME THING HE HAS MODIFIED
int Status = Convert.ToInt32(rcmb_Status.SelectedItem.Value);
if (Is_Active != Convert.ToBoolean(Status))
{
// CHECKING FOR THE EXISTANCE OF EMPLOYEE WITH SOME OTHER IP IN ACTIVE STATE
if (Status == 1)
{
_obj_Smhr_ESIMASTER.Mode = 9;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_EMPID = Convert.ToInt32(rcm_employee.SelectedItem.Value);
dt1 = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (dt1.Rows.Count > 0)
{
if (dt1.Rows[0][0].ToString() == "1")
{
BLL.ShowMessage(this, "this Employee is having another IP which is in Active State");
return;
}
}
}
}
_obj_Smhr_ESIMASTER = new SMHR_ESIMASTER();
_obj_Smhr_ESIMASTER.Mode = 4;
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_ID = Convert.ToInt32(lbl_ESIDUMMYID.Text);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_BUID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_EMPID = Convert.ToInt32(rcm_employee.SelectedValue);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_EMPID = Convert.ToInt32(rcm_employee.SelectedItem.Value);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_IPNO = Convert.ToString(RNT_IPNUMBER.Text);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_IPNAME = BLL.ReplaceQuote(Convert.ToString(rtxt_IPName.Text));
_obj_Smhr_ESIMASTER.HR_MASTER_ISDELETED = Convert.ToBoolean(Status);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_MODIFIEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_MODIFIEDDATE = DateTime.Now;
bool status = BLL.set_ESIMASTER(_obj_Smhr_ESIMASTER);
if (status == true)
{
BLL.ShowMessage(this, "Record Updated Successfully");
LoadGrid();
lbl_ESI1.Visible = true;
lbl_ESI.Visible = false;
Rm_ESI_PAGE.SelectedIndex = 0;
return;
}
}
else
{
BLL.ShowMessage(this, "Ip Number Must be a Ten Digit Number");
RNT_IPNUMBER.Focus();
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "DOWNLOADESI", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rg_importchild_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
SMHR_PAYROLL _obj_smhr_payroll = new SMHR_PAYROLL();
if (RCM_FINANCIALPERIOD.SelectedItem.Value != "")
{
_obj_smhr_payroll.PERIODDTLID = Convert.ToInt32(RCM_FINANCIALPERIOD.SelectedItem.Value);
}
else
{
_obj_smhr_payroll.PERIODDTLID = 0;
}
_obj_smhr_payroll.MODE = 11;
DataTable dt_Details = new DataTable();
dt_Details = BLL.get_payrolltrans(_obj_smhr_payroll);
if (dt_Details.Rows.Count != 0)
{
//rcm_fin_elem.DataSource = dt_Details;
//rcm_fin_elem.DataValueField = "PRDDTL_ID";
//rcm_fin_elem.DataTextField = "PRDDTL_NAME";
//rcm_fin_elem.DataBind();
//rcm_fin_elem.Items.Insert(0, new RadComboBoxItem("Select"));
}
else
{
DataTable dt_Details2 = new DataTable();
rcm_fin_elem.DataSource = dt_Details2;
rcm_fin_elem.DataBind();
rcm_fin_elem.Items.Insert(0, new RadComboBoxItem("Select"));
}
SMHR_ESIMASTER _obj_Smhr_ESIMASTER = new SMHR_ESIMASTER();
_obj_Smhr_ESIMASTER.Mode = 7;
if (rcmb_BUI.SelectedItem.Value != "")
{
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_BUID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value);
}
else
{
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_BUID = 0;
}
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_ORGID = Convert.ToInt32(Session["ORG_ID"]);
if (rcm_fin_elem.SelectedItem.Value != "")
{
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_CREATEDBY = Convert.ToInt32(rcm_fin_elem.SelectedItem.Value);
}
else
{
_obj_Smhr_ESIMASTER.SMHR_ESI_MASTER_CREATEDBY = 0;
}
DataTable dt = BLL.get_ESIMASTER(_obj_Smhr_ESIMASTER);
if (dt.Rows.Count != 0)
{
//btn_Save.Visible = true;
rg_importchild.DataSource = dt;
for (int i = 0; i < rg_importchild.Items.Count; i++)
{
Label LBLAMOUNT;
LBLAMOUNT = rg_importchild.Items[i].FindControl("lbl_IMPORTCHILD_TOTALAMOUNT") as Label;
Label LBLREASONCODE;
LBLREASONCODE = rg_importchild.Items[i].FindControl("lbl_IMPORTCHILD_reasoncode") as Label;
if (LBLAMOUNT.Text == "0")
{
LBLREASONCODE.Text = "1";
}
else
{
LBLREASONCODE.Text = "0";
}
}
return;
//BTN_DOWNLOAD.Visible = true;
}
else
{
DataTable dt1 = new DataTable();
btn_Save.Visible = false;
BTN_DOWNLOAD.Visible = false;
rg_importchild.DataSource = dt1;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_esiimport", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
