private void fillCityName(int CityID)
{
string Error = "";
DBCity cityObj = new DBCity();
LabelCityName.Text = cityObj.getCityNameByID(CityID, ref Error);
}
private void fillCity()
{
string Error = "";
DBCity cityObj = new DBCity();
DataTable table = cityObj.getAllCity(ref Error);
GridViewCity.DataSource = table;
GridViewCity.DataBind();
}
private void fillCity()
{
string Error = "";
DBCity cityObj = new DBCity();
DataTable table = cityObj.getAllCity(ref Error);
DropDownListCity.DataSource = table;
DropDownListCity.DataValueField = "CityID";
DropDownListCity.DataTextField = "CityName";
DropDownListCity.DataBind();
}
public void clear()
{
DBFirstName.Clear();
DBSurname.Clear();
DBEmail.Clear();
DBPhone.Clear();
DBAddress1.Clear();
DBAddress2.Clear();
DBCity.Clear();
DBCounty.Clear();
DBCourse.Clear();
txtStudID.Clear();
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
string Error = "";
DBCity cityObj = new DBCity();
cityObj.addCity(TextBoxCityName.Text, ref Error);
if (Error != "")
{
Response.Write(Error);
}
else
{
TextBoxCityName.Text = "";
fillCity();
}
}
protected void GridViewCity_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int cityID = Int32.Parse(GridViewCity.DataKeys[e.RowIndex].Value.ToString());
string Error = "";
DBCity cityObj = new DBCity();
cityObj.deleteCity(cityID, ref Error);
if (Error != "")
{
Response.Write(Error);
}
else
{
fillCity();
}
}
protected void GridViewCity_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int cityID = Int32.Parse(GridViewCity.DataKeys[e.RowIndex].Value.ToString());
string Error = "";
DBCity cityObj = new DBCity();
string CityName = ((TextBox)GridViewCity.Rows[e.RowIndex].FindControl("TextBoxCity")).Text;
cityObj.updateCity(cityID, CityName, ref Error);
if (Error != "")
{
Response.Write(Error);
}
else
{
GridViewCity.EditIndex = -1;
fillCity();
}
}
