public List <LogTbl> GetAll(string SortBy)
{
TrackerDb _TDB = new TrackerDb();
string _sqlCmd = CONST_SQL_SELECT;
_sqlCmd += (!String.IsNullOrEmpty(SortBy)) ? " ORDER BY " + SortBy : " ORDER BY DateAdded"; // add default order\
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(_sqlCmd);
List <LogTbl> _DataItems = new List <LogTbl>();
if (_DataReader != null)
{
while (_DataReader.Read())
{
LogTbl _DataItem = new LogTbl();
_DataItem.LogID = (_DataReader["LogID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["LogID"]);
_DataItem.DateAdded = (_DataReader["DateAdded"] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(_DataReader["DateAdded"]).Date;
_DataItem.UserID = (_DataReader["UserID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["UserID"]);
_DataItem.SectionID = (_DataReader["SectionID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["SectionID"]);
_DataItem.TranactionTypeID = (_DataReader["TranactionTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["TranactionTypeID"]);
_DataItem.CustomerID = (_DataReader["CustomerID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["CustomerID"]);
_DataItem.Details = (_DataReader["Details"] == DBNull.Value) ? string.Empty : _DataReader["Details"].ToString();
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TDB.Close();
return(_DataItems);
}
public bool InsertLogItem(LogTbl objLog)
{
bool _inserted = false;
TrackerDb _TDB = new TrackerDb();
_TDB.AddParams(DateTime.Now, DbType.DateTime); // other insert DateTime does not work only date
_TDB.AddParams(objLog.UserID, DbType.Int32);
_TDB.AddParams(objLog.SectionID, DbType.Int32);
_TDB.AddParams(objLog.TranactionTypeID, DbType.Int32);
_TDB.AddParams(objLog.CustomerID, DbType.Int64);
_TDB.AddParams(objLog.Details);
_TDB.AddParams(objLog.Notes);
_inserted = string.IsNullOrWhiteSpace(_TDB.ExecuteNonQuerySQL(CONST_SQL_INSERT));
_TDB.Close();
return(_inserted);
}
