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