/*Funcion: actualizar equipos Param: EquipmentUpdateView,AuditDataFromWeb Return: status */ public CUDView updateEquipment(EquipmentUpdateView equipment, AuditDataFromWeb audit) { CUDView logic = new CUDView(); AuditDao auditDao = new AuditDao(); DataTable auditDaoResult = auditDao.getEquipmentOldValues(equipment.Id); String OldValues = "EquipmentId: " + equipment.Id; foreach (DataRow row in auditDaoResult.Rows) { if (auditDaoResult.Columns.Contains("HMI") && row["HMI"] != DBNull.Value) { OldValues = OldValues + ", HMIAddress: " + row["HMI"].ToString(); } if (auditDaoResult.Columns.Contains("Location") && row["Location"] != DBNull.Value) { OldValues = OldValues + ", Location: " + row["Location"].ToString(); } if (auditDaoResult.Columns.Contains("PLC") && row["PLC"] != DBNull.Value) { OldValues = OldValues + ", PLCAddress: " + row["PLC"].ToString(); } if (auditDaoResult.Columns.Contains("PLCLink") && row["PLCLink"] != DBNull.Value) { OldValues = OldValues + ", PLCLink: " + row["PLCLink"].ToString(); } if (auditDaoResult.Columns.Contains("Enabled") && row["Enabled"] != DBNull.Value) { OldValues = OldValues + ", Status: " + row["Enabled"].ToString(); } } EquipmentDao Dao = new EquipmentDao(); String state = Dao.updateEquipment(equipment); logic = CUDVerifyLogic.verifierInsertDeleteUpdate("update", state); if (logic.update == true) { AuditService auditservice = new AuditService(); String Action = "Update Equipment"; String newValues = "EquipmentId: " + equipment.Id; newValues = newValues + ", HMIAddress: " + equipment.HMIAddress; newValues = newValues + ", Location: " + equipment.Location; newValues = newValues + ", PLCAddress: " + equipment.PLCAddress; newValues = newValues + ", PLCLink: " + equipment.PLCLink; newValues = newValues + ", Status: " + equipment.Status; auditservice.formUpdate(Action, newValues, OldValues, audit); } return logic; }