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()); } }