protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
ddlCountry.Items[0].Enabled = false;
int CountryId = int.Parse(ddlCountry.SelectedItem.Value);
DataSet ds = StateBusinessLayer.GetStateByCountryId(CountryId);
BindDDL(ddlState, ds, "StateName", "StateID");
ddlState.Items.Insert(0, "---Select---");
lblUpdateAddress.Text = "Plz Select State...";
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int stateId = 0;
Label l;
l = (Label)GridView1.Rows[e.RowIndex].FindControl("lblStateId");
stateId = int.Parse(l.Text);
StateBusinessLayer.DeleteState(stateId);
lblMsg.Text = "State Deleted Successfully";
ShowState();
}
protected void btnAddState_Click(object sender, EventArgs e)
{
//VBARIABLE DECLARATION
string StateName, StateCode, StateDesc;
int CountryID;
//VBARIABLE INITIALIZATION
StateName = "";
StateCode = "";
StateDesc = "";
CountryID = 0;
//VALUES VALIDATION
if (txtStateName.Text.Trim().Length > 0)
{
StateName = txtStateName.Text.Trim();
}
else
{
lblMsg.Text = "Enter State Name";
}
txtStateName.Focus();
if (txtStateCode.Text.Trim().Length > 0)
{
StateCode = txtStateCode.Text.Trim();
}
else
{
lblMsg.Text = "Enter State Code";
}
txtStateCode.Focus();
if (txtStateDesc.Text.Trim().Length > 0)
{
StateDesc = txtStateDesc.Text.Trim();
}
else
{
lblMsg.Text = "Enter State Description";
}
txtStateDesc.Focus();
CountryID = int.Parse(ddlCountry.SelectedItem.Value);
StateBusinessLayer.InsertNewState(StateName, StateCode, StateDesc, CountryID);
lblMsg.Text = "New State Added Successfully...";
txtStateName.Focus();
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int CountryId = int.Parse(ddlCountry.SelectedItem.Value);
DataSet ds = StateBusinessLayer.GetStateByCountryId(CountryId);
BindDDL(ddlState, ds, "StateName", "StateID");
ddlState.Items.Insert(0, "SELECT STATE");
}
catch (Exception)
{
lblMsg.Text = "Plz Select Country Name";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Name"] == null)
{
Response.Redirect("~/Admin/frmAdminLogin.aspx");
}
if (!IsPostBack)
{
ddlState.DataSource = StateBusinessLayer.GetStateNameById();
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "StateID";
ddlState.DataBind();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
CheckBox chk;
foreach (GridViewRow gr in GridView1.Rows)
{
chk = (CheckBox)gr.FindControl("chkId");
if (chk.Checked == true)
{
Label l;
int StateId = 0;
l = (Label)gr.FindControl("lblStateId");
StateId = int.Parse(l.Text);
StateBusinessLayer.DeleteState(StateId);
lblMsg.Text = "State Deleted Successfully";
ShowState();
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int StateId = 0;
int CountryId = 0;
string StateName, StateCode, StateDesc;
//Variable Initialization
StateName = "";
StateCode = "";
StateDesc = "";
if (txtUpdateStateName.Text.Trim().Length > 0)
{
StateName = txtUpdateStateName.Text;
}
else
{
lblmsg.Text = "Enter State Name";
}
if (txtUpdateStateCode.Text.Trim().Length > 0)
{
StateCode = txtUpdateStateCode.Text;
}
else
{
lblmsg.Text = "Enter State Code";
}
if (txtUpdateStateDesc.Text.Trim().Length > 0)
{
StateDesc = txtUpdateStateDesc.Text;
}
else
{
lblmsg.Text = "Enter State Description";
}
StateId = int.Parse(Request["StateId"]);
CountryId = int.Parse(ddlCountry.SelectedItem.Value);
StateBusinessLayer.UdateState(StateId, StateName, StateCode, StateDesc, CountryId);
lblmsg.Text = "State Updated Successfully....";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Name"] == null)
{
Response.Redirect("~/Admin/frmAdminLogin.aspx");
}
if (!IsPostBack)
{
DataSet ds = new DataSet();
int CityId = int.Parse(Request["CityId"]);
ds = CityBusinessLayer.GetCityByID(CityId);
txtCityName.Text = ds.Tables[0].Rows[0][0].ToString();
txtCityDesc.Text = ds.Tables[0].Rows[0][1].ToString();
txtCityCode.Text = ds.Tables[0].Rows[0][2].ToString();
ddlState.DataSource = StateBusinessLayer.GetStateNameById();
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "StateID";
ddlState.DataBind();
}
}
public void ShowState()
{
GridView1.DataSource = StateBusinessLayer.ShowAllState();
GridView1.DataBind();
}
