public int UpdateStudentAmount(string coursecode)
{
var ret = 0;
COURSE_BUS bus = new COURSE_BUS();
var course = bus.GetByID(new COURSE_OBJ.BusinessObjectID(coursecode));
if (course == null)
{
ret = -1;
bus.CloseConnection();
return(ret);
}
// tính số sinh viên của lớp học
MARK_BUS markBus = new MARK_BUS();
var liMark = markBus.getAllBy2("CODE", new fieldpara("COURSECODE", coursecode, 0),
new fieldpara("UNiVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
if (liMark != null)
{
course.STUDENTAMOUNT = liMark.Count;
ret = bus.Update(course);
}
markBus.CloseConnection();
bus.CloseConnection();
return(ret);
}
/// <summary>
/// get danh sách tất cả các sinh viên, trừ các sinh viên đã được thêm vào lớp học
/// </summary>
/// <param name="coursecode">mã lớp học</param>
/// <param name="classcode">mã lớp</param>
/// <returns></returns>
public JsonResult GetAllStudent(string coursecode, string classcode)
{
// danh sách mã sinh viên đã tham gia vào course
List <string> listStudentCode = new List <string>();
MARK_BUS bus = new MARK_BUS();
List <fieldpara> lipa = new List <fieldpara>();
if (!string.IsNullOrEmpty(coursecode))
{
lipa.Add(new fieldpara("COURSECODE", coursecode, 0));
}
lipa.Add(new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
lipa.Add(new fieldpara("EDUCATIONLEVELCODE", "DH", 0));
List <MARK_OBJ> liStudentCourse = bus.getAllBy2("STUDENTCODE", lipa.ToArray());
foreach (var studentcourse in liStudentCourse)
{
listStudentCode.Add(studentcourse.STUDENTCODE);
}
// danh sách tất cả các sinh viên
STUDENT_BUS busStudent = new STUDENT_BUS();
var liStudent = busStudent.getAllBy2("CODE", new fieldpara("CLASSCODE", classcode, 0),
new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0),
new fieldpara("EDUCATIONLEVELCODE", "DH", 0));
var count = 0;
if (listStudentCode.Count > 0)
{
for (int i = 0; i < liStudent.Count; i++)
{
if (listStudentCode.Contains(liStudent[i].CODE))
{
liStudent.RemoveAt(i);
i--;
}
}
}
var data = JsonConvert.SerializeObject(liStudent);
busStudent.CloseConnection();
bus.CloseConnection();
return(Json(new
{
data,//Danh sách
count
}, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// lấy danh sách sinh viên của lớp môn học, chưa được thêm vào đợt thi
/// </summary>
/// <param name="examtimeCode">mã đợt thi</param>
/// <param name="courseCode">mã lớp môn học</param>
/// <returns></returns>
public JsonResult GetAllStudent(string examtimeCode, string courseCode)
{
var ret = 0;
MARK_BUS markBus = new MARK_BUS();
//lấy toàn bộ danh sách sinh viên trong một lớp môn học
var liMark = markBus.getAllBy2(new fieldpara("COURSECODE", courseCode, 0),
new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
markBus.CloseConnection();
EXAMHALLSTUDENT_BUS examBus = new EXAMHALLSTUDENT_BUS();
var liExamHallStudent = examBus.getAllBy2(new fieldpara("EXAMTIMECODE", examtimeCode, 0),
new fieldpara("COURSECODE", courseCode, 0),
new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
if (liMark == null && liExamHallStudent == null)
ret = -1;
else
{
foreach (var examHallStudent in liExamHallStudent)
{
for (int i = 0; i < liMark.Count; i++)
{
var mark = liMark[i];
if (mark.CODE == examHallStudent.MARKCODE && mark.COURSECODE == examHallStudent.COURSECODE)
{
liMark.Remove(mark);
break;
}
}
}
}
List<STUDENT_OBJ> liStudent = new List<STUDENT_OBJ>();
if (liMark != null && liMark.Count > 0)
{
foreach (var mark in liMark)
{
liStudent.Add(mark._STUDENTCODE);
}
}
return Json(new { data = liStudent, ret = ret }, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// get danh sách các course của 1 sinh viên
/// </summary>
/// <returns></returns>
public JsonResult GetByStudent()
{
var ret = 1;
string studentcode = "";
if (_ses.loginType.Equals("STUDENT"))
{
studentcode = _ses.loginCode;
}
else
{
ret = -1;
}
List <COURSE_OBJ> liCourse = null;
if (ret >= 0)
{
MARK_BUS bus = new MARK_BUS();
liCourse = new List <COURSE_OBJ>();
List <fieldpara> lipa = new List <fieldpara>();
if (!string.IsNullOrEmpty(studentcode))
{
lipa.Add(new fieldpara("STUDENTCODE", studentcode, 0));
}
lipa.Add(new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0));
var liMark = bus.getAllBy2("CODE", lipa.ToArray());
if (liMark != null)
{
foreach (var mark in liMark)
{
liCourse.Add(mark._COURSECODE);
}
}
bus.CloseConnection();
}
return(Json(new { data = liCourse, ret }, JsonRequestBehavior.AllowGet));
}
public int ProcessExamFormAuto(string examtimecode, string coursecode, int testcount)
{
int ret = 0;
//Lấy được đợt thi
EXAMTIME_BUS bus = new EXAMTIME_BUS();
EXAMTIME_OBJ obj = bus.GetByID(new EXAMTIME_OBJ.BusinessObjectID(examtimecode));
EXAMFORM_BUS busExamfom = new EXAMFORM_BUS();
List <EXAMFORM_OBJ> liExamform = new List <EXAMFORM_OBJ>();
bus.CloseConnection();
if (obj == null)
{
ret = -1;
}
//Lấy được lớp học
MARK_BUS busMark = new MARK_BUS();
List <MARK_OBJ> liMark = busMark.getAllBy2(new fieldpara("COURSECODE", coursecode));
busMark.CloseConnection();
if (ret >= 0)
{
liExamform = CreateExamForm(obj, testcount, out ret);
}
EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS();
EXAMFORMDETAIL_OBJ objExamformdetail = new EXAMFORMDETAIL_OBJ();
List <EXAMFORMDETAIL_OBJ> liExamformdetail = new List <EXAMFORMDETAIL_OBJ>();
//Danh sách cấu trúc đề
TESTSTRUCTDETAIL_BUS busTeststructdetail = new TESTSTRUCTDETAIL_BUS();
List <TESTSTRUCTDETAIL_OBJ> liTestStructDetail = busTeststructdetail.getByTestStruct(obj.TESTSTRUCTCODE, _ses.gUNIVERSITYCODE);
busTeststructdetail.CloseConnection();
string currentCode = busExamformdetail.genNextCode(objExamformdetail);
if (ret >= 0)
{
foreach (EXAMFORM_OBJ objtem in liExamform)
{
ret = CreateExamFormDetail(ref liExamformdetail, objtem, liTestStructDetail, ref currentCode);
if (ret < 0)
{
break;
}
}
}
//Gán sinh viên vào danh sách đề
List <EXAMHALLSTUDENT_OBJ> liExamhallstudent = new List <EXAMHALLSTUDENT_OBJ>();
EXAMHALLSTUDENT_BUS busExamhallstudent = new EXAMHALLSTUDENT_BUS();
EXAMHALLSTUDENT_OBJ objExamhallstudent = new EXAMHALLSTUDENT_OBJ();
currentCode = busExamhallstudent.genNextCode(objExamhallstudent);
int i = 0;
//Thêm tất cả sinh viên
foreach (MARK_OBJ objMar in liMark)
{
//Gán sinh viên vào examhall student
objExamhallstudent = new EXAMHALLSTUDENT_OBJ();
objExamhallstudent.CODE = currentCode;
currentCode = busExamhallstudent.genNextCode(objExamhallstudent, currentCode);
objExamhallstudent.COURSECODE = coursecode;
objExamhallstudent.EDITTIME = DateTime.Now;
objExamhallstudent.EDITUSER = _ses.loginCode;
objExamhallstudent.EXAMFORMCODE = liExamform[i % testcount].CODE;
objExamhallstudent.EXAMTIMECODE = examtimecode;
i++;
objExamhallstudent.EXAMHALLCODE = "";
objExamhallstudent.MARKCODE = objMar.CODE;
objExamhallstudent.UNIVERSITYCODE = _ses.gUNIVERSITYCODE;
liExamhallstudent.Add(objExamhallstudent);
}
if (ret >= 0)
{
busExamfom.BeginTransaction();
busExamformdetail.setConnection(busExamfom);
busExamhallstudent.setConnection(busExamfom);
ret = busExamfom.InsertMultiItems(liExamform);
if (ret >= 0)
{
ret = busExamformdetail.InsertMultiItems(liExamformdetail);
}
if (ret >= 0)
{
ret = busExamhallstudent.InsertMultiItems(liExamhallstudent);
}
if (ret >= 0)
{
busExamfom.CommitTransaction();
}
else
{
busExamfom.RollbackTransaction();
}
}
busExamfom.CloseConnection();
return(ret);
}
