public void testaddCommentsFromXML()
{
XmlDocument doc = new XmlDocument();
Student stud = new Student();
Comment comm = new Comment();
Period period = new Period();
period.PeriodID = 1;
period.PeriodName = "Term1";
////stud.StudentID = "95-0072";
////stud.FirstName = "Abbey Geraldine";
////stud.LastName = "Matibag";
////comm.CommentText = "Abbey tries very hard";
stud.StudentID = "08-0204";
stud.FirstName = "Armina";
stud.LastName = "Bago";
comm.CommentText = "Armina is an excellent student";
//stud.StudentID = "04-0140";
//stud.FirstName = "Beatrice Louee";
//stud.LastName = "Antonio";
//comm.CommentText = "Beatrice was fantastic this term definitely!";
//period.PeriodComment.CommentText = comm.CommentText;
doc.Load(@"c:\XML\XML Homeroom_template.xml");
//EGPXMLParser.parseHomeroomXML(FrontController.getInstance().getStudentController(), doc);
//System.Windows.Forms.MessageBox.Show(controller.getStudent(stud.StudentID).StudentID);
//System.Windows.Forms.MessageBox.Show(this.controller.getStudent(stud.StudentID).StudentID);
//System.Windows.Forms.MessageBox.Show(controller.getPeriod(this.controller.getStudent(stud.StudentID), period.PeriodID).PeriodComment.CommentText);
//Assert.AreEqual(controller.getPeriod(this.controller.getStudent(stud.StudentID), period.PeriodID).PeriodComment.CommentText.Equals(comm.CommentText), true);
//Assert.AreEqual(comm.CommentText,controller.getStudent(stud.StudentID).RptCard.Periods.Find(delegate(Period per) {return per.PeriodComment.CommentText.Equals(comm.CommentText);}).PeriodComment.CommentText);
Assert.AreEqual(comm.CommentText, controller.getPeriod(controller.getStudent(stud.StudentID), period.PeriodID).PeriodComment.Find(delegate(Comment comment) { return(comment.CommentText.Equals(comm.CommentText)); }).CommentText);
}
public void testAddNewStudent()
{
//contoller = new FrontController().getStudentController();
Student std = new Student();
std.StudentID = "123";
std.FirstName = "any";
int asd = contoller.getAllStudents().Count;
contoller.addOrUpdateStudent(std);
int sample2 = contoller.getAllStudents().Count;
Assert.AreEqual(contoller.getStudent("123"), std);
Assert.AreEqual(contoller.getStudent("123").FirstName, std.FirstName);
Assert.AreNotEqual(contoller.getAllStudents().Count, asd);
Assert.AreEqual(sample2, contoller.getAllStudents().Count);
}
private static void addAttendanceFromXML(IStudentController controller, String doc)
{
#region codes
//try
//{
// XmlNodeList primelist = doc.SelectNodes("easygradepro/class");
// foreach (XmlNode primenode in primelist)
// {
// XmlNodeList peroidlist = primenode.SelectNodes("classrecord");
// XmlNodeList studentinfo = primenode.SelectNodes("student");
// foreach (XmlNode student in studentinfo)
// {
// Student idgeter = new Student();
// idgeter.StudentID = student.ChildNodes[0].ChildNodes[0].InnerText;
// //String idgeter = "";
// //idgeter = student.ChildNodes[0].ChildNodes[0].InnerText;
// XmlNodeList attend = student.SelectNodes("stud_attendance/stud_att_totals/stud_att_mastercat");
// foreach (XmlNode period in peroidlist)
// {
// Attendance a = new Attendance();
// Period p = new Period();
// p.PeriodID = Int32.Parse(period.ChildNodes[1].InnerText);
// p.PeriodName = period.ChildNodes[2].InnerText;
// Double exabsent = 0;
// Double absent = 0;
// Double total = 0;
// Double tardy = 0;
// foreach (XmlNode attendance in attend)
// {
// if (attendance.Attributes["cat"].Value == "Excused Absence")
// {
// //change "" to 0
// if (attendance.InnerText != "")
// {
// exabsent = Convert.ToDouble(attendance.InnerText);
// }
// else
// { exabsent = 0; }
// }
// if (attendance.Attributes["cat"].Value == "Unexcused Absence")
// {
// //change "" to 0
// if (attendance.InnerText != "")
// {
// absent = Convert.ToDouble(attendance.InnerText);
// }
// else
// {
// absent = 0;
// }
// }
// total = exabsent + absent;
// a.DaysAbsent = total;
// if (attendance.Attributes["cat"].Value == "Tardy")
// {
// //change "" to 0
// if (attendance.InnerText != "")
// {
// tardy = Convert.ToDouble(attendance.InnerText);
// }
// else { tardy = 0; }
// }
// a.DaysTardy = tardy;
// controller.addOrUpdateAttendance(controller.getStudent(idgeter.StudentID), a, p);
// }
// }
// }
// }
//}
//catch (Exception er)
//{
// System.Windows.Forms.MessageBox.Show(er.Message,"Attendance catcher!!!");
//}
#endregion
double ab = 0;
double ex = 0;
double tardy = 0;
try
{
myReader = new StreamReader(doc);
String loadedString = null;
while ((loadedString = myReader.ReadLine()) != null)
{
Student stud = new Student();
Attendance att = new Attendance();
Period p = new Period();
String[] studentDetails = loadedString.Split('\t');
stud.StudentID = studentDetails[0];
stud.FirstName = studentDetails[1];
stud.LastName = studentDetails[2];
if (studentDetails[3].ToString() != "") ex = Convert.ToDouble(studentDetails[3]);
else ex = 0;
if (studentDetails[4].ToString() != "") ab = Convert.ToDouble(studentDetails[4]);
else ab = 0;
if (studentDetails[5].ToString() != "") tardy = Convert.ToDouble(studentDetails[5]);
else tardy = 0;
p.PeriodID = 1;
p.PeriodName = "Term 1";
att.DaysAbsent = ex + ab;
att.DaysTardy = tardy;
controller.addOrUpdateAttendance(controller.getStudent(stud.StudentID), att, p);
}
myReader.Close();
}
catch (Exception er)
{
System.Windows.Forms.MessageBox.Show(er.Message, "Unable to run the File");
}
}
private static void addSkillsFromXML(IStudentController controller, String doc)
{
#region codes
//XmlNodeList primelist = doc.SelectNodes("easygradepro/class");
//foreach (XmlNode primenode in primelist)
//{
// XmlNodeList periodList = primenode.SelectNodes("classrecord");
// XmlNodeList studentinfo = primenode.SelectNodes("student");
// XmlNodeList gradename = primenode.SelectNodes("standards/standard");
// Dictionary<String, String> skillNames = new Dictionary<string, string>();
// foreach (XmlNode test in gradename)
// {
// Skill skill = new Skill();
// skill.SkillID = test.ChildNodes[0].InnerText;
// skill.SkillName = test.ChildNodes[3].InnerText;
// skillNames.Add(skill.SkillID, skill.SkillName);
// }
// foreach (XmlNode student in studentinfo)
// {
// //String adviser;
// Student idgeter = new Student();
// idgeter.StudentID = student.ChildNodes[0].ChildNodes[0].InnerText;
// idgeter.LastName = student.ChildNodes[0].ChildNodes[3].InnerText;
// idgeter.FirstName = student.ChildNodes[0].ChildNodes[4].InnerText;
// XmlNodeList gradeinfo = student.SelectNodes("stud_grades/stud_stdgrades");
// foreach (XmlNode test in periodList)
// {
// Period period = new Period();
// period.PeriodID = Int32.Parse(test.ChildNodes[1].InnerText);
// period.PeriodName = test.ChildNodes[2].InnerText;
// //adviser = test.ChildNodes[8].InnerText;
// controller.addOrUpdatePeriod(controller.getStudent(idgeter.StudentID), period);
// foreach (XmlNode grade in gradeinfo)
// {
// if (grade.HasChildNodes == true)
// {
// XmlNodeList stdgradeinfo = grade.SelectNodes("stud_stdgrade");
// foreach (XmlNode stdgrade in stdgradeinfo)
// {
// Skill skilltostore = new Skill();
// skilltostore.SkillID = stdgrade.ChildNodes[0].InnerText;
// skilltostore.SkillName = skillNames[skilltostore.SkillID];
// if (stdgrade.ChildNodes[1].InnerText == "" || stdgrade.ChildNodes[2].InnerText == "")
// {
// skilltostore.NumericGrade = 0.0;
// skilltostore.LetterGrade = "N/A";
// }
// else
// {
// skilltostore.NumericGrade = double.Parse(stdgrade.ChildNodes[1].InnerText);
// skilltostore.LetterGrade = stdgrade.ChildNodes[2].InnerText;
// }
// //idgeter.Adviser = adviser;
// controller.addOrUpdateSkill(controller.getStudent(idgeter.StudentID), skilltostore, controller.getPeriod(controller.getStudent(idgeter.StudentID), period.PeriodID));
// }
// }
// else
// {
// break;
// }
// }
// }
// }
//}
#endregion
try
{
myReader = new StreamReader(doc);
}
catch (Exception er)
{
System.Windows.Forms.MessageBox.Show(er.Message, "Unable to run the File");
}
String loadedString = null;
Student stud = new Student();
while ((loadedString = myReader.ReadLine()) != null)
{
String[] studentDetails = loadedString.Split('\t');
stud.StudentID = studentDetails[0];
Period period = new Period();
period.PeriodID = Convert.ToInt32(studentDetails[3].Substring(5,1));
controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), period);
int term1Counter = 8;
while (term1Counter <= 68)
{
Skill Skill = new Skill();
Skill.SkillID = studentDetails[term1Counter];
if (Skill.SkillID != "A" || Skill.SkillID != "B" || Skill.SkillID != "C" || Skill.SkillID != "D" || Skill.SkillID != "E")
{
if (studentDetails[term1Counter + 1] != "")
{
String[] skillGrades = studentDetails[term1Counter + 1].Split('/');
Skill.NumericGrade = Convert.ToDouble(skillGrades[0]);
Skill.LetterGrade = skillGrades[1];
}
else
{
//Grade.SubjectID = studentDetails[4].Substring(0, 4);
Skill.LetterGrade = "N/A";
Skill.NumericGrade = 0;
}
}
term1Counter += 2;
controller.addOrUpdateSkill(controller.getStudent(stud.StudentID), Skill, controller.getPeriod(controller.getStudent(stud.StudentID), period.PeriodID));
}
}
}
private static void addGradesFromXML(IStudentController controller, String doc)
{
#region codes
//XmlNodeList primelist = doc.SelectNodes("easygradepro/class");
//foreach (XmlNode primenode in primelist)
//{
// XmlNodeList peroidlist = primenode.SelectNodes("classrecord");
// XmlNodeList studentinfo = primenode.SelectNodes("student");
// XmlNodeList gradename = primenode.SelectNodes("assignments/assignment");
// foreach (XmlNode student in studentinfo)
// {
// Student idgeter = new Student();
// idgeter.StudentID = student.ChildNodes[0].ChildNodes[0].InnerText;
// XmlNodeList gradeinfo = student.SelectNodes("stud_grades/overall");
// foreach (XmlNode test in peroidlist)
// {
// Grade Grade = new Grade();
// Period period = new Period();
// period.PeriodID = Int32.Parse(test.ChildNodes[1].InnerText);
// period.PeriodName = test.ChildNodes[2].InnerText;
// Grade.SubjectID = test.ChildNodes[4].InnerText;
// Grade.SubjectCategory = test.ChildNodes[5].InnerText;
// Grade.SubjectName = test.ChildNodes[0].InnerText;
// controller.addOrUpdatePeriod(controller.getStudent(idgeter.StudentID), period);
// foreach (XmlNode grade in gradeinfo)
// {
// if (grade.ChildNodes[2].InnerText != "")
// {
// Grade.NumericGrade = double.Parse(grade.ChildNodes[0].InnerText);
// Grade.LetterGrade = grade.ChildNodes[2].InnerText;
// controller.addOrUpdateGrade(controller.getStudent(idgeter.StudentID), Grade, controller.getPeriod(controller.getStudent(idgeter),period.PeriodID));
// }
// }
// }
// }
//}
#endregion
try
{
myReader = new StreamReader(doc);
String loadedString = null;
Student stud = new Student();
while ((loadedString = myReader.ReadLine()) != null)
{
String[] studentDetails = loadedString.Split('\t');
stud.StudentID = studentDetails[0];
Grade Grade = new Grade();
Period period = new Period();
if (studentDetails[9] != null)
{
period.PeriodID = 1;
period.PeriodName = "Term 1";
controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), period);
if (studentDetails[8] != "" && studentDetails[9] != "")
{
Grade.SubjectID = studentDetails[4].Substring(0, 4);
//Grade.SubjectID = studentDetails[4];
Grade.LetterGrade = studentDetails[9];
Grade.NumericGrade = Convert.ToDouble(studentDetails[8]);
}
else
{
Grade.SubjectID = studentDetails[4].Substring(0, 4);
//Grade.SubjectID = studentDetails[4];
Grade.LetterGrade = "N/A";
Grade.NumericGrade = 0;
}
controller.addOrUpdateGrade(controller.getStudent(stud.StudentID), Grade, controller.getPeriod(controller.getStudent(stud), period.PeriodID));
}
//if (studentDetails[11] != null)
//{
// period.PeriodID = 2;
// period.PeriodName = "Term 2";
// controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), period);
// if (studentDetails[10] != "")
// {
// //Grade.SubjectID = studentDetails[4].Substring(0, 4);
// Grade.SubjectID = studentDetails[4];
// Grade.LetterGrade = studentDetails[11];
// Grade.NumericGrade = Convert.ToDouble(studentDetails[10]);
// }
// else
// {
// //Grade.SubjectID = studentDetails[4].Substring(0, 4);
// Grade.SubjectID = studentDetails[4];
// Grade.LetterGrade = "";
// Grade.NumericGrade = 0;
// }
// controller.addOrUpdateGrade(controller.getStudent(stud.StudentID), Grade, controller.getPeriod(controller.getStudent(stud), period.PeriodID));
//}
//if (studentDetails[13] != null)
//{
// period.PeriodID = 3;
// period.PeriodName = "Term 3";
// controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), period);
// if (studentDetails[12] != "")
// {
// //Grade.SubjectID = studentDetails[4].Substring(0, 4);
// Grade.SubjectID = studentDetails[4];
// Grade.LetterGrade = studentDetails[13];
// Grade.NumericGrade = Convert.ToDouble(studentDetails[12]);
// }
// else
// {
// //Grade.SubjectID = studentDetails[4].Substring(0, 4);
// Grade.SubjectID = studentDetails[4];
// Grade.LetterGrade = "";
// Grade.NumericGrade = 0;
// }
// controller.addOrUpdateGrade(controller.getStudent(stud.StudentID), Grade, controller.getPeriod(controller.getStudent(stud), period.PeriodID));
//}
}
myReader.Close();
}
catch (Exception er)
{
System.Windows.Forms.MessageBox.Show(er.Message, "Unable to run the File");
}
}
private static void addCommentsFromXML(IStudentController controller, String doc)
{
#region codes
//XmlNodeList primelist = doc.SelectNodes("easygradepro/class");
//Dictionary<string, string> subjectname = new Dictionary<string, string>();
//foreach (XmlNode primenode in primelist)
//{
// XmlNodeList peroidlist = primenode.SelectNodes("classrecord");
// XmlNodeList assignlst = primenode.SelectNodes("assignments/assignment");
// XmlNodeList studentinfo = primenode.SelectNodes("student");
// foreach (XmlNode test in peroidlist)
// {
// Period period = new Period();
// period.PeriodID = Int32.Parse(test.ChildNodes[1].InnerText);
// period.PeriodName = test.ChildNodes[2].InnerText;
// foreach (XmlNode student in studentinfo)
// {
// String studid = student.ChildNodes[0].ChildNodes[0].InnerText;
// XmlNodeList comment = student.SelectNodes("stud_grades/score/score_note");
// foreach (XmlNode commentcontainer in comment)
// {
// if (commentcontainer.InnerText != "")
// {
// Comment cmt = new Comment();
// cmt.CommentText = commentcontainer.InnerText;
// controller.addOrUpdatePeriod(controller.getStudent(studid), period);
// controller.getPeriod(controller.getStudent(studid), period.PeriodID).PeriodComment.Add(cmt);
// }
// }
// }
// }
//}
#endregion
try
{
myReader = new StreamReader(doc);
}
catch (Exception er)
{
System.Windows.Forms.MessageBox.Show(er.Message, "Unable to run the File");
}
try
{
String loadedString = null;
while ((loadedString = myReader.ReadLine()) != null)
{
Student stud = new Student();
Period p = new Period();
Comment cmt = new Comment();
String[] studentDetails = loadedString.Split('\t');
stud.StudentID = studentDetails[0];
stud.FirstName = studentDetails[1];
stud.LastName = studentDetails[2];
if (studentDetails[3] != null)
{
p.PeriodID = 1;
p.PeriodName = "Term 1";
cmt.CommentText = studentDetails[3];
controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), p);
controller.getPeriod(controller.getStudent(stud.StudentID), p.PeriodID).PeriodComment.Add(cmt);
}
}
myReader.Close();
}
catch
{
}
}
private static void addSkillsFromXML(IStudentController controller, String doc)
{
#region codes
//XmlNodeList primelist = doc.SelectNodes("easygradepro/class");
//foreach (XmlNode primenode in primelist)
//{
// XmlNodeList periodList = primenode.SelectNodes("classrecord");
// XmlNodeList studentinfo = primenode.SelectNodes("student");
// XmlNodeList gradename = primenode.SelectNodes("standards/standard");
// Dictionary<String, String> skillNames = new Dictionary<string, string>();
// foreach (XmlNode test in gradename)
// {
// Skill skill = new Skill();
// skill.SkillID = test.ChildNodes[0].InnerText;
// skill.SkillName = test.ChildNodes[3].InnerText;
// skillNames.Add(skill.SkillID, skill.SkillName);
// }
// foreach (XmlNode student in studentinfo)
// {
// //String adviser;
// Student idgeter = new Student();
// idgeter.StudentID = student.ChildNodes[0].ChildNodes[0].InnerText;
// idgeter.LastName = student.ChildNodes[0].ChildNodes[3].InnerText;
// idgeter.FirstName = student.ChildNodes[0].ChildNodes[4].InnerText;
// XmlNodeList gradeinfo = student.SelectNodes("stud_grades/stud_stdgrades");
// foreach (XmlNode test in periodList)
// {
// Period period = new Period();
// period.PeriodID = Int32.Parse(test.ChildNodes[1].InnerText);
// period.PeriodName = test.ChildNodes[2].InnerText;
// //adviser = test.ChildNodes[8].InnerText;
// controller.addOrUpdatePeriod(controller.getStudent(idgeter.StudentID), period);
// foreach (XmlNode grade in gradeinfo)
// {
// if (grade.HasChildNodes == true)
// {
// XmlNodeList stdgradeinfo = grade.SelectNodes("stud_stdgrade");
// foreach (XmlNode stdgrade in stdgradeinfo)
// {
// Skill skilltostore = new Skill();
// skilltostore.SkillID = stdgrade.ChildNodes[0].InnerText;
// skilltostore.SkillName = skillNames[skilltostore.SkillID];
// if (stdgrade.ChildNodes[1].InnerText == "" || stdgrade.ChildNodes[2].InnerText == "")
// {
// skilltostore.NumericGrade = 0.0;
// skilltostore.LetterGrade = "N/A";
// }
// else
// {
// skilltostore.NumericGrade = double.Parse(stdgrade.ChildNodes[1].InnerText);
// skilltostore.LetterGrade = stdgrade.ChildNodes[2].InnerText;
// }
// //idgeter.Adviser = adviser;
// controller.addOrUpdateSkill(controller.getStudent(idgeter.StudentID), skilltostore, controller.getPeriod(controller.getStudent(idgeter.StudentID), period.PeriodID));
// }
// }
// else
// {
// break;
// }
// }
// }
// }
//}
#endregion
try
{
myReader = new StreamReader(doc);
}
catch (Exception er)
{
System.Windows.Forms.MessageBox.Show(er.Message, "Unable to run the File");
}
String loadedString = null;
Student stud = new Student();
while ((loadedString = myReader.ReadLine()) != null)
{
String[] studentDetails = loadedString.Split('\t');
stud.StudentID = studentDetails[0];
Period period = new Period();
period.PeriodID = Convert.ToInt32(studentDetails[3].Substring(5, 1));
controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), period);
int term1Counter = 8;
while (term1Counter <= 68)
{
Skill Skill = new Skill();
Skill.SkillID = studentDetails[term1Counter];
if (Skill.SkillID != "A" || Skill.SkillID != "B" || Skill.SkillID != "C" || Skill.SkillID != "D" || Skill.SkillID != "E")
{
if (studentDetails[term1Counter + 1] != "")
{
String[] skillGrades = studentDetails[term1Counter + 1].Split('/');
Skill.NumericGrade = Convert.ToDouble(skillGrades[0]);
Skill.LetterGrade = skillGrades[1];
}
else
{
//Grade.SubjectID = studentDetails[4].Substring(0, 4);
Skill.LetterGrade = "N/A";
Skill.NumericGrade = 0;
}
}
term1Counter += 2;
controller.addOrUpdateSkill(controller.getStudent(stud.StudentID), Skill, controller.getPeriod(controller.getStudent(stud.StudentID), period.PeriodID));
}
}
}
private static void addCommentsFromXML(IStudentController controller, String doc)
{
#region codes
//XmlNodeList primelist = doc.SelectNodes("easygradepro/class");
//Dictionary<string, string> subjectname = new Dictionary<string, string>();
//foreach (XmlNode primenode in primelist)
//{
// XmlNodeList peroidlist = primenode.SelectNodes("classrecord");
// XmlNodeList assignlst = primenode.SelectNodes("assignments/assignment");
// XmlNodeList studentinfo = primenode.SelectNodes("student");
// foreach (XmlNode test in peroidlist)
// {
// Period period = new Period();
// period.PeriodID = Int32.Parse(test.ChildNodes[1].InnerText);
// period.PeriodName = test.ChildNodes[2].InnerText;
// foreach (XmlNode student in studentinfo)
// {
// String studid = student.ChildNodes[0].ChildNodes[0].InnerText;
// XmlNodeList comment = student.SelectNodes("stud_grades/score/score_note");
// foreach (XmlNode commentcontainer in comment)
// {
// if (commentcontainer.InnerText != "")
// {
// Comment cmt = new Comment();
// cmt.CommentText = commentcontainer.InnerText;
// controller.addOrUpdatePeriod(controller.getStudent(studid), period);
// controller.getPeriod(controller.getStudent(studid), period.PeriodID).PeriodComment.Add(cmt);
// }
// }
// }
// }
//}
#endregion
try
{
myReader = new StreamReader(doc);
}
catch (Exception er)
{
System.Windows.Forms.MessageBox.Show(er.Message, "Unable to run the File");
}
try
{
String loadedString = null;
while ((loadedString = myReader.ReadLine()) != null)
{
Student stud = new Student();
Period p = new Period();
Comment cmt = new Comment();
String[] studentDetails = loadedString.Split('\t');
stud.StudentID = studentDetails[0];
stud.FirstName = studentDetails[1];
stud.LastName = studentDetails[2];
if (studentDetails[3] != null)
{
p.PeriodID = 1;
p.PeriodName = "Term 1";
cmt.CommentText = studentDetails[3];
controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), p);
controller.getPeriod(controller.getStudent(stud.StudentID), p.PeriodID).PeriodComment.Add(cmt);
}
}
myReader.Close();
}
catch
{
}
}
private static void addAttendanceFromXML(IStudentController controller, String doc)
{
#region codes
//try
//{
// XmlNodeList primelist = doc.SelectNodes("easygradepro/class");
// foreach (XmlNode primenode in primelist)
// {
// XmlNodeList peroidlist = primenode.SelectNodes("classrecord");
// XmlNodeList studentinfo = primenode.SelectNodes("student");
// foreach (XmlNode student in studentinfo)
// {
// Student idgeter = new Student();
// idgeter.StudentID = student.ChildNodes[0].ChildNodes[0].InnerText;
// //String idgeter = "";
// //idgeter = student.ChildNodes[0].ChildNodes[0].InnerText;
// XmlNodeList attend = student.SelectNodes("stud_attendance/stud_att_totals/stud_att_mastercat");
// foreach (XmlNode period in peroidlist)
// {
// Attendance a = new Attendance();
// Period p = new Period();
// p.PeriodID = Int32.Parse(period.ChildNodes[1].InnerText);
// p.PeriodName = period.ChildNodes[2].InnerText;
// Double exabsent = 0;
// Double absent = 0;
// Double total = 0;
// Double tardy = 0;
// foreach (XmlNode attendance in attend)
// {
// if (attendance.Attributes["cat"].Value == "Excused Absence")
// {
// //change "" to 0
// if (attendance.InnerText != "")
// {
// exabsent = Convert.ToDouble(attendance.InnerText);
// }
// else
// { exabsent = 0; }
// }
// if (attendance.Attributes["cat"].Value == "Unexcused Absence")
// {
// //change "" to 0
// if (attendance.InnerText != "")
// {
// absent = Convert.ToDouble(attendance.InnerText);
// }
// else
// {
// absent = 0;
// }
// }
// total = exabsent + absent;
// a.DaysAbsent = total;
// if (attendance.Attributes["cat"].Value == "Tardy")
// {
// //change "" to 0
// if (attendance.InnerText != "")
// {
// tardy = Convert.ToDouble(attendance.InnerText);
// }
// else { tardy = 0; }
// }
// a.DaysTardy = tardy;
// controller.addOrUpdateAttendance(controller.getStudent(idgeter.StudentID), a, p);
// }
// }
// }
// }
//}
//catch (Exception er)
//{
// System.Windows.Forms.MessageBox.Show(er.Message,"Attendance catcher!!!");
//}
#endregion
double ab = 0;
double ex = 0;
double tardy = 0;
try
{
myReader = new StreamReader(doc);
String loadedString = null;
while ((loadedString = myReader.ReadLine()) != null)
{
Student stud = new Student();
Attendance att = new Attendance();
Period p = new Period();
String[] studentDetails = loadedString.Split('\t');
stud.StudentID = studentDetails[0];
stud.FirstName = studentDetails[1];
stud.LastName = studentDetails[2];
if (studentDetails[3].ToString() != "")
{
ex = Convert.ToDouble(studentDetails[3]);
}
else
{
ex = 0;
}
if (studentDetails[4].ToString() != "")
{
ab = Convert.ToDouble(studentDetails[4]);
}
else
{
ab = 0;
}
if (studentDetails[5].ToString() != "")
{
tardy = Convert.ToDouble(studentDetails[5]);
}
else
{
tardy = 0;
}
p.PeriodID = 1;
p.PeriodName = "Term 1";
att.DaysAbsent = ex + ab;
att.DaysTardy = tardy;
controller.addOrUpdateAttendance(controller.getStudent(stud.StudentID), att, p);
}
myReader.Close();
}
catch (Exception er)
{
System.Windows.Forms.MessageBox.Show(er.Message, "Unable to run the File");
}
}
private static void addGradesFromXML(IStudentController controller, String doc)
{
#region codes
//XmlNodeList primelist = doc.SelectNodes("easygradepro/class");
//foreach (XmlNode primenode in primelist)
//{
// XmlNodeList peroidlist = primenode.SelectNodes("classrecord");
// XmlNodeList studentinfo = primenode.SelectNodes("student");
// XmlNodeList gradename = primenode.SelectNodes("assignments/assignment");
// foreach (XmlNode student in studentinfo)
// {
// Student idgeter = new Student();
// idgeter.StudentID = student.ChildNodes[0].ChildNodes[0].InnerText;
// XmlNodeList gradeinfo = student.SelectNodes("stud_grades/overall");
// foreach (XmlNode test in peroidlist)
// {
// Grade Grade = new Grade();
// Period period = new Period();
// period.PeriodID = Int32.Parse(test.ChildNodes[1].InnerText);
// period.PeriodName = test.ChildNodes[2].InnerText;
// Grade.SubjectID = test.ChildNodes[4].InnerText;
// Grade.SubjectCategory = test.ChildNodes[5].InnerText;
// Grade.SubjectName = test.ChildNodes[0].InnerText;
// controller.addOrUpdatePeriod(controller.getStudent(idgeter.StudentID), period);
// foreach (XmlNode grade in gradeinfo)
// {
// if (grade.ChildNodes[2].InnerText != "")
// {
// Grade.NumericGrade = double.Parse(grade.ChildNodes[0].InnerText);
// Grade.LetterGrade = grade.ChildNodes[2].InnerText;
// controller.addOrUpdateGrade(controller.getStudent(idgeter.StudentID), Grade, controller.getPeriod(controller.getStudent(idgeter),period.PeriodID));
// }
// }
// }
// }
//}
#endregion
try
{
myReader = new StreamReader(doc);
String loadedString = null;
Student stud = new Student();
while ((loadedString = myReader.ReadLine()) != null)
{
String[] studentDetails = loadedString.Split('\t');
stud.StudentID = studentDetails[0];
Grade Grade = new Grade();
Period period = new Period();
if (studentDetails[9] != null)
{
period.PeriodID = 1;
period.PeriodName = "Term 1";
controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), period);
if (studentDetails[8] != "" && studentDetails[9] != "")
{
Grade.SubjectID = studentDetails[4].Substring(0, 4);
//Grade.SubjectID = studentDetails[4];
Grade.LetterGrade = studentDetails[9];
Grade.NumericGrade = Convert.ToDouble(studentDetails[8]);
}
else
{
Grade.SubjectID = studentDetails[4].Substring(0, 4);
//Grade.SubjectID = studentDetails[4];
Grade.LetterGrade = "N/A";
Grade.NumericGrade = 0;
}
controller.addOrUpdateGrade(controller.getStudent(stud.StudentID), Grade, controller.getPeriod(controller.getStudent(stud), period.PeriodID));
}
//if (studentDetails[11] != null)
//{
// period.PeriodID = 2;
// period.PeriodName = "Term 2";
// controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), period);
// if (studentDetails[10] != "")
// {
// //Grade.SubjectID = studentDetails[4].Substring(0, 4);
// Grade.SubjectID = studentDetails[4];
// Grade.LetterGrade = studentDetails[11];
// Grade.NumericGrade = Convert.ToDouble(studentDetails[10]);
// }
// else
// {
// //Grade.SubjectID = studentDetails[4].Substring(0, 4);
// Grade.SubjectID = studentDetails[4];
// Grade.LetterGrade = "";
// Grade.NumericGrade = 0;
// }
// controller.addOrUpdateGrade(controller.getStudent(stud.StudentID), Grade, controller.getPeriod(controller.getStudent(stud), period.PeriodID));
//}
//if (studentDetails[13] != null)
//{
// period.PeriodID = 3;
// period.PeriodName = "Term 3";
// controller.addOrUpdatePeriod(controller.getStudent(stud.StudentID), period);
// if (studentDetails[12] != "")
// {
// //Grade.SubjectID = studentDetails[4].Substring(0, 4);
// Grade.SubjectID = studentDetails[4];
// Grade.LetterGrade = studentDetails[13];
// Grade.NumericGrade = Convert.ToDouble(studentDetails[12]);
// }
// else
// {
// //Grade.SubjectID = studentDetails[4].Substring(0, 4);
// Grade.SubjectID = studentDetails[4];
// Grade.LetterGrade = "";
// Grade.NumericGrade = 0;
// }
// controller.addOrUpdateGrade(controller.getStudent(stud.StudentID), Grade, controller.getPeriod(controller.getStudent(stud), period.PeriodID));
//}
}
myReader.Close();
}
catch (Exception er)
{
System.Windows.Forms.MessageBox.Show(er.Message, "Unable to run the File");
}
}