public async Task <IActionResult> EditResult(int?id, int?resultId)
{
TempData["ResultId"] = resultId;
int.TryParse(TempData["ExamId"].ToString(), out int ExamId);
if (id == null)
{
return(NotFound());
}
var studentRequest = await _repository.Query <Student>().Include(x => x.Result).Where(x => x.Id == id).FirstOrDefaultAsync();
var resultEntity = await _repository.FindByIdAsync <Result>(studentRequest.Result.Id);
if (studentRequest == null)
{
return(NotFound());
}
var exam = _repository.Query <Exam>().Include(x => x.City).FirstOrDefault(x => x.Id == studentRequest.Result.ExamId);
var studentViewModel = StudentsMappings.ToViewModel(studentRequest, resultEntity);
if (resultEntity.Tasks == null)
{
studentViewModel.Tasks = new double[JsonSerializer.Deserialize <double[]>(exam.Tasks).Length];
}
studentViewModel.TasksString = new string[studentViewModel.Tasks.Length];
for (int i = 0; i < studentViewModel.TasksString.Length; i++)
{
studentViewModel.TasksString[i] = studentViewModel.Tasks[i].ToString().Replace(",", ".");
}
studentViewModel.ExamCityAndDate = $"{exam.City.Name}, {exam.Date.ToShortDateString()}";
TempData["ExamId"] = ExamId;
return(View(studentViewModel));
}
public async Task <IActionResult> Edit(int id, string[] selectedPriority, [Bind("Id, FirstName, LastName, Email, PhoneNumber, Gender, Comment")] StudentViewModel studentViewModel)
{
var student = await _repository.Query <Student>()
.Include(x => x.StudentCourses)
.ThenInclude(x => x.Course)
.ThenInclude(x => x.Programs)
.FirstOrDefaultAsync(x => x.Id == id);
if (id != student.Id)
{
return(NotFound());
}
if (student.StudentDataLocked == true)
{
ModelState.AddModelError("StudentEdit", "Kandidato duomenys yra užrakinti, redaguoti kandidato negalima");
TempData["ErrorMessage"] = "Kandidato duomenys yra užrakinti, redaguoti kandidato negalima";
return(RedirectToAction("Edit", "Students", new { id = student.Id }));
}
if (ModelState.IsValid)
{
try
{
StudentsMappings.ToEntity(student, studentViewModel);
var studentCourses = student.StudentCourses.ToList();
var selectedPriorityWithoutNullAndDuplictates = selectedPriority.Where(priority => !string.IsNullOrEmpty(priority)).Distinct().ToArray();
var listOfSelectedPriority = selectedPriorityWithoutNullAndDuplictates.ToList();
foreach (var studentCourse in studentCourses)
{
studentCourse.Priority = null;
int priority = listOfSelectedPriority.IndexOf(studentCourse.Course.Title);
if (priority == -1)
{
studentCourse.Priority = null;
}
else
{
studentCourse.Priority = priority + 1;
}
}
await _repository.SaveAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!_repository.Exists <Student>(student.Id))
{
return(NotFound());
}
else
{
throw;
}
}
var previousUrl = TempData["ReturnPath"].ToString();
return(Redirect(previousUrl));
}
return(View(student));
}
public async Task <IActionResult> EditResult(string[] tasksString)
{
int.TryParse(TempData["ResultId"].ToString(), out int resultId);
int.TryParse(TempData["ExamId"].ToString(), out int ExamId);
if (ModelState.IsValid)
{
try
{
double[] Tasks = new double[tasksString.Length];
for (int i = 0; i < Tasks.Length; i++)
{
Tasks[i] = double.Parse(tasksString[i], System.Globalization.CultureInfo.InvariantCulture);
}
var studentRequest = _repository.Query <Student>().Include(x => x.Result).ThenInclude(y => y.Exam).Where(x => x.Id > 0);
var result = await _repository.FindByIdAsync <Result>(resultId);
var student = await studentRequest.FirstOrDefaultAsync(x => x.Id == result.StudentForeignKey);
var studentResultViewModel = StudentsMappings.ToStudentsResultViewModel(Tasks);
var examTasks = StudentsMappings.ToStudentsResultViewModel(result).Tasks;
if (student.PassedExam)
{
TempData["ErrorMessage"] = "Kandidatas yra pakviestas į pokalbį, todėl jo duomenų negalima redaguoti.";
return(RedirectToAction("EditResult", "Students", new { resultId }));
}
var testToDelete = examTasks.Select((x, i) => x < Tasks[i]);
var isInvalid = examTasks.Select((x, i) => x < Tasks[i]).Any(x => x);
if (isInvalid)
{
ModelState.AddModelError("EditResult", "Užduoties balas negali būti didesnis nei testo šablono balas");
TempData["ErrorMessage"] = "Užduoties balas negali būti didesnis nei testo šablono balas";
return(RedirectToAction("EditResult", "Students", new { resultId }));
}
StudentsMappings.ToResultEntity(result, studentResultViewModel);
await _repository.SaveAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(RedirectToAction("Index", "Students", new { id = ExamId }));
}
return(RedirectToAction("Index", "Students", new { id = ExamId }));
}
public async Task <IActionResult> Index(int?id)
{
if (id == null)
{
_logger.LogError("Exam id was null. User {User}.", _user);
return(NotFound());
}
TempData["ExamId"] = id;
var studentRequest = _repository.Query <Student>()
.Include(x => x.Result)
.Include(x => x.ConversationResult)
.Where(x => x.Id > 0);
var students = await studentRequest.Where(x => x.Result.Exam.Id == id).ToListAsync();
if (students == null)
{
_logger.LogWarning("No students found. User {User}.", _user);
return(NotFound());
}
var studentViewModels = new List <StudentsResultViewModel>();
var exam = _repository.Query <Exam>().Include(x => x.City).FirstOrDefault(x => x.Id == id);
students.ForEach(x => studentViewModels.Add(StudentsMappings.ToViewModel(x, x.Result)));
foreach (var item in students)
{
foreach (var student in studentViewModels)
{
student.FinalPoints = student.Tasks?.Sum(x => x) ?? 0;
var examDraft = _repository.Query <Exam>().FirstOrDefault(e => e.Id == student.ExamId);
double maxPoints = TaskParametersMappings.ToTaskParameterViewModel(examDraft).Tasks.Sum(x => x);
student.PercentageGrade = student.FinalPoints * 100 / maxPoints;
student.ExamCityAndDate = $"{exam.City.Name}, {exam.Date.ToShortDateString()}";
}
}
studentViewModels = studentViewModels.OrderByDescending(x => x.FinalPoints).ToList();
_logger.LogInformation($"Found {studentViewModels.Count} students. User {_user}.");
return(View(studentViewModels));
}
public async Task <IActionResult> Edit(int?id)
{
var returnPath = HttpContext.Request.Headers["Referer"].ToString();
TempData["ReturnPath"] = returnPath;
if (id == null)
{
return(NotFound());
}
var student = await _repository.Query <Student>()
.Include(x => x.Result)
.FirstOrDefaultAsync(x => x.Id == id);
if (student == null)
{
return(NotFound());
}
var studentViewModel = StudentsMappings.ToViewModel(student);
var programs = await _repository.Query <Core.Library.Entities.Program>().ToListAsync();
var studentCourses = await _repository.Query <StudentCourse>()
.Where(x => x.StudentId == id)
.OrderByDescending(x => x.Priority.HasValue)
.ThenBy(x => x.Priority)
.ToListAsync();
var exam = _repository.Query <Exam>().Include(x => x.City).FirstOrDefault(x => x.Id == student.Result.ExamId);
studentViewModel.ExamCityAndDate = $"{exam.City.Name}, {exam.Date.ToShortDateString()}";
var stringPrograms = new List <SelectListItem>();
studentViewModel.SelectedPriority = new string[studentCourses.Count()];
List <string> listOfSelectedPriority = new List <string>();
foreach (var studentCourse in studentCourses)
{
var priorityCourse = _repository.Query <Course>()
.Where(x => x.Id == studentCourse.CourseId)
.FirstOrDefault();
var priorityName = programs.Where(x => x.Id == priorityCourse.ProgramId).FirstOrDefault();
stringPrograms.Add(new SelectListItem {
Value = priorityName.Name, Text = priorityName.Name
});
if (studentCourse.Priority == null)
{
listOfSelectedPriority.Add(null);
}
else
{
listOfSelectedPriority.Add(priorityName.Name);
}
}
stringPrograms.Add(new SelectListItem {
Value = "", Text = ""
});
studentViewModel.SelectedPriority = listOfSelectedPriority.ToArray();
studentViewModel.Programs = stringPrograms;
return(View(studentViewModel));
}
public async Task <IActionResult> Create(string[] selectedPriority, [Bind("Id, FirstName, LastName, Email, PhoneNumber, Gender, Comment")] StudentViewModel studentViewModel)
{
int.TryParse(TempData["ExamId"].ToString(), out int ExamId);
var backToExam = RedirectToAction("Index", "Students", new { id = ExamId });
if (ModelState.IsValid)
{
var student = StudentsMappings.ToEntity(studentViewModel);
Result result = new Result
{
ExamId = ExamId,
};
result = await _repository.InsertAsync <Result>(result);
result.Student = student;
student.Result = result;
student.ResultId = result.Id;
await _repository.InsertAsync <Student>(student);
var studentsExam = _repository.FindByIdAsync <Exam>(ExamId).Result;
await _repository.SaveAsync();
studentViewModel = StudentsMappings.ToViewModel(student);
var programs = await _repository.Query <Core.Library.Entities.Program>().ToListAsync();
foreach (var program in programs)
{
StudentCourse studentCourse = new StudentCourse
{
StudentId = student.Id,
Student = student
};
var priorityProgram = _repository.Query <Core.Library.Entities.Program>()
.Where(x => x.Name == program.Name)
.FirstOrDefault();
var priorityCourse = _repository.Query <Course>()
.Where(x => x.ProgramId == priorityProgram.Id)
.Where(x => x.StartYear.Year == studentsExam.Date.Year)
.FirstOrDefault();
if (priorityCourse != null)
{
studentCourse.CourseId = priorityCourse.Id;
}
else
{
Course course = new Course
{
StartYear = studentsExam.Date,
EndYear = studentsExam.Date.AddYears(1),
CityId = studentsExam.CityId,
ProgramId = priorityProgram.Id,
Title = priorityProgram.Name
};
studentCourse.CourseId = course.Id;
studentCourse.Course = course;
await _repository.InsertAsync <Course>(course);
_logger.LogInformation($"Added new course: {course.Title}. User {_user}.");
}
var selectedPriorityWithoutNullAndDuplictates = selectedPriority.Where(priority => !string.IsNullOrEmpty(priority)).Distinct().ToArray();
var listOfSelectedPriority = selectedPriorityWithoutNullAndDuplictates.ToList();
int priority = listOfSelectedPriority.IndexOf(program.Name);
if (priority == -1)
{
studentCourse.Priority = null;
}
else
{
studentCourse.Priority = priority + 1;
}
await _repository.InsertAsync <StudentCourse>(studentCourse);
_logger.LogInformation($"Created student: {studentViewModel.FirstName} {studentViewModel.LastName}. User {_user}.");
}
return(backToExam);
}
return(backToExam);
}