private IQueryable <User> getAllUsers() { var user = this.GetUser(CurrentUser.GetUserName()); if (user == null) { return(null); } var userId = user.UserId; var OfficeTypeId = user.Office.OfficeTypeId; var offices = new OfficeRepository().GetOfficesByProv(user.Office.ProvinceId).ToIds(); if (OfficeTypeId == (int)OfficeTypes.HEADOFFICE) { return(from u in this.m_Context.Users where u.UserId != userId orderby u.UserName select u); } else { return(from u in this.m_Context.Users where u.UserId != userId && offices.Any(new Func <int, bool>(i => i == u.OfficeId)) orderby u.UserName select u); } }
private IQueryable <Driver> getAllDrivers() { var user = new UserRepository().GetUser(CurrentUser.GetUserName()); if (user == null) { return(null); } var userId = user.UserId; var OfficeTypeId = user.Office.OfficeTypeId; var offices = new OfficeRepository().GetOfficesByProv(user.Office.ProvinceId).ToIds(); if (OfficeTypeId == (int)OfficeTypes.HEADOFFICE) { return(from v in this.m_Context.Drivers orderby v.FirstName, v.Surname select v); } else { return(from v in this.m_Context.Drivers // where offices.Any(new Func<int, bool>(i => i == v.OfficeId)) orderby v.FirstName, v.Surname select v); } }