public FrmEdit(int id)
{
InitializeComponent();
db = new Employee197PM33774Entities();
emp = db.Employees.Single(nv => nv.id == id);
this.Load += Form3_Load;
}
private void FrmAdd_Load(object sender, EventArgs e)
{
Employee197PM33774Entities db = new Employee197PM33774Entities();
CbbRoom.DataSource = db.DEPARTMENTs.ToList();
CbbRoom.DisplayMember = "name";//ten cột trong db
CbbRoom.ValueMember = "id";
}
private void btnSave_Click(object sender, EventArgs e)
{
Employee emp = new Employee();
emp.NAME = txtName.Text;
emp.BIRTHDATE = txtBirthday.Text;
emp.ID_DEPARTMENT = (int)CbbRoom.SelectedValue;
Employee197PM33774Entities db = new Employee197PM33774Entities();
db.Employees.Add(emp);
db.SaveChanges();
MessageBox.Show("Thêm mới thành công");
this.Close();
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dtgEmployee.SelectedRows.Count == 1)
{
var row = dtgEmployee.SelectedRows[0];
var cell = row.Cells["id"];
int id = (int)cell.Value;
employee = new Employee197PM33774Entities();
Employee emp = employee.Employees.Single(nv => nv.id == id);
employee.Employees.Remove(emp);
employee.SaveChanges();
MessageBox.Show("Xóa NV THành công");
}
else
{
MessageBox.Show("Mời bạn chọn 1 dòng");
}
LoadEmployee();
}
void LoadEmployee()
{
employee = new Employee197PM33774Entities();
dtgEmployee.DataSource = employee.Employees.ToList();
}
