public const int CONST_DEFAULT_CITYID = 1; // cape town public List <CityTblData> GetAll(string SortBy) { List <CityTblData> _ListCitys = new List <CityTblData>(); TrackerDb _TDB = new TrackerDb(); string _sqlCmd = CONST_SQL_SUMMARYDATA; // Add order by string _sqlCmd += " ORDER BY " + (!String.IsNullOrEmpty(SortBy) ? SortBy : " City"); // run the query we have built IDataReader _DataReader = _TDB.ReturnIDataReader(_sqlCmd); if (_DataReader != null) { while (_DataReader.Read()) { CityTblData _CityTblItem = new CityTblData(); _CityTblItem.ID = Convert.ToInt32(_DataReader["ID"]); _CityTblItem.City = (_DataReader["City"] == DBNull.Value) ? "" : _DataReader["City"].ToString(); _ListCitys.Add(_CityTblItem); } _DataReader.Close(); } _TDB.Close(); return(_ListCitys); }
public List <CityPrepDaysTbl> GetAllByCityId(int pCityID) { string _sqlCmd = CONST_SQL_SELECTBYCITYID; //if (!String.IsNullOrEmpty(SortBy)) // _sqlCmd += " ORDER BY " + SortBy; TrackerDb _TrackerDb = new TrackerDb(); _TrackerDb.AddWhereParams(pCityID, DbType.Int32); List <CityPrepDaysTbl> _DataItems = new List <CityPrepDaysTbl>(); IDataReader _DataReader = _TrackerDb.ReturnIDataReader(_sqlCmd); // ExecuteSQLGetDataReader(_sqlCmd); // ReturnIDataReader(_sqlCmd); if (_DataReader != null) { while (_DataReader.Read()) { CityPrepDaysTbl _DataItem = new CityPrepDaysTbl(); _DataItem.CityID = pCityID; _DataItem.CityPrepDaysID = (_DataReader["CityPrepDaysID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["CityPrepDaysID"]); _DataItem.PrepDayOfWeekID = (_DataReader["PrepDayOfWeekID"] == DBNull.Value) ? byte.MinValue : Convert.ToByte(_DataReader["PrepDayOfWeekID"]); _DataItem.DeliveryDelayDays = (_DataReader["DeliveryDelayDays"] == DBNull.Value) ? 0 : Convert.ToInt16(_DataReader["DeliveryDelayDays"]); _DataItem.DeliveryOrder = (_DataReader["DeliveryOrder"] == DBNull.Value) ? 0 : Convert.ToInt16(_DataReader["DeliveryOrder"]); _DataItems.Add(_DataItem); } _DataReader.Close(); } _TrackerDb.Close(); return(_DataItems); }