protected void DropCityList_SelectedIndexChanged(object sender, EventArgs e)
{
CCityMaster ObjState = new CCityMaster(Convert.ToInt32(DropCityList.SelectedValue));
BindState(ObjState.StateId.ToString());
//CStateMaster ObjState = new CStateMaster(Convert.ToInt32(DropCityList.SelectedValue));
// Dropstate.SelectedValue = ObjState.StateId.ToString();
// Lblstate.Text = ObjState.StateId.ToString();
//////SqlConnection ObjConnection = new SqlConnection(Common.C_ConnectionString);
//////ObjConnection.Open();
//////SqlCommand ObjCommand = new SqlCommand();
//////ObjCommand.Connection = ObjConnection;
//////ObjCommand.CommandText = "CustomerMastercityList";
//////ObjCommand.CommandType = CommandType.StoredProcedure;
////////ObjCommand.Parameters.AddWithValue("@CityId", DropCityList.SelectedValue);
//////SqlDataAdapter ObjDataAdapter = new SqlDataAdapter(ObjCommand);
//////DataSet dsCustomerMastercityList = new DataSet();
//////ObjDataAdapter.Fill(dsCustomerMastercityList);
//////Dropstate.DataSource = dsCustomerMastercityList;
//////Dropstate.DataTextField = "Statename";
//////Dropstate.DataValueField = "SatateId";
//////Dropstate.DataBind();
////if (dsCustomerMastercityList.Tables[0].Rows.Count > 0)
////{
//// DataSet dr = dsCustomerMastercityList.Tables[0].Rows[0];
//// //DropCityList.SelectedValue = dr["Cityname"].
//// Dropstate.SelectedValue = dr["Statename"].ToString();
//// //LblState.Text = dr["Statename"].ToString();
////}
}
protected void gvcity_RowEditing(object sender, GridViewEditEventArgs e)
{
TblAddEdit.Visible = true;
ButInsert.Visible = false;
ButUpdate.Visible = true;
ButCancle.Visible = true;
int intCityId = Convert.ToInt32(gvcity.DataKeys[e.NewEditIndex].Value);
CCityMaster ObjCity = new CCityMaster(intCityId);
if (ObjCity.IsExit == true)
{
Lblmsg.Text = "";
TxtCityId.Text = ObjCity.CityId.ToString();
TxtCityname.Text = ObjCity.Cityname.ToString();
DropSate.SelectedValue = ObjCity.StateId.ToString();
}
}
protected void gvcity_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int intCityId = Convert.ToInt32(gvcity.DataKeys[e.RowIndex].Value);
CCityMaster ObjCity = new CCityMaster(intCityId);
if (ObjCity.IsExit == true)
{
Lblmsg.Text = "";
TxtCityId.Text = ObjCity.CityId.ToString();
TxtCityname.Text = ObjCity.Cityname.ToString();
DropSate.SelectedValue = ObjCity.StateId.ToString();
}
int intReturnValues = CCityMasterServices.CityMasterDelete(Convert.ToInt32(TxtCityId.Text));
if (intReturnValues > 0)
{
Lblmsg.Text = "City Delete";
BindgvCity();
TxtCityId.Text = "";
TxtCityname.Text = "";
}
}