// Set selection on certain Lessons
public void setSelectionByLessonsList(LessonList list)
{
if (list == null || list.amount() <= 0 || lessons == null)
{
return;
}
for (int j = 0; j < lessons.amount(); j++)
{
for (int i = 0; i < list.amount(); i++)
{
if (list[i].sameValue(lessons[j]))
{
for (int k = 0; k < cards.Length; k++)
{
if (cards[k].getCourseName().Equals(list[i].courseName))
{
if (cards[k].getChecked() != true)
{
cards[k].Checked(true);
}
break;
}
}
lessonChecks.add(lessons[j]);
break;
}
}
}
updateChecksCourse();
}
// Get all the courses of the lessons to new List
private LessonList getLessonsOfCourse(string courseName)
{
LessonList result = new LessonList();
for (int i = 0; i < lessons.amount(); i++)
{
if (lessons[i].courseName.Equals(courseName))
{
result.add(lessons[i]);
}
}
return(result);
}
public static LessonList parserExcelFile(DataTable data)
{
LessonList result = new LessonList();
string[] colNames = getIndexProperties(data);
if (colNames == null)
{
return(null);
}
string name = "";
int year = 4;
foreach (DataRow row in data.Rows)
{
string lecturer = "", type = "", day = "", place = "";
int number = -1, hours = -1, start = -1, end = -1;
try
{
for (int i = 0; i < 10; i++)
{
if (colNames[i] != null && !row[colNames[i]].Equals(""))
{
string text = row[colNames[i]].ToString();
Regex regex = new Regex(@"(שנה (- )?(\w)('))");
Match match = regex.Match(text);
if (match.Success)
{
text = match.ToString();
}
switch (text)
{
case "1":
case "א":
case "א'":
case "שנה א":
case "שנה א'":
case "שנה - א":
case "שנה - א'":
year = 1;
break;
case "2":
case "ב":
case "ב'":
case "שנה ב":
case "שנה ב'":
case "שנה - ב":
case "שנה - ב'":
year = 2;
break;
case "3":
case "ג":
case "ג'":
case "שנה ג":
case "שנה ג'":
case "שנה - ג":
case "שנה - ג'":
year = 3;
break;
case "4":
case "ד":
case "ד'":
case "שנה ד":
case "שנה ד'":
case "שנה - ד":
case "שנה - ד'":
year = 4;
break;
default:
break;
}
switch (i)
{
case 0: // year
break;
case 1: // course name
if (!text.Equals(""))
{
name = text;
}
break;
case 2: // lecturer
lecturer = text;
break;
case 3: // day !work
switch (text)
{
case "א":
case "א'":
case "ראשון":
case "1":
day = "א";
break;
case "ב":
case "ב'":
case "שני":
case "2":
day = "ב";
break;
case "ג":
case "ג'":
case "שלישי":
case "3":
day = "ג";
break;
case "ד":
case "ד'":
case "רביעי":
case "4":
day = "ד";
break;
case "ה":
case "ה'":
case "חמישי":
case "5":
day = "ה";
break;
case "ו":
case "ו'":
case "שישי":
case "6":
day = "ו";
break;
}
break;
case 4: // start !work
start = returnTime(text, true);
break;
case 5: // end !work
end = returnTime(text, false);
break;
case 6: //week hours
try {
hours = end - start;
if (hours <= 0)
{
hours = Int32.Parse(text);
}
}
catch {
hours = 0;
};
break;
case 7: // class name
place = text;
break;
case 8: // number lesson
try {
number = Int32.Parse(text);
}
catch {
number = 1;
};
break;
case 9: // type
switch (text)
{
case "הרצאה":
case "ה":
type = "ה";
break;
case "תרגול":
case "ת":
type = "ת";
break;
case "מעבדה":
case "מ":
type = "מ";
break;
default:
type = "ת";
break;
}
break;
}
}
}
Lesson l = new Lesson(name, type, number, lecturer, day, start, end, end - start, year, place);
result.add(l);
}
catch
{
}
}
return(result);
}
public void addTest()
{
Assert.IsTrue(list2.isSameLessonList(list2.add(l)));
}
