public ActionResult Edit([Bind(Include = "Id,TopicNo,TopicName,StartDate,EndDate,ChapterID,Status")] AspNetTopic aspNetTopic) { if (ModelState.IsValid) { db.Entry(aspNetTopic).State = EntityState.Modified; db.SaveChanges(); var status = db.AspNetTopics.Where(x => x.ChapterID == aspNetTopic.ChapterID).Select(x => x.Status).ToList(); bool completed = true; foreach (var item in status) { if (item == false) { completed = false; break; } } AspNetChapter aspNetChapter = db.AspNetChapters.Where(x => x.Id == aspNetTopic.ChapterID).FirstOrDefault(); if (completed) { aspNetChapter.Status = true; db.SaveChanges(); } else { aspNetChapter.Status = false; db.SaveChanges(); } return(RedirectToAction("Dashboard", "Account")); } ViewBag.ChapterID = new SelectList(db.AspNetChapters, "Id", "ChapterName", aspNetTopic.ChapterID); return(View(aspNetTopic)); }
public ActionResult DeleteConfirmed(int id) { AspNetChapter aspNetChapter = db.AspNetChapters.Find(id); db.AspNetChapters.Remove(aspNetChapter); db.SaveChanges(); return(RedirectToAction("Dashboard", "Account")); }
public JsonResult ChapterByLessonPlan(int id) { db.Configuration.ProxyCreationEnabled = false; var LessonTopicObj = db.AspNetLessonPlan_Topic.FirstOrDefault(s => s.LessonPlanID == id); var topicObj = db.AspNetTopics.FirstOrDefault(s => s.Id == LessonTopicObj.TopicID); AspNetChapter chapterobj = db.AspNetChapters.FirstOrDefault(x => x.Id == topicObj.ChapterID); int? chapter = chapterobj.Id; return(Json(chapter, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "Id,ChapterNo,ChapterName,StartDate,EndDate,SubjectID,Status")] AspNetChapter aspNetChapter) { if (ModelState.IsValid) { db.Entry(aspNetChapter).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Dashboard", "Account")); } ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetChapter.SubjectID); return(View(aspNetChapter)); }
// GET: AspNetChapter/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetChapter aspNetChapter = db.AspNetChapters.Find(id); if (aspNetChapter == null) { return(HttpNotFound()); } return(View(aspNetChapter)); }
// GET: AspNetChapter/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetChapter aspNetChapter = db.AspNetChapters.Find(id); if (aspNetChapter == null) { return(HttpNotFound()); } ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetChapter.SubjectID); return(View(aspNetChapter)); }
public ActionResult Create([Bind(Include = "Id,ChapterNo,ChapterName,StartDate,EndDate,SubjectID,Status")] AspNetChapter aspNetChapter) { if (ModelState.IsValid) { db.AspNetChapters.Add(aspNetChapter); db.SaveChanges(); ViewBag.ClassID = new SelectList(db.AspNetSubjects.Where(x => x.TeacherID == TeacherID).Select(x => x.AspNetClass).Distinct(), "Id", "ClassName"); ViewBag.CreateChapter = "Chapter created and updated successfully"; return(View("../Teacher_Dashboard/_Topics")); } ViewBag.SubjectID = new SelectList(db.AspNetSubjects.Where(x => x.AspNetClass.SessionID == SessionID), "Id", "SubjectName", aspNetChapter.SubjectID); return(View(aspNetChapter)); }
public ActionResult CurriculumFromFile() { HttpPostedFileBase file = Request.Files["curriculum"]; int SubjectID = Convert.ToInt32(Request.Form["SubjectID"]); if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName)) { string fileName = file.FileName; string fileContentType = file.ContentType; byte[] fileBytes = new byte[file.ContentLength]; var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength)); } using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 1; rowIterator <= noOfRow; rowIterator++) { var heading = workSheet.Cells[rowIterator, 1].Value.ToString(); if (heading == "Chapter") { rowIterator++; AspNetChapter aspNetChapter = new AspNetChapter(); aspNetChapter.SubjectID = SubjectID; aspNetChapter.ChapterNo = Convert.ToInt32(workSheet.Cells[rowIterator, 1].Value.ToString()); aspNetChapter.ChapterName = workSheet.Cells[rowIterator, 2].Value.ToString(); aspNetChapter.StartDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 3].Value.ToString()); aspNetChapter.EndDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 4].Value.ToString()); aspNetChapter.Status = Convert.ToBoolean(Convert.ToInt32(workSheet.Cells[rowIterator, 5].Value.ToString())); db.AspNetChapters.Add(aspNetChapter); db.SaveChanges(); } else if (heading == "Topic") { int ChapterID = db.AspNetChapters.Max(item => item.Id); rowIterator++; AspNetTopic aspNetTopic = new AspNetTopic(); aspNetTopic.ChapterID = ChapterID; aspNetTopic.TopicNo = Convert.ToDouble(workSheet.Cells[rowIterator, 1].Value.ToString()); aspNetTopic.TopicName = workSheet.Cells[rowIterator, 2].Value.ToString(); aspNetTopic.StartDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 3].Value.ToString()); aspNetTopic.EndDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 4].Value.ToString()); aspNetTopic.Status = Convert.ToBoolean(Convert.ToInt32(workSheet.Cells[rowIterator, 5].Value.ToString())); db.AspNetTopics.Add(aspNetTopic); db.SaveChanges(); } else { int ChapterID = db.AspNetChapters.Max(item => item.Id); AspNetTopic aspNetTopic = new AspNetTopic(); aspNetTopic.ChapterID = ChapterID; aspNetTopic.TopicNo = Convert.ToDouble(workSheet.Cells[rowIterator, 1].Value.ToString()); aspNetTopic.TopicName = workSheet.Cells[rowIterator, 2].Value.ToString(); aspNetTopic.StartDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 3].Value.ToString()); aspNetTopic.EndDate = Convert.ToDateTime(workSheet.Cells[rowIterator, 4].Value.ToString()); aspNetTopic.Status = Convert.ToBoolean(Convert.ToInt32(workSheet.Cells[rowIterator, 5].Value.ToString())); db.AspNetTopics.Add(aspNetTopic); db.SaveChanges(); } } } return(RedirectToAction("Dashboard", "Teacher_Dashboard")); }