public ActionResult Save(User professor, HttpPostedFileBase file, HttpPostedFileBase cv)
{
var professorInDb = _context.Users.Single(c => c.Id == professor.Id);
professorInDb.FullName = professor.FullName;
professorInDb.Email = professor.Email;
if (file != null)
{
byte[] imageData = null;
using (var binary = new BinaryReader(file.InputStream))
{
imageData = binary.ReadBytes(file.ContentLength);
professor.UserPhoto = imageData;
}
}
if (cv != null)
{
byte[] cvPdf = null;
using (var binary = new BinaryReader(cv.InputStream))
{
cvPdf = binary.ReadBytes(cv.ContentLength);
professor.CV = cvPdf;
}
}
_context.SaveChanges();
return(RedirectToAction("Index", "Professor"));
}
/// <summary>
/// Deletes the group and the members of the group.
/// </summary>
/// <param name="id">The identifier.</param>
/// <exception cref="CustomException"></exception>
public void DeleteGroup(int id)
{
try {
using (var db = new ELearningDatabaseEntities()) {
//delete the members of the group to be deleted
List <GroupMembers> membersOfDeletedGroup = db.GroupMembers
.Where(m => m.GroupId == id)
.ToList();
foreach (var m in membersOfDeletedGroup)
{
db.GroupMembers.Remove(m);
}
db.SaveChanges();
//delete the group
Groups group = db.Groups
.Where(g => g.GroupId == id)
.First();
db.Groups.Remove(group);
db.SaveChanges();
}
}
catch (InvalidOperationException ioe) {
throw new CustomException(ioe.Message);
}
}
/// <summary>
/// Deletes the homework.
/// </summary>
/// <param name="id">The identifier.</param>
/// <exception cref="CustomException">
/// </exception>
public void DeleteHomework(int id)
{
try {
using (var db = new ELearningDatabaseEntities()) {
//delete the assignements for the homework
var assignementsToDelete = db.HomeworkAssignements
.Where(a => a.HomeworkId == id)
.ToList();
foreach (var a in assignementsToDelete)
{
db.HomeworkAssignements.Remove(a);
}
db.SaveChanges();
//delete the homework
Homeworks hw = db.Homeworks
.Where(h => h.HomeworkId == id)
.First();
db.Homeworks.Remove(hw);
db.SaveChanges();
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Delete a forum with the specified Id
/// </summary>
/// <param name="id"></param>
public void DeleteForum(int?id)
{
try {
using (var db = new ELearningDatabaseEntities()) {
List <Messages> messages = db.Messages
.Where(x => x.ForumId == id)
.ToList();
foreach (Messages m in messages)
{
db.Messages.Remove(m);
db.SaveChanges();
}
Forums forum = db.Forums
.Where(x => x.ForumId == id)
.First();
db.Forums.Remove(forum);
db.SaveChanges();
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
public IHttpActionResult CreateQuestion(QuestionDto questionDto)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var question = Mapper.Map <QuestionDto, Question>(questionDto);
_context.Questions.Add(question);
_context.SaveChanges();
questionDto.Id = question.Id;
return(Created(new Uri(Request.RequestUri + "/" + question.Id), questionDto));
}
/// <summary>
/// Deletes the module.
/// </summary>
/// <param name="id">The identifier.</param>
/// <exception cref="CustomException">
/// </exception>
public void DeleteModule(int id)
{
try {
using (var db = new ELearningDatabaseEntities()) {
var result = db.Resources
.First(x => x.ModuleID == id);
if (result != null)
{
var resourceList = db.Resources.Where(x => x.ModuleID == result.ModuleID).ToList();
foreach (var resursa in resourceList)
{
DeleteFile(resursa.FileId);
db.Resources.Remove(resursa);
}
string fileId = result.FileId;
//for drive
this.DeleteFile(fileId);
db.Resources.Remove(result);
db.SaveChanges();
}
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ioe) {
throw new CustomException(ioe.Message);
}
catch (Exception ex) {
throw new CustomException(ex.Message);
}
}
public ActionResult Delete(int id)
{
var question = _context.Questions.SingleOrDefault(c => c.Id == id);
var questionid = question.CourseID_Id;
_context.Questions.Remove(question);
_context.SaveChanges();
var viewModel = new SelectedQuestionsViewModel
{
Question = _context.Questions.Where(c => c.CourseID_Id.Equals(questionid)).ToList(),
Course_id = questionid,
};
return(View("Index", viewModel));
}
/// <summary>
/// Assigns the homework.
/// </summary>
/// <param name="dto"></param>
/// <exception cref="CustomException">
/// </exception>
public void AssignHomework(HomeworkAssignementDTO dto)
{
try {
using (var db = new ELearningDatabaseEntities()) {
HomeworkAssignements ha = db.HomeworkAssignements
.Where(a => a.AssignementId == dto.AssignementId)
.FirstOrDefault();
if (ha != null)
{
if (dto.StudentId != null && dto.StudentId > 0)
{
ha.StudentId = dto.StudentId;
}
if (dto.GroupId != null && dto.GroupId > 0)
{
ha.GroupId = dto.GroupId;
}
db.HomeworkAssignements.Attach(ha);
db.Entry(ha).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
else
{
HomeworkAssignements newAssignement = new HomeworkAssignements();
newAssignement.AnswerId = dto.AnswerId;
newAssignement.AssignementId = dto.AssignementId;
newAssignement.CourseId = dto.CourseId;
newAssignement.CourseModuleId = dto.CourseModuleId;
newAssignement.GradeId = dto.GradeId;
newAssignement.GroupId = dto.GroupId;
newAssignement.HomeworkId = dto.HomeworkId;
newAssignement.StudentId = dto.StudentId;
db.HomeworkAssignements.Add(newAssignement);
db.SaveChanges();
}
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
public ActionResult Delete(string id)
{
var studentInDb = _context.Users.SingleOrDefault(c => c.Id == id);
_context.Users.Remove(studentInDb);
_context.Subscriptions.RemoveRange(_context.Subscriptions.Where(c => c.Student_Id == id));
_context.SaveChanges();
return(View("Index"));
}
/// <summary>
/// Grades the homework.
/// </summary>
/// <param name="grade">The grade.</param>
/// <param name="dto">The homework grade dto.</param>
/// <exception cref="CustomException">
/// </exception>
public void GradeHomework(Grades grade, HomeworkGradeDTO dto)
{
try {
using (var db = new ELearningDatabaseEntities()) {
HomeworkAssignements ha = db.HomeworkAssignements
.Where(h => h.AssignementId == dto.AssignementId)
.First();
//if the homework was already graded, we just update the grade value
if (ha.GradeId != null && ha.GradeId > 0)
{
Grades gr = db.Grades
.Where(g => g.GradeId == ha.GradeId)
.First();
gr.GradeValue = grade.GradeValue;
gr.Gradedatetime = grade.Gradedatetime;
db.Grades.Attach(gr);
db.Entry(gr).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
else
{
//add the new grade
db.Grades.Add(grade);
db.SaveChanges();
//attach the grade to the homework
ha.GradeId = grade.GradeId;
db.HomeworkAssignements.Attach(ha);
db.Entry(ha).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ioe) {
throw new CustomException(ioe.Message);
}
}
/// <summary>
/// Submits the homework.
/// </summary>
/// <param name="assignementId">The assignement identifier.</param>
/// <param name="answer">The answer.</param>
/// <exception cref="CustomException">
/// </exception>
public void SubmitHomework(int assignementId, Answers answer)
{
try {
using (var db = new ELearningDatabaseEntities()) {
HomeworkAssignements ha = db.HomeworkAssignements
.Where(a => a.AssignementId == assignementId)
.First();
//if answer doesn't already exist
if (ha.AnswerId == null)
{
//add the new answer
db.Answers.Add(answer);
db.SaveChanges();
//add the newly created answer to the homework
ha.AnswerId = answer.AnswerId;
db.HomeworkAssignements.Attach(ha);
db.Entry(ha).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
else
{
//else only update the existing answer
Answers ans = db.Answers
.Where(a => a.AnswerId == ha.AnswerId)
.First();
ans.AnswerValue = answer.AnswerValue;
db.Answers.Attach(ans);
db.Entry(ans).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Enrol a student to a course
/// </summary>
/// <param name= "usersInCourses">The module.</param>
/// <exception cref="CustomException"></exception>
public void EnrollStudentInCourse(UsersInCourse usersInCourses)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.UsersInCourse.Add(usersInCourses);
db.SaveChanges();
}
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Saves the resources to database.
/// </summary>
/// <param name="resources">The resources.</param>
/// <exception cref="CustomException"></exception>
public void SaveResourcesToDb(Resources resources)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Resources.Add(resources);
db.SaveChanges();
}
}
catch (Exception ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Adds the specified module.
/// </summary>
/// <param name="module">The module.</param>
/// <exception cref="CustomException"></exception>
public void AddModule(CourseModule module)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.CourseModule.Add(module);
db.SaveChanges();
}
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Deletes all logs.
/// </summary>
/// <exception cref="CustomException"></exception>
public void DeleteAllDisplayedLogs()
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Database.ExecuteSqlCommand("TRUNCATE TABLE Logs");
db.SaveChanges();
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
}
public ViewResult Subscribe(int id)
{
var course = _context.Courses.SingleOrDefault(c => c.Id == id);
var viewmodel = new CourseFormViewModel
{
Course = course,
Professor = _context.Users.ToList()
};
var studentId = User.Identity.GetUserId();
var firstQuery = _context.Users.Single(c => c.Id == studentId);
Subscription newSubscription = new Subscription()
{
Student_Id = firstQuery.Id,
Course_Id = course.Id
};
_context.Subscriptions.Add(newSubscription);
_context.SaveChanges();
return(View("Details", viewmodel));
}
/// <summary>
/// Adds the homework.
/// </summary>
/// <param name="hw">The hw.</param>
/// <exception cref="CustomException"></exception>
public void AddHomework(Homeworks hw)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Homeworks.Add(hw);
db.SaveChanges();
}
}
catch (InvalidOperationException ioe) {
throw new CustomException(ioe.Message);
}
}
/// <summary>
/// Edits the specified course.
/// </summary>
/// <param name="course">The course.</param>
/// <exception cref="CustomException"></exception>
public void EditCourse(Courses course)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Courses.Attach(course);
db.Entry(course).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Edits the homework.
/// </summary>
/// <param name="hw">The hw.</param>
/// <exception cref="CustomException"></exception>
public void EditHomework(Homeworks hw)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Homeworks.Attach(hw);
db.Entry(hw).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Adds the group.
/// </summary>
/// <param name="group">The group.</param>
/// <returns></returns>
/// <exception cref="CustomException"></exception>
public Groups AddGroup(Groups group)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Groups.Add(group);
db.SaveChanges();
}
return(group);
}
catch (InvalidOperationException ioe) {
throw new CustomException(ioe.Message);
}
}
/// <summary>
/// Edits the group.
/// </summary>
/// <param name="group">The group.</param>
/// <exception cref="CustomException"></exception>
public void EditGroup(Groups group)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Groups.Attach(group);
db.Entry(group).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
catch (InvalidOperationException ioe) {
throw new CustomException(ioe.Message);
}
}
public IHttpActionResult DeleteProfessor(string id)
{
var professorInDb = _context.Users.SingleOrDefault(c => c.Id == id);
if (professorInDb == null)
{
return(NotFound());
}
_context.Users.Remove(professorInDb);
_context.SaveChanges();
return(Ok());
}
public IHttpActionResult DeleteStudent(string id)
{
var studentInDb = _context.Users.SingleOrDefault(c => c.Id == id);
if (studentInDb == null)
{
return(NotFound());
}
var subscriptions = _context.Subscriptions.Where(x => x.Student_Id == id).ToList();
if (subscriptions != null)
{
_context.Subscriptions.RemoveRange(subscriptions);
_context.SaveChanges();
}
_context.Users.Remove(studentInDb);
_context.SaveChanges();
return(Ok());
}
/// <summary>
/// Update a message in a forum
/// </summary>
/// <param name="message"></param>
public void UpdateMessage(Messages message)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Messages.Attach(message);
db.Entry(message).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ioe) {
throw new CustomException(ioe.Message);
}
}
/// <summary>
/// Add the specified forum.
/// </summary>
/// <param name="course">The forum.</param>
/// <exception cref="CustomException"></exception>
public void AddForum(Forums forums)
{
if (forums.Category.Equals(""))
{
throw new CustomException("Category cannot be empty");
}
try {
using (var db = new ELearningDatabaseEntities()) {
db.Forums.Add(forums);
db.SaveChanges();
}
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Edit a category from the specified Forum
/// </summary>
/// <param name="forum"></param>
public void EditCategory(Forums forum)
{
try {
using (var db = new ELearningDatabaseEntities()) {
db.Forums.Attach(forum);
db.Entry(forum).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Deletes the log.
/// </summary>
/// <param name="id">The identifier.</param>
/// <exception cref="CustomException"></exception>
public void DeleteLog(int id)
{
try {
using (var db = new ELearningDatabaseEntities()) {
Logs log = db.Logs
.Where(l => l.Id == id)
.FirstOrDefault();
db.Logs
.Remove(log);
db.SaveChanges();
}
}
catch (ArgumentNullException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Updates the user.
/// </summary>
/// <param name="user">The user.</param>
/// <exception cref="CustomException"></exception>
public void UpdateUser(Users user)
{
try {
using (var db = new ELearningDatabaseEntities()) {
if (user != null)
{
db.Users.Attach(user);
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
}
}
catch (ArgumentNullException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Unenroll a student from a course with specified id
/// </summary>
/// <param name="id">The identifier.</param>
/// <exception cref="CustomException">
/// </exception>
public void UnenrollCourse(int id)
{
try {
using (var db = new ELearningDatabaseEntities()) {
UsersInCourse c = db.UsersInCourse
.Where(x => x.CourseId == id)
.First();
db.UsersInCourse.Remove(c);
db.SaveChanges();
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}
/// <summary>
/// Deletes the module with the specified identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <exception cref="CustomException">
/// </exception>
public void DeleteModule(int id)
{
try {
using (var db = new ELearningDatabaseEntities()) {
CourseModule cm = db.CourseModule
.Where(x => x.ModuleId == id)
.First();
db.CourseModule.Remove(cm);
db.SaveChanges();
}
}
catch (ArgumentNullException ane) {
throw new CustomException(ane.Message);
}
catch (InvalidOperationException ex) {
throw new CustomException(ex.Message);
}
}