public IActionResult Post([FromBody] Izbori elections) { elections.datumOdrzavanja = DateTime.Now; long insertedId = _service.AddElections(elections); return(Ok(insertedId)); }
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; } }