private void UpdateProjectButton_Click(object sender, RoutedEventArgs e) { try { // check for empty ness CheckForEmpty(this.UpdateProjectGrid); if (this.textboxstatus == false) { MessageBox.Show("A field has not been entered"); textboxstatus = false; return; } DB1 = new DBManager(); Container Entity1 = new Container(); Entity1._project.project_id = DB1.GetProjects("SELECT * FROM projects WHERE project_name = '" + this.UpdateProjectProjectNameComboBox.SelectedItem.ToString() + "'").First().project_id; Entity1._project.project_name = this.UpdateProjectProjectNameTextBox.Text; Entity1._project.location = this.UpdateProjectLocationTextBox.Text; Entity1._project.description = this.UpdateProjectDescriptionTextBox.Text; Entity1._project.end_date = (DateTime)this.UpdateProjectEndDatePicker.SelectedDate; Entity1._project.start_date = (DateTime)this.UpdateProjectStartDatePicker.SelectedDate; // get the client try { List<clients> cc = DB1.GetClients(""); var result = from item in cc where item.client_name.ToLower().Contains(this.RegisterProjectClientTextBox.Text.ToLower()) select item; if (result != null) { Entity1._project.client_id = Convert.ToInt32(((List<clients>)result.ToList()).First().client_id); } } catch { } if (DB1.UpdateProject(Entity1._project)) { MessageBox.Show("Project Successfully updated"); EmptyAllfields(this.UpdateProjectGrid); Initialization(); //this.UpdateProjectProjectNameComboBox = new ComboBox(); //ComboboxPopulating(this.UpdateProjectProjectNameComboBox, null); } } catch { } }