Ejemplo n.º 1
0
        public JsonResult sodotrang()
        {
            try
            {
                DT_WebGISEntities ett = new DT_WebGISEntities();
                bool ISADMIN          = false;
                bool ISBLANK          = false;

                #region jsTreePage

                List <jsTree> jsTreeList = new List <jsTree>();
                jsTree        objTree    = new jsTree();
                var           dataAll    = ett.CSF_Pages.Where(x => x.IsAdmin == ISADMIN && x.IsBlank == ISBLANK && x.IsActive == true).OrderBy(x => x.Order).ToList();
                var           data       = dataAll.Where(x => x.ParentID == 0);
                foreach (var item in data)
                {
                    objTree      = new jsTree();
                    objTree.id   = item.ID;
                    objTree.text = item.Name;

                    objTree.children = getChild(item.ID, dataAll);
                    jsTreeList.Add(objTree);
                }

                #endregion jsTreePage

                var jsonResults = new { jsTreeList, state = true };
                return(Json(jsonResults, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet));
            }
        }
Ejemplo n.º 2
0
        public PartialViewResult DSHoiDap(string title, string category, string key, string type, int?page)
        {
            try
            {
                ViewBag.TITLE = title;
                ViewBag.CATE  = category;
                int typeID = type != null?Convert.ToInt32(type) : 0;

                key = key != null ? key : "";
                CMS_Questions_DAO objDAO = new CMS_Questions_DAO();
                var data       = objDAO.Search(key, typeID, true);
                int pageSize   = 10;
                int pageNumber = (page ?? 1);
                using (DT_WebGISEntities MyContext = new DT_WebGISEntities())
                {
                    TempData["LoaiCauHoi"] = MyContext.CMS_TypeOfQuestion.ToList();
                    TempData.Keep("LoaiCauHoi");
                }
                ViewBag.KEY  = key;
                ViewBag.TYPE = typeID;
                return(PartialView(data.ToPagedList(pageNumber, pageSize)));
            }
            catch (Exception ex)
            {
                Logs.WriteLog(ex);
                return(PartialView());
            }
        }
Ejemplo n.º 3
0
        //
        // GET: /HinhAnh/
        // cate: loai hinh anh
        public PartialViewResult IndexHinhAnh(string title, string category, string cate)
        {
            try
            {
                DT_WebGISEntities MyContext = new DT_WebGISEntities();
                ViewBag.TITLE = title;
                int cateID = 0;
                if (cate == null)
                {
                    var objCate = MyContext.CMS_TypeOfPhoto.FirstOrDefault();
                    cateID           = objCate.ID;
                    ViewBag.CATENAME = objCate.Name;
                }
                else
                {
                    cateID = Convert.ToInt32(cate);
                    var objCate = MyContext.CMS_TypeOfPhoto.Find(cateID);
                    ViewBag.CATENAME = objCate.Name;
                }
                var listData = MyContext.CMS_Photos.Where(s => s.Publish == true && s.TypeOfPhotoID == cateID).OrderBy(s => s.CreateDate).ToList();

                //album
                TempData["ALBUM"] = MyContext.CMS_TypeOfPhoto.ToList();
                TempData.Keep("ALBUM");
                return(PartialView(listData));
            }
            catch (Exception ex)
            {
                Logs.WriteLog(ex);
                return(PartialView());
            }
        }
Ejemplo n.º 4
0
 public ActionResult ThongKeVanBan(string keyWord, string type, string area, string org, int?page)
 {
     try
     {
         DT_WebGISEntities MVCContext = new DT_WebGISEntities();
         TempData["TypeOfDocumentID"] = MVCContext.CMS_TypeOfDocument.ToList();
         TempData.Keep("TypeOfDocumentID");
         TempData["AreaOfDocument"] = MVCContext.CMS_AreaOfDocument.ToList();
         TempData.Keep("AreaOfDocument");
         TempData["OrganizationID"] = MVCContext.CMS_Organization.ToList();
         TempData.Keep("OrganizationID");
         int typeID = Convert.ToInt32(type);
         int areaID = Convert.ToInt32(area);
         int orgID  = Convert.ToInt32(org);
         keyWord = keyWord != null ? keyWord : "";
         CMS_Documents_DAO objDAO = new CMS_Documents_DAO();
         var data = objDAO.Search(keyWord, typeID, areaID, orgID).Where(x => x.Publish == true);
         ViewBag.SearchString = keyWord;
         ViewBag.TYPE         = type;
         ViewBag.AREA         = area;
         ViewBag.ORG          = org;
         int pageSize   = 10;
         int pageNumber = (page ?? 1);
         return(View(data.ToPagedList(pageNumber, pageSize)));
     }
     catch (Exception ex)
     {
         SetAlert("Lỗi" + ex.Message.ToString(), "error");
         Logs.WriteLog(ex);
         return(View());
     }
 }
