public JsonResult GetListQuestion(string groupcode, int page, int pageSize)
{
var ret = -1;
//mặc định cho phần trang
if (pageSize == 0)
{
pageSize = AppConfig.item4page();
}
if (page < 1)
{
page = 1;
}
//Khai báo lấy dữ liệu
QUESTION_BUS bus = new QUESTION_BUS();
List <fieldpara> lipa = new List <fieldpara>
{
new fieldpara("QUESTIONGROUPCODE", groupcode, 0)
};
int countpage;
//order by theorder, with pagesize and the page
List <QUESTION_OBJ> data = bus.getAllBy2("CODEVIEW", pageSize, page, out countpage, lipa.ToArray());
// tất cả các bản ghi
List <QUESTION_OBJ> totalData = bus.getAllBy2("CODEVIEW", lipa.ToArray());
int totalItem = totalData.Count;
bus.CloseConnection();
//Chỉ số đầu tiên của trang hiện tại (đã trừ -1)
int startpage = (page - 1) * pageSize;
//Trả về client
var a = JsonConvert.SerializeObject(data);
string firstquestion = "";
if (data.Count != 0)
{
firstquestion = JsonConvert.SerializeObject(data[0]);
}
if (totalItem > 0)
{
ret = 1;
}
var jsonResult = Json(new
{
firstquestion,
data, //Danh sách
data2 = a,
totalItem, //số lượng bản ghi
totalPage = countpage,
startindex = startpage, //bắt đầu số trang
ret //ok
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
/// <summary>
/// Lấy về danh sách và phần tử ở đầu
/// </summary>
/// <param name="groupcode"></param>
/// <returns></returns>
public JsonResult GetQuestion(string groupcode)
{
var ret = 0;
//Khai báo lấy dữ liệu
QUESTION_BUS bus = new QUESTION_BUS();
List <fieldpara> lipa = new List <fieldpara>
{
new fieldpara("QUESTIONGROUPCODE", groupcode, 0)
};
//order by theorder, with pagesize and the page
List <QUESTION_OBJ> data = bus.getAllBy2("CODEVIEW", lipa.ToArray());
QUESTION_OBJ firstquestion = null;
if (data.Count > 0)
{
firstquestion = data[0];
}
bus.CloseConnection();
//Chỉ số đầu tiên của trang hiện tại (đã trừ -1)
var jsonResult = Json(new
{
firstquestion,
data, //Danh sách
ret //ok
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
/// <summary>
/// get list question by questiongroup
/// </summary>
/// <param name="questionGroupCode"></param>
/// <returns></returns>
public List <QUESTION_OBJ> GetListQuesByQuesGroup(string questionGroupCode)
{
QUESTION_BUS bus = new QUESTION_BUS();
var data = bus.getAllBy2("NAME", new fieldpara("QUESTIONGROUPCODE", questionGroupCode, 0));
return(data);
}
/// <summary>
/// lấy chi tiết câu hỏi, câu trả lời theo nhóm câu hỏi
/// </summary>
/// <param name="questiongroupcode">mã nhóm câu hỏi</param>
/// <returns></returns>
public JsonResult GetById(string questiongroupcode)
{
var ret = 0;
var numberQuestion = 0;
List <QUESTION_OBJ> liQuestion = new List <QUESTION_OBJ>();
List <ANSWER_OBJ> liAnswer = new List <ANSWER_OBJ>();
QUESTIONGROUP_BUS bus = new QUESTIONGROUP_BUS();
var obj = bus.GetByID(new QUESTIONGROUP_OBJ.BusinessObjectID(questiongroupcode));
if (obj != null)
{
// lấy danh sách câu hỏi tương ứng
QUESTION_BUS questionBus = new QUESTION_BUS();
liQuestion = questionBus.getAllBy2("CODE",
new fieldpara("QUESTIONGROUPCODE", questiongroupcode, 0));
if (liQuestion != null)
{
// lấy danh sách câu trả lời
ANSWER_BUS answerBus = new ANSWER_BUS();
liAnswer = answerBus.getAllBy2("CODE",
new fieldpara("QUESTIONGROUPCODE", questiongroupcode, 0));
if (liAnswer == null)
{
ret = -3;
}
answerBus.CloseConnection();
}
else
{
ret = -2;
}
if (liQuestion != null)
{
numberQuestion = liQuestion.Count;
}
questionBus.CloseConnection();
}
else
{
ret = -1;
}
bus.CloseConnection();
var jsonResult = Json(new
{
numberQuestion, //so luong cau hoi
ObjexamHallstudent = obj, //examhallstudent code
liQuestiongroup = obj, //danh sach nhom cau hoi
li_question = liQuestion, //danh sach cac cau hoi
li_answer = liAnswer, //danh sach tat ca cac cau tra loi
ret //ok
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public JsonResult ListQuestionExam(string groupcode)
{
QUESTION_BUS bus = new QUESTION_BUS();
List <fieldpara> lipa = new List <fieldpara>
{
new fieldpara("QUESTIONGROUPCODE", groupcode, 0)
};
//order by theorder, with pagesize and the page
List <QUESTION_OBJ> data = bus.getAllBy("CODEVIEW", lipa.ToArray());
// tất cả các bản ghi
List <QUESTION_OBJ> totalData = bus.getAllBy2("CODEVIEW", lipa.ToArray());
int totalItem = totalData.Count;
bus.CloseConnection();
//Chỉ số đầu tiên của trang hiện tại (đã trừ -1)
//Trả về client
var a = JsonConvert.SerializeObject(data);
string firstquestion = "";
if (data.Count != 0)
{
firstquestion = JsonConvert.SerializeObject(data[0]);
}
var jsonResult = Json(new
{
firstquestion,
data, //Danh sách
data2 = a,
totalItem, //số lượng bản ghi
ret = 0 //ok
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
/// <summary>
/// lấy chi tiết 1 đề thi
/// </summary>
/// <param name="examformcode">mã đề thi</param>
/// <returns></returns>
public JsonResult Preview(string examformcode)
{
int ret = 0;
int numberQuestion = 0;
EXAMFORM_BUS busExamform = new EXAMFORM_BUS();
EXAMFORM_OBJ objExamform = busExamform.GetByID((new EXAMFORM_OBJ.BusinessObjectID(examformcode)));
busExamform.CloseConnection();
if (objExamform == null)
{
ret = -2;
}
//Danh sachs cau truc
EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS();
List <EXAMFORMDETAIL_OBJ> liExamformdetail = new List <EXAMFORMDETAIL_OBJ>();
if (ret >= 0)
{
if (objExamform != null)
{
liExamformdetail = busExamformdetail.getAllBy2("THEORDER", new fieldpara("EXAMFORMCODE", objExamform.CODE));
}
busExamformdetail.CloseConnection();
if (liExamformdetail == null)
{
ret = -3;
}
}
List <fieldpara> lipa = new List <fieldpara>();
List <jointable> lijoin = new List <jointable>();
//Lay danh sach cac nhom cau hoi
QUESTIONGROUP_BUS busQuestiongroup = new QUESTIONGROUP_BUS();
List <QUESTIONGROUP_OBJ> liQuestiongroup = new List <QUESTIONGROUP_OBJ>();
if (ret >= 0)
{
if (objExamform != null)
{
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "CODE", "QUESTIONGROUPCODE", new fieldpara("EXAMFORMCODE", objExamform.CODE)));
}
liQuestiongroup = busQuestiongroup.getAllBy2("CODE", lipa, lijoin);
if (liQuestiongroup == null)
{
ret = -4;
}
busQuestiongroup.CloseConnection();
}
//Lay danh sach cau hoi
QUESTION_BUS busQuestion = new QUESTION_BUS();
List <QUESTION_OBJ> listQuestionreturn = new List <QUESTION_OBJ>();
if (ret >= 0)
{
lijoin.Clear();
if (objExamform != null)
{
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE",
new fieldpara("examformcode", objExamform.CODE)));
}
var liQuestion = busQuestion.getAllBy2("CODE", lipa, lijoin);
if (liQuestion == null)
{
ret = -5;
}
else
{
foreach (var objQuestion in liQuestion)
{
QUESTION_OBJ objTemp = new QUESTION_OBJ();
objTemp.CODE = objQuestion.CODE;
objTemp.ANSWERCODE = null;
objTemp.CONTENT = objQuestion.CONTENT;
objTemp.QUESTIONGROUPCODE = objQuestion.QUESTIONGROUPCODE;
objTemp._QUESTIONGROUPCODE = objQuestion._QUESTIONGROUPCODE;
objTemp._ID = objQuestion._ID;
listQuestionreturn.Add(objTemp);
}
numberQuestion = liQuestion.Count;
}
busQuestion.CloseConnection();
}
//Lay danh danh cac dap an
ANSWER_BUS busAnswer = new ANSWER_BUS();
List <ANSWER_OBJ> liAnswer = new List <ANSWER_OBJ>();
if (ret >= 0)
{
lijoin.Clear();
if (objExamform != null)
{
lijoin.Add((new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE",
new fieldpara("examformcode", objExamform.CODE))));
}
liAnswer = busAnswer.getAllBy2("CODE", lipa, lijoin);
if (liAnswer == null)
{
ret = -6;
}
busAnswer.CloseConnection();
}
var jsonResult = Json(new
{
numberQuestion, //so luong cau hoi
ObjexamForm = objExamform, //examform
liExamformDetail = liExamformdetail, //Danh sách examdetail
liQuestiongroup, //danh sach nhom cau hoi
li_question = listQuestionreturn, //danh sach cac cau hoi
li_answer = liAnswer, //danh sach tat ca cac cau tra loi
ret //ok
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
/// <summary>
/// Lấy ra chi tiết của một bài thi dựa vào mã sinh viên trong bảng điểm lớp môn học và mã học kì
/// </summary>
/// <param name="markcode">mã sinh viên trong lớp môn học</param>
/// <param name="examtimecode">mã học kì </param>
/// <returns></returns>
public JsonResult GetDetailExam(string markcode, string examtimecode)
{
if (string.IsNullOrEmpty(markcode))
{
markcode = "1708310001";
}
int ret = 0;
int numberQuestion = 0;
MARK_BUS markbus = new MARK_BUS();
MARK_OBJ objmark = markbus.GetByID(new MARK_OBJ.BusinessObjectID(markcode));//markbus.GetByKey(new fieldpar("STUDENTCODE", _ses.loginCode, 0),new fieldpara("COURSECODE", courseCode, 0));
markbus.CloseConnection();
if (objmark == null)
{
ret = -7;
}
EXAMHALLSTUDENT_OBJ obj = new EXAMHALLSTUDENT_OBJ();
if (ret >= 0)
{
EXAMHALLSTUDENT_BUS bus = new EXAMHALLSTUDENT_BUS();
if (objmark != null)
{
obj = bus.GetByKey(new fieldpara("MARKCODE", objmark.CODE, 0),
new fieldpara("examtimecode", examtimecode));
}
bus.CloseConnection();
}
//Lấy được một lần thi
if (obj == null)
{
ret = -1;
}
EXAMFORM_BUS busExamform = new EXAMFORM_BUS();
EXAMFORM_OBJ objExamform = null;
//Lấy đề thi
if (ret >= 0)
{
if (obj != null)
{
objExamform = busExamform.GetByID((new EXAMFORM_OBJ.BusinessObjectID(obj.EXAMFORMCODE)));
}
busExamform.CloseConnection();
if (objExamform == null)
{
ret = -2;
}
}
//Danh sachs cau truc
EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS();
List <EXAMFORMDETAIL_OBJ> liExamformdetail = new List <EXAMFORMDETAIL_OBJ>();
if (ret >= 0)
{
if (objExamform != null)
{
liExamformdetail = busExamformdetail.getAllBy2("THEORDER", new fieldpara("EXAMFORMCODE", objExamform.CODE));
}
busExamformdetail.CloseConnection();
if (liExamformdetail == null)
{
ret = -3;
}
}
List <fieldpara> lipa = new List <fieldpara>();
List <jointable> lijoin = new List <jointable>();
//Lay danh sach cac nhom cau hoi
QUESTIONGROUP_BUS busQuestiongroup = new QUESTIONGROUP_BUS();
List <QUESTIONGROUP_OBJ> liQuestiongroup = new List <QUESTIONGROUP_OBJ>();
if (ret >= 0)
{
if (objExamform != null)
{
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "CODE", "QUESTIONGROUPCODE", new fieldpara("EXAMFORMCODE", objExamform.CODE)));
}
liQuestiongroup = busQuestiongroup.getAllBy2("CODE", lipa, lijoin);
if (liQuestiongroup == null)
{
ret = -4;
}
busQuestiongroup.CloseConnection();
}
//Lay danh sach cau hoi
QUESTION_BUS busQuestion = new QUESTION_BUS();
List <QUESTION_OBJ> listQuestionreturn = new List <QUESTION_OBJ>();
if (ret >= 0)
{
lijoin.Clear();
if (objExamform != null)
{
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE",
new fieldpara("examformcode", objExamform.CODE)));
}
var liQuestion = busQuestion.getAllBy2("CODE", lipa, lijoin);
if (liQuestion == null)
{
ret = -5;
}
else
{
foreach (var objQuestion in liQuestion)
{
QUESTION_OBJ objTemp = new QUESTION_OBJ();
objTemp.CODE = objQuestion.CODE;
objTemp.ANSWERCODE = null;
objTemp.CONTENT = objQuestion.CONTENT;
objTemp.QUESTIONGROUPCODE = objQuestion.QUESTIONGROUPCODE;
objTemp._QUESTIONGROUPCODE = objQuestion._QUESTIONGROUPCODE;
objTemp._ID = objQuestion._ID;
listQuestionreturn.Add(objTemp);
}
numberQuestion = liQuestion.Count;
}
busQuestion.CloseConnection();
}
//Lay danh danh cac dap an
ANSWER_BUS busAnswer = new ANSWER_BUS();
List <ANSWER_OBJ> liAnswer = new List <ANSWER_OBJ>();
if (ret >= 0)
{
lijoin.Clear();
if (objExamform != null)
{
lijoin.Add((new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE",
new fieldpara("examformcode", objExamform.CODE))));
}
liAnswer = busAnswer.getAllBy2("CODE", lipa, lijoin);
if (liAnswer == null)
{
ret = -6;
}
busAnswer.CloseConnection();
}
//get list exam result in case student lost the internet
EXAMRESULT_BUS busExamresult = new EXAMRESULT_BUS();
List <EXAMRESULT_OBJ> liExamresult = new List <EXAMRESULT_OBJ>();
if (ret >= 0)
{
if (obj != null)
{
liExamresult = busExamresult.getAllBy2(new fieldpara("examhallstudentcode", obj.CODE));
}
busExamresult.CloseConnection();
}
var jsonResult = Json(new
{
numberQuestion, //so luong cau hoi
ObjexamHallstudent = obj, //examhallstudent code
ObjexamForm = objExamform, //examform
liExamformDetail = liExamformdetail, //Danh sách examdetail
liQuestiongroup, //danh sach nhom cau hoi
li_question = listQuestionreturn, //danh sach cac cau hoi
li_answer = liAnswer, //danh sach tat ca cac cau tra loi
liExamresult, //danh sach tat ca cac dap an da tra loi cu sinh vien
ret //ok
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
/// <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);
}
/// <summary>
/// lấy kết quả bài thi dựa trên mark code
/// </summary>
/// <param name="markcode"></param>
/// <returns></returns>
/// show questiongroup
/// show question
/// show answer
/// put data//hide other answer
public JsonResult ShowData(string markcode)
{
var ret = -1;
int numberQuestion = 0;
//dựa vào mã sinh viên thuộc lớp môn học nào sẽ xác định mã sinh bài thi của phòng nào đó cho môn học đó
EXAMHALLSTUDENT_BUS bus = new EXAMHALLSTUDENT_BUS();
EXAMHALLSTUDENT_OBJ obj = bus.GetByKey(new fieldpara("MARKCODE", markcode, 0));
bus.CloseConnection();
//bài kiểm tra
EXAMFORM_BUS busExamform = new EXAMFORM_BUS();
EXAMFORM_OBJ objExamform = null;
if (ret >= 0)
{
objExamform = busExamform.GetByID((new EXAMFORM_OBJ.BusinessObjectID(obj.EXAMFORMCODE)));
busExamform.CloseConnection();
if (objExamform == null)
{
ret = -2;
}
}
//Danh sachs cau truc
EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS();
List <EXAMFORMDETAIL_OBJ> liExamformdetail = new List <EXAMFORMDETAIL_OBJ>();
if (ret >= 0)
{
if (objExamform != null)
{
liExamformdetail = busExamformdetail.getAllBy2("THEORDER", new fieldpara("EXAMFORMCODE", objExamform.CODE));
}
busExamformdetail.CloseConnection();
if (liExamformdetail == null)
{
ret = -3;
}
}
List <fieldpara> lipa = new List <fieldpara>();
List <jointable> lijoin = new List <jointable>();
//Lay danh sach cac nhom cau hoi
QUESTIONGROUP_BUS busQuestiongroup = new QUESTIONGROUP_BUS();
List <QUESTIONGROUP_OBJ> liQuestiongroup = new List <QUESTIONGROUP_OBJ>();
if (ret >= 0)
{
if (objExamform != null)
{
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "CODE", "QUESTIONGROUPCODE", new fieldpara("EXAMFORMCODE", objExamform.CODE)));
}
liQuestiongroup = busQuestiongroup.getAllBy2("CODE", lipa, lijoin);
if (liQuestiongroup == null)
{
ret = -4;
}
busQuestiongroup.CloseConnection();
}
//Lay danh sach cau hoi
QUESTION_BUS busQuestion = new QUESTION_BUS();
List <QUESTION_OBJ> liQuestion = new List <QUESTION_OBJ>();
if (ret >= 0)
{
lijoin.Clear();
if (objExamform != null)
{
lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE",
new fieldpara("examformcode", objExamform.CODE)));
}
liQuestion = busQuestion.getAllBy2("CODE", lipa, lijoin);
if (liQuestion == null)
{
ret = -5;
}
else
{
numberQuestion = liQuestion.Count;
}
busQuestion.CloseConnection();
}
//Lay danh danh cac dap an
ANSWER_BUS busAnswer = new ANSWER_BUS();
List <ANSWER_OBJ> liAnswer = new List <ANSWER_OBJ>();
if (ret >= 0)
{
lijoin.Clear();
if (objExamform != null)
{
lijoin.Add((new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE))));
}
liAnswer = busAnswer.getAllBy2("CODE", lipa, lijoin);
if (liAnswer == null)
{
ret = -6;
}
busAnswer.CloseConnection();
}
var jsonResult = Json(new
{
numberQuestion, //so luong cau hoi
ObjexamHallstudent = obj, //examhallstudent code
ObjexamForm = objExamform, //examform
liExamformDetail = liExamformdetail, //Danh sách examdetail
liQuestiongroup,
li_question = liQuestion,
li_answer = liAnswer,
ret//ok
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public JsonResult UpdateExamResult(List <QuestionAnswer> listobj, EXAMFORM_OBJ examform, List <EXAMFORMDETAIL_OBJ> listexamformdetail, string examhallstudentcode)
{
//bài thi của sinh viên sẽ đưa lên gồm có : mã câu hỏi,mã câu trả lời, nội dung câu trả lời
// examformcode: mã đề thi , examformdetailcode: mã phần thi
// answerfile: link file muốn lưu trên server cho bài thi nói
////list answer, QuestionAnswer {MaCauHoi,MaXTL}
var ret = 0;
int add = 0;
QUESTIONTYPE_BUS busQuestiontype = new QUESTIONTYPE_BUS();
List <QUESTIONTYPE_OBJ> liQuestiontype = busQuestiontype.getAllBy2();
busQuestiontype.CloseConnection();
// list question answer
// List<QuestionAnswer> listStudentAnswer = JsonConvert.DeserializeObject<List<QuestionAnswer>>(listobj);
List <QuestionAnswer> listStudentAnswer = listobj;
if (listStudentAnswer.Count <= 0)
{
ret = -1;
}
//list EXAMFORMDETAIL_OBJ
// List<EXAMFORMDETAIL_OBJ> listEXamDetail = JsonConvert.DeserializeObject<List<EXAMFORMDETAIL_OBJ>>(listexamformdetail);
List <EXAMFORMDETAIL_OBJ> listEXamDetail = listexamformdetail;
if (listEXamDetail.Count <= 0)
{
ret = -2;
}
// list examform
// string exCode = examformcode;
// EXAMFORM_OBJ objExForm = JsonConvert.DeserializeObject<EXAMFORM_OBJ>(exCode);
EXAMFORM_OBJ objExForm = examform;
//examhallstudentcode
string exHallcode = examhallstudentcode;
//object examresult
EXAMRESULT_BUS bus = new EXAMRESULT_BUS();
QUESTION_BUS busQuestion = new QUESTION_BUS();
// QUESTIONGROUP_BUS busQGroup = new QUESTIONGROUP_BUS();
// duyet trong list examformdetail
foreach (var item in listEXamDetail)
{
//lay danh sach question theo tung questiongroup trong examformdetail
List <QUESTION_OBJ> liQuestion = busQuestion.getAllBy2("CODE", new fieldpara("QUESTIONGROUPCODE", item.QUESTIONGROUPCODE));
//duyet trong list question
foreach (var question in liQuestion)
{
//duyet trong danh sach cau tra loi cua sinh vien de dua ra la cau hoi nay la cap nhat hay them moi
foreach (var answer in listStudentAnswer)
{
//kiem tra su ton tai cua cau hoi
if (answer.MaCauHoi == question.CODE)
{
//question group to determinecasse writing
var objTemp = bus.GetByID(new EXAMRESULT_OBJ.BusinessObjectID(exHallcode, item.CODE, question.CODE));
//chua co thi tuc la them moi
if (objTemp == null)
{
add = 1;
objTemp = new EXAMRESULT_OBJ();
}
objTemp.EXAMHALLSTUDENTCODE = exHallcode;
objTemp.EXAMFORMDETAILCODE = item.CODE;
objTemp.EXAMFORMCODE = objExForm.CODE;
objTemp.QUESTIONCODE = question.CODE;
objTemp.QUESTIONGROUPCODE = item.QUESTIONGROUPCODE;
switch (getCodeview(liQuestiontype, item.TESTSTRUCTDETAILCODE)) // thực chất là item._QUESTIONGROUPCODE.QUESTIONTYPECODE nhưng do ko gửi được _QUESTIONGROUPCODE lên, do đó gán tạm TESTSTRUCTDETAILCODE = (item._QUESTIONGROUPCODE.QUESTIONTYPECODE)
{
//multichoice
//1
case "MC": //"1707130001":
objTemp.ANSWERCODE = answer.MaCauTL;
objTemp.ANSWERTEXT = "";
break;
//single choice case
//2
case "MS":
objTemp.ANSWERCODE = answer.MaCauTL;
objTemp.ANSWERTEXT = "";
break;
//case CO, true,false,not given
//3
case "CO":
objTemp.ANSWERCODE = answer.MaCauTL;
objTemp.ANSWERTEXT = "";
break;
//write
//4
case "WR": // "1707130007":
objTemp.ANSWERCODE = "";
objTemp.ANSWERTEXT = answer.MaCauTL;
break;
//rewrite
//5
case "RW": // "1707130004":
objTemp.ANSWERCODE = "";
objTemp.ANSWERTEXT = answer.MaCauTL;
break;
//NGHE NOI
//6
case "LA": // "1708300007": //LA
objTemp.ANSWERFILE = GetName(answer.MaCauTL);
break;
//trường hợp điền từ vào ô trống
//7
case "FG":
objTemp.ANSWERCODE = "";
objTemp.ANSWERTEXT = answer.MaCauTL;
break;
//TRUONG HOP KEO THA VAO O TRONG
//8
case "FI":
objTemp.ANSWERCODE = answer.MaCauTL;
objTemp.ANSWERTEXT = "";
break;
// Keo tha vao o trong
//9
case "FF":
objTemp.ANSWERCODE = answer.MaCauTL;
objTemp.ANSWERTEXT = "";
break;
//cau hoi ghep doi
//10
case "PA":
objTemp.ANSWERCODE = answer.MaCauTL;
objTemp.ANSWERTEXT = "";
break;
//dạng câu hỏi sắp xếp lại câu
//11
case "RA":
objTemp.ANSWERTEXT = answer.MaCauTL;
objTemp.ANSWERCODE = "";
break;
default:
objTemp.ANSWERCODE = "";
objTemp.ANSWERTEXT = "";
break;
}
objTemp.LOCK = objExForm.LOCK;
objTemp.LOCKDATE = DateTime.Now;
objTemp.MARK = 0;
if (add > 0)
{
ret = bus.insert(objTemp);
}
else
{
objTemp._ID.QUESTIONCODE = question.CODE;
objTemp._ID.EXAMFORMDETAILCODE = item.CODE;
objTemp._ID.EXAMHALLSTUDENTCODE = exHallcode;
ret = bus.update(objTemp);
}
}
}
}
}
if (ret >= 0)
{
_ses.tSOURCEPATHSESSION?.Clear();
_ses.tDESTINATIONPATHSESSION?.Clear();
}
return(Json(new
{
ret
}, JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="subjectcode"></param>
/// <param name="parentcode"></param>
/// <param name="code"></param>
/// <param name="codetype"></param>
/// <param name="name"></param>
/// <param name="nametype"></param>
/// <param name="note"></param>
/// <param name="notetype"></param>
/// <returns></returns>
public JsonResult GetAllSearch(int page, int pageSize, string subjectcode, string parentcode, string code, bool codetype, string name, bool nametype,
string note, bool notetype)
{
var ret = 0;
//mặc định cho phần trang
if (pageSize == 0)
{
pageSize = AppConfig.item4page();
}
if (page < 1)
{
page = 1;
}
//Khai báo lấy dữ liệu
SUBJECTCONTENT_BUS bus = new SUBJECTCONTENT_BUS();
List <fieldpara> lipa = new List <fieldpara>
{
new fieldpara("SUBJECTCODE", subjectcode, 0),
new fieldpara("PARENTCODE", parentcode, 0)
};
if (!string.IsNullOrEmpty(code))
{
lipa.Add(codetype ? new fieldpara("CODEVIEW", code, 0) : new fieldpara("CODEVIEW", code, 1));
}
if (!string.IsNullOrEmpty(name))
{
lipa.Add(nametype ? new fieldpara("NAME", name, 0) : new fieldpara("NAME", name, 1));
}
if (!string.IsNullOrEmpty(note))
{
lipa.Add(notetype ? new fieldpara("NOTE", note, 0) : new fieldpara("NOTE", note, 1));
}
lipa.Add(new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
// lipa.Add(new fieldpara("LOCK", 0, 0));
int countpage;
int totalItem;
//order by theorder, with pagesize and the page
var data = bus.getAllBy2("THEORDER", pageSize, page, out countpage, out totalItem, lipa);
ret = data == null ? -1 : 0;
//Trả về cho client
var groupquestion = "";
var question = "";
int startpage = 0; // //Chỉ số đầu tiên của trang hiện tại (đã trừ -1)
if (ret >= 0)
{
foreach (var item in data)
{
item.NOTE = "";
}
//Chỉ số đầu tiên của trang hiện tại (đã trừ -1)
startpage = (page - 1) * pageSize;
//get first questiongroup
// string codefistSubcon = data.Count != 0 ? data[0].CODE : "";
//Chỉ số đầu tiên của trang hiện tại (đã trừ -1)
if (data.Count != 0)
{
QUESTIONGROUP_BUS busgroup = new QUESTIONGROUP_BUS();
List <QUESTIONGROUP_OBJ> li = busgroup.getAllBy2("CODEVIEW",
new fieldpara("SUBJECTCODE", subjectcode, 0),
new fieldpara("SUBJECTCONTENTCODE", data[0].CODE, 0));
if (li.Count > 0)
{
groupquestion = li.Count != 0 ? JsonConvert.SerializeObject(li[0]) : "";
}
if (li.Count != 0)
{
QUESTION_BUS busquestion = new QUESTION_BUS();
List <QUESTION_OBJ> liquestion = busquestion.getAllBy2("CODEVIEW",
new fieldpara("QUESTIONGROUPCODE", li[0].CODE, 0));
if (liquestion.Count > 0)
{
question = liquestion.Count != 0 ? JsonConvert.SerializeObject(liquestion[0]) : "";
}
}
}
}
bus.CloseConnection();
return(Json(new
{
question,
groupquestion,
data, //Danh sách
lst = data,
totalItem, //số lượng bản ghi
totalPage = countpage,
startindex = startpage, //bắt đầu số trang
ret = ret //ok
}, JsonRequestBehavior.AllowGet));
}