public async Task <ActionResult> DeleteConfirmed(int id) { success_story story = await db.success_story.FindAsync(id); story.status = 0; db.Entry(story).State = EntityState.Modified; await db.SaveChangesAsync(); //db.success_story.Remove(story); List <success_story_category> categoryList = (from ca in db.success_story_category where ca.success_story_id == story.success_story_id && ca.status == 1 select ca).ToList(); foreach (success_story_category storyCategory in categoryList) { storyCategory.status = 0; db.Entry(storyCategory).State = EntityState.Modified; await db.SaveChangesAsync(); } List <success_story_courses> courseList = (from ca in db.success_story_courses where ca.success_story_id == story.success_story_id && ca.status == 1 select ca).ToList(); foreach (success_story_courses storyCourse in courseList) { storyCourse.status = 0; db.Entry(storyCourse).State = EntityState.Modified; await db.SaveChangesAsync(); } return(RedirectToAction("Index")); }
// GET: SuccessStory/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } success_story story = await db.success_story.FindAsync(id); if (story == null) { return(HttpNotFound()); } else if (story.status == 0) { return(HttpNotFound()); } StoryIndexViewModel editView = new StoryIndexViewModel(); editView.successStory = story; editView.allCategoryList = (from ca in db.category from ssc in db.success_story_category .Where(ssc => ssc.category_id == ca.category_id && ssc.success_story_id == story.success_story_id && ssc.status == 1) select new CategoryCheckBoxModel { category_id = ca.category_id, category_name = ca.category_name, story_category_id = (ssc == null ? 0 : ssc.story_category_id), isSelected = (ssc == null ? false : true) }).ToList(); editView.allCourseList = (from co in db.courses from ssc in db.success_story_courses .Where(ssc => ssc.course_id == co.course_id && ssc.success_story_id == story.success_story_id && ssc.status == 1) select new CourseCheckboxModel { course_id = co.course_id, course_code = co.course_code, course_name = co.course_name, story_course_id = (ssc == null ? 0 : ssc.story_course_id), isSelected = (ssc == null ? false : true) }).ToList(); return(View(editView)); }
public async Task <ActionResult> Edit(StoryIndexViewModel editView) { if (ModelState.IsValid) { success_story story = editView.successStory; var validImageTypes = new string[] { "image/gif", "image/jpeg", "image/jpg", "image/png" }; if (editView.picFile != null && editView.picFile.ContentLength > 0) { if (!validImageTypes.Contains(editView.picFile.ContentType)) { ModelState.AddModelError("ImageUpload", "Please choose either a GIF, JPG or PNG image."); } var uploadDir = "~/images/successstory"; var newFileName = String.Format("{0}_{1}_{2}", "Story", DateTime.Now.ToString("yyyyMMddHHmmssfff"), Path.GetFileName(editView.picFile.FileName)); var imagePath = Path.Combine(Server.MapPath(uploadDir), newFileName); editView.picFile.SaveAs(imagePath); var imageUrl = Path.Combine(uploadDir, Path.GetFileName(imagePath)); story.pic = "~/images/successstory/" + newFileName; } db.Entry(story).State = EntityState.Modified; await db.SaveChangesAsync(); foreach (CategoryCheckBoxModel cat in editView.allCategoryList) { if (cat.story_category_id == 0 && cat.isSelected == true) { success_story_category newSsc = new success_story_category(); newSsc.success_story_id = story.success_story_id; newSsc.category_id = cat.category_id; newSsc.status = 1; db.success_story_category.Add(newSsc); await db.SaveChangesAsync(); } if (cat.story_category_id != 0 && cat.isSelected == false) { success_story_category updateSsc = new success_story_category(); updateSsc.story_category_id = cat.story_category_id; updateSsc.success_story_id = story.success_story_id; updateSsc.category_id = cat.category_id; updateSsc.status = 0; db.Entry(updateSsc).State = EntityState.Modified; await db.SaveChangesAsync(); } } foreach (CourseCheckboxModel cor in editView.allCourseList) { if (cor.story_course_id == 0 && cor.isSelected == true) { success_story_courses newSsc = new success_story_courses(); newSsc.success_story_id = story.success_story_id; newSsc.course_id = cor.course_id; newSsc.status = 1; db.success_story_courses.Add(newSsc); await db.SaveChangesAsync(); } if (cor.story_course_id != 0 && cor.isSelected == false) { success_story_courses updateSsc = new success_story_courses(); updateSsc.story_course_id = cor.story_course_id; updateSsc.success_story_id = story.success_story_id; updateSsc.course_id = cor.course_id; updateSsc.status = 0; db.Entry(updateSsc).State = EntityState.Modified; await db.SaveChangesAsync(); } } return(RedirectToAction("Index")); } return(View(editView)); }