public List <DangKi> getDangKi(int MSSV, int MaHK)
{
string sql = String.Format(@"select LopHoc.MaLop, TenMH, SoTinChi
from LopHoc, MonHoc, SV_LH
where LopHoc.MaMH = MonHoc.MaMH
and LopHoc.MaLop = SV_LH.MaLop
and MaHK = {0}
and MaSV = {1}", MaHK, MSSV);
try
{
SqlDataReader dr = dp.ExecReader(sql);
List <DangKi> list = new List <DangKi>();
string MaLop, TenMH, STC;
while (dr.Read())
{
MaLop = dr.GetString(0);
TenMH = dr.GetString(1);
STC = dr.GetString(2);
DangKi ht = new DangKi(MaLop, TenMH, STC);
list.Add(ht);
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
public int DangKyThi(int mand)
{
try
{
DangKi a = new DangKi();
string ngay = DateTime.Today.Day.ToString();
string thang = DateTime.Today.Month.ToString();
string nam = DateTime.Today.Year.ToString();
string ngaydk = thang + "/" + ngay + "/" + nam;
DateTime dtime = new DateTime(2018, 12, 27);
//string formattedStrings = dti
a.NgayDangKy = DateTime.Today;
a.TinhTrang = false;
a.MaNguoiDung = mand;
var prolist = thi.BoDes.ToList(); // lấy tất cả sản phẩm
int count = prolist.Count();
int index = new Random().Next(count); // lấy random từ 0 => count nhằm mục đính lấy random trong danh sách Product
BoDe pro = prolist.Skip(index).FirstOrDefault();
// dùng Skip để lấy Product thứ index
a.MaBoDe = pro.MaBoDe;
thi.DangKis.InsertOnSubmit(a);
thi.SubmitChanges();
return(0);
}
catch
{
return(1);
}
}
public ActionResult SignUp(DangKi model)
{
tbl_thongtincanhan ttcn = new tbl_thongtincanhan();
tbl_taikhoan tk = new tbl_taikhoan();
Func_ThongTinCaNhan f_ttcn = new Func_ThongTinCaNhan();
Func_TaiKhoan f_tk = new Func_TaiKhoan();
ttcn.ten = model.ten;
ttcn.sdt = model.sdt;
ttcn.email = model.email;
ttcn.ngaysinh = model.ngaysinh;
ttcn.gioitinh = model.gioitinh;
if (ttcn.gioitinh == "Nam")
{
ttcn.anhdaidien = "anhNam.png";
}
else
{
ttcn.anhdaidien = "anhNu.png";
}
ttcn.diachi = model.diachi;
f_ttcn.Insert(ttcn);
tk.id_q = 3;
tk.tentaikhoan = model.tentaikhoan;
tk.matkhau = model.matkhau;
tk.id_ttcn = ttcn.id;
tk.trangthai = true;
f_tk.Insert(tk);
return(Redirect("/Home/Index"));
}
public void UpdateKQ(int makq, int mand)
{
var dung = from kq in thi.ChiTietKetQuas
where kq.MaKetQua == makq && kq.KetQua == true
select kq;
var sai = from kq in thi.ChiTietKetQuas
where kq.MaKetQua == makq && kq.KetQua == false
select kq;
KetQua ketqua = thi.KetQuas.Where(t => t.MaKetQua == makq).FirstOrDefault();
if (ketqua != null)
{
ketqua.DapAnSai = sai.Count();
ketqua.DapAnDung = dung.Count();
}
DangKi dangki = thi.DangKis.Where(t => t.MaNguoiDung == mand && t.TinhTrang == false).FirstOrDefault();
if (dangki != null)
{
dangki.TinhTrang = true;
}
thi.SubmitChanges();
}
