Ejemplo n.º 1
0
        public static void EnsureCategoryInserted(this ProfileDbContext context)
        {
            if (!context.JobCategory.Any())
            {
                var actor = context.JobCategory.Add(new JobCategory {
                    CategoryName = "Actor", DisplayName = "Actor", CategoryDesc = "Actor Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;
                context.JobSubCategory.AddRange(
                    new JobSubCategory
                {
                    SubCategoryName   = "Agencies",
                    DisplayName       = "Agencies",
                    SubCategoryDesc   = "Agencies",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "Entertainers",
                    DisplayName       = "Entertainers",
                    SubCategoryDesc   = "Entertainers",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "EventsPromotions",
                    DisplayName       = "Events & Promotions",
                    SubCategoryDesc   = "Events & Promotions",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "FeatureFilms",
                    DisplayName       = "Feature Films",
                    SubCategoryDesc   = "Feature Films",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "Musicvideos",
                    DisplayName       = "Music videos",
                    SubCategoryDesc   = "Music videos",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "Presenters",
                    DisplayName       = "Presenters",
                    SubCategoryDesc   = "Presenters",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "ShortFilms",
                    DisplayName       = "Short Films",
                    SubCategoryDesc   = "Short Films",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "TheatreMusicals",
                    DisplayName       = "Theatre & Musicals",
                    SubCategoryDesc   = "Theatre & Musicals",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "TVCommercials",
                    DisplayName       = "TV Commercials",
                    SubCategoryDesc   = "TV commercials",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "TVSeries",
                    DisplayName       = "TV Series",
                    SubCategoryDesc   = "TV Series",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "VoiceoverRadio",
                    DisplayName       = "Voiceover & Radio",
                    SubCategoryDesc   = "Voiceover & Radio",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "Web",
                    DisplayName       = "Web",
                    SubCategoryDesc   = "Web",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                },
                    new JobSubCategory
                {
                    SubCategoryName   = "Other",
                    DisplayName       = "Other",
                    SubCategoryDesc   = "Other",
                    SubCategoryStatus = 1,
                    SubCategoryType   = "interest",
                    JobCategory       = actor,
                    DttmCreated       = DateTime.UtcNow,
                    DttmModified      = DateTime.UtcNow
                });

                var modal = context.JobCategory.Add(new JobCategory {
                    CategoryName = "Modal", DisplayName = "Modal", CategoryDesc = "Modal Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;
                context.JobSubCategory.AddRange(
                    new JobSubCategory {
                    SubCategoryName = "Agencies", DisplayName = "Agencies", SubCategoryDesc = "Agencies", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Catwalk", DisplayName = "Catwalk", SubCategoryDesc = "Catwalk", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "CompetitionsPageants", DisplayName = "Competitions & Pageants", SubCategoryDesc = "Competitions and Pageants", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "EventsPromotions", DisplayName = "Events & Promotions", SubCategoryDesc = "Events and Promotions", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Fitting", DisplayName = "Fitting", SubCategoryDesc = "Fitting", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Hairmodels", DisplayName = "Hair models", SubCategoryDesc = "Hair models", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Musicvideos", DisplayName = "Music videos", SubCategoryDesc = "Music videos", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Presenters", DisplayName = "Presenters", SubCategoryDesc = "Presenters", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Print", DisplayName = "Print", SubCategoryDesc = "Print", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "TimeforPrints", DisplayName = "Time for Prints", SubCategoryDesc = "Time for Prints", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "TVcommercials", DisplayName = "TV Commercials", SubCategoryDesc = "TV commercials", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Other", DisplayName = "Other", SubCategoryDesc = "Other", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = modal, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }
                    );


                var musician = context.JobCategory.Add(new JobCategory {
                    CategoryName = "Musician", DisplayName = "Musician", CategoryDesc = "Musician Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;
                context.JobSubCategory.AddRange(
                    new JobSubCategory {
                    SubCategoryName = "Classical", DisplayName = "Classical", SubCategoryDesc = "Classical", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Country", DisplayName = "Country", SubCategoryDesc = "Country", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Electronic", DisplayName = "Electronic", SubCategoryDesc = "Electronic", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Hiphop", DisplayName = "Hip-hop", SubCategoryDesc = "Hip-hop", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Indie", DisplayName = "Indie", SubCategoryDesc = "Indie", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Jazz", DisplayName = "Jazz", SubCategoryDesc = "Jazz", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Metal", DisplayName = "Metal", SubCategoryDesc = "Metal", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Pop", DisplayName = "Pop", SubCategoryDesc = "Pop", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Rock", DisplayName = "Rock", SubCategoryDesc = "Rock", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = musician, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }
                    );

                var tvreality = context.JobCategory.Add(new JobCategory {
                    CategoryName = "TVReality", DisplayName = "TV & Reality", CategoryDesc = "TV & Reality Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;
                context.JobSubCategory.AddRange(
                    new JobSubCategory {
                    SubCategoryName = "Audiences", DisplayName = "Audiences", SubCategoryDesc = "Audiences", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = tvreality, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "DocumentariesFactual", DisplayName = "Documentaries & Factual", SubCategoryDesc = "Documentaries and Factual", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = tvreality, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Gameshows", DisplayName = "Game shows", SubCategoryDesc = "Game shows", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = tvreality, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "RealityTV", DisplayName = "Reality TV", SubCategoryDesc = "Reality TV", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = tvreality, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }
                    );

                var dancing = context.JobCategory.Add(new JobCategory {
                    CategoryName = "Dancing", DisplayName = "Dancing", CategoryDesc = "Dancing Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;
                context.JobSubCategory.AddRange(
                    // Interest
                    new JobSubCategory {
                    SubCategoryName = "Audiences", DisplayName = "Audiences", SubCategoryDesc = "Audiences", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Choreographers", DisplayName = "Choreographers", SubCategoryDesc = "Choreographers", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Companies", DisplayName = "Companies", SubCategoryDesc = "Companies", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Competitions", DisplayName = "Competitions", SubCategoryDesc = "Competitions", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Liveperformance", DisplayName = "Live performance", SubCategoryDesc = "Live performance", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Musicvideos", DisplayName = "Music videos", SubCategoryDesc = "Music videos", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Photoshoots", DisplayName = "Photo shoots", SubCategoryDesc = "Photo shoots", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "TeachersInstructors", DisplayName = "Teachers / Instructors", SubCategoryDesc = "Teachers / Instructors", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "TVFilm", DisplayName = "TV & Film", SubCategoryDesc = "TV and Film", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Other", DisplayName = "Other", SubCategoryDesc = "Other", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },

                    // Style
                    new JobSubCategory {
                    SubCategoryName = "Ballet", DisplayName = "Ballet", SubCategoryDesc = "Ballet", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Ballroom", DisplayName = "Ballroom", SubCategoryDesc = "Ballroom", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Bellydance", DisplayName = "Bellydance", SubCategoryDesc = "Bellydance", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Bollywood", DisplayName = "Bollywood", SubCategoryDesc = "Bollywood", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Breakdancing", DisplayName = "Breakdancing", SubCategoryDesc = "Breakdancing", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Contemporary", DisplayName = "Contemporary", SubCategoryDesc = "Contemporary", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Country", DisplayName = "Country", SubCategoryDesc = "Country", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Disco", DisplayName = "Disco", SubCategoryDesc = "Disco", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Folk", DisplayName = "Folk", SubCategoryDesc = "Folk", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "HipHop", DisplayName = "Hip Hop", SubCategoryDesc = "Hip Hop", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Jazz", DisplayName = "Jazz", SubCategoryDesc = "Jazz", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "LatinAmerican", DisplayName = "Latin American", SubCategoryDesc = "Latin American", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "RockRoll", DisplayName = "Rock & Roll", SubCategoryDesc = "Rock & Roll", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Salsa", DisplayName = "Salsa", SubCategoryDesc = "Salsa", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Swing", DisplayName = "Swing", SubCategoryDesc = "Swing", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Tango", DisplayName = "Tango", SubCategoryDesc = "Tango", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Tap", DisplayName = "Tap", SubCategoryDesc = "Tap", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Others", DisplayName = "Others", SubCategoryDesc = "Others", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }
                    //new JobSubCategory { SubCategoryName = "Audiences", DisplayName = "Audiences", SubCategoryDesc = "Audiences", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow },
                    // new JobSubCategory { SubCategoryName = "Audiences", DisplayName = "Audiences", SubCategoryDesc = "Audiences", SubCategoryStatus = 1, SubCategoryType = "style", JobCategory = dancing, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow }
                    );

                var filmstagecrew = context.JobCategory.Add(new JobCategory {
                    CategoryName = "FilmStageCrew", DisplayName = "Film & Stage Crew", CategoryDesc = "Film & Stage Crew Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;
                context.JobSubCategory.AddRange(
                    new JobSubCategory {
                    SubCategoryName = "ArtDepartment", DisplayName = "Art Department", SubCategoryDesc = "Art Department", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Camera", DisplayName = "Camera", SubCategoryDesc = "Camera", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Competitions", DisplayName = "Competitions", SubCategoryDesc = "Competitions", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Festivals", DisplayName = "Festivals", SubCategoryDesc = "Festivals", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Costume", DisplayName = "Costume", SubCategoryDesc = "Costume", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Editing", DisplayName = "Editing", SubCategoryDesc = "Editing", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Grip", DisplayName = "Grip", SubCategoryDesc = "Grip", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Lighting", DisplayName = "Lighting", SubCategoryDesc = "Lighting", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "SoundMusic", DisplayName = "Sound & Music", SubCategoryDesc = "Sound & Music", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Other", DisplayName = "Other", SubCategoryDesc = "Other", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = filmstagecrew, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }
                    );

                var stylist = context.JobCategory.Add(new JobCategory {
                    CategoryName = "Stylist", DisplayName = "Stylist", CategoryDesc = "Stylist Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;
                context.JobSubCategory.AddRange(
                    new JobSubCategory {
                    SubCategoryName = "HairStylists", DisplayName = "Hair Stylists", SubCategoryDesc = "Hair Stylists", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = stylist, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "MakeupArtists", DisplayName = "Makeup Artists", SubCategoryDesc = "Makeup Artists", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = stylist, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Stylists", DisplayName = "Stylists", SubCategoryDesc = "Stylists", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = stylist, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                },
                    new JobSubCategory {
                    SubCategoryName = "Other", DisplayName = "Other", SubCategoryDesc = "Other", SubCategoryStatus = 1, SubCategoryType = "interest", JobCategory = stylist, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }
                    );

                var photographer = context.JobCategory.Add(new JobCategory {
                    CategoryName = "Photographer", DisplayName = "Photographer", CategoryDesc = "Photographer Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;
                var magazine = context.JobCategory.Add(new JobCategory {
                    CategoryName = "Magazine", DisplayName = "Magazine", CategoryDesc = "Magazine Category", CategoryStatus = 1, DttmCreated = DateTime.UtcNow, DttmModified = DateTime.UtcNow
                }).Entity;


                context.SaveChanges();
            }
        }