public List <UsedItemGroupTbl> GetAll(string SortBy)
{
List <UsedItemGroupTbl> _DataItems = new List <UsedItemGroupTbl>();
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())
{
UsedItemGroupTbl _DataItem = new UsedItemGroupTbl();
#region StoreThisDataItem
_DataItem.UsedItemGroupID = (_DataReader["UsedItemGroupID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["UsedItemGroupID"]);
_DataItem.ContactID = (_DataReader["ContactID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["ContactID"]);
_DataItem.GroupItemTypeID = (_DataReader["GroupItemTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["GroupItemTypeID"]);
_DataItem.LastItemTypeID = (_DataReader["LastItemTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["LastItemTypeID"]);
_DataItem.LastItemTypeSortPos = (_DataReader["LastItemTypeSortPos"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["LastItemTypeSortPos"]);
_DataItem.LastItemDateChanged = (_DataReader["LastItemDateChanged"] == DBNull.Value) ? System.DateTime.Now : Convert.ToDateTime(_DataReader["LastItemDateChanged"]);
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
#endregion
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TDB.Close();
return(_DataItems);
}
public UsedItemGroupTbl GetLastUsedItemID(long pContactID, int pItemID, DateTime pDeliveryDate)
{
UsedItemGroupTbl _DataItem = new UsedItemGroupTbl();
TrackerDb _TDB = new TrackerDb();
_TDB.AddWhereParams(pContactID, DbType.Int64, "@ContactID");
_TDB.AddWhereParams(pItemID, DbType.Int32, "@LastItemTypeID");
_TDB.AddWhereParams(pDeliveryDate, DbType.Date, "@LastItemDateChanged ");
//"SELECT UsedItemGroupID, GroupItemTypeID, LastItemTypeSortPos, Notes FROM UsedItemGroupTbl WHERE ContactID = ? AND LastItemTypeID = ? AND LastItemDateChanged = ?";
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(CONST_SELECTLASTUSEDITEMID);
if (_DataReader != null)
{
if (_DataReader.Read())
{
_DataItem.UsedItemGroupID = (_DataReader["UsedItemGroupID"] == DBNull.Value) ? TrackerDb.CONST_INVALIDID : Convert.ToInt32(_DataReader["UsedItemGroupID"]);
_DataItem.ContactID = pContactID;
_DataItem.GroupItemTypeID = (_DataReader["GroupItemTypeID"] == DBNull.Value) ? TrackerDb.CONST_INVALIDID : Convert.ToInt32(_DataReader["GroupItemTypeID"]);
_DataItem.LastItemTypeID = pItemID;
_DataItem.LastItemTypeSortPos = (_DataReader["LastItemTypeSortPos"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["LastItemTypeSortPos"]);
_DataItem.LastItemDateChanged = pDeliveryDate;
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
}
_DataReader.Close();
}
_TDB.Close();
return(_DataItem);
}
public const int CONST_DEFAULT_CITYID = 1; // cape town
public List <CityTblData> GetAll(string SortBy)
{
List <CityTblData> _ListCitys = new List <CityTblData>();
TrackerDb _TDB = new TrackerDb();
string _sqlCmd = CONST_SQL_SUMMARYDATA;
// Add order by string
_sqlCmd += " ORDER BY " + (!String.IsNullOrEmpty(SortBy) ? SortBy : " City");
// run the query we have built
IDataReader _DataReader = _TDB.ReturnIDataReader(_sqlCmd);
if (_DataReader != null)
{
while (_DataReader.Read())
{
CityTblData _CityTblItem = new CityTblData();
_CityTblItem.ID = Convert.ToInt32(_DataReader["ID"]);
_CityTblItem.City = (_DataReader["City"] == DBNull.Value) ? "" : _DataReader["City"].ToString();
_ListCitys.Add(_CityTblItem);
}
_DataReader.Close();
}
_TDB.Close();
return(_ListCitys);
}
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);
}
/// <summary>
/// Execute the SQL statement does not return results, such as: delete, update, insert operation
/// </summary>
/// <param name="strSQL">SQL String of a non Query Type</param>
/// <returns>success or failure</returns>
public bool UpdateOrderHeader(OrderHeaderData pOrderHeader, List <string> pOrders)
{
bool _resultState = false;
string _strSQL = CONST_ORDERUPDATEHEADER_SQL + " WHERE ";
// for all the OrderIds passed create a where clause
for (int i = 0; i < pOrders.Count - 1; i++)
{
_strSQL += " OrderID = " + pOrders[i] + " OR";
}
_strSQL += " OrderID = " + pOrders[pOrders.Count - 1];
TrackerDb _TDB = new TrackerDb();
_TDB.AddParams(pOrderHeader.CustomerID, DbType.Int64, "@CustomerID");
_TDB.AddParams(pOrderHeader.OrderDate, DbType.Date, "@OrderDate");
_TDB.AddParams(pOrderHeader.RoastDate, DbType.Date, "@RoastDate");
_TDB.AddParams(pOrderHeader.ToBeDeliveredBy, DbType.Int64, "@ToBeDeliveredBy");
_TDB.AddParams(pOrderHeader.RequiredByDate, DbType.Date, "@RequiredByDate");
_TDB.AddParams(pOrderHeader.Confirmed, DbType.Boolean, "@Confirmed");
_TDB.AddParams(pOrderHeader.Done, DbType.Boolean, "@Done");
_TDB.AddParams(pOrderHeader.InvoiceDone, DbType.Boolean, "@InvoiceDone");
_TDB.AddParams(pOrderHeader.PurchaseOrder, DbType.String, "@PurchaseOrder");
_TDB.AddParams(pOrderHeader.Notes, DbType.String, "@Notes");
_resultState = String.IsNullOrEmpty(_TDB.ExecuteNonQuerySQL(_strSQL));
_TDB.Close();
return(_resultState);
}
public List <SysDataTbl> GetAll() //(string SortBy)
{
List <SysDataTbl> _DataItems = new List <SysDataTbl>();
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())
{
SysDataTbl _DataItem = new SysDataTbl();
_DataItem.ID = (_DataReader["ID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["ID"]);
_DataItem.LastReoccurringDate = (_DataReader["LastReoccurringDate"] == DBNull.Value) ? System.DateTime.MinValue : Convert.ToDateTime(_DataReader["LastReoccurringDate"]).Date;
_DataItem.DoReoccuringOrders = (_DataReader["DoReoccuringOrders"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["DoReoccuringOrders"]);
_DataItem.DateLastPrepDateCalcd = (_DataReader["DateLastPrepDateCalcd"] == DBNull.Value) ? System.DateTime.MinValue : Convert.ToDateTime(_DataReader["DateLastPrepDateCalcd"]).Date;
_DataItem.MinReminderDate = (_DataReader["MinReminderDate"] == DBNull.Value) ? System.DateTime.MinValue : Convert.ToDateTime(_DataReader["MinReminderDate"]).Date;
_DataItem.GroupItemTypeID = (_DataReader["GroupItemTypeID"] == DBNull.Value) ? TrackerDb.CONST_INVALIDID : Convert.ToInt32(_DataReader["GroupItemTypeID"]);
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TrackerDb.Close();
return(_DataItems);
}
/*
* try
* {
* _conn.Open();
* if (_cmd.ExecuteNonQuery() > 0)
*
*
* OleDbConnection _conn = new OleDbConnection(_connectionString);
*
* // add parameters in the order they appear in the update command
* OleDbCommand _cmd = new OleDbCommand(_sqlCmd, _conn);
* _cmd.Parameters.Add(new OleDbParameter { Value = ItemTypeID });
* _cmd.Parameters.Add(new OleDbParameter { Value = Math.Round(QuantityOrdered,2) });
* _cmd.Parameters.Add(new OleDbParameter { Value = PackagingID });
* _cmd.Parameters.Add(new OleDbParameter { Value = OrderID });
*
* try
* {
* _conn.Open();
* if (_cmd.ExecuteNonQuery() > 0)
* return false;
* }
* catch (OleDbException ex)
* {
* string _ErrStr = ex.Message;
* return _ErrStr == "";
* }
* finally
* {
* _conn.Close();
* }
*
* return true;
* }
*/
public bool InsertOrderDetails(Int64 CustomerID, DateTime OrderDate, DateTime RoastDate, Int32 ToBeDeliveredBy,
DateTime RequiredByDate, Boolean Confirmed, Boolean Done, String Notes,
double QuantityOrdered, Int32 PackagingID, Int32 ItemTypeID)
{
string _sqlCmd = "INSERT INTO OrdersTbl (CustomerId, OrderDate, RoastDate, RequiredByDate, ToBeDeliveredBy, Confirmed, Done, Notes, " +
" ItemTypeID, QuantityOrdered, PackagingID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
//1 2 3 4 5 6 7 8 9 10 11
bool _Success = false;
// check if the item is a group item then get the next group.
TrackerTools _TT = new TrackerTools();
ItemTypeID = _TT.ChangeItemIfGroupToNextItemInGroup(CustomerID, ItemTypeID, RequiredByDate);
TrackerDb _TDB = new TrackerDb();
// first summary data
_TDB.AddParams(CustomerID, DbType.Int64, "@CustomerID");
_TDB.AddParams(OrderDate, DbType.Date, "@OrderDate");
_TDB.AddParams(RoastDate, DbType.Date, "@RoastDate");
_TDB.AddParams(RequiredByDate, DbType.Date, "@RequiredByDate");
_TDB.AddParams(ToBeDeliveredBy, DbType.Int32, "@ToBeDeliveredBy");
_TDB.AddParams(Confirmed, DbType.Boolean, "@Confirmed");
_TDB.AddParams(Done, DbType.Boolean, "@Done");
_TDB.AddParams(Notes, DbType.String, "@Notes");
// Now line data
_TDB.AddParams(ItemTypeID, DbType.Int32, "@ItemTypeID");
_TDB.AddParams(Math.Round(QuantityOrdered, 2), DbType.Double, "@QuantityOrdered");
_TDB.AddParams(PackagingID, DbType.Int32, "@PackagingID");
_Success = String.IsNullOrEmpty(_TDB.ExecuteNonQuerySQL(_sqlCmd));
_TDB.Close();
return(_Success);
}
public int GetLastIDInserted(long pCustomerID)
{
int _LastID = 0;
TrackerDb _TDB = new TrackerDb();
_TDB.AddWhereParams(pCustomerID, DbType.Int64);
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(CONST_SQL_SELECTLAST);
if (_DataReader != null)
{
if (_DataReader.Read())
{
_LastID = (_DataReader["RepairID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairID"]);
}
else
{
_DataReader.Close();
}
}
_TDB.Close();
return(_LastID);
}
public string UpdateRepair(RepairsTbl RepairItem, int orig_RepairID)
{
string _result = String.Empty;
TrackerDb _TrackerDb = new TrackerDb();
_TrackerDb.AddParams(RepairItem.CustomerID, DbType.Int64);
_TrackerDb.AddParams(RepairItem.ContactName, DbType.String);
_TrackerDb.AddParams(RepairItem.ContactEmail, DbType.String);
_TrackerDb.AddParams(RepairItem.JobCardNumber, DbType.String);
_TrackerDb.AddParams(RepairItem.DateLogged, DbType.Date);
_TrackerDb.AddParams(RepairItem.LastStatusChange, DbType.Date);
_TrackerDb.AddParams(RepairItem.MachineTypeID, DbType.Int32);
_TrackerDb.AddParams(RepairItem.MachineSerialNumber, DbType.String);
_TrackerDb.AddParams(RepairItem.SwopOutMachineID, DbType.Int32);
_TrackerDb.AddParams(RepairItem.MachineConditionID, DbType.Int32);
_TrackerDb.AddParams(RepairItem.TakenFrother, DbType.Boolean);
_TrackerDb.AddParams(RepairItem.TakenBeanLid, DbType.Boolean);
_TrackerDb.AddParams(RepairItem.TakenWaterLid, DbType.Boolean);
_TrackerDb.AddParams(RepairItem.BrokenFrother, DbType.Boolean);
_TrackerDb.AddParams(RepairItem.BrokenBeanLid, DbType.Boolean);
_TrackerDb.AddParams(RepairItem.BrokenWaterLid, DbType.Boolean);
_TrackerDb.AddParams(RepairItem.RepairFaultID, DbType.Int32);
_TrackerDb.AddParams(RepairItem.RepairFaultDesc, DbType.String);
_TrackerDb.AddParams(RepairItem.RepairStatusID, DbType.Int32);
_TrackerDb.AddParams(RepairItem.RelatedOrderID, DbType.Int64);
_TrackerDb.AddParams(RepairItem.Notes, DbType.String);
_TrackerDb.AddWhereParams(orig_RepairID, DbType.Int32);
_result = _TrackerDb.ExecuteNonQuerySQL(CONST_SQL_UPDATE);
_TrackerDb.Close();
return(_result);
}
public string Update(PriceLevelsTbl pPriceLevelsTbl, int pOrignal_PriceLevelID)
{
string _result = string.Empty;
TrackerDb _TDB = new TrackerDb();
#region UpdateParameters
if (pOrignal_PriceLevelID > 0)
{
_TDB.AddWhereParams(pOrignal_PriceLevelID, DbType.Int32); // check this line it assumes id field is int32
}
else
{
_TDB.AddWhereParams(pPriceLevelsTbl.PriceLevelID, DbType.Boolean, "@PriceLevelID");
}
_TDB.AddParams(pPriceLevelsTbl.PriceLevelDesc, DbType.String, "@PriceLevelDesc");
_TDB.AddParams(Math.Round(pPriceLevelsTbl.PricingFactor, 3), DbType.Double, "@PricingFactor");
_TDB.AddParams(pPriceLevelsTbl.Enabled, DbType.Int32, "@Enabled");
_TDB.AddParams(pPriceLevelsTbl.Notes, DbType.String, "@Notes");
#endregion
// Now we have the parameters excute the SQL
_result = _TDB.ExecuteNonQuerySQL(CONST_SQL_UPDATE);
_TDB.Close();
return(_result);
}
public bool InsertRepair(RepairsTbl DataItem)
{
bool _result = false;
TrackerDb _TrackerDb = new TrackerDb();
_TrackerDb.AddParams(DataItem.CustomerID, DbType.Int64);
_TrackerDb.AddParams(DataItem.ContactName, DbType.String);
_TrackerDb.AddParams(DataItem.ContactEmail, DbType.String);
_TrackerDb.AddParams(DataItem.JobCardNumber, DbType.String);
_TrackerDb.AddParams(DataItem.DateLogged, DbType.Date);
_TrackerDb.AddParams(DataItem.LastStatusChange, DbType.Date);
_TrackerDb.AddParams(DataItem.MachineTypeID, DbType.Int32);
_TrackerDb.AddParams(DataItem.MachineSerialNumber, DbType.String);
_TrackerDb.AddParams(DataItem.SwopOutMachineID, DbType.Int32);
_TrackerDb.AddParams(DataItem.MachineConditionID, DbType.Int32);
_TrackerDb.AddParams(DataItem.TakenFrother, DbType.Boolean);
_TrackerDb.AddParams(DataItem.TakenBeanLid, DbType.Boolean);
_TrackerDb.AddParams(DataItem.TakenWaterLid, DbType.Boolean);
_TrackerDb.AddParams(DataItem.BrokenFrother, DbType.Boolean);
_TrackerDb.AddParams(DataItem.BrokenBeanLid, DbType.Boolean);
_TrackerDb.AddParams(DataItem.BrokenWaterLid, DbType.Boolean);
_TrackerDb.AddParams(DataItem.RepairFaultID, DbType.Int32);
_TrackerDb.AddParams(DataItem.RepairFaultDesc, DbType.String);
_TrackerDb.AddParams(DataItem.RepairStatusID, DbType.Int32);
_TrackerDb.AddParams(DataItem.RelatedOrderID, DbType.Int64);
_TrackerDb.AddParams(DataItem.Notes, DbType.String);
_result = String.IsNullOrEmpty(_TrackerDb.ExecuteNonQuerySQL(CONST_SQL_INSERT));
_TrackerDb.Close();
return(_result);
}
public List <CityPrepDaysTbl> GetAllByCityId(int pCityID)
{
string _sqlCmd = CONST_SQL_SELECTBYCITYID;
//if (!String.IsNullOrEmpty(SortBy))
// _sqlCmd += " ORDER BY " + SortBy;
TrackerDb _TrackerDb = new TrackerDb();
_TrackerDb.AddWhereParams(pCityID, DbType.Int32);
List <CityPrepDaysTbl> _DataItems = new List <CityPrepDaysTbl>();
IDataReader _DataReader = _TrackerDb.ReturnIDataReader(_sqlCmd); // ExecuteSQLGetDataReader(_sqlCmd); // ReturnIDataReader(_sqlCmd);
if (_DataReader != null)
{
while (_DataReader.Read())
{
CityPrepDaysTbl _DataItem = new CityPrepDaysTbl();
_DataItem.CityID = pCityID;
_DataItem.CityPrepDaysID = (_DataReader["CityPrepDaysID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["CityPrepDaysID"]);
_DataItem.PrepDayOfWeekID = (_DataReader["PrepDayOfWeekID"] == DBNull.Value) ? byte.MinValue : Convert.ToByte(_DataReader["PrepDayOfWeekID"]);
_DataItem.DeliveryDelayDays = (_DataReader["DeliveryDelayDays"] == DBNull.Value) ? 0 : Convert.ToInt16(_DataReader["DeliveryDelayDays"]);
_DataItem.DeliveryOrder = (_DataReader["DeliveryOrder"] == DBNull.Value) ? 0 : Convert.ToInt16(_DataReader["DeliveryOrder"]);
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TrackerDb.Close();
return(_DataItems);
}
public List <CityPrepDaysTbl> GetAll(string SortBy)
{
TrackerDb _TrackerDb = new TrackerDb();
string _sqlCmd = CONST_SQL_SELECT;
if (!String.IsNullOrEmpty(SortBy))
{
_sqlCmd += " ORDER BY " + SortBy;
}
List <CityPrepDaysTbl> _DataItems = new List <CityPrepDaysTbl>();
IDataReader _DataReader = _TrackerDb.ExecuteSQLGetDataReader(_sqlCmd);
if (_DataReader != null)
{
while (_DataReader.Read())
{
CityPrepDaysTbl _DataItem = new CityPrepDaysTbl();
_DataItem.CityPrepDaysID = (_DataReader["CityPrepDaysID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["CityPrepDaysID"]);
_DataItem.CityID = (_DataReader["CityID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["CityID"]);
_DataItem.PrepDayOfWeekID = (_DataReader["PrepDayOfWeekID"] == DBNull.Value) ? byte.MinValue : Convert.ToByte(_DataReader["PrepDayOfWeekID"]);
_DataItem.DeliveryDelayDays = (_DataReader["DeliveryDelayDays"] == DBNull.Value) ? 0 : Convert.ToInt16(_DataReader["DeliveryDelayDays"]);
_DataItem.DeliveryOrder = (_DataReader["DeliveryOrder"] == DBNull.Value) ? 0 : Convert.ToInt16(_DataReader["DeliveryOrder"]);
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TrackerDb.Close();
return(_DataItems);
}
public string GetTransactionTypeByID(Int32 pTransactionID)
{
string _TransactionType = string.Empty;
TrackerDb _TDB = new TrackerDb();
// for some reason this is not working so have replaced with string
//_TDB.AddWhereParams(pTransactionID, DbType.Int32);
string _sql = CONST_SQL_SELECTTTANSACTIONBYID;
_sql = _sql.Replace("?", pTransactionID.ToString());
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(_sql);
if (_DataReader != null)
{
if (!_DataReader.Read())
{
_TransactionType = (_DataReader["TransactionType"] == DBNull.Value) ? string.Empty : _DataReader["TransactionType"].ToString();
}
else
{
_TransactionType = pTransactionID.ToString();
}
_DataReader.Close();
}
_TDB.Close();
return(_TransactionType);
}
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);
}
/// <summary>
/// Check to see if this contact has ever taken an item from this group before - if so return it otherwise return -1
/// </summary>
/// <param name="pContactID">The ID of the contact</param>
/// <param name="pGroupItemTypeID">The Group ID requesed</param>
/// <returns>True if it </returns>
public UsedItemGroupTbl ContactLastGroupItem(long pContactID, int pGroupItemTypeID)
{
UsedItemGroupTbl _DataItem = new UsedItemGroupTbl();
TrackerDb _TDB = new TrackerDb();
_TDB.AddWhereParams(pContactID, DbType.Int64, "@ContactID");
_TDB.AddWhereParams(pGroupItemTypeID, DbType.Int32, "@GroupItemTypeID");
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(CONST_SQL_GETGROUPITEMTYPED); //SELECT UsedItemGroupID, LastItemTypeID, LastItemTypeSortPos, LastItemDateChanged, Notes FROM UsedItemGroupTbl WHERE(ContactID = ?) AND (GroupItemTypeID = ?)";
if (_DataReader != null)
{
if (_DataReader.Read())
{
_DataItem.UsedItemGroupID = (_DataReader["UsedItemGroupID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["UsedItemGroupID"]);
_DataItem.ContactID = pContactID;
_DataItem.GroupItemTypeID = pGroupItemTypeID;
_DataItem.LastItemTypeID = (_DataReader["LastItemTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["LastItemTypeID"]);
_DataItem.LastItemTypeSortPos = (_DataReader["LastItemTypeSortPos"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["LastItemTypeSortPos"]);
_DataItem.LastItemDateChanged = (_DataReader["LastItemDateChanged"] == DBNull.Value) ? System.DateTime.Now : Convert.ToDateTime(_DataReader["LastItemDateChanged"]);
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
}
_DataReader.Close();
}
_TDB.Close();
return(_DataItem);
}
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 List <RepairFaultsTbl> GetAll(string SortBy)
{
List <RepairFaultsTbl> _DataItems = new List <RepairFaultsTbl>();
TrackerDb _TrackerDb = new TrackerDb();
string _sqlCmd = CONST_SQL_SELECT;
_sqlCmd += " ORDER BY " + (String.IsNullOrEmpty(SortBy) ? "SortOrder" : SortBy);
// params would go here if need
IDataReader _DataReader = _TrackerDb.ExecuteSQLGetDataReader(_sqlCmd);
if (_DataReader != null)
{
while (_DataReader.Read())
{
RepairFaultsTbl _DataItem = new RepairFaultsTbl();
_DataItem.RepairFaultID = (_DataReader["RepairFaultID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairFaultID"]);
_DataItem.RepairFaultDesc = (_DataReader["RepairFaultDesc"] == DBNull.Value) ? string.Empty : _DataReader["RepairFaultDesc"].ToString();
_DataItem.SortOrder = (_DataReader["SortOrder"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["SortOrder"]);
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TrackerDb.Close();
return(_DataItems);
}
public string Update(UsedItemGroupTbl pUsedItemGroupTbl, int pOrignal_UsedItemGroupID)
{
string _result = string.Empty;
TrackerDb _TDB = new TrackerDb();
#region UpdateParameters
if (pOrignal_UsedItemGroupID > 0)
{
_TDB.AddWhereParams(pOrignal_UsedItemGroupID, DbType.Int32); // check this line it assumes id field is int32
}
else
{
_TDB.AddWhereParams(pUsedItemGroupTbl.UsedItemGroupID, DbType.Int32, "@UsedItemGroupID");
}
_TDB.AddParams(pUsedItemGroupTbl.ContactID, DbType.Int64, "@ContactID");
_TDB.AddParams(pUsedItemGroupTbl.GroupItemTypeID, DbType.Int32, "@GroupItemTypeID");
_TDB.AddParams(pUsedItemGroupTbl.LastItemTypeID, DbType.Int32, "@LastItemTypeID");
_TDB.AddParams(pUsedItemGroupTbl.LastItemTypeSortPos, DbType.Int32, "@LastItemTypeSortPos");
_TDB.AddParams(pUsedItemGroupTbl.LastItemDateChanged, DbType.Date, "@LastItemDateChanged");
_TDB.AddParams(pUsedItemGroupTbl.Notes, DbType.String, "@Notes");
#endregion
// Now we have the parameters excute the SQL
_result = _TDB.ExecuteNonQuerySQL(CONST_SQL_UPDATE); // UPDATE UsedItemGroupTbl SET ContactID = ?, GroupItemTypeID = ?, LastItemTypeID = ?, LastItemTypeSortPos = ?, LastItemDateChanged = ?, Notes = ? WHERE (UsedItemGroupID = ?)";
_TDB.Close();
return(_result);
}
public int GetServiceID(int pItemID)
{
//string _connectionStr = ConfigurationManager.ConnectionStrings[QOnT.classes.TrackerDb.CONST_CONSTRING].ConnectionString;
TrackerDb _TDB = new TrackerDb();
//using (OdbcConnection _conn = new OdbcConnection(_connectionStr))
//{
int _ServiceID = 0;
//OdbcCommand _cmd = new OdbcCommand(CONST_SQL_SELECTSERVICETYPEID, _conn); // run the qurey we have built
//_cmd.Parameters.Add(new OdbcParameter { Value = pItemID });
//_conn.Open();
//OdbcDataReader _DataReader = _cmd.ExecuteReader();
_TDB.AddWhereParams(pItemID, DbType.Int32);
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(CONST_SQL_SELECTSERVICETYPEID);
if (_DataReader.Read())
{
_ServiceID = (_DataReader["ServiceTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["ServiceTypeID"]);
}
//}
return(_ServiceID);
}
/// <summary>
/// Retrieve the customer's defaults as per the ClientTbl
/// </summary>
/// <param name="_CustID">the customer id</param>
/// <returns>Contact / Customers prefered items for ID passed</returns>
public ContactPreferedItems RetrieveCustomerPrefs(long _CustID)
{
// using custonmer id query the customers table to get the customers preferences.
// prep the TTools connection, if it has not already been preped
TrackerDb _TDB = new TrackerDb();
ContactPreferedItems _ContactPreferedItems = new ContactPreferedItems(_CustID);
// get the customers City
string _sqlStr = "SELECT CustomersTbl.PreferedAgent, CustomersTbl.CoffeePreference, CustomersTbl.PriPrefQty, CustomersAccInfoTbl.RequiresPurchOrder " +
" FROM (CustomersTbl LEFT OUTER JOIN CustomersAccInfoTbl ON CustomersTbl.CustomerID = CustomersAccInfoTbl.CustomerID) WHERE CustomersTbl.CustomerID = " + _CustID.ToString();
IDataReader _Reader = _TDB.ExecuteSQLGetDataReader(_sqlStr);
if (_Reader != null)
{
if (_Reader.Read())
{
_ContactPreferedItems.DeliveryByID = (_Reader["PreferedAgent"] == DBNull.Value) ? CONST_DEFAULT_DELIVERYBYID : (int)_Reader["PreferedAgent"];
_ContactPreferedItems.PreferedItem = (_Reader["CoffeePreference"] == DBNull.Value) ? 0 : (int)_Reader["CoffeePreference"];
_ContactPreferedItems.PreferedQty = (_Reader["PriPrefQty"] == DBNull.Value) ? 1 : Convert.ToDouble(_Reader["PriPrefQty"]);
_ContactPreferedItems.RequiresPurchOrder = (_Reader["RequiresPurchOrder"] == DBNull.Value) ? false : (bool)(_Reader["RequiresPurchOrder"]);
}
_Reader.Close();
}
_TDB.Close();
return(_ContactPreferedItems);
}
public List <CustomerTypeTbl> GetAll(string SortBy)
{
List <CustomerTypeTbl> _DataItems = new List <CustomerTypeTbl>();
//string _connectionStr = ConfigurationManager.ConnectionStrings[QOnT.classes.TrackerDb.CONST_CONSTRING].ConnectionString;
TrackerDb _TDB = new TrackerDb();
//using (OdbcConnection _conn = new OdbcConnection(_connectionStr))
//{
string _sqlCmd = CONST_SQL_SELECT;
if (!String.IsNullOrEmpty(SortBy))
{
_sqlCmd += " ORDER BY " + SortBy; // Add order by string
}
//OdbcCommand _cmd = new OdbcCommand(_sqlCmd, _conn); // run the qurey we have built
//_conn.Open();
// OdbcDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(_sqlCmd);
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(_sqlCmd);
while (_DataReader.Read())
{
CustomerTypeTbl _DataItem = new CustomerTypeTbl();
_DataItem.CustTypeID = (_DataReader["CustTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["CustTypeID"]);
_DataItem.CustTypeDesc = (_DataReader["CustTypeDesc"] == DBNull.Value) ? string.Empty : _DataReader["CustTypeDesc"].ToString();
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
_DataItems.Add(_DataItem);
}
//}
return(_DataItems);
}
public CustomersTbl GetCustomersByCustomerID(long pCustomerID, string pSortBy)
{
List <CustomersTbl> _ListCustomersTblData = new List <CustomersTbl>();
TrackerDb _TrackerDb = new TrackerDb();
//string _connectionStr = ConfigurationManager.ConnectionStrings[CONST_CONSTRING].ConnectionString;
string _sqlCmd = CONST_SQL_CUSTOMERS_SELECT;
if (pCustomerID > 0)
{
_sqlCmd += " WHERE CustomerID = ? ";
}
if (!String.IsNullOrEmpty(pSortBy))
{
_sqlCmd += " ORDER BY " + pSortBy;
}
// run the qurey we have built
if (pCustomerID > 0)
{
_TrackerDb.AddWhereParams(pCustomerID, DbType.Int64); // Parameters.Add(new OdbcParameter { Value = pCustomerID });
}
IDataReader _DataReader = _TrackerDb.ExecuteSQLGetDataReader(_sqlCmd);
while (_DataReader.Read())
{
_ListCustomersTblData.Add(MoveReaderDataToCustomersTblData(_DataReader)); //_CustomersTblData);
}
_TrackerDb.Close();
return(_ListCustomersTblData[0]);
}
public List <ReoccuranceTypeTbl> GetAll(string SortBy)
{
List <ReoccuranceTypeTbl> _DataItems = new List <ReoccuranceTypeTbl>();
TrackerDb _TDB = new TrackerDb();
// string _connectionStr = CONST_CONSTRING;
//using (OleDbConnection _conn = new OleDbConnection(_connectionStr))
//{
string _sqlCmd = CONST_SQL_SELECT;
if (!String.IsNullOrEmpty(SortBy))
{
_sqlCmd += " ORDER BY " + SortBy; // Add order by string
}
//OleDbCommand _cmd = new OleDbCommand(_sqlCmd, _conn); // run the qurey we have built
//_conn.Open();
//OleDbDataReader _DataReader = _cmd.ExecuteReader();
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(_sqlCmd);
while (_DataReader.Read())
{
ReoccuranceTypeTbl _DataItem = new ReoccuranceTypeTbl();
_DataItem.ID = (_DataReader["ID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["ID"]);
_DataItem.Type = (_DataReader["Type"] == DBNull.Value) ? string.Empty : _DataReader["Type"].ToString();
_DataItems.Add(_DataItem);
}
//}
_DataReader.Close();
_TDB.Close();
return(_DataItems);
}
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(CustomersAccInfoTbl pCustomersAccInfoTbl, long pOrignal_CustomersAccInfoID)
{
string _result = string.Empty;
TrackerDb _TDB = new TrackerDb();
if (pCustomersAccInfoTbl.CustomerID == 0)
{
_result = "error: CustomerID cannot be 0";
}
else
{
#region UpdateParameters
if (pOrignal_CustomersAccInfoID > 0)
{
_TDB.AddWhereParams(pOrignal_CustomersAccInfoID, DbType.Int64); // check this line it assumes id field is int32
}
else
{
_TDB.AddWhereParams(pCustomersAccInfoTbl.CustomersAccInfoID, DbType.Int64, "@CustomersAccInfoID");
}
_TDB.AddParams(pCustomersAccInfoTbl.CustomerID, DbType.Int64, "@CustomerID");
_TDB.AddParams(pCustomersAccInfoTbl.RequiresPurchOrder, DbType.Int32, "@RequiresPurchOrder");
_TDB.AddParams(pCustomersAccInfoTbl.CustomerVATNo, DbType.String, "@CustomerVATNo");
_TDB.AddParams(pCustomersAccInfoTbl.BillAddr1, DbType.String, "@BillAddr1");
_TDB.AddParams(pCustomersAccInfoTbl.BillAddr2, DbType.String, "@BillAddr2");
_TDB.AddParams(pCustomersAccInfoTbl.BillAddr3, DbType.String, "@BillAddr3");
_TDB.AddParams(pCustomersAccInfoTbl.BillAddr4, DbType.String, "@BillAddr4");
_TDB.AddParams(pCustomersAccInfoTbl.BillAddr5, DbType.String, "@BillAddr5");
_TDB.AddParams(pCustomersAccInfoTbl.ShipAddr1, DbType.String, "@ShipAddr1");
_TDB.AddParams(pCustomersAccInfoTbl.ShipAddr2, DbType.String, "@ShipAddr2");
_TDB.AddParams(pCustomersAccInfoTbl.ShipAddr3, DbType.String, "@ShipAddr3");
_TDB.AddParams(pCustomersAccInfoTbl.ShipAddr4, DbType.String, "@ShipAddr4");
_TDB.AddParams(pCustomersAccInfoTbl.ShipAddr5, DbType.String, "@ShipAddr5");
_TDB.AddParams(pCustomersAccInfoTbl.AccEmail, DbType.String, "@AccEmail");
_TDB.AddParams(pCustomersAccInfoTbl.AltAccEmail, DbType.String, "@AltAccEmail");
_TDB.AddParams(pCustomersAccInfoTbl.PaymentTermID, DbType.Int32, "@PaymentTermID");
_TDB.AddParams(pCustomersAccInfoTbl.Limit, DbType.Double, "@Limit");
_TDB.AddParams(pCustomersAccInfoTbl.FullCoName, DbType.String, "@FullCoName");
_TDB.AddParams(pCustomersAccInfoTbl.AccFirstName, DbType.String, "@AccFirstName");
_TDB.AddParams(pCustomersAccInfoTbl.AccLastName, DbType.String, "@AccLastName");
_TDB.AddParams(pCustomersAccInfoTbl.AltAccFirstName, DbType.String, "@AltAccFirstName");
_TDB.AddParams(pCustomersAccInfoTbl.AltAccLastName, DbType.String, "@AltAccLastName");
_TDB.AddParams(pCustomersAccInfoTbl.PriceLevelID, DbType.Int32, "@PriceLevelID");
_TDB.AddParams(pCustomersAccInfoTbl.InvoiceTypeID, DbType.Int32, "@InvoiceTypeID");
_TDB.AddParams(pCustomersAccInfoTbl.RegNo, DbType.String, "@RegNo");
_TDB.AddParams(pCustomersAccInfoTbl.BankAccNo, DbType.String, "@BankAccNo");
_TDB.AddParams(pCustomersAccInfoTbl.BankBranch, DbType.String, "@BankBranch");
_TDB.AddParams(pCustomersAccInfoTbl.Enabled, DbType.Boolean, "@Enabled");
_TDB.AddParams(pCustomersAccInfoTbl.Notes, DbType.String, "@Notes");
#endregion
// Now we have the parameters excute the SQL
_result = _TDB.ExecuteNonQuerySQL(CONST_SQL_UPDATE);
_TDB.Close();
}
return(_result);
}
public List <CustomersAccInfoTbl> GetAll(string SortBy)
{
List <CustomersAccInfoTbl> _DataItems = new List <CustomersAccInfoTbl>();
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())
{
CustomersAccInfoTbl _DataItem = new CustomersAccInfoTbl();
#region StoreThisDataItem
_DataItem.CustomersAccInfoID = (_DataReader["CustomersAccInfoID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["CustomersAccInfoID"]);
_DataItem.CustomerID = (_DataReader["CustomerID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["CustomerID"]);
_DataItem.RequiresPurchOrder = (_DataReader["RequiresPurchOrder"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["RequiresPurchOrder"]);
_DataItem.CustomerVATNo = (_DataReader["CustomerVATNo"] == DBNull.Value) ? string.Empty : _DataReader["CustomerVATNo"].ToString();
_DataItem.BillAddr1 = (_DataReader["BillAddr1"] == DBNull.Value) ? string.Empty : _DataReader["BillAddr1"].ToString();
_DataItem.BillAddr2 = (_DataReader["BillAddr2"] == DBNull.Value) ? string.Empty : _DataReader["BillAddr2"].ToString();
_DataItem.BillAddr3 = (_DataReader["BillAddr3"] == DBNull.Value) ? string.Empty : _DataReader["BillAddr3"].ToString();
_DataItem.BillAddr4 = (_DataReader["BillAddr4"] == DBNull.Value) ? string.Empty : _DataReader["BillAddr4"].ToString();
_DataItem.BillAddr5 = (_DataReader["BillAddr5"] == DBNull.Value) ? string.Empty : _DataReader["BillAddr5"].ToString();
_DataItem.ShipAddr1 = (_DataReader["ShipAddr1"] == DBNull.Value) ? string.Empty : _DataReader["ShipAddr1"].ToString();
_DataItem.ShipAddr2 = (_DataReader["ShipAddr2"] == DBNull.Value) ? string.Empty : _DataReader["ShipAddr2"].ToString();
_DataItem.ShipAddr3 = (_DataReader["ShipAddr3"] == DBNull.Value) ? string.Empty : _DataReader["ShipAddr3"].ToString();
_DataItem.ShipAddr4 = (_DataReader["ShipAddr4"] == DBNull.Value) ? string.Empty : _DataReader["ShipAddr4"].ToString();
_DataItem.ShipAddr5 = (_DataReader["ShipAddr5"] == DBNull.Value) ? string.Empty : _DataReader["ShipAddr5"].ToString();
_DataItem.AccEmail = (_DataReader["AccEmail"] == DBNull.Value) ? string.Empty : _DataReader["AccEmail"].ToString();
_DataItem.AltAccEmail = (_DataReader["AltAccEmail"] == DBNull.Value) ? string.Empty : _DataReader["AltAccEmail"].ToString();
_DataItem.PaymentTermID = (_DataReader["PaymentTermID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["PaymentTermID"]);
_DataItem.Limit = (_DataReader["Limit"] == DBNull.Value) ? 0.0 : Convert.ToDouble(_DataReader["Limit"]);
_DataItem.FullCoName = (_DataReader["FullCoName"] == DBNull.Value) ? string.Empty : _DataReader["FullCoName"].ToString();
_DataItem.AccFirstName = (_DataReader["AccFirstName"] == DBNull.Value) ? string.Empty : _DataReader["AccFirstName"].ToString();
_DataItem.AccLastName = (_DataReader["AccLastName"] == DBNull.Value) ? string.Empty : _DataReader["AccLastName"].ToString();
_DataItem.AltAccFirstName = (_DataReader["AltAccFirstName"] == DBNull.Value) ? string.Empty : _DataReader["AltAccFirstName"].ToString();
_DataItem.AltAccLastName = (_DataReader["AltAccLastName"] == DBNull.Value) ? string.Empty : _DataReader["AltAccLastName"].ToString();
_DataItem.PriceLevelID = (_DataReader["PriceLevelID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["PriceLevelID"]);
_DataItem.InvoiceTypeID = (_DataReader["InvoiceTypeID"] == DBNull.Value) ? InvoiceTypeTbl.CONST_DEFAULT_INVOICETYPEID : Convert.ToInt32(_DataReader["InvoiceTypeID"]);
_DataItem.RegNo = (_DataReader["RegNo"] == DBNull.Value) ? string.Empty : _DataReader["RegNo"].ToString();
_DataItem.BankAccNo = (_DataReader["BankAccNo"] == DBNull.Value) ? string.Empty : _DataReader["BankAccNo"].ToString();
_DataItem.BankBranch = (_DataReader["BankBranch"] == DBNull.Value) ? string.Empty : _DataReader["BankBranch"].ToString();
_DataItem.Enabled = (_DataReader["Enabled"] == DBNull.Value) ? true : 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 DeleteByCityPrepDayID(int pCityPrepDayID)
{
string _result = string.Empty;
TrackerDb _TDB = new TrackerDb();
_TDB.AddWhereParams(pCityPrepDayID, DbType.Int32, "@CityPrepDayID");
_result = _TDB.ExecuteNonQuerySQL(CONST_SQL_DELETEBYID);
_TDB.Close();
return(_result);
}
public string Delete(int pPaymentTermID)
{
string _result = string.Empty;
TrackerDb _TDB = new TrackerDb();
_TDB.AddWhereParams(pPaymentTermID, DbType.Int32, "@PaymentTermID");
_result = _TDB.ExecuteNonQuerySQL(CONST_SQL_DELETE);
_TDB.Close();
return(_result);
}
public string DeleteRepair(int RepairID)
{
string _result = String.Empty;
TrackerDb _TrackerDb = new TrackerDb();
_TrackerDb.AddParams(RepairID, DbType.Int32);
_result = _TrackerDb.ExecuteNonQuerySQL(CONST_SQL_DELETE);
return(_result);
}
