public async Task <IActionResult> Edit(int id, [Bind("Id,CourseId,StudentId")] StudentCourses studentCourses)
{
if (id != studentCourses.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(studentCourses);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentCoursesExists(studentCourses.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index", "Courses"));
}
ViewData["CourseId"] = new SelectList(_context.Courses, "Id", "Title", studentCourses.CourseId);
ViewData["StudentId"] = new SelectList(_context.Students, "Id", "Name", studentCourses.StudentId);
return(View(studentCourses));
}
public List <StudentCourses> GetAllStudentsView()
{
string query = "SELECT * FROM VW_StudentCoursesGrade";
SqlCommand.CommandText = query;
SqlConnection.Open();
SqlDataReader reader = SqlCommand.ExecuteReader();
List <StudentCourses> studentCourseses = new List <StudentCourses>();
while (reader.Read())
{
StudentCourses studentCourse = new StudentCourses
{
StudentId = Convert.ToInt32(reader["Student_Id"].ToString()),
CourseId = Convert.ToInt32(reader["Course_Id"].ToString()),
CourseCode = reader["Code"].ToString(),
CourseName = reader["Name"].ToString(),
GradeName = reader["GradeName"].ToString() != string.Empty
? reader["GradeName"].ToString()
: "Not Graded Yet",
EnrollDate = DateTime.Parse(reader["EnrollDate"].ToString())
};
studentCourseses.Add(studentCourse);
}
reader.Close();
SqlConnection.Close();
return(studentCourseses);
}
public void AssignCourseToStudent(int courseId, int studentId)
{
Course course = db.Courses.Include(c => c.StudentCourses).ThenInclude(sc => sc.Student).FirstOrDefault(c => c.Id == courseId);
Member student = db.Members.Include(m => m.StudentCourses).ThenInclude(sc => sc.Course).FirstOrDefault(m => m.Id == studentId);
if (student.StudentCourses.Any(sc => sc.CourseId == courseId))
{
throw new Exception("The course you are trying to add is already in your schedule.");
}
else if (student.StudentCourses.Any(sc => sc.Course.StartTime == course.StartTime && sc.Course.StartDate == course.StartDate))
{
throw new Exception("This course is at the same time as another course in your schedule.");
}
else if (((student.StudentCourses.Sum(sc => sc.Course.CreditHours) + course.CreditHours) > MaxCreditHours))
{
throw new Exception("Adding this course to your schedule will exceed the amount of credit hours allowed.");
}
else if (course.StudentCourses.Count() >= course.StudentCapacity)
{
throw new Exception("The course you are attemptint to add is already full.");
}
StudentCourses studentCourses = new StudentCourses()
{
StudentId = studentId,
Student = student,
CourseId = courseId,
Course = course
};
course.StudentCourses.Add(studentCourses);
db.SaveChanges();
}
public ActionResult DeleteStudentCourse(int?id)
{
StudentCourses student = db.StudentCourseEntity.Find(id);
db.StudentCourseEntity.Remove(student);
db.SaveChanges();
return(RedirectToAction("StudentIndex"));
}
public ActionResult DeleteConfirmed(int id)
{
StudentCourses studentcourses = db.StudentCourses.Find(id);
db.StudentCourses.Remove(studentcourses);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int UpdateAllStudentCourse(StudentCourses studentCourses)
{
string query = "UPDATE StudentCourses SET GradeId = '" + studentCourses.GradeId + "' WHERE Student_Id = '" + studentCourses.StudentId + "' AND Course_Id = '" + studentCourses.CourseId + "'";
SqlCommand.CommandText = query;
SqlConnection.Open();
int rowAffected = SqlCommand.ExecuteNonQuery();
SqlConnection.Close();
return(rowAffected);
}
public void Fetch(string filepath1, string filepath2, string filepath3)
{
FetchStudent(filepath1);
FetchCourse(filepath2);
FetchStudentCourse(filepath3);
foreach (string line in StudentList)
{
if (line == StudentList[0])
{
continue;
}
else
{
string[] properties = line.Split(',');
Students.Add(new Student {
StudentID = Int32.Parse(properties[0]), StudentName = properties[1], StudentAddress = properties[2], PhoneNumber = properties[3]
});
}
}
foreach (string line in CourseList)
{
if (line == CourseList[0])
{
continue;
}
else
{
string[] properties = line.Split(',');
Courses.Add(new Course {
CourseID = Int32.Parse(properties[0]), CourseName = properties[1]
});
}
}
foreach (string line in StudentCourseList)
{
if (line == StudentCourseList[0])
{
continue;
}
else
{
string[] properties = line.Split(',');
StudentCourses.Add(new StudentCourse {
id = Int32.Parse(properties[0]), StudentID = Int32.Parse(properties[1]), CourseID = Int32.Parse(properties[2])
});
}
}
}
public async Task <IActionResult> Create([Bind("StudentCourseId,StudentId,CourseName")] StudentCourses studentCourses)
{
if (ModelState.IsValid)
{
_context.Add(studentCourses);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["StudentId"] = new SelectList(_context.Students, "StudentId", "StudentId", studentCourses.StudentId);
return(View(studentCourses));
}
public ActionResult Edit([Bind(Include = "ID,StudentID,CourseID,AssignedOn")] StudentCourses studentcourses)
{
if (ModelState.IsValid)
{
db.Entry(studentcourses).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.Courses, "ID", "Code", studentcourses.CourseID);
ViewBag.StudentID = new SelectList(db.Students, "ID", "Name", studentcourses.StudentID);
return(View(studentcourses));
}
// GET: /StudentCourses/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentCourses studentcourses = db.StudentCourses.Find(id);
if (studentcourses == null)
{
return(HttpNotFound());
}
return(View(studentcourses));
}
public void CoursesforStudent(int id)
{
// IEnumerable<StudentCourse> result = new List<StudentCourse>();
IEnumerable <StudentCourse> studentcourse = new List <StudentCourse>();
studentcourse = StudentCourses.Where(s => s.StudentID == id);
foreach (StudentCourse scourse in studentcourse)
{
// course = Courses.Where(c => c.CourseID == scourse.CourseID).ToList();
Course course = new Course();
course = Courses.Find(c => c.CourseID == scourse.CourseID);
result.Add(course);
}
}
public async Task <StudentCourses> GetCourseToStudentAsync(Guid studentId)
{
var student = await GetStudentAsync(studentId);
var model = new StudentCourses
{
Student = new StudentsForDisplay {
Id = student.Id, Name = student.FirstName
},
CurrentCourseIds = _uow.GetRepository <CourseUser>().Where(x => x.UserId == studentId).Select(x => x.CourseId).ToArray(),
Courses = GetList().ToDictionary(x => x.Id, x => x.Name)
};
return(model);
}
public void AssignStudentToCourse(int studentId, int courseId)
{
Course course = GetCourse(courseId);
Member student = GetStudent(studentId);
StudentCourses studentCourses = new StudentCourses()
{
StudentId = studentId,
Student = student,
CourseId = courseId,
Course = course
};
course.StudentCourses.Add(studentCourses);
db.SaveChanges();
}
public void RemoveStudentFromCourse(int studentId, int courseId)
{
Member student = db.Members.FirstOrDefault(m => m.Id == studentId);
Course course = db.Courses.FirstOrDefault(c => c.Id == courseId);
StudentCourses studentCourses = new StudentCourses()
{
StudentId = studentId,
Student = student,
CourseId = courseId,
Course = course
};
course.StudentCourses.Remove(studentCourses);
db.SaveChanges();
}
// GET: /StudentCourses/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentCourses studentcourses = db.StudentCourses.Find(id);
if (studentcourses == null)
{
return(HttpNotFound());
}
ViewBag.CourseID = new SelectList(db.Courses, "ID", "Code", studentcourses.CourseID);
ViewBag.StudentID = new SelectList(db.Students, "ID", "Name", studentcourses.StudentID);
return(View(studentcourses));
}
public async Task <bool> AddStudentCourse(StudentCourseInputDto input)
{
if (input != null)
{
foreach (var course in input.Courses)
{
StudentCourses s1 = new StudentCourses();
s1.CourseGuid = course.Id.Value;
s1.StudentGuid = input.StudentGuid;
_context.Add(s1);
}
}
await _context.SaveChangesAsync();
return(true);
}
public void AddStudentToCourse(int studentId, int courseId)
{
StudentCourses studentCourses = new StudentCourses()
{
CourseId = courseId,
StudentId = studentId
};
try
{
data.studentCourses.Add(studentCourses);
}
catch (Exception ex)
{
logger.Log(ex.Message);
}
}
public ActionResult courseSelected(string[] courses)
{
string course_id = Request["course"];
string student_id = Request["user_id"];
// int[] nums = Array.ConvertAll(course_id.Split(','), int.Parse);
for (int i = 0; i < courses.Length; i++)
{
StudentCourses coursess = new StudentCourses();
coursess.SID = student_id;
coursess.CID = courses[i];
db.StudentCourses.Add(coursess);
db.SaveChanges();
}
return(Content(student_id));
}
public static void Seed(ModelBuilder modelBuilder)
{
//create arrays for each entity
var teachers = new Teacher[]
{
//put teachers here
new Teacher{Id=1,Firstname="TopDog",Lastname="Soete" },
new Teacher{Id=2,Firstname="Willie",Lastname="Schokellé" },
new Teacher{Id=3,Firstname="Sieggie",Lastname="Derdeyn" }
};
var students = new Student[]
{
//put students here
new Student{Id=1,Firstname="Jimmy",Lastname="Page" },
new Student{Id=2,Firstname="Rory",Lastname="Gallagher" },
new Student{Id=3,Firstname="Pino",Lastname="Daniele" },
};
var courses = new Course[]
{
//put courses here
new Course{Id=1,Title="WBA",TeacherId=3 },
new Course{Id=2,Title="WFA",TeacherId=2 },
new Course{Id=3,Title="DBS",TeacherId=1 }
};
var studentCourses = new StudentCourses[]
{
//put studentCourses here
new StudentCourses{StudentId=1,CourseId=2},
new StudentCourses{StudentId=1,CourseId=1},
new StudentCourses{StudentId=1,CourseId=3},
new StudentCourses{StudentId=2,CourseId=1},
new StudentCourses{StudentId=2,CourseId=2},
new StudentCourses{StudentId=2,CourseId=3},
new StudentCourses{StudentId=3,CourseId=1},
new StudentCourses{StudentId=3,CourseId=2},
new StudentCourses{StudentId=3,CourseId=3},
};
//add the seeding data to the entity HasData()
modelBuilder.Entity<Teacher>().HasData(teachers);
modelBuilder.Entity<Student>().HasData(students);
modelBuilder.Entity<Course>().HasData(courses);
modelBuilder.Entity<StudentCourses>().HasData(studentCourses);
}
public async Task <IActionResult> DeleteStudentCourses([FromBody] StudentCourses studentCourses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var studentCoursesEntry = await _context.StudentCourses.FindAsync(studentCourses.StudentId, studentCourses.CourseId);
if (studentCoursesEntry == null)
{
return(NotFound());
}
_context.StudentCourses.Remove(studentCoursesEntry);
await _context.SaveChangesAsync();
return(Ok(studentCoursesEntry));
}
public async Task <IActionResult> PostStudentCourses([FromBody] StudentCourses studentCourses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var course = _context.Courses.FirstOrDefault(c => c.Id == studentCourses.CourseId);
var student = _context.Students.FirstOrDefault(s => s.Id == studentCourses.StudentId);
if (course == null || student == null)
{
return(BadRequest());
}
var studentCoursesEntry = new StudentCourses
{
CourseId = course.Id,
StudentId = student.Id,
Course = course,
Student = student
};
_context.StudentCourses.Add(studentCoursesEntry);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (StudentCoursesExists(studentCourses.StudentId))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(CreatedAtAction("GetStudentCourses", new { id = studentCoursesEntry.StudentId }, studentCoursesEntry));
}
public ActionResult StudentIndex(String Courses)
{
int courseID = Int32.Parse(Courses);
Courses course = db.CoursesEntity.Find(courseID);
StudentCourses student = new StudentCourses();
student.Username = User.Identity.Name;
student.CourseId = courseID;
student.CourseName = course.CourseName;
student.CourseCredits = course.CourseCredits;
student.LecturerId = course.LecturerId;
student.LecturerName = course.LecturerName;
student.LecturerLastname = course.LecturerLastname;
db.StudentCourseEntity.Add(student);
db.SaveChanges();
return(RedirectToAction("StudentIndex"));
}
public ActionResult SaveResult(StudentCourses studentCourses)
{
List <StudentCourses> studentIds = studentCoursesManager.GetAllStudentCourse().Where(a => a.StudentId == studentCourses.StudentId && a.CourseId == studentCourses.CourseId).ToList();
if (ModelState.IsValid)
{
var count = studentIds.Count;
if (count == 1)
{
foreach (var item in studentIds)
{
if (item.GradeId == string.Empty)
{
ViewBag.Message = studentCoursesManager.UpdateAllStudentCourse(studentCourses)
? " Student result saved Successfully"
: "Student result is not Saved";
}
else
{
ViewBag.FailMessage = "Result has Already asigned to this student";
}
}
}
else
{
ViewBag.FailMessage = "You are not enrolled in the course! Please enrolled first!!";
}
}
else
{
ViewBag.FailMessage = "Please Fill Up Data properly!!";
}
List <Student> students = studentMangager.GetAllStudents();
ViewBag.studentsList = students;
List <Grade> grades = gradeManager.GetAllGrades();
ViewBag.gradesList = grades;
return(View());
}
public IActionResult Assign(int id)
{
var record = _teacherCoursesRepository.GetById(id);
if (record == null)
{
return(NotFound());
}
var user = _usersRepository.GetByName(HttpContext.User.Identity.Name).GetAwaiter().GetResult();
var item = new StudentCourses
{
CourseId = id,
UserId = user.Id
};
_teacherCoursesRepository.AssignToCourse(item);
return(Ok());
}
public int SaveAllStudentCourses(StudentCourses studentCourses)
{
string query = "INSERT INTO StudentCourses(Student_Id,Course_Id,EnrollDate) VALUES(@studentId,@courseId,@enrollDate)";
SqlCommand.CommandText = query;
SqlCommand.Parameters.Clear();
SqlCommand.Parameters.Add("@studentId", SqlDbType.Int);
SqlCommand.Parameters["@studentId"].Value = studentCourses.StudentId;
SqlCommand.Parameters.Add("@courseId", SqlDbType.Int);
SqlCommand.Parameters["@courseId"].Value = studentCourses.CourseId;
SqlCommand.Parameters.Add("@enrollDate", SqlDbType.Date);
SqlCommand.Parameters["@enrollDate"].Value = studentCourses.EnrollDate;
SqlConnection.Open();
int rowaffected = SqlCommand.ExecuteNonQuery();
SqlConnection.Close();
return(rowaffected);
}
public ActionResult EnrollCourse(StudentCourses studentCourses)
{
List <StudentCourses> studentIds = studentCoursesManager.GetAllStudentCourse().Where(a => a.StudentId == studentCourses.StudentId && a.CourseId == studentCourses.CourseId).ToList();
if (ModelState.IsValid)
{
if (studentIds.Count == 0)
{
ViewBag.Message = studentCoursesManager.SaveAllStudentCourse(studentCourses)
? "Student enrolled into department successfully!"
: "Student Enrolled is not Saved Successfully";
}
else
{
ViewBag.FailMessage = "Student has already enrolled in this course.";
}
}
List <Student> students = studentMangager.GetAllStudents();
ViewBag.studentsList = students;
return(View());
}
public List <StudentCourses> GetAllStudentCourse()
{
string query = "SELECT * FROM StudentCourses";
SqlCommand.CommandText = query;
SqlConnection.Open();
SqlDataReader reader = SqlCommand.ExecuteReader();
List <StudentCourses> studentCourseses = new List <StudentCourses>();
while (reader.Read())
{
StudentCourses studentCourse = new StudentCourses
{
StudentId = Convert.ToInt32(reader["Student_Id"].ToString()),
CourseId = Convert.ToInt32(reader["Course_Id"].ToString()),
GradeId = reader["GradeId"].ToString(),
};
studentCourseses.Add(studentCourse);
}
reader.Close();
SqlConnection.Close();
return(studentCourseses);
}
public async Task <IActionResult> PutStudentCourses([FromRoute] string IdentityId, [FromRoute] int CourseId, [FromBody] StudentCourses studentCourses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
// IdentityId should replaced with StudentId
if (IdentityId != studentCourses.Student.IdentityId || CourseId != studentCourses.CourseId)
{
return(BadRequest());
}
_context.Entry(studentCourses).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
// studentCourses.StudentId should be StudentId that will have to be in the parameters instead of IdentityId
if (!StudentCoursesExists(studentCourses.StudentId, CourseId))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public bool UpdateAllStudentCourse(StudentCourses studentCourses)
{
return(studentCoursesGateway.UpdateAllStudentCourse(studentCourses) > 0);
}
public bool SaveAllStudentCourse(StudentCourses studentCourses)
{
return(studentCoursesGateway.SaveAllStudentCourses(studentCourses) > 0);
}
