private void confirmBtn_Click(object sender, EventArgs e) { try { if (!string.IsNullOrWhiteSpace(NameTb.Text)) { string departmentName = NameTb.Text; if (_editDepartment) { _departmentToBeEdited.Name = departmentName; DatabaseFunctions.UpdateDepartment(_departmentToBeEdited, departmentOldName); } else { Department newDepartment = new Department(departmentName); DatabaseFunctions.AddDepartment(newDepartment); } DatabaseFunctions.GetAllDepartments(); this.Close(); } else { MessageBox.Show("Fill in the empty field."); } } catch (NoConnectionException) { MessageBox.Show("Connection unsuccessful, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (NotExistingException) { MessageBox.Show("Department is non-existent, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void EmployeesForm_Load(object sender, EventArgs e) { try { DatabaseFunctions.GetAllUsers(); DatabaseFunctions.GetAllDepartments(); employeesLv.Items.Clear(); foreach (var item in Users.users) { ListViewItem lvi = new ListViewItem(item.ID.ToString()); lvi.SubItems.Add(item.FirstName); lvi.SubItems.Add(item.LastName); lvi.SubItems.Add(item.Email); lvi.SubItems.Add(item.PhoneNumber); lvi.SubItems.Add(item.Position.ToString()); lvi.SubItems.Add(item.Salary.ToString("C2", CultureInfo.CurrentCulture)); lvi.SubItems.Add(item.UserDepartment.Name); employeesLv.Items.Add(lvi); } departmentCb.Items.Clear(); departmentCb.Items.Add("Department"); departmentCb.Items.Add("All Departments"); departmentCb.SelectedIndex = 0; foreach (var item in Departments.departments) { departmentCb.Items.Add(item.Name); } roleCb.SelectedIndex = 0; } catch (NoConnectionException) { MessageBox.Show("Connection unsuccessful, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (NotExistingException) { MessageBox.Show("Department is non-existent, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } AnimateWindow(this.Handle, 500, AnimateWindowFlags.AW_SLIDE); }
public MainForm() { InitializeComponent(); usernameTb.Click += new EventHandler(click_username); usernameTb.Leave += new EventHandler(leave_username); passwordTb.Click += new EventHandler(click_password); passwordTb.Leave += new EventHandler(leave_password); try { if (!DatabaseFunctions.GetAllUsers() && !DatabaseFunctions.GetAllProducts()) { MessageBox.Show("Loading Data Failure, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (!DatabaseFunctions.GetAllDepartments()) { MessageBox.Show("Loading Data Failure, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (!File.Exists("idSeeder")) { string id = (Users.LastGenUsernameId() + 1).ToString(); File.WriteAllLines("idSeeder", new string[] { id }); } } catch (NoConnectionException) { MessageBox.Show("Loading Data Failure, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (IOException) { MessageBox.Show("Loading Data Failure, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void removeBtn_Click(object sender, EventArgs e) { try { DatabaseFunctions.RemoveDepartment(_departmentToBeEdited); DatabaseFunctions.GetAllDepartments(); this.Close(); } catch (NoConnectionException) { MessageBox.Show("Connection unsuccessful, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (NotExistingException) { MessageBox.Show("Department is non-existent, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (UsersInDepartmentException) { MessageBox.Show("There are still employees in that department", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void DepartmentsForm_Load(object sender, EventArgs e) { this.StartPosition = FormStartPosition.CenterScreen; try { DatabaseFunctions.GetAllDepartments(); foreach (var item in Departments.departments) { departmentsLb.Items.Add(item.Name); } } catch (NoConnectionException) { MessageBox.Show("Connection unsuccessful, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (NotExistingException) { MessageBox.Show("Department is non-existent, please restart", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } AnimateWindow(this.Handle, 500, AnimateWindowFlags.AW_SLIDE); }