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 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 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;
}
}
