private void btnThem_Click_1(object sender, EventArgs e) { LTUDQL1DataContext themnd = new LTUDQL1DataContext(); USER us = new USER(); us.f_HoTen = txtHoTen.Text; us.f_MaSo = txtMaSo.Text; us.f_Email = txtEmail.Text; us.f_GioiTinh = txtGioiTinh.Text; us.f_NgaySinh = txtNgaySinh.Text; us.f_Phone = txtPhone.Text; us.f_TenDangNhap = txtTenDangNhap.Text; us.f_MatKhau = txtMatKhau.Text; us.f_IDPhanQuyen = int.Parse(txtIDPhanQuyen.Text.ToString()); if (us.f_HoTen == "" && us.f_TenDangNhap == "" && us.f_MaSo == "" && us.f_Email == "" && us.f_NgaySinh == "" && us.f_MatKhau == "") { MessageBox.Show("Không được bỏ trống !!!"); return; } else { themnd.USERs.InsertOnSubmit(us); themnd.SubmitChanges(); MessageBox.Show("Tạo thành công người Dùng!!!"); LoadData(); } CleanTextBox(); }
private void Btndangnhap_Click(object sender, EventArgs e) { var tendangnhap = txtUsername.Text; var matkhau = txtPassword.Text; using (var db = new LTUDQL1DataContext()) { if (db.USERs.SingleOrDefault(u => u.f_TenDangNhap == tendangnhap && u.f_MatKhau == matkhau && u.f_IDPhanQuyen == 0) != null) { MessageBox.Show("LOGIN ADMIN"); ViewAdmin f = new ViewAdmin(); this.Hide(); f.ShowDialog(); } else if (db.USERs.SingleOrDefault(u => u.f_TenDangNhap == tendangnhap && u.f_MatKhau == matkhau && u.f_IDPhanQuyen == 2) != null) { MessageBox.Show("LOGIN GIÁO VIÊN"); Form1 f = new Form1(); this.Hide(); f.ShowDialog(); } else if (db.USERs.SingleOrDefault(u => u.f_TenDangNhap == tendangnhap && u.f_MatKhau == matkhau && u.f_IDPhanQuyen == 1) != null) { MessageBox.Show("LOGIN HỌC SINH"); Form2 f = new Form2(); this.Hide(); f.ShowDialog(); } } }
private void btn_TaoKyThi_Click(object sender, EventArgs e) { LTUDQL1DataContext themkt = new LTUDQL1DataContext(); KyThi kt = new KyThi(); kt.MaKT = txtmakt.Text; kt.Ngay = txtmant.Text; kt.MaDT = txtmadt.Text; kt.ThoiGian = txttg.Text; kt.MaHV = txtmahv.Text; if (kt.MaKT == "" && kt.MaHV == "") { MessageBox.Show("Không được bỏ trống Mã Kỳ Thi và Mã Học Viên!!!"); return; } else { themkt.KyThis.InsertOnSubmit(kt); themkt.SubmitChanges(); MessageBox.Show("Tạo thành công kỳ thi thử!!!"); LoadData(); } CleanTextBox(); }
private void LoadData() { using (var db = new LTUDQL1DataContext()) { dgv_NguoiDung.DataSource = db.USERs.Select(u => u); } }
private void LoadData() { using (var db = new LTUDQL1DataContext()) { dataGridViewImport.DataSource = db.USERs.Select(u => u); } }
private void LoadData() { using (var db = new LTUDQL1DataContext()) { dgv_HocVien.DataSource = db.KetQuas.Select(u => u); } }
private void LoadData() { using (var db = new LTUDQL1DataContext()) { dgv_CauHoi.DataSource = db.CauHois.Select(u => u); } }
private void BtnDangKy_Click(object sender, EventArgs e) { var hoten = txtHoTen.Text; var maso = txtMaSo.Text; var email = txtEmail.Text; var ngaysinh = datengaysinh.Text; var gioitinh = cbbGioiTinh.Text; var phone = txtPhone.Text; var tendangnhap = txttendangnhap.Text; var matkhau = txtmatkhau.Text; var phanquyen = int.Parse(cbbPhanQuyen.Text.ToString()); using (var db = new LTUDQL1DataContext()) { if (db.USERs.SingleOrDefault(u => u.f_TenDangNhap == tendangnhap) != null) { MessageBox.Show("User đã tồn tại!"); return; } db.USERs.InsertOnSubmit(new USER { f_HoTen = hoten, f_MaSo = maso, f_Email = email, f_GioiTinh = gioitinh, f_MatKhau = matkhau, f_NgaySinh = ngaysinh, f_Phone = phone, f_TenDangNhap = tendangnhap, f_IDPhanQuyen = phanquyen }); db.SubmitChanges(); } if (txtmatkhau.Text == txtxacnhanmatkhau.Text) { MessageBox.Show("Đăng ký thành công!"); } else if (txtxacnhanmatkhau.Text != txtmatkhau.Text) { MessageBox.Show("Mật khẩu xác nhận không trùng!"); txtxacnhanmatkhau.Focus(); txtxacnhanmatkhau.SelectAll(); } }
private void btn_sua_Click(object sender, EventArgs e) { LTUDQL1DataContext Suadt = new LTUDQL1DataContext(); DeThi dt = new DeThi(); dt = Suadt.DeThis.Where(u => u.MaDK == txtMaDK.Text).Where(u => u.MaDT == txtMaDT.Text).Single(); dt.MaDT = txtMaDT.Text; dt.MaBD = txtMaBD.Text; dt.MaCH = txtMaCH.Text; dt.MaDK = txtMaDK.Text; Suadt.SubmitChanges(); MessageBox.Show("Update Success!!!"); LoadData(); CleanTextBox(); }
private void btn_sua_Click(object sender, EventArgs e) { LTUDQL1DataContext suakt = new LTUDQL1DataContext(); KyThi kt = new KyThi(); kt = suakt.KyThis.Where(u => u.MaKT == txtmakt.Text).Where(u => u.MaHV == txtmahv.Text).Single(); kt.MaKT = txtmakt.Text; kt.Ngay = txtmant.Text; kt.MaDT = txtmadt.Text; kt.ThoiGian = txttg.Text; kt.MaHV = txtmahv.Text; suakt.SubmitChanges(); LoadData(); MessageBox.Show("UpDate thành công!!!"); CleanTextBox(); }
private void btn_RPCauhoi_Click(object sender, EventArgs e) { string cauhoi = txtRPCauHoi.Text; using (var db = new LTUDQL1DataContext()) { bsCR.DataSource = from kq in db.KetQuas join kt in db.KyThis on new { kq.MaKT, kq.MaHV } equals new { kt.MaKT, kt.MaHV } join dt in db.DeThis on kt.MaDT equals dt.MaDT join ch in db.CauHois on dt.MaCH equals ch.MaCH where ch.MaCH == cauhoi select new KetQuaRP { MaHocVien = kq.MaHV, Diem = kq.Diem, KyThi = kt.MaKT, CauHoi = ch.MaCH }; } this.rpv_HocSinh.RefreshReport(); }
private void rpv_HocSinh_Load(object sender, EventArgs e) { rpv_HocSinh.LocalReport.DataSources.Clear(); using (var db = new LTUDQL1DataContext()) { bsCR.DataSource = from kq in db.KetQuas join kt in db.KyThis on new { kq.MaKT, kq.MaHV } equals new { kt.MaKT, kt.MaHV } join dt in db.DeThis on kt.MaDT equals dt.MaDT join ch in db.CauHois on dt.MaCH equals ch.MaCH select new KetQuaRP { MaHocVien = kq.MaHV, Diem = kq.Diem, KyThi = kt.MaKT, CauHoi = ch.MaCH }; } rdsCR.Value = bsCR; rdsCR.Name = "DataSetHV"; rpv_HocSinh.LocalReport.DataSources.Add(rdsCR); }
private void reportViewer1_Load(object sender, EventArgs e) { reportViewer1.LocalReport.DataSources.Clear(); using (var db = new LTUDQL1DataContext()) { bsCR.DataSource = from kq in db.KetQuas join kt in db.KyThis on new { kq.MaKT, kq.MaHV } equals new { kt.MaKT, kt.MaHV } join sv in db.USERs on kt.MaHV equals sv.f_MaSo select new ThiSinhRP { MaKyThi = kt.MaKT, MaHocVien = sv.f_MaSo, TenHocVien = sv.f_HoTen, NgaySinh = sv.f_NgaySinh, GioiTinh = sv.f_GioiTinh, Diem = kq.Diem }; } rdsCR.Value = bsCR; rdsCR.Name = "RPTheoKy"; reportViewer1.LocalReport.DataSources.Add(rdsCR); }
private void btnSua_Click_1(object sender, EventArgs e) { LTUDQL1DataContext sua = new LTUDQL1DataContext(); USER us = new USER(); us = sua.USERs.Where(u => u.f_MaSo == txtMaSo.Text).Single(); us.f_HoTen = txtHoTen.Text; us.f_Email = txtEmail.Text; us.f_GioiTinh = txtGioiTinh.Text; us.f_NgaySinh = txtNgaySinh.Text; us.f_Phone = txtPhone.Text; us.f_TenDangNhap = txtTenDangNhap.Text; us.f_MatKhau = txtMatKhau.Text; us.f_IDPhanQuyen = int.Parse(txtIDPhanQuyen.Text.ToString()); sua.SubmitChanges(); MessageBox.Show("UpDate thành công!!!"); LoadData(); CleanTextBox(); }
private void btn_Sua_Click(object sender, System.EventArgs e) { LTUDQL1DataContext themCauHoi = new LTUDQL1DataContext(); CauHoi ch = new CauHoi(); ch = themCauHoi.CauHois.Where(u => u.MaCH == txtMaCH.Text).Single(); ch.MaCH = txtMaCH.Text; ch.CapHoc = txtCaphoc.Text; ch.MonHoc = txtMH.Text; ch.NoiDung = txtND.Text; ch.DapAnA = txtDAA.Text; ch.DapAnB = txtDAB.Text; ch.DapAnC = txtDAC.Text; ch.DapAnD = txtDAD.Text; ch.DapAnDung = txtDA.Text; themCauHoi.SubmitChanges(); LoadData(); MessageBox.Show("Update success!!!"); CleanTextBox(); }
private void btn_them_Click(object sender, EventArgs e) { LTUDQL1DataContext themdt = new LTUDQL1DataContext(); DeThi dt = new DeThi(); dt.MaDT = txtMaDT.Text; dt.MaBD = txtMaBD.Text; dt.MaCH = txtMaCH.Text; dt.MaDK = txtMaDK.Text; if (dt.MaDK == "" && dt.MaDT == "") { MessageBox.Show("Insert Fail!!!"); return; } themdt.DeThis.InsertOnSubmit(dt); themdt.SubmitChanges(); MessageBox.Show("Insert Success!!!"); LoadData(); CleanTextBox(); }
private void btn_LoadReport_Click(object sender, EventArgs e) { string ky = txtChonKy.Text; using (var db = new LTUDQL1DataContext()) { bsCR.DataSource = from kq in db.KetQuas join kt in db.KyThis on new { kq.MaKT, kq.MaHV } equals new { kt.MaKT, kt.MaHV } join sv in db.USERs on kt.MaHV equals sv.f_MaSo where kt.MaKT == ky select new ThiSinhRP { MaKyThi = kt.MaKT, MaHocVien = sv.f_MaSo, TenHocVien = sv.f_HoTen, NgaySinh = sv.f_NgaySinh, GioiTinh = sv.f_GioiTinh, Diem = kq.Diem }; } this.reportViewer1.RefreshReport(); }
private void btnDongGop_Click(object sender, EventArgs e) { LTUDQL1DataContext DongGop = new LTUDQL1DataContext();