void setSessionClassGroups(string selectedValue)
{
using (PPDBEntities db = new PPDBEntities())
{
List <string> ClassGroups = new List <string>();
string oneClassGroup = string.Empty;
foreach (var elem in db.ClassGroups)
{
oneClassGroup = elem.DegreeCourse.ToString() + "/" + elem.Graduate.ToString() + "/";
if (elem.FullTimeStudies == true)
{
oneClassGroup += "STACJ";
}
else
{
oneClassGroup += "NIESTACJ";
}
oneClassGroup += "/" + elem.Semester.ToString() + "/" + elem.Speciality.ToString();
ClassGroups.Add(oneClassGroup);
}
if (ClassGroups.IndexOf(selectedValue) >= 0)
{
ClassGroups.Remove(selectedValue);
ClassGroups.Insert(0, selectedValue);
}
Session["ClassGroups"] = new SelectList(ClassGroups);
setSessionCategoriesAndStats("", ClassGroups.ElementAt(0));
}
}
public ActionResult Run()
{
if (Session["User"].ToString() == "Admin" || Session["User"].ToString() == "SuperAdmin")
{
if ((bool)HttpContext.Application["RecActive"] == false && (bool)HttpContext.Application["AfterRec"] == true)
{
using (PPDBEntities db = new PPDBEntities())
{
DateTime saveTime = DateTime.Now;
foreach (var oneClassGroup in db.ClassGroups)
{
foreach (var oneCategory in db.Categories.Where(x => x.ClassGroupID == oneClassGroup.ClassGroupID))
{
var subjects = db.ElectiveSubjectsAndSpecialities.Where(x => x.CategoryID == oneCategory.CategoryID);
Dictionary <int, List <int> > algorithmChoices = AssignStudentToSubjectInOneCategory(subjects, oneCategory, oneClassGroup);
if (algorithmChoices == null)
{
return(RedirectToAction("", "Home"));
}
//Zapisz wyniki do bazy
foreach (var resultSubject in algorithmChoices)
{
foreach (var resultStudent in resultSubject.Value)
{
var checkIfFinalChoiceExists = db.FinalChoices.Where(x => x.StudentNo == resultStudent && x.CategoryID == oneCategory.CategoryID).FirstOrDefault();
if (checkIfFinalChoiceExists != null)
{
if (checkIfFinalChoiceExists.ChoiceID != resultSubject.Key)
{
checkIfFinalChoiceExists.ChoiceID = resultSubject.Key;
checkIfFinalChoiceExists.LastEdit = saveTime;
checkIfFinalChoiceExists.LastEditedBy = Int32.Parse(Session["AdminID"].ToString());
db.Entry(checkIfFinalChoiceExists).State = EntityState.Modified;
}
}
else
{
var newResult = new FinalChoices();
newResult.StudentNo = resultStudent;
newResult.CategoryID = oneCategory.CategoryID;
newResult.ChoiceID = resultSubject.Key;
newResult.CreationDate = saveTime;
newResult.CreatedBy = Int32.Parse(Session["AdminID"].ToString());
db.FinalChoices.Add(newResult);
}
}
}
}
}
db.SaveChanges();
TempData["Success"] = "Algorytm przydziału studentów zakończył się pomyślnie!";
}
}
}
return(RedirectToAction("", "Home"));
}
public ActionResult SaveStudentChoices(string[] Subjects)
{
if (Session["User"].ToString() == "Student")
{
DateTime saveTime = DateTime.Now;
int activeChoice = 0;
int StdNo = Int32.Parse(Session["StudentNo"].ToString());
using (PPDBEntities db = new PPDBEntities())
{
var ClassGroups = db.StudentsAndClassGroups.Where(x => x.StudentNo == StdNo);
foreach (var oneClassGroup in ClassGroups)
{
var Categories = db.Categories.Where(x => x.ClassGroupID == oneClassGroup.ClassGroupID);
foreach (var Cat in Categories)
{
var findUserChoices = db.StudentChoices.Where(u => u.StudentNo == StdNo && u.CategoryID == Cat.CategoryID);
//if istnieje to nadpisz else dodaj do bazy
for (int i = 1; i <= Cat.MaxNoChoices; i++)
{
if (findUserChoices.Where(x => x.PreferenceNo == i).Count() == 1)
{
var findChoice = findUserChoices.Where(x => x.PreferenceNo == i).FirstOrDefault();
var newChoiceName = Subjects[activeChoice];
int newChoiceID = db.ElectiveSubjectsAndSpecialities.Where(x => x.Name == newChoiceName && x.CategoryID == Cat.CategoryID).Select(x => x.ElectiveSubjectAndSpecialityID).FirstOrDefault();
if (findChoice.ChoiceID != newChoiceID)
{
findChoice.ChoiceID = newChoiceID;
findChoice.ChoiceDate = saveTime;
db.Entry(findChoice).State = EntityState.Modified;
}
}
else
{
var newChoice = new StudentChoices.Models.StudentChoices();
newChoice.StudentNo = StdNo;
newChoice.CategoryID = Cat.CategoryID;
var newChoiceName = Subjects[activeChoice];
int newChoiceID = db.ElectiveSubjectsAndSpecialities.Where(x => x.Name == newChoiceName && x.CategoryID == Cat.CategoryID).Select(x => x.ElectiveSubjectAndSpecialityID).FirstOrDefault();
newChoice.ChoiceID = newChoiceID;
newChoice.PreferenceNo = Byte.Parse(i.ToString());
newChoice.ChoiceDate = saveTime;
db.StudentChoices.Add(newChoice);
}
activeChoice++;
}
}
}
db.SaveChanges();
TempData["Success"] = "Zapisano wybory pomyślnie!";
}
}
return(RedirectToAction("", "Home"));
}
public void ExportResults()
{
if (Session["User"].ToString() == "Admin" || Session["User"].ToString() == "SuperAdmin")
{
if ((bool)HttpContext.Application["RecActive"] == false && (bool)HttpContext.Application["AfterRec"] == true)
{
using (PPDBEntities db = new PPDBEntities())
{
List <Models.Export.Category> exportData = new List <Models.Export.Category>();
var categories = db.ClassGroups.Join(db.Categories, c => c.ClassGroupID,
cm => cm.ClassGroupID, (c, cm) => new
{
CategoryID = cm.CategoryID,
Name = cm.Name,
DegreeCourse = c.DegreeCourse,
Graduate = c.Graduate,
FullTimeStudies = c.FullTimeStudies,
Semester = c.Semester,
Speciality = c.Speciality,
}).ToList();
List <Models.Export.ElectiveSubjectAndSpeciality> subjectslist;
List <string> studentsnolist;
foreach (var categoryitem in categories)
{
subjectslist = new List <Models.Export.ElectiveSubjectAndSpeciality>();
foreach (var subjectitem in db.ElectiveSubjectsAndSpecialities.Where(x => x.CategoryID == categoryitem.CategoryID))
{
studentsnolist = new List <string>();
foreach (var choiceitem in db.FinalChoices.Where(x => x.ChoiceID == subjectitem.ElectiveSubjectAndSpecialityID))
{
studentsnolist.Add(choiceitem.StudentNo.ToString());
}
subjectslist.Add(new Models.Export.ElectiveSubjectAndSpeciality(subjectitem.Name, studentsnolist));
}
exportData.Add(new Models.Export.Category(categoryitem.Name, categoryitem.DegreeCourse, categoryitem.Graduate, categoryitem.FullTimeStudies, categoryitem.Semester, categoryitem.Speciality, subjectslist));
}
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename = Results.xml");
Response.ContentType = "text/xml";
var serializer = new System.Xml.Serialization.XmlSerializer(exportData.GetType());
serializer.Serialize(Response.OutputStream, exportData);
}
}
}
}
void setSessionCategoriesAndStats(string selectedValue, string selectedClassGroup)
{
using (PPDBEntities db = new PPDBEntities())
{
var selectedClassGroupDetails = selectedClassGroup.Split('/');
string DegreeCourse = selectedClassGroupDetails[0];
Byte Graduate = Byte.Parse(selectedClassGroupDetails[1]);
bool FullTimeStudies = selectedClassGroupDetails[2] == "STACJ" ? true : false;
Byte Semester = Byte.Parse(selectedClassGroupDetails[3]);
string Speciality = selectedClassGroupDetails[4];
var selectedClassGroupID = db.ClassGroups.Where(x => x.DegreeCourse == DegreeCourse &&
x.Graduate == Graduate && x.FullTimeStudies == FullTimeStudies &&
x.Semester == Semester && x.Speciality == Speciality).FirstOrDefault().ClassGroupID;
Session["NoOfStudents"] = db.StudentsAndClassGroups.Where(x => x.ClassGroupID == selectedClassGroupID).Count();
List <string> Categories = new List <string>();
foreach (var elem in db.Categories.Where(x => x.ClassGroupID == selectedClassGroupID).Select(x => x.Name))
{
Categories.Add(elem);
}
if (Categories.IndexOf(selectedValue) >= 0)
{
Categories.Remove(selectedValue);
Categories.Insert(0, selectedValue);
}
Session["Categories"] = new SelectList(Categories);
int NoOfSavedStudents = 0;
int NoOfSavedStudentsOnOneSubject = 0;
Dictionary <string, int> stats = new Dictionary <string, int>();
var firstCategoryName = Categories.ElementAt(0);
var firstCategoryID = db.Categories.Where(x => x.Name == firstCategoryName).FirstOrDefault().CategoryID;
foreach (var item in db.ElectiveSubjectsAndSpecialities.Where(x => x.CategoryID == firstCategoryID))
{
NoOfSavedStudentsOnOneSubject = db.StudentChoices.Where(x => x.ChoiceID == item.ElectiveSubjectAndSpecialityID && x.PreferenceNo == 1).Count();
stats.Add(item.Name, NoOfSavedStudentsOnOneSubject);
NoOfSavedStudents += NoOfSavedStudentsOnOneSubject;
}
Session["NoOfSavedStudents"] = NoOfSavedStudents;
Session["Stats"] = stats;
}
}
public void ExportAdminResults()
{
if (Session["User"].ToString() == "SuperAdmin")
{
using (PPDBEntities db = new PPDBEntities())
{
List <Models.Export.Admin> exportData = new List <Models.Export.Admin>();
var admins = db.Admins.ToList();
foreach (var v in admins)
{
exportData.Add(new Models.Export.Admin(v.Login, v.Password, v.Active, v.SuperAdmin));
}
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename = AdminsResults.xml");
Response.ContentType = "text/xml";
var serializer = new System.Xml.Serialization.XmlSerializer(exportData.GetType());
serializer.Serialize(Response.OutputStream, exportData);
}
}
}
Dictionary <int, List <int> > AssignStudentToSubjectInOneCategory(IQueryable <ElectiveSubjectsAndSpecialities> subjects, Categories oneCategory, ClassGroups oneClassGroup)
{
Dictionary <int, List <int> > algorithmChoices = new Dictionary <int, List <int> >();
List <int> chosenStudents = new List <int>();
using (PPDBEntities db = new PPDBEntities())
{
var studentChoicesOneClassGroup = db.StudentChoices.Where(x => x.CategoryID == oneCategory.CategoryID).OrderBy(x => x.ChoiceDate);
for (int ChoicePref = 1; ChoicePref <= oneCategory.MaxNoChoices; ChoicePref++)
{
foreach (var oneSubject in subjects)
{
if (ChoicePref == 1)
{
chosenStudents = new List <int>();
}
else
{
chosenStudents = algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID];
}
if (oneSubject.UpperLimit != null)
{
int freePlaces = oneSubject.UpperLimit.Value - chosenStudents.Count;
if (freePlaces > 0)
{
var selectedStudentsNo = studentChoicesOneClassGroup.Where(x => x.ChoiceID == oneSubject.ElectiveSubjectAndSpecialityID && x.PreferenceNo == ChoicePref).Select(x => x.StudentNo);
var selectedsortedStudentsNo = db.StudentsAndClassGroups.Where(x => selectedStudentsNo.Any(y => y == x.StudentNo)).OrderByDescending(x => x.AverageGrade).Select(x => x.StudentNo).Take(freePlaces);
foreach (var item in selectedsortedStudentsNo)
{
studentChoicesOneClassGroup = studentChoicesOneClassGroup.Where(x => x.StudentNo != item).OrderBy(x => x.ChoiceDate);
chosenStudents.Add(item);
}
}
}
else
{
var selectedStudentsNo = studentChoicesOneClassGroup.Where(x => x.ChoiceID == oneSubject.ElectiveSubjectAndSpecialityID && x.PreferenceNo == ChoicePref).Select(x => x.StudentNo);
var selectedsortedStudentsNo = db.StudentsAndClassGroups.Where(x => selectedStudentsNo.Any(y => y == x.StudentNo)).Select(x => x.StudentNo);
foreach (var item in selectedsortedStudentsNo)
{
studentChoicesOneClassGroup = studentChoicesOneClassGroup.Where(x => x.StudentNo != item).OrderBy(x => x.ChoiceDate);
chosenStudents.Add(item);
}
}
algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID] = chosenStudents;
}
}
//weź studentów którzy nigdzie się nie dostali
if (studentChoicesOneClassGroup.Count() > 0)
{
var restOfStudentsNo = db.StudentsAndClassGroups.Where(x => studentChoicesOneClassGroup.Any(y => y.StudentNo == x.StudentNo)).OrderByDescending(x => x.AverageGrade).Select(x => x.StudentNo);
foreach (var oneSubject in subjects.Where(x => x.UpperLimit != null))
{
int freePlaces = oneSubject.UpperLimit.Value - algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID].Count;
if (freePlaces > 0)
{
var selectedsortedStudentsNo = restOfStudentsNo.Take(freePlaces);
foreach (var item in selectedsortedStudentsNo)
{
studentChoicesOneClassGroup = studentChoicesOneClassGroup.Where(x => x.StudentNo != item).OrderBy(x => x.ChoiceDate);;
algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID].Add(item);
}
}
if (restOfStudentsNo.Count() == 0)
{
break;
}
}
//tylko jeden weź
if (restOfStudentsNo.Count() > 0)
{
var oneSubject = subjects.Where(x => x.UpperLimit == null).FirstOrDefault();
if (oneSubject != null)
{
foreach (var item in restOfStudentsNo)
{
algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID].Add(item);
}
}
else
{
string alertStudents = string.Empty;
foreach (var item in restOfStudentsNo)
{
alertStudents += " " + item;
}
if (restOfStudentsNo.Count() == 1)
{
TempData["Alert"] = "Nie można przydzielić studenta o indeksie" + alertStudents;
}
else
{
TempData["Alert"] = "Nie można przydzielić studentów o indeksach:" + alertStudents;
}
TempData["Alert"] += " - brak wolnych miejsc w kategorii " + oneCategory.Name + " w grupie " + oneClassGroup.DegreeCourse.ToString() + "/" + oneClassGroup.Graduate.ToString() + "/";
if (oneClassGroup.FullTimeStudies == true)
{
TempData["Alert"] += "STACJ";
}
else
{
TempData["Alert"] += "NIESTACJ";
}
TempData["Alert"] += "/" + oneClassGroup.Semester.ToString() + "/" + oneClassGroup.Speciality.ToString() + "!";
return(null);
}
}
}
//weź studentów którzy nie wybrali
var studentsWithoutChoicesNo = db.StudentsAndClassGroups.Where(x => x.ClassGroupID == oneClassGroup.ClassGroupID && !db.StudentChoices.Any(y => y.StudentNo == x.StudentNo && y.CategoryID == oneCategory.CategoryID)).OrderByDescending(x => x.AverageGrade).Select(x => x.StudentNo).ToList();
if (studentsWithoutChoicesNo.Count() > 0)
{
foreach (var oneSubject in subjects.Where(x => x.UpperLimit != null))
{
int freePlaces = oneSubject.UpperLimit.Value - algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID].Count;
if (freePlaces > 0)
{
var selectedsortedStudentsNo = studentsWithoutChoicesNo.Take(freePlaces);
foreach (var item in selectedsortedStudentsNo)
{
studentsWithoutChoicesNo = studentsWithoutChoicesNo.Where(x => x != item).ToList();
algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID].Add(item);
}
}
if (studentsWithoutChoicesNo.Count() == 0)
{
break;
}
}
//tylko jeden weź
if (studentsWithoutChoicesNo.Count() > 0)
{
var oneSubject = subjects.Where(x => x.UpperLimit == null).FirstOrDefault();
if (oneSubject != null)
{
foreach (var item in studentsWithoutChoicesNo)
{
algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID].Add(item);
}
}
else
{
string alertStudents = string.Empty;
foreach (var item in studentsWithoutChoicesNo)
{
alertStudents += " " + item;
}
if (studentsWithoutChoicesNo.Count() == 1)
{
TempData["Alert"] = "Nie można przydzielić studenta o indeksie" + alertStudents;
}
else
{
TempData["Alert"] = "Nie można przydzielić studentów o indeksach:" + alertStudents;
}
TempData["Alert"] += " - brak wolnych miejsc w kategorii " + oneCategory.Name + " w grupie " + oneClassGroup.DegreeCourse.ToString() + "/" + oneClassGroup.Graduate.ToString() + "/";
if (oneClassGroup.FullTimeStudies == true)
{
TempData["Alert"] += "STACJ";
}
else
{
TempData["Alert"] += "NIESTACJ";
}
TempData["Alert"] += "/" + oneClassGroup.Semester.ToString() + "/" + oneClassGroup.Speciality.ToString() + "!";
return(null);
}
}
}
//sprawdź limity dolne
int excludedSubjectID = -1;
int biggestDifferenceNumberOfPlaces = 0;
foreach (var oneSubject in subjects.Where(x => x.LowerLimit != null))
{
if (oneSubject.LowerLimit.Value - algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID].Count > biggestDifferenceNumberOfPlaces)
{
biggestDifferenceNumberOfPlaces = oneSubject.LowerLimit.Value - algorithmChoices[oneSubject.ElectiveSubjectAndSpecialityID].Count;
excludedSubjectID = oneSubject.ElectiveSubjectAndSpecialityID;
}
}
if (excludedSubjectID != -1)
{
return(AssignStudentToSubjectInOneCategory(subjects.Where(x => x.ElectiveSubjectAndSpecialityID != excludedSubjectID), oneCategory, oneClassGroup));
}
}
return(algorithmChoices);
}
public ActionResult Index(Users user)
{
using (PPDBEntities db = new PPDBEntities())
{
byte[] clientPassword = Encoding.ASCII.GetBytes(user.Password);
//utworzenie skrotu od pobranego hasla (SHA256)
using (var sha256 = SHA256.Create())
{
byte[] clientPasswordSHA256 = sha256.ComputeHash(clientPassword);
user.Password = BitConverter.ToString(clientPasswordSHA256).Replace("-", string.Empty);;
}
//Sprawdzenie czy to admin
var usrAdmin = db.Admins.Where(u => u.Login == user.Login &&
u.Password == user.Password).FirstOrDefault();
if (usrAdmin != null)
{
//Sprawdzenie czy konto jest aktywne
if (usrAdmin.Active == true)
{
Session["UserName"] = usrAdmin.Login;
Session["AdminID"] = usrAdmin.AdminID;
if (usrAdmin.SuperAdmin == true)
{
Session["User"] = "******";
}
else
{
Session["User"] = "******";
}
usrAdmin.LastLogin = DateTime.Now;
db.Entry(usrAdmin).State = EntityState.Modified;
db.SaveChanges();
if (Session["ClassGroups"] == null)
{
setSessionClassGroups("");
}
return(RedirectToAction("", "Home"));
}
else
{
ViewBag.Alert = "Konto jest nieaktywne!";
return(View());
}
}
else
{
//Sprawdzenie czy to student
var usrStudent = db.Students.Where(u => u.Login == user.Login).FirstOrDefault();
if (usrStudent != null)
{
//Sprawdzenie czy nie przekroczono limitu logowań
if (usrStudent.TriesNo < 3)
{
//Sprawdzenie poprawności hasła
if (usrStudent.Password == user.Password)
{
Session["UserName"] = usrStudent.Login + " (" + usrStudent.Name + " " + usrStudent.Surname + ")";
Session["User"] = "******";
Session["StudentNo"] = usrStudent.StudentNo;
usrStudent.TriesNo = 0;
db.Entry(usrStudent).State = EntityState.Modified;
db.SaveChanges();
if ((bool)HttpContext.Application["RecActive"] == true)
{
var ChosenOptions = new Dictionary <string, string>();
if (Session["Options"] == null)
{
Dictionary <string, Dictionary <ArrayList, Dictionary <List <List <string> >, SelectList> > > optionsAll = new Dictionary <string, Dictionary <ArrayList, Dictionary <List <List <string> >, SelectList> > >();
Dictionary <ArrayList, Dictionary <List <List <string> >, SelectList> > optionsOneGroup;
Dictionary <List <List <string> >, SelectList> optionsOneCategory;
List <List <string> > optionsOneCategoryList;
string oneClassGroupStr = string.Empty;
var ClassGroups = db.StudentsAndClassGroups.Where(x => x.StudentNo == usrStudent.StudentNo);
foreach (var oneClassGroup in ClassGroups)
{
optionsOneGroup = new Dictionary <ArrayList, Dictionary <List <List <string> >, SelectList> >();
var Categories = db.Categories.Where(x => x.ClassGroupID == oneClassGroup.ClassGroupID);
foreach (var Cat in Categories)
{
optionsOneCategory = new Dictionary <List <List <string> >, SelectList>();
optionsOneCategoryList = new List <List <string> >();
var optionsOneCategorySubjects = db.ElectiveSubjectsAndSpecialities.Where(x => x.CategoryID == Cat.CategoryID);
foreach (var Sub in optionsOneCategorySubjects)
{
var SubInfo = new List <string>();
SubInfo.Add(Sub.Name);
SubInfo.Add(Sub.Information);
var files = String.Empty;
foreach (var file in db.Files.Where(x => x.ElectiveSubjectAndSpecialityID == Sub.ElectiveSubjectAndSpecialityID))
{
files += file.Filename + "\n" + file.Path + " ";
}
SubInfo.Add(files);
optionsOneCategoryList.Add(SubInfo);
}
optionsOneCategory[optionsOneCategoryList] = new SelectList(optionsOneCategorySubjects.Select(x => x.Name).ToList());
var optionsOneGroupParams = new ArrayList();
optionsOneGroupParams.Add(Cat.Name);
optionsOneGroupParams.Add(Cat.MaxNoChoices);
for (int i = 1; i <= Cat.MaxNoChoices; i++)
{
ChosenOptions[Cat.Name + " " + i] = "";
}
optionsOneGroup[optionsOneGroupParams] = optionsOneCategory;
}
var ClassGroup = db.ClassGroups.Where(x => x.ClassGroupID == oneClassGroup.ClassGroupID).FirstOrDefault();
oneClassGroupStr = ClassGroup.DegreeCourse.ToString() + ", " + ClassGroup.Graduate.ToString() + ". stopień, ";
if (ClassGroup.FullTimeStudies == true)
{
oneClassGroupStr += "st. stacjonarne";
}
else
{
oneClassGroupStr += "st. niestacjonarne";
}
oneClassGroupStr += ", sem. " + ClassGroup.Semester.ToString() + "., " + ClassGroup.Speciality.ToString()
+ ", średnia ocen: " + oneClassGroup.AverageGrade.ToString();
optionsAll[oneClassGroupStr] = optionsOneGroup;
}
Session["Options"] = optionsAll;
}
var ChosenOptionsFromDB = db.StudentChoices.Where(x => x.StudentNo == usrStudent.StudentNo);
foreach (var item in ChosenOptionsFromDB)
{
ChosenOptions[db.Categories.Where(x => x.CategoryID == item.CategoryID).FirstOrDefault().Name + " " + item.PreferenceNo] = db.ElectiveSubjectsAndSpecialities.Where(x => x.ElectiveSubjectAndSpecialityID == item.ChoiceID).FirstOrDefault().Name;
}
Session["ChosenOptions"] = ChosenOptions;
}
else if ((bool)HttpContext.Application["ShareResults"] == true)
{
Dictionary <string, Dictionary <string, string> > resultsAll = new Dictionary <string, Dictionary <string, string> >();
Dictionary <string, string> resultsOneGroup;
string oneClassGroupStr = string.Empty;
var ClassGroups = db.StudentsAndClassGroups.Where(x => x.StudentNo == usrStudent.StudentNo);
foreach (var oneClassGroup in ClassGroups)
{
resultsOneGroup = new Dictionary <string, string>();
var Categories = db.Categories.Where(x => x.ClassGroupID == oneClassGroup.ClassGroupID);
foreach (var Cat in Categories)
{
var FinalChoiceID = db.FinalChoices.Where(x => x.StudentNo == usrStudent.StudentNo && x.CategoryID == Cat.CategoryID).Select(x => x.ChoiceID).FirstOrDefault();
var FinalChoiceName = db.ElectiveSubjectsAndSpecialities.Where(x => x.ElectiveSubjectAndSpecialityID == FinalChoiceID).Select(x => x.Name).FirstOrDefault();
resultsOneGroup[Cat.Name] = FinalChoiceName;
}
var ClassGroup = db.ClassGroups.Where(x => x.ClassGroupID == oneClassGroup.ClassGroupID).FirstOrDefault();
oneClassGroupStr = ClassGroup.DegreeCourse.ToString() + ", " + ClassGroup.Graduate.ToString() + ". stopień, ";
if (ClassGroup.FullTimeStudies == true)
{
oneClassGroupStr += "st. stacjonarne";
}
else
{
oneClassGroupStr += "st. niestacjonarne";
}
oneClassGroupStr += ", sem. " + ClassGroup.Semester.ToString() + "., " + ClassGroup.Speciality.ToString()
+ ", średnia ocen: " + oneClassGroup.AverageGrade.ToString();
resultsAll[oneClassGroupStr] = resultsOneGroup;
}
Session["Results"] = resultsAll;
}
return(RedirectToAction("", "Home"));
}
else
{
usrStudent.TriesNo += 1;
db.Entry(usrStudent).State = EntityState.Modified;
db.SaveChanges();
}
}
else
{
ViewBag.Alert = "Konto jest zablokowane - przekroczono liczbę błędnych logowań. Skontaktuj się z administratorem systemu!";
return(View());
}
}
}
}
ViewBag.Alert = "Dane logowania są niepoprawne!";
return(View());
}
