//function added by kavita kaushik for select record based on search parameters//
 public DataSet LoadCityAll(clsCityMaster objCity)
 {
     object[] parameters = new object[4] {
         objCity.AreaCode, objCity.CityName, objCity.ProvinceName, objCity.TerrName
     };
     dataAccessDS = new DataAccess();
     return(dataAccessDS.LoadDataSet(parameters, "P_TM_CityMaster_SelectAll", "CitySelectAll"));
 }
 public DataSet LoadCity(clsCityMaster objCity)
 {
     object[] parameters = new object[1] {
         objCity.CityId
     };
     dataAccessDS = new DataAccess();
     return(dataAccessDS.LoadDataSet(parameters, "P_TM_CityMaster_Select", "CitySelect"));
 }
        //end of function//

        public DataSet SaveCity(clsCityMaster objCity)
        {
            object[] parameters = new object[] { objCity.CityId,
                                                 objCity.AreaCode,
                                                 objCity.TerritoryId,
                                                 objCity.ProvinceId,
                                                 objCity.CityName,
                                                 objCity.CityNameChinese,
                                                 objCity.User,
                                                 objCity.isActive };
            dataAccessDS = new DataAccess();
            return(dataAccessDS.LoadDataSet(parameters, "P_TM_CityMaster_InsertUpdate", "CityDetail"));
        }