public void LoadGrid()
{
try
{
_obj_Smhr_County = new SMHR_COUNTY();
_obj_Smhr_County.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = BLL.get_County(_obj_Smhr_County);
Rg_Counties.DataSource = DT;
clearControls();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_County", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCounties()
{
try
{
SMHR_COUNTY _obj_Smhr_County = new SMHR_COUNTY();
_obj_Smhr_County.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
rcmb_County.DataSource = BLL.get_County(_obj_Smhr_County);
rcmb_County.DataTextField = "COUNTY_CODE";
rcmb_County.DataValueField = "COUNTY_ID";
rcmb_County.DataBind();
rcmb_County.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("'", "''"), "frm_TownMaster", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadCounty()
{
try
{
SMHR_COUNTY _obj_Smhr_County = new SMHR_COUNTY();
_obj_Smhr_County.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_County.OPERATION = operation.Select;
DataTable dt = BLL.get_County(_obj_Smhr_County);
rcmb_County.DataSource = dt;
rcmb_County.DataTextField = "COUNTY_CODE";
rcmb_County.DataValueField = "COUNTY_ID";
rcmb_County.DataBind();
rcmb_County.Items.Insert(0, new RadComboBoxItem("ALL"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmployeeList", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rc_Country_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
rc_County.SelectedIndex = -1;
rc_Town.SelectedIndex = -1;
SMHR_COUNTY _obj_Smhr_County = new SMHR_COUNTY();
_obj_Smhr_County.OPERATION = operation.Select2;
_obj_Smhr_County.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_County.COUNTRY_ID = Convert.ToInt32(rc_Country.SelectedValue);
rc_County.DataSource = BLL.get_County(_obj_Smhr_County);
rc_County.DataTextField = "COUNTY_CODE";
rc_County.DataValueField = "COUNTY_ID";
rc_County.DataBind();
rc_County.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 lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
clearControls();
LoadCountries();
//if (rcmb_Country.FindItemByText("Kenya") != null)
// rcmb_Country.FindItemByText("Kenya").Selected = true;
rtxt_CountyCode.Enabled = false;
SMHR_COUNTY _obj_Smhr_County = new SMHR_COUNTY();
_obj_Smhr_County.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_County.COUNTY_ID = Convert.ToInt32(e.CommandArgument);
DataTable dt = BLL.get_County(_obj_Smhr_County);
//DataTable dt = BLL.get_County(new SMHR_COUNTY(Convert.ToInt32(Convert.ToString(e.CommandArgument))));
lbl_CountyID.Text = Convert.ToString(dt.Rows[0]["COUNTY_ID"]);
rtxt_CountyCode.Text = Convert.ToString(dt.Rows[0]["COUNTY_CODE"]);
rtxt_CountyName.Text = Convert.ToString(dt.Rows[0]["COUNTY_NAME"]);
rcmb_Country.SelectedIndex = rcmb_Country.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["COUNTRY_ID"]));
//code for security
rcmb_Country.Enabled = false;
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
Rm_CY_page.SelectedIndex = 1;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_County", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_County = new SMHR_COUNTY();
_obj_Smhr_County.COUNTY_CODE = BLL.ReplaceQuote(rtxt_CountyCode.Text);
_obj_Smhr_County.COUNTY_NAME = BLL.ReplaceQuote(rtxt_CountyName.Text);
_obj_Smhr_County.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_County.COUNTRY_ID = Convert.ToInt32(rcmb_Country.SelectedValue);
_obj_Smhr_County.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_County.CREATEDDATE = DateTime.Now;
_obj_Smhr_County.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_County.LASTMDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_County.COUNTY_ID = Convert.ToInt32(lbl_CountyID.Text);
_obj_Smhr_County.OPERATION = operation.Update;
if (BLL.set_County(_obj_Smhr_County))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
break;
case "BTN_SAVE":
_obj_Smhr_County.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_County(_obj_Smhr_County).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "District Name Already Exists");
return;
}
_obj_Smhr_County.OPERATION = operation.Insert;
if (BLL.set_County(_obj_Smhr_County))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_CY_page.SelectedIndex = 0;
LoadGrid();
Rg_Counties.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_County", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
