/// <summary>
/// Overrides own Prioritys from the Prioritys from Parameter student
/// </summary>
/// <param name="student">Student what shall override</param>
public void addPrioritys(Student student)
{
for(int i = 0; i < student.Prioritys.Count; i++){
if (student.Prioritys[i] != null && student.Prioritys[i].Value.Length > 0 && student.Prioritys[i].Value != "Noch nicht abgestimmt")
{
if (this.Prioritys.Count >= student.Prioritys[i].Prio)
{
this.Prioritys.Add(student.Prioritys[i]);
}
else
{
this.Prioritys[student.Prioritys[i].Prio] = student.Prioritys[i];
}
}
}
}
public bool addStudent(Student objStudent)
{
if (!this.findStudent(objStudent) && objStudent.countCourses > 0)
{
if (this.objStudents.Count >= iMaxPlaces)//Course full
{
return false;
}
else
{
this.objStudents.Add(objStudent);
return true;
}
}
else
{
return false;
}
}
public bool Equals(Student tmpStudent)
{
if (tmpStudent != null && tmpStudent.ID == this.ID)
{
return true;
}
else
{
return false;
}
}
public static void readExcelData(object objFile, string sStudentXMLPath)
{
String sFile = objFile.ToString();//Parameter to String
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
int rCnt = 0;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(sFile, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
List<Student> objStudents = new List<Student>();
int iStudentsIndex = 0;
#region getPriority from PathName
string[] tmpPathSplits = sFile.Split(' ');
int priotity = -1;
bool bCountCourses = false;
try
{
priotity = Convert.ToInt32(Regex.Match(tmpPathSplits[(tmpPathSplits.Length - 2)], @"\d+").Value) - 1;
}
catch (FormatException)
{
bCountCourses = true;
}
#endregion
//Gehe das ganze Tabellenblatt durch
for (rCnt = 2; rCnt <= range.Rows.Count; rCnt++)//Startet von 2. Zeile wegen Überschriften
{
//Hier haben wir Zugriff auf jede Zeile
if ((range.Cells[rCnt, 1] as Excel.Range).Value2 != null)
{
string sName = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2;
string sSurname = (string)(range.Cells[rCnt, 2] as Excel.Range).Value2;
string sID = (string)(range.Cells[rCnt, 3] as Excel.Range).Value2;
string sGroup = (string)(range.Cells[rCnt, 4] as Excel.Range).Value2;
string sAnswer = Convert.ToString((range.Cells[rCnt, 5] as Excel.Range).Value2);
//Calculation of new ID
if(sID.Length > 30){
sID = sID.Substring(sID.Length - 28, 27);
}
if (sID == null || sID.Length < 2)
{
sID = "ID" + sName + "x" + sSurname;
}
Student tmpStudent = new Student(sName, sSurname, sID, sGroup);
tmpStudent.setChoose(priotity, sAnswer, bCountCourses);
objStudents.Add(tmpStudent);
++iStudentsIndex;
}
}
StudentsList objStudentsList = StudentsList.getListFromXML(sStudentXMLPath);
objStudentsList.setStudents(objStudents);//Set/Merges Students, Overrides existing Prioritys (if necesarry)
objStudentsList.saveList(sStudentXMLPath);
xlWorkBook.Close(true, null, null);
xlApp.Quit();
}
private bool findStudent(Student objStudent)
{
foreach (Student tmpStudent in this.objStudents)
{
if (objStudent.Equals(tmpStudent))
{
return true;
}
}
return false;
}