protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
{
ddlState.Items[0].Enabled = false;
int StateId = int.Parse(ddlState.SelectedItem.Value);
DataSet ds = CityBusinessLayer.GetCityByState(StateId);
BindDDL(ddlCity, ds, "CityName", "CityID");
ddlCity.Items.Insert(0, "---Select---");
lblUpdateAddress.Text = "Plz Select City....";
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label l;
l = (Label)GridView1.Rows[e.RowIndex].FindControl("lblCityId");
int CityId = 0;
CityId = int.Parse(l.Text);
CityBusinessLayer.DeleteCity(CityId);
ShowCity();
lblMsg.Text = "City Deleted Successfully...";
}
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int StateId = int.Parse(ddlState.SelectedItem.Value);
DataSet ds = CityBusinessLayer.GetCityByState(StateId);
BindDDL(ddlCity, ds, "CityName", "CityID");
ddlCity.Items.Insert(0, "SELECT CITY");
}
catch (Exception)
{
lblMsg.Text = "Plz Select State Name";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Name"] == null)
{
Response.Redirect("~/Admin/frmAdminLogin.aspx");
}
if (!IsPostBack)
{
ddlCity.DataSource = CityBusinessLayer.GetCityName();
ddlCity.DataTextField = "CityName";
ddlCity.DataValueField = "CityID";
ddlCity.DataBind();
}
}
protected void btnAddCity_Click(object sender, EventArgs e)
{ //variable declaration
string CityName, CityCode, CityDescription;
int StateID;
//varaible initialization
CityCode = "";
CityDescription = "";
CityName = "";
StateID = 0;
//control's value validation
if (txtCityName.Text.Trim().Length > 0)
{
CityName = txtCityName.Text.Trim();
}
else
{
lblMsg.Text = "Enter City Name";
}
if (txtCityDesc.Text.Trim().Length > 0)
{
CityDescription = txtCityDesc.Text.Trim();
}
else
{
lblMsg.Text = "Enter City Description";
}
if (txtCityCode.Text.Trim().Length > 0)
{
CityCode = txtCityCode.Text.Trim();
}
else
{
lblMsg.Text = "Enter City Code";
}
StateID = int.Parse(ddlState.SelectedItem.Value);
//Active = Convert.ToByte(lblActive.Text);
//make call to business layer
CityBusinessLayer.InsertCity(CityName, CityDescription, CityCode, StateID);
lblMsg.Text = "City Added Successfully...";
txtCityName.Focus();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int CityId = int.Parse(Request["CityId"]);
string CityName, CityDesc, CityCode;
//Initialization
CityName = "";
CityDesc = "";
CityCode = "";
int StateId = 0;
StateId = int.Parse(ddlState.SelectedItem.Value);
//Assigning Values
if (txtCityName.Text.Trim().Length > 0)
{
CityName = txtCityName.Text.Trim();
}
else
{
lblMsg.Text = "Enter City Name...";
}
if (txtCityDesc.Text.Trim().Length > 0)
{
CityDesc = txtCityDesc.Text.Trim();
}
else
{
lblMsg.Text = "Enter City Description...";
}
if (txtCityCode.Text.Trim().Length > 0)
{
CityCode = txtCityCode.Text.Trim();
}
else
{
lblMsg.Text = "Enter City Code...";
}
//Calling CityBusinessLayer
CityBusinessLayer.UpdateCity(CityId, CityName, CityDesc, CityCode, StateId);
lblMsg.Text = "City 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();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
CheckBox chk;
foreach (GridViewRow gr in GridView1.Rows)
{
Label l;
l = (Label)gr.FindControl("lblCityId");
int CityId = 0;
CityId = int.Parse(l.Text);
chk = (CheckBox)gr.FindControl("chkid");
if (chk.Checked == true)
{
CityBusinessLayer.DeleteCity(CityId);
lblMsg.Text = "City Deleted Successfully...";
}
else
{
lblMsg.Text = "No City Selected...";
}
ShowCity();
}
}
public void ShowCity()
{
GridView1.DataSource = CityBusinessLayer.ShowAllCity();
GridView1.DataBind();
}
