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 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 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 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_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 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();
}