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