private void UpdateData() { _user.Name = NameField.Text; _user.LastName = SurNameField.Text; _user.RegMail = EmailField.Text; _user.Bio = BioField.Text; _user.Classes.Clear(); _user.Skills.Clear(); if (_imagePath != _user.PicturePath) { if (File.Exists(openFileDialog1.FileName)) { Image Img = new Bitmap(openFileDialog1.FileName); Img.Save(@"Pictures\" + openFileDialog1.SafeFileName); _user.PicturePath = openFileDialog1.SafeFileName; } } for (int i = 0; i < SkillsList.Items.Count; i++) { Skills skill; var check = TeamBuildingEntities.Skills.ToList().Where(k => k.SklName == SkillsList.Items[i].ToString()); if (check.ToList().Count > 0) { _user.Skills.Add(check.ToList()[0]); } else { TeamBuildingEntities.Skills.Add(new Skills() { Projects = new List <Projects>(), SklId = TeamBuildingEntities.Skills.Count() + 1, SklName = SkillsList.Items[i].ToString(), Users = new List <Users>() }); //TeamBuildingEntities.SaveChanges(); _user.Skills.Add(TeamBuildingEntities.Skills.ToList().Last()); } } for (int i = 0; i < ClassList.Items.Count; i++) { if (ClassList.GetItemChecked(i)) { _user.Classes.Add(TeamBuildingEntities.Classes.ToList()[i]); } } //TeamBuildingEntities.Entry(TeamBuildingEntities.Users).State=EntityState.Modified; TeamBuildingEntities.SaveChanges(); }
private Projects CreateBaseForProject() { try { UsersList = new ObservableCollection <Users>(TeamBuildingEntities.Users); int projectId; if (ExistedProject == null) { projectId = TeamBuildingEntities.Projects.ToList()[TeamBuildingEntities.Projects.Count() - 1].PrjtId + 1; } else { projectId = ExistedProject.PrjtId; } if (!File.Exists(openFileDialog1.FileName) && ExistedProject == null) { _imagePath = "default.jpg"; } _newProject = new Projects() { PrjtId = projectId, PrjtName = NameField.Text, PrjtDescription = DescriptionField.Text, PrjtCreated = (ExistedProject == null) ? Convert.ToDateTime(DateTime.Today) : ExistedProject.PrjtCreated, PrjtImagePath = _imagePath, PrjtCreatedBy = (ExistedProject == null) ? UsersList[StartUp.SelectedUser - 1].UsrId : ExistedProject.PrjtCreatedBy, PjrtLikeCounter = (ExistedProject == null) ? 0 : ExistedProject.PjrtLikeCounter }; _newProject.Users2.Clear(); _newProject.Users2.Add(UsersList[StartUp.SelectedUser - 1]); if (File.Exists(openFileDialog1.FileName) || ExistedProject != null && ExistedProject.PrjtImagePath != _imagePath) { Image Img = new Bitmap(openFileDialog1.FileName); Img.Save(@"Pictures\" + openFileDialog1.SafeFileName); } if (ExistedProject != null) { ExistedProject.PrjtClasses.Clear(); ExistedProject.Skills.Clear(); } for (int i = 0; i < SkillList.Items.Count; i++) { Skills skill; var check = TeamBuildingEntities.Skills.ToList().Where(k => k.SklName == SkillList.Items[i].ToString()); if (check.ToList().Count > 0) { _newProject.Skills.Add(check.ToList()[0]); } else { TeamBuildingEntities.Skills.Add(new Skills() { Projects = new List <Projects>(), SklId = TeamBuildingEntities.Skills.Count() + 1, SklName = SkillList.Items[i].ToString(), Users = new List <Users>() }); TeamBuildingEntities.SaveChanges(); _newProject.Skills.Add(TeamBuildingEntities.Skills.ToList().Last()); } } for (int i = 0; i < ClassList.Items.Count; i++) { if (ClassList.GetItemChecked(i)) { _newProject.PrjtClasses.Add(new PrjtClasses() { ClClassId = i, ClPrjtId = _newProject.PrjtId, ClPeopleNeeded = "1", Classes = TeamBuildingEntities.Classes.ToList()[i], Projects = _newProject }); } } } catch (Exception exception) { MessageBox.Show(exception.ToString()); } return(_newProject); }