public ActionResult Create(int schoolYear) { try { dbTIREntities db = new dbTIREntities(); StudentExt studentExt = new StudentExt(); ModelServices modelService = new ModelServices(); studentExt.SchoolYear = schoolYear; PopulateViewData(studentExt); studentExt.SchoolYearDesc = HelperService.SchoolYearDescription(db); studentExt.SchoolYearId = modelService.SchoolYearId(); return View(studentExt); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public void PopulateViewData(StudentExt studentExt) { dbTIREntities db = new dbTIREntities(); SiteUser siteUser = ((SiteUser)Session["SiteUser"]); StudentService studentService = new StudentService(siteUser, db); ModelServices modelService = new ModelServices(); studentExt.DistrictId = siteUser.Districts[0].Id; studentExt.DistrictDesc = siteUser.Districts[0].Name; studentExt.StudentClasses = studentExt.StudentId != 0 ? modelService.GetClassesByStudent(studentExt.StudentId, studentExt.SchoolYear) : null; studentExt.SchoolYears = studentExt.StudentId != 0 ? modelService.GetSchoolYearByStudent(studentExt.StudentId) : null; studentExt.DropDown = new DropDownData(); int schoolYearId = modelService.GetSchoolYearId(studentExt.SchoolYear); studentExt.DropDown.School = new SchoolDropDown(modelService.GetSchoolDropDownData(siteUser.EdsUserId, schoolYearId), false); studentExt.DropDown.School.SelectedSchool = studentExt.ServingSchoolId; studentExt.DropDown.Grade = new GradeDropDown(studentService.DropDownDataForGrade()); studentExt.DropDown.Grade.SelectedGrade = (studentExt.GradeLevel != null) ? (int)studentExt.GradeLevel : -1; studentExt.DropDown.Gender = new GenderDropDown(modelService.DropDownDataForGender()); studentExt.DropDown.Gender.SelectedGender = (studentExt.GenderId != null) ? (int)studentExt.GenderId : 1; studentExt.DropDown.Lineage = new LineageDropDown(studentService.DropDownDataForLineage()); studentExt.DropDown.Lineage.SelectedLineage = (studentExt.LineageId != null) ? (int)studentExt.LineageId : -1; studentExt.DropDown.HomeLanguage = new LanguageDropDown(studentService.DropDownDataForLanguage()); studentExt.DropDown.HomeLanguage.SelectedLanguage = (studentExt.HomeLanguageId != null) ? (int)studentExt.HomeLanguageId : -1; studentExt.DropDown.NativeLanguage = new LanguageDropDown(studentService.DropDownDataForLanguage()); studentExt.DropDown.NativeLanguage.SelectedLanguage = (studentExt.NativeLanguageId != null) ? (int)studentExt.NativeLanguageId : -1; studentExt.DropDown.Race = new RaceDropDown(modelService.DropDownDataForRace()); studentExt.DropDown.Race.SelectedRace = (studentExt.RaceId != null) ? (int)studentExt.RaceId : -1; ViewBag.SchoolYear = studentExt.SchoolYear; }
/// <summary> /// This function is used to Add and Update student /// </summary> /// <param name="studentExtend"></param> public void SaveStudents(StudentExt studentExtend) { using (var context = new dbTIREntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { tblStudent newtblStudent = new tblStudent() { FirstName = studentExtend.FirstName, MiddleName = studentExtend.MiddleName, LastName = studentExtend.LastName, DistrictId = studentExtend.DistrictId, StateId = studentExtend.StateId, LocalId = studentExtend.LocalId, LineageId = studentExtend.LineageId == -1 ? null : studentExtend.LineageId, RaceId = studentExtend.RaceId == -1 ? null : studentExtend.RaceId, GenderId = studentExtend.GenderId, BirthDate = studentExtend.BirthDate, HomeLanguageId = studentExtend.HomeLanguageId == -1 ? null : studentExtend.HomeLanguageId, NativeLanguageId = studentExtend.NativeLanguageId == -1 ? null : studentExtend.NativeLanguageId, ChangeDatetime = DateTime.Now }; if (studentExtend.StudentId == 0) { context.tblStudents.Add(newtblStudent); } else { newtblStudent.StudentId = studentExtend.StudentId; context.tblStudents.Add(newtblStudent); context.Entry(newtblStudent).State = EntityState.Modified; } context.SaveChanges(); tblStudentSchoolYear newtblStudentSchoolYear = new tblStudentSchoolYear() { StudentId = newtblStudent.StudentId, SchoolYearId = studentExtend.SchoolYearId, ServingSchoolId = studentExtend.ServingSchoolId, GradeLevel = studentExtend.GradeLevel, StateId = studentExtend.StateId, LocalId = studentExtend.LocalId, LepIndicator = studentExtend.LepIndicator, IepIndicator = studentExtend.IepIndicator, FrlIndicator = studentExtend.FrlIndicator, EnrollmentDate = studentExtend.EnrollmentDate, ChangeDateTIme = DateTime.Now, Hispanic = studentExtend.Hispanic }; if (studentExtend.StudentSchoolYearId == 0) { context.tblStudentSchoolYears.Add(newtblStudentSchoolYear); } else { newtblStudentSchoolYear.StudentSchoolYearId = studentExtend.StudentSchoolYearId; context.tblStudentSchoolYears.Add(newtblStudentSchoolYear); context.Entry(newtblStudentSchoolYear).State = EntityState.Modified; } context.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } } }