/// <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);
}
public JsonResult CheckCodeViewExitQuestion(string questiongroup, string code, string codeView)
{
int ret;
QUESTION_BUS bus = new QUESTION_BUS();
QUESTION_OBJ obj;
if (!string.IsNullOrEmpty(code))
{
//check for update
obj = bus.GetByKey(new fieldpara("CODEVIEW", codeView, 0),
new fieldpara("QUESTIONGROUPCODE", questiongroup, 0),
new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
if (obj == null)
{
//change codeview
ret = 1;
}
else
{
//change other feature,not codeview
ret = code == obj.CODE ? 1 : -1;
}
}
else
{
obj = bus.GetByKey(new fieldpara("CODEVIEW", codeView, 0),
new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
ret = obj == null ? 1 : -1;
}
bus.CloseConnection();
return(Json(new { sussess = ret }, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteQuestion(List <string> code)
{
if (code != null)
{
var bus = new QUESTION_BUS();
var busAnswer = new ANSWER_BUS();
foreach (string t in code)
{
var item = bus.GetByID(new QUESTION_OBJ.BusinessObjectID(t));
List <ANSWER_OBJ> lianswer = busAnswer.getAllBy(new fieldpara("QUESTIONCODE", t));
foreach (var itemAnswer in lianswer)
{
busAnswer.delete(itemAnswer._ID);
}
if (t != null)
{
bus.delete(item._ID);
}
}
busAnswer.CloseConnection();
bus.CloseConnection();
}
return(Json(new
{
ret = 0
}, JsonRequestBehavior.AllowGet));
}
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 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);
}
/// <summary>
/// xóa danh sách các answer và question mà trong đó các questiongroup được trả về để GetQuestionxóa,không cần thông báo, nếu có con thì không cho xóa, còn nếu không có thì xóa nó đi,thanks
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public JsonResult DeleteQgroup(List <string> code)
{
int ans = -1;
if (code != null)
{
var bus = new QUESTIONGROUP_BUS();
foreach (string t in code)
{
var ret = 0;
if (t != null)
{
var item = bus.GetByID(new QUESTIONGROUP_OBJ.BusinessObjectID(t));
if (item == null)
{
continue;
}
if (ret >= 0)
{
QUESTION_BUS busQuestion = new QUESTION_BUS();
//check children
ret = busQuestion.checkCode(null, new fieldpara("QUESTIONGROUPCODE", t));
busQuestion.CloseConnection();
//check children
if (ret > 0)
{
ANSWER_BUS busAnswer = new ANSWER_BUS();
ret = busAnswer.checkCode(null, new fieldpara("QUESTIONGROUPCODE", t));
busAnswer.CloseConnection();
}
//exist children
if (ret != 0)
{
ret = -1;
}
}
if (ret == 0)
{
ans = 1;
bus.delete(item._ID);
}
}
}
bus.CloseConnection();
}
return(Json(new
{
ret = ans
}, JsonRequestBehavior.AllowGet));
}
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);
}
public JsonResult UpdateQuestionF(QUESTION_OBJ obj, string questiontypeCodeView, string contentAnswer)
{
QUESTION_BUS bus = new QUESTION_BUS();
int ret;
int add = 0;
ANSWER_BUS busAnswer = new ANSWER_BUS();
ANSWER_OBJ objAnswer = new ANSWER_OBJ();
//kiểm tra tồn tại cho trường hợp sửa
var objTemp = !string.IsNullOrEmpty(obj.CODE) ? bus.GetByID(new QUESTION_OBJ.BusinessObjectID(obj.CODE)) : new QUESTION_OBJ();
//hết kiểm tra tồn tại bản ghi
objTemp.CODEVIEW = obj.CODEVIEW;
objTemp.NAME = obj.NAME;
objTemp.CONTENTIMG = obj.CONTENTIMG;
objTemp.MARK = obj.MARK;
objTemp.ORD = obj.ORD;
objTemp.LOCK = obj.LOCK;
objTemp.CONTENT = obj.CONTENT;
objTemp.QUESTIONGROUPCODE = obj.QUESTIONGROUPCODE;
objTemp.ANSWERCODE = obj.ANSWERCODE;
//Kiểm tra tình trạng sửa hay là thêm mới
if (string.IsNullOrEmpty(obj.CODE))
{
//Thêm mới
add = 1;
//Sinh mã
objTemp.CODE = bus.genNextCode(obj);
objAnswer.CODE = busAnswer.genNextCode(objAnswer);
objTemp.ANSWERCODE = objAnswer.CODE;
}
if (add == 1)
{
ret = bus.insert(objTemp);
//chỉ cần thêm mới chứ không cần cập nhật answer
if (ret >= 0)
{
objAnswer.QUESTIONCODE = objTemp.CODE;
objAnswer.QUESTIONGROUPCODE = obj.QUESTIONGROUPCODE;
objAnswer.CODEVIEW = "1";
objAnswer.THEORDER = 1;
objAnswer.NAME = objTemp.NAME;
objAnswer.CONTENT = contentAnswer;
objAnswer.TRUEANSWER = 1;
ret = busAnswer.insert(objAnswer);
}
}
else
{
//gán _ID để xác định bản ghi sẽ được cập nhật
objTemp._ID.CODE = obj.CODE;
ret = bus.update(objTemp);
}
bus.CloseConnection();
busAnswer.CloseConnection();
return(Json(new
{
code = objTemp.CODE,
ret
},
JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateQuestion(QUESTION_OBJ obj, string typeQuestion)
{
int ret = 0;
int add = 0;
QUESTION_OBJ objTemp;
string codeAnswer = "";
QUESTION_BUS bus = new QUESTION_BUS();
ANSWER_BUS ansbus = new ANSWER_BUS();
if (!string.IsNullOrEmpty(obj.CODE)) //edit
{
objTemp = bus.GetByID(new QUESTION_OBJ.BusinessObjectID(obj.CODE));
if (typeQuestion == "CO")
{
List <ANSWER_OBJ> libegin = ansbus.getAllBy2(" CODE ", new fieldpara("QUESTIONCODE", obj.CODE, 0)
, new fieldpara("QUESTIONGROUPCODE", obj.QUESTIONGROUPCODE, 0));
if (obj.ANSWERCODE != null)
{
foreach (ANSWER_OBJ item in libegin)
{
if (item.CODEVIEW.Split('_')[1] == obj.ANSWERCODE)
{
codeAnswer = item.CODE;
item.TRUEANSWER = 1;
item._ID.CODE = item.CODE;
ret = ansbus.update(item);
}
else
{
item.TRUEANSWER = 0;
item._ID.CODE = item.CODE;
ret = ansbus.update(item);
}
}
}
}
}
else //add
{
objTemp = new QUESTION_OBJ();
}
if (ret < 0)
{
//đóng kết nối trước khi trả về
bus.CloseConnection();
//ban ghi sửa đã bị xóa
return(Json(new { ret }, JsonRequestBehavior.AllowGet));
}
//hết kiểm tra tồn tại bản ghi
objTemp.CODEVIEW = obj.CODEVIEW;
objTemp.NAME = obj.NAME;
objTemp.CONTENTIMG = obj.CONTENTIMG;
objTemp.MARK = obj.MARK;
objTemp.ORD = obj.ORD;
objTemp.LOCK = obj.LOCK;
objTemp.CONTENT = obj.CONTENT;
objTemp.QUESTIONGROUPCODE = obj.QUESTIONGROUPCODE;
//trong trường hợp là câu hỏi dạng CO thì cập nhật lại answercode bằng codeanswer không thì sẽ làm như bình thường objTemp.Answercode= obj.Answercode
objTemp.ANSWERCODE = typeQuestion == "CO" ? codeAnswer : obj.ANSWERCODE;
//Kiểm tra tình trạng sửa hay là thêm mới
if (string.IsNullOrEmpty(obj.CODE))
{
//Thêm mới
add = 1;
//Sinh mã
objTemp.CODE = bus.genNextCode(obj);
if (typeQuestion == "CO")
{
ANSWER_OBJ objAnser = new ANSWER_OBJ();
ANSWER_BUS busAnswer = new ANSWER_BUS();
string answerCode = busAnswer.genNextCode(objAnser);
List <ANSWER_OBJ> listAnswer = new List <ANSWER_OBJ>();
List <string> listContentAnswer = new List <string> {
"TRUE", "FALSE", "NOT GIVEN"
};
//Tự động sinh ra câu hỏi và là 3 đáp án true, false,
//Tự động sinh ra câu tra lời
for (int i = 0; i < listContentAnswer.Count; i++)
{
ANSWER_OBJ answer = new ANSWER_OBJ
{
CODE = answerCode
};
answerCode = busAnswer.GenNextCode(answer, answerCode);
answer.QUESTIONCODE = objTemp.CODE;
answer.QUESTIONGROUPCODE = obj.QUESTIONGROUPCODE;
answer.CODEVIEW = "CO_" + i;
answer.THEORDER = i + 1;
answer.NAME = "CO" + (i + 1);
answer.CONTENT = listContentAnswer[i];
if (int.Parse(obj.ANSWERCODE) == i)
{
objTemp.ANSWERCODE = answerCode;
answer.TRUEANSWER = 1;
}
else
{
answer.TRUEANSWER = 0;
}
listAnswer.Add(answer);
}
busAnswer.BeginTransaction();
ret = busAnswer.InsertMultiItems(listAnswer);
if (ret < 0)
{
busAnswer.RollbackTransaction();
}
else
{
busAnswer.CommitTransaction();
}
busAnswer.CloseConnection();
}
}
if (add == 1 && ret >= 0)
{
ret = bus.insert(objTemp);
}
else
{
//gán _ID để xác định bản ghi sẽ được cập nhật
objTemp._ID.CODE = obj.CODE;
ret = bus.update(objTemp);
}
bus.CloseConnection();
ansbus.CloseConnection();
return(Json(new
{
ret
},
JsonRequestBehavior.AllowGet));
}
/// <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);
}