public string AddEditClass(int level, string label, string teacher, string branch)
{
if (IsAuthorized())
{
Database.SchoolClass newclass = new Database.SchoolClass();
newclass.Level = level;
newclass.Name = label;
string log = null;
string namefirst = teacher.Split(' ')[0];
string namesec = teacher.Split(' ')[1];
var teachers = VaKEGrade.Database.VaKEGradeRepository.Instance.GetTeachers();
newclass.PrimaryClassTeacherID = (from c in teachers
where (c.LastName == namefirst && c.FirstName == namesec) || (c.LastName == namesec && c.FirstName == namefirst)
select c.ID).First();
var branches = VaKEGrade.Database.VaKEGradeRepository.Instance.GetBranches();
newclass.BranchID = (from c in branches
where c.Name == branch
select c.ID).First();
if (newclass.BranchID == null)
{
log = "Der Angegebene Zweig existiert nicht";
}
VaKEGrade.Database.VaKEGradeRepository.Instance.AddClass(newclass);
return log;
}
ViewData["error"] = "Bitte melden sie sich am System an";
return null;
}
public ActionResult RecieveStudentConfig()
{
if (IsAuthorized())
{
foreach (string inputTagName in Request.Files)
{
HttpPostedFileBase file = Request.Files[inputTagName];
if (file.ContentLength > 0)
{
byte[] config = new byte[file.ContentLength];
file.InputStream.Read(config, 0, file.ContentLength);
string s = System.Text.UnicodeEncoding.UTF8.GetString(config);
string[] data = s.Split(Environment.NewLine.ToCharArray());
List<Database.SchoolClass> classes = VaKEGrade.Database.VaKEGradeRepository.Instance.GetClasses().ToList<Database.SchoolClass>();
foreach (string temp in data)
{
if (temp != "")
{
string[] pupil = temp.Split(';');
int classID = -1;
foreach (Database.SchoolClass curClass in classes)
{
if (curClass.Level + "" + curClass.Name == pupil[2])
{
classID = curClass.ID;
break;
}
}
if (classID == -1)
{
Database.SchoolClass newClass = new Database.SchoolClass();
newClass.Name = pupil[2].Substring(1, 1);
newClass.Level = Convert.ToInt32(pupil[2].Substring(0, 1));
VaKEGrade.Database.VaKEGradeRepository.Instance.AddClass(newClass);
classID = newClass.ID;
}
VaKEGrade.Database.VaKEGradeRepository.Instance.AddPupil(new Database.Pupil() { FirstName = pupil[0], LastName = pupil[1], Birthdate = Convert.ToDateTime(pupil[4]), ClassID = classID, Religion = pupil[3], Gender = pupil[5] });
}
}
}
}
return RedirectToAction("Index");
}
ViewData["error"] = "Bitte melden sie sich am System an";
return Redirect("/Home/");
}
