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