/**
* GET request that get one pharmaceutical house
*/
public pharmaceutical_house GetPharmaceuticalHousebyId(int id)
{
var query = "SELECT * FROM getPharmaceuticalHouse(" + id + ");";
pharmaceutical_house pharma = _context.Database.SqlQuery <pharmaceutical_house>(query).FirstOrDefault();
return(pharma);
}
/**
* PUT request that updates a pharmaceutical house
*/
public Response UpdatePharmaceuticalHouse(int id, pharmaceutical_house ph)
{
Response res = new Response();
res.success = true;
res.code = "1";
res.message = "SUCCESSFUL";
try
{
var query = "SELECT updatepharmaceuticalhouse(" + id + ",'" + ph.name + "');";
_context.Database.SqlQuery <Int32>(query).FirstOrDefault();
}
catch (NpgsqlException ex)
{
res.success = false;
res.code = ex.Code;
res.message = ex.BaseMessage;
}
return(res);
}
/**
* PUT request that updates a pharmaceutical house
*/
public Response Put(int id, pharmaceutical_house ph)
{
return(repository.UpdatePharmaceuticalHouse(id, ph));
}
/**
* POST request that inserts a pharmaceutical house
*/
public Response Post(pharmaceutical_house ph)
{
return(repository.AddPharmaceuticalHouse(ph));
}
