/// <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 ELearningDatabaseEntitiesServer()) {
             db.CourseModule.Add(module);
             db.SaveChanges();
         }
     }
     catch (InvalidOperationException ex) {
         throw new CustomException(ex.Message);
     }
 }
 /// <summary>
 /// Gets all logs.
 /// </summary>
 /// <returns></returns>
 /// <exception cref="CustomException"></exception>
 public List<Logs> GetAllLogs()
 {
     try {
         using (var db = new ELearningDatabaseEntitiesServer()) {
             return db.Logs
                         .OrderBy(x => x.EventDateTime)
                         .ToList();
         }
     }
     catch (ArgumentNullException ex) {
         throw new CustomException(ex.Message);
     }
 }
 /// <summary>
 /// Gets the log by datetime.
 /// </summary>
 /// <param name="datetime">The datetime.</param>
 /// <returns></returns>
 /// <exception cref="CustomException"></exception>
 public List<Logs> GetLogByDatetime(DateTime datetime)
 {
     try {
         using (var db = new ELearningDatabaseEntitiesServer()) {
             return db.Logs
                         .Where(l => l.EventDateTime.Year == datetime.Year
                                         && l.EventDateTime.Month == datetime.Month
                                         && l.EventDateTime.Day == datetime.Day)
                         .ToList();
         }
     }
     catch (ArgumentNullException 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 ELearningDatabaseEntitiesServer()) {
             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>
 /// 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 ELearningDatabaseEntitiesServer()) {
             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);
     }
 }
        /// <summary>
        /// Gets the course by identifier.
        /// </summary>
        /// <param name="id">The identifier.</param>
        /// <returns></returns>
        /// <exception cref="CustomException"></exception>
        public Courses GetCourseById(int? id)
        {
            try {
                Courses toBeReturned;
                using (var db = new ELearningDatabaseEntitiesServer()) {
                    toBeReturned = db.Courses
                                        .FirstOrDefault(x => x.CourseId == id);
                }

                return toBeReturned;
            }
            catch (ArgumentNullException ex) {
                throw new CustomException(ex.Message);
            }
        }
 /// <summary>
 /// Gets all modules for the course with the specified identifier.
 /// </summary>
 /// <param name="courseId">The course identifier.</param>
 /// <returns></returns>
 /// <exception cref="CustomException"></exception>
 public List<CourseModule> GetAllModules(int? courseId)
 {
     try {
         List<CourseModule> tobeReturned;
         using (var db = new ELearningDatabaseEntitiesServer()) {
             tobeReturned = db.CourseModule
                                 .Where(x => x.CourseId == courseId)
                                 .ToList();
         }
         return tobeReturned;
     }
     catch (ArgumentNullException ex) {
         throw new CustomException(ex.Message);
     }
 }
        /// <summary>
        /// Gets all courses.
        /// </summary>
        /// <returns></returns>
        /// <exception cref="CustomException"></exception>
        public List<Courses> GetAllCourses()
        {
            try {
                List<Courses> courses;
                using (var db = new ELearningDatabaseEntitiesServer()) {
                    courses = db.Courses
                                    .ToList();
                }

                return courses;
            }
            catch (ArgumentNullException ane) {
                throw new CustomException(ane.Message);
            }
        }
 /// <summary>
 /// Edits the specified course.
 /// </summary>
 /// <param name="course">The course.</param>
 /// <exception cref="CustomException"></exception>
 public void Edit(Courses course)
 {
     try {
         using (var db = new ELearningDatabaseEntitiesServer()) {
             Courses course1 = db.Courses.Where(x => x.CourseId == course.CourseId).First();
             db.Courses.Remove(course1);
             db.SaveChanges();
             db.Courses.Add(course);
             db.SaveChanges();
         }
     }
     catch (InvalidOperationException ex) {
         throw new CustomException(ex.Message);
     }
 }
 /// <summary>
 /// Gets the logs containing the given information.
 /// </summary>
 /// <param name="eventUserLogged">The event containing the given information.</param>
 /// <returns></returns>
 /// <exception cref="CustomException"></exception>
 public List<Logs> GetLogByEventInfo(string eventInfo)
 {
     try {
         using (var db = new ELearningDatabaseEntitiesServer()) {
             return db.Logs
                         .Where(l => l.EventInfo.Contains(eventInfo))
                         .ToList();
         }
     }
     catch (ArgumentNullException ex) {
         throw new CustomException(ex.Message);
     }
 }
 /// <summary>
 /// Gets the log by identifier.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 /// <exception cref="CustomException"></exception>
 public Logs GetLogById(int id)
 {
     try {
         using (var db = new ELearningDatabaseEntitiesServer()) {
             return db.Logs
                         .Where(l => l.Id == id)
                         .FirstOrDefault();
         }
     }
     catch (ArgumentNullException ex) {
         throw new CustomException(ex.Message);
     }
 }
 //
 // GET: /Admin/LogDetails(id = 0)
 public ActionResult LogDetails(int id = 0)
 {
     this.logger.Info("Entering: " + System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.FullName + ": " + System.Reflection.MethodBase.GetCurrentMethod().Name + " --> " + User.Identity.Name);
     try {
         using (var db = new ELearningDatabaseEntitiesServer()) {
             Logs log = this.adminManagement.GetLogById(id);
             LogsViewModel lvm = this.viewModelFactory.GetViewModel(log);
             return View(lvm);
         }
     }
     catch (CustomException ce) {
         this.logger.Trace(ce, "Username: "******"Operation could not be completed!";
         return View("Error");
     }
     catch (Exception ex) {
         this.logger.Trace(ex, "Username: "******"Operation could not be completed!";
         return View("Error");
     }
 }
Example #13
0
 //
 // GET: /Home/DeleteUsers(id = 0)
 public ActionResult DeleteUser(int id = 0)
 {
     this.logger.Info("Entering: " + System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.FullName + ": " + System.Reflection.MethodBase.GetCurrentMethod().Name + " --> " + User.Identity.Name);
     try {
         using (var db = new ELearningDatabaseEntitiesServer()) {
             Users user = this.userManagement.GetUserById(id);
             UserProfile userprofile = this.viewModelFactory.GetViewModel(user);
             return View(userprofile);
         }
     }
     catch (CustomException ce) {
         this.logger.Trace(ce, "Username: "******"Could not find user!";
         return View("Error");
     }
 }