public List <CodeChallenge.ModelDomain.User> GetAllUsers()
{
var optionsBuilder = new DbContextOptionsBuilder <CodeChallengeContext>();
optionsBuilder.UseSqlServer(sqlConnection);
using (CodeChallengeContext contex = new CodeChallengeContext(optionsBuilder.Options))
{
List <ModelDomain.User> result = new List <ModelDomain.User>();
List <DAL.User> resultDB = contex.User.ToList();
//From Entity object to Domain object (example in case of DB first and heavy Entity objects)
resultDB.ForEach(e =>
{
ModelDomain.User user = new ModelDomain.User();
user.Id = e.Id;
user.FirstName = e.FirstName;
user.LastName = e.LastName;
result.Add(user);
});
return(result);
}
}
public List <ModelDomain.UserProject> GetUserProject(int userId)
{
List <ModelDomain.UserProject> result = new List <ModelDomain.UserProject>();
if (userId > 0)
{
var optionsBuilder = new DbContextOptionsBuilder <CodeChallengeContext>();
optionsBuilder.UseSqlServer(sqlConnection);
using (CodeChallengeContext contex = new CodeChallengeContext(optionsBuilder.Options))
{
//get the user data
DAL.User user = contex.User.Where(u => u.Id == userId).Single();
//include("User").Include("Project") or a Select with joins of just the required field is faster,
//just doing example of multiple DB access in a BLL
List <DAL.UserProject> resultDB = contex.UserProject.Where(e => e.UserId == userId).ToList();
resultDB.ForEach(e =>
{
ModelDomain.UserProject uResult = new ModelDomain.UserProject();
uResult.AssignedDate = e.AssignedDate;
uResult.IsActive = e.IsActive;
uResult.User = new ModelDomain.User();
uResult.UserId = user.Id;
uResult.User.Id = user.Id;
uResult.User.FirstName = user.FirstName;
uResult.User.LastName = user.LastName;
//get project from DB
DAL.Project project = contex.Project.Where(p => p.Id == e.ProjectId).Single();
uResult.Project = new ModelDomain.Project();
uResult.ProjectId = project.Id;
uResult.Project.Id = project.Id;
uResult.Project.StartDate = project.StartDate;
uResult.Project.EndDate = project.EndDate;
uResult.Project.Credits = project.Credits;
result.Add(uResult);
});
}
}
return(result);
}
public UserRepository(CodeChallengeContext dbContext, IMappingEngine mapper) : base(dbContext)
{
_mapper = mapper;
}
