//[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));
}
