public bool saveValidationItem() { Decimal dMinFieldValue = 0; Decimal dMaxFieldValue = 0; String MinFieldValue = Util.getQ("Field_Min_" + ID); String MaxFieldValue = Util.getQ("Field_Max_" + ID); if (FieldType.ToLower() == "checkbox") { String FieldValue = Util.getQ("Field_" + ID); if (FieldValue == "1") { MinFieldValue = "1"; MaxFieldValue = "1"; } else { MinFieldValue = "0"; MaxFieldValue = "0"; } } Decimal.TryParse(MinFieldValue, out dMinFieldValue); Decimal.TryParse(MaxFieldValue, out dMaxFieldValue); //Delete from table if already saved String SQL = "DELETE FROM [DroneCheckListValidation] WHERE \n" + " [DroneID]= " + DroneID + " AND\n" + " [DroneCheckListID] = " + CheckListID + " AND\n" + " [DroneCheckListItemID] = " + ID; Util.doSQL(SQL); //Save Mi SQL = "INSERT INTO [DroneCheckListValidation](\n" + " [DroneID],\n" + " [DroneCheckListID],\n" + " [DroneCheckListItemID],\n" + " [MinValue],\n" + " [MaxValue],\n" + " [CanBeIgnored],\n" + " [MustBeChecked]\n" + ") VALUES (\n" + " " + DroneID + ",\n" + " " + CheckListID + ",\n" + " " + ID + ",\n" + " " + dMinFieldValue.ToString() + ",\n" + " " + dMaxFieldValue.ToString() + ",\n" + " 1,\n" + " 1\n" + ")"; Util.doSQL(SQL); return true; }