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