private bool SendStatusChangeEmail(RepairsTbl pRepair)
{
EmailCls _Email = new EmailCls();
EquipTypeTbl _EquipTypes = new EquipTypeTbl();
RepairStatusesTbl _RepairStatuses = new RepairStatusesTbl();
_Email.SetEmailTo(pRepair.ContactEmail);
_Email.SetEmailSubject("Change to repair status - notification.");
_Email.AddStrAndNewLineToBody("<b>Repair Status Change Notification</b>");
_Email.AddFormatToBody("Dear {0}, <br /><br />", pRepair.ContactName);
_Email.AddFormatToBody("Please note that repair status of the {0}, serial number: {1}, has changed to <b>{2}</b>.<br /><br />",
_EquipTypes.GetEquipName(pRepair._MachineTypeID),
pRepair.MachineSerialNumber, _RepairStatuses.GetRepairStatusDesc(pRepair.RepairStatusID));
_Email.AddStrAndNewLineToBody("You are receiving this status update since your email address was assigned to the tracking of this repair.<br />");
_Email.AddStrAndNewLineToBody("Please note that Quaffee DOES NOT run a coffee machine repair workshop. As a service to our current coffee " +
"purchasing clients we will take the coffee machine to the workshop, give a swop out machine to the client, if available, and " +
"charge what we are charged by the workshop plus a small admin fee. Please note: we are not able to quote these repairs, if you would like " +
"to contact the workshop directly, please ask us for their details.<br />");
_Email.AddStrAndNewLineToBody("For clients that are not currently using our coffee, or have not used our coffee consistently over" +
" the last 3 months, we may at our discretion offer a swop out machine, at a fee, and also change a collection and delivery fee.<br />");
_Email.AddStrAndNewLineToBody("Any warantee on the repairs is carried by the workshop not by Quaffee.<br />");
_Email.AddStrAndNewLineToBody("The Quaffee Team");
_Email.AddStrAndNewLineToBody("web: <a href='http://www.quaffee.co.za'>quaffee.co.za</a>");
return(_Email.SendEmail());
}
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);
}
private List <RepairsTbl> GetAllRepairs(string SortBy, string pSQL, List <DBParameter> pWhereParams)
{
List <RepairsTbl> _DataItems = new List <RepairsTbl>();
TrackerDb _TrackerDb = new TrackerDb();
pSQL += " ORDER BY " + (String.IsNullOrEmpty(SortBy) ? "DateLogged DESC" : SortBy); // Add order by string
// params would go here if need
if (pWhereParams != null)
{
_TrackerDb.WhereParams = pWhereParams;
}
IDataReader _DataReader = _TrackerDb.ExecuteSQLGetDataReader(pSQL);
if (_DataReader != null)
{
while (_DataReader.Read())
{
RepairsTbl _DataItem = new RepairsTbl();
_DataItem.RepairID = (_DataReader["RepairID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairID"]);
_DataItem.CustomerID = (_DataReader["CustomerID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["CustomerID"]);
_DataItem.ContactName = (_DataReader["ContactName"] == DBNull.Value) ? string.Empty : _DataReader["ContactName"].ToString();
_DataItem.ContactEmail = (_DataReader["ContactEmail"] == DBNull.Value) ? string.Empty : _DataReader["ContactEmail"].ToString();
_DataItem.JobCardNumber = (_DataReader["JobCardNumber"] == DBNull.Value) ? string.Empty : _DataReader["JobCardNumber"].ToString();
_DataItem.DateLogged = (_DataReader["DateLogged"] == DBNull.Value) ? System.DateTime.Now.Date : Convert.ToDateTime(_DataReader["DateLogged"]).Date;
_DataItem.LastStatusChange = (_DataReader["LastStatusChange"] == DBNull.Value) ? System.DateTime.Now.Date : Convert.ToDateTime(_DataReader["LastStatusChange"]).Date;
_DataItem.MachineTypeID = (_DataReader["MachineTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["MachineTypeID"]);
_DataItem.MachineSerialNumber = (_DataReader["MachineSerialNumber"] == DBNull.Value) ? string.Empty : _DataReader["MachineSerialNumber"].ToString();
_DataItem.SwopOutMachineID = (_DataReader["SwopOutMachineID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["SwopOutMachineID"]);
_DataItem.MachineConditionID = (_DataReader["MachineConditionID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["MachineConditionID"]);
_DataItem.TakenFrother = (_DataReader["TakenFrother"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenFrother"]);
_DataItem.TakenBeanLid = (_DataReader["TakenBeanLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenBeanLid"]);
_DataItem.TakenWaterLid = (_DataReader["TakenWaterLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenWaterLid"]);
_DataItem.BrokenFrother = (_DataReader["BrokenFrother"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenFrother"]);
_DataItem.BrokenBeanLid = (_DataReader["BrokenBeanLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenBeanLid"]);
_DataItem.BrokenWaterLid = (_DataReader["BrokenWaterLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenWaterLid"]);
_DataItem.RepairFaultID = (_DataReader["RepairFaultID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairFaultID"]);
_DataItem.RepairFaultDesc = (_DataReader["RepairFaultDesc"] == DBNull.Value) ? string.Empty : _DataReader["RepairFaultDesc"].ToString();
_DataItem.RepairStatusID = (_DataReader["RepairStatusID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairStatusID"]);
_DataItem.RelatedOrderID = (_DataReader["RelatedOrderID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["RelatedOrderID"]);
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
_DataItems.Add(_DataItem);
}
_DataReader.Close();
}
_TrackerDb.Close();
return(_DataItems);
}
public RepairsTbl GetRepairById(int pRepairID)
{
RepairsTbl _DataItem = null;
if (pRepairID > 0)
{
TrackerDb _TrackerDb = new TrackerDb();
// params would go here if need
_TrackerDb.AddWhereParams(pRepairID, DbType.Int32);
IDataReader _DataReader = _TrackerDb.ExecuteSQLGetDataReader(CONST_SQL_SELECTBYREPAIRID);
if (_DataReader != null)
{
if (_DataReader.Read())
{
_DataItem = new RepairsTbl();
_DataItem.RepairID = pRepairID;
_DataItem.CustomerID = (_DataReader["CustomerID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["CustomerID"]);
_DataItem.ContactName = (_DataReader["ContactName"] == DBNull.Value) ? string.Empty : _DataReader["ContactName"].ToString();
_DataItem.ContactEmail = (_DataReader["ContactEmail"] == DBNull.Value) ? string.Empty : _DataReader["ContactEmail"].ToString();
_DataItem.JobCardNumber = (_DataReader["JobCardNumber"] == DBNull.Value) ? string.Empty : _DataReader["JobCardNumber"].ToString();
_DataItem.DateLogged = (_DataReader["DateLogged"] == DBNull.Value) ? System.DateTime.Now.Date : Convert.ToDateTime(_DataReader["DateLogged"]).Date;
_DataItem.LastStatusChange = (_DataReader["LastStatusChange"] == DBNull.Value) ? System.DateTime.Now.Date : Convert.ToDateTime(_DataReader["LastStatusChange"]).Date;
_DataItem.MachineTypeID = (_DataReader["MachineTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["MachineTypeID"]);
_DataItem.MachineSerialNumber = (_DataReader["MachineSerialNumber"] == DBNull.Value) ? string.Empty : _DataReader["MachineSerialNumber"].ToString();
_DataItem.SwopOutMachineID = (_DataReader["SwopOutMachineID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["SwopOutMachineID"]);
_DataItem.MachineConditionID = (_DataReader["MachineConditionID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["MachineConditionID"]);
_DataItem.TakenFrother = (_DataReader["TakenFrother"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenFrother"]);
_DataItem.TakenBeanLid = (_DataReader["TakenBeanLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenBeanLid"]);
_DataItem.TakenWaterLid = (_DataReader["TakenWaterLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenWaterLid"]);
_DataItem.BrokenFrother = (_DataReader["BrokenFrother"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenFrother"]);
_DataItem.BrokenBeanLid = (_DataReader["BrokenBeanLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenBeanLid"]);
_DataItem.BrokenWaterLid = (_DataReader["BrokenWaterLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenWaterLid"]);
_DataItem.RepairFaultID = (_DataReader["RepairFaultID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairFaultID"]);
_DataItem.RepairFaultDesc = (_DataReader["RepairFaultDesc"] == DBNull.Value) ? string.Empty : _DataReader["RepairFaultDesc"].ToString();
_DataItem.RepairStatusID = (_DataReader["RepairStatusID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairStatusID"]);
_DataItem.RelatedOrderID = (_DataReader["RelatedOrderID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["RelatedOrderID"]);
_DataItem.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
}
_DataReader.Close();
}
_TrackerDb.Close();
}
return(_DataItem);
}
public List <RepairsTbl> GetListOfRelatedTempOrders()
{
List <RepairsTbl> _RelatedRepairs = new List <RepairsTbl>(); // should only be one but check
TrackerDb _TDB = new TrackerDb();
IDataReader _DataReader = _TDB.ExecuteSQLGetDataReader(CONST_SQL_SELECTITEMWITHANORDER);
if (_DataReader != null)
{
while (_DataReader.Read())
{
RepairsTbl _RelatedRepair = new RepairsTbl();
_RelatedRepair.RepairID = (_DataReader["RepairID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairID"]);
_RelatedRepair.CustomerID = (_DataReader["CustomerID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["CustomerID"]);
_RelatedRepair.ContactName = (_DataReader["ContactName"] == DBNull.Value) ? string.Empty : _DataReader["ContactName"].ToString();
_RelatedRepair.ContactEmail = (_DataReader["ContactEmail"] == DBNull.Value) ? string.Empty : _DataReader["ContactEmail"].ToString();
_RelatedRepair.JobCardNumber = (_DataReader["JobCardNumber"] == DBNull.Value) ? string.Empty : _DataReader["JobCardNumber"].ToString();
_RelatedRepair.DateLogged = (_DataReader["DateLogged"] == DBNull.Value) ? System.DateTime.Now.Date : Convert.ToDateTime(_DataReader["DateLogged"]).Date;
_RelatedRepair.LastStatusChange = (_DataReader["LastStatusChange"] == DBNull.Value) ? System.DateTime.Now.Date : Convert.ToDateTime(_DataReader["LastStatusChange"]).Date;
_RelatedRepair.MachineTypeID = (_DataReader["MachineTypeID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["MachineTypeID"]);
_RelatedRepair.MachineSerialNumber = (_DataReader["MachineSerialNumber"] == DBNull.Value) ? string.Empty : _DataReader["MachineSerialNumber"].ToString();
_RelatedRepair.SwopOutMachineID = (_DataReader["SwopOutMachineID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["SwopOutMachineID"]);
_RelatedRepair.MachineConditionID = (_DataReader["MachineConditionID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["MachineConditionID"]);
_RelatedRepair.TakenFrother = (_DataReader["TakenFrother"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenFrother"]);
_RelatedRepair.TakenBeanLid = (_DataReader["TakenBeanLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenBeanLid"]);
_RelatedRepair.TakenWaterLid = (_DataReader["TakenWaterLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["TakenWaterLid"]);
_RelatedRepair.BrokenFrother = (_DataReader["BrokenFrother"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenFrother"]);
_RelatedRepair.BrokenBeanLid = (_DataReader["BrokenBeanLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenBeanLid"]);
_RelatedRepair.BrokenWaterLid = (_DataReader["BrokenWaterLid"] == DBNull.Value) ? false : Convert.ToBoolean(_DataReader["BrokenWaterLid"]);
_RelatedRepair.RepairFaultID = (_DataReader["RepairFaultID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairFaultID"]);
_RelatedRepair.RepairFaultDesc = (_DataReader["RepairFaultDesc"] == DBNull.Value) ? string.Empty : _DataReader["RepairFaultDesc"].ToString();
_RelatedRepair.RepairStatusID = (_DataReader["RepairStatusID"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["RepairStatusID"]);
_RelatedRepair.RelatedOrderID = (_DataReader["RelatedOrderID"] == DBNull.Value) ? 0 : Convert.ToInt64(_DataReader["RelatedOrderID"]);
_RelatedRepair.Notes = (_DataReader["Notes"] == DBNull.Value) ? string.Empty : _DataReader["Notes"].ToString();
_RelatedRepairs.Add(_RelatedRepair);
}
_DataReader.Close();
}
_TDB.Close();
return(_RelatedRepairs);
}
private bool LogARepair(RepairsTbl pRepair, bool pCalcOrderData)
{
bool _Success = false;
// create a new order for delivery [RoastDate]
OrderTblData _OrderData = new OrderTblData();
DateTime _RequiredByDate = DateTime.Now.Date.AddDays(7);
// add the default data to order
_OrderData.CustomerId = pRepair.CustomerID;
_OrderData.ItemTypeID = ItemTypeTbl.CONST_SERVICEITEMID;
_OrderData.QuantityOrdered = 1;
_OrderData.Notes = "Collect/Swop out Machine for Service";
// Calculate the Data from the customer details
if (pCalcOrderData)
{
TrackerTools _TT = new TrackerTools();
_OrderData.RoastDate = _TT.GetNextRoastDateByCustomerID(pRepair.CustomerID, ref _RequiredByDate);
TrackerTools.ContactPreferedItems _ContactPreferedItems = _TT.RetrieveCustomerPrefs(pRepair.CustomerID);
_OrderData.OrderDate = DateTime.Now.Date;
_OrderData.RequiredByDate = _RequiredByDate;
if (_ContactPreferedItems.RequiresPurchOrder)
{
_OrderData.PurchaseOrder = TrackerTools.CONST_POREQUIRED;
}
_OrderData.ToBeDeliveredBy = _ContactPreferedItems.DeliveryByID;
}
else
{
_OrderData.RoastDate = _OrderData.OrderDate = DateTime.Now.Date;
_OrderData.RequiredByDate = _RequiredByDate;
}
// save the data to the orders
OrderTbl _Order = new OrderTbl();
_Order.InsertNewOrderLine(_OrderData);
pRepair.RelatedOrderID = _Order.GetLastOrderAdded(_OrderData.CustomerId, _OrderData.OrderDate, ItemTypeTbl.CONST_SERVICEITEMID);
return(_Success);
}
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);
}