private void RefreshData() { QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); var query = from b in db.SinhViens select new { b.MaSinhVien, b.TenSinhVien, b.NgaySinh, b.GioiTinh, b.QueQuan, b.Khoa, b.SoDienThoai, b.Email }; txtMaSinhVien.Text = ""; txtTenSinhVien.Text = ""; txtNgaySinh.Text = ""; txtGioiTinh.Text = ""; txtQueQuan.Text = ""; txtKhoa.Text = ""; txtMSVTimKiem.Text = ""; txtEmail.Text = ""; txtSDT.Text = ""; dataSinhVien.DataSource = query; }
private void btnTimKiem_Click(object sender, EventArgs e) { QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); var query = from b in db.BangDiems where b.MaMonHoc == txtTimKiem.Text && b.MaSinhVien == QuanLySinhVien.btnTimKiem.GetMSV() select new { b.MaSinhVien, b.MaMonHoc, b.TenMonHoc, b.SoTinChi, b.Diem }; dataDiem.DataSource = query; LockControl(); if (dataDiem.Rows.Count == 0) { return; } else { for (int i = 0; i < dataDiem.Rows.Count; i++) { string diem = dataDiem.Rows[i].Cells[4].Value.ToString(); if (double.Parse(diem) <= 4) { dataDiem.Rows[i].Cells[4].Style.ForeColor = Color.Red; } } } }
private void btnXoa_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn có muốn xóa sinh viên " + dataSinhVien.Rows[dataSinhVien.CurrentRow.Index].Cells[1].Value.ToString(), "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.Yes) { QuanLySinhVienDataContext db1 = new QuanLySinhVienDataContext(); var query1 = from c in db1.BangDiems where c.MaSinhVien == txtMaSinhVien.Text select new { c.MaSinhVien, c.MaMonHoc, c.SoTinChi, c.TenMonHoc, c.Diem }; int dem = query1.Count(); if (dem != 0) { while (dem != 0) { string MaSinhVien1 = dataSinhVien.Rows[dataSinhVien.CurrentRow.Index].Cells[0].Value.ToString(); BangDiem t1 = db1.BangDiems.FirstOrDefault(p => p.MaSinhVien == MaSinhVien1); db1.BangDiems.DeleteOnSubmit(t1); db1.SubmitChanges(); dem--; } } //-------------------------------------------------- string MaSinhVien = dataSinhVien.Rows[dataSinhVien.CurrentRow.Index].Cells[0].Value.ToString(); QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); SinhVien t = db.SinhViens.FirstOrDefault(p => p.MaSinhVien == MaSinhVien); db.SinhViens.DeleteOnSubmit(t); db.SubmitChanges(); var query = from b in db.SinhViens select new { b.MaSinhVien, b.TenSinhVien, b.NgaySinh, b.GioiTinh, b.QueQuan, b.Khoa, b.Email, b.SoDienThoai }; dataSinhVien.DataSource = query; txtMSVTimKiem.Text = ""; btnTimKiemSV.Enabled = true; } }
private void btnXoa_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn có muốn xóa môn học " + dataDiem.Rows[dataDiem.CurrentRow.Index].Cells[2].Value.ToString(), "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.Yes) { string MaSinhVien = dataDiem.Rows[dataDiem.CurrentRow.Index].Cells[0].Value.ToString(); string MaMonHoc = dataDiem.Rows[dataDiem.CurrentRow.Index].Cells[1].Value.ToString(); QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); BangDiem t = db.BangDiems.FirstOrDefault(p => p.MaSinhVien == MaSinhVien && p.MaMonHoc == MaMonHoc); db.BangDiems.DeleteOnSubmit(t); db.SubmitChanges(); } txtTimKiem.Text = ""; RefreshData(); tinhDiem(); }
private void btnLuu_Click(object sender, EventArgs e) { if (check == "Them") { try { QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); SinhVien n = new SinhVien(); n.MaSinhVien = txtMaSinhVien.Text; n.TenSinhVien = txtTenSinhVien.Text; n.NgaySinh = txtNgaySinh.Text; n.GioiTinh = txtGioiTinh.Text; n.QueQuan = txtQueQuan.Text; n.Khoa = txtKhoa.Text; n.Email = txtEmail.Text; n.SoDienThoai = txtSDT.Text; db.SinhViens.InsertOnSubmit(n); db.SubmitChanges(); MessageBox.Show("Bạn đã thêm xong sinh viên " + txtMaSinhVien.Text); RefreshData(); } catch (Exception ex) { MessageBox.Show("Hãy xem lại mã " + txtMaSinhVien.Text + " nó đã tồn tại!"); } txtMSVTimKiem.Text = ""; } else if (check == "Sua") { QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); var a = (from p in db.SinhViens where p.MaSinhVien == txtMaSinhVien.Text select p).FirstOrDefault(); a.TenSinhVien = txtTenSinhVien.Text; a.NgaySinh = txtNgaySinh.Text; a.GioiTinh = txtGioiTinh.Text; a.QueQuan = txtQueQuan.Text; a.Khoa = txtKhoa.Text; a.SoDienThoai = txtSDT.Text; a.Email = txtEmail.Text; db.SubmitChanges(); MessageBox.Show("Bạn đã thay đổi thành công"); RefreshData(); } LockControl(); btnXemDiem.Enabled = true; btnTimKiemSV.Enabled = true; }
public void RefreshData() { QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); var query = from b in db.BangDiems where b.MaSinhVien == QuanLySinhVien.btnTimKiem.GetMSV() select new { b.MaSinhVien, b.MaMonHoc, b.TenMonHoc, b.SoTinChi, b.Diem }; txtTimKiem.Text = ""; dataDiem.DataSource = query; }
private void btnLuu_Click(object sender, EventArgs e) { if (check == "Them") { try { QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); BangDiem n = new BangDiem(); n.MaSinhVien = txtMaSinhVien.Text; n.MaMonHoc = txtMaMonHoc.Text; n.TenMonHoc = txtTenMonHoc.Text; n.SoTinChi = int.Parse(txtSoTinChi.Text); n.Diem = double.Parse(txtDiem.Text); db.BangDiems.InsertOnSubmit(n); db.SubmitChanges(); MessageBox.Show("Bạn đã thêm xong mã môn học " + txtMaMonHoc.Text); RefreshData(); tinhDiem(); } catch (Exception ex) { MessageBox.Show("Hãy xem lại mã " + txtMaSinhVien.Text + " nó đã tồn tại!"); } } else if (check == "Sua") { QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); var a = (from p in db.BangDiems where p.MaSinhVien == txtMaSinhVien.Text && p.MaMonHoc == txtMaMonHoc.Text select p).FirstOrDefault(); a.MaSinhVien = txtMaSinhVien.Text; a.MaMonHoc = txtMaMonHoc.Text; a.TenMonHoc = txtTenMonHoc.Text; a.SoTinChi = int.Parse(txtSoTinChi.Text); a.Diem = double.Parse(txtDiem.Text); db.SubmitChanges(); MessageBox.Show("Bạn đã thay đổi thành công"); RefreshData(); tinhDiem(); } txtTimKiem.Text = ""; LockControl(); btnTimKiem.Enabled = true; }
private void button1_Click(object sender, EventArgs e)//btntimkiem { QuanLySinhVienDataContext db = new QuanLySinhVienDataContext(); var query = from b in db.SinhViens where b.MaSinhVien == txtMSVTimKiem.Text select new { b.MaSinhVien, b.TenSinhVien, b.NgaySinh, b.GioiTinh, b.QueQuan, b.Khoa, b.SoDienThoai, b.Email }; dataSinhVien.DataSource = query; LockControl(); btnXemDiem.Enabled = true; }