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