public IList <TFNC> GetFunctionsWithPermissions(TROL role)
{
dbEntities db = new dbEntities();
IFunctionRepository _repository = new FunctionRepository(db);
IList <TFNC> ret = _repository.GetFunctionsWithPermissions(role);
return(ret);
}
public TROL GetRoleByPrimaryKey(TROL role)
{
dbEntities db = new dbEntities();
IRoleRepository _repository = new RoleRepository(db);
TROL ret = _repository.GetByPrimaryKey(role.CODROL);
return(ret);
}
public IList <TROL> GetFilteredRoles(TROL role)
{
dbEntities db = new dbEntities();
IRoleRepository _repository = new RoleRepository(db);
IList <TROL> ret = _repository.GetFiltered(role);
return(ret);
}
public List <TROLFNC> GetFunctionsForRole(TROL role)
{
List <TROLFNC> truofunlst = (from ruofun in db.Set <TROLFNC>()
where ruofun.CODROL.Equals(role.CODROL)
select ruofun).ToList();
return(truofunlst);
}
public bool UpdateRole(TROL role)
{
dbEntities db = new dbEntities();
IRoleRepository _repository = new RoleRepository(db);
_repository.Update(role);
_repository.SaveChanges();
return(true);
}
public int InsertRole(TROL role)
{
dbEntities db = new dbEntities();
IRoleRepository _repository = new RoleRepository(db);
int ret = _repository.InsertOnSubmit(role);
_repository.SaveChanges();
return(ret);
}
public int DeleteRole(TROL role)
{
dbEntities db = new dbEntities();
IRoleRepository _repository = new RoleRepository(db);
TROL r = _repository.GetRoleUsersFuncs(role);
int ret = _repository.DeleteOnSubmit(r, true);
_repository.SaveChanges();
return(ret);
}
public IList <TFNC> GetFunctionsWithPermissions(TROL role)
{
// TODO da mettere a posto
var lista = (from f in db.Set <TFNC>().Include("TROLFNC")
from rf in db.Set <TROLFNC>().Where(x => x.CODFNC == f.CODFNC && role.CODROL.Equals(x.CODROL)).DefaultIfEmpty()
where (!string.IsNullOrEmpty(f.DESCTL) && !string.IsNullOrEmpty(f.DESACTCTL))
orderby f.DESFNC
select f);
return(lista.ToList());
}
