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