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 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 IActionResult Post([FromBody] PolitickiSubjekt politicalSubject) { long insertedId = _service.AddPoliticalSubject(politicalSubject); return(Ok(insertedId)); }
public IActionResult Put([FromBody] PolitickiSubjekt politicalSubject) { _service.UpdatePoliticalSubject(politicalSubject); return(Ok()); }
public IActionResult Get(long id) { PolitickiSubjekt politicalSubject = _service.GetPoliticalSubject(id); return(Ok(politicalSubject)); }