//Takes the details of an appeal object into a string array for display purposes private String[] printAppeal(String rn) { Appeal temp = cdb.retAppeal(db2, rn); if (temp == null) { return(new String[] { "Appeal not found!", "Please check whether the entered reference number is correct." }); } String[] r = new String[6]; r[0] = "Appeal : " + temp.getType() + " - " + temp.getSub(); r[1] = "Reference Number : " + temp.getReference(); r[2] = "Submitted on : " + temp.getSubmit(); if (temp.isValidated()) { r[3] = "Validated: Yes"; } else { r[3] = "Validated: No"; } if (temp.isCompleted()) { r[4] = "Completed on : " + temp.getComplete(); } else { r[4] = "Progress : " + temp.getProgress(); } if (String.IsNullOrWhiteSpace(temp.getAdd())) { r[5] = ""; } else { r[5] = "Additional details: " + temp.getAdd(); } return(r); }
//Stores an Appeal object in the database public void storeAppeal(Water_Board_Management.Database d, Appeal apl) { Water_Board_Management.AppealRow ar = new Water_Board_Management.AppealRow(apl.getReference(), apl.getAccount(), apl.getType(), apl.getSub(), apl.getAdd(), apl.isCompleted(), apl.getSubmit(), apl.getComplete(), apl.getProgress(), apl.isValidated()); d.insert(ar); }