public void StudentRank_IsNotInGroup() { // Arrange var simon = new StudentRank { Position = 2, Name = "Simon" }; var sergey = new StudentRank { Position = 6, Name = "Sergey" }; var thomas = new StudentRank { Position = 8, Name = "Thomas" }; var chris = new StudentRank { Position = 16, Name = "Chris" }; var harry = new StudentRank { Position = 16, Name = "Harry" }; var roger = new StudentRank { Position = 18, Name = "Roger" }; // Act // Assert Assert.IsFalse(simon.IsInGroup(chris)); Assert.IsFalse(harry.IsInGroup(roger)); }
public void StudentRank_IsInGroup() { // Arrange StudentRank.NofCols = 5; var simon = new StudentRank { Position = 2, Name = "Simon" }; var sergey = new StudentRank { Position = 6, Name = "Sergey" }; var thomas = new StudentRank { Position = 8, Name = "Thomas" }; var chris = new StudentRank { Position = 16, Name = "Chris" }; var harry = new StudentRank { Position = 16, Name = "Harry" }; // Act // Assert Assert.IsTrue(simon.IsInGroup(sergey)); Assert.IsTrue(simon.IsInGroup(thomas)); Assert.IsTrue(chris.IsInGroup(harry)); }
/*--------------------------------------StudentRank--------------------------------*/ public int AddStudentRank(StudentRank ld) { string sqlstr = "INSERT INTO db_p2_sturank (STU_NUM, RAK_ID, STR_DT)VALUES(" + ld.Stnum + ", " + ld.Rank + ", '" + ld.Date + "');"; int result = MySqlHelper.ExecuteNonQuery(sqlstr); return(result); }
public void StudentRank_Deserialize_Null() { // Arrange var input = GetInput1(); // Act // deserialise string array into model var list = StudentRank.Deserialize(null); // Assert }
public void StudentRank_Deserialize_EmptyString() { // Arrange var input = GetInput1(); // Act // deserialise string array into model var list = StudentRank.Deserialize(string.Empty); // Assert }
public void StudentRank_Deserialize_Input_Sample2() { // Arrange var input = GetInput2(); // Act // deserialise string array into model var list = StudentRank.Deserialize(input); // Assert Assert.IsNotNull(list); Assert.AreEqual(6, list.Count); }
public void StudentRank_Serialize_Group1() { // Arrange var input = GetGroup1(); // Act // deserialise string array into model var output = StudentRank.Serialize(input); // Assert Assert.IsNotNull(output); Assert.AreEqual(NeighboursOutput1, output); }
public void StudentRank_Deserialize_EmptyEntries() { // Arrange var input = GetInput1(); // Act // deserialise string array into model var list = StudentRank.Deserialize(input); // Assert Assert.IsNotNull(list); Assert.AreEqual(0, list.Count); }
static void Main(string[] args) { SqlFuns sf = new SqlFuns(); IList <Student> st = sf.SearchStudent(true); for (int i = 2; i < st.Count; i++) { StudentRank t = new StudentRank(); t.Stnum = st[i].Stnum; t.Rank = 1; t.Date = st[i].Joindate; sf.AddStudentRank(t); } }
public void IncludeRanks(StudentRank ranks) { var targets = _platoon.Where(s => (s.Rank & ranks) != 0); foreach (var target in targets) { if (_students.Contains(target)) { continue; } _students.Add(target); } }
/// <summary> /// For a given student instance, get all the others students in his/her group /// </summary> /// <param name="instance"></param> /// <returns></returns> public HashSet <string> GetGroup(StudentRank instance) { var res = new HashSet <string>(); foreach (var student in Get()) { if (instance.IsInGroup(student) && !res.Contains(student.Name)) { res.Add(student.Name); } } return(res); }
public StudentRank SearchStudentRank(uint snum, uint rkid) { string sqlstr = "SELECT STU_NUM, RAK_ID, STR_DT FROM db_p2_sturank WHERE STU_NUM="; string sqlend = " AND RAK_ID="; DataSet ds = MySqlHelper.ExecuteQuery(sqlstr + snum + sqlend + rkid); DataTable dt = ds.Tables[0]; StudentRank temp = new StudentRank(); temp.Stnum = uint.Parse(dt.Rows[0][0].ToString()); temp.Rank = uint.Parse(dt.Rows[0][1].ToString()); temp.Date = DateTime.Parse(dt.Rows[0][2].ToString()); return(temp); }
public Student(XmlNode xmlNode) : base( xmlNode.SelectSingleNode("PresonalDetails/FirstName").InnerText, xmlNode.SelectSingleNode("PresonalDetails/LastName").InnerText, xmlNode.SelectSingleNode("PresonalDetails/EGN").InnerText, xmlNode.SelectSingleNode("PresonalDetails/HomeTown").InnerText ) { int facultyNumber = int.Parse(xmlNode.SelectSingleNode("FacultyNumber").InnerText); StudentRank rank = (StudentRank)Enum.Parse(typeof(StudentRank), xmlNode.SelectSingleNode("Rank").InnerText); //int points = int.Parse(xmlNode.SelectSingleNode("Points").InnerText); if (facultyNumber == 0) { throw new ArgumentException("Faculty number cannot be zero"); } this.coursesList = new List <Course>(); XmlNode coursesNode = xmlNode.SelectSingleNode("CoursesList"); XmlNode courseNode = coursesNode.FirstChild; while (!(courseNode == null)) { //Enum.Parse(cName, courseNode.InnerText.ToString()); object cName = Enum.Parse(typeof(CourseName), courseNode.InnerText.ToString()); this.AddCourse(new Course((CourseName)cName)); courseNode = courseNode.NextSibling; } this.GradeList = new List <Grade>(); XmlNode gradesNode = xmlNode.SelectSingleNode("GradesList"); XmlNode gradeNode = gradesNode.FirstChild; while (!(gradeNode == null)) { this.AddGrade(new Grade( double.Parse(gradeNode.SelectSingleNode("Weight").InnerText), new Course((CourseName)Enum.Parse(typeof(CourseName), gradeNode.SelectSingleNode("Course").InnerText.ToString())) ) ); gradeNode = gradeNode.NextSibling; } this.FacultyNumber = facultyNumber; this.Rank = rank; //this.Points = points; }
public IList <StudentRank> SearchStudentRank(uint snum) { string sqlstr = "SELECT STU_NUM, RAK_ID, STR_DT FROM db_p2_sturank WHERE STU_NUM="; string sqlend = " ORDER BY RAK_ID DESC"; DataSet ds = MySqlHelper.ExecuteQuery(sqlstr + snum + sqlend); DataTable dt = ds.Tables[0]; IList <StudentRank> result = new List <StudentRank>(); for (int i = 0; i < dt.Rows.Count; i++) { StudentRank temp = new StudentRank(); temp.Stnum = uint.Parse(dt.Rows[i][0].ToString()); temp.Rank = uint.Parse(dt.Rows[i][1].ToString()); temp.Date = DateTime.Parse(dt.Rows[i][2].ToString()); result.Add(temp); } return(result); }
public ActionResult <string> Post([FromBody] string value) { if (String.IsNullOrWhiteSpace(value)) { return(BadRequest()); } try { // deserialise string array into model var list = StudentRank.Deserialize(value); // store into repository (why?) _studentRankRepository.Add(list); // get all student's rank var studentRanks = _studentRankRepository.Get(); var groups = new StringBuilder(); // for each student get neighbours list foreach (var student in studentRanks) { if (!groups.ToString().Contains(student.Name)) { var group = _studentRankRepository.GetGroup(student); groups.Append($"{{'{String.Join<string>("','", group)}'}}"); } } // serialise list var res = $"{{{groups.ToString()}}}"; return(Ok(res)); } catch { return(BadRequest("Invalid input format")); } }
//shorthand property declaration //public StudentRank StudentRank { get; set; } //other properties might include: age, studentID, DOB, major, ClassRank, Drink Pref, Gender //STEP 2: CONSTRUCTORS!!! public Student(string name, StudentRank rank) { this.Name = name; this.CourseList = new List <Course>(); //make sure to initialize any lists this.StudentRank = rank; }
public ActionResult Index(int StudentId) { GlobalStudentID = StudentId; StudentGeneralDetails objStudentLoginDetails = new StudentGeneralDetails(); StudentDashboard _StudentDashboardDetails = new StudentDashboard(); if (GlobalStudentID != 0) { String _GetStudentGeneralDetails = SupportWeb.GetStudentDetails(GlobalStudentID); JObject StudentGeneralDetailsparsing = JObject.Parse(_GetStudentGeneralDetails); objStudentLoginDetails.BoardName = (string)StudentGeneralDetailsparsing["Table"][0]["BoardName"]; objStudentLoginDetails.CityName = (string)StudentGeneralDetailsparsing["Table"][0]["CityName"]; objStudentLoginDetails.ClassName = (string)StudentGeneralDetailsparsing["Table"][0]["ClassName"]; objStudentLoginDetails.DistrictName = (string)StudentGeneralDetailsparsing["Table"][0]["DistrictName"]; objStudentLoginDetails.EmailAddress = (string)StudentGeneralDetailsparsing["Table"][0]["EmailAddress"]; objStudentLoginDetails.Name = (string)StudentGeneralDetailsparsing["Table"][0]["FirstName"]; objStudentLoginDetails.PhoneNumber = (string)StudentGeneralDetailsparsing["Table"][0]["PhoneNumber"]; objStudentLoginDetails.GroupId = (int)StudentGeneralDetailsparsing["Table"][0]["GroupId"]; objStudentLoginDetails.StudentId = GlobalStudentID; objStudentLoginDetails.InstitutionName = (string)StudentGeneralDetailsparsing["Table"][0]["InstitutionName"]; StudentRank _StudentRankDetails = new StudentRank(); OverallAvailableTest _StudentOverallAvailableTest = new OverallAvailableTest(); OverallLastFiveTest _StudentOverallLastFiveTest = new OverallLastFiveTest(); String _GetStudentDashboardDetails1 = SupportWeb.GetStudentDashboard(GlobalStudentID); String _GetStudentDashboardDetails = SupportWeb.StudentDashboardDetails(GlobalStudentID); JObject Studentparsing = JObject.Parse(_GetStudentDashboardDetails); JObject Studentparsing1 = JObject.Parse(_GetStudentDashboardDetails1); try { _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"]; } catch { return(RedirectToAction("CheckStudentDetails", "CustomerSupport")); } 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 <StudentSubjects> _SubjectDetailsList = new List <StudentSubjects>(); for (int i = 0; i < _SubjectCount; i++) { StudentSubjects _SubjectDetails = new StudentSubjects(); _SubjectDetails.SubjectName = (String)Studentparsing["Table4"][i]["SubjectName"]; _SubjectDetails.SubjectID = (Int32)Studentparsing["Table4"][i]["SubjectId"]; _SubjectDetailsList.Add(_SubjectDetails); } _StudentDashboardDetails.StudentSubjects = _SubjectDetailsList; _StudentDashboardDetails.OverallAvailableTest = _OverallAvailableTestList; _StudentDashboardDetails.OverallLastFiveTest = _LastFiveTestList; _StudentDashboardDetails.StudentRank = _StudentRankDetails; _StudentDashboardDetails.SubjectPercentage = _SubjectPercentageList; _StudentDashboardDetails.StudentGeneralDetails = objStudentLoginDetails; return(View(_StudentDashboardDetails)); } else { _StudentDashboardDetails = null; return(View(_StudentDashboardDetails)); } }
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)); }
public ActionResult Dashboard() { string dashboardOutput = StudentWeb.GetStudentDetails(Convert.ToInt32(Session["UserId"].ToString())); JObject studentUnderParentparsing = JObject.Parse(dashboardOutput); // load login details in student general class StudentGeneralDetails _studentDetails = new StudentGeneralDetails(); _studentDetails.BoardName = (String)studentUnderParentparsing["Table"][0]["BoardName"]; _studentDetails.CityName = (String)studentUnderParentparsing["Table"][0]["CityName"]; _studentDetails.ClassName = (String)studentUnderParentparsing["Table"][0]["ClassName"]; _studentDetails.DistrictName = (String)studentUnderParentparsing["Table"][0]["DistrictName"]; _studentDetails.EmailAddress = (String)studentUnderParentparsing["Table"][0]["EmailAddress"]; _studentDetails.Name = (String)studentUnderParentparsing["Table"][0]["FirstName"]; _studentDetails.PhoneNumber = (String)studentUnderParentparsing["Table"][0]["PhoneNumber"]; _studentDetails.StateName = (String)studentUnderParentparsing["Table"][0]["StateName"]; _studentDetails.StudentId = (Int32)studentUnderParentparsing["Table"][0]["StudentId"]; _studentDetails.InstitutionName = (String)studentUnderParentparsing["Table"][0]["InstitutionName"]; // Create Object for class StudentDashboard _StudentDashboardDetails = new StudentDashboard(); StudentRank _StudentRankDetails = new StudentRank(); OverallAvailableTest _StudentOverallAvailableTest = new OverallAvailableTest(); OverallLastFiveTest _StudentOverallLastFiveTest = new OverallLastFiveTest(); // Get Dashboard Details with respect to student id form service String _GetStudentDashboardDetails = StudentWeb.StudentDashboardDetails(Convert.ToInt32(Session["UserId"].ToString())); // Get Student Rank Details form service with respect to student id String _GetStudentDashboardDetails1 = StudentWeb.GetStudentDashboard(Convert.ToInt32(Session["UserId"].ToString())); // Parse the student dashbord details form Json Student dashboard JObject Studentparsing = JObject.Parse(_GetStudentDashboardDetails); // parse the student rank details form Json Student dashboard Details1 JObject Studentparsing1 = JObject.Parse(_GetStudentDashboardDetails1); // int _studentPerformanceCount = Studentparsing["Table3"].Count(); _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(); if (_LastFiveTestCountCount > 5) { _LastFiveTestCountCount = 5; } 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); } int _OverallAvailableTestCount = (Int32)Studentparsing["Table3"].Count(); //Studentparsing["Table3"].Count(); List <OverallAvailableTest> _OverallAvailableTestList = new List <OverallAvailableTest>(); //If Test Count is more than 5 show only five test //It is not last five test if (_OverallAvailableTestCount > 5) { _OverallAvailableTestCount = 5; } // adding five test details for (int i = 0; i < _OverallAvailableTestCount; 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 <StudentSubjects> _SubjectDetailsList = new List <StudentSubjects>(); for (int i = 0; i < _SubjectCount; i++) { StudentSubjects _SubjectDetails = new StudentSubjects(); _SubjectDetails.SubjectName = (String)Studentparsing["Table4"][i]["SubjectName"]; _SubjectDetails.SubjectID = (Int32)Studentparsing["Table4"][i]["SubjectId"]; _SubjectDetailsList.Add(_SubjectDetails); } // Get the Rows Count in Good, Bad and Average int goodPerformingCount = Studentparsing["Table5"].Count(); // Good performace int averagePerformingCount = Studentparsing["Table6"].Count(); // Average performance int badPerformingCount = Studentparsing["Table7"].Count(); // Bad performance // Create Object for Good, Average, Bad list List <GoodPerformingSubject> _goodPerformingSubjectList = new List <GoodPerformingSubject>(); List <AveragePerformingSubject> _averagePerformingSubjectList = new List <AveragePerformingSubject>(); List <BadPerformingSubject> _badPerformingSubjectList = new List <BadPerformingSubject>(); // Add good performing into list #region Good Performing if (goodPerformingCount > 0) { if (goodPerformingCount > 5) { for (int i = 0; i < 5; i++) { GoodPerformingSubject _goodPerformingSubject = new GoodPerformingSubject(); _goodPerformingSubject.SubjectId = (Int32)Studentparsing["Table5"][i]["SubjectId"]; _goodPerformingSubject.SubjectName = (string)Studentparsing["Table5"][i]["SubjectName"]; _goodPerformingSubject.LessionId = (Int32)Studentparsing["Table5"][i]["LessionId"]; _goodPerformingSubject.LessionName = (string)Studentparsing["Table5"][i]["LessionName"]; _goodPerformingSubject.Topic = (string)Studentparsing["Table5"][i]["Topic"]; _goodPerformingSubject.Percentage = (Int32)Studentparsing["Table5"][i]["Percentage"]; _goodPerformingSubjectList.Add(_goodPerformingSubject); } } else { for (int i = 0; i < goodPerformingCount; i++) { GoodPerformingSubject _goodPerformingSubject = new GoodPerformingSubject(); _goodPerformingSubject.SubjectId = (Int32)Studentparsing["Table5"][i]["SubjectId"]; _goodPerformingSubject.SubjectName = (string)Studentparsing["Table5"][i]["SubjectName"]; _goodPerformingSubject.LessionId = (Int32)Studentparsing["Table5"][i]["LessionId"]; _goodPerformingSubject.LessionName = (string)Studentparsing["Table5"][i]["LessionName"]; _goodPerformingSubject.Topic = (string)Studentparsing["Table5"][i]["Topic"]; _goodPerformingSubject.Percentage = (Int32)Studentparsing["Table5"][i]["Percentage"]; _goodPerformingSubjectList.Add(_goodPerformingSubject); } } } #endregion // Add Average performing list #region Average Performing if (averagePerformingCount > 0) { if (averagePerformingCount > 5) { for (int i = 0; i < 5; i++) { AveragePerformingSubject _AveragePerformingSubject = new AveragePerformingSubject(); _AveragePerformingSubject.SubjectId = (Int32)Studentparsing["Table6"][i]["SubjectId"]; _AveragePerformingSubject.SubjectName = (string)Studentparsing["Table6"][i]["SubjectName"]; _AveragePerformingSubject.LessionId = (Int32)Studentparsing["Table6"][i]["LessionId"]; _AveragePerformingSubject.LessionName = (string)Studentparsing["Table6"][i]["LessionName"]; _AveragePerformingSubject.Topic = (string)Studentparsing["Table6"][i]["Topic"]; _AveragePerformingSubject.Percentage = (Int32)Studentparsing["Table6"][i]["Percentage"]; _averagePerformingSubjectList.Add(_AveragePerformingSubject); } } else { for (int i = 0; i < averagePerformingCount; i++) { AveragePerformingSubject _AveragePerformingSubject = new AveragePerformingSubject(); _AveragePerformingSubject.SubjectId = (Int32)Studentparsing["Table6"][i]["SubjectId"]; _AveragePerformingSubject.SubjectName = (string)Studentparsing["Table6"][i]["SubjectName"]; _AveragePerformingSubject.LessionId = (Int32)Studentparsing["Table6"][i]["LessionId"]; _AveragePerformingSubject.LessionName = (string)Studentparsing["Table6"][i]["LessionName"]; _AveragePerformingSubject.Topic = (string)Studentparsing["Table6"][i]["Topic"]; _AveragePerformingSubject.Percentage = (Int32)Studentparsing["Table6"][i]["Percentage"]; _averagePerformingSubjectList.Add(_AveragePerformingSubject); } } } #endregion // Add Bad Performing List #region Bad Performing if (badPerformingCount > 0) { if (badPerformingCount > 5) { for (int i = 0; i < 5; i++) { BadPerformingSubject _BadPerformingSubject = new BadPerformingSubject(); _BadPerformingSubject.SubjectId = (Int32)Studentparsing["Table7"][i]["SubjectId"]; _BadPerformingSubject.SubjectName = (string)Studentparsing["Table7"][i]["SubjectName"]; _BadPerformingSubject.LessionId = (Int32)Studentparsing["Table7"][i]["LessionId"]; _BadPerformingSubject.LessionName = (string)Studentparsing["Table7"][i]["LessionName"]; _BadPerformingSubject.Topic = (string)Studentparsing["Table7"][i]["Topic"]; _BadPerformingSubject.Percentage = (Int32)Studentparsing["Table7"][i]["Percentage"]; _badPerformingSubjectList.Add(_BadPerformingSubject); } } else { for (int i = 0; i < badPerformingCount; i++) { BadPerformingSubject _BadPerformingSubject = new BadPerformingSubject(); _BadPerformingSubject.SubjectId = (Int32)Studentparsing["Table7"][i]["SubjectId"]; _BadPerformingSubject.SubjectName = (string)Studentparsing["Table7"][i]["SubjectName"]; _BadPerformingSubject.LessionId = (Int32)Studentparsing["Table7"][i]["LessionId"]; _BadPerformingSubject.LessionName = (string)Studentparsing["Table7"][i]["LessionName"]; _BadPerformingSubject.Topic = (string)Studentparsing["Table7"][i]["Topic"]; _BadPerformingSubject.Percentage = (Int32)Studentparsing["Table7"][i]["Percentage"]; _badPerformingSubjectList.Add(_BadPerformingSubject); } } } #endregion _StudentDashboardDetails.OverallAvailableTest = _OverallAvailableTestList; _StudentDashboardDetails.OverallLastFiveTest = _LastFiveTestList; _StudentDashboardDetails.StudentRank = _StudentRankDetails; _StudentDashboardDetails.SubjectPercentage = _SubjectPercentageList; _StudentDashboardDetails.StudentGeneralDetails = _studentDetails; _StudentDashboardDetails.GoodPerformingSubject = _goodPerformingSubjectList; _StudentDashboardDetails.AveragePerformingSubject = _averagePerformingSubjectList; _StudentDashboardDetails.BadPerformingSubject = _badPerformingSubjectList; return(View(_StudentDashboardDetails)); }
// Student Dashboard Object // // GET: /Parent/ public ActionResult Dashboard() { // Get Student Under Parent string _studentUnderParent = ParentWeb.GetStudentUnderParent(Convert.ToInt32(Session["UserId"].ToString())); // Parse the value to string JObject studentUnderParentparsing = JObject.Parse(_studentUnderParent); // Parent DashBoard Object ParentDashboard _parentDashboard = new ParentDashboard(); // List Created to Load the Student Under Parent List <StudentUnderParent> _ListStudentUnderParent = new List <StudentUnderParent>(); // Get the table Count int _studentUnderParentCount = studentUnderParentparsing["Table"].Count(); if (_studentUnderParentCount == 0) { // Load the Student details in List Using For loop //for (int i = 0; i < _studentUnderParentCount; i++) //{ // StudentUnderParent _ParentUnderStudent = new StudentUnderParent(); // _ParentUnderStudent.StudentId = (Int32)studentUnderParentparsing["Table"][i]["StudentId"]; // _ParentUnderStudent.StudentName = (string)studentUnderParentparsing["Table"][i]["StudentName"]; // _ListStudentUnderParent.Add(_ParentUnderStudent); //} int StudentId = 403; //(Int32)studentUnderParentparsing["Table"][0]["StudentId"]; // Get Student Details string _getStudentDetails = ParentWeb.GetStudentDetails(StudentId); // Parse Json to String JObject _StudentDetailsParse = JObject.Parse(_getStudentDetails); // Load the Student Details // Student Details from parent Dashboard module class //string dashboardOutput = ParentWeb.GetStudentDetails(Convert.ToInt32( Session["UserId"].ToString())); string dashboardOutput = ParentWeb.GetStudentDetails(StudentId); JObject studentDashboard = JObject.Parse(dashboardOutput); StudentGeneralDetails _studentDetails = new StudentGeneralDetails(); _studentDetails.BoardName = (String)studentDashboard["Table"][0]["BoardName"]; _studentDetails.CityName = (String)studentDashboard["Table"][0]["CityName"]; _studentDetails.ClassName = (String)studentDashboard["Table"][0]["ClassName"]; _studentDetails.DistrictName = (String)studentDashboard["Table"][0]["DistrictName"]; _studentDetails.EmailAddress = (String)studentDashboard["Table"][0]["EmailAddress"]; _studentDetails.Name = (String)studentDashboard["Table"][0]["Name"]; _studentDetails.PhoneNumber = (String)studentDashboard["Table"][0]["PhoneNumber"]; _studentDetails.StateName = (String)studentDashboard["Table"][0]["StateName"]; _studentDetails.StudentId = (Int32)studentDashboard["Table"][0]["StudentId"]; _studentDetails.InstitutionName = (String)studentDashboard["Table"][0]["InstitutionName"]; StudentRank _StudentRankDetails = new StudentRank(); OverallAvailableTest _StudentOverallAvailableTest = new OverallAvailableTest(); OverallLastFiveTest _StudentOverallLastFiveTest = new OverallLastFiveTest(); String _GetStudentDashboardDetails = ParentWeb.StudentDashboardDetails(_studentDetails.StudentId); String _GetStudentDashboardDetails1 = ParentWeb.GetStudentDashboard(_studentDetails.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>(); // adding five test details 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 <StudentSubjectDetails> _SubjectDetailsList = new List <StudentSubjectDetails>(); for (int i = 0; i < _SubjectCount; i++) { StudentSubjectDetails _SubjectDetails = new StudentSubjectDetails(); _SubjectDetails.SubjectName = (String)Studentparsing["Table4"][i]["SubjectName"]; _SubjectDetails.SubjectID = (Int32)Studentparsing["Table4"][i]["SubjectId"]; _SubjectDetailsList.Add(_SubjectDetails); } // Report Subjectwise performance int goodPerformingCount = Studentparsing["Table5"].Count(); int averagePerformingCount = Studentparsing["Table6"].Count(); int badPerformingCount = Studentparsing["Table7"].Count(); List <GoodPerformingSubject> _goodPerformingSubjectList = new List <GoodPerformingSubject>(); List <AveragePerformingSubject> _averagePerformingSubjectList = new List <AveragePerformingSubject>(); List <BadPerformingSubject> _badPerformingSubjectList = new List <BadPerformingSubject>(); // Add good performing into list #region Good Performing if (goodPerformingCount > 0) { if (goodPerformingCount > 5) { for (int i = 0; i < 5; i++) { GoodPerformingSubject _goodPerformingSubject = new GoodPerformingSubject(); _goodPerformingSubject.SubjectId = (Int32)Studentparsing["Table5"][i]["SubjectId"]; _goodPerformingSubject.SubjectName = (string)Studentparsing["Table5"][i]["SubjectName"]; _goodPerformingSubject.LessionId = (Int32)Studentparsing["Table5"][i]["LessionId"]; _goodPerformingSubject.LessionName = (string)Studentparsing["Table5"][i]["LessionName"]; _goodPerformingSubject.Topic = (string)Studentparsing["Table5"][i]["Topic"]; _goodPerformingSubject.Percentage = (Int32)Studentparsing["Table5"][i]["Percentage"]; _goodPerformingSubjectList.Add(_goodPerformingSubject); } } else { for (int i = 0; i < goodPerformingCount; i++) { GoodPerformingSubject _goodPerformingSubject = new GoodPerformingSubject(); _goodPerformingSubject.SubjectId = (Int32)Studentparsing["Table5"][i]["SubjectId"]; _goodPerformingSubject.SubjectName = (string)Studentparsing["Table5"][i]["SubjectName"]; _goodPerformingSubject.LessionId = (Int32)Studentparsing["Table5"][i]["LessionId"]; _goodPerformingSubject.LessionName = (string)Studentparsing["Table5"][i]["LessionName"]; _goodPerformingSubject.Topic = (string)Studentparsing["Table5"][i]["Topic"]; _goodPerformingSubject.Percentage = (Int32)Studentparsing["Table5"][i]["Percentage"]; _goodPerformingSubjectList.Add(_goodPerformingSubject); } } } #endregion // Add Average performing into List #region Average Performing if (averagePerformingCount > 0) { if (averagePerformingCount > 5) { for (int i = 0; i < 5; i++) { AveragePerformingSubject _AveragePerformingSubject = new AveragePerformingSubject(); _AveragePerformingSubject.SubjectId = (Int32)Studentparsing["Table6"][i]["SubjectId"]; _AveragePerformingSubject.SubjectName = (string)Studentparsing["Table6"][i]["SubjectName"]; _AveragePerformingSubject.LessionId = (Int32)Studentparsing["Table6"][i]["LessionId"]; _AveragePerformingSubject.LessionName = (string)Studentparsing["Table6"][i]["LessionName"]; _AveragePerformingSubject.Topic = (string)Studentparsing["Table6"][i]["Topic"]; _AveragePerformingSubject.Percentage = (Int32)Studentparsing["Table6"][i]["Percentage"]; _averagePerformingSubjectList.Add(_AveragePerformingSubject); } } else { for (int i = 0; i < averagePerformingCount; i++) { AveragePerformingSubject _AveragePerformingSubject = new AveragePerformingSubject(); _AveragePerformingSubject.SubjectId = (Int32)Studentparsing["Table6"][i]["SubjectId"]; _AveragePerformingSubject.SubjectName = (string)Studentparsing["Table6"][i]["SubjectName"]; _AveragePerformingSubject.LessionId = (Int32)Studentparsing["Table6"][i]["LessionId"]; _AveragePerformingSubject.LessionName = (string)Studentparsing["Table6"][i]["LessionName"]; _AveragePerformingSubject.Topic = (string)Studentparsing["Table6"][i]["Topic"]; _AveragePerformingSubject.Percentage = (Int32)Studentparsing["Table6"][i]["Percentage"]; _averagePerformingSubjectList.Add(_AveragePerformingSubject); } } } #endregion // Add Bad performing into list #region Bad Performing if (badPerformingCount > 0) { if (badPerformingCount > 5) { for (int i = 0; i < 5; i++) { BadPerformingSubject _BadPerformingSubject = new BadPerformingSubject(); _BadPerformingSubject.SubjectId = (Int32)Studentparsing["Table7"][i]["SubjectId"]; _BadPerformingSubject.SubjectName = (string)Studentparsing["Table7"][i]["SubjectName"]; _BadPerformingSubject.LessionId = (Int32)Studentparsing["Table7"][i]["LessionId"]; _BadPerformingSubject.LessionName = (string)Studentparsing["Table7"][i]["LessionName"]; _BadPerformingSubject.Topic = (string)Studentparsing["Table7"][i]["Topic"]; _BadPerformingSubject.Percentage = (Int32)Studentparsing["Table7"][i]["Percentage"]; _badPerformingSubjectList.Add(_BadPerformingSubject); } } else { for (int i = 0; i < badPerformingCount; i++) { BadPerformingSubject _BadPerformingSubject = new BadPerformingSubject(); _BadPerformingSubject.SubjectId = (Int32)Studentparsing["Table7"][i]["SubjectId"]; _BadPerformingSubject.SubjectName = (string)Studentparsing["Table7"][i]["SubjectName"]; _BadPerformingSubject.LessionId = (Int32)Studentparsing["Table7"][i]["LessionId"]; _BadPerformingSubject.LessionName = (string)Studentparsing["Table7"][i]["LessionName"]; _BadPerformingSubject.Topic = (string)Studentparsing["Table7"][i]["Topic"]; _BadPerformingSubject.Percentage = (Int32)Studentparsing["Table7"][i]["Percentage"]; _badPerformingSubjectList.Add(_BadPerformingSubject); } } } #endregion _parentDashboard.OverallAvailableTest = _OverallAvailableTestList; _parentDashboard.OverallLastFiveTest = _LastFiveTestList; _parentDashboard.StudentRank = _StudentRankDetails; _parentDashboard.SubjectPercentage = _SubjectPercentageList; _parentDashboard.StudentGeneralDetails = _studentDetails; _parentDashboard.GoodPerformingSubject = _goodPerformingSubjectList; _parentDashboard.AveragePerformingSubject = _averagePerformingSubjectList; _parentDashboard.BadPerformingSubject = _badPerformingSubjectList; return(View(_parentDashboard)); } else { return(RedirectToAction("index", "StudentUnderParent")); } }
public StudentRank Add(StudentRank instance) { _repository.Add(instance); return(instance); }
public Collection<StudentRank> GetStudentRankBySOIDandAOID_Print(int SOID, int AOID) { StudentRank studentRank = null; Collection<StudentRank> _list = new Collection<StudentRank>(); using (OdbcConnection connection = new OdbcConnection(connectionString)) { using (OdbcCommand command = new OdbcCommand()) { command.Connection = connection; command.CommandText = "{CALL GetStudentRankBySOIDandAOID1_Print(?,?)}"; command.CommandType = CommandType.StoredProcedure; //Parameter Setting command.Parameters.AddWithValue("@SOID", SOID); command.Parameters.AddWithValue("@AOID", AOID); command.CommandTimeout = 900; connection.Open(); using (OdbcDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { studentRank = new StudentRank(); studentRank.AssessmentOID = Convert.ToInt32(dataReader["AssessmentOID"]); studentRank.Comment = Convert.ToString(dataReader["Comment"]); studentRank.Rank = Convert.ToInt32(dataReader["Rank"]); //studentRank.Score = Convert.ToDouble(dataReader["Score"]); studentRank.SectionName = Convert.ToString(dataReader["SectionName"]); studentRank.SectionOID = Convert.ToInt32(dataReader["SectionOID"]); _list.Add(studentRank); } } } } return _list; }
public Student(string firstName, string lastName, string egn, int facultyNumber, StudentRank rank = StudentRank.Unknown, string hometown = "Unknown") : base(firstName, lastName, egn, hometown) { //if (facultyNumber == null) //{ // throw new ArgumentNullException("Faculty number cannot be null"); //} if (facultyNumber == 0) { throw new ArgumentException("Faculty number cannot be zero"); } this.coursesList = new List<Course>(); this.GradeList = new List<Grade>(); this.FacultyNumber = facultyNumber; this.Rank = rank; }
private void PrintIntervention(int POID, int RiskOID, string BannerID,int AOID) { try { Interventions intervention = new Interventions(); intervention = intervention.GetInterventionByOID(POID); if (intervention != null) { Student stdnt = new Student(); int StdOID = stdnt.GetStudentOIDByStudentBannerID(Request.QueryString["soid"]); stdnt = stdnt.GetStudentByOID(StdOID); if (stdnt != null) { string html = ""; Assessment ass = new Assessment(); //Create Html html += "<table width='100%' ><tr><td><img alt='Logo' src='../../images/chippewavtc_logo.jpg' /></td><td style='text-align:center;'><span style='font-size:medium;font-weight:bold;'> Steps to Success: CVTC's commitment to helping YOU succeed!</span><br/><span style='text-align:center;'> Inventory of Student Success: Personalized Success Plan </span></td></tr></table>"; html += "<table width='100%'><tr><td style='width:45%;'>Success Steps For:<br /><b>First Name :</b>" + stdnt.FirstName + " <b>Last Name :</b> " + stdnt.LastName + "</td><td> <div style='background-color: #C0C0C0;float:left;width:20%;'>Program </div><div style='padding-left:10px;border:solid 1px black;width:75%; float:left;'>" + stdnt.MajorProgramEnrollment + "</div></td></tr></table>"; //ass.GetAssessmentByAssessmentOID(AOID); //if (ass != null) //{ //html += "<table width='100%'><tr><td style='width:45%;'><b>Assessment Name : </b><b>" + ass.AssessmentName + "</b></td><td> </td></tr></table>"; //} html += "<table width='100%'><tr><td style='border:solid 1px black;'>Inventory of Student Success results provide comparsions of your attitudes and confidence with other<br /> entering CVTC students in key focus areas that could affect your academic performance and program<br /> persistance: </td></tr></table>"; //Collection<Interventions> interventions = intervention.GetInterventionByStudentOID(intervention.StudentOID); Collection<Interventions> interventions = new Collection<Interventions>(); interventions = intervention.GetInterventionByAssOID(StdOID, RiskOID,AOID); foreach (Interventions inter in interventions) { //Start html += "<table style='width: 100%;'>"; //Get Sectionwise Student Rank StudentRank studentRank = new StudentRank(); // Collection<StudentRank> _list = studentRank.GetStudentRankByOID(stdnt.StudentOID); int AssessmentOID = 0; //Assessment ass = new Assessment(); // AssessmentOID = ass.GetAssessmentOIDByAssessmentName(ddlAssessment.SelectedItem.Text); // Collection<Assessment> assList = new Collection<Assessment>(); //assList = ass.GetAssessmentBySOID(BannerID); ass.GetAssessmentByAssessmentOID(AOID); if (ass != null) { //foreach (Assessment assessment in assList) //{ Collection<StudentRank> _list = studentRank.GetStudentRankBySOIDandAOID(StdOID, ass.AssessmentOID); //if //for (int i = 0; i < 5; i++) foreach (StudentRank stRank in _list) { html += "<tr>"; html += "<td style='border:solid 1px black;background-color:#727272;width:200px;'>" + stRank.SectionName + "</td>"; html += "<td style='border:solid 1px black;width:50px;text-align:center;'>" + stRank.Rank.ToString() + "</td>"; html += "<td style='border:solid 1px black;'>" + stRank.Comment + "</td>"; html += "</tr>"; //break; } break; //} } html += "</table>"; //End } html += "<table style='width: 100%; border:solid 1px black;'> <tr > <td>COMPASS test scores measure your academic readiness for college coursework in four broad areas:</td> </tr> </table>"; html += " <table style='width: 60%; '> <tr><td style='background-color:#727272;width:200px;'>COMPASS Pre-Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.PrealgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Writing</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassWrittingTestScore + "</td></tr> <tr><td style='background-color:#727272;width:200px;'>COMPASS Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassalgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Reading</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassReadingTestScore + "</td></tr> </table>"; html += "<br/>"; int counter = 0; //Collection<Interventions> interventionsList = intervention.GetInterventionByStudentOID(StdOID,RiskOID); foreach (Interventions inter in interventions) { counter++; #region Printing Checkboxes html += "<table style='width: 100%; '>"; html += "<tr><td style='width:60px;font-size:medium;font-weight:bold;'></td><td style='background-color:#727272;width:100px;'> Assessment Name : </td><td>" + inter .AssessmentName + "</td><td></td></tr>"; html += "<tr><td style='width:60px;font-size:medium;font-weight:bold;'>Step " + counter.ToString() + "</td><td style='background-color:#727272;width:100px;'> Plan Target</td><td>" + inter.DomainName + "</td><td></td></tr>"; html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Intervention</td><td>" + inter.InterventionName + "</td><td></td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>CVTC Advocate </td><td>" + inter.UserName + "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Action Date </td><td>" + inter.LatestActionDate; html += " Prescribed "; if (inter.Prescribed == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Participating "; if (inter.Participating == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Internal "; if (inter.Internal == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Urgent "; if (inter.Urgent == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Completed "; if (inter.Completed == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Contact Date </td><td>" + inter.LatestContact; html += " Email "; if (inter.Email == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Telephone "; if (inter.Telephone == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " In Person "; if (inter.InPerson == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Hand-Off "; if (inter.HandOff == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Testing "; if (inter.Testing == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } #endregion html += "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>Comments : </td><td>" + inter.Comment + "</td></tr>"; html += "</table>"; html += "<br /><br />"; //End }//foreach //html += "<script type =\"text/javascript\">"; //html += "printDiv();"; //html += "</script>"; Response.Write(html.ToString()); //print_div1.InnerHtml = html; }//std } } catch (Exception ex) { } }
public void UpdateStudentDetails(string newFirstName, string newLastName, string newEGN, int newFacultyNumber, StudentRank newRank = StudentRank.Unknown, string newHometown = "Unknown") { this.UpdatePersonalDetails(newFirstName, newLastName, newEGN, newHometown); if (newFacultyNumber == 0) { throw new ArgumentException("Faculty number cannot be zero"); } // this.coursesList = new List<Course>(); // this.GradeList = new List<Grade>(); this.FacultyNumber = newFacultyNumber; this.Rank = newRank; //this.Points = newPoints; }
private void PrintIntervention(int aid, string studentID,string StuEmail) { try { Assessment ass = new Assessment(); ass = ass.GetAssessmentByOID(aid); ResultEmail resultEmail = new ResultEmail(); resultEmail = resultEmail.GetResultEmailByAOID(aid); if (resultEmail == null) return; Student student = new Student().GetStudentByStudentOID(studentID); StringBuilder sb = new StringBuilder(); sb.Append("<table cellpadding='0px' cellspacing='0px' style='width:100%; margin:0px 30px 0px 30px'>"); sb.Append("<tr>"); sb.Append("<td align='center' style='font-size:24px; font-weight:bold;'> " + ass.AssessmentName + " Feedback Report</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>CVTC applicant: <b>" + student.FullName + "</b> Program Interest: <b>" + student.MajorProgramEnrollment + "</b></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td > <br />" + resultEmail.Header + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td ><br /><b>*Your individual Inventory of Student Success assessment results suggest . . .</b><br /></td>"); sb.Append("</tr>"); StudentRank studentRank = new StudentRank(); Collection<StudentRank> studentRankList = studentRank.GetStudentRankBySOIDandAOID(student.StudentOID, ass.AssessmentOID); int i = 0; string txtSign = "", txtComments = ""; sb.Append("<td>"); sb.Append("<table cellpadding='0px' cellspacing='0px' style='width:80%;'>"); foreach (StudentRank SR in studentRankList) { txtComments = SR.Comment; foreach (Section s in ass.SectionList) { if (SR.SectionOID == s.SectionOID) { if (SR.Rank >= s.Medium) { txtSign = "+"; } else if ((SR.Rank < s.Medium) && (SR.Rank >= s.Low)) { txtSign = "~"; } else if ((SR.Rank < s.Low)) { txtSign = "-"; } //else //{ // txtSign = "-"; // //txtComments = ""; //} break; } } if (i % 2 == 0) { sb.Append("<tr>"); sb.Append("<td align='right' valign='middle' style='width:2%'><b>" + txtSign + "</b></td>"); sb.Append("<td style='width:48%; border: thin solid #000000; padding:10px;'> " + txtComments + " </td>"); //sb.Append("<td style='width:48%; border: thin solid #000000; padding:10px;'> " + SR.Rank + " </td>"); } else { sb.Append("<td align='right' valign='middle' style='width:2%'><b>" + txtSign + "</b></td>"); sb.Append("<td style='width:48%; border: thin solid #000000; padding:10px;'> " + txtComments + " </td>"); //sb.Append("<td style='width:48%; border: thin solid #000000; padding:10px;'> " + SR.Rank + " </td>"); sb.Append("</tr>"); } i++; txtSign = ""; txtComments = ""; } if (studentRankList.Count % 2 == 0) { sb.Append("<tr>"); sb.Append("<td colspan='4'><br />*( +above average ~average -below average )</td>"); sb.Append("</tr>"); } else { sb.Append("<td colspan='2'><br /> *( +above average ~average -below average )</td>"); sb.Append("</tr>"); } sb.Append("</table>"); sb.Append("</td>"); sb.Append("<tr>"); sb.Append("<td > <br />" + resultEmail.ShowAboveResult + "</td>"); sb.Append("</tr>"); sb.Append("</table>"); string StudentEmail=null; if (ConfigurationManager.AppSettings["productionMode"].ToString() == "OFF") { StudentEmail = System.Web.Configuration.WebConfigurationManager.AppSettings["asseeementEmail"].ToString(); } else if (ConfigurationManager.AppSettings["productionMode"].ToString() == "ON") { StudentEmail = StuEmail; if (StudentEmail == null || StudentEmail == "") { StudentEmail = System.Web.Configuration.WebConfigurationManager.AppSettings["asseeementEmail"].ToString(); } } this.SendMail(StudentEmail, "Assesment feedback report ", sb.ToString()); //this.SendMail("*****@*****.**", "Assesment feedback report ", sb.ToString()); } catch (Exception ex) { } }
public void ExcludeRanks(StudentRank ranks) { _students.RemoveAll(s => (s.Rank & ranks) != 0); }
private void PrintInterventionAll(int SOID) { try { string html = ""; Interventions inter = new Interventions(); Collection<Interventions> _list = new Collection<Interventions>(); _list = inter.GetInterventionByStudentOID(SOID); //if (inter != null) if (_list.Count != 0) { foreach (Interventions iv in _list) { Student stdnt = new Student(); // stdnt = stdnt.GetStudentByOID(inter.StudentOID); stdnt = stdnt.GetStudentByOID(SOID); if (stdnt != null) { //Create Html html += "<table width='100%' ><tr><td><img alt='Logo' src='../../images/chippewavtc_logo.jpg' /></td><td style='text-align:center;'><span style='font-size:medium;font-weight:bold;'> Steps to Success: CVTC's commitment to helping YOU succeed!</span><br/><span style='text-align:center;'> Inventory of Student Success: Personalized Success Plan </span></td></tr></table>"; html += "<table width='100%'><tr><td style='width:45%;'>Success Steps For:<br />First:" + stdnt.FirstName + " Last: " + stdnt.LastName + "</td><td> <div style='background-color: #C0C0C0;float:left;width:20%;'>Program </div><div style='padding-left:10px;border:solid 1px black;width:75%; float:left;'>" + stdnt.MajorProgramEnrollment + "</div></td></tr></table>"; // html += "<table width='100%'><tr><td>Success Steps For:<br />First: Abdul Last: Karim</td><td> <div style=' background-color: #C0C0C0;float:left;width:20%; '>Program </div><div style='padding-left:10px;border:solid 1px black;width:78%; float:left;'>Information Technology </div></td></tr></table>"; html += "<table width='100%'><tr><td style='border:solid 1px black;'>Inventory of Student Success results provide comparsions of your attitudes and confidence with other<br /> entering CVTC students in key focus areas that could affect your academic performance and program<br /> persistance: </td></tr></table>"; html += "<table style='width: 100%;'>"; //Get Sectionwise Student Rank StudentRank studentRank = new StudentRank(); //Collection<StudentRank> srLIST = studentRank.GetStudentRankBySOIDandAOID(SOID,22); Collection<StudentRank> srLIST = studentRank.GetStudentRankByOID(SOID); //if //for (int i = 0; i < 5; i++) foreach (StudentRank stRank in srLIST) { html += "<tr>"; html += "<td style='border:solid 1px black;background-color:#727272;width:200px;'>" + stRank.SectionName + "</td>"; html += "<td style='border:solid 1px black;width:50px;text-align:center;'>" + stRank.Rank.ToString() + "</td>"; html += "<td style='border:solid 1px black;'>" + stRank.Comment + "</td>"; html += "</tr>"; } html += "</table>"; html += "<table style='width: 100%; border:solid 1px black;'> <tr > <td>COMPASS test scores measure your academic readiness for college coursework in four broad areas:</td> </tr> </table>"; html += " <table style='width: 60%; '> <tr><td style='background-color:#727272;width:200px;'>COMPASS Pre-Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.PrealgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Writing</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassWrittingTestScore + "</td></tr> <tr><td style='background-color:#727272;width:200px;'>COMPASS Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassalgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Reading</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassReadingTestScore + "</td></tr> </table>"; html += "<br/>"; //Last Part Intervention html += "<table style='width: 100%; '>"; html += "<tr><td style='width:60px;font-size:medium;font-weight:bold;'>Step 1</td><td style='background-color:#727272;width:100px;'> Plan Target</td><td>" + inter.DomainName + "</td><td></td></tr>"; html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Intervention</td><td>" + inter.InterventionName + "</td><td></td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>CVTC Advocate </td><td>" + inter.UserName + "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Action Date </td><td>" + inter.LatestActionDate; html += " Prescribed "; if (inter.Prescribed == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Participating "; if (inter.Participating == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Internal "; if (inter.Internal == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Urgent "; if (inter.Urgent == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Completed "; if (inter.Completed == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Contact Date </td><td>" + inter.LatestContact; html += " Email "; if (inter.Email == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Telephone "; if (inter.Telephone == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " In Person "; if (inter.InPerson == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Hand-Off "; if (inter.HandOff == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Testing "; if (inter.Testing == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += "</td></tr>"; html += "</table>"; } } html += "<script type =\"text/javascript\">"; html += "printDiv();"; html += "</script>"; print_div1.InnerHtml = html; } } catch (Exception ex) { } }
public Student(string firstName, string lastName, string egn, int facultyNumber, StudentRank rank = StudentRank.Unknown, string hometown = "Unknown") : base(firstName, lastName, egn, hometown) { //if (facultyNumber == null) //{ // throw new ArgumentNullException("Faculty number cannot be null"); //} if (facultyNumber == 0) { throw new ArgumentException("Faculty number cannot be zero"); } this.coursesList = new List <Course>(); this.GradeList = new List <Grade>(); this.FacultyNumber = facultyNumber; this.Rank = rank; }