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