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