//[CheckPermission] public JsonResult GetPermissionByRole(string RoleID, string ModuleID, string isadmin) { try { CSF_MVCEntities ett = new CSF_MVCEntities(); int ROLEID = Convert.ToInt32(RoleID); int MODULEID = Convert.ToInt32(ModuleID); bool ISADMIN = Convert.ToBoolean(isadmin); List <int> lFuncByRole = ett.CSF_RoleFunction.Where(x => x.RoleID == ROLEID).Select(x => (int)x.FunctionID).ToList(); List <int> lPageByRole = ett.CSF_PageRole.Where(x => x.RoleID == ROLEID).Select(x => (int)x.PageID).ToList(); #region jsTreePage List <jsTree> jsTreeList = new List <jsTree>(); jsTree objTree = new jsTree(); jsTreeState state; var dataAll = ett.CSF_Pages.Where(x => x.IsAdmin == ISADMIN).OrderBy(x => x.Order).ToList(); var data = dataAll.Where(x => x.ParentID == 0); foreach (var item in data) { objTree = new jsTree(); state = new jsTreeState(); objTree.id = item.ID; objTree.text = item.Name; if (lPageByRole.Contains(item.ID)) { state.selected = true; } objTree.children = getChild(item.ID, dataAll, lPageByRole); objTree.state = state; jsTreeList.Add(objTree); } #endregion #region jsTreeFunction List <jsTree> jsTreeListF = new List <jsTree>(); jsTree objTreeF = new jsTree(); jsTreeState stateF; var dataAllF = ett.CSF_Functions.Where(x => x.ModuleID == MODULEID).ToList(); var dataF = dataAllF.Where(x => x.ParentID == 0); foreach (var item in dataF) { objTreeF = new jsTree(); stateF = new jsTreeState(); objTreeF.id = item.ID; objTreeF.text = item.Name; if (lFuncByRole.Contains(item.ID)) { stateF.selected = true; } objTreeF.children = getChildF(item.ID, dataAllF, lFuncByRole); objTreeF.state = stateF; jsTreeListF.Add(objTreeF); } #endregion var jsonResults = new { lFuncByRole, lPageByRole, jsTreeList, jsTreeListF, state = true }; return(Json(jsonResults, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet)); } }
public List <jsTree> getChildF(int ParentID, List <CSF_Functions> dataAll, List <int> lFuncByRole) { try { List <jsTree> jsTreeList = new List <jsTree>(); jsTree objTree; jsTreeState state; var data = dataAll.Where(x => x.ParentID == ParentID); if (data.Count() > 0) { foreach (var item in data) { objTree = new jsTree(); state = new jsTreeState(); objTree.id = item.ID; objTree.text = item.Name; if (lFuncByRole.Contains(item.ID)) { state.selected = true; } objTree.children = getChildF(item.ID, dataAll, lFuncByRole); objTree.state = state; jsTreeList.Add(objTree); } } return(jsTreeList); } catch (Exception ex) { throw ex; } }
public List <jsTree> getChild(int ParentID, List <CSF_Pages> dataAll) { try { List <jsTree> jsTreeList = new List <jsTree>(); jsTree objTree; var data = dataAll.Where(x => x.ParentID == ParentID); if (data.Count() > 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); } } return(jsTreeList); } catch (Exception ex) { throw ex; } }
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)); } }
//[CheckPermission] public JsonResult GetPermissionByRole(string RoleID, string ModuleID, string isadmin) { try { DT_WebGISEntities ett = new DT_WebGISEntities(); int ROLEID = Convert.ToInt32(RoleID); int MODULEID = Convert.ToInt32(ModuleID); bool ISADMIN = Convert.ToBoolean(isadmin); //List<int> lFuncByRole = ett.CSF_RoleFunction.Where(x => x.RoleID == ROLEID) // .Select(x => (int)x.FunctionID) // .ToList(); List <int> lFuncByRole = ett.CSF_Functions .Join(ett.CSF_Modules, fc => fc.ModuleID, md => md.ID, (fc, md) => new { CSF_Functions = fc, CSF_Modules = md }) .Where(md => md.CSF_Modules.IsActive == true) .Select(mfc => mfc.CSF_Functions) .Join(ett.CSF_RoleFunction, mfc => mfc.ID, rfc => rfc.FunctionID, (mfc, rfc) => new { CSF_Functions = mfc, CSF_RoleFunction = rfc }) .Select(fr => fr.CSF_RoleFunction) .Where(x => x.RoleID == ROLEID) .Select(x => (int)x.FunctionID) .ToList(); //List<int> lPageByRole = ett.CSF_PageRole.Where(x => x.RoleID == ROLEID).Select(x => (int)x.PageID).ToList(); List <int> lPageByRole = ett.CSF_Pages .Join(ett.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(mpg => mpg.CSF_Pages) .Join(ett.CSF_PageRole, pg => pg.ID, pr => pr.PageID, (pg, pr) => new { CSF_Pages = pg, CSF_PageRole = pr }) .Select(pgr => pgr.CSF_PageRole) .Where(x => x.RoleID == ROLEID).Select(x => (int)x.PageID).ToList(); #region jsTreePage List <jsTree> jsTreeList = new List <jsTree>(); jsTree objTree = new jsTree(); jsTreeState state; //var dataAll = ett.CSF_Pages.Where(x => x.IsAdmin == ISADMIN && x.IsActive == true).OrderBy(x => x.Order).ToList(); var dataAll = ett.CSF_Pages .Join(ett.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(pgmd => pgmd.CSF_Pages) .Where(x => x.IsAdmin == ISADMIN && x.IsActive == true).OrderBy(x => x.Order).ToList(); var data = dataAll.Where(x => x.ParentID == 0); foreach (var item in data) { objTree = new jsTree(); state = new jsTreeState(); objTree.id = item.ID; objTree.text = item.Name; if (lPageByRole.Contains(item.ID)) { state.selected = true; } objTree.children = getChild(item.ID, dataAll, lPageByRole); objTree.state = state; jsTreeList.Add(objTree); } #endregion #region jsTreeFunction List <jsTree> jsTreeListF = new List <jsTree>(); jsTree objTreeF = new jsTree(); jsTreeState stateF; //var dataAllF = ett.CSF_Functions.Where(x => x.ModuleID == MODULEID).ToList(); var dataAllF = ett.CSF_Functions .Join(ett.CSF_Modules, fc => fc.ModuleID, md => md.ID, (fc, md) => new { CSF_Functions = fc, CSF_Modules = md }) .Where(md => md.CSF_Modules.IsActive == true) .Select(fc => fc.CSF_Functions) .Where(x => x.ModuleID == MODULEID).ToList(); var dataF = dataAllF.Where(x => x.ParentID == 0); foreach (var item in dataF) { objTreeF = new jsTree(); stateF = new jsTreeState(); objTreeF.id = item.ID; objTreeF.text = item.Name; if (lFuncByRole.Contains(item.ID)) { stateF.selected = true; } objTreeF.children = getChildF(item.ID, dataAllF, lFuncByRole); objTreeF.state = stateF; jsTreeListF.Add(objTreeF); } #endregion var jsonResults = new { lFuncByRole, lPageByRole, jsTreeList, jsTreeListF, state = true }; return(Json(jsonResults, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet)); } }
public JsonResult DescriptionGetir([DataSourceRequest] DataSourceRequest request) { JsonResult jsonResult; try { int genelID = (int)base.Session["genelID"]; List <jsTree> jsTrees = new List <jsTree>(); jsTree _jsTree = new jsTree(); this.db.Database.Connection.Open(); using (this.db.Database.Connection) { SqlDataReader sqlDataReader = (new SqlCommand() { Connection = (SqlConnection)this.db.Database.Connection, CommandText = string.Concat("Set nocount on Set Dateformat dmy " + "IF OBJECT_ID('tempdb..#Description') IS NOT NULL begin drop table #Description end " + "Declare @sp_Sirket_Kod varchar(10)=1 Declare @spGenelid int = ", genelID.ToString(), " Declare @spSecim bit = 1 " + "Declare @spTeklifMasterid int= 0 " + "select s.Aciklamaid, t.StokAciklama, g.Kategoriid, g.Kampanyaid into #Description from StokKarti s " + "inner join KampanyalarGecici g on g.Genelid=@spGenelid and g.Kampanyaid=s.Kampanyaid and g.Secim=1 " + "inner join StokKartiTanim t on t.Sirket_Kod = s.Sirket_Kod and t.id = s.Aciklamaid where s.Sirket_Kod = @sp_Sirket_Kod " + "group by s.Aciklamaid, t.StokAciklama, g.Kategoriid, g.Kampanyaid " + "Delete DescriptionGecici " + "where Genelid = @spGenelid and not exists(select * from #Description where Aciklamaid=DescriptionGecici.Aciklamaid) insert into DescriptionGecici(Genelid, Kategoriid, KategoriAciklama, Aciklamaid, StokAciklama, Secim) select @spGenelid, t.Kategoriid, isnull((select Tanim from Kategoriler where Sirket_Kod = @sp_Sirket_Kod and id = t.Kategoriid), ''), t.Aciklamaid, t.StokAciklama, @spSecim from #Description t where not exists(select id from DescriptionGecici where Genelid = @spGenelid and Aciklamaid = t.Aciklamaid) select DISTINCT g.Genelid, Aciklamaid, StokAciklama, Secim, Kategoriid, KategoriAciklama from DescriptionGecici g where g.Genelid = @spGenelid order by g.KategoriAciklama, g.StokAciklama ") }).ExecuteReader(CommandBehavior.CloseConnection); if (sqlDataReader != null) { List <KampanyalarDescriptionDTO> kampanyalarDescriptionDTOs = new List <KampanyalarDescriptionDTO>(); while (sqlDataReader.Read()) { kampanyalarDescriptionDTOs.Add(new KampanyalarDescriptionDTO() { Genelid = (int)sqlDataReader["Genelid"], Aciklamaid = (int)sqlDataReader["Aciklamaid"], StokAciklama = (string)sqlDataReader["StokAciklama"], Secim = (bool)sqlDataReader["Secim"], Kategoriid = (int)sqlDataReader["Kategoriid"], KategoriAciklama = (string)sqlDataReader["KategoriAciklama"] }); } sqlDataReader.Close(); foreach (var kategori in kampanyalarDescriptionDTOs .GroupBy(group => group.Kategoriid) .Select(select => new { key = select.Key, item = select.ToList() })) { _jsTree = new jsTree() { id = string.Concat("*", kategori.key), text = kategori.item.Select(s => s.KategoriAciklama).FirstOrDefault(), parent = "#", state = new jsTree_state() { opened = false, disabled = false, selected = false }, li_attr = new jsTree_attr() { @class = "root" } }; jsTrees.Add(_jsTree); foreach (KampanyalarDescriptionDTO kampanyalarDescriptionDTO in kategori.item) { _jsTree = new jsTree() { id = kampanyalarDescriptionDTO.Aciklamaid.ToString(), text = kampanyalarDescriptionDTO.StokAciklama, parent = string.Concat("*", kategori.key), state = new jsTree_state() { opened = false, disabled = false, selected = true }, li_attr = new jsTree_attr() { @class = "treeKampanya" } }; jsTrees.Add(_jsTree); } } jsonResult = base.Json(jsTrees, JsonRequestBehavior.AllowGet); } else { jsonResult = null; } } } catch (SqlException sqlException) { throw; } finally { this.db.Database.Connection.Close(); } return(jsonResult); }
public JsonResult KampanyaTreeDoldur() { //string webKullaniciNo = Session["WebKullaniciNo"].ToString(); //WebKullanicilari webKullanicilari = this.db.WebKullanicilari.FirstOrDefault(w => w.WebKullaniciNo == webKullaniciNo); //List<WebKullaniciYetkileri> webKullaniciYetkileri = webKullanicilari.WebKullaniciYetkileri.ToList(); //List<jsTree> Tree = new List<jsTree>(); ///* Kategoriler ve kampanyalar*/ //List<Kategoriler> kategoriler = (from kat in db.Kategoriler // join kam in db.Kampanyalar.Where(w => w.Aktif && w.PortaldeGoster) on kat.id equals kam.Kategoriid // select new Kategoriler() // { // id = kat.id, // Tanim = kat.Tanim // }).ToList(); //foreach (var kategori in kategoriler) //{ // jsTree Node = new jsTree(); // Node = new jsTree(); // Node.id = "*" + kategori.id; // Node.text = kategori.Tanim; // Node.parent = "#"; // Node.state = new jsTree_state() { opened = false, disabled = false, selected = false }; // Node.li_attr = new jsTree_attr { @class = "root" }; // if (webKullaniciYetkileri.Count() != 0) // { // if (!webKullaniciYetkileri.Select(s => s.Kategoriid).Contains(kategori.id)) continue; // } // Tree.Add(Node); // List<Kampanyalar> kategoriyegoreKampanyalar = db.Kampanyalar // .Where(w => w.Kategoriid == kategori.id && w.Aktif && w.PortaldeGoster) // .OrderBy(oby => oby.Tanim).ToList(); // foreach (var kampanya in kategoriyegoreKampanyalar) // { // Node = new jsTree(); // Node.id = "$" + kampanya.id.ToString(); // Node.text = kampanya.Tanim; // Node.parent = "*" + kampanya.Kategoriid; // Node.state = new jsTree_state() { opened = false, disabled = false, selected = false }; // Node.li_attr = new jsTree_attr { @class = "treeKampanya" }; // if (Request.IsAuthenticated && webKullanicilari.WebKullaniciRoles == "Kategori") // { // Node.li_attr = new jsTree_attr() // { // @class = "hidden" // }; // } // Tree.Add(Node); // } //} //return Json(Tree, JsonRequestBehavior.AllowGet); string webKullaniciNo = Session["WebKullaniciNo"].ToString(); WebKullanicilari webKullanicilari = this.db.WebKullanicilari.FirstOrDefault(w => w.WebKullaniciNo == webKullaniciNo); List <WebKullaniciYetkileri> webKullaniciYetkileri = webKullanicilari.WebKullaniciYetkileri.ToList(); List <jsTree> Tree = new List <jsTree>(); /* Kategoriler ve kampanyalar*/ List <Kampanyalar> kampanyalar = db.Kampanyalar.Where(w => w.Aktif && w.PortaldeGoster).OrderBy(o => o.Tanim).ToList(); jsTree Node = new jsTree(); //var kategoriyeGoreKampanyalar = kampanyalar.GroupBy(group => group.Kategoriid).Select(select => new { key = select.Key, item = select.ToList().OrderBy(o => o.Kategoriler.Tanim) }); var kategoriyeGoreKampanyalar = (from w in kampanyalar where w.Aktif select w into oby orderby oby.Kategoriler.Tanim select oby into g group g by g.Kategoriid into s select new { kategoriId = s.Key, kampanyalar = s.ToList <Kampanyalar>() }).ToList(); //Node = new jsTree(); //Node.id = "**" + "0"; //Node.text = "Kategorilerine Göre Kampanyalar"; //Node.parent = "#"; //Node.state = new jsTree_state() { opened = true, disabled = false, selected = false }; //Node.li_attr = new jsTree_attr { @class = "root" }; //Tree.Add(Node); foreach (var grupItem in kategoriyeGoreKampanyalar.ToList()) { //foreach (var yetki in webKullaniciYetkileri) //{ // yetki.Kategoriid //} Node = new jsTree(); Node.id = "*" + grupItem.kategoriId; Node.text = grupItem.kampanyalar.Where(w => w.Kategoriid == grupItem.kategoriId).Select(s => s.Kategoriler.Tanim).FirstOrDefault(); Node.parent = "#"; Node.state = new jsTree_state() { opened = false, disabled = false, selected = false }; Node.li_attr = new jsTree_attr { @class = "root" }; if (webKullaniciYetkileri.Count() != 0) { if (!webKullaniciYetkileri.Select(s => s.Kategoriid).Contains(grupItem.kategoriId)) { continue; } } Tree.Add(Node); foreach (var item in grupItem.kampanyalar) { Node = new jsTree(); Node.id = "$" + item.id.ToString(); Node.text = item.Tanim; Node.parent = "*" + grupItem.kategoriId; Node.state = new jsTree_state() { opened = false, disabled = false, selected = false }; Node.li_attr = new jsTree_attr { @class = "treeKampanya" }; if (Request.IsAuthenticated && webKullanicilari.WebKullaniciRoles == "Kategori") { Node.li_attr = new jsTree_attr() { @class = "hidden" }; } Tree.Add(Node); } } return(Json(Tree, JsonRequestBehavior.AllowGet)); }