public string UpdateRepair(TrackerDotNet.control.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 UpdateRepair(TrackerDotNet.control.RepairsTbl RepairItem)
{
return(UpdateRepair(RepairItem, RepairItem.RepairID));
}
