public List <PaymentTermsTbl> GetAll(string SortBy)
{
List <PaymentTermsTbl> _DataItems = new List <PaymentTermsTbl>();
TrackerDb _TDB = 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 = _TDB.ExecuteSQLGetDataReader(_sqlCmd);
if (_DataReader != null)
{
while (_DataReader.Read())
{
PaymentTermsTbl _DataItem = new PaymentTermsTbl();
#region StoreThisDataItem
_DataItem.PaymentTermID = (_DataReader["PaymentTermID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["PaymentTermID"]);
_DataItem.PaymentTermDesc = (_DataReader["PaymentTermDesc"] == DBNull.Value) ? string.Empty : _DataReader["PaymentTermDesc"].ToString();
_DataItem.PaymentDays = (_DataReader["PaymentDays"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["PaymentDays"]);
_DataItem.DayOfMonth = (_DataReader["DayOfMonth"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["DayOfMonth"]);
_DataItem.UseDays = (_DataReader["UseDays"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["UseDays"]);
_DataItem.Enabled = (_DataReader["Enabled"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["Enabled"]);
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
#endregion
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TDB.Close();
return(_DataItems);
}
public string Update(PaymentTermsTbl pPaymentTermsTbl, int pOrignal_PaymentTermID)
{
string _result = string.Empty;
TrackerDb _TDB = new TrackerDb();
#region UpdateParameters
if (pOrignal_PaymentTermID > 0)
{
_TDB.AddWhereParams(pOrignal_PaymentTermID, DbType.Int32); // check this line it assumes id field is int32
}
else
{
_TDB.AddWhereParams(pPaymentTermsTbl.PaymentTermID, DbType.Boolean, "@PaymentTermID");
}
_TDB.AddParams(pPaymentTermsTbl.PaymentTermDesc, DbType.String, "@PaymentTermDesc");
_TDB.AddParams(pPaymentTermsTbl.PaymentDays, DbType.Int32, "@PaymentDays");
_TDB.AddParams(pPaymentTermsTbl.DayOfMonth, DbType.Int32, "@DayOfMonth");
_TDB.AddParams(pPaymentTermsTbl.UseDays, DbType.Boolean, "@UseDays");
_TDB.AddParams(pPaymentTermsTbl.Enabled, DbType.Boolean, "@Enabled");
_TDB.AddParams(pPaymentTermsTbl.Notes, DbType.String, "@Notes");
#endregion
// Now we have the parameters excute the SQL
_result = _TDB.ExecuteNonQuerySQL(CONST_SQL_UPDATE);
_TDB.Close();
return(_result);
}
public string Insert(PaymentTermsTbl pPaymentTermsTbl)
{
string _result = string.Empty;
TrackerDb _TDB = new TrackerDb();
#region InsertParameters
_TDB.AddParams(pPaymentTermsTbl.PaymentTermDesc, DbType.String, "@PaymentTermDesc");
_TDB.AddParams(pPaymentTermsTbl.PaymentDays, DbType.Int32, "@PaymentDays");
_TDB.AddParams(pPaymentTermsTbl.DayOfMonth, DbType.Int32, "@DayOfMonth");
_TDB.AddParams(pPaymentTermsTbl.UseDays, DbType.Boolean, "@UseDays");
_TDB.AddParams(pPaymentTermsTbl.Enabled, DbType.Boolean, "@Enabled");
_TDB.AddParams(pPaymentTermsTbl.Notes, DbType.String, "@Notes");
#endregion
// Now we have the parameters excute the SQL
_result = _TDB.ExecuteNonQuerySQL(CONST_SQL_INSERT);
_TDB.Close();
return(_result);
}
public string Delete(PaymentTermsTbl pPaymentTermsTbl)
{
return(Delete(pPaymentTermsTbl.PaymentTermID));
}
public string Update(PaymentTermsTbl pPaymentTermsTbl)
{
return(Update(pPaymentTermsTbl, 0));
}