/// <summary> /// Insert Contact item into Temp Line /// </summary> /// <param name="pLineData">Contact Line Data to add</param> /// <returns>success or failure</returns> public bool InsertContactItems(ItemContactRequires pLineData) { bool _Success = false; TrackerDb _TDB = new TrackerDb(); #region Parameters // Add data sent CustomerId, OrderDate, RoastDate, RequiredByDate, ToBeDeliveredByID, Confirmed, Done, Notes _TDB.AddParams(pLineData.CustomerID, DbType.Int64, "@CustomerID"); _TDB.AddParams(pLineData.ItemID, DbType.Int32, "@ItemID"); _TDB.AddParams(pLineData.ItemQty, DbType.Double, "@ItemQty"); _TDB.AddParams(pLineData.ItemPrepID, DbType.Int32, "@ItemPrepID"); _TDB.AddParams(pLineData.ItemPackagID, DbType.Int32, "@ItemPackagID"); _TDB.AddParams(pLineData.AutoFulfill, DbType.Boolean, "@AutoFulfill"); _TDB.AddParams(pLineData.ReoccurID, DbType.Int64, "@ReoccurID"); #endregion _Success = String.IsNullOrEmpty(_TDB.ExecuteNonQuerySQL(CONST_SQL_INSERTNEWITEMS)); _TDB.Close(); return(_Success); }
public List <ItemContactRequires> GetAllContactItems(long CustomerID, string SortBy) { List <ItemContactRequires> _DataItems = new List <ItemContactRequires>(); if (CustomerID > 0) { string _sqlCmd = CONST_SQL_SELECTCONTACTITEMSBYCUST; _sqlCmd += (!String.IsNullOrEmpty(SortBy)) ? " ORDER BY " + SortBy : " ORDER BY ItemID"; // add default order TrackerDb _TDB = new TrackerDb(); _TDB.AddWhereParams(CustomerID, DbType.Int64, "@CustomerID"); IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(_sqlCmd); if (_DataReader != null) { while (_DataReader.Read()) { ItemContactRequires _DataItem = new ItemContactRequires(); _DataItem.TCIID = (_DataReader["TCIID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["TCIID"]); _DataItem.CustomerID = (_DataReader["CustomerID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["CustomerID"]); _DataItem.ItemID = (_DataReader["ItemID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["ItemID"]); _DataItem.ItemQty = (_DataReader["ItemQty"] == DBNull.Value) ? 0 : Convert.ToDouble(_DataReader["ItemQty"]); _DataItem.ItemPrepID = (_DataReader["ItemPrepID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["ItemPrepID"]); _DataItem.ItemPackagID = (_DataReader["ItemPackagID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["ItemPackagID"]); _DataItem.AutoFulfill = (_DataReader["AutoFulfill"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["AutoFulfill"]); _DataItem.ReoccurID = (_DataReader["ReoccurOrderID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["ReoccurOrderID"]); _DataItem.ReoccurOrder = (_DataItem.ReoccurID > 0); // _DataItem.NextDateRequired = (_DataReader["NextDateRequired"] == DBNull.Value) ? DateTime.MaxValue : Convert.ToDateTime(_DataReader["NextDateRequired"]); _DataItems.Add(_DataItem); } _DataReader.Close(); } _TDB.Close(); } return(_DataItems); }