public List <Object> getRolesXEmployee(int id) { using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1()) { List <Object> client = new List <Object>(); try { if (!this.existEmployee(id)) { client = null; return(client); } var roles = construyeEntities.Roles.Where(e => e.id_employee == id).ToList(); for (int i = 0; i < roles.Count; ++i) { RoleSpecification_Data roleData = new RoleSpecification_Data(); roleData.id_role = roles.ElementAt(i).Role_specification.id; roleData.specification = roles.ElementAt(i).Role_specification.specification; client.Add(roleData); } return(client); } catch (Exception E) { client = null; return(client); } } }
public IHttpActionResult addRole([FromBody] RoleSpecification_Data data) { if (data == null) { //Bad request code 400 return(BadRequest()); } /* * if (roleSpecificationLogic.existRole(data.id_role)) * { * //petición correcta pero no pudo ser procesada porque ya existe el archivo code 202 * return StatusCode(HttpStatusCode.Accepted); * } */ if (roleSpecificationLogic.addRole(data)) { //petición correcta y se ha creado un nuevo recurso code 201 return(StatusCode(HttpStatusCode.Created)); } else { //No se pudo crear el recurso por un error interno code 500 return(InternalServerError()); } }
public RoleSpecification_Data GetRole(int ID) { RoleSpecification_Data result = new RoleSpecification_Data(); Role_specification role_Specification; using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1()) { try { if (!this.existRole(ID)) { result = null; return(result); } role_Specification = construyeEntities.Role_specification.Find(ID); result.id_role = role_Specification.id; result.specification = role_Specification.specification; return(result); } catch (Exception E) { result = null; return(result); } } }
public List <Object> GetListRole() { List <Object> dataList = new List <object>(); using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1()) { try { var providerList = construyeEntities.Role_specification.ToList(); int n = providerList.Count; if (n == 0) { dataList = null; return(dataList); } else { for (int i = 0; i < providerList.Count; ++i) { RoleSpecification_Data data = new RoleSpecification_Data(); data.id_role = providerList.ElementAt(i).id; data.specification = providerList.ElementAt(i).specification; dataList.Add(data); } return(dataList); } } catch { dataList = null; return(dataList); } } }
public bool updateRole(RoleSpecification_Data data) { using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1()) { try { var role = construyeEntities.Role_specification.Find(data.id_role); role.id = data.id_role; role.specification = data.specification; construyeEntities.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
public IHttpActionResult GetRole(int id) { if (!roleSpecificationLogic.existRole(id)) { //No se encontró el recurso code 404 return(NotFound()); } RoleSpecification_Data role = roleSpecificationLogic.GetRole(id); if (role != null) { // ok code 200 return(Ok(role)); } else { //No se pudo crear el recurso por un error interno code 500 return(InternalServerError()); } }
public bool addRole(RoleSpecification_Data data) { using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1()) { Role_specification role = new Role_specification(); role.id = data.id_role; role.specification = data.specification; try { construyeEntities.Role_specification.Add(role); construyeEntities.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
public IHttpActionResult updateRole([FromBody] RoleSpecification_Data data) { if (data == null) { //Bad request code 400 return(BadRequest()); } if (!roleSpecificationLogic.existRole(data.id_role)) { //petición correcta pero no pudo ser procesada porque no existe el archivo code 404 return(NotFound()); } if (roleSpecificationLogic.updateRole(data)) { //petición correcta y se ha creado un nuevo recurso code 200 ok return(Ok()); } else { //No se pudo crear el recurso por un error code 500 return(InternalServerError()); } }