static CustomersTbl MoveReaderDataToCustomersTblData(IDataReader pDataReader)
{
CustomersTbl _CustomersTblData = new CustomersTbl();
_CustomersTblData.CustomerID = Convert.ToInt64(pDataReader["CustomerID"]);
_CustomersTblData.CompanyName = (pDataReader["CompanyName"] == DBNull.Value) ? "" : pDataReader["CompanyName"].ToString();
_CustomersTblData.ContactTitle = (pDataReader["ContactTitle"] == DBNull.Value) ? "" : pDataReader["ContactTitle"].ToString();
_CustomersTblData.ContactFirstName = (pDataReader["ContactFirstName"] == DBNull.Value) ? "" : pDataReader["ContactFirstName"].ToString();
_CustomersTblData.ContactLastName = (pDataReader["ContactLastName"] == DBNull.Value) ? "" : pDataReader["ContactLastName"].ToString();
_CustomersTblData.ContactAltFirstName = (pDataReader["ContactAltFirstName"] == DBNull.Value) ? "" : pDataReader["ContactAltFirstName"].ToString();
_CustomersTblData.ContactAltLastName = (pDataReader["ContactAltLastName"] == DBNull.Value) ? "" : pDataReader["ContactAltLastName"].ToString();
_CustomersTblData.Department = (pDataReader["Department"] == DBNull.Value) ? "" : pDataReader["Department"].ToString();
_CustomersTblData.BillingAddress = (pDataReader["BillingAddress"] == DBNull.Value) ? "" : pDataReader["BillingAddress"].ToString();
_CustomersTblData.City = (pDataReader["City"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["City"]);
_CustomersTblData.Province = (pDataReader["Province"] == DBNull.Value) ? "" : pDataReader["Province"].ToString();
_CustomersTblData.PostalCode = (pDataReader["PostalCode"] == DBNull.Value) ? "" : pDataReader["PostalCode"].ToString();
_CustomersTblData.Region = (pDataReader["Region"] == DBNull.Value) ? "" : pDataReader["Region"].ToString();
_CustomersTblData.PhoneNumber = (pDataReader["PhoneNumber"] == DBNull.Value) ? "" : pDataReader["PhoneNumber"].ToString();
_CustomersTblData.Extension = (pDataReader["Extension"] == DBNull.Value) ? "" : pDataReader["Extension"].ToString();
_CustomersTblData.FaxNumber = (pDataReader["FaxNumber"] == DBNull.Value) ? "" : pDataReader["FaxNumber"].ToString();
_CustomersTblData.CellNumber = (pDataReader["CellNumber"] == DBNull.Value) ? "" : pDataReader["CellNumber"].ToString();
_CustomersTblData.EmailAddress = (pDataReader["EmailAddress"] == DBNull.Value) ? "" : pDataReader["EmailAddress"].ToString();
_CustomersTblData.AltEmailAddress = (pDataReader["AltEmailAddress"] == DBNull.Value) ? "" : pDataReader["AltEmailAddress"].ToString();
_CustomersTblData.ContractNo = (pDataReader["ContractNo"] == DBNull.Value) ? "" : pDataReader["ContractNo"].ToString();
_CustomersTblData.CustomerTypeID = (pDataReader["CustomerTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["CustomerTypeID"]);
_CustomersTblData.EquipType = (pDataReader["EquipType"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["EquipType"]);
_CustomersTblData.CoffeePreference = (pDataReader["CoffeePreference"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["CoffeePreference"]);
_CustomersTblData.PriPrefQty = (pDataReader["PriPrefQty"] == DBNull.Value) ? 1 : Convert.ToDouble(pDataReader["PriPrefQty"]);
_CustomersTblData.PrefPrepTypeID = (pDataReader["PrefPrepTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["PrefPrepTypeID"]);
_CustomersTblData.PrefPackagingID = (pDataReader["PrefPackagingID"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["PrefPackagingID"]);
_CustomersTblData.SecondaryPreference = (pDataReader["SecondaryPreference"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["SecondaryPreference"]);
_CustomersTblData.SecPrefQty = (pDataReader["SecPrefQty"] == DBNull.Value) ? 1 : Convert.ToDouble(pDataReader["SecPrefQty"]);
_CustomersTblData.TypicallySecToo = (pDataReader["TypicallySecToo"] == DBNull.Value) ? false : Convert.ToBoolean(pDataReader["TypicallySecToo"]);
_CustomersTblData.PreferedAgent = (pDataReader["PreferedAgent"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["PreferedAgent"]);
_CustomersTblData.SalesAgentID = (pDataReader["SalesAgentID"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["SalesAgentID"]);
_CustomersTblData.MachineSN = (pDataReader["MachineSN"] == DBNull.Value) ? "" : pDataReader["MachineSN"].ToString();
_CustomersTblData.UsesFilter = (pDataReader["UsesFilter"] == DBNull.Value) ? false : Convert.ToBoolean(pDataReader["UsesFilter"]);
_CustomersTblData.autofulfill = (pDataReader["autofulfill"] == DBNull.Value) ? false : Convert.ToBoolean(pDataReader["autofulfill"]);
_CustomersTblData.enabled = (pDataReader["enabled"] == DBNull.Value) ? false : Convert.ToBoolean(pDataReader["enabled"]);
_CustomersTblData.PredictionDisabled = (pDataReader["PredictionDisabled"] == DBNull.Value) ? false : Convert.ToBoolean(pDataReader["PredictionDisabled"]);
_CustomersTblData.AlwaysSendChkUp = (pDataReader["AlwaysSendChkUp"] == DBNull.Value) ? false : Convert.ToBoolean(pDataReader["AlwaysSendChkUp"]);
_CustomersTblData.NormallyResponds = (pDataReader["NormallyResponds"] == DBNull.Value) ? false : Convert.ToBoolean(pDataReader["NormallyResponds"]);
_CustomersTblData.ReminderCount = (pDataReader["ReminderCount"] == DBNull.Value) ? 0 : Convert.ToInt32(pDataReader["ReminderCount"]);
_CustomersTblData.Notes = (pDataReader["Notes"] == DBNull.Value) ? "" : pDataReader["Notes"].ToString();
return(_CustomersTblData);
}
public string UpdateCustomer(CustomersTbl ThisCustomerTblData, long CustomerIDToUpdate)
{
string errString = "";
// string _connectionStr = ConfigurationManager.ConnectionStrings[CONST_CONSTRING].ConnectionString;
//using (OdbcConnection _conn = new OdbcConnection(_connectionStr))
//{
// string _sqlCmd = CONST_SQL_CUSTOMERS_UPDATE;
// OdbcCommand _cmd = new OdbcCommand(_sqlCmd, _conn);
// #region Parameters
// // Add data sent
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.CompanyName });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactTitle });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactFirstName });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactLastName });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactAltFirstName });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactAltLastName });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Department });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.BillingAddress });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.City });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Province });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PostalCode });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Region });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PhoneNumber });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Extension });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.FaxNumber });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.CellNumber });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.EmailAddress });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.AltEmailAddress });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContractNo });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.CustomerTypeID });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.EquipType });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.CoffeePreference });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PriPrefQty });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PrefPrepTypeID });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PrefPackagingID });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.SecondaryPreference });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.SecPrefQty });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.TypicallySecToo });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PreferedAgent });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.SalesAgentID });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.MachineSN });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.UsesFilter });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.autofulfill });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.enabled });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PredictionDisabled });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.AlwaysSendChkUp });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.NormallyResponds });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ReminderCount });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Notes });
// // " WHERE CustomersTbl.CustomerID = ?)";
// _cmd.Parameters.Add(new OdbcParameter { Value = CustomerIDToUpdate });
// /// last paramatere Cust ID
// ///// others here
// #endregion
// try
// {
// _conn.Open();
// if (_cmd.ExecuteNonQuery() > 0)
// errString = "";
// else
// errString += " - error ";
// }
// catch (OdbcException oleErr)
// {
// // Handle exception.
// errString += " ERROR: " + oleErr.Message;
// }
// finally
// {
// _conn.Close();
// }
//}
return(errString);
}
public bool InsertCustomer(CustomersTbl ThisCustomerTblData, ref string pErrorStr)
{
bool _RecsInserted = false;
pErrorStr = "";
// string _connectionStr = ConfigurationManager.ConnectionStrings[CONST_CONSTRING].ConnectionString;
//using (OdbcConnection _conn = new OdbcConnection(_connectionStr))
//{
// string _sqlCmd = CONST_SQL_CUSTOMERS_INSERT;
// OdbcCommand _cmd = new OdbcCommand(_sqlCmd, _conn);
// #region Parameters
// // first summary data
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.CompanyName }); // Line 1.1
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactTitle }); // Line 1.2
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactFirstName }); // Line 1.3
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactLastName }); // Line 1.4
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactAltFirstName }); // Line 1.5
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContactAltLastName }); // Line 2.1
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Department }); // Line 2.2
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.BillingAddress }); // Line 2.3
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.City }); // Line 2.4
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Province }); // Line 2.5
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PostalCode });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Region });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PhoneNumber });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Extension });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.FaxNumber }); // End line 3
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.CellNumber });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.EmailAddress });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.AltEmailAddress });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ContractNo });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.CustomerTypeID }); // End Line 4
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.EquipType });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.CoffeePreference });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PriPrefQty });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PrefPrepTypeID });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PrefPackagingID }); // 5
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.SecondaryPreference });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.SecPrefQty });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.TypicallySecToo });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PreferedAgent });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.SalesAgentID }); // 6
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.MachineSN });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.UsesFilter });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.autofulfill });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.enabled });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.PredictionDisabled }); // 7
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.AlwaysSendChkUp });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.NormallyResponds });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.ReminderCount });
// _cmd.Parameters.Add(new OdbcParameter { Value = ThisCustomerTblData.Notes });
// #endregion
// try
// {
// _conn.Open();
// int _numInsert = _cmd.ExecuteNonQuery();
// _RecsInserted = (_numInsert > 0);
// }
// catch (OdbcException oleErr)
// {
// // Handle exception.
// pErrorStr = oleErr.Message;
// _RecsInserted = false;
// }
// finally
// {
// _conn.Close();
// }
//}
return(_RecsInserted);
}
public bool HandleAndUpdateRepairStatusChange(RepairsTbl pRepair)
{
// send email and handle status change
bool _Success = true;
switch (pRepair.RepairStatusID)
{
case CONST_REPAIRSTATUS_LOGGED:
{
_Success = LogARepair(pRepair, true);
break;
}
case CONST_REPAIRSTATUS_COLLECTED:
{
if (pRepair.RelatedOrderID.Equals(0))
{
_Success = LogARepair(pRepair, true);
}
else
{
OrderTbl _Order = new OrderTbl();
_Order.UpdateIncDeliveryDateBy7(pRepair.RelatedOrderID);
}
break;
}
case CONST_REPAIRSTATUS_WORKSHOP:
{
if (pRepair.RelatedOrderID.Equals(0))
{
_Success = LogARepair(pRepair, false);
}
else
{
OrderTbl _Order = new OrderTbl();
_Order.UpdateIncDeliveryDateBy7(pRepair.RelatedOrderID);
}
if (!String.IsNullOrEmpty(pRepair.MachineSerialNumber))
{
// if we have no serial number in the current Customer Tbl then update
CustomersTbl _Customers = new CustomersTbl();
_Customers.SetEquipDetailsIfEmpty(pRepair.MachineTypeID, pRepair.MachineSerialNumber, pRepair.CustomerID);
}
break;
}
case CONST_REPAIRSTATUS_READY:
{
if (pRepair.RelatedOrderID > 0)
{
OrderTbl _Order = new OrderTbl();
NextRoastDateByCityTbl _NextDates = new NextRoastDateByCityTbl();
_Order.UpdateOrderDeliveryDate(_NextDates.GetNextDeliveryDate(pRepair.CustomerID), pRepair.RelatedOrderID);
}
break;
}
case CONST_REPAIRSTATUS_DONE:
{
if (pRepair.RelatedOrderID > 0)
{
OrderTbl _Order = new OrderTbl();
_Order.UpdateSetDoneByID(true, pRepair.RelatedOrderID);
// ??? should we do this since it interupts with the Preiction Calculations
}
break;
}
default:
{
break;
}
}
_Success = String.IsNullOrEmpty(UpdateRepair(pRepair));
_Success = _Success && SendStatusChangeEmail(pRepair);
return(_Success);
}
