public string Put(SubSectionModel subSectionModel) { string success = ""; try { using (var db = new BookDbContext()) { var bookSubSection = db.SubSections.Where(s => s.Id == subSectionModel.Id).FirstOrDefault(); if (bookSubSection == null) { success = "not found"; } else { bookSubSection.SubSectionTitle = subSectionModel.SubSectionTitle; bookSubSection.SubSectionOrder = subSectionModel.SubSectionOrder; bookSubSection.SubSectionContents = subSectionModel.SubSectionContents; db.SaveChanges(); success = "ok"; } } } catch (Exception ex) { success = Helpers.ErrorDetails(ex); } return(success); }
public SubSectionModel Patch(int subSectionId) { var subSectionModel = new SubSectionModel(); using (var db = new BookDbContext()) { var dbSubSection = db.SubSections.Where(s => s.Id == subSectionId).FirstOrDefault(); if (dbSubSection != null) { subSectionModel.Id = dbSubSection.Id; subSectionModel.SubSectionTitle = dbSubSection.SubSectionTitle; subSectionModel.SubSectionOrder = dbSubSection.SubSectionOrder; subSectionModel.SubSectionContents = dbSubSection.SubSectionContents; //subSection.v subSectionModel.SectionTitle = dbSubSection.BookSection.SectionTitle; subSectionModel.SectionOrder = dbSubSection.BookSection.SectionOrder; subSectionModel.ChapterTitle = dbSubSection.BookSection.Chapter.ChapterTitle; subSectionModel.ChapterOrder = dbSubSection.BookSection.Chapter.ChapterOrder; subSectionModel.SectionId = dbSubSection.SectionId.Value; subSectionModel.success = "ok"; } } return(subSectionModel); }
public ActionResult Index() { AdminModel model = new AdminModel(); model.brands = new List <BrandModel>(); foreach (var brand in setzDB.Brands) { BrandModel brandModel = new BrandModel(); brandModel.brand = brand; model.brands.Add(brandModel); } model.sectionModels = new List <SectionModel>(); foreach (var section in setzDB.Sections.OrderBy(s => s.Order)) { SectionModel sectionModel = new SectionModel(); sectionModel.section = section; sectionModel.subSectionModels = new List <SubSectionModel>(); foreach (var subSection in setzDB.SubSections.Where(subs => subs.SectionID == section.ID).OrderBy(ss => ss.Order)) { SubSectionModel subSectionModel = new SubSectionModel(); subSectionModel.subSection = subSection; subSectionModel.categoryModels = new List <CategoryModel>(); foreach (var category in setzDB.Categories.Where(a => a.SubSectionID == subSection.ID).OrderBy(c => c.Order)) { CategoryModel categoryModel = new CategoryModel(); categoryModel.category = category; categoryModel.subCategories = new List <SubCategory>(); foreach (var subCategory in setzDB.SubCategories.Where(b => b.CategoryID == category.ID).OrderBy(sc => sc.Order)) { categoryModel.subCategories.Add(subCategory); } subSectionModel.categoryModels.Add(categoryModel); } sectionModel.subSectionModels.Add(subSectionModel); } model.sectionModels.Add(sectionModel); } return(View(model)); }
public string Post(SubSectionModel subSectionModel) { string success = ""; try { using (var db = new BookDbContext()) { var bookSubSection = new SubSection() { SectionId = subSectionModel.SectionId, Id = subSectionModel.Id, SubSectionTitle = subSectionModel.SubSectionTitle, SubSectionOrder = subSectionModel.SubSectionOrder, SubSectionContents = subSectionModel.SubSectionContents, }; db.SubSections.Add(bookSubSection); db.SaveChanges(); success = bookSubSection.Id.ToString(); } } catch (Exception ex) { success = Helpers.ErrorDetails(ex); } return(success); }
public List <SectionModel> generateNavBar() { List <SectionModel> sectionModelList = new List <SectionModel>(); foreach (var section in setzDB.Sections.OrderBy(s => s.Order)) { if (section.Visibility) { SectionModel sectionModel = new SectionModel(); sectionModel.section = section; sectionModel.subSectionModels = new List <SubSectionModel>(); foreach (var subSection in setzDB.SubSections.Where(subs => subs.SectionID == section.ID).OrderBy(ss => ss.Order)) { if (subSection.Visibility) { SubSectionModel subSectionModel = new SubSectionModel(); subSectionModel.subSection = subSection; subSectionModel.categoryModels = new List <CategoryModel>(); foreach (var category in setzDB.Categories.Where(c => c.SubSectionID == subSection.ID).OrderBy(c => c.Order)) { if (category.Visibility) { CategoryModel categoryModel = new CategoryModel(); categoryModel.category = category; //categoryModel.subCategories = setzDB.SubCategories.Where(s => s.CategoryID == category.ID).ToList(); subSectionModel.categoryModels.Add(categoryModel); } } sectionModel.subSectionModels.Add(subSectionModel); } } sectionModelList.Add(sectionModel); } } return(sectionModelList); }
public SectionDataModel(SubSectionModel obj) { SubSections = new List <SubSectionModel>(); SubSections.Add(obj); }