/// <summary> /// Finds the student users by company. /// </summary> /// <param name="companyId">The company id.</param> /// <param name="view">The view.</param> /// <returns></returns> public List <Model.Entities.User> FindStudentUsersByCompany(int companyId, int view) { List <Model.Entities.User> userList = new List <Model.Entities.User>(); try { IQueryable <User> userQuery = this.Context.Set <Student>() .Where(u => u.CompanyId.Equals(companyId)) .Include(s => s.CourseRegistrations) .Include(p => p.CourseRegistrations.Select(x => x.Course)) .OrderByDescending(u => u.Id); if (view != 0) { userQuery = userQuery.Take(view); } // Return Users userList = UserEntityFactory.CreateFromDataModel(userQuery.ToList(), ObjectMapper); } catch (Exception ex) { ExceptionManager.HandleException(ex, PolicyNameType.ExceptionShielding); } return(userList); }
/// <summary> /// Adds the specified model. /// </summary> /// <param name="model">The model.</param> public override Model.Entities.User Add(Model.Entities.User model) { User newEntity = UserEntityFactory.CreateFromDomainModel(model, ObjectMapper); DbEntityEntry entry = Context.Entry <User>(newEntity); if (entry.State == System.Data.Entity.EntityState.Detached) { Context.Entry <User>(newEntity).State = System.Data.Entity.EntityState.Added; Context.SaveChanges(); } return(UserEntityFactory.CreateFromDataModel(newEntity, ObjectMapper)); }
/// <summary> /// Finds the user by email id. /// </summary> /// <param name="emailId">The email id.</param> /// <returns></returns> public Model.Entities.User FindUserByEmailId(string emailId) { Model.Entities.User user = null; try { User userEntity = this.Context.Set <User>().FirstOrDefault(x => x.Email.ToLower() == emailId.ToLower()); user = UserEntityFactory.CreateFromDataModel(userEntity, ObjectMapper); } catch (Exception ex) { ExceptionManager.HandleException(ex, PolicyNameType.ExceptionShielding); } return(user); }
/// <summary> /// Finds the user by member ship id. /// </summary> /// <param name="membershipId">The membership id.</param> /// <returns></returns> public Model.Entities.User FindUserByMemberShipId(int membershipId) { Model.Entities.User user = null; try { IQueryable <User> users = this.Context.Set <User>().Where(p => p.Membership_Id == membershipId).Take(1); User userEntity = users.ToList().FirstOrDefault(); user = UserEntityFactory.CreateFromDataModel(userEntity, ObjectMapper); } catch (Exception ex) { ExceptionManager.HandleException(ex, PolicyNameType.ExceptionShielding); } return(user); }
/// <summary> /// Finds all. /// </summary> /// <returns></returns> public override IQueryable <Model.Entities.User> FindAll() { List <Model.Entities.User> userList = new List <Model.Entities.User>(); try { IQueryable <User> userQuery = this.Context.Set <User>().OrderByDescending(u => u.Id); // Return Users userList = UserEntityFactory.CreateFromDataModel(userQuery.ToList(), ObjectMapper); } catch (Exception ex) { ExceptionManager.HandleException(ex, PolicyNameType.ExceptionShielding); } return(userList.AsQueryable()); }
/// <summary> /// Finds the student by studentName. /// </summary> /// <param name="userName">The studentName</param> /// <returns>Student</returns> public Model.Entities.Student FindStudentByName(string studentName) { Model.Entities.Student student = null; try { Student studentEntity = this.Context.Set <Student>() .Where(u => (u.FirstName + " " + u.LastName).ToLower().Contains(studentName.ToLower())) .FirstOrDefault(); student = UserEntityFactory.CreateFromDataModel(studentEntity, ObjectMapper) as Model.Entities.Student; } catch (Exception ex) { ExceptionManager.HandleException(ex, PolicyNameType.ExceptionShielding); } return(student); }
/// <summary> /// Finds the student users by company. /// </summary> /// <param name="companyId">The company id.</param> /// <param name="view">The view.</param> /// <returns></returns> public List <Model.Entities.User> FindStudentUsersByCompany(int companyId, string filter) { List <Model.Entities.User> userList = new List <Model.Entities.User>(); try { IQueryable <User> userQuery; if (String.IsNullOrEmpty(filter)) { userQuery = this.Context.Set <Student>() .Where(u => u.CompanyId.Equals(companyId)) .Include(s => s.CourseRegistrations) .Include(p => p.CourseRegistrations.Select(x => x.Course)) .OrderByDescending(u => u.Id); } else { userQuery = this.Context.Set <Student>() .Where(u => u.CompanyId.Equals(companyId) && (u.FirstName.ToLower().Contains(filter.ToLower()) || u.LastName.ToLower().Contains(filter.ToLower()) || u.Email.ToLower().Contains(filter.ToLower()))) .Include(s => s.CourseRegistrations) .Include(p => p.CourseRegistrations.Select(x => x.Course)) .OrderByDescending(u => u.Id); } // Return Users userList = UserEntityFactory.CreateFromDataModel(userQuery.ToList(), ObjectMapper); } catch (Exception ex) { ExceptionManager.HandleException(ex, PolicyNameType.ExceptionShielding); } return(userList); }
/// <summary> /// Finds the user by UserName. /// </summary> /// <param name="userName">The username</param> /// <returns></returns> public Model.Entities.User FindUserByUserName(string userName) { Model.Entities.User user = null; try { /*IQueryable<User> users = this.Context.Set<Student>() * .Where(u => u.UserName.ToLower().Equals(userName.ToLower())) * .Include(s => s.CourseRegistrations) * .Include(p => p.CourseRegistrations.Select(x => x.Course)) * .Take(1);*/ IQueryable <User> users = this.Context.Set <User>().Include(u => u.Roles) .Where(u => u.UserName.ToLower().Equals(userName.ToLower())) .Take(1); User userEntity = users.ToList().FirstOrDefault(); user = UserEntityFactory.CreateFromDataModel(userEntity, ObjectMapper); } catch (Exception ex) { ExceptionManager.HandleException(ex, PolicyNameType.ExceptionShielding); } return(user); }
/// <summary> /// Finds the by. /// </summary> /// <param name="id">The id.</param> /// <returns></returns> public override Model.Entities.User FindBy(int id) { User entity = Context.Set <User>().Find(id); return(UserEntityFactory.CreateFromDataModel(entity, ObjectMapper)); }