public int DeleteCity(string key)
{
if (key.Equals(string.Empty) || key.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
int i = 0;
using (SqlCommand command = new SqlCommand())
{
i = ExecuteNonQuery(CityStringsSql.DeleteCity(key));
}
return(i);
}
public City AddCity(City city)
{
DataTable dt = new DataTable();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(CityStringsSql.AddCity(city));
}
foreach (DataRow ms in dt.Rows)
{
city = City.ToObject(ms);
}
return(city);
}
public List <City> GetAllCities()
{
DataTable dt = new DataTable();
List <City> arrCity = new List <City>();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(CityStringsSql.GetAllCities());
}
foreach (DataRow ms in dt.Rows)
{
arrCity.Add(City.ToObject(ms));
}
return(arrCity);
}
public City GetCity(string key)
{
if (key.Equals(string.Empty) || key.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
DataTable dt = new DataTable();
City city = new City();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(CityStringsSql.GetCity(key));
}
foreach (DataRow ms in dt.Rows)
{
city = City.ToObject(ms);
}
return(city);
}
