public DataSetData GetDataSetData(string SQL, int PageNumber, int PageSize, out CustomException ServiceError) { try { DataSet ds = GetDataSet(SQL, PageNumber, PageSize); ServiceError = null; return(DataSetData.FromDataSet(ds)); } catch (Exception ex) { ServiceError = new CustomException(ex); } return(null); }
public DataSetData GetSchools(out CustomException ServiceError) { try { string SQL = "select SCHOOL_ID, SCHOOL_NAME from SCHOOLS;"; int PageNumber = 1; int PageSize = 10000; DataSet ds = GetDataSet(SQL, PageNumber, PageSize); ServiceError = null; return(DataSetData.FromDataSet(ds)); } catch (Exception ex) { ServiceError = new CustomException(ex); } return(null); }
public DataSetData GetEventTypes(out CustomException ServiceError) { try { string SQL = "select EVENT_TYPE_ID, EVENT_TYPE_NAME from EVENT_TYPES;"; int PageNumber = 1; int PageSize = 10000; DataSet ds = GetDataSet(SQL, PageNumber, PageSize); ServiceError = null; return(DataSetData.FromDataSet(ds)); } catch (Exception ex) { ServiceError = new CustomException(ex); } return(null); }
public DataSetData GetSchoolBuildings(int school_id, out CustomException ServiceError) { try { string SQL = String.Format("select SCHOOL_BUILDINGS_ID, BUILDING_NAME from SCHOOL_BUILDINGS where (SCHOOL_ID = {0});", school_id); int PageNumber = 1; int PageSize = 10000; DataSet ds = GetDataSet(SQL, PageNumber, PageSize); ServiceError = null; return(DataSetData.FromDataSet(ds)); } catch (Exception ex) { ServiceError = new CustomException(ex); } return(null); }