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); }