public List <SentRemindersLogTbl> GetAllByDate(DateTime pDateSent, string SortBy) { List <SentRemindersLogTbl> _DataItems = new List <SentRemindersLogTbl>(); TrackerDb _TrackerDb = new TrackerDb(); string _sqlCmd = CONST_SQL_SELECT_BYDATESENT; if (!String.IsNullOrEmpty(SortBy)) { _sqlCmd += " ORDER BY " + SortBy; // Add order by string } // params would go here if need _TrackerDb.AddWhereParams(pDateSent.Date, DbType.Date); IDataReader _DataReader = _TrackerDb.ExecuteSQLGetDataReader(_sqlCmd); if (_DataReader != null) { while (_DataReader.Read()) { SentRemindersLogTbl _DataItem = new SentRemindersLogTbl(); _DataItem.ReminderID = (_DataReader["ReminderID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["ReminderID"]); _DataItem.CustomerID = (_DataReader["CustomerID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["CustomerID"]); _DataItem.DateSentReminder = (_DataReader["DateSentReminder"] == DBNull.Value) ? System.DateTime.Now.Date : Convert.ToDateTime(_DataReader["DateSentReminder"]).Date; _DataItem.NextPrepDate = (_DataReader["NextPrepDate"] == DBNull.Value) ? System.DateTime.Now.Date : Convert.ToDateTime(_DataReader["NextPrepDate"]).Date; _DataItem.ReminderSent = (_DataReader["ReminderSent"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["ReminderSent"]); _DataItem.HadAutoFulfilItem = (_DataReader["HadAutoFulfilItem"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["HadAutoFulfilItem"]); _DataItem.HadReoccurItems = (_DataReader["HadReoccurItems"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["HadReoccurItems"]); _DataItems.Add(_DataItem); } _DataReader.Close(); } _TrackerDb.Close(); return(_DataItems); }
public string InsertLogItem(SentRemindersLogTbl pSentRemindersLog) { string _ErrString = String.Empty; TrackerDb _TDB = new TrackerDb(); _TDB.AddParams(pSentRemindersLog.CustomerID, DbType.Int64); _TDB.AddParams(pSentRemindersLog.DateSentReminder, DbType.Date); _TDB.AddParams(pSentRemindersLog.NextPrepDate, DbType.Date); _TDB.AddParams(pSentRemindersLog.ReminderSent, DbType.Boolean); _TDB.AddParams(pSentRemindersLog.HadAutoFulfilItem, DbType.Boolean); _TDB.AddParams(pSentRemindersLog.HadReoccurItems, DbType.Boolean); _ErrString = _TDB.ExecuteNonQuerySQL(CONST_SQL_INSERT); _TDB.Close(); return(_ErrString); }