public void AddChallengesToUser(int userid, IList <int> challengeids)
{
User usr = _users.FirstOrDefault(u => u.UserId == userid);
//Feth the challenges that might be added
List <Challenge> challenges = _challenges.Where(c => challengeids.Contains(c.ChallengeId)).ToList();
//Fetch the existing challenges for the user
List <int> existing = _dbContext.ChallengeUser.Where(cu => cu.UserId == userid).Select(cu => cu.ChallengeId).ToList();
//Add the not already existing challenges
List <ChallengeUser> challengesToAdd = challenges.Where(c => !existing.Contains(c.ChallengeId)).Select(c =>
new ChallengeUser()
{
ChallengeId = c.ChallengeId,
Challenge = c,
User = usr,
UserId = usr.UserId
}
).ToList();
usr.AddChallenges(challengesToAdd);
_dbContext.ChallengeUser.AddRange(challengesToAdd);
_dbContext.SaveChanges();
}
public void SaveChanges()
{
_dbContext.SaveChanges();
}
public async Task InitializeData()
{
_dbContext.Database.EnsureDeleted();
if (_dbContext.Database.EnsureCreated())
{
await CreateRoles();
//Multimeduser
await CreateUser("SofieV", "*****@*****.**", "P@ssword123", UserRole.MULTIMED);
//categories
Category c = new Category()
{
Name = "Ondergewicht"
};
_dbContext.Add(c);
//challenges
Challenge ch = new Challenge()
{
ChallengeImage = "", Description = "Loop 2 km", Title = "Lopen", Category = c, Level = 1
};
//TherapistType
TherapistType thType = new TherapistType()
{
Type = "Diëtist", Categories = new List <Category> {
c
}
};
_dbContext.Add(thType);
//OpeningTimes
List <OpeningTimes> otList = new List <OpeningTimes>()
{
new OpeningTimes()
{
Interval = "9-17"
},
new OpeningTimes()
{
Interval = "9-17"
},
new OpeningTimes()
{
Interval = "9-17"
},
new OpeningTimes()
{
Interval = "9-17"
},
new OpeningTimes()
{
Interval = "9-17"
},
new OpeningTimes()
{
Interval = "9-17"
},
new OpeningTimes()
{
Interval = "9-17"
},
};
//Therapist
Therapist th = new Therapist()
{
FirstName = "Therapist", LastName = "De Peape", HouseNumber = 1, PhoneNumber = "0474139526", PostalCode = 9000, Street = "test", Website = "www.google.com", City = "Gent", Email = "*****@*****.**", TherapistType = thType, OpeningTimes = otList
};
await CreateUser("TestTh", th.Email, "P@ssword123", UserRole.THERAPIST);
_dbContext.Add(th);
//company
Company cmp = new Company()
{
Name = "Multimed", Street = "Multimedstraat", City = "Gent", Contract = DateTime.Now.AddYears(30), Country = "Belgie", Mail = "*****@*****.**", Phone = "04785889764", PostalCode = 9000, HouseNumber = 1, Site = "multimed.be"
};
_dbContext.Add(cmp);
//user
User usr = new User()
{
FirstName = "Boefer", FamilyName = "rob", Phone = "0478995888", ExperiencePoints = 16, Company = cmp, Email = "*****@*****.**", Contract = cmp.Contract
};
usr.AddTherapist(th);
//many to many from user
List <CategoryUser> cusr = new List <CategoryUser> {
new CategoryUser()
{
Category = c, User = usr, UserId = usr.UserId, CategoryId = c.CategoryId
}
};
ChallengeUser chUsr = new ChallengeUser()
{
ChallengeUserId = usr.UserId, User = usr, ChallengeId = ch.ChallengeId, Challenge = ch
};
usr.AddChallenges(new List <ChallengeUser> {
chUsr
});
usr.AddCategories(cusr);
//account user
await CreateUser("Boeferrob", usr.Email, "P@ssword123", UserRole.USER);
_dbContext.Add(usr);
_dbContext.ChallengeUser.Add(chUsr);
th.AddClient(usr);
#region Save changes
_dbContext.SaveChanges();
#endregion
}
}