Ejemplo n.º 5
0
 public ActionResult Edit(int id)
 {
     try
     {
         DT_WebGISEntities  MyContext = new DT_WebGISEntities();
         CMS_Categories_DAO objDAO    = new CMS_Categories_DAO();
         var Partial = objDAO.GetCategoriesByID(id);
         List <SubSelectBox> listTree = new List <SubSelectBox>();
         SubSelectBox        sc;
         var    listData  = MyContext.CMS_Categories.ToList();
         var    listData0 = listData.Where(x => x.PARENTCATE == 0).OrderBy(x => x.ORDERS).ToList();
         string tag       = "";
         foreach (var item in listData0)
         {
             sc      = new SubSelectBox();
             sc.id   = item.ID;
             sc.name = item.NAME;
             listTree.Add(sc);
             BuildSubTree(listTree, item.ID, listData, tag);
         }
         TempData["PARENTCATE"] = listTree;
         TempData.Keep("PARENTCATE");
         return(View(Partial));
     }
     catch (Exception ex)
     {
         SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error);
         Logs.WriteLog(ex);
         return(View());
     }
 }
Ejemplo n.º 6
0
 public JsonResult GetPageParent(string isadmin)
 {
     try
     {
         DT_WebGISEntities MyContext = new DT_WebGISEntities();
         bool IsAdmin = isadmin == "true" ? true : false;
         List <SubSelectBox> listTree = new List <SubSelectBox>();
         SubSelectBox        sc;
         //var listData = MyContext.CSF_Pages.Where(x => x.IsAdmin == IsAdmin).ToList();
         var listData = MyContext.CSF_Pages
                        .Join(MyContext.CSF_Modules,
                              pg => pg.ModuleID,
                              md => md.ID,
                              (pg, md) => new { CSF_Pages = pg, CSF_Modules = md })
                        .Where(md => md.CSF_Modules.IsActive == true)
                        .Select(mdp => mdp.CSF_Pages)
                        .Where(x => x.IsAdmin == IsAdmin).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;
             listTree.Add(sc);
             BuildSubTree(listTree, item.ID, listData, tag);
         }
         var jsonResults = new { listTree, state = true };
         return(Json(jsonResults, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet));
     }
 }
Ejemplo n.º 7
0
 private void setAutheniticated(string username)
 {
     try
     {
         DT_WebGISEntities MyContext  = new DT_WebGISEntities();
         CSF_Users_DAO     objUserDao = new CSF_Users_DAO();
         var user = objUserDao.GetByUserName(username);
         if (user == null)
         {
             CSF_Users obj = new CSF_Users();
             obj.UserName     = username;
             obj.FullName     = username;
             obj.Status       = 1;
             obj.RegisterDate = DateTime.Now;
             obj.Email        = username + "@monre.gov.vn";
             obj.Password     = Encryptor.MD5Hash("e10adc3949ba59abbe56e057f20f883e");
             MyContext.CSF_Users.Add(obj);
             MyContext.SaveChanges();
             if (obj.ID > 0)
             {
                 int          IDRegistedGroup = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["IDRegistedGroup"]);
                 CSF_UserRole objUR           = new CSF_UserRole();
                 objUR.RoleID = IDRegistedGroup;
                 objUR.UserID = obj.ID;
                 MyContext.CSF_UserRole.Add(objUR);
                 MyContext.SaveChanges();
             }
         }
         FormsAuthentication.SetAuthCookie(username, false);
     }
     catch (Exception ex)
     {
         Logs.WriteLog(ex);
     }
 }
