public static ClassStudentMap getClassStudentMapByStudent(int student_id)
{
try
{
QE_CLASS classs = GetClassesByStudent(student_id);
STUDENT student = StudentService.GetStudent(student_id);
CLASS_STUDENT_LIST list = getClassStudentListByStudent(student_id);
ClassStudentMap map = new ClassStudentMap(classs, student, list);
return(map);
}
catch (Exception e)
{
return(null);
}
}
public ActionResult _Student(_StudentViewModel SVM)
{
checkLogin();
// fields checking
if (!ModelState.IsValid)
{
return(View("_Student", SVM));
}
//edit or create
bool result = false;
if (SVM.selectedStudent.ID > 0)
{//ediit
SVM.selectedStudent.MODIFY_BY = CP.userID;
SVM.selectedStudent.MODIFY_DATE = DateTime.Now;
result = DBS.updateRecord(SVM.selectedStudent);
}
else
{//create
SVM.selectedStudent.ACTIVE = true;
SVM.selectedStudent.ADD_BY = CP.userID;
SVM.selectedStudent.ADD_DATE = DateTime.Now;
SVM.selectedStudent.ID = DBS.addRecordReturnID(SVM.selectedStudent);
CLASS_STUDENT_LIST newMap = new CLASS_STUDENT_LIST(SVM.selectedClass, SVM.selectedStudent.ID, SVM.selectedStudentNum, CP.userID, DateTime.Now, 0, Constant.DEF_DATETIME, true);
int newMap_id = DBS.addRecordReturnID(newMap); //add new map linking up student and class
if (SVM.selectedStudent.ID > 0 && newMap_id > 0)
{
result = true;
}
}
ModelState.Clear();
if (result)
{
TempData[Constant.msg_success] = Constant.ChangeSucceed;
}
else
{
TempData[Constant.msg_error] = Constant.ChangeFailed;
}
return(_Student(SVM.selectedClass, SVM.selectedStudent.ID, SVM.selectedTerm));
}
public static int CreateClassStudentMap(CLASS_STUDENT_LIST newMap)
{
int newMap_id = 0; newMap_id = WillORM.InsertRecord(newMap); return(newMap_id);
}
