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));
}
