private void button_XoaHS_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
qlhs.Delete_HOCSINHXL(txtMS.Text);
qlhs.Delete_HOCSINH(txtMS.Text);
qlhs.SubmitChanges();
}
private void button_SuaHS_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
qlhs.Update_GiaoVien(txtMS.Text, txtHoTen.Text, cbGioiTinh.Text, dateTimePicker_NgSinh.Value,
txtNoiSinh.Text, int.Parse(txtCMND.Text), txtDiaChi.Text, txtEmail.Text, txtDienThoai.Text, txtMaMon.Text);
qlhs.SubmitChanges();
}
private void btnThem_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
MONHOC newmonhoc = new MONHOC();
newmonhoc.MaMon = txtMaMH.Text;
newmonhoc.TenMon = txtTenMH.Text;
//if (newmonhoc.MaMon == qlhs.MONHOCs.
try
{
qlhs.MONHOCs.InsertOnSubmit(newmonhoc);
qlhs.SubmitChanges();
}
catch (Exception)
{
MessageBox.Show("Môn học bạn muốn thêm đã có trong danh sách, không thể thêm mới");
}
//qlhs.MONHOCs.InsertOnSubmit(newmonhoc);
dtgMonHoc.DataSource = qlhs.MONHOCs;
for (int i = 0; i < dtgMonHoc.Rows.Count; i++)
{
if (dtgMonHoc.Rows[i].Cells[1].Value != null)//Nếu ô thứ i của cột thứ 1 (cột sau cột STT ấy) mà có dữ liệu thì gán giá trị cho cột STT, nếu không thì cột STT cũng không có dữ liệu
{
dtgMonHoc.Rows[i].Cells[0].Value = i + 1;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
dtgGiaoVien.DataSource = qlhs.select_GiaoVien(txtMaMon.Text);
for (int i = 0; i < dtgGiaoVien.Rows.Count; i++)
{
if (dtgGiaoVien.Rows[i].Cells[1].Value != null)//Nếu ô thứ i của cột thứ 1 (cột sau cột STT ấy) mà có dữ liệu thì gán giá trị cho cột STT, nếu không thì cột STT cũng không có dữ liệu
{
dtgGiaoVien.Rows[i].Cells[0].Value = i + 1;
}
}
txtHoTen.DataBindings.Clear();
txtHoTen.DataBindings.Add("text", dtgGiaoVien.DataSource, "TenGiaoVien");
cbGioiTinh.DataBindings.Clear();
cbGioiTinh.DataBindings.Add("text", dtgGiaoVien.DataSource, "GioiTinh");
dateTimePicker_NgSinh.DataBindings.Clear();
dateTimePicker_NgSinh.DataBindings.Add("text", dtgGiaoVien.DataSource, "NgaySinh");
txtNoiSinh.DataBindings.Clear();
txtNoiSinh.DataBindings.Add("text", dtgGiaoVien.DataSource, "NoiSinh");
txtCMND.DataBindings.Clear();
txtCMND.DataBindings.Add("text", dtgGiaoVien.DataSource, "CMND");
txtDiaChi.DataBindings.Clear();
txtDiaChi.DataBindings.Add("text", dtgGiaoVien.DataSource, "DiaChi");
txtDienThoai.DataBindings.Clear();
txtDienThoai.DataBindings.Add("text", dtgGiaoVien.DataSource, "DienThoai");
txtEmail.DataBindings.Clear();
txtEmail.DataBindings.Add("text", dtgGiaoVien.DataSource, "Email");
txtMS.DataBindings.Clear();
txtMS.DataBindings.Add("text", dtgGiaoVien.DataSource, "MaGiaoVien");
}
private void box_ChonKhoi_SelectedIndexChanged(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
//KHOI khoi = new KHOI();
//khoi.MaKhoi = cbChonKhoi.Text;
dtgLop.DataSource = qlhs.select_AllLopMA(cbChonKhoi.Text);
}
private void QL_Lop_Load(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
cbChonKhoi.DisplayMember = "MaKhoi";
//cbChonKhoi.ValueMember = "";
cbChonKhoi.DataSource = qlhs.KHOIs;
dtgLop.DataSource = qlhs.select_AllLop();
}
private void btn_Xem_Click(object sender, EventArgs e)
{
DataQLHSDataContext bchk = new DataQLHSDataContext();
this.tONGKETTableAdapter.Fill(this.qlsv1DataSet.TONGKET);
var Lst = (from s in bchk.TONGKETs
where s.MaHocKy.Contains((cbb_HK.SelectedValue).ToString()) && (s.MaLop.Contains(cbb_Lop.SelectedValue.ToString()))
select s);
}
private void QL_DSGV_Load(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
cbChonKhoi.DisplayMember = "TenMOn";
cbChonKhoi.ValueMember = "MaMon";
cbChonKhoi.DataSource = qlhs.MONHOCs;
txtMon.DataBindings.Add("Text", cbChonKhoi.DataSource, "TenMon");
txtMaMon.DataBindings.Add("Text", cbChonKhoi.DataSource, "MaMOn");
}
private void butOK_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
dtgPC.DataSource = qlhs.select_GIANGDAY(cbChonKhoi.Text, cbChonLop.Text, cbChonHK.Text,
int.Parse(txNamHoc.Text));
cbChonGiaoVien.DataBindings.Clear();
cbChonGiaoVien.DataBindings.Add("text", dtgPC.DataSource, "MaGiaoVien");
cbChonMon.DataBindings.Clear();
cbChonMon.DataBindings.Add("text", dtgPC.DataSource, "MaMon");
}
private void QL_BC_TKM_Load(object sender, EventArgs e)
{
DataQLHSDataContext bcm = new DataQLHSDataContext();
var Lst = (from s in bcm.TONGKETs select s);
dtgv_BCM.DataSource = Lst;
cbb_Mon.DataSource = bcm.MONHOCs;
cbb_Mon.DisplayMember = "TenMon";
cbb_Mon.ValueMember = "MaMon";
cbb_HK.DataSource = bcm.HOCKies;
cbb_HK.DisplayMember = "TenHocKy";
cbb_HK.ValueMember = "MaHocKy";
}
private void button_ThemHS_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
try
{
qlhs.Insert_GiaoVien(txtMS.Text, txtHoTen.Text, cbGioiTinh.Text, dateTimePicker_NgSinh.Value,
txtNoiSinh.Text, int.Parse(txtCMND.Text), txtDiaChi.Text, txtEmail.Text, txtDienThoai.Text, txtMaMon.Text);
qlhs.SubmitChanges();
}
catch (Exception)
{
MessageBox.Show("Giao Viên bạn muốn thêm đã có trong danh sách không thể thêm mới");
}
}
private void butSua_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
try
{
qlhs.UPDATE_GIANGDAY(cbChonLop.Text, cbChonHK.Text,
int.Parse(txNamHoc.Text), cbChonMon.Text, cbChonGiaoVien.Text);
qlhs.SubmitChanges();
}
catch (Exception)
{
MessageBox.Show("không thể sửa");
}
}
private void btThem_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
try
{
qlhs.Insert_GIANGDAY(cbChonLop.Text, cbChonHK.Text,
int.Parse(txNamHoc.Text), cbChonMon.Text, cbChonGiaoVien.Text);
qlhs.SubmitChanges();
}
catch (Exception)
{
MessageBox.Show("giao vien đã dc phân công không thể phân công");
}
}
private void QL_BC_TKHK_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'qlsv1DataSet.TONGKET' table. You can move, or remove it, as needed.
this.tONGKETTableAdapter.Fill(this.qlsv1DataSet.TONGKET);
DataQLHSDataContext bchk = new DataQLHSDataContext();
var Lst = (from s in bchk.TONGKETs select s);
dtgv_BCTK.DataSource = Lst;
cbb_Lop.DataSource = bchk.LOPs;
cbb_Lop.DisplayMember = "TenLop";
cbb_Lop.ValueMember = "MaLop";
cbb_HK.DataSource = bchk.HOCKies;
cbb_HK.DisplayMember = "TenHocKy";
cbb_HK.ValueMember = "MaHocKy";
}
private void QL_PC_Load(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
cbChonKhoi.DisplayMember = "MaKhoi";
cbChonKhoi.DataSource = qlhs.KHOIs;
cbChonLop.DisplayMember = "MaLop";
cbChonLop.DataSource = qlhs.LOPs;
cbChonHK.DisplayMember = "MaHocKy";
cbChonHK.DataSource = qlhs.HOCKies;
cbChonMon.DisplayMember = "MaMon";
cbChonMon.DataSource = qlhs.MONHOCs;
cbChonGiaoVien.DisplayMember = "MaGiaoVien";
cbChonGiaoVien.DataSource = qlhs.GIAOVIENs;
//dtgPC.DataSource = qlhs.select_GIANGDAY(cbChonKhoi.Text, cbChonLop.Text, cbChonHK.Text, cbChonMon.Text, cbChonGiaoVien.Text);
}
private void QL_MonHoc_Load(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
dtgMonHoc.DataSource = qlhs.MONHOCs;
txtMaMH.DataBindings.Clear();
txtMaMH.DataBindings.Add("text", dtgMonHoc.DataSource, "MaMon");
txtTenMH.DataBindings.Clear();
txtTenMH.DataBindings.Add("text", dtgMonHoc.DataSource, "TenMon");
for (int i = 0; i < dtgMonHoc.Rows.Count; i++)
{
if (dtgMonHoc.Rows[i].Cells[1].Value != null)//Nếu ô thứ i của cột thứ 1 (cột sau cột STT ấy) mà có dữ liệu thì gán giá trị cho cột STT, nếu không thì cột STT cũng không có dữ liệu
{
dtgMonHoc.Rows[i].Cells[0].Value = i + 1;
}
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
MONHOC monhoc = new MONHOC();
monhoc.MaMon = txtMaMH.Text;
qlhs.Delete_MONHOC(monhoc.MaMon);
qlhs.SubmitChanges();
dtgMonHoc.DataSource = qlhs.MONHOCs;
txtMaMH.DataBindings.Clear();
txtMaMH.DataBindings.Add("text", dtgMonHoc.DataSource, "MaMon");
txtTenMH.DataBindings.Clear();
txtTenMH.DataBindings.Add("text", dtgMonHoc.DataSource, "TenMon");
for (int i = 0; i < dtgMonHoc.Rows.Count; i++)
{
if (dtgMonHoc.Rows[i].Cells[1].Value != null)//Nếu ô thứ i của cột thứ 1 (cột sau cột STT ấy) mà có dữ liệu thì gán giá trị cho cột STT, nếu không thì cột STT cũng không có dữ liệu
{
dtgMonHoc.Rows[i].Cells[0].Value = i + 1;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
qlhs.Update_DiemDat(float.Parse(textBox1.Text), float.Parse(textBox1.Text));
}
private void butXoa_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
qlhs.Delete_GIANGDAY(cbChonGiaoVien.Text);
qlhs.SubmitChanges();
}
private void btnOK_Click(object sender, EventArgs e)
{
qlhs = new DataQLHSDataContext();
qlhs.Update_TUOIHS(float.Parse(txtMin.Text), float.Parse(txtMax.Text));
}
