private static void CreateMenu() { string conn1 = "Server=.\\SQLEXPRESS;Database=RiskappCommon;User Id=sa;Password=mk#12345;"; //We cannot run/use Simple.Data when support for legacy framework is allowed. dynamic commonDbContext = Simple.Data.Database.OpenConnection(conn1); List<MenuRights> menuRights = commonDbContext.MenuRights.All(); string menuIds = menuRights.FirstOrDefault(m=>m.RoleId == 1).MenuIds; Console.WriteLine(menuIds); HRA4.Entities.Menu menu = new HRA4.Entities.Menu() { MenuName = "Manage Users", Roles = "SuperAdmin|Administrator", Controller = "User", Action = "Index" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Manage Institution", Roles = "SuperAdmin", Controller = "Admin", Action = "Index" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Manage Providers", Roles = "SuperAdmin|Administrator", Controller = "Providers", Action = "Index" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Manage Documents", Roles = "SuperAdmin|Administrator", Controller = "DocumentEditor", Action = "Index" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Audit Reports", Roles = "SuperAdmin|Administrator", Controller = "Reports", Action = "AuditReports" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "TestPatient", Roles = "SuperAdmin|Administrator", Controller = "TestPatient", Action = "TestPatients" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Manage Clinics", Roles = "SuperAdmin|Administrator", Controller = "Clinics", Action = "Index" }; commonDbContext.Menu.Insert(menu); }
private static void CreateMenu() { string conn1 = "Server=.\\SQLEXPRESS;Database=RiskappCommon;User Id=sa;Password=mk#12345;"; //We cannot run/use Simple.Data when support for legacy framework is allowed. dynamic commonDbContext = Simple.Data.Database.OpenConnection(conn1); List <MenuRights> menuRights = commonDbContext.MenuRights.All(); string menuIds = menuRights.FirstOrDefault(m => m.RoleId == 1).MenuIds; Console.WriteLine(menuIds); HRA4.Entities.Menu menu = new HRA4.Entities.Menu() { MenuName = "Manage Users", Roles = "SuperAdmin|Administrator", Controller = "User", Action = "Index" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Manage Institution", Roles = "SuperAdmin", Controller = "Admin", Action = "Index" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Manage Providers", Roles = "SuperAdmin|Administrator", Controller = "Providers", Action = "Index" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Manage Documents", Roles = "SuperAdmin|Administrator", Controller = "DocumentEditor", Action = "Index" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Audit Reports", Roles = "SuperAdmin|Administrator", Controller = "Reports", Action = "AuditReports" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "TestPatient", Roles = "SuperAdmin|Administrator", Controller = "TestPatient", Action = "TestPatients" }; commonDbContext.Menu.Insert(menu); menu = new HRA4.Entities.Menu() { MenuName = "Manage Clinics", Roles = "SuperAdmin|Administrator", Controller = "Clinics", Action = "Index" }; commonDbContext.Menu.Insert(menu); }