public JsonResult GetDataPageSetup(string pageid) { try { CSF_MVCEntities ett = new CSF_MVCEntities(); var modules = from a in ett.CSF_Modules select new { a.ID, a.Name }; int PAGEID = Convert.ToInt32(pageid); CSF_Pages_DAO dao = new CSF_Pages_DAO(); List <CSF_Pages_GetPartial_Result> lData = dao.GetPartialByPageID(PAGEID, -1); var lDataBox = (from a in lData where a.IsBox == true select new { a.ID, a.Title }).ToList(); List <PagePartialBox> listPPB = new List <PagePartialBox>(); PagePartialBox ppb; foreach (var item in lData.Where(x => x.IsBox == true)) { ppb = new PagePartialBox(); ppb.box = item; ppb.boxChild = lData.Where(x => x.BoxParent == item.ID).ToList(); listPPB.Add(ppb); } //get list all page to copy var listPage = (from a in ett.CSF_Pages where a.IsActive == true && a.IsAdmin == false orderby a.Name select new { a.ID, a.Name }).ToList(); var jsonResults = new { modules, lData, lDataBox, listPPB, listPage, state = true }; return(Json(jsonResults, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetDataPageSetup(string pageid) { try { DT_WebGISEntities ett = new DT_WebGISEntities(); var modules = from a in ett.CSF_Modules where a.IsActive == false select new { a.ID, a.Name }; int PAGEID = Convert.ToInt32(pageid); CSF_Pages_DAO dao = new CSF_Pages_DAO(); List <CSF_Pages_GetPartial_Result> lData = dao.GetPartialByPageID(PAGEID, -1); var lDataBox = (from a in lData where a.IsBox == true select new { a.ID, a.Title }).ToList(); List <PagePartialBox> listPPB = new List <PagePartialBox>(); PagePartialBox ppb; foreach (var item in lData.Where(x => x.IsBox == true)) { ppb = new PagePartialBox(); ppb.box = item; ppb.boxChild = lData.Where(x => x.BoxParent == item.ID).ToList(); listPPB.Add(ppb); } //get list all page to copy //var listPage = (from a in ett.CSF_Pages where a.IsActive == true && a.IsAdmin == false orderby a.Name select new { a.ID, a.Name }).ToList(); List <SubSelectBox> listPage = new List <SubSelectBox>(); SubSelectBox sc; var listData = ett.CSF_Pages.Where(x => x.IsAdmin == false).ToList(); var listData0 = listData.Where(x => x.ParentID == 0).OrderBy(x => x.Order).ToList(); string tag = ""; foreach (var item in listData0) { sc = new SubSelectBox(); sc.id = item.ID; sc.name = item.Name; listPage.Add(sc); BuildSubTree(listPage, item.ID, listData, tag); } var jsonResults = new { modules, lData, lDataBox, listPPB, listPage, state = true }; return(Json(jsonResults, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet)); } }