protected void btn_Copy_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToInt32(rcmb_PreviousPeriod.SelectedItem.Value) == Convert.ToInt32(rcmb_CurrentPeriod.SelectedItem.Value))
{
BLL.ShowMessage(this, "Please Select different periods.");
return;
}
_obj_smhr_Tds_Params = new SMHR_TDS_PARAMS();
_obj_smhr_Tds_Params.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_Tds_Params.CREATEDDATE = Convert.ToDateTime(DateTime.Now);
_obj_smhr_Tds_Params.TDS_PARAMS_CURRENTPERIOD_ID = Convert.ToInt32(rcmb_CurrentPeriod.SelectedValue);
_obj_smhr_Tds_Params.TDS_PARAMS_PERIOD_ID = Convert.ToInt32(rcmb_PreviousPeriod.SelectedValue);
_obj_smhr_Tds_Params.TDS_PARAMS_TDS_ID = Convert.ToInt32(rcmb_tdsname.SelectedItem.Value);
_obj_smhr_Tds_Params.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_Tds_Params.OPERATION = operation.Get;
DataTable dt = BLL.get_TDS_PARAMS(_obj_smhr_Tds_Params);
if (dt.Rows.Count > 0)
{
_obj_smhr_Tds_Params.OPERATION = operation.Delete;
for (int i = 0; i < dt.Rows.Count; i++)
{
_obj_smhr_Tds_Params.TDS_PARAMS_SLAB_ID = Convert.ToInt32(dt.Rows[i]["TDS_SLAB_ID"]);
if (BLL.set_TDS_PARAMS(_obj_smhr_Tds_Params))
{
}
}
_obj_smhr_Tds_Params.OPERATION = operation.Validate;
if (BLL.set_TDS_PARAMS(_obj_smhr_Tds_Params))
{
BLL.ShowMessage(this, "Tds Values of Previous Period Are Copied to Current Period");
}
else
{
BLL.ShowMessage(this, "Error Ocurred");
}
}
else
{
BLL.ShowMessage(this, "First define Slabs for Selected TDS");
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_CopyTdsParams", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public void loadGrid()
{
try
{
_obj_smhr_Tds_Params = new SMHR_TDS_PARAMS();
_obj_smhr_Tds_Params.OPERATION = operation.Select;
_obj_smhr_Tds_Params.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Params = BLL.get_TDS_PARAMS(_obj_smhr_Tds_Params);
rg_Main.DataSource = dt_Params;
}
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");
}
//rg_Main.DataBind();
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (rntxt_TdsVal.Text == string.Empty && rntxt_TdsPercent.Text == string.Empty)
{
BLL.ShowMessage(this, "Please Enter Tds Value or Tds Percent");
return;
}
if (Convert.ToDouble(rntxt_TdsFromVal.Text) >= Convert.ToDouble(rntxt_TdsToVal.Text))
{
BLL.ShowMessage(this, "From value Should be Less Than To Value.");
rntxt_TdsFromVal.Text = null;
rntxt_TdsToVal.Text = null;
return;
}
string str_Params_Id = Convert.ToString(Session["str_Params_Id"]);
_obj_smhr_Tds_Params = new SMHR_TDS_PARAMS();
_obj_smhr_Tds_Params.TDS_PARAMS_SLAB_ID = Convert.ToInt32(rcmb_Slab.SelectedValue);
_obj_smhr_Tds_Params.TDS_PARAMS_FROMVAL = Convert.ToSingle(rntxt_TdsFromVal.Text.Replace("'", "''"));
_obj_smhr_Tds_Params.TDS_PARAMS_TOVAL = Convert.ToSingle(rntxt_TdsToVal.Text.Replace("'", "''"));
if (rntxt_TdsVal.Text != string.Empty)
{
_obj_smhr_Tds_Params.TDS_PARAMS_VALUE = Convert.ToSingle(rntxt_TdsVal.Text.Replace("'", "''"));
}
if (rntxt_TdsPercent.Text != string.Empty)
{
_obj_smhr_Tds_Params.TDS_PARAMS_PERCENT = Convert.ToSingle(rntxt_TdsPercent.Text.Replace("'", "''"));
}
_obj_smhr_Tds_Params.TDS_PARAMS_PERIOD_ID = Convert.ToInt32(rcmb_Period.SelectedValue);
_obj_smhr_Tds_Params.OPERATION = operation.Check1;
DataTable dt = BLL.get_TDS_PARAMS(_obj_smhr_Tds_Params);
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_smhr_Tds_Params.OPERATION = operation.Update;
_obj_smhr_Tds_Params.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_Tds_Params.LASTMDFDATE = Convert.ToDateTime(DateTime.Now);
_obj_smhr_Tds_Params.TDS_PARAMS_ID = Convert.ToInt32(str_Params_Id);
if (BLL.set_TDS_PARAMS(_obj_smhr_Tds_Params))
{
BLL.ShowMessage(this, "Record Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Unable to Update the Record");
}
break;
case "BTN_SAVE":
_obj_smhr_Tds_Params.OPERATION = operation.Insert;
if (dt.Rows.Count > 0)
{
if (Convert.ToInt32(dt.Rows[0]["COUNT"]) != 0)
{
BLL.ShowMessage(this, "Slab for this values Already Exists!");
return;
}
}
_obj_smhr_Tds_Params.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_Tds_Params.CREATEDDATE = Convert.ToDateTime(DateTime.Now);
if (BLL.set_TDS_PARAMS(_obj_smhr_Tds_Params))
{
BLL.ShowMessage(this, "Record Inserted Successfully");
}
else
{
BLL.ShowMessage(this, "Unable to Save the Record");
}
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_Params", 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");
}
}
