private void btnXoaPH_Click(object sender, EventArgs e) { if (btnXoaPH.Enabled == true) { string err = null; DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa phòng " + txtTenPH.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { try { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); PhongHoc ph = new PhongHoc(); ph.MaPH = Int32.Parse(txtMaPH.Text); et.Entry(ph).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLPhongHoc_Load(sender, e); } } }
private void btnXoaBan_Click(object sender, EventArgs e) { if (btnXoaBan.Enabled == true) { DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa ban " + txtTenBan.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { try { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Ban bdel = new Ban(); bdel.MaBan = Int32.Parse(txtMaBan.Text); bdel.TenBan = txtTenBan.Text; et.Entry(bdel).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); QLBan_Load(sender, e); } catch (Exception ex) { MessageBox.Show("Xóa lỗi! Lỗi " + ex.Message); } } } }
private void btnXoaGV_Click(object sender, EventArgs e) { if (btnXoaGV.Enabled == true) { string err = null; DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa giáo viên " + txtTenGV.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { try { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); GiaoVien gv = new GiaoVien(); gv.MaGV = Int32.Parse(txtMaGV.Text); gv.TenGV = txtTenGV.Text; et.Entry(gv).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); QLGiaoVien_Load(sender, e); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } } } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); GiaoVien gv = new GiaoVien(); gv.MaGV = Int32.Parse(txtMaGV.Text); gv.TenGV = txtTenGV.Text; gv.GioiTinh = txtGioiTinh.Text; gv.SDT = txtSDT.Text; gv.ChucVu = txtChucVu.Text; gv.Email = txtEmail.Text; gv.MaBM = Int32.Parse(txtMaBM.Text); et.Entry(gv).State = EntityState.Added; et.SaveChanges(); MessageBox.Show("Thêm thành công!"); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); GiaoVien gv = new GiaoVien(); gv.MaGV = Int32.Parse(txtMaGV.Text); gv.TenGV = txtTenGV.Text; gv.GioiTinh = txtGioiTinh.Text; gv.SDT = txtSDT.Text; gv.ChucVu = txtChucVu.Text; gv.Email = txtEmail.Text; gv.MaBM = Int32.Parse(txtMaBM.Text); et.Entry(gv).State = EntityState.Modified; et.SaveChanges(); MessageBox.Show("Sửa thành công!"); } QLGiaoVien_Load(sender, e); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } } else { QLGiaoVien_Load(sender, e); } }
private void btnXoaBM_Click(object sender, EventArgs e) { if (btnXoaBM.Enabled == true) { DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa bộ môn " + txtTenBM.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); BoMon bmdel = new BoMon(); bmdel.MaBM = Int32.Parse(txtMaBM.Text); et.Entry(bmdel).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); QLBoMon_Load(sender, e); } } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Lop lop = new Lop(); lop.MaLop = Int32.Parse(txtMaLH.Text); lop.TenLop = txtTenLH.Text; lop.SoHocSinh = Int32.Parse(txtSoHS.Text); lop.MaBan = Int32.Parse(txtMaBan.Text); et.Entry(lop).State = EntityState.Added; et.SaveChanges(); MessageBox.Show("Thêm thành công!"); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Lop lop = new Lop(); lop.MaLop = Int32.Parse(txtMaLH.Text); lop.TenLop = txtTenLH.Text; lop.SoHocSinh = Int32.Parse(txtSoHS.Text); lop.MaBan = Int32.Parse(txtMaBan.Text); et.Entry(lop).State = EntityState.Modified; et.SaveChanges(); MessageBox.Show("Sửa thành công!"); } QLLop_Load(sender, e); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } } else { QLLop_Load(sender, e); } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); PhongHoc ph = new PhongHoc(); ph.MaPH = Int32.Parse(txtMaPH.Text); ph.TenPH = txtTenPH.Text; ph.DungLuong = Int32.Parse(txtDungLuong.Text); et.Entry(ph).State = EntityState.Added; et.SaveChanges(); MessageBox.Show("Đã xóa!"); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); PhongHoc ph = new PhongHoc(); ph.MaPH = Int32.Parse(txtMaPH.Text); ph.TenPH = txtTenPH.Text; ph.DungLuong = Int32.Parse(txtDungLuong.Text); et.Entry(ph).State = EntityState.Modified; et.SaveChanges(); MessageBox.Show("Đã xóa!"); } } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLPhongHoc_Load(sender, e); } else { QLPhongHoc_Load(sender, e); } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Ban b = new Ban(); b.MaBan = Int32.Parse(txtMaBan.Text); b.TenBan = txtTenBan.Text; et.Entry(b).State = EntityState.Added; et.SaveChanges(); MessageBox.Show("Thêm thành công!"); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Ban bnew = new Ban(); bnew.MaBan = Int32.Parse(txtMaBan.Text); bnew.TenBan = txtTenBan.Text; et.Entry(bnew).State = EntityState.Modified; et.SaveChanges(); MessageBox.Show("Sửa thành công!"); } } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLBan_Load(sender, e); } else { QLBan_Load(sender, e); } }
private void btnXoaLop_Click(object sender, EventArgs e) { if (btnXoaLop.Enabled == true) { DialogResult r = MessageBox.Show(null, "Bạn có chắc xóa lớp " + txtTenLH.Text + " không!", "Cân nhắc", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { try { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); Lop lop = new Lop(); lop.MaLop = Int32.Parse(txtMaLH.Text); et.Entry(lop).State = EntityState.Deleted; et.SaveChanges(); MessageBox.Show("Đã xóa!"); } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLLop_Load(sender, e); } } }
private void btnReload_Click(object sender, EventArgs e) { if (k == 1) { try { if (t == 1) { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); MonHoc mh = new MonHoc(); mh.MaMH = Int32.Parse(txtMaMH.Text); mh.TenMH = txtTenMH.Text; et.Entry(mh).State = EntityState.Added; et.SaveChanges(); } else { XepThoiKhoaBieuEntities et = new XepThoiKhoaBieuEntities(); MonHoc mh = new MonHoc(); mh.MaMH = Int32.Parse(txtMaMH.Text); mh.TenMH = txtTenMH.Text; et.Entry(mh).State = EntityState.Modified; et.SaveChanges(); } } catch (Exception ex) { MessageBox.Show("Lỗi " + ex.Message); } QLMonHoc_Load(sender, e); } else { QLMonHoc_Load(sender, e); } }