Ejemplo n.º 8
0
        protected void SetTempData2SelectList(int moduleid, int pageid, bool IsAdmin)
        {
            DT_WebGISEntities MyContext = new DT_WebGISEntities();
            var listModules             = MyContext.CSF_Modules;

            TempData["module"] = new SelectList(listModules, "ID", "Name", moduleid);
            TempData.Keep("module");
            List <SubSelectBox> listTree = new List <SubSelectBox>();
            SubSelectBox        sc;
            //var listData = MyContext.CSF_Pages.Where(x => x.IsAdmin == IsAdmin).ToList();
            var listData = MyContext.CSF_Pages
                           .Join(MyContext.CSF_Modules,
                                 pg => pg.ModuleID,
                                 md => md.ID,
                                 (pg, md) => new { CSF_Pages = pg, CSF_Modules = md })
                           .Where(md => md.CSF_Modules.IsActive == false)
                           .Select(mdp => mdp.CSF_Pages)
                           .Where(x => x.IsAdmin == IsAdmin).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;
                listTree.Add(sc);
                BuildSubTree(listTree, item.ID, listData, tag);
            }
            TempData["page"] = listTree;
            TempData.Keep("page");
        }
Ejemplo n.º 9
0
        public ActionResult ThongKeCauHoi(string keyWord, string type, int?page)
        {
            try
            {
                DT_WebGISEntities MVCContext = new DT_WebGISEntities();
                TempData["TypeOfQuestionID"] = MVCContext.CMS_TypeOfQuestion.ToList();
                TempData.Keep("TypeOfQuestionID");


                int typeID = type != null?Convert.ToInt32(type) : 0;

                keyWord = keyWord != null ? keyWord : "";
                CMS_Questions_DAO objDAO = new CMS_Questions_DAO();
                var data = objDAO.Search(keyWord, typeID, true);
                ViewBag.SearchString = keyWord;
                ViewBag.TYPE         = type;
                int pageSize   = 10;
                int pageNumber = (page ?? 1);
                return(View(data.ToPagedList(pageNumber, pageSize)));
            }
            catch (Exception ex)
            {
                SetAlert("Lỗi" + ex.Message.ToString(), "error");
                Logs.WriteLog(ex);
                return(View());
            }
        }
Ejemplo n.º 10
0
 public ActionResult Create()
 {
     try
     {
         CMS_News_DAO      objDAO     = new CMS_News_DAO();
         DT_WebGISEntities MVCContext = new DT_WebGISEntities();
         //var listData = MVCContext.CMS_Categories.Where(x => x.PUBLISH == true).AsQueryable().Select(new x SubSelectBox { }).ToList();
         List <SubSelectBox> listTree = new List <SubSelectBox>();
         SubSelectBox        sc;
         var listData     = (from a in MVCContext.CMS_Categories where a.PUBLISH == true select new SubSelectBox()
         {
             id = a.ID, name = a.NAME, parentid = (int)a.PARENTCATE
         }).ToList();
         var    listData0 = listData.Where(x => x.parentid == 0).ToList();
         string tag       = "";
         foreach (var item in listData0)
         {
             sc      = new SubSelectBox();
             sc.id   = item.id;
             sc.name = item.name;
             listTree.Add(sc);
             BuildSubTree(listTree, item.id, listData, tag);
         }
         TempData["categories"] = listTree;
         TempData.Keep("categories");
         return(View());
     }
     catch (Exception ex)
     {
         SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error);
         Logs.WriteLog(ex);
         return(View());
     }
 }
Ejemplo n.º 11
0
        public ActionResult ThongKeBanDo(string keyWord, string type, int?page)
        {
            try
            {
                DT_WebGISEntities MVCContext = new DT_WebGISEntities();
                TempData["TypeOfMapID"] = MVCContext.CMS_TypeOfMap.ToList();
                TempData.Keep("TypeOfMapID");


                int          TypeOfMapID  = type == null ? 0 : Convert.ToInt32(type);
                string       searchString = keyWord != null ? keyWord : "";
                CMS_Maps_DAO objDAO       = new CMS_Maps_DAO();
                var          data         = objDAO.Search(searchString, TypeOfMapID);
                ViewBag.SearchString = searchString;
                ViewBag.TYPE         = type;

                int pageSize   = 10;
                int pageNumber = (page ?? 1);
                return(View(data.ToPagedList(pageNumber, pageSize)));
            }
            catch (Exception ex)
            {
                SetAlert("Lỗi" + ex.Message.ToString(), "error");
                Logs.WriteLog(ex);
                return(View());
            }
        }
