public Kandidat GetCandidate(long id) { try { string connectionString = ConnectionStringHelper.GetConnectionString(_configuration); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { ExecutorService repository = new ExecutorService(connection, transaction); List <SqlParameter> parameters = new List <SqlParameter>(); repository.AddParameterInList("@Id", id, SqlDbType.BigInt, ref parameters); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_CANDIDATE, parameters); Kandidat candidate = DataReaderConverter.ToObject <Kandidat>(dataReader); dataReader.Close(); return(candidate); } } } catch (Exception ex) { throw ex; } }
public PolitickiSubjekt GetPoliticalSubject(long id) { try { string connectionString = ConnectionStringHelper.GetConnectionString(_configuration); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction()) { ExecutorService repository = new ExecutorService(connection, transaction); List <SqlParameter> parameters = new List <SqlParameter>(); repository.AddParameterInList("@Id", id, SqlDbType.BigInt, ref parameters); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_POLITICALSUBJECT, parameters); PolitickiSubjekt politicalSubject = DataReaderConverter.ToObject <PolitickiSubjekt>(dataReader); dataReader.Close(); return(politicalSubject); } } } catch (Exception ex) { throw ex; } }