private void btnLuu_Click(object sender, EventArgs e)
{
if (txtMaHS.Text == "" || txtTenHS.Text == "" || txtDT.Text == "" || txtDC.Text == "")
{
MessageBox.Show("Xin mời nhập đầy đủ thông tin");
LockControl();
return;
}
else
{
tblHocSinh tblHocSinh = new tblHocSinh();
tblHocSinh.TenHS = txtTenHS.Text;
if (rdbNam.Checked)
{
tblHocSinh.GT = "Nam";
}
else
{
tblHocSinh.GT = "Nữ";
}
tblHocSinh.NgaySinh = dtpNgaySinh.Value;
tblHocSinh.DiaChi = txtDC.Text;
tblHocSinh.DanToc = txtDT.Text;
tblHocSinh.MaLop = (int)cbmLop.SelectedValue;
tblHocSinh.TonGiao = cboTG.SelectedItem.ToString();
QLHSContex db = new QLHSContex();
db.Entry(tblHocSinh).State = (tblHocSinh.MaHS == 0) ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
MessageBox.Show("Lưu thành công");
db.SaveChanges();
loadHS();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (txtMaGV.Text == "" || txtTen.Text == "" || txtSDT.Text == "" || txtLuong.Text == "" || txtDiaChi.Text == "")
{
MessageBox.Show("Xin mời nhập đầy đủ thông tin");
Khoa_btn();
return;
}
else
{
//Them GV
#region
var giaovien = new tblGiaovien();
giaovien.MaGV = Convert.ToInt16(txtMaGV.Text);
if (rdbNam.Checked)
{
giaovien.GT = "Nam";
}
else
{
giaovien.GT = "Nữ";
}
giaovien.Luong = Convert.ToInt32(txtLuong.Text);
giaovien.NgaySinh = dtpNgaySinh.Value;
giaovien.SDT = txtSDT.Text;
giaovien.TenGV = txtTen.Text;
giaovien.DiaChi = txtDiaChi.Text;
var monhoc = new MonHocDAO();
giaovien.MaMon = (int)cboMamon.SelectedValue;
var db = new GiaoVienDAO();
QLHSContex context = new QLHSContex();
context.Entry(giaovien).State = giaovien.MaGV == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
context.SaveChanges();
MessageBox.Show("Lưu thành công");
//
txtMaGV.Enabled = false;
btnLuu.Enabled = false;
btnSua.Enabled = true;
btnXoa.Enabled = true;
LoadGV();
SetNull();
#endregion
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc chắn muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
QLHSContex db = new QLHSContex();
tblGiaovien tblGiaovien = new tblGiaovien();
tblGiaovien.MaGV = Convert.ToInt16(txtMaGV.Text);
db.Entry(tblGiaovien).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
MessageBox.Show("Xóa thành công!");
LoadGV();
}
}
private void displayData()
{
try
{
QLHSContex db = new QLHSContex();
dvDuLieu = new DataView(dtDuLieu);
dvGiaoVien = new DataView(dtGiaoVien);
dvLop = new DataView(dtLop);
dvXGiaoVien = new DataView(dtGiaoVien);
dvXLop = new DataView(dtLop);
dvThu = new DataView(dtThu);
dvXThu = new DataView(dtThu);
// blind datasource
//dgvData.DataSource = new DataView(); ;
//this.dgvData.ClearSelection();
dgvData.DataSource = db.tblGiangday.ToList();
//cboGiaoVien.DataSource = dvGiaoVien;
//cboGiaoVien.DisplayMember = "TenGV";
//cboGiaoVien.ValueMember = "MaGV";
//cboLop.DataSource = dvLop;
//cboLop.DisplayMember = "TenLop";
//cboLop.ValueMember = "MaLop";
//cboXemGiaoVien.DataSource = dvXGiaoVien;
//cboXemGiaoVien.DisplayMember = "TenGV";
//cboXemGiaoVien.ValueMember = "MaGV";
//cboXemLop.DataSource = dvXLop;
//cboXemLop.DisplayMember = "TenLop";
//cboXemLop.ValueMember = "MaLop";
//cboThu.DataSource = dvThu;
//cboThu.DisplayMember = "Ten";
//cboThu.ValueMember = "ID";
//cboXemTheoThu.DataSource = dvXThu;
//cboXemTheoThu.DisplayMember = "Ten";
//cboXemTheoThu.ValueMember = "ID";
}
catch (Exception ex)
{
MessageBox.Show("Don't display data.\nERROR:" + ex.Message);
}
}
public UserDAO()
{
db = new QLHSContex();
}
public GiaoVienDAO()
{
db = new QLHSContex();
}
public MonHocDAO()
{
db = new QLHSContex();
}
