private void CreateBoardType(SJiraContext context) { var boardType = new List<BoardType> { new BoardType{ Name="Scrum"}, new BoardType{ Name="Kanban"}, }; context.BoardTypes.AddOrUpdate(c => c.Name, boardType.ToArray()); context.SaveChanges(); }
private void CreateMenuItems_My_Open_Issues_ToolBar(SJiraContext context) { var MenuitemTypeButton = context.MenuItemTypes.Where(c => c.Name == "Button").FirstOrDefault(); var MenuitemTypeLink = context.MenuItemTypes.Where(c => c.Name == "Link").FirstOrDefault(); var MenuitemTypeDropdown = context.MenuItemTypes.Where(c => c.Name == "Dropdown").FirstOrDefault(); var MenuitemTypeInput = context.MenuItemTypes.Where(c => c.Name == "Input").FirstOrDefault(); //var MenuManager1 = context.MenuManagers.Where(c => c.Title == "My Open Issues" && c.MenuManagerType.Name == "ToolBar").FirstOrDefault(); MenuItem entity = new MenuItem(); var Menus = new List<MenuItem>(); entity.Title = "New Filter"; entity.MenuAction = "/Issue/New_Filter"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 10; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Type"; entity.MenuAction = "/Issue/Type"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 20; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //------------------------------------------------------------------ entity = new MenuItem(); entity.Title = "Status"; entity.MenuAction = "/Issue/Status"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 30; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Assignee"; entity.MenuAction = "/Issue/Assigneee"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 40; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Contains Text"; entity.MenuAction = "/Issue/Contains_Text"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 50; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "More"; entity.MenuAction = "/Issue/More"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 60; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //--------------------------------------------------------------------------- entity = new MenuItem(); entity.Title = "Advanced"; entity.MenuAction = "/Issue/Advanced"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 70; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "List_Detail"; entity.MenuAction = "/Issue/List_Detail"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 80; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); //context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuManagerId }, Menus.ToArray()); context.SaveChanges(); }
// // GET: /Default1/ public ProjectController() { db = new SJiraContext(); projectModelFactory = new ProjectModelFactory(); }
private void CreateIssueResolution(SJiraContext context) { var issueResolution = new List<IssueResolution> { new IssueResolution{ Name="Fixed"}, new IssueResolution{ Name="Won't Fix"}, new IssueResolution{ Name="Duplicate"}, new IssueResolution{ Name="Incomplete"}, new IssueResolution{ Name="Cannot Reproduce"}, new IssueResolution{ Name="Unresolved"}, new IssueResolution{ Name="Done"} }; context.IssueResolutions.AddOrUpdate(c => c.Name, issueResolution.ToArray()); context.SaveChanges(); }
//private void CreateMenuManagers_Configure(SJiraContext context) //{ // var MenuItemConfigure = context.MenuItems.Where(c => c.Title == "Configure").FirstOrDefault(); // var MenuManagerTypeTabs = context.MenuManagerTypes.Where(c => c.Name == "Tabs").FirstOrDefault(); // var Menus = new List<MenuManager>(); // MenuManager entity = new MenuManager(); // entity.MenuItemId = MenuItemConfigure.MenuItemId; // entity.Title = "Configure"; // entity.MenuManagerTypeId = MenuManagerTypeTabs.MenuManagerTypeId; // Menus.Add(entity); // context.MenuManagers.AddOrUpdate(c => new { c.Title, c.MenuManagerTypeId }, Menus.ToArray()); context.SaveChanges(); //} private void CreateMenuItems_Configure_Tabs(SJiraContext context) { //var MenuManager1 = context.MenuManagers.Where(c => c.Title == "Configure" && c.MenuManagerType.Name == "Tabs").FirstOrDefault(); var MenuitemTypeButton = context.MenuItemTypes.Where(c => c.Name == "Button").FirstOrDefault(); var MenuitemTypeLink = context.MenuItemTypes.Where(c => c.Name == "Link").FirstOrDefault(); var MenuitemTypeDropdown = context.MenuItemTypes.Where(c => c.Name == "Dropdown").FirstOrDefault(); var MenuitemTypeInput = context.MenuItemTypes.Where(c => c.Name == "Input").FirstOrDefault(); MenuItem entity = new MenuItem(); var Menus = new List<MenuItem>(); entity.Title = "Filter"; entity.MenuAction = "/Configure/Filter"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 10; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Columns"; entity.MenuAction = "/Configure/Columns"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 20; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Swimlanes"; entity.DisplayOrder = 21; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Configure/Swimlanes"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Quick Filters"; entity.MenuAction = "/Configure/Quick_Filters"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 30; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Card Colours"; entity.MenuAction = "/Configure/Card_Colours"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 40; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Estimation"; entity.MenuAction = "/Configure/Estimation"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 50; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Working Days"; entity.MenuAction = "/Configure/Working_Days"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 60; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Issue Detail View"; entity.MenuAction = "/Configure/Issue_Detail_View"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 70; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); //context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuManagerId }, Menus.ToArray()); context.SaveChanges(); }
private void CreateGadget(SJiraContext context) { var gadget = new List<Gadget> { new Gadget{ Name="Resolved Charts",Title="Line Chart Example",MenuAction="~/Views/Dashboard/Gadgets/Line_Chart.cshtml",DisplayOrder=5}, new Gadget{ Name="Pie Chat",Title="Pie Chart Example",MenuAction="~/Views/Dashboard/Gadgets/Pie_Chart.cshtml",DisplayOrder=1}, new Gadget{ Name="Filter Result",Title="Multiple Axes Line Chart Example ",MenuAction="~/Views/Dashboard/Gadgets/Multiple_Line_Chart.cshtml",DisplayOrder=2}, new Gadget{ Name="Road Map",Title="Bar Chart Example ",MenuAction="~/Views/Dashboard/Gadgets/Bar_Chart.cshtml",DisplayOrder=4}, new Gadget{ Name="Two Dimentional Filter Statistics",Title="Moving Line Chart Example",MenuAction="~/Views/Dashboard/Gadgets/Moving_Line_Chart.cshtml",DisplayOrder=3}, }; context.Gadgets.AddOrUpdate(c => c.Name, gadget.ToArray()); context.SaveChanges(); }
private void CreateIssue(SJiraContext context) { //var user1 = context.Users.Where(c => c.UserName == "XT19141").FirstOrDefault(); //var user2 = context.Users.Where(c => c.UserName == "xt17640").FirstOrDefault(); var project1 = context.Projects.Where(c => c.Code == "PDB").FirstOrDefault(); var project2 = context.Projects.Where(c => c.Code == "PIP").FirstOrDefault(); var IssueResolution1 = context.IssueResolutions.Where(c => c.Name == "Unresolved").FirstOrDefault(); var IssueResolution2 = context.IssueResolutions.Where(c => c.Name == "Incomplete").FirstOrDefault(); var IssueProprity1 = context.IssuePriorities.Where(c => c.Name == "Blocker").FirstOrDefault(); var IssueProprity2 = context.IssuePriorities.Where(c => c.Name == "High").FirstOrDefault(); var IssueType1 = context.IssueTypes.Where(c => c.Name == "Epic").FirstOrDefault(); var IssueType2 = context.IssueTypes.Where(c => c.Name == "Story").FirstOrDefault(); //var status1 = context.Status.Where(c => c.Name == "1-New").FirstOrDefault(); //var status2 = context.Status.Where(c => c.Name == "2-On Hold").FirstOrDefault(); try { var issues = new List<Issue> { new Issue //(Guid.NewGuid()) { IssueId=Guid.NewGuid(), Code = "PSC-2152", Summary = "Export/Import Datastage", Description = "Export/Import Datastage", //DateOfBirth = new DateTime(2008, 1, 28), IssueTypeId=IssueType1.IssueTypeId, IssuePriorityId=IssueProprity1.IssuePriorityId, IssueResolutionId=IssueResolution1.IssueResolutionId, CreatedDate=DateTime.Now, // CompleteIssue = new CompleteIssue(){ Votes=1, Watches=1, // StatusId = status1.Id, TimeOriginalIstimate=5000, ProjectId=project1.ProjectId //} }, new Issue //(Guid.NewGuid()) { IssueId=Guid.NewGuid(), Code = "PSC-2153", Summary = "Prepare data for initial load", Description = "Prepare data for initial load", //DateOfBirth = new DateTime(1958, 1, 1), IssueTypeId=IssueType2.IssueTypeId, IssuePriorityId=IssueProprity2.IssuePriorityId, IssueResolutionId=IssueResolution2.IssueResolutionId, CreatedDate=DateTime.Now, // CompleteIssue = new CompleteIssue(){ Votes=1, Watches=1, // StatusId = status2.Id, ProjectId=project2.ProjectId, TimeOriginalIstimate=6000 //} } }; context.Issues.AddOrUpdate( c => new { c.Code }, issues.ToArray()); context.SaveChanges(); //context.SaveChanges(); } catch (Exception eCreateIssue) { throw eCreateIssue; } }
private void CreateSprint(SJiraContext context) { //DateTimeRange DateRange1 = new DateTimeRange(DateTime.Now.AddDays(-100), DateTime.Now.AddDays(-50)); //DateTimeRange DateRange2 = new DateTimeRange(DateTime.Now.AddDays(-49), DateTime.Now.AddDays(-1)); var user = new List<Sprint> { new Sprint{ Name="Sp1",DateRange_Start=DateTime.Now.AddDays(-100) ,DateRange_End=DateTime.Now.AddDays(-50)}, new Sprint{ Name="Sp2",DateRange_Start=DateTime.Now.AddDays(-49),DateRange_End=DateTime.Now.AddDays(-1)}, }; context.Sprints.AddOrUpdate(c => new { c.Name }, user.ToArray()); context.SaveChanges(); }
private void CreateStatus(SJiraContext context) { var status = new List<Status> { new Status{ Name="1-New"}, new Status{ Name="2-On Hold"}, new Status{ Name="Backlog"}, new Status{ Name="Selected for Development"}, new Status{ Name="In Refinement"}, new Status{ Name="In Development"}, new Status{ Name="Awaiting Review"}, new Status{ Name="In Review"}, new Status{ Name="Awaiting Deployment"}, new Status{ Name="Ready for Release"}, new Status{ Name="Closed"}, new Status{ Name="Ready for UIT"}, new Status{ Name="Ready for UAT"}, new Status{ Name="Design"}, new Status{ Name="Technical Mapping"}, new Status{ Name="Development"}, new Status{ Name="Validation"}, new Status{ Name="Ready for Design Signoff"}, new Status{ Name="In Progress 25%"}, new Status{ Name="In Progress 50%"}, new Status{ Name="In Progress 75%"}, new Status{ Name="Technical UIT"}, new Status{ Name="Business UIT"}, new Status{ Name="UAT"}, new Status{ Name="Client Info Required"}, new Status{ Name="More Info Required"}, new Status{ Name="In Progress"}, new Status{ Name="On Hold"}, new Status{ Name="DEV"}, new Status{ Name="STG"}, new Status{ Name="PRD"}, new Status{ Name="Reopened"} }; context.Status.AddOrUpdate(c => c.Name, status.ToArray()); context.SaveChanges(); }
private void CreateProjectType(SJiraContext context) { var projectType = new List<ProjectType> { new ProjectType{ Name="Simple Issue Tracking",Description="Simple Issue Trackings" }, new ProjectType{ Name="Project Mangement",Description="Project Mangement"}, new ProjectType{ Name="Agile Kanban",Description="Agile Kanban"}, new ProjectType{ Name="JIRA Classic",Description="JIRA Classic" }, new ProjectType{ Name="Software Development",Description="Software Development"}, new ProjectType{ Name="Agile Scrum",Description="Agile Scrum"}, new ProjectType{ Name="Demo Projet",Description="Demo Projet"}, }; context.ProjectTypes.AddOrUpdate(c => c.Name, projectType.ToArray()); context.SaveChanges(); }
private void CreateSharedWith(SJiraContext context) { var sharedWith = new List<SharedWith> { new SharedWith{ Name="Private Dashboard"}, new SharedWith{ Name="Shared with all users"}, }; context.SharedWiths.AddOrUpdate(c => c.Name, sharedWith.ToArray()); context.SaveChanges(); }
private void CreateProjectCategory(SJiraContext context) { var projectCategory = new List<ProjectCategory> { new ProjectCategory{ Name="Internal",Description="Internal projects" }, new ProjectCategory{ Name="External",Description="External projects"}, new ProjectCategory{ Name="Enhancement",Description="Enhancement projects"}, }; try { context.ProjectCategories.AddOrUpdate(c => c.Name, projectCategory.ToArray()); context.SaveChanges(); } catch (Exception eProjectCategory) { throw eProjectCategory; } }
private void CreateProject(SJiraContext context) { var projectCategory1 = context.ProjectCategories.Where(c => c.Name == "Internal").FirstOrDefault(); var user1 = context.Users.Where(c => c.UserName == "XT19141").FirstOrDefault(); var project = new List<Project> { new Project{ Name="People Dashboard", //Description="<script>alert('xss');</script>", Code="PDB", //ProjectId=Guid.NewGuid(), ProjectCategoryId=projectCategory1.ProjectCategoryId, LeadId=user1.Id}, new Project{ Name="Pipeline", //Description="<script>alert('xss');</script>", Code="PIP", //ProjectId=Guid.NewGuid(), ProjectCategoryId=projectCategory1.ProjectCategoryId, LeadId=user1.Id}, }; context.Projects.AddOrUpdate(c => new { c.Code }, project.ToArray()); context.SaveChanges(); }
private void CreateMenuItemType(SJiraContext context) { var menuItemType = new List<MenuItemType> { new MenuItemType{ Name="button"}, new MenuItemType{ Name="Link", }, new MenuItemType{ Name="Dropdown"}, new MenuItemType{ Name="input"}, }; context.MenuItemTypes.AddOrUpdate(c => c.Name, menuItemType.ToArray()); context.SaveChanges(); }
private void CreateDashboardType(SJiraContext context) { var dashboardType = new List<DashboardType> { new DashboardType{ Name="One",Code="12",Layout="~/Views/Dashboard/Gadgets/One.cshtml"}, new DashboardType{ Name="Two",Code="66",Layout="~/Views/Dashboard/Gadgets/Two.cshtml"}, new DashboardType{ Name="Three",Code="444",Layout="~/Views/Dashboard/Gadgets/Three.cshtml"}, new DashboardType{ Name="Four",Code="6666",Layout="~/Views/Dashboard/Gadgets/Four.cshtml"}, new DashboardType{ Name="One Left",Code="39",Layout="~/Views/Dashboard/Gadgets/OneLeft.cshtml"}, new DashboardType{ Name="One Right",Code="93",Layout="~/Views/Dashboard/Gadgets/OneRight.cshtml"}, }; context.DashboardTypes.AddOrUpdate(c => c.Code, dashboardType.ToArray()); context.SaveChanges(); }
private void CreateUser(SJiraContext context) { var user = new List<ApplicationUser> { new ApplicationUser{UserName="******" //,LastName="Aissat",FirstName="Mohamed",,ContractType=ContractType.Consultant }, new ApplicationUser{UserName="******" //,LastName="Aissat",FirstName="Mohamed",,ContractType=ContractType.Consultant }, new ApplicationUser{ UserName="******" //,LastName="Paul",FirstName="Jerome",ContractType=ContractType.Consultant }, new ApplicationUser{UserName="******" //,LastName="Lemaitre",FirstName="Nathalie",",ContractType=ContractType.Consultant }, new ApplicationUser{ UserName="******", //LastName="Gagne",FirstName="Ghislain ",,ContractType=ContractType.Consultant }, new ApplicationUser{ UserName="******", //LastName="Girgis",FirstName="Mark ",,ContractType=ContractType.Consultant }, }; context.Users.AddOrUpdate(c => new { c.UserName }, user.ToArray()); context.SaveChanges(); }
private void CreateDashboardUser(SJiraContext context) { var dashboardUser = new List<DashboardUser>(); foreach (Dashboard dashboard in context.Dashboards) { if (dashboard.SharedWith.Name == "Private Dashboard") { dashboardUser.Add(new DashboardUser { UserId = dashboard.OwnerId, DashboardId = dashboard.DashboardId }); } if (dashboard.SharedWith.Name == "Shared with all users") { foreach (ApplicationUser user in context.Users) { //if (dashboard.OwnerId != user.UserId) //{ dashboardUser.Add(new DashboardUser { UserId = user.Id, DashboardId = dashboard.DashboardId }); //} } } } context.DashboardUsers.AddOrUpdate(c => new { c.UserId, c.DashboardId }, dashboardUser.ToArray()); context.SaveChanges(); }
private void CreateWork(SJiraContext context) { var issue1 = context.Issues.Where(c => c.Code == "PSC-2152").FirstOrDefault(); var issue2 = context.Issues.Where(c => c.Code == "PSC-2153").FirstOrDefault(); var status1 = context.Status.Where(c => c.Name == "1-New").FirstOrDefault(); var status2 = context.Status.Where(c => c.Name == "2-On Hold").FirstOrDefault(); var project1 = context.Projects.Where(c => c.Code == "PDB").FirstOrDefault(); var project2 = context.Projects.Where(c => c.Code == "PIP").FirstOrDefault(); var user1 = context.Users.Where(c => c.UserName == "XT19141").FirstOrDefault(); var user2 = context.Users.Where(c => c.UserName == "xt17640").FirstOrDefault(); var sprint1 = context.Sprints.Where(c => c.Name == "Sp1").FirstOrDefault(); var sprint2 = context.Sprints.Where(c => c.Name == "Sp2").FirstOrDefault(); var works = new List<Work> { new Work() { Title= "work1", WorkTypeId = 1, IssueId = issue1.IssueId, StatusId = status1.StatusId, StartDate=DateTime.Now.AddDays(-5), TimeWorked=4, WorkId=Guid.NewGuid(), AssigneeId=user1.Id, SprintId=sprint1.SprintId }, new Work() {Title= "work2", WorkTypeId = 1, IssueId = issue2.IssueId, StatusId = status2.StatusId, StartDate=DateTime.Now.AddDays(-3), TimeWorked=3, WorkId=Guid.NewGuid(), AssigneeId=user1.Id, SprintId=sprint1.SprintId } }; context.Works.AddOrUpdate(c => new { c.Title }, works.ToArray()); context.SaveChanges(); //DateTimeRange DateRange1 = new DateTimeRange(DateTime.Now.AddDays(-5), DateTime.Now.AddDays(-4)); //DateTimeRange DateRange2 = new DateTimeRange(DateTime.Now.AddDays(-3), DateTime.Now.AddDays(-1)); //context.Works.Add(new Work(Guid.NewGuid()) //{ // WorkType = WorkType.BackLog, // IssueId = issue1.IssueId, // StatusId = status1.Id, // DateRange = DateRange1, // //TimeRange_Start = DateTime.Now.AddDays(-5), // //TimeRange_End = DateTime.Now.AddDays(-4), // //WorkId=Guid.NewGuid(), // ProjectId = project1.Id, // UserId = user1.Id, // SprintId = sprint1.Id //}); //context.Works.Add(new Work(Guid.NewGuid()) //{ // WorkType = WorkType.BackLog, // IssueId = issue2.IssueId, // StatusId = status2.Id, // DateRange = DateRange2, // //TimeRange_Start = DateTime.Now.AddDays(-3), // //TimeRange_End = DateTime.Now.AddDays(-1), // //WorkId = Guid.NewGuid(), // ProjectId = project2.Id, // UserId = user1.Id, // SprintId = sprint1.Id //}); }
private void CreateGadgetType(SJiraContext context) { var gadgetType = new List<GadgetType> { new GadgetType{ Name="Bambo"}, new GadgetType{ Name="Charts"}, new GadgetType{ Name="Clover"}, new GadgetType{ Name="JIRA"}, new GadgetType{ Name="Other"}, new GadgetType{ Name="Walboard"}, }; context.GadgetTypes.AddOrUpdate(c => c.Name, gadgetType.ToArray()); context.SaveChanges(); }
private void CreateWorkType(SJiraContext context) { var workType = new List<WorkType> { new WorkType{ Name="Spint Change"}, new WorkType{ Name="User Change"}, new WorkType{ Name="Status Change"}, new WorkType{ Name="Log Work"}, }; context.WorkTypes.AddOrUpdate(c => c.Name, workType.ToArray()); context.SaveChanges(); }
//private void CreateMenumanagerType(SJiraContext context) //{ // var menuManagerType = new List<MenuManagerType> //{ // new MenuManagerType{ Name="ToolBar"}, // new MenuManagerType{ Name="SideBar", }, // new MenuManagerType{ Name="Main"}, // new MenuManagerType{ Name="Secondary"}, // new MenuManagerType{ Name="Tabs"}, //}; // context.MenuManagerTypes.AddOrUpdate(c => c.Name, menuManagerType.ToArray()); context.SaveChanges(); //} private void CreateIssuePriority(SJiraContext context) { var IssuePriorities = new List<IssuePriority> { new IssuePriority{ Name="Blocker"}, new IssuePriority{ Name="High"}, new IssuePriority{ Name="Med"}, new IssuePriority{ Name="Low"}, new IssuePriority{ Name="Critical"}, new IssuePriority{ Name="Major"}, new IssuePriority{ Name="Minor"}, new IssuePriority{ Name="Trivial"}, new IssuePriority{ Name="3-Medium"}, new IssuePriority{ Name="2-High"}, new IssuePriority{ Name="4-Low"}, new IssuePriority{ Name="1-Critical"} }; context.IssuePriorities.AddOrUpdate(c => c.Name, IssuePriorities.ToArray()); context.SaveChanges(); }
private void CreateDashboard(SJiraContext context) { var DashboardFour = context.DashboardTypes.Where(c => c.Name == "Four").FirstOrDefault(); var DashboardOne = context.DashboardTypes.Where(c => c.Name == "One").FirstOrDefault(); var DashboardOneLeft = context.DashboardTypes.Where(c => c.Name == "One Left").FirstOrDefault(); var DashboardSharedWithAll = context.SharedWiths.Where(c => c.Name == "Shared with all users").FirstOrDefault(); var DashboardPrivateDashboard = context.SharedWiths.Where(c => c.Name == "Private Dashboard").FirstOrDefault(); var user1 = context.Users.Where(c => c.UserName == "XT19141").FirstOrDefault(); var Dasboards = new List<Dashboard>(); Dashboard entity = new Dashboard(); entity.Name = "System Dashboard"; entity.SharedWithId = DashboardSharedWithAll.SharedWithId; entity.Description = "PDB"; entity.DashboardTypeId = DashboardOne.DashboardTypeId; entity.OwnerId = user1.Id; Dasboards.Add(entity); entity = new Dashboard(); entity.Name = "JIRA Junior Dasboard"; entity.SharedWithId = DashboardSharedWithAll.SharedWithId; entity.Description = "PIP"; entity.DashboardTypeId = DashboardOneLeft.DashboardTypeId; entity.OwnerId = user1.Id; Dasboards.Add(entity); var user2 = context.Users.Where(c => c.UserName == "xt17640").FirstOrDefault(); entity = new Dashboard(); entity.Name = "The Quirky IRKD Dashboard"; entity.SharedWithId = DashboardPrivateDashboard.SharedWithId; entity.Description = "PIP"; entity.DashboardTypeId = DashboardFour.DashboardTypeId; entity.OwnerId = user2.Id; Dasboards.Add(entity); var user3 = context.Users.Where(c => c.UserName == "XT10596").FirstOrDefault(); entity = new Dashboard(); entity.Name = "IRKD Dashboard"; entity.SharedWithId = DashboardSharedWithAll.SharedWithId; entity.Description = "PIP"; entity.DashboardTypeId = DashboardFour.DashboardTypeId; entity.OwnerId = user3.Id; Dasboards.Add(entity); entity = new Dashboard(); entity.Name = "Agile Dashboard"; entity.SharedWithId = DashboardSharedWithAll.SharedWithId; entity.Description = "PIP"; entity.DashboardTypeId = DashboardFour.DashboardTypeId; entity.OwnerId = user3.Id; Dasboards.Add(entity); entity = new Dashboard(); entity.Name = "Realtime Activity Dashboard"; entity.SharedWithId = DashboardSharedWithAll.SharedWithId; entity.Description = "PIP"; entity.DashboardTypeId = DashboardFour.DashboardTypeId; entity.OwnerId = user3.Id; Dasboards.Add(entity); // var Dashboard = new List<Dashboard> //{ // new Dashboard{ Name="Sytem Dashboard", // SharedWithId=DashboardSharedWiths.SharedWithId, // Description="PDB", // DashboardTypeId=DashboardFour.DashboardTypeId, // OwnerId=user1.UserId}, // new Dashboard{ Name="JIRA Junior Dasboard", // SharedWithId=DashboardSharedWiths.SharedWithId, // Description="PIP", // DashboardTypeId=DashboardFour.DashboardTypeId, // OwnerId=user1.UserId}, //}; context.Dashboards.AddOrUpdate(c => new { c.Name }, Dasboards.ToArray()); context.SaveChanges(); }
private void CreateIssueType(SJiraContext context) { try { var issueTypes = new List<IssueType> { new IssueType{ Name="Bug", Description="Software Developpement ", Sequence=5}, new IssueType{ Name="template"}, new IssueType{ Name="SRS_Issue"}, new IssueType{ Name="In Development"}, new IssueType{ Name="DataCity"}, new IssueType{ Name="SL-Action"}, new IssueType{ Name="Theme"}, new IssueType{ Name="Task (general)"}, new IssueType{ Name="Technical Task"}, new IssueType{ Name="New Feature",Description="Software Developpement ", Sequence=4}, new IssueType{ Name="Question"}, new IssueType{ Name="Task", Description="Software Developpement ", Sequence=2}, new IssueType{ Name="Improvement"}, new IssueType{ Name="Sub Task",Description="Software Developpement ", Sequence=3}, new IssueType{ Name="Epic"}, new IssueType{ Name="Story", Description="Software Developpement ", Sequence=1}, new IssueType{ Name="Technical Debt"} }; context.IssueTypes.AddOrUpdate(c => c.Name, issueTypes.ToArray()); context.SaveChanges(); //issueTypes.ForEach(b => context.IssueTypes.Add(b)); } catch (Exception eCreateIssueType) { throw eCreateIssueType; } }
public SeedData(SJiraContext context) { _context = context; }
//private void CreateMenuManagers_Home(SJiraContext context) //{ // var Menus = new List<MenuManager>(); // //var MenuManagerTypeSideBar = context.MenuManagerTypes.Where(c => c.Name == "SideBar").FirstOrDefault(); // //var MenuManagerTypeToolBar = context.MenuManagerTypes.Where(c => c.Name == "ToolBar").FirstOrDefault(); // var MenuManagerTypeMain = context.MenuManagerTypes.Where(c => c.Name == "Main").FirstOrDefault(); // var MenuManagerTypeSecondary = context.MenuManagerTypes.Where(c => c.Name == "Secondary").FirstOrDefault(); // MenuManager entity = new MenuManager(); // //entity.MenuItemId = null; // entity.Title = "Home Main"; // entity.MenuManagerTypeId = MenuManagerTypeMain.MenuManagerTypeId; // Menus.Add(entity); // entity = new MenuManager(); // //entity.MenuItemId = null; // entity.Title = "Home SideBar"; // entity.MenuManagerTypeId = MenuManagerTypeSecondary.MenuManagerTypeId; // Menus.Add(entity); // context.MenuManagers.AddOrUpdate(c => new { c.Title, c.MenuManagerTypeId }, Menus.ToArray()); context.SaveChanges(); //} private void CreateMenuItems_Home_Main(SJiraContext context) { try { var MenuitemTypeButton = context.MenuItemTypes.Where(c => c.Name == "Button").FirstOrDefault(); var MenuitemTypeLink = context.MenuItemTypes.Where(c => c.Name == "Link").FirstOrDefault(); var MenuitemTypeDropdown = context.MenuItemTypes.Where(c => c.Name == "Dropdown").FirstOrDefault(); var MenuitemTypeInput = context.MenuItemTypes.Where(c => c.Name == "Input").FirstOrDefault(); //var MenuManager1 = context.MenuManagers.Where(c => c.Title == "Home Main" && c.MenuManagerType.Name == "Main").FirstOrDefault(); var Menus = new List<MenuItem>(); MenuItem entity = new MenuItem(); entity.Title = "Main"; entity.DisplayOrder = 10; entity.MenuAction = "#"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "SideBar"; entity.DisplayOrder = 10; entity.MenuAction = "#"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "ToolBar"; entity.DisplayOrder = 10; entity.MenuAction = "#"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuManagerId }, Menus.ToArray()); context.SaveChanges(); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); // Submenu for MenuItemId=2 var MenuMain = context.MenuItems.Where(m => m.Title == "Main").FirstOrDefault(); //entity.ParentId = MenuMain.MenuItemId; //entity.Title = "Home"; //entity.DisplayOrder = 10; //entity.MenuAction = "/Dashboards/SystemDashboard"; ////entity.MenuManagerId = MenuManager1.MenuManagerId; //entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuMain.MenuItemId; entity.Title = "Dashboards"; entity.MenuAction = "/Dashboard/Dashboard"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 20; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuMain.MenuItemId; entity.Title = "Projects"; entity.MenuAction = "/Project/Projects"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 30; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuMain.MenuItemId; entity.Title = "Issues"; entity.MenuAction = "/Issue/Issues"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 30; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuMain.MenuItemId; entity.Title = "Agile"; entity.MenuAction = "/Agile/Agile"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 40; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuManagerId }, Menus.ToArray()); context.SaveChanges(); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); // Submenu for MenuItemId=2 //-------------------------------------------------------------------------- Menus = new List<MenuItem>(); // Submenu for MenuItemId=2 var Parent = context.MenuItems.Where(m => m.Title == "Dashboards").FirstOrDefault(); //-------------------------------------------------------------------------- //entity = new MenuItem(); //entity.ParentId = Parent.MenuItemId; //entity.Title = "Separated link"; //entity.DisplayOrder = 90; ////entity.MenuManagerId = MenuManager1.MenuManagerId; //entity.MenuAction = "/Manage/Favorites"; //entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //entity = new MenuItem(); entity.ParentId = Parent.MenuItemId; entity.Title = "Manage Dashboards"; entity.DisplayOrder = 100; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Manage/Favorites"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); var MenuItemManageDashboards = context.MenuItems.Where(m => m.Title == "Manage Dashboards").FirstOrDefault(); entity = new MenuItem(); entity.ParentId = MenuItemManageDashboards.MenuItemId; entity.Title = "Favorites"; entity.DisplayOrder = 10; entity.MenuAction = "/Manage/Favorites"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItemManageDashboards.MenuItemId; entity.Title = "My"; entity.DisplayOrder = 20; entity.MenuAction = "/Manage/My"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItemManageDashboards.MenuItemId; entity.Title = "Popular"; entity.DisplayOrder = 30; entity.MenuAction = "/Manage/Popular"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItemManageDashboards.MenuItemId; entity.Title = "Search"; entity.DisplayOrder = 40; entity.MenuAction = "/Dashboard/Search"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); // Submenus for MenuItemId=3 var MenuItem3 = context.MenuItems.Where(m => m.Title == "Projects").FirstOrDefault(); //Current Project entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Current Project"; entity.DisplayOrder = 1; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "#"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "My Scrum Project (MSP)"; entity.DisplayOrder = 10; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/My_Scrum_Project_(MSP)"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 11; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/My_Scrum_Project_(MSP)"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //-------------------------------------------------------------------------- //Recent Projects entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Recent Projects"; entity.DisplayOrder = 12; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "#"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "IRKD (IRKD)"; entity.DisplayOrder = 20; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/IRKD_(IRKD)"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Pomodoro Web Client (PWC)"; entity.DisplayOrder = 20; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/Pomodoro_Web_Client_(PWC)"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 21; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/Pomodoro_Web_Client_(PWC)"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //-------------------------------------------------------------------------- entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "View All Projects"; entity.DisplayOrder = 30; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/Index"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //-------------------------------------------------------------------------- entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 31; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/Index"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Import External Project"; entity.DisplayOrder = 40; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/Import_External_Project"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Create Project"; entity.DisplayOrder = 50; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Project/Create"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); // Submenus for MenuItemId=4 var MenuItem4 = context.MenuItems.Where(m => m.Title == "Issues").FirstOrDefault(); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Current Filter"; entity.DisplayOrder = 1; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "#"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "IRKD Planning (30 Issues)"; entity.DisplayOrder = 10; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/IRKD_Planning_(30 Issues)"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //---------------------------------------------------------------------------------- entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 11; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/IRKD_Planning_(30 Issues)"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Search for Issues"; entity.DisplayOrder = 20; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/Search_for_Issues"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Create Issue"; entity.DisplayOrder = 30; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/Create"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //-------------------------------------------------------------------------- Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 31; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/Create"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); //Recent Issues entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Recent Issues "; entity.DisplayOrder = 32; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "#"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "IRKD-5 As a user, I would like"; entity.DisplayOrder = 40; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/IRKD-5_As_a_user_I_would_like"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 41; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/IRKD-5_As_a_user_I_would_like"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //-------------------------------------------------------------------------- //Filters entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Filters"; entity.DisplayOrder = 42; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "#"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "My Open Issues"; entity.DisplayOrder = 50; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/My_Open_Issues"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Reported by Me"; entity.DisplayOrder = 60; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/Reported_by_Me"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "2.0 Tirage"; entity.DisplayOrder = 70; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/2.0_Tirage"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "High priority work"; entity.DisplayOrder = 80; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/High_priority_work"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "IRKD Planning"; entity.DisplayOrder = 90; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/IRKD_Planning"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Recent Created Bug"; entity.DisplayOrder = 100; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/Recent_Created_Bugss"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); //---------------------------------------------------------------------- entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 101; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/Recent_Created_Bugss"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Manger Filters"; entity.DisplayOrder = 110; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/Manger_Filters"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); // Submenus for MenuItemId=5 var MenuItem5 = context.MenuItems.Where(m => m.Title == "Agile").FirstOrDefault(); //Recent Boards entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "Recent Boards"; entity.DisplayOrder = 1; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "#"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "My Scrum Project"; entity.DisplayOrder = 10; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/My_Scrum_Project"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "IRKD"; entity.DisplayOrder = 20; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/IRKD"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "IRKD Planning"; entity.DisplayOrder = 30; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/IRKD_Planning"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "2.0 Triage"; entity.DisplayOrder = 40; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/2.0_Triage"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "more..."; entity.DisplayOrder = 50; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/more"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 51; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/more"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); //-------------------------------------------------------------------------- entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "Mange Boards"; entity.DisplayOrder = 60; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/Mange_Boards"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "Getting Started"; entity.DisplayOrder = 70; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/Getting_Started"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "Separated link"; entity.DisplayOrder = 80; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/Getting_Started"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //-------------------------------------------------------------------------- entity = new MenuItem(); entity.ParentId = MenuItem5.MenuItemId; entity.Title = "Classic..."; entity.DisplayOrder = 90; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Agile/Classic"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); } catch (Exception eCreateMenuItem) { throw eCreateMenuItem; } }
private void CreateDashboardGadget(SJiraContext context) { var DashboardGadget = new List<DashboardGadget> { new DashboardGadget{ GadgetId=1,DashboardId=1,Sequence=1}, new DashboardGadget{ GadgetId=1,DashboardId=2,Sequence=1}, new DashboardGadget{ GadgetId=2,DashboardId=2,Sequence=2}, new DashboardGadget{ GadgetId=3,DashboardId=1,Sequence=2}, new DashboardGadget{ GadgetId=3,DashboardId=3,Sequence=2}, new DashboardGadget{ GadgetId=4,DashboardId=2,Sequence=2}, new DashboardGadget{ GadgetId=5,DashboardId=3,Sequence=1}, }; context.DashboardGadgets.AddOrUpdate(c => new { c.GadgetId, c.DashboardId }, DashboardGadget.ToArray()); context.SaveChanges(); }
private void CreateChild(SJiraContext context) { //var MenuManager1 = context.MenuManagers.Where(c => c.Title == "Principal").FirstOrDefault(); MenuItem entity = new MenuItem(); var Menus = new List<MenuItem>(); entity.Title = "Home"; entity.DisplayOrder = 10; entity.MenuAction = "/Home/Home"; //entity.MenuManagerId = MenuManager1.MenuManagerId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Maintenance"; entity.MenuAction = "/Maintenance/Maintenance"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 20; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Reports"; entity.MenuAction = "/Reports/Reports"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 30; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Lookup"; entity.MenuAction = "/Lookup/Lookup"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 30; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title }, Menus.ToArray()); context.SaveChanges(); Menus = new List<MenuItem>(); // Submenu for MenuItemId=2 var Parent = context.MenuItems.Where(m => m.Title == "Maintenance").FirstOrDefault(); entity = new MenuItem(); entity.ParentId = Parent.MenuItemId; entity.Title = "Users"; entity.DisplayOrder = 10; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Maintenance/Users"; Menus.Add(entity); //Menus.Find(m => m.Title == "Maintenance").Menus.Add(entity); entity = new MenuItem(); entity.ParentId = Parent.MenuItemId; entity.Title = "Roles"; entity.DisplayOrder = 20; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Maintenance/Roles"; //Menus.Find(m => m.Title == "Maintenance").Menus.Add(entity); Menus.Add(entity); // Submenus for MenuItemId=3 var MenuItem3 = context.MenuItems.Where(m => m.Title == "Reports").FirstOrDefault(); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Report 1"; entity.DisplayOrder = 10; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Reports/Report1"; //Menus.Find(m => m.Title == "Reports").Menus.Add(entity); Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem3.MenuItemId; entity.Title = "Report 2"; entity.DisplayOrder = 20; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Reports/Report2"; //Menus.Find(m => m.Title == "Reports").Menus.Add(entity); Menus.Add(entity); // Submenus for MenuItemId=4 var MenuItem4 = context.MenuItems.Where(m => m.Title == "Lookup").FirstOrDefault(); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Logs"; entity.DisplayOrder = 10; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Lookup/Logs"; //Menus.Find(m => m.Title == "Lookup").Menus.Add(entity); Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Resources"; entity.DisplayOrder = 20; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Lookup/Resources"; //Menus.Find(m => m.Title == "Lookup").Menus.Add(entity); Menus.Add(entity); entity = new MenuItem(); entity.ParentId = MenuItem4.MenuItemId; entity.Title = "Lookup Tables"; entity.DisplayOrder = 30; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Lookup/LookupTables"; //Menus.Find(m => m.Title == "Lookup").Menus.Add(entity); Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title }, Menus.ToArray()); context.SaveChanges(); }
private void CreateDashboardMenuItems(SJiraContext context) { var MenuitemTypeButton = context.MenuItemTypes.Where(c => c.Name == "Button").FirstOrDefault(); var MenuitemTypeLink = context.MenuItemTypes.Where(c => c.Name == "Link").FirstOrDefault(); var MenuitemTypeDropdown = context.MenuItemTypes.Where(c => c.Name == "Dropdown").FirstOrDefault(); var MenuitemTypeInput = context.MenuItemTypes.Where(c => c.Name == "Input").FirstOrDefault(); var Menus = new List<MenuItem>(); MenuItem entity = new MenuItem(); entity.Title = "Add Gadget"; entity.MenuAction = "/Dashboard/Search"; entity.DisplayOrder = 10; entity.MenuIcon = @"<i class=""fa fa-plus""></i>"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Edit Layout"; entity.MenuAction = "/Dashboard/Search"; entity.DisplayOrder = 10; entity.MenuIcon = @"<i class=""fa fa-pencil""></i>"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Tools"; entity.MenuAction = "/Dashboard/Search"; entity.DisplayOrder = 10; entity.MenuIcon = @"<i class=""fa a-gear fa-cog""></i>"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //80 NULL Add Gadget 10 /Dashboard/Search <i class="fa fa-plus"></i> NULL //81 NULL Edit Layout 20 /Dashboard/Search <i class="fa fa-pencil"></i> NULL //82 NULL Tools 30 /Dashboard/Search <i class="fa a-gear fa-cog"></i> NULL context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); var MenuitemTools = context.MenuItems.Where(c => c.Title == "Tools" && c.MenuAction == "/Dashboard/Search").FirstOrDefault(); var MenuitemEditLayout = context.MenuItems.Where(c => c.Title == "Edit Layout" && c.MenuAction == "/Dashboard/Search").FirstOrDefault(); var MenuitemAddGadget = context.MenuItems.Where(c => c.Title == "Add Gadget" && c.MenuAction == "/Dashboard/Search").FirstOrDefault(); //var DashboardSystemDashboard = context.Dashboards.Where(c => c.Name == "System Dashboard").FirstOrDefault(); //var DashboardJIRAJuniorDasboard = context.Dashboards.Where(c => c.Name == "JIRA Junior Dasboard").FirstOrDefault(); //var DashboardTheQuirkyIRKDDashboard = context.Dashboards.Where(c => c.Name == "The Quirky IRKD Dashboard").FirstOrDefault(); var Menus1 = new List<DashboardMenuItem>(); foreach (Dashboard dashboard in context.Dashboards) { if (dashboard.DashboardType.Name != "One") { DashboardMenuItem entity1 = new DashboardMenuItem(); entity1.MenuItemId = MenuitemAddGadget.MenuItemId; entity1.DashboardId = dashboard.DashboardId; entity1.DisplayOrder = 10; Menus1.Add(entity1); entity1 = new DashboardMenuItem(); entity1.MenuItemId = MenuitemEditLayout.MenuItemId; entity1.DashboardId = dashboard.DashboardId; entity1.DisplayOrder = 20; Menus1.Add(entity1); entity1 = new DashboardMenuItem(); entity1.MenuItemId = MenuitemTools.MenuItemId; entity1.DashboardId = dashboard.DashboardId; entity1.DisplayOrder = 30; Menus1.Add(entity1); } else if (dashboard.DashboardType.Name == "One") { DashboardMenuItem entity1 = new DashboardMenuItem(); entity1.MenuItemId = MenuitemTools.MenuItemId; entity1.DashboardId = dashboard.DashboardId; entity1.DisplayOrder = 10; Menus1.Add(entity1); } } context.DashboardMenuItems.AddOrUpdate(c => new { c.MenuItemId, c.DashboardId }, Menus1.ToArray()); context.SaveChanges(); //DashboardMenuItem entity1 = new DashboardMenuItem(); //entity1.MenuItemId = MenuitemTools.MenuItemId; //entity1.DashboardId = DashboardSystemDashboard.DashboardId; //entity1.DisplayOrder = 10; //Menus1.Add(entity1); //entity1 = new DashboardMenuItem(); //entity1.MenuItemId = MenuitemEditLayout.MenuItemId; //entity1.DashboardId = DashboardJIRAJuniorDasboard.DashboardId; //entity1.DisplayOrder = 10; //Menus1.Add(entity1); //entity1 = new DashboardMenuItem(); //entity1.MenuItemId = MenuitemAddGadget.MenuItemId; //entity1.DashboardId = DashboardJIRAJuniorDasboard.DashboardId; //entity1.DisplayOrder = 20; //Menus1.Add(entity1); //entity1 = new DashboardMenuItem(); //entity1.MenuItemId = MenuitemTools.MenuItemId; //entity1.DashboardId = DashboardJIRAJuniorDasboard.DashboardId; //entity1.DisplayOrder = 30; //Menus1.Add(entity1); //context.DashboardMenuItems.AddOrUpdate(c => new { c.MenuItemId, c.DashboardId }, Menus1.ToArray()); context.SaveChanges(); }
public CurrentUser(IIdentity identity, SJiraContext context) { _identity = identity; _context = context; }
//private void CreateMenuManagers_My_Open_Issues(SJiraContext context) //{ // var MenuItemMyOpenIssues= context.MenuItems.Where(c => c.Title == "My Open Issues").FirstOrDefault(); // var MenuManagerTypeSideBar = context.MenuManagerTypes.Where(c => c.Name == "SideBar").FirstOrDefault(); // var MenuManagerTypeToolBar = context.MenuManagerTypes.Where(c => c.Name == "ToolBar").FirstOrDefault(); // var Menus = new List<MenuManager>(); // MenuManager entity = new MenuManager(); // entity.MenuItemId = MenuItemMyOpenIssues.MenuItemId; // entity.Title = "My Open Issues"; // entity.MenuManagerTypeId = MenuManagerTypeSideBar.MenuManagerTypeId; // Menus.Add(entity); // entity = new MenuManager(); // entity.MenuItemId = MenuItemMyOpenIssues.MenuItemId; // entity.Title = "My Open Issues"; // entity.MenuManagerTypeId = MenuManagerTypeToolBar.MenuManagerTypeId; // Menus.Add(entity); // context.MenuManagers.AddOrUpdate(c => new { c.Title, c.MenuManagerTypeId }, Menus.ToArray()); context.SaveChanges(); //} private void CreateMenuItems_My_Open_Issues_SideBar(SJiraContext context) { //var MenuManager1 = context.MenuManagers.Where(c => c.Title == "My Open Issues" && c.MenuManagerType.Name == "SideBar").FirstOrDefault(); var MenuitemTypeButton = context.MenuItemTypes.Where(c => c.Name == "Button").FirstOrDefault(); var MenuitemTypeLink = context.MenuItemTypes.Where(c => c.Name == "Link").FirstOrDefault(); var MenuitemTypeDropdown = context.MenuItemTypes.Where(c => c.Name == "Dropdown").FirstOrDefault(); var MenuitemTypeInput = context.MenuItemTypes.Where(c => c.Name == "Input").FirstOrDefault(); MenuItem entity = new MenuItem(); var Menus = new List<MenuItem>(); entity.Title = "New Filter"; entity.MenuAction = "/Issue/New_Filter"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 10; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Find filters"; entity.MenuAction = "/Issue/Find_filters"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 20; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //------------------------------------------------------------------ //-------------------------------------------------------------------------- entity = new MenuItem(); entity.Title = "Separated link"; entity.DisplayOrder = 21; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/Find_filters"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "My Open Issues"; entity.MenuAction = "/Issue/My_Open_Issues"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 30; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Reported by Me"; entity.MenuAction = "/Issue/Reported_by_Me"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 40; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Recently Viewed"; entity.MenuAction = "/Issue/Recently_Viewed"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 50; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "All Issues"; entity.MenuAction = "/Issue/All_Issues"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 60; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); //--------------------------------------------------------------------------- entity = new MenuItem(); entity.Title = "Separated link"; entity.DisplayOrder = 61; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "/Issue/All_Issues"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "FAVORITE FILTERS"; entity.DisplayOrder = 62; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.MenuAction = "#"; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "2.0 Triage"; entity.MenuAction = "/Issue/2.0_Triage"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 70; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "High priority work"; entity.MenuAction = "/Issue/High_priority_work"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 80; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "IRDK Planning"; entity.MenuAction = "/Issue/IRDK_Planning"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 90; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); entity = new MenuItem(); entity.Title = "Recently Created Bugs"; entity.MenuAction = "/Issue/Recently_Created_Bugs"; //entity.MenuManagerId = MenuManager1.MenuManagerId; entity.DisplayOrder = 100; entity.MenuItemTypeId = MenuitemTypeLink.MenuItemTypeId; Menus.Add(entity); context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuAction }, Menus.ToArray()); context.SaveChanges(); //context.MenuItems.AddOrUpdate(c => new { c.Title, c.MenuManagerId }, Menus.ToArray()); context.SaveChanges(); }