private void RefreshListView() { using (var db = new EmployeesDBContext()) { if (SearchByComboBox.Text == SalaryManagementSystem.Properties.Resources.NameStr) { searchResult = (from em in db.Employees where em.Name.Contains(SearchTextBox.Text) select em).ToList(); } else if (SearchByComboBox.Text == SalaryManagementSystem.Properties.Resources.EGNStr) { searchResult = (from em in db.Employees where em.EGN.Contains(SearchTextBox.Text) select em).ToList(); } else if (SearchByComboBox.Text == SalaryManagementSystem.Properties.Resources.CompanyNameStr) { searchResult = (from em in db.Employees where em.CompanyName.Contains(SearchTextBox.Text) select em).ToList(); } } EmployeesListView.ItemsSource = searchResult; }
private void DeleteEmployee(Employee employee) { using (var db = new EmployeesDBContext()) { var toRemove = db.Employees.SingleOrDefault(em => em.ID == employee.ID); if (toRemove != null) { db.Employees.Remove(toRemove); db.SaveChanges(); } } }
private void EditBtn_Click(object sender, RoutedEventArgs e) { if (EmployeesListView.SelectedItems.Count > 1) { MessageBox.Show("Please select just one employee!"); return; } Employee selectedEmployee = EmployeesListView.SelectedItem as Employee; if (selectedEmployee != null) { using (var db = new EmployeesDBContext()) { var toEdit = db.Employees.SingleOrDefault(em => em.ID == selectedEmployee.ID); if (toEdit != null) { string newValue = selectedEmployee.Salary.ToString(); while (newValue.Length > 0) { newValue = Interaction.InputBox(SalaryManagementSystem.Properties.Resources.EnterSalaryMsg , "Input" , newValue); double newValueAsDouble; if (Double.TryParse(newValue, out newValueAsDouble) && newValueAsDouble >= Constants.MIN_SALARY) { toEdit.Salary = newValueAsDouble; db.SaveChanges(); RefreshListView(); break; } else if (newValue.Length > 0) { string salaryMsg = SalaryManagementSystem.Properties.Resources.InvalidSalaryMsg; salaryMsg = salaryMsg.Replace("^1", Constants.MIN_SALARY.ToString()); MessageBox.Show(salaryMsg , "Error" , MessageBoxButton.OK , MessageBoxImage.Error); } } } } } else { MessageBox.Show(SalaryManagementSystem.Properties.Resources.SelectEmployeeMsg); } }
public ListEmployeeSalaryBills() { InitializeComponent(); listViewColumnSorter = new ListViewColumnSorter(listView); using (var db = new EmployeesDBContext()) { var employees = db.Employees.ToList(); var bills = db.EmployeeSalaryBills.ToList(); salaryBills = bills; } listView.ItemsSource = salaryBills; }
private void CreateBill(Employee employee, string targetFolderPath) { using (var db = new EmployeesDBContext()) { var toExport = db.Employees.SingleOrDefault(em => em.ID == employee.ID); if (toExport != null) { EmployeeSalaryBill salaryBill = new EmployeeSalaryBill(DateTime.Now, toExport); if (targetFolderPath.Substring(targetFolderPath.Length - 1) == "\\") { targetFolderPath += "Bill_" + toExport.Name + "_" + salaryBill.Date.ToString().Replace("/", "_").Replace(":", "_") + ".xlsx"; } else { targetFolderPath += "\\Bill_" + toExport.Name + "_" + salaryBill.Date.ToString().Replace("/", "_").Replace(":", "_") + ".xlsx"; } SalaryBillToExcel.WriteSalaryBillToExcel(salaryBill, targetFolderPath); db.EmployeeSalaryBills.Add(salaryBill); db.SaveChanges(); } } }
private void SubmitBtn_Click(object sender, RoutedEventArgs e) { double salary = 0; if (NameTextBox.Text.Length < Employee.MIN_NAME_LENGTH) { string nameMsg = SalaryManagementSystem.Properties.Resources.InvalidNameMsg; nameMsg = nameMsg.Replace("^1", Employee.MIN_NAME_LENGTH.ToString()); MessageBox.Show(nameMsg , "Error" , MessageBoxButton.OK , MessageBoxImage.Error); } else if (!Employee.IsValidEGN(EGNTextBox.Text)) { MessageBox.Show(SalaryManagementSystem.Properties.Resources.InvalidEGNMsg , "Error" , MessageBoxButton.OK , MessageBoxImage.Error); } else if (!double.TryParse(SalaryTextBox.Text, out salary) || salary < Constants.MIN_SALARY) { string salaryMsg = SalaryManagementSystem.Properties.Resources.InvalidSalaryMsg; salaryMsg = salaryMsg.Replace("^1", Constants.MIN_SALARY.ToString()); MessageBox.Show(salaryMsg , "Error" , MessageBoxButton.OK , MessageBoxImage.Error); } else if (CompanyTextBox.Text.Length == 0) { MessageBox.Show(SalaryManagementSystem.Properties.Resources.InvalidCompanyName , "Error" , MessageBoxButton.OK , MessageBoxImage.Error); } else { using (var db = new EmployeesDBContext()) { var query = from em in db.Employees where em.EGN == EGNTextBox.Text select em; // EGN must be unique! if (query.Count() == 0) { Employee newEmployee = new Employee() { Name = NameTextBox.Text, EGN = EGNTextBox.Text, Salary = salary, CompanyName = CompanyTextBox.Text }; db.Employees.Add(newEmployee); db.SaveChanges(); string addedMsg = SalaryManagementSystem.Properties.Resources.AddedEmployee; addedMsg = addedMsg.Replace("^1", newEmployee.Name); addedMsg = addedMsg.Replace("^2", newEmployee.EGN); MessageBox.Show(addedMsg , "Information" , MessageBoxButton.OK , MessageBoxImage.Information); } else { string alreadyExistsMsg = SalaryManagementSystem.Properties.Resources.EmployeeAlreadyExists; alreadyExistsMsg = alreadyExistsMsg.Replace("^1", EGNTextBox.Text); MessageBox.Show(alreadyExistsMsg , "Error" , MessageBoxButton.OK , MessageBoxImage.Error); } } } }