Ejemplo n.º 12
0
 //[CheckPermission]
 public JsonResult GetDataPermission()
 {
     try
     {
         DT_WebGISEntities ett = new DT_WebGISEntities();
         var lRole             = from a in ett.CSF_Roles select new { a.ID, a.Name };
         var lFunc             = from a in ett.CSF_Functions
                                 join b in ett.CSF_Modules on a.ModuleID equals b.ID
                                 where b.IsActive == true
                                 orderby a.ModuleID
                                 select new { a.ID, a.Name, a.ModuleID, ModuleName = b.Name };
         var lPage = from a in ett.CSF_Pages
                     join b in ett.CSF_Modules on a.ModuleID equals b.ID
                     where b.IsActive == true
                     orderby a.ModuleID
                     where a.IsActive == true
                     select new { a.ID, a.Name, a.ModuleID, ModuleName = b.Name };
         var lModule     = from a in ett.CSF_Modules where a.IsActive == true orderby a.Name select new { a.ID, a.Name };
         var jsonResults = new { lRole, lFunc, lPage, lModule, state = true };
         return(Json(jsonResults, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet));
     }
 }
Ejemplo n.º 13
0
        public PartialViewResult IndexService(string title, string lv, string q, int?page)
        {
            try
            {
                DT_WebGISEntities MyContext = new DT_WebGISEntities();
                ViewBag.TITLE = title;
                q             = q == null ? "" : q;
                ViewBag.Q     = q;
                q             = q.ToLower().Trim();
                int iLV   = lv == null ? 0 : Convert.ToInt32(lv);
                var ldata = MyContext.CMS_Services.Where(x => x.Name.ToLower().Contains(q) && (x.TypeOfMapID == iLV || iLV == 0) && x.Publish == true).ToList();

                TempData["LV"] = MyContext.CMS_TypeOfMap.ToList();
                TempData.Keep("LV");
                ViewBag.LV = iLV;

                int pageSize   = 10;
                int pageNumber = (page ?? 1);
                return(PartialView(ldata.ToPagedList(pageNumber, pageSize)));
            }
            catch (Exception ex)
            {
                Logs.WriteLog(ex);
                return(PartialView());
            }
        }
Ejemplo n.º 14
0
 public JsonResult GetParentID()
 {
     try
     {
         DT_WebGISEntities   MyContext = new DT_WebGISEntities();
         List <SubSelectBox> listTree  = new List <SubSelectBox>();
         SubSelectBox        sc;
         var    listData  = MyContext.CMS_Organization.ToList();
         var    listData0 = listData.Where(x => x.ParentID == 0).ToList();
         string tag       = "";
         foreach (var item in listData0)
         {
             sc      = new SubSelectBox();
             sc.id   = item.ID;
             sc.name = item.Name;
             listTree.Add(sc);
             BuildSubTree(listTree, item.ID, listData, tag);
         }
         var jsonResults = new { listTree, state = true };
         return(Json(jsonResults, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet));
     }
 }
Ejemplo n.º 15
0
        public ActionResult EditBanDo(int id)
        {
            try
            {
                CMS_Maps_DAO       objDAO        = new CMS_Maps_DAO();
                DT_WebGISEntities  MyContext     = new DT_WebGISEntities();
                CMS_MapService_DAO objMapSeveDAO = new CMS_MapService_DAO();
                CMS_Services_DAO   objSeverDAO   = new CMS_Services_DAO();
                var Partial = objDAO.GetMapByID(id);
                var list    = MyContext.CMS_TypeOfMap.ToList();
                TempData["TypeOfMap"] = new SelectList(list, "ID", "Name", (int)Partial.TypeOfMapID);
                TempData.Keep("TypeOfMap");

                var list1 = MyContext.CMS_MapService_ByMapID(id).ToList();
                TempData["MapServices"] = list1.ToList();
                TempData.Keep("MapServices");
                var list2 = MyContext.CMS_Services.Where(s => s.Publish == true).ToList();
                TempData["Services"] = list2;
                TempData.Keep("Services");
                return(View(Partial));
            }
            catch (Exception ex)
            {
                SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error);
                Logs.WriteLog(ex);
                return(View());
            }
        }
