public int Create(SubjectDetails subjectDetails) { IMapper mapper = GetMapperForEntity(); var subject = mapper.Map <Subject>(subjectDetails); return(SubjectRepository.Insert(subject)); }
public IActionResult ShowSubjectInfo(int subjectId) { var subject = _context.Subject.Include("SubjectProfessor").Include("SubjectProfessor.IdProfessorNavigation").SingleOrDefault(x => x.IdSubject == subjectId); var subjectDetails = new SubjectDetails { Subject = subject, CanFollow = HttpContext.User != null && HttpContext.User.Identity.IsAuthenticated, IsFollowed = IsFollow(subject.IdSubject) }; return(PartialView("_SubjectDetails", subjectDetails)); }
public ActionResult ExamMarks(int class_id = 0, int subject_id = 0) { int school_id = SessionHandler.GetSchoolID(); var exam_types = _ed.GetAll(school_id).ToList(); if (school_id != 0 && class_id != 0 && subject_id != 0) { var rests = _ed.FindOnCondition(school_id,class_id, subject_id); if (rests.ToList().Count == 0 || exam_types.Count != rests.ToList().Count) { foreach (var exam in exam_types) { if (rests.ToList().Count == 0) { _ed.InsertSubjectExam(school_id, subject_id, exam.exam_id, class_id, 1); } else { foreach (var se in rests) { if (se.exam_id == exam.exam_id && se.subject_id == subject_id && class_id == se.class_id) continue; _ed.InsertSubjectExam(school_id, subject_id, exam.exam_id, class_id, 1); } } } } ViewBag.class_id = class_id; ViewBag.subject_id = subject_id; SubjectDetails sbs = new SubjectDetails(); ClassDetails clss = new ClassDetails(); ViewBag.subjects = sbs.GetAll(school_id).ToList().ToJSON(); ViewBag.classes = clss.GetAll(school_id); var rest = _ed.FindOnCondition(school_id, class_id, subject_id); return View(rest); } else { SubjectDetails sbs = new SubjectDetails(); ClassDetails clss = new ClassDetails(); ViewBag.subjects = sbs.GetAll(school_id).ToList().ToJSON(); ViewBag.classes = clss.GetAll(school_id); return View(); } }
public IHttpActionResult PostSubject(SubjectDetails subjectDetails) { IHttpActionResult result; if (ModelState.IsValid) { int subjectId = SubjectService.Create(subjectDetails); result = Ok(subjectId); } else { result = BadRequest(ModelState); } return(result); }
/// <summary> /// 获取并转换为<see cref="SubjectDetails"/>类型数据对象 /// </summary> /// <returns></returns> public SubjectDetails ConvertToSubjectDetails() { if (Subject == null) { return(null); } var details = new SubjectDetails { Count = _subject.Count, Courses = Courses, CreateTime = _subject.CreateTime, Name = _subject.Name, Status = _subject.Status, SubjectId = _subject.SubjectId }; return(details); }
public SubjectDetails RetrieveSubjectDetail(SubjectDetailRequest sdData) { string stProc = FetchAllSubjectDetailByANM; string stProc1 = FetchSubjectANMPrePC; string stProc2 = FetchSubjectANMPNDTesting; string stProc3 = FetchSubjectANMPostPC; string stProc4 = FetchANMMTPService; var pList = new List <SqlParameter>() { new SqlParameter("@UserId", sdData.userId), new SqlParameter("@FromDate", sdData.fromDate.ToCheckNull()), new SqlParameter("@ToDate", sdData.toDate.ToCheckNull()) }; var allPrimaryData = UtilityDL.FillData <SubjectPrimaryDetail>(stProc, pList); var allAddressData = UtilityDL.FillData <SubjectAddresDetail>(stProc, pList); var allPregnancyData = UtilityDL.FillData <SubjectPregnancyDetail>(stProc, pList); var allParentData = UtilityDL.FillData <SubjectParentDetail>(stProc, pList); var pList1 = new List <SqlParameter>() { new SqlParameter("@UserId", sdData.userId), }; var allPrPC = UtilityDL.FillData <SubjectPrePNDTCounselling>(stProc1, pList1); var allPNDTTest = UtilityDL.FillData <SubjectPNDTTesting>(stProc2, pList1); var allPoPC = UtilityDL.FillData <SubjectPostPNDTCounselling>(stProc3, pList1); var allMTP = UtilityDL.FillData <SubjectMTPService>(stProc4, pList1); var subDetail = new SubjectDetails(); subDetail.PrimarySubjectList = allPrimaryData; subDetail.AddressSubjectList = allAddressData; subDetail.PregnancySubjectList = allPregnancyData; subDetail.ParentSubjectList = allParentData; subDetail.prePndtCounselling = allPrPC; subDetail.pndtTesting = allPNDTTest; subDetail.postPndtCounselling = allPoPC; subDetail.mtpService = allMTP; return(subDetail); }
public SubjectDetails RetrieveParticularCHCSubjectDetail(SubjectsDetailRequest sdData) { string stProc = FetchCHCParticularSubjectDetail; string stProc1 = FetchSubjectCHCPrePC; string stProc2 = FetchSubjectCHCPNDTesting; string stProc3 = FetchSubjectCHCPostPC; string stProc4 = FetchCHCMTPService; var pList = new List <SqlParameter>() { new SqlParameter("@UserId", sdData.userId), new SqlParameter("@UniqueSubjectID", sdData.userInput ?? sdData.userInput), }; var allPrimaryData = UtilityDL.FillData <SubjectPrimaryDetail>(stProc, pList); var allAddressData = UtilityDL.FillData <SubjectAddresDetail>(stProc, pList); var allPregnancyData = UtilityDL.FillData <SubjectPregnancyDetail>(stProc, pList); var allParentData = UtilityDL.FillData <SubjectParentDetail>(stProc, pList); var pList1 = new List <SqlParameter>() { new SqlParameter("@UserId", sdData.userId), }; var allPrPC = UtilityDL.FillData <SubjectPrePNDTCounselling>(stProc1, pList1); var allPNDTTest = UtilityDL.FillData <SubjectPNDTTesting>(stProc2, pList1); var allPoPC = UtilityDL.FillData <SubjectPostPNDTCounselling>(stProc3, pList1); var allMTP = UtilityDL.FillData <SubjectMTPService>(stProc4, pList1); var subDetail = new SubjectDetails(); subDetail.PrimarySubjectList = allPrimaryData; subDetail.AddressSubjectList = allAddressData; subDetail.PregnancySubjectList = allPregnancyData; subDetail.ParentSubjectList = allParentData; subDetail.prePndtCounselling = allPrPC; subDetail.pndtTesting = allPNDTTest; subDetail.postPndtCounselling = allPoPC; subDetail.mtpService = allMTP; return(subDetail); }
public ActionResult StudentMarks(int class_id = 0, int subject_id = 0, int exam_id = 0) { int school_id = SessionHandler.GetSchoolID(); int user_id = SessionHandler.GetUserID(); SubjectDetails sbs = new SubjectDetails(); ClassDetails clss = new ClassDetails(); ViewBag.subjects = sbs.GetAll(school_id).ToList().ToJSON(); ViewBag.classes = clss.GetAll(school_id); ViewBag.exams = _ed.GetAll(school_id).ToList(); if (school_id != 0 && class_id != 0 && subject_id != 0 && exam_id != 0) { StudentDetails stds = new StudentDetails(); var stnds_result = stds.GetAll(school_id, class_id).ToList(); var rests = _ed.FindMarksOnCondition(school_id, class_id, subject_id, exam_id); if (rests.ToList().Count == 0 || stnds_result.Count != rests.ToList().Count) { foreach (var std in stnds_result) { if (rests.ToList().Count == 0) { _ed.InsertSubjectMarks(school_id, subject_id, exam_id, class_id, std.user_id, user_id); } else { bool isExisted = false; foreach (var se in rests) { if (se.exam_id == exam_id && se.subject_id == subject_id && class_id == se.class_id && se.student_id == std.user_id) isExisted = true; } if (!isExisted) { _ed.InsertSubjectMarks(school_id, subject_id, exam_id, class_id, std.user_id, user_id); } } } } ViewBag.class_id = class_id; ViewBag.subject_id = subject_id; var rest = _ed.FindMarksOnCondition(school_id, class_id, subject_id, exam_id); return View(rest); } return View(); }
public ActionResult Report() { { string dashboardOutput = StudentWeb.GetStudentDetails(Convert.ToInt32(Session["UserId"].ToString())); JObject _StudentDashboardParsing = JObject.Parse(dashboardOutput); StudentGeneralDetails _studentDetails = new StudentGeneralDetails(); _studentDetails.BoardName = (String)_StudentDashboardParsing["Table"][0]["BoardName"]; _studentDetails.CityName = (String)_StudentDashboardParsing["Table"][0]["CityName"]; _studentDetails.ClassName = (String)_StudentDashboardParsing["Table"][0]["ClassName"]; _studentDetails.DistrictName = (String)_StudentDashboardParsing["Table"][0]["DistrictName"]; _studentDetails.EmailAddress = (String)_StudentDashboardParsing["Table"][0]["EmailAddress"]; _studentDetails.Name = (String)_StudentDashboardParsing["Table"][0]["FirstName"]; _studentDetails.PhoneNumber = (String)_StudentDashboardParsing["Table"][0]["PhoneNumber"]; _studentDetails.StateName = (String)_StudentDashboardParsing["Table"][0]["StateName"]; _studentDetails.StudentId = (Int32)_StudentDashboardParsing["Table"][0]["StudentId"]; _studentDetails.InstitutionName = (String)_StudentDashboardParsing["Table"][0]["InstitutionName"]; ReportModel ReportDetails = new ReportModel(); LessionWiseReportModel _StudentReportDetails = new LessionWiseReportModel(); string studentDashboard = StudentWeb.StudentDashboardDetails(Convert.ToInt32(Session["UserId"].ToString())); JObject _studentDashboardParse = JObject.Parse(studentDashboard); int _SubjectCount = (Int32)_studentDashboardParse["Table4"].Count(); List <SubjectDetails> _SubjectDetailsList = new List <SubjectDetails>(); for (int i = 0; i < _SubjectCount; i++) { SubjectDetails _SubjectDetails = new SubjectDetails(); _SubjectDetails.SubjectName = (String)_studentDashboardParse["Table4"][i]["SubjectName"]; _SubjectDetails.SubjectID = (Int32)_studentDashboardParse["Table4"][i]["SubjectId"]; _SubjectDetailsList.Add(_SubjectDetails); } ReportDetails.StudentGeneralDetails = _studentDetails; string _GetStudentDashboardDetails = StudentWeb.GetLessionWiseReport(_studentDetails.StudentId, _SubjectDetailsList[0].SubjectID); JObject Studentparsing = JObject.Parse(_GetStudentDashboardDetails); int _lessionReportCount = (Int32)Studentparsing["Table"].Count(); List <LessionWiseReportModel> _lessionWiseReportModelList = new List <LessionWiseReportModel>(); for (int i = 0; i < _lessionReportCount; i++) { LessionWiseReportModel _lessionWiseReportModel = new LessionWiseReportModel(); _lessionWiseReportModel.StudentId = (Int32)Studentparsing["Table"][i]["StudentId"]; _lessionWiseReportModel.SubjectId = (Int32)Studentparsing["Table"][i]["SubjectId"]; _lessionWiseReportModel.LessionName = (String)Studentparsing["Table"][i]["LessionName"]; _lessionWiseReportModel.Percentage = (Int32)Studentparsing["Table"][i]["Percentage"]; _lessionWiseReportModel.QuestionsAsked = (Int32)Studentparsing["Table"][i]["QuestionsAsked"]; _lessionWiseReportModel.CorrectAnswers = (Int32)Studentparsing["Table"][i]["CorrectAnswers"]; _lessionWiseReportModelList.Add(_lessionWiseReportModel); } //Completed TEst Details string _GetTestCompletedDetails = StudentWeb.GetWritenTestDetails(_studentDetails.StudentId); JObject WrittenTestparsing = JObject.Parse(_GetTestCompletedDetails); int _WrittenTestCount = (Int32)WrittenTestparsing["Table"].Count(); List <CompletedTestList> _CompletedTestList = new List <CompletedTestList>(); for (int i = 0; i < _WrittenTestCount; i++) { CompletedTestList _CompletedTestListReportModel = new CompletedTestList(); _CompletedTestListReportModel.Description = (String)WrittenTestparsing["Table"][i]["Description"]; _CompletedTestListReportModel.MarksScored = (Int32)WrittenTestparsing["Table"][i]["MarksScored"]; _CompletedTestListReportModel.SubjectId = (Int32)WrittenTestparsing["Table"][i]["SubjectId"]; if (_CompletedTestListReportModel.SubjectId == 1) { _CompletedTestListReportModel.SubjectName = "Maths"; } else if (_CompletedTestListReportModel.SubjectId == 2) { _CompletedTestListReportModel.SubjectName = "Science"; } else if (_CompletedTestListReportModel.SubjectId == 3) { _CompletedTestListReportModel.SubjectName = "Social"; } else if (_CompletedTestListReportModel.SubjectId == 4) { _CompletedTestListReportModel.SubjectName = "Maths"; } else if (_CompletedTestListReportModel.SubjectId == 5) { _CompletedTestListReportModel.SubjectName = "Chemistry"; } else if (_CompletedTestListReportModel.SubjectId == 6) { _CompletedTestListReportModel.SubjectName = "Physics"; } else if (_CompletedTestListReportModel.SubjectId == 7) { _CompletedTestListReportModel.SubjectName = "Computer"; } else if (_CompletedTestListReportModel.SubjectId == 8) { _CompletedTestListReportModel.SubjectName = "Biology"; } _CompletedTestListReportModel.TestId = (Int32)WrittenTestparsing["Table"][i]["TestId"]; _CompletedTestList.Add(_CompletedTestListReportModel); } //--Completed TEst Details--// ReportDetails.LessonWiseReportList = _lessionWiseReportModelList; ReportDetails.StudentSubjectList = _SubjectDetailsList; ReportDetails.StudentGeneralDetails = _studentDetails; ReportDetails.CompletedTestList = _CompletedTestList; return(View(ReportDetails)); } }
public ActionResult TestMain() { // model student general details string dashboardOutput = StudentWeb.GetStudentDetails(Convert.ToInt32(Session["UserId"].ToString())); JObject _StudentDetailsParsing = JObject.Parse(dashboardOutput); StudentGeneralDetails _studentDetails = new StudentGeneralDetails(); _studentDetails.BoardName = (String)_StudentDetailsParsing["Table"][0]["BoardName"]; _studentDetails.CityName = (String)_StudentDetailsParsing["Table"][0]["CityName"]; _studentDetails.ClassName = (String)_StudentDetailsParsing["Table"][0]["ClassName"]; _studentDetails.DistrictName = (String)_StudentDetailsParsing["Table"][0]["DistrictName"]; _studentDetails.EmailAddress = (String)_StudentDetailsParsing["Table"][0]["EmailAddress"]; _studentDetails.Name = (String)_StudentDetailsParsing["Table"][0]["FirstName"]; _studentDetails.PhoneNumber = (String)_StudentDetailsParsing["Table"][0]["PhoneNumber"]; _studentDetails.StateName = (String)_StudentDetailsParsing["Table"][0]["StateName"]; _studentDetails.StudentId = (Int32)_StudentDetailsParsing["Table"][0]["StudentId"]; _studentDetails.InstitutionName = (String)_StudentDetailsParsing["Table"][0]["InstitutionName"]; string studentDashboard = StudentWeb.StudentDashboardDetails(Convert.ToInt32(Session["UserId"].ToString())); JObject _studentDashboardParse = JObject.Parse(studentDashboard); int _SubjectCount = (Int32)_studentDashboardParse["Table4"].Count(); List <SubjectDetails> _SubjectDetailsList = new List <SubjectDetails>(); for (int i = 0; i < _SubjectCount; i++) { SubjectDetails _SubjectDetails = new SubjectDetails(); _SubjectDetails.SubjectName = (String)_studentDashboardParse["Table4"][i]["SubjectName"]; _SubjectDetails.SubjectID = (Int32)_studentDashboardParse["Table4"][i]["SubjectId"]; _SubjectDetailsList.Add(_SubjectDetails); } //Passing Parameter to Webservice and receving in string string _GetOverallPendingTestDetails = StudentWeb.GetPendingTests(_studentDetails.StudentId, "All"); //Received string and changed to json object JObject TestMainOverallParsing = JObject.Parse(_GetOverallPendingTestDetails); //To Identify Number of Values in JSON to Iterate Int32 _TestMainOverallCount = (int)TestMainOverallParsing["Table"].Count(); //Created to pass in Main Class for Model View TestMain _ModelTestMain = new TestMain(); //Created a List for Model List <OverallTest> _ListOverallTest = new List <OverallTest>(); List <PublicTest> _ListPublicTest = new List <PublicTest>(); for (int i = 0; i < _TestMainOverallCount; i++) { //Created Temprory object in List OverallTest _OverallTest = new OverallTest(); _OverallTest.TestID = (Int32)TestMainOverallParsing["Table"][i]["TestId"]; _OverallTest.StudentName = (String)TestMainOverallParsing["Table"][i]["Percentage"]; _OverallTest.SubjectName = (String)TestMainOverallParsing["Table"][i]["SubjectName"]; _OverallTest.Description = (String)TestMainOverallParsing["Table"][i]["Description"]; //Adding object in List _ListOverallTest.Add(_OverallTest); } _ModelTestMain.StudentGeneralDetails = _studentDetails; _ModelTestMain.GlobalStudentSubjectDetails = _SubjectDetailsList; _ModelTestMain.OverallTest = _ListOverallTest; return(View(_ModelTestMain)); }
public ActionResult Index() { StudentGeneralDetails objStudentLoginDetails = new StudentGeneralDetails(); objStudentLoginDetails.BoardName = GlobalStudentClass.BoardName; objStudentLoginDetails.CityName = GlobalStudentClass.CityName; objStudentLoginDetails.ClassName = GlobalStudentClass.ClassName; objStudentLoginDetails.DistrictName = GlobalStudentClass.DistrictName; objStudentLoginDetails.EmailAddress = GlobalStudentClass.EmailAddress; objStudentLoginDetails.Name = GlobalStudentClass.Name; objStudentLoginDetails.PhoneNumber = GlobalStudentClass.PhoneNumber; objStudentLoginDetails.StateName = GlobalStudentClass.StateName; objStudentLoginDetails.StudentId = GlobalStudentClass.StudentId; objStudentLoginDetails.InstitutionName = GlobalStudentClass.InstitutionName; StudentDashboard _StudentDashboardDetails = new StudentDashboard(); StudentRank _StudentRankDetails = new StudentRank(); OverallAvailableTest _StudentOverallAvailableTest = new OverallAvailableTest(); OverallLastFiveTest _StudentOverallLastFiveTest = new OverallLastFiveTest(); String _GetStudentDashboardDetails = StudentWeb.StudentDashboardDetails(GlobalStudentClass.StudentId); String _GetStudentDashboardDetails1 = StudentWeb.GetStudentDashboard(GlobalStudentClass.StudentId); JObject Studentparsing = JObject.Parse(_GetStudentDashboardDetails); JObject Studentparsing1 = JObject.Parse(_GetStudentDashboardDetails1); _StudentRankDetails.CityRank = (Int32)Studentparsing1["Table"][0]["CityRank"]; _StudentRankDetails.DistrictRank = (Int32)Studentparsing1["Table"][0]["DistrictRank"]; _StudentRankDetails.InstitutionRank = (Int32)Studentparsing1["Table"][0]["InstitutionRank"]; _StudentRankDetails.StateRank = (Int32)Studentparsing1["Table"][0]["StateRank"]; int _SubjectPercentageCount = (Int32)Studentparsing["Table1"].Count(); List <SubjectPercentage> _SubjectPercentageList = new List <SubjectPercentage>(); for (int i = 0; i < _SubjectPercentageCount; i++) { SubjectPercentage _Subjectpercentage = new SubjectPercentage(); _Subjectpercentage.SubjectId = (Int32)Studentparsing["Table1"][i]["SubjectId"]; _Subjectpercentage.Percentage = (Int32)Studentparsing["Table1"][i]["Percentage"]; _Subjectpercentage.SubjectName = (String)Studentparsing["Table1"][i]["SubjectName"]; _SubjectPercentageList.Add(_Subjectpercentage); } List <OverallLastFiveTest> _LastFiveTestList = new List <OverallLastFiveTest>(); int _LastFiveTestCountCount = (Int32)Studentparsing["Table2"].Count(); for (int i = 0; i < _LastFiveTestCountCount; i++) { OverallLastFiveTest _LastFiveTest = new OverallLastFiveTest(); _LastFiveTest.SubjectID = (Int32)Studentparsing["Table2"][i]["SubjectId"]; _LastFiveTest.Percentage = (Int32)Studentparsing["Table2"][i]["Percentage"]; _LastFiveTest.SubjectName = (String)Studentparsing["Table2"][i]["SubjectName"]; _LastFiveTest.TestId = (Int32)Studentparsing["Table2"][i]["TestId"]; _LastFiveTest.TestType = (String)Studentparsing["Table2"][i]["TestType"]; _LastFiveTestList.Add(_LastFiveTest); } List <OverallAvailableTest> _OverallAvailableTestList = new List <OverallAvailableTest>(); for (int i = 0; i < 5; i++) { OverallAvailableTest _OverallAvailableTest = new OverallAvailableTest(); _OverallAvailableTest.SubjectID = (Int32)Studentparsing["Table3"][i]["SubjectId"]; _OverallAvailableTest.SubjectName = (String)Studentparsing["Table3"][i]["SubjectName"]; _OverallAvailableTest.TestId = (Int32)Studentparsing["Table3"][i]["TestId"]; _OverallAvailableTest.TestType = (String)Studentparsing["Table3"][i]["TestType"]; _OverallAvailableTestList.Add(_OverallAvailableTest); } //ADding Subject in Global int _SubjectCount = (Int32)Studentparsing["Table4"].Count(); List <SubjectDetails> _SubjectDetailsList = new List <SubjectDetails>(); for (int i = 0; i < _SubjectCount; i++) { SubjectDetails _SubjectDetails = new SubjectDetails(); _SubjectDetails.SubjectName = (String)Studentparsing["Table4"][i]["SubjectName"]; _SubjectDetails.SubjectID = (Int32)Studentparsing["Table4"][i]["SubjectId"]; _SubjectDetailsList.Add(_SubjectDetails); } GlobalStudentSubjects.SubjectList = _SubjectDetailsList; _StudentDashboardDetails.OverallAvailableTest = _OverallAvailableTestList; _StudentDashboardDetails.OverallLastFiveTest = _LastFiveTestList; _StudentDashboardDetails.StudentRank = _StudentRankDetails; _StudentDashboardDetails.SubjectPercentage = _SubjectPercentageList; _StudentDashboardDetails.StudentGeneralDetails = objStudentLoginDetails; return(View(_StudentDashboardDetails)); }