/**
* GET request that get one subsidiary
*/
public subsidiary GetSubsidiary(int id_subsidiary)
{
var query = "SELECT * FROM getSubsidiary(" + id_subsidiary + ");";
subsidiary sub = _context.Database.SqlQuery <subsidiary>(query).FirstOrDefault();
return(sub);
}
/**
* PUT request that updates a subsidiary
*/
public Response updateSubsidiary(int id_subsdiary, subsidiary sub)
{
Response res = new Response();
res.success = true;
res.code = "1";
res.message = "SUCCESSFUL";
try
{
var query = "SELECT updateSubsidiary(" + id_subsdiary + ", '" + sub.name + "', '" + sub.description + "', " + sub.company + ");";
_context.Database.SqlQuery <Boolean>(query).FirstOrDefault();
}
catch (NpgsqlException ex)
{
res.success = false;
res.code = ex.Code;
res.message = ex.BaseMessage;
}
return(res);
}
/**
* PUT request that updates a subsidiary
*/
public Response Put(int id, subsidiary sub)
{
return(repository.updateSubsidiary(id, sub));
}
/**
* POST request that inserts a subsidiary
*/
public Response Post(subsidiary sub)
{
return(repository.insertSubsidiary(sub));
}
