public List <TransactionTypesTbl> GetAll(string SortBy)
{
List <TransactionTypesTbl> _DataItems = new List <TransactionTypesTbl>();
TrackerDb _TrackerDb = new TrackerDb();
string _sqlCmd = CONST_SQL_SELECT;
if (!String.IsNullOrEmpty(SortBy))
{
_sqlCmd += " ORDER BY " + SortBy; // Add order by string
}
// params would go here if need
IDataReader _DataReader = _TrackerDb.ExecuteSQLGetDataReader(_sqlCmd);
if (_DataReader != null)
{
while (_DataReader.Read())
{
TransactionTypesTbl _DataItem = new TransactionTypesTbl();
_DataItem.TransactionID = (_DataReader["TransactionID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["TransactionID"]);
_DataItem.TransactionType = (_DataReader["TransactionType"] == DBNull.Value) ? string.Empty : _DataReader["TransactionType"].ToString();
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TrackerDb.Close();
return(_DataItems);
}
public string InsertTransactionType(TransactionTypesTbl pTransactionType)
{
TrackerDb _TDB = new TrackerDb();
_TDB.AddParams(pTransactionType.TransactionID, DbType.Int32);
_TDB.AddParams(pTransactionType.TransactionType);
_TDB.AddParams(pTransactionType.Notes);
string _Result = _TDB.ExecuteNonQuerySQL(CONST_SQL_INSERT);
_TDB.Close();
return(_Result);
}
public static void UpdateTransaction(TransactionTypesTbl pTransactionType, int pOrignal_TransactionID)
{
TrackerDb _TDB = new TrackerDb();
_TDB.AddParams(pTransactionType.TransactionType);
_TDB.AddParams(pTransactionType.Notes);
if (pOrignal_TransactionID > 0)
{
_TDB.AddWhereParams(pOrignal_TransactionID, DbType.Int32);
}
else
{
_TDB.AddWhereParams(pTransactionType.TransactionID, DbType.Int32);
}
string _Result = _TDB.ExecuteNonQuerySQL(CONST_SQL_UPDATE);
_TDB.Close();
// return _Result;
}
public static void UpdateTransaction(TransactionTypesTbl pTransactionType)
{
UpdateTransaction(pTransactionType, 0);
}
