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