public Role_Data GetRoles(int ID)
{
Role_Data result = new Role_Data();
Role role;
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
if (!this.existRoles(ID))
{
result = null;
return(result);
}
role = construyeEntities.Roles.Find(ID);
result.id = role.id;
result.id_employee = role.id_employee;
result.id_role = role.id_role;
result.start_date = role.start_date;
return(result);
}
catch (Exception E)
{
result = null;
return(result);
}
}
}
public bool updateRoles(Role_Data data)
{
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var role = construyeEntities.Roles.Find(data.id_role);
role.id_role = data.id_role;
role.id_employee = data.id_employee;
role.start_date = data.start_date;
role.Role_specification = construyeEntities.Role_specification.Find(data.id_role);
role.Employee = construyeEntities.Employees.Find(data.id_employee);
construyeEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public List <Object> GetListRoles()
{
List <Object> dataList = new List <object>();
using (TeConstruyeEntities1 construyeEntities = new TeConstruyeEntities1())
{
try
{
var providerList = construyeEntities.Roles.ToList();
int n = providerList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < providerList.Count; ++i)
{
Role_Data data = new Role_Data();
data.id = providerList.ElementAt(i).id;
data.id_employee = providerList.ElementAt(i).id_employee;
data.id_role = providerList.ElementAt(i).id_role;
data.start_date = providerList.ElementAt(i).start_date;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}