public IActionResult Get(int id) { broker.OtvoriKonekciju(); var command = new NpgsqlCommand(@"SELECT * FROM ""PodaciOMuzi"" WHERE ""rbPodatakaOMuzi"" = '" + id + "';", broker.connection); NpgsqlDataReader reader = command.ExecuteReader(); PodaciOMuzi pom = new PodaciOMuzi(); while (reader.Read()) { pom.RbPodatakOMuzi = Convert.ToInt32(reader[0]); pom.IdZivotinje = reader[1].ToString(); pom.KolicinaMleka = Convert.ToInt32(reader[2]); pom.VremeMuze = Convert.ToDateTime(reader[3].ToString()); } broker.ZatvoriKonekciju(); return(Ok(pom)); }
public IActionResult Put([FromBody] PodaciOMuzi podaciOMuzi) { broker.OtvoriKonekciju(); try { var command = new NpgsqlCommand($"UPDATE \"PodaciOMuzi\" SET \"rbPodatakaOMuzi\" = '{podaciOMuzi.RbPodatakOMuzi}', " + $"\"idZivotinje\" = '{podaciOMuzi.IdZivotinje}', " + $"\"kolicinaMleka\" = '{podaciOMuzi.KolicinaMleka}', " + $"\"vremeMuze\" = '{podaciOMuzi.VremeMuze}' " + $"WHERE \"rbPodatakaOMuzi\" = '{podaciOMuzi.RbPodatakOMuzi}';", broker.connection); command.ExecuteNonQuery(); } catch (NpgsqlException ex) { return(Ok(ex.Message)); } broker.ZatvoriKonekciju(); return(Ok()); }
public IActionResult Post([FromBody] PodaciOMuzi podaciOMuzi) { // TODO: call a procedure broker.OtvoriKonekciju(); try { var command = new NpgsqlCommand($"INSERT INTO \"PodaciOMuzi\"(\"rbPodatakaOMuzi\", \"idZivotinje\", \"kolicinaMleka\", \"vremeMuze\")" + $"VALUES('{podaciOMuzi.RbPodatakOMuzi}', '{podaciOMuzi.IdZivotinje}', '{podaciOMuzi.KolicinaMleka}', '{podaciOMuzi.VremeMuze}');", broker.connection); command.ExecuteNonQuery(); var command1 = new NpgsqlCommand($"CALL procedure_odrkolmleka('{podaciOMuzi.IdZivotinje}');", broker.connection); command1.ExecuteNonQuery(); } catch (NpgsqlException ex) { return(Ok(ex.Message)); } broker.ZatvoriKonekciju(); return(Ok(podaciOMuzi)); }