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.");
}
}
