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