public void AddUser(UserDto user) { var newUser = _context.User.Where(x => x.Id == user.UserId).SingleOrDefault(); newUser.FirstName = user.FirstName; newUser.SecondName = user.SecondName; newUser.LastName = user.LastName; newUser.DateofBirth = user.DateofBirth; newUser.Gender = user.Gender; newUser.Address = user.Address; newUser.PortfolioEmail = user.PortfolioEmail; newUser.PersonalImage = user.PersonalImage; newUser.Vision = user.Vision; newUser.About = user.About; newUser.CV = user.CV; newUser.MobileNumber = user.MobileNumber; newUser.FacebookURL = user.FacebookURL; newUser.LinkedInURL = user.LinkedInURL; newUser.TwitterURL = user.TwitterURL; _context.SaveChanges(); foreach (var technicalskill in user.TechnicalSkillsDto) { UserTechnicalSkill userTechnicalSkill = new UserTechnicalSkill(); userTechnicalSkill.UserId = newUser.Id; userTechnicalSkill.TechnicalSkillId = technicalskill; _context.UserTechnicalSkills.Add(userTechnicalSkill); _context.SaveChanges(); } foreach (var interpersonalSkill in user.InterpersonalSkillsDto) { UserInterpersonalSkill userInterpersonalSkill = new UserInterpersonalSkill(); userInterpersonalSkill.UserId = newUser.Id; userInterpersonalSkill.InterpersonalSkillId = interpersonalSkill; _context.UserInterpersonalSkills.Add(userInterpersonalSkill); _context.SaveChanges(); } foreach (var UU in user.UniversityDto) { UserUniversity userUniversity = new UserUniversity(); userUniversity.UserId = newUser.Id; userUniversity.UniversityId = UU.UniversityId; userUniversity.DegreeId = UU.DegreeId; userUniversity.MajorName = UU.MajorName; _context.UserUniversities.Add(userUniversity); _context.SaveChanges(); } foreach (var UP in user.ProjectDto) { Project project = new Project(); project.UserId = newUser.Id; project.ProjectId = UP.ProjectId; project.ProjectName = UP.ProjectName; project.ProjectDescription = UP.ProjectDescription; project.ProjectImage = UP.ProjectImage; project.ProjectPDF = UP.ProjectPdf; _context.Projects.Add(project); _context.SaveChanges(); } }
public void AddUserToUniversity(string userId, int universityId) { var userUniversity = new UserUniversity { UniversityId = universityId, UserId = userId }; _context.UserUniversities.Add(userUniversity); _context.SaveChanges(); }
public async void UpdateUser(UserDto user) { var user1 = applicationDbContext.Users.Where(x => x.Id == user.UserId).SingleOrDefault(); user1.FirstName = user.FirstName; user1.SecondName = user.SecondName; user1.LastName = user.LastName; user1.Address = user.Address; user1.DateOfBirth = user.DateOfBirth; user1.CV = user.CVb; user1.PortfolioEmail = user.PortfolioEmail; user1.About = user.About; user1.MobileNumber = user.MobileNumber; user1.PersonalImage = user.PersonalImg; user1.Vision = user.Vision; user1.LinkedInUrl = user.LinkedInUrl; user1.FBUrl = user.FBUrl; user1.TwitterUrl = user.TwitterUrl; user1.JobTitle = user.JobTitle; var InterpersonalSkills = applicationDbContext.UserInterpersonalSkills .Where(x => x.userId == user1.Id).ToList(); foreach (var i in InterpersonalSkills) { applicationDbContext.Remove(i); applicationDbContext.SaveChanges(); } var inter = new UserInterpersonalSkills(); foreach (var i in user.InterpersonalSkills) { inter.userId = user.UserId; inter.InterpersonalSkillsId = i; applicationDbContext.UserInterpersonalSkills.Add(inter); applicationDbContext.SaveChanges(); } var TechnicalSkills = applicationDbContext.UserTechnicalSkills.Where(x => x.userId == user1.Id).ToList(); foreach (var i in TechnicalSkills) { applicationDbContext.Remove(i); applicationDbContext.SaveChanges(); } var tech = new UserTechnicalSkills(); foreach (var i in user.TechnicalSkills) { tech.userId = user.UserId; tech.TechnicalSkillsId = i; applicationDbContext.UserTechnicalSkills.Add(tech); applicationDbContext.SaveChanges(); } var uni = applicationDbContext.UserUniversitiess.Where(x => x.UserId == user.UserId).ToList(); foreach (var unii in uni) { applicationDbContext.Remove(unii); applicationDbContext.SaveChanges(); } foreach (var i in user.UniversityDtos) { var unii = new UserUniversity(); unii.UserId = user.UserId; unii.UniversityiId = i.UniversityId; unii.DegreeId = i.DegreeId; unii.MajorName = i.MajorName; applicationDbContext.UserUniversitiess.Add(unii); applicationDbContext.SaveChanges(); } var project = applicationDbContext.Projects.Where(x => x.UserId == user.UserId).ToList(); foreach (var projects in project) { applicationDbContext.Remove(projects); applicationDbContext.SaveChanges(); } foreach (var i in user.ProjectDtos) { var pro = new Project(); pro.UserId = user.UserId; pro.ProjectName = i.ProjectName; pro.ProjectPDF = i.ProjectPDFb; pro.ProjectImage = i.ProjectImg; pro.ProjectDescription = i.ProjectDescription; applicationDbContext.Projects.Add(pro); applicationDbContext.SaveChanges(); } applicationDbContext.SaveChanges(); }
public async Task <List <User> > Add(UserDto userDto) { var user = applicationDbContext.Users.Where(x => x.Id == userDto.UserId).SingleOrDefault(); user.FirstName = userDto.FirstName; user.SecondName = userDto.SecondName; user.LastName = userDto.LastName; user.Address = userDto.Address; user.DateOfBirth = userDto.DateOfBirth; user.CV = userDto.CVb; user.PortfolioEmail = userDto.PortfolioEmail; user.Gender = userDto.Gender; user.About = userDto.About; user.MobileNumber = userDto.MobileNumber; user.PersonalImage = userDto.PersonalImg; user.Vision = userDto.Vision; user.LinkedInUrl = userDto.LinkedInUrl; user.FBUrl = userDto.FBUrl; user.TwitterUrl = userDto.TwitterUrl; user.JobTitle = userDto.JobTitle; applicationDbContext.SaveChanges(); foreach (var techSkill in userDto.TechnicalSkills) { UserTechnicalSkills userTechnicalSkills = new UserTechnicalSkills(); userTechnicalSkills.userId = user.Id; userTechnicalSkills.TechnicalSkillsId = techSkill; applicationDbContext.UserTechnicalSkills.Add(userTechnicalSkills); applicationDbContext.SaveChanges(); } foreach (var interSkill in userDto.InterpersonalSkills) { UserInterpersonalSkills userInterpersonalSkills = new UserInterpersonalSkills(); userInterpersonalSkills.userId = user.Id; userInterpersonalSkills.InterpersonalSkillsId = interSkill; applicationDbContext.UserInterpersonalSkills.Add(userInterpersonalSkills); applicationDbContext.SaveChanges(); } foreach (var u in userDto.UniversityDtos) { UserUniversity userUniversity = new UserUniversity(); userUniversity.UserId = user.Id; userUniversity.DegreeId = u.DegreeId; userUniversity.UniversityiId = u.UniversityId; userUniversity.MajorName = u.MajorName; applicationDbContext.UserUniversitiess.Add(userUniversity); applicationDbContext.SaveChanges(); } foreach (var u in userDto.ProjectDtos) { Project project = new Project(); project.UserId = user.Id; project.ProjectId = u.ProjectId; project.ProjectImage = u.ProjectImg; project.ProjectPDF = u.ProjectPDFb; project.ProjectName = u.ProjectName; project.ProjectDescription = u.ProjectDescription; applicationDbContext.Projects.Add(project); applicationDbContext.SaveChanges(); } SendMail(user.Email, user.FirstName, user.Id); var userRet = applicationDbContext.User.Where(x => x.Id == userDto.UserId).ToList(); return(userRet); }
public void UpdateUser(UserDto UpdatedUser) { var user = _context.User.Where(x => x.Id == UpdatedUser.UserId).SingleOrDefault(); user.FirstName = UpdatedUser.FirstName; user.SecondName = UpdatedUser.SecondName; user.LastName = UpdatedUser.LastName; user.MobileNumber = UpdatedUser.MobileNumber; user.DateofBirth = UpdatedUser.DateofBirth; user.Gender = UpdatedUser.Gender; user.PortfolioEmail = UpdatedUser.PortfolioEmail; user.Address = UpdatedUser.Address; user.About = UpdatedUser.About; user.Vision = UpdatedUser.Vision; user.FacebookURL = UpdatedUser.FacebookURL; user.LinkedInURL = UpdatedUser.LinkedInURL; user.TwitterURL = UpdatedUser.TwitterURL; user.CV = UpdatedUser.CV; user.PersonalImage = UpdatedUser.PersonalImage; _context.SaveChanges(); var usertechnicalskills = _context.UserTechnicalSkills.Where(x => x.UserId == user.Id).ToList(); foreach (var skill in usertechnicalskills) { _context.Remove(skill); _context.SaveChanges(); } var userTechnicalSkill = new UserTechnicalSkill(); foreach (var skill in UpdatedUser.TechnicalSkillsDto) { userTechnicalSkill.UserId = UpdatedUser.UserId; userTechnicalSkill.TechnicalSkillId = skill; _context.UserTechnicalSkills.Add(userTechnicalSkill); _context.SaveChanges(); } var userInterpersonalSkills = _context.UserInterpersonalSkills.Where(x => x.UserId == user.Id).ToList(); foreach (var skill in userInterpersonalSkills) { _context.Remove(skill); _context.SaveChanges(); } var userinterpersonalSkill = new UserInterpersonalSkill(); foreach (var skill in UpdatedUser.InterpersonalSkillsDto) { userinterpersonalSkill.UserId = user.Id; userinterpersonalSkill.InterpersonalSkillId = skill; _context.UserInterpersonalSkills.Add(userinterpersonalSkill); _context.SaveChanges(); } var userUniversity = _context.UserUniversities.Where(x => x.UserId == user.Id).ToList(); foreach (var UU in userUniversity) { //userUniversity.UserId = UpdatedUser.UserId; //userUniversity.UniversityId = UU.UniversityId; //userUniversity.DegreeId = UU.DegreeId; //userUniversity.MajorName = UU.MajorName; _context.Remove(UU); _context.SaveChanges(); } foreach (var UU in UpdatedUser.UniversityDto) { var userUniversities = new UserUniversity(); userUniversities.UserId = user.Id; userUniversities.UniversityId = UU.UniversityId; userUniversities.DegreeId = UU.DegreeId; userUniversities.MajorName = UU.MajorName; _context.UserUniversities.Add(userUniversities); _context.SaveChanges(); } var userProject = _context.Projects.Where(x => x.UserId == user.Id).ToList(); foreach (var UP in userProject) { _context.Remove(UP); _context.SaveChanges(); } foreach (var UP in UpdatedUser.ProjectDto) { var project = new Project(); project.UserId = user.Id; project.ProjectName = UP.ProjectName; project.ProjectDescription = UP.ProjectDescription; project.ProjectImage = UP.ProjectImage; project.ProjectPDF = UP.ProjectPdf; _context.Add(project); _context.SaveChanges(); } }