public ActionResult DeleteConfirmed(int id) { AspnetLesson aspnetLesson = db.AspnetLessons.Find(id); db.AspnetLessons.Remove(aspnetLesson); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult GetLessonVideo(int LessonID) { AspnetLesson Lesson = db.AspnetLessons.Where(x => x.Id == LessonID).FirstOrDefault(); string LessonVideoUrl = ""; if (Lesson != null) { LessonVideoUrl = Lesson.Video_Url; } return(Json(new { LessonId = Lesson.Id, LessonName = Lesson.Name, LessonVideo = Lesson.Video_Url, LessonDescription = Lesson.Description }, JsonRequestBehavior.AllowGet)); }
// GET: AspnetLessons/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspnetLesson aspnetLesson = db.AspnetLessons.Find(id); if (aspnetLesson == null) { return(HttpNotFound()); } return(View(aspnetLesson)); }
public ActionResult CheckLessonOrderBy(string TopicId, string OrderBy) { int TopId = Convert.ToInt32(TopicId); int OrderByValue = Convert.ToInt32(OrderBy); var TopicExist = ""; AspnetLesson Lesson = db.AspnetLessons.Where(x => x.TopicId == TopId && x.OrderBy == OrderByValue).FirstOrDefault(); if (Lesson == null) { TopicExist = "No"; } else { TopicExist = "Yes"; } return(Json(TopicExist, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(LessonViewModel LessonViewModel) { AspnetLesson Lesson = new AspnetLesson(); Lesson.Name = LessonViewModel.LessonName; Lesson.Video_Url = LessonViewModel.LessonVideoURL; Lesson.TopicId = LessonViewModel.TopicId; Lesson.DurationMinutes = LessonViewModel.LessonDuration; Lesson.StartTime = LessonViewModel.StartTime; Lesson.EndTime = LessonViewModel.EndTime; Lesson.AddLink = LessonViewModel.AddLink; Lesson.CreationDate = LessonViewModel.CreationDate; Lesson.Description = LessonViewModel.LessonDescription; Lesson.CreationDate = DateTime.Now; db.AspnetLessons.Add(Lesson); db.SaveChanges(); HttpPostedFileBase Assignment = Request.Files["Assignment"]; HttpPostedFileBase Attachment1 = Request.Files["Attachment1"]; HttpPostedFileBase Attachment2 = Request.Files["Attachment2"]; HttpPostedFileBase Attachment3 = Request.Files["Attachment3"]; if (Assignment.ContentLength > 0) { var fileName = Path.GetFileName(Assignment.FileName); Assignment.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName); AspnetStudentAssignment studentAssignment = new AspnetStudentAssignment(); studentAssignment.FileName = fileName; studentAssignment.Name = LessonViewModel.AssignmentName; string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate); if (DueDate == "1/1/0001 12:00:00 AM") { studentAssignment.DueDate = null; } else { studentAssignment.DueDate = LessonViewModel.AssignmentDueDate; } studentAssignment.Description = LessonViewModel.AssignmentDescription; studentAssignment.CreationDate = DateTime.Now; studentAssignment.LessonId = Lesson.Id; db.AspnetStudentAssignments.Add(studentAssignment); db.SaveChanges(); } if (Attachment1.ContentLength > 0) { var fileName = Path.GetFileName(Attachment1.FileName); Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName); AspnetStudentAttachment studentAttachment1 = new AspnetStudentAttachment(); studentAttachment1.Name = LessonViewModel.AttachmentName1; studentAttachment1.Path = fileName; studentAttachment1.CreationDate = DateTime.Now; studentAttachment1.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment1); db.SaveChanges(); } if (Attachment2.ContentLength > 0) { var fileName = Path.GetFileName(Attachment2.FileName); Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName); AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment(); studentAttachment2.Name = LessonViewModel.AttachmentName2; studentAttachment2.Path = fileName; studentAttachment2.CreationDate = DateTime.Now; studentAttachment2.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment2); db.SaveChanges(); } if (Attachment3.ContentLength > 0) { var fileName = Path.GetFileName(Attachment3.FileName); Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName); AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment(); studentAttachment3.Name = LessonViewModel.AttachmentName3; studentAttachment3.Path = fileName; studentAttachment3.CreationDate = DateTime.Now; studentAttachment3.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment3); db.SaveChanges(); } if (LessonViewModel.LinkUrl1 != null) { AspnetStudentLink link1 = new AspnetStudentLink(); link1.URL = LessonViewModel.LinkUrl1; link1.CreationDate = DateTime.Now; link1.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link1); db.SaveChanges(); } if (LessonViewModel.LinkUrl2 != null) { AspnetStudentLink link2 = new AspnetStudentLink(); link2.URL = LessonViewModel.LinkUrl2; link2.CreationDate = DateTime.Now; link2.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link2); db.SaveChanges(); } if (LessonViewModel.LinkUrl3 != null) { AspnetStudentLink link3 = new AspnetStudentLink(); link3.URL = LessonViewModel.LinkUrl3; link3.CreationDate = DateTime.Now; link3.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link3); db.SaveChanges(); } return(RedirectToAction("ViewTopicsAndLessons", "AspnetSubjectTopics")); }
public ActionResult Edit(LessonViewModel LessonViewModel) { AspnetLesson Lesson = db.AspnetLessons.Where(x => x.Id == LessonViewModel.Id).FirstOrDefault(); Lesson.Name = LessonViewModel.LessonName; Lesson.Video_Url = LessonViewModel.LessonVideoURL; Lesson.TopicId = LessonViewModel.TopicId; Lesson.DurationMinutes = LessonViewModel.LessonDuration; Lesson.Description = LessonViewModel.LessonDescription; db.SaveChanges(); HttpPostedFileBase Assignment = Request.Files["Assignment"]; HttpPostedFileBase Attachment1 = Request.Files["Attachment1"]; HttpPostedFileBase Attachment2 = Request.Files["Attachment2"]; HttpPostedFileBase Attachment3 = Request.Files["Attachment3"]; var fileName = ""; if (Assignment.ContentLength > 0) { fileName = Path.GetFileName(Assignment.FileName); Assignment.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName); } AspnetStudentAssignment studentAssignment = db.AspnetStudentAssignments.Where(x => x.LessonId == Lesson.Id).FirstOrDefault(); if (studentAssignment != null) { if (fileName != "") { studentAssignment.FileName = fileName; } studentAssignment.Name = LessonViewModel.AssignmentName; string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate); if (DueDate == "1/1/0001 12:00:00 AM") { studentAssignment.DueDate = null; } else { studentAssignment.DueDate = LessonViewModel.AssignmentDueDate; } studentAssignment.Description = LessonViewModel.AssignmentDescription; db.SaveChanges(); } else { if (Assignment.ContentLength > 0) { AspnetStudentAssignment studentAssignment1 = new AspnetStudentAssignment(); studentAssignment1.FileName = fileName; studentAssignment1.Name = LessonViewModel.AssignmentName; string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate); if (DueDate == "1/1/0001 12:00:00 AM") { studentAssignment1.DueDate = null; } else { studentAssignment1.DueDate = LessonViewModel.AssignmentDueDate; } studentAssignment1.Description = LessonViewModel.AssignmentDescription; studentAssignment1.CreationDate = DateTime.Now; studentAssignment1.LessonId = Lesson.Id; db.AspnetStudentAssignments.Add(studentAssignment1); db.SaveChanges(); } } List <AspnetStudentAttachment> studentAttachments = db.AspnetStudentAttachments.Where(x => x.LessonId == Lesson.Id).ToList(); List <AspnetStudentLink> studentLinks = db.AspnetStudentLinks.Where(x => x.LessonId == Lesson.Id).ToList(); //db.AspnetStudentAttachments.RemoveRange(studentAttachments); //db.SaveChanges(); db.AspnetStudentLinks.RemoveRange(studentLinks); db.SaveChanges(); SEA_DatabaseEntities db1 = new SEA_DatabaseEntities(); List <AspnetStudentAttachment> studentAttachments1 = db1.AspnetStudentAttachments.Where(x => x.LessonId == Lesson.Id).ToList(); int TotalAttachments = studentAttachments1.Count; if (TotalAttachments == 0) { if (Attachment1.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment1.FileName); Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); AspnetStudentAttachment studentAttachment1 = new AspnetStudentAttachment(); studentAttachment1.Name = LessonViewModel.AttachmentName1; studentAttachment1.Path = fileName1; studentAttachment1.CreationDate = DateTime.Now; studentAttachment1.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment1); db.SaveChanges(); } if (Attachment2.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment2.FileName); Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment(); studentAttachment2.Name = LessonViewModel.AttachmentName2; studentAttachment2.Path = fileName1; studentAttachment2.CreationDate = DateTime.Now; studentAttachment2.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment2); db.SaveChanges(); } if (Attachment3.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment3.FileName); Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment(); studentAttachment3.Name = LessonViewModel.AttachmentName3; studentAttachment3.Path = fileName1; studentAttachment3.CreationDate = DateTime.Now; studentAttachment3.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment3); db.SaveChanges(); } } else { if (TotalAttachments == 1) { var FirstElement = studentAttachments1.ElementAt(0); FirstElement.Name = LessonViewModel.AttachmentName1; var FileName = FirstElement.Path; if (Attachment1.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment1.FileName); FileName = fileName1; Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); } FirstElement.Path = FileName; db1.SaveChanges(); if (Attachment2.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment2.FileName); Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment(); studentAttachment2.Name = LessonViewModel.AttachmentName2; studentAttachment2.Path = fileName1; studentAttachment2.CreationDate = DateTime.Now; studentAttachment2.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment2); db.SaveChanges(); } if (Attachment3.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment3.FileName); Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment(); studentAttachment3.Name = LessonViewModel.AttachmentName3; studentAttachment3.Path = fileName1; studentAttachment3.CreationDate = DateTime.Now; studentAttachment3.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment3); db.SaveChanges(); } } else if (TotalAttachments == 2) { var FirstElement = studentAttachments1.ElementAt(0); FirstElement.Name = LessonViewModel.AttachmentName1; var FileName0 = FirstElement.Path; if (Attachment1.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment1.FileName); FileName0 = fileName1; Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); } FirstElement.Path = FileName0; db1.SaveChanges(); var SecondElement = studentAttachments1.ElementAt(1); SecondElement.Name = LessonViewModel.AttachmentName2; var FileName1 = SecondElement.Path; if (Attachment2.ContentLength > 0) { var fileName2 = Path.GetFileName(Attachment2.FileName); FileName1 = fileName2; Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName2); } SecondElement.Path = FileName1; db1.SaveChanges(); if (Attachment3.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment3.FileName); Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment(); studentAttachment3.Name = LessonViewModel.AttachmentName3; studentAttachment3.Path = fileName1; studentAttachment3.CreationDate = DateTime.Now; studentAttachment3.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment3); db.SaveChanges(); } } else { var FirstElement = studentAttachments1.ElementAt(0); FirstElement.Name = LessonViewModel.AttachmentName1; var FileName0 = FirstElement.Path; if (Attachment1.ContentLength > 0) { var fileName1 = Path.GetFileName(Attachment1.FileName); FileName0 = fileName1; Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName1); } FirstElement.Path = FileName0; db1.SaveChanges(); var SecondElement = studentAttachments1.ElementAt(1); SecondElement.Name = LessonViewModel.AttachmentName2; var FileName1 = SecondElement.Path; if (Attachment2.ContentLength > 0) { var fileName2 = Path.GetFileName(Attachment2.FileName); FileName1 = fileName2; Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName2); } SecondElement.Path = FileName1; db1.SaveChanges(); var ThirdElement = studentAttachments1.ElementAt(2); ThirdElement.Name = LessonViewModel.AttachmentName3; var FileName2 = ThirdElement.Path; if (Attachment3.ContentLength > 0) { var fileName3 = Path.GetFileName(Attachment3.FileName); FileName2 = fileName3; Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName3); } ThirdElement.Path = FileName2; db1.SaveChanges(); } } if (LessonViewModel.LinkUrl1 != null) { AspnetStudentLink link1 = new AspnetStudentLink(); link1.URL = LessonViewModel.LinkUrl1; link1.CreationDate = DateTime.Now; link1.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link1); db.SaveChanges(); } if (LessonViewModel.LinkUrl2 != null) { AspnetStudentLink link2 = new AspnetStudentLink(); link2.URL = LessonViewModel.LinkUrl2; link2.CreationDate = DateTime.Now; link2.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link2); db.SaveChanges(); } if (LessonViewModel.LinkUrl3 != null) { AspnetStudentLink link3 = new AspnetStudentLink(); link3.URL = LessonViewModel.LinkUrl3; link3.CreationDate = DateTime.Now; link3.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link3); db.SaveChanges(); } return(RedirectToAction("ViewTopicsAndLessons", "AspnetSubjectTopics")); }
// GET: AspnetLessons/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspnetLesson aspnetLesson = db.AspnetLessons.Find(id); if (aspnetLesson == null) { return(HttpNotFound()); } AspnetStudentAssignment studentAssignment = db.AspnetStudentAssignments.Where(x => x.LessonId == aspnetLesson.Id).FirstOrDefault(); List <AspnetStudentAttachment> studentAttachments = db.AspnetStudentAttachments.Where(x => x.LessonId == aspnetLesson.Id).ToList(); List <AspnetStudentLink> studentLinks = db.AspnetStudentLinks.Where(x => x.LessonId == aspnetLesson.Id).ToList(); LessonViewModel lessonViewModel = new LessonViewModel(); lessonViewModel.LessonDescription = aspnetLesson.Description; lessonViewModel.LessonVideoURL = aspnetLesson.Video_Url; lessonViewModel.LessonName = aspnetLesson.Name; lessonViewModel.LessonDuration = aspnetLesson.DurationMinutes; lessonViewModel.StartTime = aspnetLesson.StartTime; lessonViewModel.EndTime = aspnetLesson.EndTime; lessonViewModel.AddLink = aspnetLesson.AddLink; int?TopicId = aspnetLesson.TopicId; ViewBag.LessonDuration = aspnetLesson.DurationMinutes; int? SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId; GenericSubject Subject = db.GenericSubjects.Where(x => x.Id == SubjectId).FirstOrDefault(); var CourseType = Subject.SubjectType; lessonViewModel.Id = aspnetLesson.Id; if (studentAssignment != null) { lessonViewModel.AssignmentName = studentAssignment.Name; lessonViewModel.AssignmentDescription = studentAssignment.Description; DateTime Date = Convert.ToDateTime(studentAssignment.DueDate); string date = Date.ToString("yyyy-MM-dd"); ViewBag.AssignmentFileName = studentAssignment.FileName; lessonViewModel.AssignmentDueDate = studentAssignment.DueDate; ViewBag.Date = date; } int count = 1; foreach (var link in studentLinks) { if (count == 1) { lessonViewModel.LinkUrl1 = link.URL; } else if (count == 2) { lessonViewModel.LinkUrl2 = link.URL; } else if (count == 3) { lessonViewModel.LinkUrl3 = link.URL; } else { } count++; } count = 1; foreach (var attachment in studentAttachments) { if (count == 1) { lessonViewModel.AttachmentName1 = attachment.Name; ViewBag.Attachment1FileName = attachment.Path; } else if (count == 2) { lessonViewModel.AttachmentName2 = attachment.Name; ViewBag.Attachment2FileName = attachment.Path; } else if (count == 3) { lessonViewModel.AttachmentName3 = attachment.Name; ViewBag.Attachment3FileName = attachment.Path; } else { } count++; } // ViewBag.SecId = new SelectList(db.AspNetClasses, "Id", "ClassName", ClassId); // ViewBag.SubId = new SelectList(db.GenericSubjects.Where(x => x.SubjectType == Subject.SubjectType), "Id", "SubjectName", SubjectId); var UserId = User.Identity.GetUserId(); var SubjectofCurrentSessionTeacher = from subject in db.GenericSubjects join TeacherSubject in db.Teacher_GenericSubjects on subject.Id equals TeacherSubject.SubjectId join employee in db.AspNetEmployees on TeacherSubject.TeacherId equals employee.Id where employee.UserId == UserId && subject.SubjectType == Subject.SubjectType select new { subject.Id, subject.SubjectName, }; ViewBag.SubId = new SelectList(SubjectofCurrentSessionTeacher, "Id", "SubjectName", SubjectId); ViewBag.TopicId = new SelectList(db.AspnetSubjectTopics.Where(x => x.SubjectId == SubjectId), "Id", "Name", aspnetLesson.TopicId); ViewBag.CTId = Subject.SubjectType; return(View(lessonViewModel)); }
public ActionResult DeleteLessons(int?id) { int?LessonId = id; AspnetLesson LessonToDelete = db.AspnetLessons.Where(x => x.Id == LessonId).FirstOrDefault(); if (LessonToDelete != null) { IEnumerable <AspnetComment> CommentsToDelete = db.AspnetComment_Head.Where(x => x.LessonId == LessonId).SelectMany(x => x.AspnetComments); db.AspnetComments.RemoveRange(CommentsToDelete); db.SaveChanges(); List <AspnetComment_Head> ListCommentHeadToDelete = db.AspnetComment_Head.Where(x => x.LessonId == LessonId).ToList(); db.AspnetComment_Head.RemoveRange(ListCommentHeadToDelete); db.SaveChanges(); var AssignmentToDelete = db.AspnetStudentAssignments.Where(x => x.LessonId == LessonId).FirstOrDefault(); if (AssignmentToDelete != null) { db.AspnetStudentAssignments.Remove(AssignmentToDelete); db.SaveChanges(); } List <AspnetStudentAttachment> StudentAttachmentListToDelete = db.AspnetStudentAttachments.Where(x => x.LessonId == LessonId).ToList(); db.AspnetStudentAttachments.RemoveRange(StudentAttachmentListToDelete); db.SaveChanges(); List <AspnetStudentLink> StudentLinkListToDelete = db.AspnetStudentLinks.Where(x => x.LessonId == LessonId).ToList(); db.AspnetStudentLinks.RemoveRange(StudentLinkListToDelete); db.SaveChanges(); List <AspnetStudentAssignmentSubmission> StudentAssignmentSubmissionListToDelete = db.AspnetStudentAssignmentSubmissions.Where(x => x.LessonId == LessonId).ToList(); db.AspnetStudentAssignmentSubmissions.RemoveRange(StudentAssignmentSubmissionListToDelete); db.SaveChanges(); List <StudentLessonTracking> StudentLessonTrackingListToDelete = db.StudentLessonTrackings.Where(x => x.LessonId == LessonId).ToList(); db.StudentLessonTrackings.RemoveRange(StudentLessonTrackingListToDelete); db.SaveChanges(); List <Student_Quiz_Scoring> StudentQuizScoringToDelete = db.AspnetQuestions.Where(x => x.LessonId == LessonId).SelectMany(x => x.Student_Quiz_Scoring).ToList(); db.Student_Quiz_Scoring.RemoveRange(StudentQuizScoringToDelete); db.SaveChanges(); List <Lesson_Session> LessonSessionToDelete = db.Lesson_Session.Where(x => x.LessonId == LessonId).ToList(); db.Lesson_Session.RemoveRange(LessonSessionToDelete); db.SaveChanges(); List <Quiz_Topic_Questions> QuizTopicQuestionnsToDelete = db.AspnetQuestions.Where(x => x.LessonId == LessonId).SelectMany(x => x.Quiz_Topic_Questions).ToList(); db.Quiz_Topic_Questions.RemoveRange(QuizTopicQuestionnsToDelete); db.SaveChanges(); List <AspnetQuestion> QuestionListToDelete = db.AspnetQuestions.Where(x => x.LessonId == LessonId).ToList(); db.AspnetQuestions.RemoveRange(QuestionListToDelete); db.SaveChanges(); db.AspnetLessons.Remove(LessonToDelete); db.SaveChanges(); } return(RedirectToAction("ViewTopicsAndLessons", "AspnetSubjectTopics")); }
// GET: AspnetLessons/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspnetLesson aspnetLesson = db.AspnetLessons.Find(id); if (aspnetLesson == null) { return(HttpNotFound()); } AspnetStudentAssignment studentAssignment = db.AspnetStudentAssignments.Where(x => x.LessonId == aspnetLesson.Id).FirstOrDefault(); List <AspnetStudentAttachment> studentAttachments = db.AspnetStudentAttachments.Where(x => x.LessonId == aspnetLesson.Id).ToList(); List <AspnetStudentLink> studentLinks = db.AspnetStudentLinks.Where(x => x.LessonId == aspnetLesson.Id).ToList(); LessonViewModel lessonViewModel = new LessonViewModel(); lessonViewModel.LessonDescription = aspnetLesson.Description; lessonViewModel.LessonVideoURL = aspnetLesson.Video_Url; lessonViewModel.LessonName = aspnetLesson.Name; lessonViewModel.LessonDuration = aspnetLesson.DurationMinutes; // Lesson_Session LessonSession = db.Lesson_Session.Where(x => x.LessonId == id).FirstOrDefault(); lessonViewModel.IsActive = Convert.ToBoolean(aspnetLesson.IsActive); //var StartDate = Convert.ToDateTime(LessonSession.StartDate); //var StartDateInString = StartDate.ToString("yyyy-MM-dd"); //ViewBag.LessonStartDate = StartDateInString; ////Due Date //var DueDate = Convert.ToDateTime(LessonSession.DueDate); //var DueDateInString = DueDate.ToString("yyyy-MM-dd"); //ViewBag.LessonDueDate = DueDateInString; int?TopicId = aspnetLesson.TopicId; ViewBag.LessonDuration = aspnetLesson.DurationMinutes; int? SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId; GenericSubject Subject = db.GenericSubjects.Where(x => x.Id == SubjectId).FirstOrDefault(); var CourseType = Subject.SubjectType; lessonViewModel.Id = aspnetLesson.Id; if (studentAssignment != null) { lessonViewModel.AssignmentName = studentAssignment.Name; lessonViewModel.AssignmentDescription = studentAssignment.Description; DateTime Date = Convert.ToDateTime(studentAssignment.DueDate); string date = Date.ToString("yyyy-MM-dd"); ViewBag.AssignmentFileName = studentAssignment.FileName; lessonViewModel.AssignmentDueDate = studentAssignment.DueDate; ViewBag.Date = date; } int count = 1; foreach (var link in studentLinks) { if (count == 1) { lessonViewModel.LinkUrl1 = link.URL; } else if (count == 2) { lessonViewModel.LinkUrl2 = link.URL; } else if (count == 3) { lessonViewModel.LinkUrl3 = link.URL; } else { } count++; } count = 1; foreach (var attachment in studentAttachments) { if (count == 1) { lessonViewModel.AttachmentName1 = attachment.Name; ViewBag.Attachment1FileName = attachment.Path; } else if (count == 2) { lessonViewModel.AttachmentName2 = attachment.Name; ViewBag.Attachment2FileName = attachment.Path; } else if (count == 3) { lessonViewModel.AttachmentName3 = attachment.Name; ViewBag.Attachment3FileName = attachment.Path; } else { } count++; } // ViewBag.SecId = new SelectList(db.AspNetClasses, "Id", "ClassName", ClassId); // ViewBag.SubId = new SelectList(db.GenericSubjects.Where(x => x.SubjectType == Subject.SubjectType), "Id", "SubjectName", SubjectId); ViewBag.SubId = new SelectList(db.GenericSubjects.Where(x => x.SubjectType == Subject.SubjectType), "Id", "SubjectName", SubjectId); ViewBag.TopicId = new SelectList(db.AspnetSubjectTopics.Where(x => x.SubjectId == SubjectId), "Id", "Name", aspnetLesson.TopicId); // ViewBag.SessionId = new SelectList(db.AspNetSessions, "Id", "SessionName", LessonSession.SessionId); ViewBag.CTId = Subject.SubjectType; ViewBag.OrderBy = aspnetLesson.OrderBy; return(View(lessonViewModel)); }
public ActionResult Create(LessonViewModel LessonViewModel) { AspnetLesson Lesson = new AspnetLesson(); Lesson.Name = LessonViewModel.LessonName; Lesson.Video_Url = LessonViewModel.LessonVideoURL; Lesson.TopicId = LessonViewModel.TopicId; Lesson.DurationMinutes = LessonViewModel.LessonDuration; Lesson.IsActive = LessonViewModel.IsActive; Lesson.CreationDate = LessonViewModel.CreationDate; Lesson.Description = LessonViewModel.LessonDescription; Lesson.OrderBy = LessonViewModel.OrderBy; Lesson.CreationDate = DateTime.Now; string EncrID = Lesson.Name + Lesson.Description + Lesson.Id; Lesson.EncryptedID = Encrpt.Encrypt(EncrID, true); var newString = Regex.Replace(Lesson.EncryptedID, @"[^0-9a-zA-Z]+", "s"); // Lesson.EncryptedID.Replace('/', 's').Replace('-','s').Replace('+','s').Replace('%','s').Replace('&','s'); Lesson.EncryptedID = newString; db.AspnetLessons.Add(Lesson); db.SaveChanges(); //Lesson_Session lessonSession = new Lesson_Session(); //lessonSession.LessonId = Lesson.Id; //lessonSession.SessionId = LessonViewModel.SessionId; //lessonSession.StartDate = LessonViewModel.StartDate; //lessonSession.DueDate = LessonViewModel.DueDate; //db.Lesson_Session.Add(lessonSession); //db.SaveChanges(); HttpPostedFileBase Assignment = Request.Files["Assignment"]; HttpPostedFileBase Attachment1 = Request.Files["Attachment1"]; HttpPostedFileBase Attachment2 = Request.Files["Attachment2"]; HttpPostedFileBase Attachment3 = Request.Files["Attachment3"]; if (Assignment.ContentLength > 0) { var fileName = Path.GetFileName(Assignment.FileName); Assignment.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName); AspnetStudentAssignment studentAssignment = new AspnetStudentAssignment(); studentAssignment.FileName = fileName; studentAssignment.Name = LessonViewModel.AssignmentName; string DueDate = Convert.ToString(LessonViewModel.AssignmentDueDate); if (DueDate == "1/1/0001 12:00:00 AM") { studentAssignment.DueDate = null; } else { studentAssignment.DueDate = LessonViewModel.AssignmentDueDate; } studentAssignment.Description = LessonViewModel.AssignmentDescription; studentAssignment.CreationDate = DateTime.Now; studentAssignment.LessonId = Lesson.Id; db.AspnetStudentAssignments.Add(studentAssignment); db.SaveChanges(); } if (Attachment1.ContentLength > 0) { var fileName = Path.GetFileName(Attachment1.FileName); Attachment1.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName); AspnetStudentAttachment studentAttachment1 = new AspnetStudentAttachment(); studentAttachment1.Name = LessonViewModel.AttachmentName1; studentAttachment1.Path = fileName; studentAttachment1.CreationDate = DateTime.Now; studentAttachment1.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment1); db.SaveChanges(); } if (Attachment2.ContentLength > 0) { var fileName = Path.GetFileName(Attachment2.FileName); Attachment2.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName); AspnetStudentAttachment studentAttachment2 = new AspnetStudentAttachment(); studentAttachment2.Name = LessonViewModel.AttachmentName2; studentAttachment2.Path = fileName; studentAttachment2.CreationDate = DateTime.Now; studentAttachment2.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment2); db.SaveChanges(); } if (Attachment3.ContentLength > 0) { var fileName = Path.GetFileName(Attachment3.FileName); Attachment3.SaveAs(Server.MapPath("~/Content/StudentAttachments/") + fileName); AspnetStudentAttachment studentAttachment3 = new AspnetStudentAttachment(); studentAttachment3.Name = LessonViewModel.AttachmentName3; studentAttachment3.Path = fileName; studentAttachment3.CreationDate = DateTime.Now; studentAttachment3.LessonId = Lesson.Id; db.AspnetStudentAttachments.Add(studentAttachment3); db.SaveChanges(); } if (LessonViewModel.LinkUrl1 != null) { AspnetStudentLink link1 = new AspnetStudentLink(); link1.URL = LessonViewModel.LinkUrl1; link1.CreationDate = DateTime.Now; link1.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link1); db.SaveChanges(); } if (LessonViewModel.LinkUrl2 != null) { AspnetStudentLink link2 = new AspnetStudentLink(); link2.URL = LessonViewModel.LinkUrl2; link2.CreationDate = DateTime.Now; link2.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link2); db.SaveChanges(); } if (LessonViewModel.LinkUrl3 != null) { AspnetStudentLink link3 = new AspnetStudentLink(); link3.URL = LessonViewModel.LinkUrl3; link3.CreationDate = DateTime.Now; link3.LessonId = Lesson.Id; db.AspnetStudentLinks.Add(link3); db.SaveChanges(); } return(RedirectToAction("ViewTopicsAndLessons", "AspnetSubjectTopics")); }