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