public List <AdminMenuGroup> getAdminMenuList()
{
List <AdminMenuGroup> lsAdminMenuGroup = new List <AdminMenuGroup>();
var LoginName = AdminUserContext.Current.LoginInfo.LoginName;//.BusinessPermissionList.Select(p => p.ToString());
var LanguageID = AdminUserContext.Current.LoginInfo.LanguageID;
//LanguageID = "0";
string strSql = "Select DISTINCT a.AuthorityID,b.AuthorityName,a.ModuleUrl,a.WebUrl,b.Info,a.DivID,a.UlID,a.Icon,a.Class" +
" From Authority a" +
" Inner Join AuthorityLang b ON a.AuthorityID = b.AuthorityID" +
" Inner Join RoleAuthority c ON a.AuthorityID = c.AuthorityID" +
" Inner Join UserRole d ON c.RoleID = d.RoleID" +
" Inner Join [User] e ON d.UserID = e.ID" +
" Where a.TypeID = '20000' And b.LangID = '" + LanguageID + "' And e.LoginName = '" + LoginName + "'";
DataTable dtMenu = SQLHelper.ExecuteSqlReturnDataTable(strSql);
for (int i = 0; i < dtMenu.Rows.Count; i++)
{
DataRow dr = dtMenu.Rows[i];
AdminMenuGroup item = new AdminMenuGroup();
item.Id = Convert.ToInt32(dr["AuthorityID"]);
item.Name = dr["AuthorityName"].ToString();
item.Url = dr["WebUrl"].ToString();
item.Info = dr["Info"].ToString();
item.DivId = dr["DivID"].ToString();
item.UlId = dr["UlID"].ToString();
item.Icon = dr["Icon"].ToString();
item.Class = dr["Class"].ToString();
lsAdminMenuGroup.Add(item);
}
return(lsAdminMenuGroup);
}
public List <AdminMenuGroupAll> getAdminMenuDetailsList()
{
List <AdminMenuGroupAll> lsAdminMenuGroupAll = new List <AdminMenuGroupAll>();
var LoginName = AdminUserContext.Current.LoginInfo.LoginName;//.BusinessPermissionList.Select(p => p.ToString());
var LanguageID = AdminUserContext.Current.LoginInfo.LanguageID;
//LanguageID = "0";
string strSql1 = "Select DISTINCT a.AuthorityID,a.TypeID,b.AuthorityName,a.ModuleUrl,a.WebUrl,b.Info,a.DivID,a.UlID,a.Icon,a.Class,a.MenuLayer,a.WebID" +
" From Authority a" +
" Inner Join AuthorityLang b ON a.AuthorityID = b.AuthorityID" +
" Inner Join RoleAuthority c ON a.AuthorityID = c.AuthorityID" +
" Inner Join UserRole d ON c.RoleID = d.RoleID" +
" Inner Join [User] e ON d.UserID = e.ID";
string strSql = strSql1 + " Where a.TypeID='20000' And b.LangID='" + LanguageID + "' And e.LoginName='" + LoginName + "'";
DataTable dtMenu = SQLHelper.ExecuteSqlReturnDataTable(strSql);
for (int i = 0; i < dtMenu.Rows.Count; i++)
{
AdminMenuGroupAll itemAll = new AdminMenuGroupAll();
List <AdminMenuGroup> lsAdminMenuGroup = new List <AdminMenuGroup>();
itemAll.DivId = dtMenu.Rows[i]["DivID"].ToString();
var TypeID = Convert.ToInt32(dtMenu.Rows[i]["AuthorityID"]);
DataTable dt = getSubAdminMenuDetails(strSql1, TypeID, LoginName, LanguageID);
for (int j = 0; j < dt.Rows.Count; j++)
{
AdminMenuGroup item = new AdminMenuGroup();
DataRow dr = dt.Rows[j];
item.Id = Convert.ToInt32(dr["AuthorityID"]);
item.Name = dr["AuthorityName"].ToString();
item.Url = dr["WebUrl"].ToString();
item.Info = dr["Info"].ToString();
item.DivId = dr["DivID"].ToString();
item.UlId = dr["UlID"].ToString();
item.Icon = dr["Icon"].ToString();
item.Class = dr["Class"].ToString();
item.MenuLayer = dr["MenuLayer"].ToString();
item.WebId = dr["WebID"].ToString();
var TypeID1 = Convert.ToInt32(dr["AuthorityID"]);
DataTable dt1 = getSubAdminMenuDetails(strSql1, TypeID1, LoginName, LanguageID);
List <AdminMenu> lsAdminMenu = new List <AdminMenu>();
for (int k = 0; k < dt1.Rows.Count; k++)
{
AdminMenu item1 = new AdminMenu();
DataRow dr1 = dt1.Rows[k];
item1.Id = Convert.ToInt32(dr1["AuthorityID"]);
item1.Name = dr1["AuthorityName"].ToString();
item1.Url = dr1["WebUrl"].ToString();
item1.Info = dr1["Info"].ToString();
item1.DivId = dr1["DivID"].ToString();
item1.UlId = dr1["UlID"].ToString();
item1.Icon = dr1["Icon"].ToString();
item1.Class = dr1["Class"].ToString();
item1.MenuLayer = dr1["MenuLayer"].ToString();
item1.WebId = dr1["WebID"].ToString();
lsAdminMenu.Add(item1);
}
item.AdminMenuArray = lsAdminMenu;
lsAdminMenuGroup.Add(item);
}
itemAll.AdminMenuGroup = lsAdminMenuGroup;
lsAdminMenuGroupAll.Add(itemAll);
}
return(lsAdminMenuGroupAll);
}