public async Task <IActionResult> PutMlekara([FromRoute] int id, [FromBody] Mlekara mlekara)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != mlekara.MlekaraID)
{
return(BadRequest());
}
_context.Entry(mlekara).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MlekaraExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PostMlekara([FromBody] Mlekara mlekara)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Mlekare.Add(mlekara);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMlekara", new { id = mlekara.MlekaraID }, mlekara));
}
public IActionResult Post([FromBody] Mlekara mlekara)
{
broker.OtvoriKonekciju();
try
{
var command = new NpgsqlCommand($"INSERT INTO \"Mlekara\"(\"sifraMlekare\", pib, \"nazivMlekare\", \"maticniBroj\", \"pttMesta\")" +
$"VALUES('{mlekara.SifraMlekare}', '{mlekara.Pib}', '{mlekara.NazivMlekare}', '{mlekara.MaticniBroj}', '{mlekara.PttMesta}');", broker.connection);
command.ExecuteNonQuery();
}
catch (NpgsqlException ex)
{
return(Ok(ex.Message));
}
broker.ZatvoriKonekciju();
return(Ok(mlekara));
}
public IActionResult Get(int id)
{
broker.OtvoriKonekciju();
var command = new NpgsqlCommand(@"SELECT * FROM ""Mlekara"" WHERE ""sifraMlekare"" = '" + id + "';", broker.connection);
NpgsqlDataReader reader = command.ExecuteReader();
Mlekara mlekara = new Mlekara();
while (reader.Read())
{
mlekara.SifraMlekare = reader[0].ToString();
mlekara.Pib = reader[1].ToString();
mlekara.NazivMlekare = reader[2].ToString();
mlekara.MaticniBroj = reader[3].ToString();
mlekara.PttMesta = reader[4].ToString();
}
broker.ZatvoriKonekciju();
return(Ok(mlekara));
}
public IActionResult Put([FromBody] Mlekara mlekara)
{
broker.OtvoriKonekciju();
try
{
var command = new NpgsqlCommand($"UPDATE \"Mlekara\" SET \"sifraMlekare\" = '{mlekara.SifraMlekare}', " +
$"pib = '{mlekara.Pib}', " +
$"\"nazivMlekare\" = '{mlekara.NazivMlekare}', " +
$"\"maticniBroj\" = '{mlekara.MaticniBroj}', " +
$"\"pttMesta\" = '{mlekara.PttMesta}' " +
$"WHERE \"sifraMlekare\" = '{mlekara.SifraMlekare}';", broker.connection);
command.ExecuteNonQuery();
}
catch (NpgsqlException ex)
{
return(Ok(ex.Message));
}
broker.ZatvoriKonekciju();
return(Ok());
}
public IActionResult Get()
{
List <Mlekara> mlekare = new List <Mlekara>();
broker.OtvoriKonekciju();
var command = new NpgsqlCommand(@"SELECT * FROM ""Mlekara"";", broker.connection);
NpgsqlDataReader reader = command.ExecuteReader();
Mlekara m = new Mlekara();
while (reader.Read())
{
m = new Mlekara();
m.SifraMlekare = reader[0].ToString();
m.Pib = reader[1].ToString();
m.NazivMlekare = reader[2].ToString();
m.MaticniBroj = reader[3].ToString();
m.PttMesta = reader[4].ToString();
mlekare.Add(m);
}
broker.ZatvoriKonekciju();
return(Ok(mlekare));
}