Ejemplo n.º 16
0
 public ActionResult Edit(int id)
 {
     try
     {
         CMS_Organization_DAO objDAO = new CMS_Organization_DAO();
         var Partial = objDAO.GetOrganizationByID(id);
         DT_WebGISEntities   MyContext = new DT_WebGISEntities();
         List <SubSelectBox> listTree  = new List <SubSelectBox>();
         SubSelectBox        sc;
         var    listData  = MyContext.CMS_Organization.ToList();
         var    listData0 = listData.Where(x => x.ParentID == 0).ToList();
         string tag       = "";
         foreach (var item in listData0)
         {
             sc      = new SubSelectBox();
             sc.id   = item.ID;
             sc.name = item.Name;
             listTree.Add(sc);
             BuildSubTree(listTree, item.ID, listData, tag);
         }
         TempData["Organization"] = listTree;
         TempData.Keep("Organization");
         return(View(Partial));
     }
     catch (Exception ex)
     {
         SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error);
         Logs.WriteLog(ex);
         return(View());
     }
 }
Ejemplo n.º 17
0
 public PartialViewResult ChiTietTinTuc(string title, string id)
 {
     try
     {
         ViewBag.TITLE = title;
         int newsid = Convert.ToInt32(id);
         using (DT_WebGISEntities MyContext = new DT_WebGISEntities())
         {
             var news = MyContext.CMS_News.Find(newsid);
             if (news != null)
             {
                 int    cateid  = (int)news.ID_CATEGORIES;
                 var    cate    = MyContext.CMS_Categories.Find(cateid);
                 string catekey = cate.KEY;
                 ViewBag.CateName = cate.NAME;
                 HomeController hController = new HomeController();
                 var            listData    = hController.GetCacheTinBai().Where(s => s.CateKey == catekey).Where(x => x.ID != newsid).Take(5).ToList();
                 if (listData != null && listData.Count() > 0)
                 {
                     TempData["tinbaikhac"] = listData;
                     TempData.Keep("tinbaikhac");
                 }
             }
             return(PartialView(news));
         }
     }
     catch (Exception ex)
     {
         Logs.WriteLog(ex);
         return(PartialView());
     }
 }
Ejemplo n.º 18
0
        public override void OnActionExecuting(ActionExecutingContext filterContext)
        {
            try
            {
                var descriptor               = filterContext.ActionDescriptor;
                var actionName               = descriptor.ActionName;
                var controllerName           = descriptor.ControllerDescriptor.ControllerName;
                DT_WebGISEntities MyContext  = new DT_WebGISEntities();
                CSF_Users_DAO     objUserDao = new CSF_Users_DAO();
                string            username   = filterContext.HttpContext.User.Identity.Name;

                if (!string.IsNullOrEmpty(username))
                {
                    int        intGuestGroup    = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["IDGuestGroup"]);
                    List <int> listUserRole     = objUserDao.GetRoleIDByUserName(username, intGuestGroup);
                    string     ControllerAction = controllerName + "-" + actionName;
                    var        ListPermission   = (from a in MyContext.CSF_RoleFunction
                                                   join b in MyContext.CSF_Functions on a.FunctionID equals b.ID
                                                   where listUserRole.Contains(a.RoleID)
                                                   select new { ca = b.Controller_Action.ToLower() }).ToList();
                    //write log
                    int intUserID = objUserDao.GetUserIDByUserName(username);
                    if (intUserID > 0)
                    {
                        CSF_Logs objLog = new CSF_Logs();
                        objLog.Controller_Action = controllerName + "-" + actionName;
                        objLog.CreateDate        = System.DateTime.Now;
                        objLog.UserCreate        = intUserID;
                        //objLog.Content = descriptor.ToString();
                        MyContext.CSF_Logs.Add(objLog);
                        MyContext.SaveChanges();
                    }
                    var permission = ListPermission.Where(x => x.ca.Contains(ControllerAction.ToLower())).FirstOrDefault();
                    if (permission == null && username.ToLower().Trim() != "host")
                    {
                        base.OnActionExecuting(filterContext);
                        filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary {
                            { "controller", "home" }, { "action", "index" }, { "area", "" }
                        });
                    }
                }
                else
                {
                    //filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary { { "controller", "home" }, { "action", "login" }, { "area", "" } });

                    filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary {
                        { "Area", "" },
                        { "Controller", "home" },
                        { "Action", "login" },
                        { "RedirectUrl", filterContext.HttpContext.Request.Url }
                    }
                                                                     );
                }
            }
            catch (Exception ex)
            {
                Logs.WriteLog(ex);
            }
        }
