public void ActiveDeactiveCity(int CityID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblCityTableAdapter _ObjTA = new AustraliaDAL.DataSet1TableAdapters.tblCityTableAdapter())
{
_ObjTA.ActiveDeactiveCity(CityID);
}
}
public DataTable GetCityByStateID(int StateID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCityTableAdapter _ObjTA = new AustraliaDAL.DataSet1TableAdapters.tblCityTableAdapter())
{
dt = _ObjTA.GetCitybyStateID(StateID);
}
return(dt);
}
public int AddEditCity(int CityID, string CityName, int StateID)
{
int pageval;
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCityTableAdapter _ObjTA = new AustraliaDAL.DataSet1TableAdapters.tblCityTableAdapter())
{
dt = _ObjTA.AddEditCity(CityID, CityName, StateID);
}
pageval = Convert.ToInt32(dt.Rows[0]["CityID"].ToString());
return(pageval);
}