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