Ejemplo n.º 19
0
        public PartialViewResult MainMenu()
        {
            try
            {
                int intGuestGroup              = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["IDGuestGroup"]);
                DT_WebGISEntities entities     = new DT_WebGISEntities();
                CSF_Users_DAO     objUserDao   = new CSF_Users_DAO();
                string            username     = HttpContext.User.Identity.Name;
                List <int>        lRoleID      = objUserDao.GetRoleIDByUserName(username, intGuestGroup);
                string            stringRoleID = String.Join(",", lRoleID);
                //
                List <CSF_Pages> listAllPage = new List <CSF_Pages>();
                if (username.Trim().ToLower() != "host")
                {
                    //var lPageActiveID = entities.CSF_Pages_GetPageByRoleID(stringRoleID).Select(x => (int)x.id).ToList();
                    //listAllPage = entities.CSF_Pages.Where(x => lPageActiveID.Contains(x.ID) && x.IsAdmin == false).OrderBy(x => x.Order).ToList();

                    var lPageActiveID = entities.CSF_Pages_GetPageByRoleID(stringRoleID).Select(x => (int)x.id).ToList();
                    listAllPage = entities.CSF_Pages
                                  .Where(x => lPageActiveID.Contains(x.ID) && x.IsAdmin == false)
                                  .Join(entities.CSF_Modules,
                                        pg => pg.ModuleID, // Primary Key
                                        md => md.ID,       // Foreign Key
                                        (pg, md) => new { CSF_Pages = pg, CSF_Modules = md })
                                  .Where(pgm => pgm.CSF_Modules.IsActive == false)
                                  .Select(pgm => pgm.CSF_Pages)
                                  .OrderBy(x => x.Order)
                                  .ToList();
                }
                else
                {
                    //listAllPage = entities.CSF_Pages.Where(x => x.IsAdmin == false && x.IsBlank == false && x.IsActive == true).OrderBy(x => x.Order).ToList();

                    listAllPage = entities.CSF_Pages
                                  .Where(x => x.IsAdmin == false && x.IsBlank == false && x.IsActive == true)
                                  .Join(entities.CSF_Modules,
                                        pg => pg.ModuleID, // Primary Key
                                        md => md.ID,       // Foreign Key
                                        (pg, md) => new { CSF_Pages = pg, CSF_Modules = md })
                                  .Where(pgm => pgm.CSF_Modules.IsActive == false)
                                  .Select(pgm => pgm.CSF_Pages)
                                  .OrderBy(x => x.Order)
                                  .ToList();
                }
                //
                string   stringMenu = buildTreeMenu(listAllPage);
                MainMenu mainMenu   = new MainMenu();
                mainMenu.stringMenu = stringMenu;
                return(PartialView(mainMenu));
            }
            catch (Exception ex)
            {
                Logs.WriteLog(ex);
                return(PartialView());
            }
        }
Ejemplo n.º 20
0
 public ActionResult Index(CSF_Templates obj)
 {
     ViewBag.URLIMAGE = System.Configuration.ConfigurationManager.AppSettings["UrlImage"];
     if (ModelState.IsValid)
     {
         DT_WebGISEntities MyContext = new DT_WebGISEntities();
         MyContext.Entry(obj).State = System.Data.Entity.EntityState.Modified;
         MyContext.SaveChanges();
         SetAlert("Lưu giao diên thành công", AlertType.Success);
     }
     return(View(obj));
 }
