public JsonResult CheckCodeViewExitQgroup(string code, string codeView) { int ret; QUESTIONGROUP_BUS bus = new QUESTIONGROUP_BUS(); QUESTIONGROUP_OBJ obj; if (!string.IsNullOrEmpty(code)) { //check for update obj = bus.GetByKey(new fieldpara("CODEVIEW", codeView, 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 GetListQgroup(string subjectcontentcode, string subjectcode, int page, int pageSize) { var ret = -10; //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 QUESTIONGROUP_BUS bus = new QUESTIONGROUP_BUS(); List <fieldpara> lipa = new List <fieldpara> { new fieldpara("SUBJECTCONTENTCODE", subjectcontentcode, 0) }; //here is subjectcontentcode //here is subbjectcode if (!string.IsNullOrEmpty(subjectcode)) { lipa.Add(new fieldpara("SUBJECTCODE", subjectcode, 0)); } // lipa.Add(new fieldpara("LOCK",0,0)); int countpage; //order by theorder, with pagesize and the page var data = bus.getAllBy2("CODEVIEW", pageSize, page, out countpage, lipa.ToArray()); // tất cả các bản ghi List <QUESTIONGROUP_OBJ> totalData = bus.getAllBy2("CODEVIEW", lipa.ToArray()); int totalItem = totalData.Count; if (totalItem > 0) { ret = 1; } 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 datastring = JsonConvert.SerializeObject(data); var jsonResult = Json(new { lst = data, //Danh sách 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> /// get list QuestionGroup by subjectcontentcode /// </summary> /// <param name="subjectContentCode"></param> /// <param name="questiontypecode"></param> /// <returns></returns> public List <QUESTIONGROUP_OBJ> GetQGroupBySbjContent(string subjectContentCode, string questiontypecode) { QUESTIONGROUP_BUS bus = new QUESTIONGROUP_BUS(); var data = bus.getAllBy2("NAME", new fieldpara("SUBJECTCONTENTCODE", subjectContentCode, 0), new fieldpara("QUESTIONTYPECODE", questiontypecode, 0) ); bus.CloseConnection(); return(data); }
/// <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 UpdateQgroup(QUESTIONGROUP_OBJ obj) { QUESTIONTYPE_BUS busQuestiontype = new QUESTIONTYPE_BUS(); QUESTIONTYPE_OBJ objQuestiontype = busQuestiontype.GetByID(new QUESTIONTYPE_OBJ.BusinessObjectID(obj.QUESTIONTYPECODE)); busQuestiontype.CloseConnection(); QUESTIONGROUP_BUS bus = new QUESTIONGROUP_BUS(); int ret = 0; int add = 0; //kiểm tra tồn tại cho trường hợp sửa var objTemp = !string.IsNullOrEmpty(obj.CODE) ? bus.GetByID(new QUESTIONGROUP_OBJ.BusinessObjectID(obj.CODE)) : new QUESTIONGROUP_OBJ(); //Lỗi phần dưới đưa lên if (ret < 0 || objQuestiontype == null) { //đóng kết nối trước khi trả về bus.CloseConnection(); //ban ghi sửa đã bị xóa return(Json(new { sussess = ret }, JsonRequestBehavior.AllowGet)); } //hết kiểm tra tồn tại bản ghi objTemp.EDITTIME = DateTime.Now; //Thời điểm sủa bản ghi objTemp.EDITUSER = _ses.loginCode; //Người sửa bản ghi objTemp.CODEVIEW = obj.CODEVIEW; objTemp.NAME = obj.NAME; objTemp.SUBJECTCODE = obj.SUBJECTCODE; objTemp.SUBJECTCONTENTCODE = obj.SUBJECTCONTENTCODE; objTemp.NOTE = obj.NOTE; objTemp.LOCK = obj.LOCK; objTemp.CONTENT = obj.CONTENT; objTemp.QUESTIONTYPECODE = obj.QUESTIONTYPECODE; objTemp.QUESTIONUSECODELIST = obj.QUESTIONUSECODELIST; objTemp.MARK = obj.MARK; List <string> listSourcePath = _ses.tSOURCEPATHSESSION; List <string> listDestinationPath = _ses.tDESTINATIONPATHSESSION; if (listDestinationPath != null) { for (int i = 0; i < listSourcePath.Count; i++) { if (objTemp.CONTENT.Contains((listSourcePath[i]))) { objTemp.CONTENT = objTemp.CONTENT.Replace(listSourcePath[i], listDestinationPath[i]); } } } QUESTION_BUS busQuestion = new QUESTION_BUS(); QUESTION_OBJ objQuestion = null; ANSWER_BUS busAnswer = new ANSWER_BUS(); ANSWER_OBJ objAnser = null; //Dành cho danh sách các phương pháp sử dụng // obj_temp.THEORDER = obj.THEORDER; //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); objTemp.LOCKDATE = DateTime.Now; //Sinh tự động các bản ghi theo yêu cầu switch (objQuestiontype.CODEVIEW) { case "WR": //Tự động sinh ra câu hỏi objQuestion = new QUESTION_OBJ { QUESTIONGROUPCODE = objTemp.CODE }; objQuestion.CODE = busQuestion.genNextCode(objQuestion); objQuestion.NAME = "Câu hỏi cho:" + objTemp.NAME; objQuestion.MARK = objTemp.MARK; //Tự động sinh ra câu tra lời objAnser = new ANSWER_OBJ(); objAnser.CODE = busAnswer.genNextCode(objAnser); objAnser.QUESTIONCODE = objQuestion.CODE; objAnser.QUESTIONGROUPCODE = objTemp.CODE; objAnser.CODEVIEW = "1"; objAnser.THEORDER = 1; objAnser.NAME = objTemp.NAME; objAnser.CONTENT = ""; objAnser.TRUEANSWER = 1; break; case "LA": objQuestion = new QUESTION_OBJ { QUESTIONGROUPCODE = objTemp.CODE }; objQuestion.CODE = busQuestion.genNextCode(objQuestion); objQuestion.NAME = "Câu hỏi cho:" + objTemp.NAME; objQuestion.MARK = objTemp.MARK; //Tự động sinh ra câu tra lời objAnser = new ANSWER_OBJ(); objAnser.CODE = busAnswer.genNextCode(objAnser); objAnser.QUESTIONCODE = objQuestion.CODE; objAnser.QUESTIONGROUPCODE = objTemp.CODE; objAnser.CODEVIEW = "1"; objAnser.THEORDER = 1; objAnser.NAME = objTemp.NAME; objAnser.CONTENT = ""; objAnser.TRUEANSWER = 1; break; //trường hợp câu hỏi tổng hợp cần sinh ra 3 câu trả lời là true/false/not given, nếu muốn biết được câu trả lời nào là đúng thì cần case "MS": //Tự động sinh ra câu hỏi objQuestion = new QUESTION_OBJ { QUESTIONGROUPCODE = objTemp.CODE }; objQuestion.CODE = busQuestion.genNextCode(objQuestion); objQuestion.NAME = "Câu hỏi cho:" + objTemp.NAME; objQuestion.MARK = objTemp.MARK; break; } } List <QUESTIONGROUPUSE_OBJ> liQuestiongroupuse = new List <QUESTIONGROUPUSE_OBJ>(); QUESTIONGROUPUSE_BUS busQuestiongroupuse = new QUESTIONGROUPUSE_BUS(); string[] listUse = obj.QUESTIONUSECODELIST.Split(','); foreach (var item in listUse) { QUESTIONGROUPUSE_OBJ objQuestiongroupuse = new QUESTIONGROUPUSE_OBJ { LOCK = 0, LOCKDATE = DateTime.Now, QUESITONGROUPCODE = objTemp.CODE, QUESTIONUSECODE = item }; liQuestiongroupuse.Add(objQuestiongroupuse); } bus.BeginTransaction(); busQuestiongroupuse.setConnection(bus); busAnswer.setConnection(bus); busQuestion.setConnection(bus); if (add == 1) { 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); } if (ret >= 0) { // ReSharper disable once PossiblyMistakenUseOfParamsMethod ret = busQuestiongroupuse.Delete(new fieldpara("QUESITONGROUPCODE", objTemp.CODE)); } if (ret >= 0) { ret = busQuestiongroupuse.InsertMultiItems(liQuestiongroupuse); } //Cập nhật câu hỏi nếu nó được sinh tự động if (objQuestion != null && ret >= 0) { ret = busQuestion.Insert(objQuestion); } //Cập nhật answer nếu được sinh tự động if (objAnser != null && ret >= 0) { ret = busAnswer.Insert(objAnser); } if (ret >= 0) { _ses.tSOURCEPATHSESSION?.Clear(); _ses.tDESTINATIONPATHSESSION?.Clear(); bus.CommitTransaction(); } else { bus.RollbackTransaction(); } int pagecount = 0; int currentpage = 0; string questiongroup = JsonConvert.SerializeObject(objTemp); bus.CloseConnection(); //some thing like that return(Json(new { add, ret, questiongroup, pagecount, currentpage, obj = objTemp }, 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); }
/// <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)); }