public async Task <IActionResult> Create([Bind("FirstName,LastName,cgpa,Id,Year,Semester,DepartmentId,Email")] Student student)
{
if (ModelState.IsValid)
{
var user = new IdentityUser
{
UserName = student.Email,
Email = student.Email,
EmailConfirmed = true
};
const string password = "******";
var res = await _userManager.CreateAsync(user, password);
if (res.Succeeded)
{
await _userManager.AddToRoleAsync(user, "Student");
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
ViewData["DepartmentId"] = new SelectList(_context.Departments, nameof(Department.Id), nameof(Department.Name), student.DepartmentId);
return(View(student));
}
public async Task <IActionResult> Create([Bind("Id,Name,Description")] Department department)
{
if (ModelState.IsValid)
{
_context.Add(department);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(department));
}
public async Task <IActionResult> Create([Bind("Id,DepartmentId,Code,Name,Credits")] Course course)
{
if (ModelState.IsValid)
{
_context.Add(course);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DepartmentId"] = new SelectList(_context.Departments, nameof(Department.Id), nameof(Department.Name), course.DepartmentId);
return(View(course));
}
public async Task <IActionResult> Create([Bind("Id,ExamName,Score,OutOf,EnrollmentStudentId,EnrollmentSectionId")] Mark mark)
{
if (ModelState.IsValid)
{
_context.Add(mark);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["EnrollmentSectionId"] = new SelectList(_context.Enrollments, "SectionId", "SectionId", mark.EnrollmentSectionId);
return(View(mark));
}
public async Task <IActionResult> Create([Bind("Id,Year,Semester,Number,CourseId,TeacherId")] Sections sections)
{
if (ModelState.IsValid)
{
_context.Add(sections);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CourseId"] = new SelectList(_context.Courses, nameof(Course.Id), nameof(Course.Code), sections.CourseId);
ViewData["TeacherId"] = new SelectList(_context.Teachers, nameof(Teacher.Id), nameof(Teacher.FirstName), sections.TeacherId);
return(View(sections));
}
public async Task <IActionResult> Create([Bind("SectionId,StudentId,IsFinished,gpa")] Enrollment enrollment)
{
if (ModelState.IsValid)
{
_context.Add(enrollment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["SectionId"] = new SelectList(_context.Sections, nameof(Sections.Id), nameof(Sections.Number), enrollment.SectionId);
ViewData["StudentId"] = new SelectList(_context.Students, nameof(Student.Id), nameof(Student.FirstName), enrollment.StudentId);
return(View(enrollment));
}
public async Task <ActionResult> Create([Bind(Include = "DepartmentID,DepartmentName,Budget,StartDate,InstructorID")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.InstructorID = new SelectList(db.Instructors, "InstructorID", "LastName", department.InstructorID);
return(View(department));
}
public async Task <IActionResult> Profile(int id)
{
try
{
var user = _userManager.GetUserName(User);
var student = await _context.Students.Include(s => s.Enrollments)
.ThenInclude(e => e.Section)
.ThenInclude(se => se.Course)
.Where(st => st.Email == user)
.FirstOrDefaultAsync();
var enrolls = _context.Enrollments.Include(e => e.marks)
.Where(s => s.StudentId == student.Id);
var department = await _context.Departments.Where(d => d.Id == student.DepartmentId).FirstOrDefaultAsync();
foreach (var enroll in enrolls)
{
decimal sum = 0;
foreach (var mark in enroll.marks)
{
sum += mark.OutOf;
}
if (sum >= 100)
{
enroll.IsFinished = true;
enroll.gpa = enroll.CalculateGpa();
_context.Update(enroll);
}
}
await _context.SaveChangesAsync();
decimal creditSum = 0;
decimal gpamul = 0;
foreach (var enroll in enrolls)
{
creditSum += Convert.ToDecimal(enroll.Section.Course.Credits);
gpamul += Convert.ToDecimal(enroll.Section.Course.Credits * enroll.gpa);
}
student.cgpa = gpamul / creditSum;
if (student == null)
{
return(NotFound());
}
student.Department = department;
return(View(student));
}
catch (Exception e)
{
return(View());
}
}
public async Task <IActionResult> Create(List <Mark> model)
{
try
{
// TODO: Add insert logic here
foreach (var item in model)
{
item.ExamName = model[0].ExamName;
item.OutOf = model[0].OutOf;
_context.Add(item);
}
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (Exception e)
{
return(View());
}
}
