//public void loadCountryID()
//{
// _obj_smhr_Tds = new SMHR_TDS();
// _obj_smhr_Tds.TDS_BUSINESSUNIT = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
// _obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
// _obj_smhr_Tds.OPERATION = operation.Check;
// DataTable dt_CountryID = BLL.get_Tds(_obj_smhr_Tds);
// Session["TDS_COUNTRY_ID"] = Convert.ToInt32(dt_CountryID.Rows[0][0]);
//}
public void loadGrid()
{
try
{
_obj_smhr_Tds = new SMHR_TDS();
_obj_smhr_Tds.OPERATION = operation.Select;
_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_GridBind = BLL.get_Tds(_obj_smhr_Tds);
rg_Main.DataSource = dt_GridBind;
//rg_Main.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_tds", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_BusinessUnit_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
_obj_smhr_Tds = new SMHR_TDS();
_obj_smhr_Tds.TDS_BUSINESSUNIT = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds.OPERATION = operation.Check;
DataTable dt_LocalisationID = BLL.get_Tds(_obj_smhr_Tds);
Session["TDS_LOCALISATION_ID"] = Convert.ToInt32(dt_LocalisationID.Rows[0][0]);
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_tds", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
rmp_Main.SelectedIndex = 1;
btn_Save.Visible = false;
btn_Update.Visible = true;
rcmb_BusinessUnit.Enabled = false;
//chk_TdsStatus.Checked = false;
rtxt_TdsName.Enabled = false;
loadDropdown();
_obj_smhr_Tds = new SMHR_TDS();
_obj_smhr_Tds.OPERATION = operation.Validate;
//_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds.TDS_ID = Convert.ToInt32(e.CommandArgument);
Session["TDS_ID"] = Convert.ToString(e.CommandArgument);
//ViewState["TDS_ID"] = Convert.ToInt32(e.CommandArgument);
DataTable dt = BLL.get_Tds(_obj_smhr_Tds);
rcmb_BusinessUnit.SelectedIndex = rcmb_BusinessUnit.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["BUSINESSUNIT_ID"]));
rtxt_TdsName.Text = Convert.ToString(dt.Rows[0]["TDS_NAME"]);
rtxt_TdsDesc.Text = Convert.ToString(dt.Rows[0]["TDS_DESC"]);
if (Convert.ToString(dt.Rows[0]["TDS_STATUS"]) != null)
{
int Status = Convert.ToInt32(dt.Rows[0]["TDS_STATUS"]);
rcmb_Status.SelectedIndex = rcmb_Status.FindItemIndexByValue(Convert.ToString(Status));
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_tds", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
btn_Save.Visible = false;
btn_Update.Visible = true;
loadBusinessUnit();
loadPeriod();
//loadSlabName();
//rcmb_BusinessUnit.Enabled = false;
rcmb_tdsname.Enabled = false;
rcmb_Slab.Enabled = false;
rcmb_Period.Enabled = false;
rmp_Main.SelectedIndex = 1;
Session["str_Params_Id"] = Convert.ToString(e.CommandArgument);
string str_Params_Id = Convert.ToString(Session["str_Params_Id"]);
_obj_smhr_Tds_Params = new SMHR_TDS_PARAMS();
_obj_smhr_Tds_Params.OPERATION = operation.Validate1;
_obj_smhr_Tds_Params.TDS_PARAMS_ID = Convert.ToInt32(str_Params_Id);
DataTable dt_ComboBox = BLL.get_TDS_PARAMS(_obj_smhr_Tds_Params);
if (dt_ComboBox.Rows.Count != 0)
{
//rcmb_BusinessUnit.SelectedIndex = rcmb_BusinessUnit.Items.FindItemIndexByValue(Convert.ToString(dt_ComboBox.Rows[0]["BUSINESSUNIT_ID"]));
_obj_smhr_Tds = new SMHR_TDS();
_obj_smhr_Tds.TDS_BUSINESSUNIT = Convert.ToInt32(dt_ComboBox.Rows[0]["BUSINESSUNIT_ID"]);
_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds.OPERATION = operation.Check;
DataTable dt_LocalisationID = BLL.get_Tds(_obj_smhr_Tds);
Session["TDS_LOCALISATION_ID"] = Convert.ToInt32(dt_LocalisationID.Rows[0][0]);
string str_Localisation_Id = Convert.ToString(Session["TDS_LOCALISATION_ID"]);
rcmb_tdsname.SelectedIndex = rcmb_tdsname.Items.FindItemIndexByValue(Convert.ToString(dt_ComboBox.Rows[0]["TDS_ID"]));
_obj_smhr_Tds_Slab = new SMHR_TDS_SLAB();
_obj_smhr_Tds_Slab.OPERATION = operation.Check1;
_obj_smhr_Tds_Slab.TDS_SLAB_LOCALISATION_ID = Convert.ToInt32(str_Localisation_Id);
_obj_smhr_Tds_Slab.TDS_SLAB_BUSINESSUNIT_ID = Convert.ToInt32(dt_ComboBox.Rows[0]["BUSINESSUNIT_ID"]);
_obj_smhr_Tds_Slab.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds_Slab.TDS_SLAB_TDS_ID = Convert.ToInt32(rcmb_tdsname.SelectedItem.Value);
DataTable dt_SlabName = BLL.get_TdsSlab(_obj_smhr_Tds_Slab);
rcmb_Slab.DataSource = dt_SlabName;
rcmb_Slab.DataTextField = "TDS_SLAB_NAME";
rcmb_Slab.DataValueField = "TDS_SLAB_ID";
rcmb_Slab.DataBind();
rcmb_Slab.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
rcmb_Slab.SelectedIndex = rcmb_Slab.Items.FindItemIndexByValue(Convert.ToString(dt_ComboBox.Rows[0]["TDS_SLAB_ID"]));
rcmb_tdsname.SelectedIndex = rcmb_tdsname.Items.FindItemIndexByValue(Convert.ToString(dt_ComboBox.Rows[0]["TDS_ID"]));
if (dt_ComboBox.Rows[0]["TDS_PARAMS_PERIOD_ID"] != System.DBNull.Value)
{
rcmb_Period.SelectedIndex = rcmb_Period.Items.FindItemIndexByValue(Convert.ToString(dt_ComboBox.Rows[0]["TDS_PARAMS_PERIOD_ID"]));
}
}
_obj_smhr_Tds_Params = new SMHR_TDS_PARAMS();
_obj_smhr_Tds_Params.OPERATION = operation.Empty;
_obj_smhr_Tds_Params.TDS_PARAMS_ID = Convert.ToInt32(str_Params_Id);
DataTable dt_Params = BLL.get_TDS_PARAMS(_obj_smhr_Tds_Params);
if (dt_Params.Rows.Count != 0)
{
rntxt_TdsFromVal.Text = Convert.ToString(dt_Params.Rows[0]["TDS_PARAMS_FROMVAL"]);
rntxt_TdsToVal.Text = Convert.ToString(dt_Params.Rows[0]["TDS_PARAMS_TOVAL"]);
rntxt_TdsVal.Text = Convert.ToString(dt_Params.Rows[0]["TDS_PARAMS_VALUE"]);
rntxt_TdsPercent.Text = Convert.ToString(dt_Params.Rows[0]["TDS_PARAMS_PERCENT"]);
//rcmb_Period.SelectedIndex = rcmb_Period.Items.FindItemIndexByValue(Convert.ToString(dt_Params.Rows[0]["PERIOD_ID"]));
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Tds_Params", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
//protected void rcmb_BusinessUnit_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
//{
// try
// {
// _obj_smhr_Tds_Slab = new SMHR_TDS_SLAB();
// _obj_smhr_Tds_Slab.OPERATION = operation.Check;
// _obj_smhr_Tds_Slab.TDS_SLAB_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
// _obj_smhr_Tds_Slab.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
// //_obj_smhr_Tds_Slab.TDS_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
// DataTable dt_Tds_Id = BLL.get_TdsSlab(_obj_smhr_Tds_Slab);
// if (dt_Tds_Id.Rows.Count > 0)
// {
// Session["TDS_ID"] = Convert.ToString(dt_Tds_Id.Rows[0][0]);
// load_Localisation_Id();
// }
// }
// catch (Exception ex)
// {
// SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TdsSlab", ex.StackTrace, DateTime.Now);
// Response.Redirect("~/Frm_ErrorPage.aspx");
// }
//}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
string str_Localisation = Convert.ToString(Session["TDS_LOCALISATION_ID"]);
_obj_smhr_Tds_Slab = new SMHR_TDS_SLAB();
if (rtxt_TdsSlabName.Text == string.Empty)
{
_obj_smhr_Tds_Slab.TDS_SLAB_NAME = Convert.ToString(rcmbSlab.SelectedItem.Text.Replace("'", "''"));
_obj_smhr_Tds_Slab.TDS_SLAB_HR_ID = Convert.ToInt32(rcmbSlab.SelectedValue);
}
else
{
_obj_smhr_Tds_Slab.TDS_SLAB_NAME = Convert.ToString(rtxt_TdsSlabName.Text.Replace("'", "''"));
}
_obj_smhr_Tds_Slab.TDS_SLAB_DESC = Convert.ToString(rtxt_TdsSlabDesc.Text.Replace("'", "''"));
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
//_obj_smhr_Tds_Slab.TDS_SLAB_TDS_ID = Convert.ToInt32(Session["TDS_ID"]);
//_obj_smhr_Tds_Slab.TDS_SLAB_ID = Convert.ToInt32(rcmb_tdsname.SelectedItem.Value);//Convert.ToInt32(Session["TDS_SLAB_ID"]);
_obj_smhr_Tds_Slab.TDS_SLAB_ID = Convert.ToInt32(Session["TDS_SLAB_ID"]);
_obj_smhr_Tds_Slab.OPERATION = operation.Update;
if (BLL.set_TdsSlab(_obj_smhr_Tds_Slab))
{
BLL.ShowMessage(this, "Record Updated Successfully");
rmp_Main.SelectedIndex = 0;
}
break;
case "BTN_SAVE":
_obj_smhr_Tds = new SMHR_TDS();
_obj_smhr_Tds.OPERATION = operation.Empty;
//_obj_smhr_Tds.TDS_BUSINESSUNIT = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
_obj_smhr_Tds.TDS_ID = Convert.ToInt32(rcmb_tdsname.SelectedItem.Value);
_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Count = BLL.get_Tds(_obj_smhr_Tds);
if (Convert.ToInt32(dt_Count.Rows[0][0]) == 0)
{
BLL.ShowMessage(this, "TDS Locale not created for this Businessunit");
return;
}
_obj_smhr_Tds_Slab.OPERATION = operation.Empty1;
_obj_smhr_Tds_Slab.TDS_SLAB_TDS_ID = Convert.ToInt32(rcmb_tdsname.SelectedItem.Value); //Convert.ToInt32(Session["TDS_ID"]);
_obj_smhr_Tds_Slab.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_TdsSlab(_obj_smhr_Tds_Slab);
if (dt.Rows.Count > 0)
{
if (Convert.ToInt32(dt.Rows[0]["COUNT"]) != 0)
{
BLL.ShowMessage(this, "TDS Slab Name Already Exists for this TDS");
return;
}
}
_obj_smhr_Tds_Slab.TDS_SLAB_LOCALISATION_ID = Convert.ToInt32(Session["TDS_LOCALISATION_ID"]); //Convert.ToInt32(str_Localisation);
_obj_smhr_Tds_Slab.TDS_SLAB_BUSINESSUNIT_ID = Convert.ToInt32(Session["TDS_BU_ID"]);
_obj_smhr_Tds_Slab.TDS_SLAB_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds_Slab.OPERATION = operation.Insert;
if (BLL.set_TdsSlab(_obj_smhr_Tds_Slab))
{
BLL.ShowMessage(this, "record inserted successfully");
}
break;
default:
break;
}
rmp_Main.SelectedIndex = 0;
loadGrid();
rg_Main.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TdsSlab", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_smhr_Tds = new SMHR_TDS();
_obj_smhr_Tds.TDS_NAME = Convert.ToString(rtxt_TdsName.Text.Replace("'", "''"));
_obj_smhr_Tds.TDS_DESC = Convert.ToString(rtxt_TdsDesc.Text.Replace("'", "''"));
_obj_smhr_Tds.TDS_BUSINESSUNIT = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
//_obj_smhr_Tds.TDS_ID = Convert.ToInt32(ViewState["TD_ID"]);
_obj_smhr_Tds.TDS_ID = Convert.ToInt32(Session["TDS_ID"]);
//if (chk_TdsStatus.Checked)
//{
// _obj_smhr_Tds.TDS_STATUS = true;
//}
//else
//{
// _obj_smhr_Tds.TDS_STATUS = false;
//}
int Status = Convert.ToInt32(rcmb_Status.SelectedItem.Value);
_obj_smhr_Tds.TDS_STATUS = Convert.ToBoolean(Status);
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
//_obj_smhr_Tds.TDS_COUNTRY_ID = Convert.ToInt32(Session["TDS_COUNTRY_ID"]);
_obj_smhr_Tds.TDS_BUSINESSUNIT = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
_obj_smhr_Tds.OPERATION = operation.Empty;
DataTable dt_Count = BLL.get_Tds(_obj_smhr_Tds);
_obj_smhr_Tds.OPERATION = operation.Check1;
_obj_smhr_Tds.TDS_BUSINESSUNIT = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds.TDS_LOCALISATION_ID = Convert.ToInt32(Session["TDS_LOCALISATION_ID"]);
DataTable dt_Status = BLL.get_Tds(_obj_smhr_Tds);
if (Convert.ToInt32(dt_Count.Rows[0][0]) != 0)
{
if (Convert.ToString(dt_Status.Rows[0]["TDS_STATUS"]) == "True")
{
BLL.ShowMessage(this, "TDS record for this Businessunit already exists");
return;
}
}
_obj_smhr_Tds.TDS_MODIFIEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_Tds.TDS_MODIFIEDDATE = Convert.ToDateTime(DateTime.Now);
_obj_smhr_Tds.OPERATION = operation.Update;
if (BLL.set_Tds(_obj_smhr_Tds))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
break;
case "BTN_SAVE":
_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds.OPERATION = operation.Empty;
DataTable dt_Count_Save = BLL.get_Tds(_obj_smhr_Tds);
_obj_smhr_Tds.OPERATION = operation.Check1;
_obj_smhr_Tds.TDS_BUSINESSUNIT = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds.TDS_LOCALISATION_ID = Convert.ToInt32(Session["TDS_LOCALISATION_ID"]);
DataTable dt_Status_Save = BLL.get_Tds(_obj_smhr_Tds);
if (Convert.ToInt32(dt_Status_Save.Rows.Count) != 0)
{
for (int i = 0; i < dt_Status_Save.Rows.Count; i++)
{
if (Convert.ToString(dt_Status_Save.Rows[i]["TDS_STATUS"]) == "True")
{
BLL.ShowMessage(this, "TDS record for this Businessunit already exists.If you want to create new Localisation, inactive the earlier record.");
return;
}
}
}
_obj_smhr_Tds.TDS_LOCALISATION_ID = Convert.ToInt32(Session["TDS_LOCALISATION_ID"]);
_obj_smhr_Tds.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds.TDS_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_Tds.TDS_CREATEDDATE = DateTime.Now;
_obj_smhr_Tds.OPERATION = operation.Insert;
if (BLL.set_Tds(_obj_smhr_Tds))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
break;
default:
break;
}
rmp_Main.SelectedIndex = 0;
loadGrid();
rg_Main.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_tds", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}