public void LoadGrid()
{
try
{
_obj_Smhr_Town = new SMHR_TOWN();
_obj_Smhr_Town.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = BLL.get_Town(_obj_Smhr_Town);
Rg_Towns.DataSource = DT;
clearControls();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TownMaster", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rc_County_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
rc_Town.SelectedIndex = -1;
SMHR_TOWN _obj_Smhr_Town = new SMHR_TOWN();
_obj_Smhr_Town.OPERATION = operation.Select2;
_obj_Smhr_Town.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Town.COUNTY_ID = Convert.ToInt32(rc_County.SelectedValue);
rc_Town.DataSource = BLL.get_Town(_obj_Smhr_Town);
rc_Town.DataTextField = "TOWN_CODE";
rc_Town.DataValueField = "TOWN_ID";
rc_Town.DataBind();
rc_Town.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "TrainerProfile", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_Town = new SMHR_TOWN();
_obj_Smhr_Town.TOWN_CODE = BLL.ReplaceQuote(rtxt_TownCode.Text);
_obj_Smhr_Town.TOWN_DESCRIPTION = BLL.ReplaceQuote(rtxt_TownName.Text);
_obj_Smhr_Town.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Town.COUNTY_ID = Convert.ToInt32(rcmb_County.SelectedValue);
_obj_Smhr_Town.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Town.CREATEDDATE = DateTime.Now;
_obj_Smhr_Town.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Town.LASTMDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_Town.TOWN_ID = Convert.ToInt32(lbl_TownID.Text);
_obj_Smhr_Town.OPERATION = operation.Update;
if (BLL.set_Town(_obj_Smhr_Town))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
break;
case "BTN_SAVE":
_obj_Smhr_Town.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_Town(_obj_Smhr_Town).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Town Name Already Exists");
return;
}
_obj_Smhr_Town.OPERATION = operation.Insert;
if (BLL.set_Town(_obj_Smhr_Town))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_CY_page.SelectedIndex = 0;
LoadGrid();
Rg_Towns.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TownMaster", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
