public int KiemTraDangNhap(int uname, string pass)
{
using (db = new DKHPDataContext())
{
var user = db.TaiKhoans.Where(x => x.maTK == uname).FirstOrDefault();
if (user != null)
{
if (user.pass == pass)
{
if (user.quyentruycap == 1)
{
return(1);
}
else if (user.quyentruycap == 2)
{
return(2);
}
else if (user.quyentruycap == 3)
{
return(3);
}
}
}
return(4);
}
}
private void btnChapNhan_Click(object sender, EventArgs e)
{
if (txtTenLHP.Text != "" && txtPhongHoc.Text != "" && txtMaLHP.Text != "" && txtLichHoc.Text != "")
{
try
{
db = new DKHPDataContext();
LopHocPhan h = new LopHocPhan();
h.maGV = Int32.Parse(cboGiangVien.SelectedValue.ToString());
h.maHK = Int32.Parse(cboHocKi.SelectedValue.ToString());
h.maMH = cboMon.SelectedValue.ToString();
h.tenLop = txtTenLHP.Text;
h.maLopHP = Int32.Parse(txtMaLHP.Text);
h.PhongHoc = txtPhongHoc.Text;
h.LichHoc = txtLichHoc.Text;
h.ThoiGianBDHoc = dtpBD.Value;
h.ThoiGianKetThuc = dtpKT.Value;
db.LopHocPhans.InsertOnSubmit(h);
db.SubmitChanges();
MessageBox.Show("Mở Lớp Thành Công");
XoaTextBox();
}
catch
{
MessageBox.Show("Sai Kiểu Dữ Liệu");
}
}
else
{
MessageBox.Show("Chưa Nhập Đủ Thông Tin");
}
}
private void frmGV_Load(object sender, EventArgs e)
{
DKHPDataContext db = new DKHPDataContext();
var user = db.GiangViens.Where(x => x.maGV == Int32.Parse(lblMGV.Text)).SingleOrDefault();
{
lblTenGv.Text = user.hotenGV;
//lblKhoa.Text = user;
lblNganh.Text = user.nganh;
//lblMGV.Text = user.maGV;
}
}
private void frmSV_Load(object sender, EventArgs e)
{
DKHPDataContext db = new DKHPDataContext();
var user = db.SinhViens.Where(x => x.maSV == Int32.Parse(lblMSV.Text)).SingleOrDefault();
{
lblTen.Text = user.hotenSV;
lblKhoa.Text = user.khoa;
lblLop.Text = user.lop;
lblChuyenNganh.Text = user.nganh;
}
}
private void btnHuy_Click(object sender, EventArgs e)
{
DataGridViewRow dtr = dgrLHP.CurrentRow;
if (dtr != null && !dtr.IsNewRow)
{
DKHPDataContext db = new DKHPDataContext();
var j = db.SinhVienDangKies.Where(p => p.maLopHP == Int32.Parse((dtr.Cells[0].Value.ToString())) && p.maSV == Int32.Parse(txtMSV.Text)).FirstOrDefault();
db.SinhVienDangKies.DeleteOnSubmit(j);
db.SubmitChanges();
loadLHP(Int32.Parse(txtMSV.Text));
}
}
public int ThemSVDK(eSVDangKi h)
{
if (h != null)
{
SinhVienDangKy v = new SinhVienDangKy();
db = new DKHPDataContext();
v.maSV = h.MaSV;
v.maChiTietLopHP = h.MaCTLHP;
db.SinhVienDangKies.InsertOnSubmit(v);
db.SubmitChanges();
return(1);
}
return(0);
}
private void btnTim_Click(object sender, EventArgs e)
{
DKHPDataContext db = new DKHPDataContext();
try
{
if (txtMSV.Text != "")
{
var d = db.SinhViens.Where(g => g.maSV == Int32.Parse(txtMSV.Text)).FirstOrDefault();
if (d != null)
{
txtTen.Text = d.hotenSV;
txtLop.Text = d.lop;
txtKhoa.Text = d.khoa;
txtChuyenNganh.Text = d.nganh;
if (d.image != null)
{
MemoryStream memory = new MemoryStream(d.image.ToArray());
Image img = Image.FromStream(memory);
if (img == null)
{
return;
}
pictureBox1.Image = img;
}
loadLHP(Int32.Parse(txtMSV.Text));
btnSua.Enabled = true;
}
else
{
MessageBox.Show("Không Tìm Thấy Sinh Viên");//Thay Đổi
txtChuyenNganh.Clear();
txtKhoa.Clear();
txtLop.Clear();
txtMSV.Clear();
txtTen.Clear();
txtMSV.Focus();
}
}
else
{
MessageBox.Show("Chưa Nhập MSSV");
}
}
catch
{
MessageBox.Show("MSSV là số");
}
}
private void frmMoLHP_Load(object sender, EventArgs e)
{
db = new DKHPDataContext();
cboGiangVien.DataSource = db.GiangViens;
cboGiangVien.DisplayMember = "hotenGV";
cboGiangVien.ValueMember = "maGV";
//
cboHocKi.DataSource = db.HocKies;
cboHocKi.DisplayMember = "maHK";
cboHocKi.ValueMember = "hocKy1";
//
cboMon.DataSource = db.MonHocs;
cboMon.DisplayMember = "tenMon";
cboMon.ValueMember = "maMH";
}
private void frmDKHP2_Load_1(object sender, EventArgs e)
{
db = new DKHPDataContext();
loadgridLHPDK(Int32.Parse(textBox1.Text));
var j = (from g in db.HocKies
where g.NamHoc <= Int32.Parse(textBox2.Text)
select new
{
g.NamHoc,
g.hocKy1
});
cboHocKy.DataSource = j;
cboHocKy.DisplayMember = "hocKy1";
cboHocKy.ValueMember = "NamHoc";
}
public void loadgridLHPDK(int ma)
{
DKHPDataContext db = new DKHPDataContext();
var v = (from a in db.SinhVienDangKies
join b in db.LopHocPhans on a.maLopHP equals b.maLopHP
join n in db.MonHocs on b.maMH equals n.maMH
where a.maSV == ma
select new
{
b.maLopHP,
n.tenMon,
n.tinChi
});
dgrLHPDK.DataSource = v;
}
public void loadGridLHP(string mamon)
{
DKHPDataContext db = new DKHPDataContext();
var n = (from s in db.MonHocs
join c in db.LopHocPhans on s.maMH equals c.maMH
where s.maMH == mamon
select new
{
c.maLopHP,
s.tenMon,
c.tenLop,
s.tinChi
});
dgrLopHocPhan.DataSource = n;
}
private void loadLHP(int masv)
{
DKHPDataContext db = new DKHPDataContext();
var g = (from y in db.SinhVienDangKies
join h in db.LopHocPhans on y.maLopHP equals h.maLopHP
where y.maSV == masv
select new
{
h.maLopHP,
h.LichHoc,
h.tenLop,
h.ThoiGianBDHoc,
h.ThoiGianKetThuc
});
dgrLHP.DataSource = g;
}
private void button2_Click(object sender, EventArgs e)
{
MemoryStream stream = new MemoryStream();
pictureBox1.Image.Save(stream, ImageFormat.Png);
DKHPDataContext db = new DKHPDataContext();
SinhVien sv = new SinhVien();
sv.hotenSV = txtTen.Text;
sv.maSV = Int32.Parse(txtMSV.Text);
sv.lop = txtLop.Text;
sv.nganh = txtChuyenNganh.Text;
sv.khoa = txtKhoa.Text;
sv.image = stream.ToArray();
db.SinhViens.InsertOnSubmit(sv);
db.SubmitChanges();
}
private void button1_Click(object sender, EventArgs e)
{
if (txtTK.Text != "" && txtGK.Text != "" && txtCK.Text != "")
{
db = new DKHPDataContext();
SinhVienDangKy h = db.SinhVienDangKies.Where(p => p.maSV == Int32.Parse(txtMaSV.Text) && p.maLopHP == Int32.Parse(txtMLHP.Text)).FirstOrDefault();
h.ThuongKi = Int32.Parse(txtTK.Text);
h.GiuaKi = Int32.Parse(txtGK.Text);
h.CuoiKi = Int32.Parse(txtCK.Text);
db.SubmitChanges();
cboLopHP_SelectedIndexChanged(cboLopHP, null);
clearTextBox();
}
else
{
MessageBox.Show("Chưa Nhập Dữ Liệu");
}
}
private void frmDiem_Load(object sender, EventArgs e)
{
db = new DKHPDataContext();
var t = (from f in db.GiangViens
join g in db.LopHocPhans on f.maGV equals g.maGV
join h in db.MonHocs on g.maMH equals h.maMH
where f.maGV == Int32.Parse(textBox1.Text)
select new
{
g.tenLop,
h.tenMon,
g.maLopHP
});
cboLopHP.DataSource = t;
cboLopHP.DisplayMember = "tenLop";
cboLopHP.ValueMember = "maLopHP";
}
private void frmGiangVien_Load(object sender, EventArgs e)
{
DKHPDataContext db = new DKHPDataContext();
var user = db.GiangViens.Where(x => x.maGV == Int32.Parse(lblMGV.Text)).SingleOrDefault();
{
lblTen.Text = user.hotenGV;
lblNganh.Text = user.nganh;
if (user.image != null)
{
MemoryStream memory = new MemoryStream(user.image.ToArray());
Image img = Image.FromStream(memory);
if (img == null)
{
return;
}
ptrAva.Image = img;
}
}
}
public void loadGridMon(int hk)
{
DKHPDataContext db = new DKHPDataContext();
var nv = (from s in db.MonHocs
join w in db.HocKies on s.MaHK equals w.maHK
where w.hocKy1 == hk && !(from a in db.SinhVienDangKies
join b in db.LopHocPhans on a.maLopHP equals b.maLopHP
join n in db.MonHocs on b.maMH equals n.maMH
where a.maSV == Int32.Parse(textBox1.Text)
select n.tenMon).Contains(s.tenMon)
select new
{
s.maMH,
s.tinChi,
s.tenMon,
w.hocKy1
});
dgrMon.DataSource = nv;
}
private void loadds(int malhp)
{
db = new DKHPDataContext();
var h = (from p in db.SinhVienDangKies
join f in db.SinhViens on p.maSV equals f.maSV
join t in db.LopHocPhans on p.maLopHP equals t.maLopHP
where t.maLopHP == malhp
select new
{
t.maLopHP,
f.maSV,
f.hotenSV,
p.ThuongKi,
p.GiuaKi,
p.CuoiKi
}
);
dgrSV.DataSource = h;
}
private void frmSinhVien_Load_1(object sender, EventArgs e)
{
DKHPDataContext db = new DKHPDataContext();
var user = db.SinhViens.Where(x => x.maSV == Int32.Parse(lblMSV.Text)).SingleOrDefault();
{
lblTen.Text = user.hotenSV;
lblKhoa.Text = user.khoa;
lblLop.Text = user.lop;
lblNganh.Text = user.nganh;
lblNam.Text = (DateTime.Now.Year - user.NamVaoHoc).ToString();
if (user.image != null)
{
MemoryStream memory = new MemoryStream(user.image.ToArray());
Image img = Image.FromStream(memory);
if (img == null)
{
return;
}
ptrAva.Image = img;
}
}
}
private void frmLichDay_Load(object sender, EventArgs e)
{
db = new DKHPDataContext();
var g = (from u in db.GiangViens
join f in db.LopHocPhans on u.maGV equals f.maGV
join t in db.MonHocs on f.maMH equals t.maMH
join h in db.HocKies on f.maHK equals h.maHK
where u.maGV == Int32.Parse(textBox1.Text)
orderby h.hocKy1
select new
{
t.tenMon,
f.PhongHoc,
f.LichHoc,
f.ThoiGianBDHoc,
f.ThoiGianKetThuc,
h.hocKy1
}
);
dgrLichDay.DataSource = g;
}
public void loadTTLHP(int ma)
{
DKHPDataContext db = new DKHPDataContext();
var v = (from a in db.LopHocPhans
join r in db.GiangViens on a.maGV equals r.maGV
where a.maLopHP == ma
select new
{
a.maLopHP,
a.tenLop,
a.LichHoc,
r.hotenGV
});
foreach (var x in v)
{
lblMaLopHP.Text = x.maLopHP.ToString();
lblTenGiaoVien.Text = x.hotenGV.ToString();
lblSoLuong.Text = x.LichHoc.ToString();
lblTongso.Text = x.tenLop.ToString();
}
}
private void frmDiemSV_Load(object sender, EventArgs e)
{
db = new DKHPDataContext();
var g = (from u in db.SinhVienDangKies
join f in db.SinhViens on u.maSV equals f.maSV
join t in db.LopHocPhans on u.maLopHP equals t.maLopHP
join h in db.HocKies on t.maHK equals h.maHK
join m in db.MonHocs on t.maMH equals m.maMH
where f.maSV == Int32.Parse(textBox1.Text)
orderby h.hocKy1
select new
{
t.maLopHP,
m.tenMon,
u.ThuongKi,
u.GiuaKi,
u.CuoiKi,
h.hocKy1
}
);
dgrDiem.DataSource = g;
}
private void btnDK_Click(object sender, EventArgs e)
{
DataGridViewRow dtr = dgrLopHocPhan.CurrentRow;
if (dtr != null && !dtr.IsNewRow)
{
int hk = 0;
int.TryParse(cboHocKy.Text.ToString(), out hk);
db = new DKHPDataContext();
SinhVienDangKy g = new SinhVienDangKy();
g.maSV = Int32.Parse(textBox1.Text);
g.maLopHP = Int32.Parse(dtr.Cells[0].Value.ToString());
db.SinhVienDangKies.InsertOnSubmit(g);
db.SubmitChanges();
loadgridLHPDK(Int32.Parse(textBox1.Text));
cboHocKy_SelectedIndexChanged(cboHocKy, null);
dgrMon_SelectionChanged(dgrMon, null);
//loadGridMon(hk);
}
else
{
MessageBox.Show("Chưa Chọn Lớp");
}
}
public SvDangKiBLL()
{
db = new DKHPDataContext();
}
private void btnLuu_Click(object sender, EventArgs e)
{
DKHPDataContext db = new DKHPDataContext();
if (txtMSV.Text != "" && txtLop.Text != "" && txtTen.Text != "" && txtKhoa.Text != "" && txtChuyenNganh.Text != "" && pictureBox1.Image != null)
{
if (sua)
{
SinhVien f = db.SinhViens.Single(p => p.maSV == Int32.Parse(txtMSV.Text));
f.hotenSV = txtTen.Text;
f.khoa = txtKhoa.Text;
f.lop = txtLop.Text;
f.nganh = txtChuyenNganh.Text;
MemoryStream stream = new MemoryStream();
pictureBox1.Image.Save(stream, ImageFormat.Png);
f.image = stream.ToArray();
db.SubmitChanges();
setEnableControl(false);
btnLuu.Enabled = false;
txtMSV.Enabled = true;
}
if (Them)
{
try
{
MemoryStream stream = new MemoryStream();
pictureBox1.Image.Save(stream, ImageFormat.Png);
SinhVien sv = new SinhVien();
sv.hotenSV = txtTen.Text;
sv.maSV = Int32.Parse(txtMSV.Text);
sv.lop = txtLop.Text;
sv.nganh = txtChuyenNganh.Text;
sv.khoa = txtKhoa.Text;
if (pictureBox1.Image != null)
{
sv.image = stream.ToArray();
}
db.SinhViens.InsertOnSubmit(sv);
db.SubmitChanges();
setEnableControl(false);
btnLuu.Enabled = false;
txtMSV.Enabled = true;
}
catch
{
MessageBox.Show("Sai kiểu dữ liệu");
txtKhoa.Clear();
txtLop.Clear();
txtMSV.Clear();
txtTen.Clear();
txtChuyenNganh.Clear();
txtMSV.Focus();
pictureBox1.Image = null;
}
}
}
else
{
MessageBox.Show("Chưa Nhập Đầy Đủ Thông Tin");
}
}
