示例#1
0
        public static void Initialize(WorktaskDbContext context)
        {
            context.Database.EnsureDeleted();
            context.Database.EnsureCreated();

            if (context.Worktasks.Any())
            {
                return;
            }

            var roles = new Role[]
            {
                new Role
                {
                    Name = "Оператор"
                },
                new Role
                {
                    Name = "Менеджер",
                },
                new Role
                {
                    Name = "Исполнитель",
                },
                new Role
                {
                    Name = "Администратор",
                },
            };

            context.Roles.AddRange(roles);
            context.SaveChanges();

            var employees = new Employee[]
            {
                new Employee {
                    FIO = "Петров Петр", RoleID = 1
                },
                new Employee {
                    FIO = "Иванов Иван", RoleID = 2
                },
                new Employee {
                    FIO = "Сергеев Сергей", RoleID = 3
                },
                new Employee {
                    FIO = "Дмитриев Дмитрий", RoleID = 4
                }
            };

            context.Employees.AddRange(employees);
            context.SaveChanges();

            var statuses = new Status[]
            {
                new Status {
                    ID = "New", Name = "Новая"
                },
                new Status {
                    ID = "Created", Name = "Черновик"
                },
                new Status {
                    ID = "Completed", Name = "Выполнено"
                },
                new Status {
                    ID = "Accepted", Name = "В обработке"
                },
                new Status {
                    ID = "Clarified", Name = "На согласовании"
                },
                new Status {
                    ID = "Declined", Name = "Отклонено"
                }
            };

            context.WorktaskStatuses.AddRange(statuses);
            context.SaveChanges();

            var routes = new StatusRoute[]
            {
                new StatusRoute {
                    FromStatusId = "Created", ToStatusId = "Accepted"
                },
                new StatusRoute {
                    FromStatusId = "Created", ToStatusId = "Declined", NeedComment = true
                },
                new StatusRoute {
                    FromStatusId = "Accepted", ToStatusId = "Completed"
                },
                new StatusRoute {
                    FromStatusId = "Accepted", ToStatusId = "Clarified", NeedComment = true
                },
            };

            context.StatusRoutes.AddRange(routes);
            context.SaveChanges();

            var tasks = new Worktask[]
            {
                new Worktask
                {
                    ID         = "1",
                    StatusId   = "Created",
                    Subject    = "test",
                    Text       = "test",
                    AuthorId   = 1,
                    EditorId   = 1,
                    CreateDate = DateTime.Now,
                    UpdateDate = DateTime.Now,
                },
                new Worktask
                {
                    ID         = "2",
                    StatusId   = "Completed",
                    Subject    = "test",
                    Text       = "test",
                    AuthorId   = 1,
                    EditorId   = 1,
                    CreateDate = DateTime.Now,
                    UpdateDate = DateTime.Now,
                },
                new Worktask
                {
                    ID         = "3",
                    StatusId   = "Accepted",
                    Subject    = "test",
                    Text       = "test",
                    AuthorId   = 1,
                    EditorId   = 1,
                    CreateDate = DateTime.Now,
                    UpdateDate = DateTime.Now,
                },
                new Worktask
                {
                    ID         = "4",
                    StatusId   = "Declined",
                    Subject    = "test",
                    Text       = "test",
                    AuthorId   = 1,
                    EditorId   = 1,
                    CreateDate = DateTime.Now,
                    UpdateDate = DateTime.Now,
                },
            };

            context.Worktasks.AddRange(tasks);
            context.SaveChanges();

            var accessTypes = new AccessType[]
            {
                new AccessType {
                    Name = "Create"
                },
                new AccessType {
                    Name = "Read"
                },
                new AccessType {
                    Name = "Edit"
                },
                new AccessType {
                    Name = "Delete"
                },
            };

            context.AccessTypes.AddRange(accessTypes);
            context.SaveChanges();

            var accesses = new StatusAccess[]
            {
                new StatusAccess
                {
                    RoleID       = 1,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Create").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "New").ID,
                },
                new StatusAccess
                {
                    RoleID       = 1,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = true,
                    StatusId     = statuses.Single(o => o.ID == "Created").ID,
                },
                new StatusAccess
                {
                    RoleID       = 2,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Created").ID,
                },
                new StatusAccess
                {
                    RoleID       = 2,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Clarified").ID,
                },
                new StatusAccess
                {
                    RoleID       = 2,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Edit").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Created").ID,
                },
                new StatusAccess
                {
                    RoleID       = 3,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Accepted").ID,
                },
                new StatusAccess
                {
                    RoleID       = 4,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Accepted").ID,
                },
                new StatusAccess
                {
                    RoleID       = 4,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Declined").ID,
                },
                new StatusAccess
                {
                    RoleID       = 4,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Completed").ID,
                },
                new StatusAccess
                {
                    RoleID       = 4,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Clarified").ID,
                },
                new StatusAccess
                {
                    RoleID       = 4,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Read").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Created").ID,
                },
                new StatusAccess
                {
                    RoleID       = 1,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Edit").ID,
                    OnlyAuthored = true,
                    StatusId     = statuses.Single(o => o.ID == "Created").ID,
                },
                new StatusAccess
                {
                    RoleID       = 4,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Delete").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Completed").ID,
                },
                new StatusAccess
                {
                    RoleID       = 4,
                    AccessTypeId = accessTypes.Single(a => a.Name == "Delete").ID,
                    OnlyAuthored = false,
                    StatusId     = statuses.Single(o => o.ID == "Declined").ID,
                },
            };

            context.WorktaskAccesses.AddRange(accesses);
            context.SaveChanges();

            var routeAccesses = new StatusRouteAccess[]
            {
                new StatusRouteAccess
                {
                    RoleId        = roles.Single(r => r.Name == "Менеджер").ID,
                    StatusRouteId = 3,
                },
                new StatusRouteAccess
                {
                    RoleId        = roles.Single(r => r.Name == "Менеджер").ID,
                    StatusRouteId = 4,
                },
                new StatusRouteAccess
                {
                    RoleId        = roles.Single(r => r.Name == "Исполнитель").ID,
                    StatusRouteId = 1,
                },
                new StatusRouteAccess
                {
                    RoleId        = roles.Single(r => r.Name == "Исполнитель").ID,
                    StatusRouteId = 2,
                },
            };

            context.StatusRouteAccesses.AddRange(routeAccesses);
            context.SaveChanges();

            var comments = new Comment[]
            {
                new Comment {
                    AuthorId = 1, CreateDate = DateTime.Now, Text = "bla", WorktaskId = "1"
                },
                new Comment {
                    AuthorId = 2, CreateDate = DateTime.Now, Text = "bla", WorktaskId = "1"
                },
                new Comment {
                    AuthorId = 3, CreateDate = DateTime.Now, Text = "bla", WorktaskId = "2"
                },
                new Comment {
                    AuthorId = 4, CreateDate = DateTime.Now, Text = "bla", WorktaskId = "3"
                },
            };

            context.Comments.AddRange(comments);
            context.SaveChanges();
        }