public IList <VMEN> GetMenuByUser(TUSR user)
{
dbEntities db = new dbEntities();
IMenuRepository _repository = new MenuRepository(db);
IList <VMEN> ret = _repository.GetMenuByUser(user);
return(ret);
}
public IList <TROL> GetRolesAssociatedToUser(TUSR user)
{
dbEntities db = new dbEntities();
IRoleRepository _repository = new RoleRepository(db);
IList <TROL> ret = _repository.GetRolesAssociatedToUser(user);
return(ret);
}
public TUSR GetUserByPrimaryKey(TUSR user)
{
dbEntities db = new dbEntities();
IUserRepository _repository = new UserRepository(db);
TUSR ret = _repository.GetByPrimaryKey(user.CODUSR);
return(ret);
}
public TUSR GetUserRolesByCompanyAndUsername(TUSR user)
{
dbEntities db = new dbEntities();
IUserRepository _repository = new UserRepository(db);
TUSR ret = _repository.GetUserRolesByCompanyAndUsername(user);
return(ret);
}
// USARE ODATA
public IList <TUSR> GetFilteredUsers(TUSR user)
{
dbEntities db = new dbEntities();
IUserRepository _repository = new UserRepository(db);
IList <TUSR> ret = _repository.GetFiltered(user);
return(ret);
}
public IList <VMEN> GetMenuByUser(TUSR user)
{
var menuQuery = (from m in db.Set <VMEN>()
where m.CODUSR.Equals(user.CODUSR)
select m).Distinct();
var orderedList = menuQuery.OrderBy(x => x.SORPAT).ToList();
return(orderedList);
}
public int InsertUser(TUSR user)
{
dbEntities db = new dbEntities();
IUserRepository _repository = new UserRepository(db);
int ret = _repository.InsertOnSubmit(user);
_repository.SaveChanges();
return(ret);
}
public bool UpdateUser(TUSR user)
{
dbEntities db = new dbEntities();
IUserRepository _repository = new UserRepository(db);
_repository.Update(user);
_repository.SaveChanges();
return(true);
}
public IList <TROL> GetRolesAssociatedToUser(TUSR user)
{
var roles = (from ur in db.Set <TUSRROL>()
join r in db.Set <TROL>() on ur.CODROL equals r.CODROL
where (user.CODUSR.Equals(ur.CODUSR))
select r).Distinct();
return(roles.ToList());
}
public int DeleteUser(TUSR user)
{
dbEntities db = new dbEntities();
IUserRepository _repository = new UserRepository(db);
TUSR u = _repository.GetUserRolesByPrimaryKey(user);
int ret = _repository.DeleteOnSubmit(u, true);
_repository.SaveChanges();
return(ret);
}
