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