public void ActiveDeactiveState(int StateID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblStateTableAdapter _ObjTA = new AustraliaDAL.DataSet1TableAdapters.tblStateTableAdapter())
{
_ObjTA.ActiveDeactiveState(StateID);
}
}
public DataTable GetStateAllByCountryID(int CountryID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblStateTableAdapter _ObjTA = new AustraliaDAL.DataSet1TableAdapters.tblStateTableAdapter())
{
dt = _ObjTA.GetStateAllByCountryID(CountryID);
}
return(dt);
}
public int AddEditState(int StateID, string StateName, int CountryID)
{
int pageval;
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblStateTableAdapter _ObjTA = new AustraliaDAL.DataSet1TableAdapters.tblStateTableAdapter())
{
dt = _ObjTA.AddEditState(StateID, StateName, CountryID);
}
pageval = Convert.ToInt32(dt.Rows[0]["StateID"].ToString());
return(pageval);
}
