// 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);
}
// GET: SuccessStory
public async Task<ActionResult> Index(string sortOrder)
{
List<success_story> storyList = (from ss in db.success_story where ss.status == 1 select ss).ToList();
List<success_story> outList;
ViewBag.IDSortParm = sortOrder;
ViewBag.OrderSortParm = sortOrder;
if ("ID_asc".Equals(sortOrder))
{
//outList = db.success_story.OrderBy(e => e.success_story_id).ToList();
outList = storyList.OrderBy(e => e.success_story_id).ToList();
}
else if ("ID_desc".Equals(sortOrder))
{
outList = storyList.OrderByDescending(e => e.success_story_id).ToList();
}
else if ("Order_desc".Equals(sortOrder))
{
outList = storyList.OrderByDescending(e => e.sort_number).ToList();
}
else if ("Order_asc".Equals(sortOrder))
{
outList = storyList.OrderBy(e => e.sort_number).ToList();
}
else
{
ViewBag.OrderSortParm = "Order_asc";
outList = storyList.OrderBy(e => e.sort_number).ToList();
}
List<StoryIndexViewModel> viewList = new List<StoryIndexViewModel>();
foreach (var rec in outList)
{
StoryIndexViewModel st = new StoryIndexViewModel();
st.successStory = rec;
st.categoryList = (from cat in db.success_story_category
join cam in db.category on cat.category_id equals cam.category_id
where cat.success_story_id == rec.success_story_id && cat.status == 1
select new StoryCategoryViewModel
{
story_category_id = cat.story_category_id,
success_story_id = cat.success_story_id,
category_id = cat.category_id,
category_name = cam.category_name,
status = cat.status
}).ToList();
st.coursesList = (from ssc in db.success_story_courses
join cos in db.courses on ssc.course_id equals cos.course_id
where ssc.success_story_id == rec.success_story_id && ssc.status == 1
select new StoryCourseViewModel
{
story_course_id = ssc.story_course_id,
success_story_id = ssc.success_story_id,
course_id = ssc.course_id,
course_code = cos.course_code,
course_name = cos.course_name,
status = ssc.status
}).ToList();
viewList.Add(st);
}
//return View(await db.success_story.ToListAsync());
return View(viewList.ToList());
}
// GET: SuccessStory/Create
public ActionResult Create()
{
StoryIndexViewModel editView = new StoryIndexViewModel();
editView.successStory = new success_story();
editView.successStory.pic = "~/Images/successstory/no_image.jpg";
editView.allCategoryList = (from ca in db.category
select new CategoryCheckBoxModel
{
category_id = ca.category_id,
category_name = ca.category_name,
isSelected = false
}).ToList();
editView.allCourseList = (from co in db.courses
select new CourseCheckboxModel
{
course_id = co.course_id,
course_code = co.course_code,
course_name = co.course_name,
isSelected = false
}).ToList();
return View(editView);
}
public async Task<ActionResult> Detail(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
StoryIndexViewModel stViewModel = new StoryIndexViewModel();
stViewModel.successStory = await db.success_story.FindAsync(id);
if (stViewModel.successStory == null)
{
return HttpNotFound();
}
stViewModel.categoryList = (from cat in db.success_story_category
join cam in db.category on cat.category_id equals cam.category_id
where cat.success_story_id == stViewModel.successStory.success_story_id && cat.status == 1
select new StoryCategoryViewModel
{
story_category_id = cat.story_category_id,
success_story_id = cat.success_story_id,
category_id = cat.category_id,
category_name = cam.category_name,
status = cat.status
}).ToList();
stViewModel.coursesList = (from ssc in db.success_story_courses
join cos in db.courses on ssc.course_id equals cos.course_id
where ssc.success_story_id == stViewModel.successStory.success_story_id && ssc.status == 1
select new StoryCourseViewModel
{
story_course_id = ssc.story_course_id,
success_story_id = ssc.success_story_id,
course_id = ssc.course_id,
course_code = cos.course_code,
course_name = cos.course_name,
status = ssc.status
}).ToList();
stViewModel.courses = (from ssc in db.success_story_courses
join cos in db.courses on ssc.course_id equals cos.course_id
where ssc.success_story_id == stViewModel.successStory.success_story_id && ssc.status == 1
select new CourseViewModel
{
course_id = cos.course_id,
course_code = cos.course_code,
course_name = cos.course_name,
subject_id = cos.subject_id,
topic_id = cos.topic_id,
description = cos.description,
price = cos.price,
status = cos.status
}).ToList();
return View(stViewModel);
}
public void SuccessStoryController_Edit_Test11()
{
// Initialization
SuccessStoryController ctl = new SuccessStoryController();
StoryIndexViewModel editView = new StoryIndexViewModel();
// To test if it is null
var result = ctl.Edit(editView);
Assert.IsNotNull(result);
}
