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