public ActionResult Create(int id) { if (id != 0) { AspnetSubjectTopic aspnetSubjectTopic = db.AspnetSubjectTopics.Find(id); int? SubjectId = aspnetSubjectTopic.SubjectId; GenericSubject Subject = db.GenericSubjects.Where(x => x.Id == SubjectId).FirstOrDefault(); ViewBag.TopicExist = 1; ViewBag.TopicId = id; ViewBag.SubjectId = aspnetSubjectTopic.SubjectId; ViewBag.CTId = Subject.SubjectType; return(View()); } else { ViewBag.TopicId = null; ViewBag.SubjectId = null; ViewBag.CTId = null; ViewBag.TopicExist = 0; // ViewBag.TopicId = new SelectList(db.AspnetSubjectTopics, "Id", "Name"); // ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName"); return(View()); } }
//public JsonResult StudentByClass(int id) //{ // var result1 = db.AspNetSubjects.Where(x => x.ClassID == id).ToList(); // var obj = JsonConvert.SerializeObject(result1); // return Json(obj, JsonRequestBehavior.AllowGet); //} // GET: AspnetSubjectTopics/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspnetSubjectTopic aspnetSubjectTopic = db.AspnetSubjectTopics.Find(id); if (aspnetSubjectTopic == null) { return(HttpNotFound()); } //Teacher Subjects int?SubjectId = aspnetSubjectTopic.SubjectId; GenericSubject Subject = db.GenericSubjects.Where(x => x.Id == SubjectId).FirstOrDefault(); // ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", Subject.ClassID); // ViewBag.SubjectId = new SelectList(db.GenericSubjects.Where(x=>x.SubjectType == Subject.SubjectType), "Id", "SubjectName", aspnetSubjectTopic.SubjectId); ViewBag.SubjectId = new SelectList(db.GenericSubjects.Where(x => x.SubjectType == Subject.SubjectType), "Id", "SubjectName", aspnetSubjectTopic.SubjectId); ViewBag.CTId = Subject.SubjectType; ViewBag.OrderBy = aspnetSubjectTopic.OrderBy; return(View(aspnetSubjectTopic)); }
// GET: AspnetQuizs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspnetQuiz aspnetQuiz = db.AspnetQuizs.Find(id); if (aspnetQuiz == null) { return(HttpNotFound()); } DateTime Date = Convert.ToDateTime(aspnetQuiz.Start_Date); string StartDate = Date.ToString("yyyy-MM-dd"); ViewBag.StartDate = StartDate; DateTime Date1 = Convert.ToDateTime(aspnetQuiz.Due_Date); string DueDate = Date1.ToString("yyyy-MM-dd"); ViewBag.DueDate = DueDate; var AllTopicIDs = db.Quiz_Topic_Questions.Where(x => x.QuizId == id).Select(x => x.TopicId).ToList(); var AllTopic = from topic in db.AspnetSubjectTopics where AllTopicIDs.Contains(topic.Id) select topic; ViewBag.TopicId = new SelectList(AllTopic, "Id", "Name"); //All Questions To Display var AllQuestionIDS = db.Quiz_Topic_Questions.Where(x => x.QuizId == id).Select(x => x.QuestionId).ToList(); var AllQuestion = from Question in db.AspnetQuestions where AllQuestionIDS.Contains(Question.Id) select Question; ViewBag.QuestionID = new SelectList(AllQuestion, "Id", "Name"); int? TopicId = db.Quiz_Topic_Questions.Where(x => x.QuizId == id).FirstOrDefault().TopicId; int? SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId; GenericSubject SubjectObj = db.GenericSubjects.Where(x => x.Id == SubjectId).FirstOrDefault(); string CourseType = SubjectObj.SubjectType; ViewBag.SubjectId = new SelectList(db.GenericSubjects.Where(x => x.SubjectType == CourseType), "Id", "SubjectName", SubjectId); // var UserId = User.Identity.GetUserId(); ViewBag.CTId = CourseType; return(View(aspnetQuiz)); }
public void GenericEnumeration() { var expected = new GenericSubject <TypeCode> { PropertyName = TypeCode.SByte }; _serializer.Cycle(expected) .Should().BeEquivalentTo(expected); }
//public JsonResult StudentByClass(int id) //{ // var result1 = db.AspNetSubjects.Where(x => x.ClassID == id).ToList(); // var obj = JsonConvert.SerializeObject(result1); // return Json(obj, JsonRequestBehavior.AllowGet); //} // GET: AspnetSubjectTopics/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspnetSubjectTopic aspnetSubjectTopic = db.AspnetSubjectTopics.Find(id); if (aspnetSubjectTopic == null) { return(HttpNotFound()); } //Teacher Subjects int?SubjectId = aspnetSubjectTopic.SubjectId; GenericSubject Subject = db.GenericSubjects.Where(x => x.Id == SubjectId).FirstOrDefault(); 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.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", Subject.ClassID); // ViewBag.SubjectId = new SelectList(db.GenericSubjects.Where(x=>x.SubjectType == Subject.SubjectType), "Id", "SubjectName", aspnetSubjectTopic.SubjectId); ViewBag.SubjectId = new SelectList(SubjectofCurrentSessionTeacher, "Id", "SubjectName", aspnetSubjectTopic.SubjectId); ViewBag.CTId = Subject.SubjectType; return(View(aspnetSubjectTopic)); }
// 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)); }
// 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)); }