private void UpdateWindow() { //The project from another window DataRowView drv = (DataRowView)App.Current.Properties["project"]; //project id int pid = (int)drv["pid"]; //employee id (owner of project) int empId = Convert.ToInt32(drv["employee_eid"]); ProjectMaster2016.projectmasterDataSet projectmasterDataSet = ((ProjectMaster2016.projectmasterDataSet)(this.FindResource("projectmasterDataSet"))); // Load data into the table project. You can modify this code as needed. ProjectMaster2016.projectmasterDataSetTableAdapters.projectTableAdapter projectmasterDataSetprojectTableAdapter = new ProjectMaster2016.projectmasterDataSetTableAdapters.projectTableAdapter(); //projectmasterDataSetprojectTableAdapter.Fill(projectmasterDataSet.project); try { //get project projectmasterDataSetprojectTableAdapter.FillByProjectId(projectmasterDataSet.project, pid); System.Windows.Data.CollectionViewSource projectViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("projectViewSource"))); projectViewSource.View.MoveCurrentToFirst(); } catch { } //get name of employee(owner of project) projectmasterDataSetTableAdapters.employeeTableAdapter eta = new projectmasterDataSetTableAdapters.employeeTableAdapter(); eta.Fill(projectmasterDataSet.employee); string s = (string)eta.GetEmployeeName(empId); cbEmployee.Text = s; // Load data into the table employee. You can modify this code as needed. System.Windows.Data.CollectionViewSource employeeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("employeeViewSource"))); isFinished = (bool)drv["projectisfinished"]; //check if status has changed when updating isFinishedChanged = isFinished; //set colors and text for project status if (isFinished == true) { lblIsFinished.Content = "Já"; lblIsFinished.Background = Brushes.LightGreen; } else if (isFinished == false) { lblIsFinished.Content = "Nei"; lblIsFinished.Background = Brushes.PaleVioletRed; } // Load data into the table project_employees. You can modify this code as needed. ProjectMaster2016.projectmasterDataSetTableAdapters.project_employeesTableAdapter peta = new ProjectMaster2016.projectmasterDataSetTableAdapters.project_employeesTableAdapter(); peta.FillByProjectEmployeeName(projectmasterDataSet.project_employees, pid); System.Windows.Data.CollectionViewSource project_employeesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("project_employeesViewSource"))); project_employeesViewSource.View.MoveCurrentToFirst(); }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { int eid = (int)lbEmployees.SelectedValue; projectmasterDataSetTableAdapters.employeeTableAdapter eta = new projectmasterDataSetTableAdapters.employeeTableAdapter(); eta.UpdateEmployee(nameTextBox.Text, emailTextBox.Text, homeaddressTextBox.Text, (int)zipComboBox.SelectedValue, phoneTextBox.Text, professionTextBox.Text, eid); UpdateWindow(); lbEmployees.SelectedValue = eid; MessageBox.Show("Breytingar hafa verið vistaðar"); } catch { MessageBox.Show("Úbbs. Eitthvað fór úrskeiðis."); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { //Insert collected data into the database projectmasterDataSetTableAdapters.employeeTableAdapter eta = new projectmasterDataSetTableAdapters.employeeTableAdapter(); eta.Insert(nameTextBox.Text, emailTextBox.Text, homeaddressTextBox.Text, (int)zipComboBox.SelectedValue, phoneTextBox.Text, (byte[])App.Current.Properties["image"], professionTextBox.Text, null, null, passwordTextBox.Text, usernameTextBox.Text, (int)userroleComboBox.SelectedValue, DateTime.Now); MessageBox.Show("Breytingar hafa verið vistaðar"); this.Close(); } catch { MessageBox.Show("Úbbs. Eitthvað fór úrskeiðis."); } }
private void btnRemoveEmployee_Click(object sender, RoutedEventArgs e) { int eid = (int)employeeDataGrid.SelectedValue; MessageBoxResult result = MessageBox.Show("Ertu viss um að þú viljir eyða starfsmaður", "Eyða starfsmaður", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { try { projectmasterDataSetTableAdapters.employeeTableAdapter eta = new projectmasterDataSetTableAdapters.employeeTableAdapter(); eta.DeleteEmployee(eid); UpdateWindow(); } catch { MessageBox.Show("Ekki hægt að eyða starfsmaður", "Framkvæmd mistókst"); } } }
private void btnChangeImg_Click(object sender, RoutedEventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); if (dlg.ShowDialog() == true) { int eid = (int)lbEmployees.SelectedValue; byte[] img = File.ReadAllBytes(dlg.FileName); projectmasterDataSetTableAdapters.employeeTableAdapter ita = new projectmasterDataSetTableAdapters.employeeTableAdapter(); ita.UpdateImg(img, (int)lbEmployees.SelectedValue); UpdateWindow(); lbEmployees.SelectedValue = eid; } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { //Updating the employee table values (except the image column) int eid = (int)lbEmployees.SelectedValue; projectmasterDataSetTableAdapters.employeeTableAdapter eta = new projectmasterDataSetTableAdapters.employeeTableAdapter(); eta.UpdateEmployee(nameTextBox.Text, emailTextBox.Text, homeaddressTextBox.Text, (int)zipComboBox.SelectedValue, phoneTextBox.Text, professionTextBox.Text, usernameTextBox.Text, passwordTextBox.Text, (int)userroleComboBox.SelectedValue, eid); projectmasterDataSetTableAdapters.employeeTableAdapter ita = new projectmasterDataSetTableAdapters.employeeTableAdapter(); //Updating the image column in the employee table, in case there is an image saved in app current properties if (App.Current.Properties["image"] != null) { ita.UpdateImg((byte[])App.Current.Properties["image"], (int)lbEmployees.SelectedValue); } //Collapsing temporary image container and showing normal image container imgImageTemp.Visibility = Visibility.Collapsed; imgImage.Visibility = Visibility.Visible; UpdateWindow(); //Setting selected value so the employee listbox stays at the edited employee after saving. lbEmployees.SelectedValue = eid; MessageBox.Show("Breytingar hafa verið vistaðar"); } catch { MessageBox.Show("Úbbs. Eitthvað fór úrskeiðis."); } }