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;
}
}
public void DeleteCandidate(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.DELETE_CANDIDATE, parameters);
dataReader.Close();
transaction.Commit();
}
}
}
catch (Exception ex)
{
throw ex;
}
}