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());
}
}
