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 long AddCandidate(Kandidat kandidat)
{
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("@ImePrezime", kandidat.imePrezime, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@JMBG", kandidat.jmbg, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Adresa", kandidat.adresa, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Telefon", kandidat.telefon, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Email", kandidat.email, SqlDbType.Text, ref parameters);
SqlDataReader dataReader = repository.ExecuteProcedure(Constants.ADD_CANDIDATE, parameters);
long insertedId = DataReaderConverter.ToBigInt(dataReader);
dataReader.Close();
transaction.Commit();
return(insertedId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateVotesOfCandidate(GlasoviKandidat votes)
{
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", votes.id, SqlDbType.BigInt, ref parameters);
repository.AddParameterInList("@BrojGlasova", votes.brojGlasova, SqlDbType.Int, ref parameters);
SqlDataReader dataReader = repository.ExecuteProcedure(Constants.UPDATE_NUMBER_OF_VOTES_CANDIDATE, parameters);
dataReader.Close();
transaction.Commit();
}
}
}
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;
}
}
public List <GlasoviKandidat> GetVotesByCandidate(long electionsId, long categoryId, long candidateId)
{
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("@KandidatId", candidateId, SqlDbType.BigInt, ref parameters);
SqlDataReader dataReader = repository.ExecuteProcedure(Constants.GET_CANDIDATE_VOTES, parameters);
List <GlasoviKandidat> votes = DataReaderConverter.ToList <GlasoviKandidat>(dataReader);
dataReader.Close();
transaction.Commit();
return(votes);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public GlasoviPolitickiSubjekt 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_POLITICALSUBJECTS_VOTES_BY_ID, parameters);
List <GlasoviPolitickiSubjekt> votes = DataReaderConverter.ToList <GlasoviPolitickiSubjekt>(dataReader);
dataReader.Close();
transaction.Commit();
return(votes[0]);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public long AddPoliticalSubject(PolitickiSubjekt politickiSubjekt)
{
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("@Sifra", politickiSubjekt.sifra, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Naziv", politickiSubjekt.naziv, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Adresa", politickiSubjekt.adresa, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Grad", politickiSubjekt.grad, SqlDbType.Text, ref parameters);
repository.AddParameterInList("@Telefon", politickiSubjekt.telefon, SqlDbType.Text, ref parameters);
SqlDataReader dataReader = repository.ExecuteProcedure(Constants.ADD_POLITICALSUBJECT, parameters);
long insertedId = DataReaderConverter.ToBigInt(dataReader);
dataReader.Close();
transaction.Commit();
return(insertedId);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <GlasoviPolitickiSubjekt> GetVotesByPollingStation(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_POLITICALSUBJECTS_VOTES_BY_CATEGORY_AND_POLLINGSTATION, 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 long AddElections(Izbori elections)
{
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("@VrstaIzboraId", elections.vrstaIzboraId, SqlDbType.BigInt, ref parameters);
repository.AddParameterInList("@NivoIzboraId", elections.nivoIzboraId, SqlDbType.BigInt, ref parameters);
repository.AddParameterInList("@DatumOdrzavanja", elections.datumOdrzavanja, SqlDbType.Date, ref parameters);
SqlDataReader dataReader = repository.ExecuteProcedure(Constants.ADD_ELECTIONS, parameters);
long insertedId = DataReaderConverter.ToBigInt(dataReader);
dataReader.Close();
transaction.Commit();
return(insertedId);
}
}
}
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;
}
}