private void AddEmployee_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'hBSDataSet1.Gender' table. You can move, or remove it, as needed.
this.genderTableAdapter.Fill(this.hBSDataSet1.Gender);
// TODO: This line of code loads data into the 'hBSDataSet.EmployeeType' table. You can move, or remove it, as needed.
this.employeeTypeTableAdapter.Fill(this.hBSDataSet.EmployeeType);
if (index != -1)
{
using (database = new HBSDataContext())
{
employee = database.Employees.Single(x => x.EmployeeId == index);
txtName.Text = employee.Name;
txtSurname.Text = employee.Surname;
txtEmail.Text = employee.Email;
txtPhone.Text = employee.PhoneNumber;
cmbGender.SelectedValue = employee.Gender.GenderId;
cmbType.SelectedValue = employee.EmployeeType.EmployeeTypeId;
txtNOK.Text = employee.NextOfKin.NkName;
txtNOKPhone.Text = employee.NextOfKin.NkPhoneNumber;
txtStreetName.Text = employee.Address.StreetName;
txtSuburb.Text = employee.Address.Suburb;
txtCity.Text = employee.Address.City;
txtProvince.Text = employee.Address.Province;
txtCode.Text = employee.Address.PostalCode;
button7.Enabled = false;
addEmployee.Enabled = true;
}
}
}
public void loadEmployees()
{
using (database = new HBSDataContext())
{
var list = database.Employees.Select(o =>
new EmployeeResult
{
Id = o.EmployeeId,
Name = o.Name,
Surname = o.Surname,
PhoneNumber = o.PhoneNumber,
Email = o.Email
}).ToList();
DataTable dt = new DataTable();
using (var reader = ObjectReader.Create(list))
{
dt.Load(reader);
}
DataView view = dt.AsDataView();
dataGridView1.DataSource = view;
comboBox1.SelectedIndex = 0;
}
dataGridView1.MouseClick += new MouseEventHandler(mouse_click);
}
private void button7_Click(object sender, EventArgs e)
{
using (database = new HBSDataContext())
{
try
{
Address address = new Address();
address.StreetName = txtStreetName.Text;
address.Suburb = txtSuburb.Text;
address.City = txtCity.Text;
address.Province = txtProvince.Text;
address.PostalCode = txtCode.Text;
NextOfKin nextOfKin = new NextOfKin();
nextOfKin.NkName = txtNOK.Text;
nextOfKin.NkPhoneNumber = txtNOKPhone.Text;
Gender gender = database.Genders.Single(x => x.GenderId == int.Parse(cmbGender.SelectedValue.ToString()));
EmployeeType employeeType = database.EmployeeTypes.Single(x => x.EmployeeTypeId == int.Parse(cmbType.SelectedValue.ToString()));
Employee employee = new Employee();
employee.Name = txtName.Text;
employee.Surname = txtSurname.Text;
employee.Email = txtEmail.Text;
employee.PhoneNumber = txtPhone.Text;
database.Addresses.InsertOnSubmit(address);
database.NextOfKins.InsertOnSubmit(nextOfKin);
employee.Address = address;
employee.NextOfKin = nextOfKin;
employee.Gender = gender;
employee.EmployeeType = employeeType;
database.Employees.InsertOnSubmit(employee);
database.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally {
}
this.Close();
mainForm.loadEmployees();
MessageBox.Show("New Employee Added");
}
}
public void deleteEmployee(int index)
{
try
{
using (database = new HBSDataContext())
{
var q = database.Employees.Where(x => x.EmployeeId == int.Parse(index.ToString())).Single <Employee>();
database.GetTable <Address>().DeleteOnSubmit(q.Address);
database.GetTable <NextOfKin>().DeleteOnSubmit(q.NextOfKin);
database.GetTable <Employee>().DeleteOnSubmit(q);
database.SubmitChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally { loadEmployees(); }
}
