public static string DeleteSubmissionBySerial(Guid serialNumber)
{
string sqlQuery = @"DELETE FROM dbo.Submission
WHERE SerialNumber = @SerialNumber;";
int rowsDeleted = DBDataAccess.DeleteData(sqlQuery, new { SerialNumber = serialNumber });
return(rowsDeleted + " rows deleted.");
}