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