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