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));
}
