private CourceViewModel GetCourseModel(int courseId)
{
ApplicationDbContext dbContext = new ApplicationDbContext();
var _coursedb = dbContext.Courses.FirstOrDefault(x => x.Id == courseId);
if (_coursedb != null)
{
var _lecture = dbContext.Lectures.FirstOrDefault(x => x.CourseId == _coursedb.Id);
var _seminar = dbContext.Seminars.FirstOrDefault(x => x.CourseId == _coursedb.Id);
var _discipline = dbContext.Disciplines.FirstOrDefault(x => x.Id == _coursedb.DisciplineId);
var _lectureProf = dbContext.Workers.FirstOrDefault(x => x.id == _lecture.ProcessorId);
var _seminarProf = dbContext.Workers.FirstOrDefault(x => x.id == _lecture.ProcessorId);
var _course = new CourceViewModel
{
Title = _discipline.Title,
CreditCount = _seminar.CreditCount + _lecture.CreditCount,
lecCreditCount = _lecture.CreditCount,
SemCreditCount = _seminar.CreditCount,
lecProfessor = _lectureProf.LastName + " " + _lectureProf.Firstname + "(" + _lectureProf.ScienceDegree + ")",
semProfessor = _seminarProf.LastName + " " + _seminarProf.Firstname + "(" + _seminarProf.ScienceDegree + ")",
Description = _discipline.Description,
Literatures = _discipline.Literatures,
CourseId = _coursedb.Id
};
return(_course);
}
else
{
return(null);
}
}
public ActionResult MyCourses(int id)
{
ApplicationDbContext dbContext = new ApplicationDbContext();
var courses = new List <CourceViewModel>();
var studentCourses = dbContext.StudentCources.Where(x => x.StudentId == id).ToList();
var _courses = new List <Course>();
if (studentCourses.Count != 0 && studentCourses != null)
{
foreach (var item in studentCourses)
{
_courses.Add(dbContext.Courses.FirstOrDefault(x => x.Id == item.CourceId));
}
}
if (_courses.Count != 0)
{
try
{
foreach (var item in _courses)
{
var _lecture = dbContext.Lectures.FirstOrDefault(x => x.CourseId == item.Id);
var _seminar = dbContext.Seminars.FirstOrDefault(x => x.CourseId == item.Id);
var _discipline = dbContext.Disciplines.FirstOrDefault(x => x.Id == item.DisciplineId);
var _lectureProf = dbContext.Workers.FirstOrDefault(x => x.id == _lecture.ProcessorId);
var _seminarProf = dbContext.Workers.FirstOrDefault(x => x.id == _lecture.ProcessorId);
var _course = new CourceViewModel
{
Title = _discipline.Title,
CreditCount = _seminar.CreditCount + _lecture.CreditCount,
lecCreditCount = _lecture.CreditCount,
SemCreditCount = _seminar.CreditCount,
lecProfessor = _lectureProf.LastName + " " + _lectureProf.Firstname + "(" + _lectureProf.ScienceDegree + ")",
semProfessor = _seminarProf.LastName + " " + _seminarProf.Firstname + "(" + _seminarProf.ScienceDegree + ")",
Description = _discipline.Description,
Literatures = _discipline.Literatures,
CourseId = item.Id,
isElective = item.IsElective
};
courses.Add(_course);
}
return(View(courses));
}
catch (Exception)
{
ViewBag.Success = false;
ViewBag.Message = "Произашла ошибка при загрузке данных";
return(View("Result"));
}
}
else
{
ViewBag.Success = false;
ViewBag.Message = "Созданных курсов нет. Добавьте чтобы посмотреть";
return(View("Result"));
}
}
public ActionResult Course(int applicantId, string university)
{
var courses = _courseService.GetCourses(university);
var viewModel = new CourceViewModel
{
ApplicantId = applicantId,
University = university,
CourseHolders = courses.Select(x => BuildHolder(applicantId, x)).ToList()
};
return(View(viewModel));
}
public ActionResult SubscriptionRequest(int id)
{
ApplicationDbContext dbContext = new ApplicationDbContext();
CourceSubscriptionViewModel model = new CourceSubscriptionViewModel();
var sub = dbContext.CourseSubscriptionRequests.FirstOrDefault(x => x.Id == id);
Student _student = dbContext.Students.FirstOrDefault(x => x.Id == sub.StudentId);
CourceViewModel _courceViewModel = GetCourseModel(id);
model.student = _student;
model.cource = _courceViewModel;
model.status = sub.status;
model.SubId = sub.Id;
return(View(model));
}
public ActionResult StudentCourse(int id)
{
ApplicationDbContext dbContext = new ApplicationDbContext();
var _coursedb = dbContext.Courses.FirstOrDefault(x => x.Id == id);
if (_coursedb != null)
{
try
{
var _lecture = dbContext.Lectures.FirstOrDefault(x => x.CourseId == _coursedb.Id);
var _seminar = dbContext.Seminars.FirstOrDefault(x => x.CourseId == _coursedb.Id);
var _discipline = dbContext.Disciplines.FirstOrDefault(x => x.Id == _coursedb.DisciplineId);
var _lectureProf = dbContext.Workers.FirstOrDefault(x => x.id == _lecture.ProcessorId);
var _seminarProf = dbContext.Workers.FirstOrDefault(x => x.id == _seminar.ProcessorId);
var _course = new CourceViewModel
{
Title = _discipline.Title,
CreditCount = _seminar.CreditCount + _lecture.CreditCount,
lecCreditCount = _lecture.CreditCount,
SemCreditCount = _seminar.CreditCount,
lecProfessor = _lectureProf.LastName + " " + _lectureProf.Firstname + "(" + _lectureProf.ScienceDegree + ")",
semProfessor = _seminarProf.LastName + " " + _seminarProf.Firstname + "(" + _seminarProf.ScienceDegree + ")",
Description = _discipline.Description,
Literatures = _discipline.Literatures,
CourseId = _coursedb.Id
};
return(View(_course));
}
catch (Exception)
{
ViewBag.Success = false;
ViewBag.Message = "Произашла ошибка при загрузке данных";
return(View("Result"));
}
}
else
{
ViewBag.Success = false;
ViewBag.Message = "Произашла ошибка при загрузке данных";
return(View("Result"));
}
}
public ActionResult CourseSubscriptionRequests()
{
ApplicationDbContext dbContext = new ApplicationDbContext();
List <CourceSubscriptionViewModel> model = new List <CourceSubscriptionViewModel>();
var subs = dbContext.CourseSubscriptionRequests.ToList();
if (subs.Count != 0 && subs != null)
{
foreach (var item in subs)
{
Student _student = dbContext.Students.FirstOrDefault(x => x.Id == item.StudentId);
CourceViewModel _courceViewModel = GetCourseModel(item.CourseId);
model.Add(new CourceSubscriptionViewModel
{
student = _student,
cource = _courceViewModel,
status = item.status,
SubId = item.Id
});
}
}
return(View(model));
}