protected void LoadMainGrid() { try { SMHR_ESIIMPORT _obj_SMHR_ESIIMPORT = new SMHR_ESIIMPORT(); _obj_SMHR_ESIIMPORT.Mode = 1; _obj_SMHR_ESIIMPORT.ESIIMPORT_ORGID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = BLL.get_ESIimport(_obj_SMHR_ESIIMPORT); if (dt.Rows.Count != 0) { Rg_ESIIMPORT.DataSource = dt; Rg_ESIIMPORT.DataBind(); } else { DataTable dt1 = new DataTable(); Rg_ESIIMPORT.DataSource = dt1; Rg_ESIIMPORT.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_Save_Click(object sender, EventArgs e) { try { for (int i = 0; i < rg_importchild.Items.Count; i++) { Label LBLEMPLOYEE; LBLEMPLOYEE = rg_importchild.Items[i].FindControl("lbl_EMPLOYEE_NAME") as Label; Label LBLIPNO; LBLIPNO = rg_importchild.Items[i].FindControl("lbl_IMPORTCHILD_IPNUMBER") as Label; Label LBLIPNAME; LBLIPNAME = rg_importchild.Items[i].FindControl("lbl_IMPORTCHILD_IPNAME") as Label; Label LBLPRESENTDAYS; LBLPRESENTDAYS = rg_importchild.Items[i].FindControl("lbl_IMPORTCHILD_presentdays") as Label; Label LBLTOTALAMOUNT; LBLTOTALAMOUNT = rg_importchild.Items[i].FindControl("lbl_IMPORTCHILD_TOTALAMOUNT") as Label; Label LBLREASONCODE; LBLREASONCODE = rg_importchild.Items[i].FindControl("lbl_IMPORTCHILD_reasoncode") as Label; SMHR_ESIIMPORT _obj_SMHR_ESIIMPORT = new SMHR_ESIIMPORT(); _obj_SMHR_ESIIMPORT.Mode = 3; _obj_SMHR_ESIIMPORT.ESIIMPORT_BUID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value); _obj_SMHR_ESIIMPORT.ESIIMPORT_ORGID = Convert.ToInt32(Session["org_id"]); _obj_SMHR_ESIIMPORT.ESIIMPORT_FINANCIAL_PERIOD = Convert.ToInt32(RCM_FINANCIALPERIOD.SelectedItem.Value); _obj_SMHR_ESIIMPORT.ESIIMPORT_PERIDEMLEMENTID = Convert.ToInt32(rcm_fin_elem.SelectedItem.Value); _obj_SMHR_ESIIMPORT.ESIIMPORT_EMPNAME = Convert.ToString(LBLEMPLOYEE.Text); _obj_SMHR_ESIIMPORT.ESIIMPORT_IPNO = Convert.ToString(LBLIPNO.Text); _obj_SMHR_ESIIMPORT.ESIIMPORT_IPNAME = Convert.ToString(LBLIPNAME.Text); _obj_SMHR_ESIIMPORT.ESIIMPORT_PRESENTDAYS = Convert.ToInt32(LBLPRESENTDAYS.Text); _obj_SMHR_ESIIMPORT.ESIIMPORT_TOTALAMOUNT = Convert.ToString(LBLTOTALAMOUNT.Text); _obj_SMHR_ESIIMPORT.ESIIMPORT_REASONCODE = Convert.ToInt32(LBLREASONCODE.Text); bool status = BLL.set_ESIimport(_obj_SMHR_ESIIMPORT); if (status == true) { BLL.ShowMessage(this, "Record Inserted Successfully"); Rm_ESIIMPORT_PAGE.SelectedIndex = 0; LoadMainGrid(); lbl_det.Visible = false; lbl_esiimport.Visible = true; return; } } } 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"); } }
/// <summary> ///IN THIS data binding from database to datatable binding to radgrid /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void Rg_ESIIMPORT_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { try { SMHR_ESIIMPORT _obj_SMHR_ESIIMPORT = new SMHR_ESIIMPORT(); _obj_SMHR_ESIIMPORT.Mode = 1; _obj_SMHR_ESIIMPORT.ESIIMPORT_ORGID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = BLL.get_ESIimport(_obj_SMHR_ESIIMPORT); if (dt.Rows.Count != 0) { Rg_ESIIMPORT.DataSource = dt; } } 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"); } }
/// <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_DOWNLOAD_Command(object sender, CommandEventArgs e) { try { LoadCombos(); SMHR_ESIIMPORT _obj_SMHR_ESIIMPORT = new SMHR_ESIIMPORT(); _obj_SMHR_ESIIMPORT.Mode = 2; _obj_SMHR_ESIIMPORT.ESIIMPORT_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); DataTable DT = BLL.get_ESIimport(_obj_SMHR_ESIIMPORT); if (DT.Rows.Count != 0) { rcmb_BUI.SelectedIndex = rcmb_BUI.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["ESIIMPORT_BUID"])); RCM_FINANCIALPERIOD.SelectedIndex = RCM_FINANCIALPERIOD.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["ESIIMPORT_FINANCIAL_PERIOD"])); SMHR_PAYROLL _obj_smhr_payroll = new SMHR_PAYROLL(); _obj_smhr_payroll.PERIODDTLID = Convert.ToInt32(RCM_FINANCIALPERIOD.SelectedValue); _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")); } rcm_fin_elem.SelectedIndex = rcm_fin_elem.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["ESIIMPORT_PERIDEMLEMENTID"])); rg_importchild.DataSource = DT; rg_importchild.DataBind(); 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"; } } rcm_fin_elem.Enabled = false; RCM_FINANCIALPERIOD.Enabled = false; btn_Save.Visible = false; lbl_esiimport.Visible = false; lbl_det.Visible = true; rcmb_BUI.Enabled = false; Rm_ESIIMPORT_PAGE.SelectedIndex = 1; if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { BTN_DOWNLOAD.Visible = false; } else { BTN_DOWNLOAD.Visible = true; } } } 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"); } }