public GlasoviKandidat GetVotesById(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_CANDIDATES_VOTES_BY_ID, parameters); List <GlasoviKandidat> votes = DataReaderConverter.ToList <GlasoviKandidat>(dataReader); dataReader.Close(); transaction.Commit(); return(votes[0]); } } } catch (Exception ex) { throw ex; } }
public List <GlasoviKandidat> GetVotesByPoolingStation(long electionsId, long categoryId, long pollingStationId) { 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("@IzboriId", electionsId, SqlDbType.BigInt, ref parameters); repository.AddParameterInList("@KategorijaId", categoryId, SqlDbType.BigInt, ref parameters); repository.AddParameterInList("@BirackoMjestoId", pollingStationId, SqlDbType.BigInt, ref parameters); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_CANDIDATES_VOTES_BY_POLLINGSTATION, parameters); List <GlasoviKandidat> votes = DataReaderConverter.ToList <GlasoviKandidat>(dataReader); dataReader.Close(); transaction.Commit(); return(votes); } } } catch (Exception ex) { throw ex; } }
public List <GlasoviPolitickiSubjekt> GetVotesByPoliticalSubject(long electionsId, long categoryId, long politicalSubjectId) { 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("@IzboriId", electionsId, SqlDbType.BigInt, ref parameters); repository.AddParameterInList("@KategorijaId", categoryId, SqlDbType.BigInt, ref parameters); repository.AddParameterInList("@PolitickiSubjektId", politicalSubjectId, SqlDbType.BigInt, ref parameters); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_POLITICALSUBJECT_VOTES_BY_CATEGORY, parameters); List <GlasoviPolitickiSubjekt> votes = DataReaderConverter.ToList <GlasoviPolitickiSubjekt>(dataReader); dataReader.Close(); transaction.Commit(); return(votes); } } } catch (Exception ex) { throw ex; } }
public List <Kategorija> GetCategoriesForElections(long electionsId) { 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("@IzboriId", electionsId, SqlDbType.BigInt, ref parameters); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_CATEGORIES_BY_ELECTIONS, parameters); List <Kategorija> categories = DataReaderConverter.ToList <Kategorija>(dataReader); dataReader.Close(); transaction.Commit(); return(categories); } } } catch (Exception ex) { throw ex; } }
public List <Lokacija> GetAllLocations() { 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); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_ALL_LOCATIONS); List <Lokacija> constituencies = DataReaderConverter.ToList <Lokacija>(dataReader); dataReader.Close(); return(constituencies); } } } catch (Exception ex) { throw ex; } }
public List <BirackoMjesto> GetAllPollingStations() { 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); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_ALL_POLLINGSTATIONS); List <BirackoMjesto> pollingStations = DataReaderConverter.ToList <BirackoMjesto>(dataReader); dataReader.Close(); return(pollingStations); } } } catch (Exception ex) { throw ex; } }
public List <Opcina> GetAllMunicipalities() { 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); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_ALL_MUNICIPALITIES); List <Opcina> opcine = DataReaderConverter.ToList <Opcina>(dataReader); dataReader.Close(); return(opcine); } } } catch (Exception ex) { throw ex; } }
public List <PolitickiSubjekt> GetAllPoliticalSubjects() { 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); SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_ALL_POLITICALSUBJECT); List <PolitickiSubjekt> politicalSubjects = DataReaderConverter.ToList <PolitickiSubjekt>(dataReader); dataReader.Close(); return(politicalSubjects); } } } catch (Exception ex) { throw ex; } }