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