private void mainForm_Load(object sender, EventArgs e)
{
//using (dbemployeeEntities db = new dbemployeeEntities())
//{
// db.Database.ExecuteSqlCommand("UPDATE employee_info SET lastname = 'SQLTEST' WHERE empID = 19");
//}
employeeinfoBindingSource.DataSource = EmployeeInfoServices.GetAll();
}
private void btnAdd_Click(object sender, EventArgs e)
{
using (EmpAddEditForm frm = new EmpAddEditForm(null))
{
if (frm.ShowDialog() == DialogResult.OK)
{
employeeinfoBindingSource.DataSource = EmployeeInfoServices.GetAll();
}
}
}
private void EmpAddEditForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
employee_info ei = employeeinfoBindingSource.Current as employee_info;
if (string.IsNullOrEmpty(textBoxFirstName.Text))
{
MessageBox.Show("Please Enter First Name!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBoxFirstName.Focus();
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(textBoxLastName.Text))
{
MessageBox.Show("Please Enter Last Name!");
textBoxLastName.Focus();
e.Cancel = true;
return;
}
if ((string.IsNullOrEmpty(textBoxContactNumber.Text)) || (textBoxContactNumber.Text.Length != 11))
{
MessageBox.Show("Please Enter Contact Number!");
textBoxContactNumber.Focus();
e.Cancel = true;
return;
}
if ((string.IsNullOrEmpty(dateTimePickerDOB.Text)))
{
MessageBox.Show("Please Enter your Birth Date!");
dateTimePickerDOB.Focus();
e.Cancel = true;
return;
}
else
{
ei.birthdate = Convert.ToDateTime(dateTimePickerDOB.Text);
}
if (IsNew)
{
EmployeeInfoServices.Insert(ei);
MessageBox.Show("Added!");
}
else
{
EmployeeInfoServices.Update(employeeinfoBindingSource.Current as employee_info);
MessageBox.Show("Saved!");
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (employeeinfoBindingSource.Current == null)
{
return;
}
if (MessageBox.Show("Are you sure you want to delete this?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
EmployeeInfoServices.Delete(employeeinfoBindingSource.Current as employee_info);
employeeinfoBindingSource.RemoveCurrent();
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (employeeinfoBindingSource.Current == null)
{
return;
}
using (EmpAddEditForm frm = new EmpAddEditForm(employeeinfoBindingSource.Current as employee_info))
{
if (frm.ShowDialog() == DialogResult.OK)
{
employeeinfoBindingSource.DataSource = EmployeeInfoServices.GetAll();
}
}
}