public JsonResult GetAllQuestion(int id)
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
var lstCauHoi = db.CauHois.Where(x => (x.MaGiangVien == session.ID || x.TrangThai == true) && x.MaMonHoc == id);
List <CauHoiModel> CHs = new List <CauHoiModel>();
foreach (var item in lstCauHoi)
{
CauHoiModel ch = new CauHoiModel();
ch.MaCauHoi = item.MaCauHoi;
ch.NoiDung = item.NoiDung;
ch.BieuThuc = item.BieuThuc;
ch.TenChuong = item.Chuong.Name;
ch.DoKho = (int)item.DoKho;
ch.TrangThai = (bool)item.TrangThai;
ch.ChuongID = (long)item.ChuongID;
ch.TenGV = item.GiangVien.HoVaTen;
CHs.Add(ch);
}
return(Json(CHs, JsonRequestBehavior.AllowGet));
}
}
private void randomCauHoi()
{
int MaxSizeRandom = int.Parse(soande.getMAXCau().Tables[0].Rows[0][0].ToString());
int NumOfQuestion = int.Parse(soande.getTongCau().Tables[0].Rows[0][0].ToString());
DataTable dtMaCauHoi = soande.getTatCaMaCauHoi().Tables[0];
List <int> listMaCauHoiSeThi = new List <int>();
List <int> listMaTatCaCauHoi = new List <int>();
foreach (DataRow dr in dtMaCauHoi.Rows)
{
int maso = int.Parse(dr[0].ToString());
listMaTatCaCauHoi.Add(maso);
}
int socauthi = SO_CAU_THI;
Random random = new Random();
if (socauthi >= NumOfQuestion)
{
MessageBox.Show("Số câu đã lơn hơn tổng số câu trong ngân hàng câu hỏi!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
do
{
int macau = random.Next(1, MaxSizeRandom);
if (!listMaCauHoiSeThi.Contains(macau) && listMaTatCaCauHoi.Contains(macau))
{
listMaCauHoiSeThi.Add(macau);
socauthi--;
}
} while (socauthi > 0);
listCauHoiSeThi = new List <CauHoiModel>();
foreach (int i in listMaCauHoiSeThi)
{
DataTable dtNoiDungCauHoi = soande.getChiTietCauHoi(i).Tables[0];
CauHoiModel cauhoi = new CauHoiModel();
cauhoi.MaCauHoi = int.Parse(dtNoiDungCauHoi.Rows[0][0].ToString());
cauhoi.NoiDungCauHoi = dtNoiDungCauHoi.Rows[0][1].ToString();
cauhoi.NoiDungDapAn_A = dtNoiDungCauHoi.Rows[0][2].ToString();
cauhoi.NoiDungDapAn_B = dtNoiDungCauHoi.Rows[0][3].ToString();
cauhoi.NoiDungDapAn_C = dtNoiDungCauHoi.Rows[0][4].ToString();
cauhoi.NoiDungDapAn_D = dtNoiDungCauHoi.Rows[0][5].ToString();
cauhoi.DapAnDung = dtNoiDungCauHoi.Rows[0][6].ToString();
if (!thitracnghiemBA.ThemChiTietThi(lblMaLanThi.Text, cauhoi.MaCauHoi))
{
return;
}
listCauHoiSeThi.Add(cauhoi);
}
}
public ActionResult Update(CauHoiModel cauhoi)
{
using (ELearningDB db = new ELearningDB())
{
if (ModelState.IsValid)
{
TimeZoneInfo date = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time");
DateTime utc = DateTime.UtcNow;
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(utc, date);
CauHoi ch = db.CauHois.Find(cauhoi.MaCauHoi);
ch.NoiDung = cauhoi.NoiDung;
ch.BieuThuc = cauhoi.BieuThuc;
ch.CauA = cauhoi.CauA;
ch.BieuThucA = cauhoi.BieuThucA;
ch.CauB = cauhoi.CauB;
ch.BieuThucB = cauhoi.BieuThucB;
ch.CauC = cauhoi.CauC;
ch.BieuThucC = cauhoi.BieuThucC;
ch.CauD = cauhoi.CauD;
ch.BieuThucD = cauhoi.BieuThucD;
ch.DapAn = cauhoi.DapAn;
ch.DoKho = cauhoi.DoKho;
ch.ChuongID = cauhoi.ChuongID;
ch.NgaySua = now;
db.SaveChanges();
return(RedirectToAction("CauHoi", "CauHoi", new { id = ch.MaMonHoc }));
}
return(View(cauhoi));
}
}
public JsonResult GetCauHoiKT(LopKTModel lop)
{
using (ELearningDB db = new ELearningDB())
{
var lstCauHoi = db.CauHois.Where(x => x.DeThis.Any(r => r.MaDeThi == lop.MaDeThi)).ToList();
List <CauHoiModel> CauHois = new List <CauHoiModel>();
foreach (var item in lstCauHoi)
{
CauHoiModel ch = new CauHoiModel();
ch.NoiDung = item.NoiDung;
ch.BieuThuc = item.BieuThuc;
ch.CauA = item.CauA;
ch.BieuThucA = item.BieuThucA;
ch.CauB = item.CauB;
ch.BieuThucB = item.BieuThucB;
ch.CauC = item.CauC;
ch.BieuThucC = item.BieuThucC;
ch.CauD = item.CauD;
ch.BieuThucD = item.BieuThucD;
ch.DapAn = (int)item.DapAn;
CauHois.Add(ch);
}
return(Json(CauHois, JsonRequestBehavior.AllowGet));
}
}
public ApiResponse <CauHoiModel> UpdateCauHoi(CauHoiModel cauHoiModel)
{
string jsonObject = JsonConvert.SerializeObject(cauHoiModel);
var list = CoreRepo.PostToGetApiResponse <CauHoiModel>(Constance.Constance.UrlApi, "CauHoi/UpdateCauHoi/", jsonObject);
if (list.Status == (int)HttpStatusCode.NotFound)
{
return(list);
}
return(list);
}
public ActionResult Edit(CauHoiModel collection)
{
try
{
// TODO: Add update logic here
var model = _cauHoiRepo.UpdateCauHoi(collection);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult TaoMoi(int id)
{
ELearningDB db = new ELearningDB();
CauHoiModel cauhoi = new CauHoiModel();
var LstChuong = db.Chuongs.Where(x => x.MaMonHoc == id);
List <ChuongModel> Chuongs = new List <ChuongModel>();
foreach (var item in LstChuong)
{
ChuongModel chuong = new ChuongModel();
chuong.ID = item.ID;
chuong.Name = item.Name;
Chuongs.Add(chuong);
}
ViewBag.Chuong = Chuongs;
cauhoi.MaMonHoc = id;
return(View(cauhoi));
}
public JsonResult GetCauHoi_DeThi(int id) //param:MaDeThi
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
var lstCauHoi = db.CauHois.Where(x => x.DeThis.Any(s => s.MaDeThi == id));
List <CauHoiModel> CauHois = new List <CauHoiModel>();
foreach (var item in lstCauHoi)
{
CauHoiModel ch = new CauHoiModel();
ch.MaCauHoi = item.MaCauHoi;
ch.NoiDung = item.NoiDung;
ch.BieuThuc = item.BieuThuc;
CauHois.Add(ch);
}
return(Json(CauHois, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create(CauHoiModel collection)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
var addNewCauHoi = _cauHoiRepo.CreateCauHoi(collection);
if (addNewCauHoi.CheckStatus())
{
return(RedirectToAction("Index", "CauHoi"));
}
}
return(View());
}
catch
{
return(View());
}
}
public JsonResult GetCauHoi(CauHoiDeThiModel chdt) //tham số: mã môn học
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
List <CauHoiModel> CHs = new List <CauHoiModel>();
var lstCauHoiDeThi = db.CauHois.Where(x => x.DeThis.Any(s => s.MaDeThi == chdt.DeThiID));
List <CauHoi> lstCH = db.CauHois.Where(x => x.MaGiangVien == session.ID && x.MaMonHoc == chdt.MaMonHoc).Except(lstCauHoiDeThi).ToList();
foreach (var item in lstCH)
{
CauHoiModel ch = new CauHoiModel();
ch.MaCauHoi = item.MaCauHoi;
ch.NoiDung = item.NoiDung;
ch.BieuThuc = item.BieuThuc;
ch.TenChuong = item.Chuong.Name;
ch.DoKho = (int)item.DoKho;
ch.TrangThai = (bool)item.TrangThai;
ch.DapAn = (int)item.DapAn;
ch.CauA = item.CauA;
ch.CauB = item.CauB;
ch.CauC = item.CauC;
ch.CauD = item.CauD;
ch.BieuThucA = item.BieuThucA;
ch.BieuThucB = item.BieuThucB;
ch.BieuThucC = item.BieuThucC;
ch.BieuThucD = item.BieuThucD;
ch.ChuongID = (long)item.ChuongID;
ch.TenGV = item.GiangVien.HoVaTen;
CHs.Add(ch);
}
return(Json(CHs, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Details(int id)
{
using (ELearningDB db = new ELearningDB())
{
CauHoi ch = db.CauHois.Find(id);
CauHoiModel cauhoi = new CauHoiModel();
cauhoi.MaCauHoi = ch.MaCauHoi;
cauhoi.NoiDung = ch.NoiDung;
cauhoi.BieuThuc = ch.BieuThuc;
cauhoi.TenChuong = ch.Chuong.Name;
cauhoi.DoKho = (int)ch.DoKho;
cauhoi.GiangVienID = ch.MaGiangVien;
cauhoi.TenGV = ch.GiangVien.HoVaTen;
cauhoi.NgayTao = ch.NgayTao.Value.ToString("dd/MM/yyyy");
cauhoi.CauA = ch.CauA;
cauhoi.BieuThucA = ch.BieuThucA;
cauhoi.CauB = ch.CauB;
cauhoi.BieuThucB = ch.BieuThucB;
cauhoi.CauC = ch.CauC;
cauhoi.BieuThucC = ch.BieuThucC;
cauhoi.CauD = ch.CauD;
cauhoi.BieuThucD = ch.BieuThucD;
cauhoi.DapAn = (int)ch.DapAn;
if (ch.NgaySua == null)
{
cauhoi.NgaySua = "";
}
else
{
cauhoi.NgaySua = ch.NgaySua.Value.ToString("dd/MM/yyyy");
}
cauhoi.MaMonHoc = (int)ch.MaMonHoc;
return(View(cauhoi));
}
}
public ActionResult Update(int id)
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
CauHoi cauhoi = db.CauHois.Find(id);
CauHoiModel ch = new CauHoiModel();
ch.MaCauHoi = cauhoi.MaCauHoi;
ch.NoiDung = cauhoi.NoiDung;
ch.BieuThuc = cauhoi.BieuThuc;
ch.CauA = cauhoi.CauA;
ch.BieuThucA = cauhoi.BieuThucA;
ch.CauB = cauhoi.CauB;
ch.BieuThucB = cauhoi.BieuThucB;
ch.CauC = cauhoi.CauC;
ch.BieuThucC = cauhoi.BieuThucC;
ch.CauD = cauhoi.CauD;
ch.BieuThucD = cauhoi.BieuThucD;
ch.DapAn = (int)cauhoi.DapAn;
ch.DoKho = (int)cauhoi.DoKho;
ch.MaMonHoc = (int)cauhoi.MaMonHoc;
var LstChuong = db.Chuongs.Where(x => x.MaMonHoc == ch.MaMonHoc);
List <ChuongModel> Chuongs = new List <ChuongModel>();
foreach (var item in LstChuong)
{
ChuongModel chuong = new ChuongModel();
chuong.ID = item.ID;
chuong.Name = item.Name;
Chuongs.Add(chuong);
}
ViewBag.Chuong = Chuongs;
return(View(ch));
}
}
public ActionResult TaoMoi(CauHoiModel cauhoi)
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
if (session == null)
{
TempData["Error"] = "Bạn chưa đăng nhập";
return(RedirectToAction("TrangChu", "Home"));
}
else
{
if (session.loai != 2)
{
TempData["Error"] = "Bạn chưa đăng nhập";
return(RedirectToAction("TrangChu", "Home"));
}
}
using (ELearningDB db = new ELearningDB())
{
TimeZoneInfo date = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time");
DateTime utc = DateTime.UtcNow;
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(utc, date);
if (ModelState.IsValid)
{
CauHoi ch = new CauHoi();
ch.NoiDung = cauhoi.NoiDung;
ch.BieuThuc = cauhoi.BieuThuc;
ch.CauA = cauhoi.CauA;
ch.BieuThucA = cauhoi.BieuThucA;
ch.CauB = cauhoi.CauB;
ch.BieuThucB = cauhoi.BieuThucB;
ch.CauC = cauhoi.CauC;
ch.BieuThucC = cauhoi.BieuThucC;
ch.CauD = cauhoi.CauD;
ch.BieuThucD = cauhoi.BieuThucD;
ch.DapAn = cauhoi.DapAn;
ch.DoKho = cauhoi.DoKho;
ch.TrangThai = true;
ch.NgayTao = now;
ch.MaMonHoc = cauhoi.MaMonHoc;
ch.MaGiangVien = session.ID;
ch.ChuongID = cauhoi.ChuongID;
db.CauHois.Add(ch);
db.SaveChanges();
return(RedirectToAction("CauHoi", "CauHoi", new { id = cauhoi.MaMonHoc }));
}
var LstChuong = db.Chuongs.Where(x => x.MaMonHoc == cauhoi.MaMonHoc);
List <ChuongModel> Chuongs = new List <ChuongModel>();
foreach (var item in LstChuong)
{
ChuongModel chuong = new ChuongModel();
chuong.ID = item.ID;
chuong.Name = item.Name;
Chuongs.Add(chuong);
}
ViewBag.Chuong = Chuongs;
return(View(cauhoi));
}
}
