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