public int AddEdit(StudentsClass entity) { int i = 0; User objUser = null; if (eSchoolSession.IsInSession(SessionKeys.CurrentUser)) objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser); if (entity != null && string.IsNullOrEmpty(entity.SchoolID)) { if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID)) entity.SchoolID = objUser.SchoolID; } if (string.IsNullOrEmpty(entity.StudentClassID)) { entity.StudentClassID = Utility.GeneratorUniqueId(ID_PREFIX_CONSTANTS.STUDENTS_CLASS_ID_PREFIX); if (objUser != null && !string.IsNullOrEmpty(objUser.UserID)) { entity.CreatedByID = objUser.UserID; entity.ModifiedByID = objUser.UserID; } else { entity.CreatedByID = "1"; entity.ModifiedByID = "1"; } } else { if (objUser != null && !string.IsNullOrEmpty(objUser.UserID)) entity.ModifiedByID = objUser.UserID; else entity.ModifiedByID = "1"; } string[] addParams = { StudentsClass_Constant.STUDENT_CLASS_ID, StudentsClass_Constant.SCHOOL_ID, StudentsClass_Constant.STUDENT_ID, StudentsClass_Constant.ACADEMIC_YEAR_ID, StudentsClass_Constant.CLASS_ID, StudentsClass_Constant.SECTION_ID, StudentsClass_Constant.BATCH_ID, StudentsClass_Constant.ROLL_NO, StudentsClass_Constant.IS_CURRENT_CLASS, StudentsClass_Constant.CREATED_BY_ID, StudentsClass_Constant.MODIFIED_BY_ID }; i = _StudentsClassRepository.ExecuteNonQuery(entity, addParams, StudentsClass_Constant.SPROC_STUDENTSCLASS_UPS); return i; }
public StudentsClass Get(StudentsClass entity) { string[] addParams = { StudentsClass_Constant.STUDENT_CLASS_ID }; return _StudentsClassRepository.Get(entity, addParams, StudentsClass_Constant.SPROC_STUDENTSCLASS_SEL); }
public int Delete(StudentsClass entity) { int i = 0; string[] addParams = { StudentsClass_Constant.STUDENT_CLASS_ID }; i = _StudentsClassRepository.ExecuteNonQuery(entity, addParams, StudentsClass_Constant.SPROC_STUDENTSCLASS_DEL); return i; }
public int UpdateCurrentClassRollNo(StudentsClass entity) { int i = 0; User objUser = null; if (eSchoolSession.IsInSession(SessionKeys.CurrentUser)) objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser); if (entity != null && string.IsNullOrEmpty(entity.SchoolID)) { if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID)) entity.SchoolID = objUser.SchoolID; if (objUser != null && !string.IsNullOrEmpty(objUser.UserID)) entity.ModifiedByID = objUser.UserID; else entity.ModifiedByID = "1"; } string[] addParams = { StudentsClass_Constant.SCHOOL_ID, StudentsClass_Constant.STUDENT_ID, StudentsClass_Constant.ACADEMIC_YEAR_ID, StudentsClass_Constant.CLASS_ID, StudentsClass_Constant.SECTION_ID, StudentsClass_Constant.BATCH_ID, StudentsClass_Constant.ROLL_NO, StudentsClass_Constant.MODIFIED_BY_ID}; i = _StudentsClassRepository.ExecuteNonQuery(entity, addParams, StudentsClass_Constant.SPROC_STUDENTSCLASS_UPS_CURRENT_CLASS_ROLLNO); return i; }
public int SetAllCurrentClassFalse(StudentsClass entity) { int i = 0; string[] addParams = { Student_Constant.STUDENT_ID}; i = _StudentsClassRepository.ExecuteNonQuery(entity, addParams, StudentsClass_Constant.SPROC_STUDENTSCLASS_UPS_SET_ALL_CURRENT_CLASS_FALSE); return i; }
public object GetScalar(StudentsClass entity) { throw new NotImplementedException(); }
public IEnumerable<StudentsClass> GetAll(StudentsClass entity) { User objUser = null; if (eSchoolSession.IsInSession(SessionKeys.CurrentUser)) objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser); if (objUser != null && !string.IsNullOrEmpty(objUser.SchoolID)) entity.SchoolID = objUser.SchoolID; string[] addParams = { Constants.PAGEINDEX, Constants.PAGESIZE, Constants.SORTEXP, StudentsClass_Constant.SCHOOL_ID, StudentsClass_Constant.STUDENT_ID}; return _StudentsClassRepository.GetAll(entity, addParams, StudentsClass_Constant.SPROC_STUDENTSCLASS_LSTALL); }
public ActionResult AssignRollNo(StudentsListViewModel model, string submit) { FillAllDropdownsForClassAssignment(); if (submit == StudentsClassRes.Save) { if (model.StudentList != null && model.StudentList.Count > 0) { foreach (Student objStudent in model.StudentList) { if (objStudent.CurrentRollNo != 0) { Student objGetStudent = new Student(); objGetStudent.StudentID = objStudent.StudentID; objGetStudent = _StudentService.Get(objGetStudent); if (objGetStudent != null && !string.IsNullOrEmpty(objGetStudent.FirstName)) { objStudent.CurrentAcademicYearID = objGetStudent.CurrentAcademicYearID; objStudent.CurrentClassID = objGetStudent.CurrentClassID; objStudent.CurrentSectionID = objGetStudent.CurrentSectionID; objStudent.CurrentBatchID = objGetStudent.CurrentBatchID; _StudentService.UpdateStudentsClassRollNo(objStudent); StudentsClass obj = new StudentsClass(); obj.StudentID = objStudent.StudentID; ; obj.AcademicYearID = objGetStudent.CurrentAcademicYearID; obj.ClassID = objGetStudent.CurrentClassID; obj.SectionID = objGetStudent.CurrentSectionID; obj.BatchID = objGetStudent.CurrentBatchID; obj.RollNo = objGetStudent.CurrentRollNo; _StudentsClassService.UpdateCurrentClassRollNo(obj); } } } } } if (model.Student == null) model.Student = new Student(); if (model.StudentsClass == null) model.StudentsClass = new StudentsClass(); model.StudentList = new List<Student>(); model.StudentList = _StudentService.GetAllStudentForClassAssignment(model.Student).ToList(); return View(model); }
public ActionResult AssignStudentToClass(StudentsListViewModel model, string submit, string[] ids) { FillAllDropdownsForClassAssignment(); if (submit == StudentsClassRes.Save) { if (model.StudentsClass.IsCurrentClass) { foreach (string strStudentID in ids) { StudentsClass obj = new StudentsClass(); obj.StudentID = strStudentID; obj.AcademicYearID = model.StudentsClass.AcademicYearID; obj.ClassID = model.StudentsClass.ClassID; obj.SectionID = model.StudentsClass.SectionID; obj.BatchID = model.StudentsClass.BatchID; obj.IsCurrentClass = model.StudentsClass.IsCurrentClass; _StudentsClassService.SetAllCurrentClassFalse(obj); _StudentsClassService.AddEdit(obj); Student objStudent = new Student(); objStudent.StudentID = strStudentID; objStudent.CurrentAcademicYearID = model.StudentsClass.AcademicYearID; objStudent.CurrentClassID = model.StudentsClass.ClassID; objStudent.CurrentSectionID = model.StudentsClass.SectionID; objStudent.CurrentBatchID = model.StudentsClass.BatchID; _StudentService.UpdateStudentsClassRollNo(objStudent); } } } if (model.Student == null) model.Student = new Student(); if (model.StudentsClass == null) model.StudentsClass = new StudentsClass(); model.StudentList = new List<Student>(); model.StudentList = _StudentService.GetAllStudentForClassAssignment(model.Student).ToList(); return View(model); }