/// <summary>
/// lấy mark theo mã sinh viên và mã khóa học
/// </summary>
/// <param name="coursecode"></param>
/// <returns></returns>
public JsonResult GetByStudentCourse(string coursecode)
{
string studentcode = _ses.loginCode;
MARK_BUS bus = new MARK_BUS();
var data = bus.GetByKey(new fieldpara("STUDENTCODE", studentcode, 0),
new fieldpara("COURSECODE", coursecode, 0),
new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
bus.CloseConnection();
return(Json(new { data }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Lây ra lấy ra mã sinh viên được chỉ định trong bảng điểm của một lớp môn học
/// </summary>
/// <param name="studentcode">mã sinh viên</param>
/// <param name="coursecode">mã lớp môn học</param>
/// <returns></returns>
public JsonResult GetMarkCode(string studentcode, string coursecode)
{
MARK_BUS markbus = new MARK_BUS();
MARK_OBJ obj = markbus.GetByKey(new fieldpara("STUDENTCODE", studentcode, 0),
new fieldpara("COURSECODE", coursecode, 0));
markbus.CloseConnection();
var jsonResult = Json(new
{
obj, //Danh sách
ret = 0 //ok
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
/// <summary>
/// thêm dữ liệu vào bảng examhallstudent :
/// </summary>
/// <param name="listStudentCode"></param>
/// <param name="examTimeCode"></param>
/// <param name="courseCode"></param>
/// <param name="parentCode"></param>
/// <returns></returns>
public JsonResult Insert(List<string> listStudentCode, string examTimeCode, string courseCode)
{
int ret = 0;
if (listStudentCode != null)
{
EXAMHALLSTUDENT_BUS bus = new EXAMHALLSTUDENT_BUS();
foreach (var studentCode in listStudentCode)
{
MARK_BUS markBus = new MARK_BUS();
MARK_OBJ markObj = markBus.GetByKey(
new fieldpara("STUDENTCODE", studentCode, 0),
new fieldpara("COURSECODE", courseCode, 0),
new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0)
);
if (markObj == null)
ret = -1;
else
{
// kiểm tra đã tồn tại bản ghi có markcode và coursecode truyền vào chưa
EXAMHALLSTUDENT_OBJ obj = bus.GetByKey(
new fieldpara("MARKCODE", markObj.CODE, 0),
new fieldpara("COURSECODE", courseCode, 0),
new fieldpara("EXAMTIMECODE", examTimeCode, 0),
new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0)
);
if (obj != null)
{
ret = -2;
return Json(new { ret }, JsonRequestBehavior.AllowGet);
}
EXAMHALLSTUDENT_OBJ objTemp = new EXAMHALLSTUDENT_OBJ();
objTemp.CODE = bus.genNextCode(objTemp);
objTemp.MARKCODE = markObj.CODE;
objTemp.COURSECODE = courseCode;
objTemp.EXAMTIMECODE = examTimeCode;
objTemp.LOCK = 0;
objTemp.EDITTIME = DateTime.Now;
objTemp.EDITUSER = _ses.loginCode;
objTemp.UNIVERSITYCODE = _ses.gUNIVERSITYCODE;
ret = bus.insert(objTemp);
}
markBus.CloseConnection();
}
bus.CloseConnection();
}
return Json(new { ret }, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// logic: truyền vào coursecode và examtimecode
/// từ coursecode và examtimecode -> tìm được examhallstudent tương ứng -> lấy ra được examformcode chính là đề thi mà sinh viên đó làm
/// lấy ra danh sách các nhóm câu hỏi của đề thi đấy (dữ liệu trong bảng examformdetail)
/// lấy danh sách các câu hỏi
/// </summary>
/// <param name="coursecode">mã lớp môn học</param>
/// <param name="examtimecode"></param>
/// <returns></returns>
public JsonResult ShowExamResult(string coursecode, string examtimecode)
{
if (string.IsNullOrEmpty(coursecode))
{
coursecode = "1708310001";
}
if (string.IsNullOrEmpty(examtimecode))
{
examtimecode = "1712250004";
}
var ret = 0;
string studentcode = "";
List <QUESTION_OBJ> liQuestion = null;
List <ANSWER_OBJ> liAnswer = null;
List <EXAMRESULT_OBJ> liExamresult = null;
EXAMFORM_OBJ objExamform = null;
List <EXAMFORMDETAIL_OBJ> liExamformdetail = null;
List <QUESTIONGROUP_OBJ> liQuestiongroup = null;
int numberQuestion = 0; // số câu hỏi
EXAMHALLSTUDENT_OBJ examhallstudentObj = new EXAMHALLSTUDENT_OBJ();
if (_ses.loginType.Equals("STUDENT"))
{
studentcode = _ses.loginCode;
}
else
{
ret = -1;
}
if (ret >= 0)
{
List <fieldpara> lipa = new List <fieldpara>();
// get mark
MARK_BUS markBus = new MARK_BUS();
lipa.Add(new fieldpara("STUDENTCODE", studentcode, 0));
lipa.Add(new fieldpara("COURSECODE", coursecode, 0));
lipa.Add(new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
var mark = markBus.GetByKey(lipa.ToArray());
markBus.CloseConnection();
if (mark != null)
{
EXAMHALLSTUDENT_BUS bus = new EXAMHALLSTUDENT_BUS();
examhallstudentObj = bus.GetByKey(new fieldpara("MARKCODE", mark.CODE, 0),
new fieldpara("EXAMTIMECODE", examtimecode));
bus.CloseConnection();
if (examhallstudentObj != null)
{
// lấy đề thi
EXAMFORM_BUS busExamform = new EXAMFORM_BUS();
objExamform = busExamform.GetByID((new EXAMFORM_OBJ.BusinessObjectID(examhallstudentObj.EXAMFORMCODE)));
busExamform.CloseConnection();
if (objExamform != null)
{
// lấy danh sách chi tiết đề thi
EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS();
liExamformdetail = busExamformdetail.getAllBy2("THEORDER", new fieldpara("EXAMFORMCODE", objExamform.CODE));
busExamformdetail.CloseConnection();
if (liExamformdetail != null)
{
lipa = new List <fieldpara>();
List <jointable> lijoin = new List <jointable>();
//Lay danh sach cac nhom cau hoi
QUESTIONGROUP_BUS busQuestiongroup = new QUESTIONGROUP_BUS();
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "CODE", "QUESTIONGROUPCODE",
new fieldpara("EXAMFORMCODE", objExamform.CODE)));
liQuestiongroup = busQuestiongroup.getAllBy2("CODE", lipa, lijoin);
busQuestiongroup.CloseConnection();
if (liQuestiongroup != null)
{
//Lay danh sach cau hoi
QUESTION_BUS busQuestion = new QUESTION_BUS();
lijoin.Clear();
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE",
"QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE)));
liQuestion = busQuestion.getAllBy2("CODE", lipa, lijoin);
numberQuestion = liQuestion.Count;
busQuestion.CloseConnection();
// lấy danh sách các câu trả lời
lijoin.Clear();
ANSWER_BUS busAnswer = new ANSWER_BUS();
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE",
"QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE)));
liAnswer = busAnswer.getAllBy2("CODE", lipa, lijoin);
busAnswer.CloseConnection();
// lấy danh sách kết quả thi của sinh vên đó
EXAMRESULT_BUS busExamresult = new EXAMRESULT_BUS();
liExamresult = busExamresult.getAllBy2(new fieldpara("examhallstudentcode",
examhallstudentObj.CODE));
busExamresult.CloseConnection();
if (liAnswer == null || liExamresult == null)
{
ret = -7;
}
}
else
{
ret = -6;
}
}
else
{
ret = -5;
}
}
else
{
ret = -4;
}
}
else
{
ret = -3;
}
}
else
{
ret = -2;
}
}
else
{
ret = -1;
}
var jsonResult = Json(new
{
numberQuestion, //so luong cau hoi
ObjexamHallstudent = examhallstudentObj, //examhallstudent code
ObjexamForm = objExamform, //examform
liExamformDetail = liExamformdetail, //Danh sách examdetail
liQuestiongroup,
li_question = liQuestion,
li_answer = liAnswer,
li_examresult = liExamresult,//danh sách đáp án
ret
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
