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));
}
