public Juror GetSummonsRecipientLogin(string socialLastFour, int juryId) { DataCommand command = new DataCommand("EXEC spGetSummonsRecipientLogin '" + socialLastFour + "', " + juryId); SqlDataReader dataReader = command.ExecuteReader(); Juror juror = dataReader.Read() ? Juror.GetJuror(dataReader.GetInt32(0)) : null; command.Close(); return(juror); }
public object GetSummonsRecipientLogin(string socialLastFour, int jurorId) { try { DataCommand command = new DataCommand("spGetSummonsRecipientLogin"); command.AddParameter("@socialLastFour", socialLastFour); command.AddParameter("@jurorId", jurorId); DataReader dataReader = command.ExecuteReader(); object juror = dataReader.Read() ? (object)Juror.GetJuror((int)dataReader.GetInteger("JurorID")) : (object)Json.Nothing; command.Close(); return(juror); } catch (Exception e) { return(Error.LogError(_logger, e)); } }