Ejemplo n.º 21
0
        public JsonResult getService()
        {
            var mapSv = "";
            int idMap = Int32.Parse(Session["idMap"].ToString());

            if (Session["idMap"] != null)
            {
                var mycontext = new DT_WebGISEntities();
                var idservice = mycontext.CMS_MapService.Where(b => b.MapID == idMap).Select(b => b.ServiceID).FirstOrDefault();
                mapSv = mycontext.CMS_Services.Where(b => b.ID == idservice).Select(b => b.URL).FirstOrDefault();
            }
            return(Json(mapSv, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 22
0
        public JsonResult editUrlMap(string url)
        {
            var id = Session["idMap"];
            DT_WebGISEntities db = new DT_WebGISEntities();
            var GT         = db.CMS_Maps.Find(id);
            var service    = db.CMS_MapService.Where(x => x.MapID == GT.ID).FirstOrDefault();
            var serviceMap = db.CMS_Services.Where(x => x.ID == service.ServiceID).FirstOrDefault();

            serviceMap.URL             = url;
            db.Entry(serviceMap).State = EntityState.Modified;
            db.SaveChanges();
            return(Json(new { status = true, message = "" }, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 23
0
        //
        // GET: /Admin/QT_Templates/

        public ActionResult Index()
        {
            DT_WebGISEntities MyContext = new DT_WebGISEntities();

            ViewBag.URLIMAGE = System.Configuration.ConfigurationManager.AppSettings["UrlImage"];
            var temp = MyContext.CSF_Templates.FirstOrDefault();

            if (temp != null)
            {
                return(View(temp));
            }
            return(View());
        }
Ejemplo n.º 24
0
        //public PartialViewResult MapView(int mapid)
        //{

        //    return PartialView();
        //}
        public ActionResult MapView(int?serviceid)
        {
            try
            {
                DT_WebGISEntities db = new DT_WebGISEntities();
                var services         = db.CMS_Services.Find(serviceid);
                return(PartialView(services));
            }
            catch (Exception ex)
            {
                Logs.WriteLog(ex);
                return(PartialView());
            }
        }
Ejemplo n.º 25
0
 public ActionResult Bando()
 {
     try
     {
         DT_WebGISEntities db = new DT_WebGISEntities();
         var id = Session["idMap"];
         var GT = db.CMS_Maps.Find(id);
         return(View(GT));
     }
     catch (Exception ex)
     {
         Logs.WriteLog(ex);
         return(View());
     }
 }
Ejemplo n.º 26
0
 //
 // GET: /Video/
 public PartialViewResult VideoIndex(string title)
 {
     try
     {
         ViewBag.TITLE = title;
         DT_WebGISEntities MyContext = new DT_WebGISEntities();
         var videos = MyContext.CMS_Videos.Where(x => x.Publish == true).ToList();
         return(PartialView(videos));
     }
     catch (Exception ex)
     {
         Logs.WriteLog(ex);
         return(PartialView());
     }
 }
Ejemplo n.º 27
0
 public ActionResult Detail(int id)
 {
     try
     {
         DT_WebGISEntities entity = new DT_WebGISEntities();
         var vb = entity.CMS_Documents.Find(id);
         return(View(vb));
     }
     catch (Exception ex)
     {
         SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error);
         Logs.WriteLog(ex);
         return(View());
     }
 }
Ejemplo n.º 28
0
 public PartialViewResult TinVideo(string title, string category)
 {
     try
     {
         DT_WebGISEntities MyContext = new DT_WebGISEntities();
         ViewBag.TITLE = title;
         var listData = MyContext.CMS_Videos.Where(s => s.Publish == true).OrderByDescending(s => s.CreateDate).Take(3).ToList();
         return(PartialView(listData));
     }
     catch (Exception ex)
     {
         Logs.WriteLog(ex);
         return(PartialView());
     }
 }
Ejemplo n.º 29
0
 public JsonResult getPartials(string moduleid)
 {
     try
     {
         DT_WebGISEntities ett = new DT_WebGISEntities();
         int MODULEID          = Convert.ToInt32(moduleid);
         var partials          = from a in ett.CSF_Partials where a.ModuleID == MODULEID select new { a.ID, a.Name };
         var jsonResults       = new { partials, state = true };
         return(Json(jsonResults, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet));
     }
 }
Ejemplo n.º 30
0
        protected void SetTempData2SelectList(int moduleid, string Controller)
        {
            DT_WebGISEntities MyContext = new DT_WebGISEntities();
            var listModules             = MyContext.CSF_Modules.Where(x => x.IsActive.HasValue == true);

            TempData["module"] = new SelectList(listModules, "ID", "Name", moduleid);
            TempData.Keep("module");
            var selectListItems = GetControllerNames().Select(x => new SelectListItem()
            {
                Value = x, Text = x
            }).ToList();

            TempData["ddlController"] = new SelectList(selectListItems, "Value", "Text", Controller);
            TempData.Keep("ddlController");
        }