コード例 #1
0
        public void Popular()
        {
            if (_context.TipoUsuario.Any())
            {
                return;
            }

            var roleAdm = new IdentityRole {
                Name = "Administrador", NormalizedName = "ADMINISTRADOR"
            };
            var roleAluno = new IdentityRole {
                Name = "Aluno", NormalizedName = "ALUNO"
            };
            var roleProf = new IdentityRole {
                Name = "Professor", NormalizedName = "PROFESSOR"
            };
            var roleCoord = new IdentityRole {
                Name = "Coordenador", NormalizedName = "COORDENADOR"
            };

            _context.Roles.AddRange(roleAdm, roleProf, roleCoord, roleAluno);

            var tipoUsuarioAdm = new TipoUsuario {
                DescTipo = "Administrador"
            };
            var tipoUsuarioAluno = new TipoUsuario {
                DescTipo = "Aluno"
            };
            var tipoUsuarioProf = new TipoUsuario {
                DescTipo = "Professor"
            };
            var tipoUsuarioCoord = new TipoUsuario {
                DescTipo = "Coordenador"
            };
            var tipoUsuarioOrientador = new TipoUsuario {
                DescTipo = "Orientador"
            };
            var tipoUsuarioCoorientador = new TipoUsuario {
                DescTipo = "Coorientador"
            };
            var tipoUsuarioMembroBanca = new TipoUsuario {
                DescTipo = "Membro da Banca"
            };

            _context.TipoUsuario.AddRange(tipoUsuarioAdm, tipoUsuarioAluno, tipoUsuarioCoord, tipoUsuarioCoorientador, tipoUsuarioMembroBanca, tipoUsuarioOrientador, tipoUsuarioProf);

            var CampusLag = new Campus {
                Nome = "Campus Lagarto", Endereco = "Lagarto"
            };
            var CampusIta = new Campus {
                Nome = "Campus Itabaiana", Endereco = "Itabaiana"
            };
            var CampusEst = new Campus {
                Nome = "Campus Estância", Endereco = "Estância"
            };
            var CampusAju = new Campus {
                Nome = "Campus Aracaju", Endereco = "Aracaju"
            };
            var CampusGlo = new Campus {
                Nome = "Campus Glória", Endereco = "Glória"
            };

            _context.Campus.AddRange(CampusLag, CampusIta, CampusEst, CampusAju, CampusGlo);

            var CursoBsi = new Curso {
                Nome = "Sistemas", Sigla = "BSI", CodEmec = 00001, Campus = CampusLag
            };
            var CursoFis = new Curso {
                Nome = "Fisica", Sigla = "FIS", CodEmec = 00002, Campus = CampusIta
            };
            var CursoAut = new Curso {
                Nome = "Automação", Sigla = "AUT", CodEmec = 00003, Campus = CampusEst
            };
            var CursoMat = new Curso {
                Nome = "Matemática", Sigla = "MAT", CodEmec = 00004, Campus = CampusAju
            };
            var CursoEng = new Curso {
                Nome = "Engenharia", Sigla = "ENG", CodEmec = 00005, Campus = CampusGlo
            };

            _context.Cursos.AddRange(CursoBsi, CursoFis, CursoAut, CursoMat, CursoEng);

            var statusPendente = new Status {
                DescStatus = "Cadastrado"
            };
            var statusHomologadoTCC = new Status {
                DescStatus = "Pré-Homologado"
            };
            var statusHomologadoBanca = new Status {
                DescStatus = "Homologado Banca"
            };
            var statusCancelado = new Status {
                DescStatus = "Cancelado"
            };
            var statusAprovado = new Status {
                DescStatus = "Aprovado"
            };
            var statusReprovado = new Status {
                DescStatus = "Reprovado"
            };

            _context.Status.AddRange(statusAprovado, statusCancelado, statusHomologadoBanca, statusHomologadoTCC, statusPendente, statusReprovado);

            var calendario20191 = new Calendario {
                Ano = 2019, Semestre = 1, DataInicio = new DateTime(2019, 06, 03), DataFim = new DateTime(2019, 06, 14), Ativo = false
            };
            var calendario20201 = new Calendario {
                Ano = 2020, Semestre = 1, DataInicio = new DateTime(2020, 06, 01), DataFim = new DateTime(2020, 06, 12), Ativo = true
            };

            _context.Calendario.AddRange(calendario20191, calendario20201);

            // A senha de todos os usuários abaixo é: P@$$w0rd

            var userAdm = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Administrador",
                Sobrenome         = "do Sistema",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "0",
                TipoUsuario       = tipoUsuarioAdm,
                Cpf         = "99999999999",
                PhoneNumber = "99999999999",
                Curso       = CursoBsi
            };
            var userCatuxe = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Catuxe",
                Sobrenome         = "Varjão",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "143717",
                Cpf         = "48786338786",
                TipoUsuario = tipoUsuarioCoord,
                PhoneNumber = "99999999999",
                Curso       = CursoBsi
            };
            var userJislane = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Jislane",
                Sobrenome         = "Silva",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "413682",
                Cpf         = "61788703205",
                TipoUsuario = tipoUsuarioProf,
                PhoneNumber = "99999999999",
                Curso       = CursoBsi
            };
            var userGilson = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Gilson",
                Sobrenome         = "Santos",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "148915",
                Cpf         = "05578896130",
                TipoUsuario = tipoUsuarioProf,
                PhoneNumber = "99999999999",
                Curso       = CursoBsi
            };
            var userGlauco = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Glauco",
                Sobrenome         = "Carvalho",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "154790",
                Cpf         = "18780486144",
                TipoUsuario = tipoUsuarioProf,
                PhoneNumber = "99999999999",
                Curso       = CursoBsi
            };
            var userJean = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Jean",
                Sobrenome         = "Louis",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "477854",
                Cpf         = "05875304515",
                TipoUsuario = tipoUsuarioProf,
                PhoneNumber = "99999999999",
                Curso       = CursoBsi
            };
            var userWillian = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Willian",
                Sobrenome         = "Farias",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20142863156328",
                Cpf         = "57878135484",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999",
                Curso       = CursoBsi
            };
            var userAlex = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Alex",
                Sobrenome         = "Oliveira",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20151863147125",
                Cpf         = "05447800241",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999",
                Curso       = CursoAut
            };
            var userAna = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Ana Carla",
                Sobrenome         = "Nascimento",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20151863147165",
                Cpf         = "15787601551",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999",
                Curso       = CursoFis
            };
            var userMateus = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Mateus",
                Sobrenome         = "Lima",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20131863058127",
                Cpf         = "04263417322",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999",
                Curso       = CursoEng
            };
            var userHelena = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Helena",
                Sobrenome         = "Mendonça",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20122863098617",
                Cpf         = "12364289838",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999",
                Curso       = CursoMat
            };

            _context.Usuario.AddRange(userAdm, userCatuxe, userWillian, userAlex, userAna, userJislane, userGilson, userGlauco, userJean, userMateus, userHelena);


            var rowAdm = new IdentityUserRole <string>();

            rowAdm.UserId = userAdm.Id;
            rowAdm.RoleId = roleAdm.Id;
            var rowCoord = new IdentityUserRole <string>();

            rowCoord.UserId = userCatuxe.Id;
            rowCoord.RoleId = roleCoord.Id;
            var rowCoordProf = new IdentityUserRole <string>();

            rowCoordProf.UserId = userCatuxe.Id;
            rowCoordProf.RoleId = roleProf.Id;
            var rowJislane = new IdentityUserRole <string>();

            rowJislane.UserId = userJislane.Id;
            rowJislane.RoleId = roleProf.Id;
            var rowGilson = new IdentityUserRole <string>();

            rowGilson.UserId = userGilson.Id;
            rowGilson.RoleId = roleProf.Id;
            var rowGlauco = new IdentityUserRole <string>();

            rowGlauco.UserId = userGlauco.Id;
            rowGlauco.RoleId = roleProf.Id;
            var rowJean = new IdentityUserRole <string>();

            rowJean.UserId = userJean.Id;
            rowJean.RoleId = roleProf.Id;
            var rowWillian = new IdentityUserRole <string>();

            rowWillian.UserId = userWillian.Id;
            rowWillian.RoleId = roleAluno.Id;
            var rowAlex = new IdentityUserRole <string>();

            rowAlex.UserId = userAlex.Id;
            rowAlex.RoleId = roleAluno.Id;
            var rowAna = new IdentityUserRole <string>();

            rowAna.UserId = userAna.Id;
            rowAna.RoleId = roleAluno.Id;
            var rowMateus = new IdentityUserRole <string>();

            rowMateus.UserId = userMateus.Id;
            rowMateus.RoleId = roleAluno.Id;
            var rowHelena = new IdentityUserRole <string>();

            rowHelena.UserId = userHelena.Id;
            rowHelena.RoleId = roleAluno.Id;
            _context.UserRoles.AddRange(rowAdm, rowCoord, rowCoordProf, rowJislane, rowGilson, rowGlauco, rowJean, rowWillian, rowAlex, rowAna, rowMateus, rowHelena);

            _context.SaveChanges();
        }
コード例 #2
0
        public void Popular()
        {
            if (_context.TipoUsuario.Any())
            {
                return;
            }

            var roleAdm = new IdentityRole {
                Name = "Administrador", NormalizedName = "ADMINISTRADOR"
            };
            var roleAluno = new IdentityRole {
                Name = "Aluno", NormalizedName = "ALUNO"
            };
            var roleProf = new IdentityRole {
                Name = "Professor", NormalizedName = "PROFESSOR"
            };
            var roleCoord = new IdentityRole {
                Name = "Coordenador", NormalizedName = "COORDENADOR"
            };

            _context.Roles.AddRange(roleAdm, roleProf, roleCoord, roleAluno);

            var tipoUsuarioAdm = new TipoUsuario {
                DescTipo = "Administrador"
            };
            var tipoUsuarioAluno = new TipoUsuario {
                DescTipo = "Aluno"
            };
            var tipoUsuarioProf = new TipoUsuario {
                DescTipo = "Professor"
            };
            var tipoUsuarioCoord = new TipoUsuario {
                DescTipo = "Coordenador"
            };
            var tipoUsuarioOrientador = new TipoUsuario {
                DescTipo = "Orientador"
            };
            var tipoUsuarioCoorientador = new TipoUsuario {
                DescTipo = "Coorientador"
            };
            var tipoUsuarioMembroBanca = new TipoUsuario {
                DescTipo = "Membro da Banca"
            };

            _context.TipoUsuario.AddRange(tipoUsuarioAdm, tipoUsuarioAluno, tipoUsuarioCoord, tipoUsuarioCoorientador, tipoUsuarioMembroBanca, tipoUsuarioOrientador, tipoUsuarioProf);

            var statusPendente = new Status {
                DescStatus = "Cadastrado"
            };
            var statusHomologadoTCC = new Status {
                DescStatus = "Pré-Homologado"
            };
            var statusHomologadoBanca = new Status {
                DescStatus = "Homologado Banca"
            };
            var statusCancelado = new Status {
                DescStatus = "Cancelado"
            };
            var statusAprovado = new Status {
                DescStatus = "Aprovado"
            };
            var statusReprovado = new Status {
                DescStatus = "Reprovado"
            };

            _context.Status.AddRange(statusAprovado, statusCancelado, statusHomologadoBanca, statusHomologadoTCC, statusPendente, statusReprovado);

            var calendario20191 = new Calendario {
                Ano = 2019, Semestre = 1, DataInicio = new DateTime(2019, 06, 03), DataFim = new DateTime(2019, 06, 14), Ativo = false
            };
            var calendario20201 = new Calendario {
                Ano = 2020, Semestre = 1, DataInicio = new DateTime(2020, 06, 01), DataFim = new DateTime(2020, 06, 12), Ativo = true
            };

            _context.Calendario.AddRange(calendario20191, calendario20201);

            // A senha de todos os usuários abaixo é: P@$$w0rd


            var userAdm = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Administrador",
                Sobrenome         = "do Sistema",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "0",
                TipoUsuario       = tipoUsuarioAdm,
                Cpf         = "99999999999",
                PhoneNumber = "99999999999"
            };
            var userCatuxe = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Catuxe",
                Sobrenome         = "Varjão",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "143717",
                Cpf         = "48786338786",
                TipoUsuario = tipoUsuarioCoord,
                PhoneNumber = "99999999999"
            };
            var userJislane = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Jislane",
                Sobrenome         = "Silva",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "413682",
                Cpf         = "61788703205",
                TipoUsuario = tipoUsuarioProf,
                PhoneNumber = "99999999999"
            };
            var userGilson = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Gilson",
                Sobrenome         = "Santos",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "148915",
                Cpf         = "05578896130",
                TipoUsuario = tipoUsuarioProf,
                PhoneNumber = "99999999999"
            };
            var userGlauco = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Glauco",
                Sobrenome         = "Carvalho",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "154790",
                Cpf         = "18780486144",
                TipoUsuario = tipoUsuarioProf,
                PhoneNumber = "99999999999"
            };
            var userJean = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Jean",
                Sobrenome         = "Louis",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "477854",
                Cpf         = "05875304515",
                TipoUsuario = tipoUsuarioProf,
                PhoneNumber = "99999999999"
            };
            var userWillian = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Willian",
                Sobrenome         = "Farias",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20142863156328",
                Cpf         = "57878135484",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999"
            };
            var userAlex = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Alex",
                Sobrenome         = "Oliveira",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20151863147125",
                Cpf         = "05447800241",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999"
            };
            var userAna = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Ana Carla",
                Sobrenome         = "Nascimento",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20151863147165",
                Cpf         = "15787601551",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999"
            };
            var userMateus = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Mateus",
                Sobrenome         = "Lima",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20131863058127",
                Cpf         = "04263417322",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999"
            };
            var userHelena = new Usuario
            {
                UserName           = "******",
                NormalizedUserName = "******",
                Email             = "*****@*****.**",
                NormalizedEmail   = "*****@*****.**",
                Nome              = "Helena",
                Sobrenome         = "Mendonça",
                PasswordHash      = "AQAAAAEAACcQAAAAEHWjbOIHqtSUeaxyCj/PR6rYwJ/xgW8jl8TYjeC4+iDj4EsSkQogl1TYPTRDpUA/5g==",
                SecurityStamp     = "WCSIGCB6MEQY4LMWJ7VFWYC43BJ6GNBD",
                ConcurrencyStamp  = "4f1ea59f-a987-45cf-abe6-d9e456b43fae",
                LockoutEnabled    = true,
                AccessFailedCount = 1,
                Matricula         = "20122863098617",
                Cpf         = "12364289838",
                TipoUsuario = tipoUsuarioAluno,
                PhoneNumber = "99999999999"
            };

            _context.Usuario.AddRange(userAdm, userWillian, userAlex, userAna, userCatuxe, userJislane, userGilson, userGlauco, userJean, userMateus, userHelena);


            var rowAdm = new IdentityUserRole <string>();

            rowAdm.UserId = userAdm.Id;
            rowAdm.RoleId = roleAdm.Id;
            var rowCoord = new IdentityUserRole <string>();

            rowCoord.UserId = userCatuxe.Id;
            rowCoord.RoleId = roleCoord.Id;
            var rowCoordProf = new IdentityUserRole <string>();

            rowCoordProf.UserId = userCatuxe.Id;
            rowCoordProf.RoleId = roleProf.Id;
            var rowJislane = new IdentityUserRole <string>();

            rowJislane.UserId = userJislane.Id;
            rowJislane.RoleId = roleProf.Id;
            var rowGilson = new IdentityUserRole <string>();

            rowGilson.UserId = userGilson.Id;
            rowGilson.RoleId = roleProf.Id;
            var rowGlauco = new IdentityUserRole <string>();

            rowGlauco.UserId = userGlauco.Id;
            rowGlauco.RoleId = roleProf.Id;
            var rowJean = new IdentityUserRole <string>();

            rowJean.UserId = userJean.Id;
            rowJean.RoleId = roleProf.Id;
            var rowWillian = new IdentityUserRole <string>();

            rowWillian.UserId = userWillian.Id;
            rowWillian.RoleId = roleAluno.Id;
            var rowAlex = new IdentityUserRole <string>();

            rowAlex.UserId = userAlex.Id;
            rowAlex.RoleId = roleAluno.Id;
            var rowAna = new IdentityUserRole <string>();

            rowAna.UserId = userAna.Id;
            rowAna.RoleId = roleAluno.Id;
            var rowMateus = new IdentityUserRole <string>();

            rowMateus.UserId = userMateus.Id;
            rowMateus.RoleId = roleAluno.Id;
            var rowHelena = new IdentityUserRole <string>();

            rowHelena.UserId = userHelena.Id;
            rowHelena.RoleId = roleAluno.Id;
            _context.UserRoles.AddRange(rowAdm, rowCoord, rowCoordProf, rowJislane, rowGilson, rowGlauco, rowJean, rowWillian, rowAlex, rowAna, rowMateus, rowHelena);

            //var tccWillian = new Tcc {
            //    Tema = "Sistema X",
            //    Usuario = userWillian,
            //    DataDeCadastro = new DateTime(2020, 02, 13, 19, 35, 04),
            //    Status = statusPendente
            //};
            //var tccAlex = new Tcc {
            //    Tema = "Sistema Y",
            //    Usuario = userAlex,
            //    DataDeCadastro = new DateTime(2020, 03, 02, 21, 43, 12),
            //    Status = statusHomologadoTCC
            //};
            //var tccMateus = new Tcc
            //{
            //    Tema = "Sistema M",
            //    Usuario = userMateus,
            //    DataDeCadastro = new DateTime(2017, 07, 07, 14, 27, 15),
            //    Status = statusHomologadoBanca,
            //    Resumo = "Resumo resumo resumo",
            //    LocalApresentacao = "Lab. 01, COINF",
            //    DataApresentacao = new DateTime(2018, 06, 19, 19, 30, 00)
            //};
            //var tccHelena = new Tcc
            //{
            //    Tema = "Sistema H",
            //    Usuario = userHelena,
            //    DataDeCadastro = new DateTime(2016, 08, 11, 17, 04, 27),
            //    Status = statusCancelado,
            //    Resumo = "Resumo resumo resumo"
            //};
            //var tccAna = new Tcc
            //{
            //    Tema = "Sistema Z",
            //    Usuario = userAna,
            //    DataDeCadastro = new DateTime(2019, 03, 11, 20, 08, 31),
            //    Status = statusAprovado,
            //    Resumo = "Resumo resumo resumo",
            //    LocalApresentacao = "Laboratório 06, COINF, IFS-Lagarto",
            //    DataApresentacao = new DateTime(2019, 06, 04, 20, 30, 52),
            //    DataFinalizacao = new DateTime(2019, 06, 14, 19, 34, 08),
            //    Nota = 8.5
            //};
            //_context.Tccs.AddRange(tccWillian, tccAlex, tccAna, tccMateus, tccHelena);


            //var orientadorWillian = new Banca { Tcc = tccWillian, Usuario = userCatuxe, TipoUsuario = tipoUsuarioOrientador };
            //var coorientadorWillian = new Banca { Tcc = tccWillian, Usuario = userGilson, TipoUsuario = tipoUsuarioCoorientador };
            //var orientadorAlex = new Banca { Tcc = tccAlex, Usuario = userGilson, TipoUsuario = tipoUsuarioOrientador };
            //var coorientadorAlex = new Banca { Tcc = tccAlex, Usuario = userJislane, TipoUsuario = tipoUsuarioCoorientador };
            //var orientadorMateus = new Banca { Tcc = tccMateus, Usuario = userGlauco, TipoUsuario = tipoUsuarioOrientador };
            //var coorientadorMateus = new Banca { Tcc = tccMateus, Usuario = userJean, TipoUsuario = tipoUsuarioCoorientador };
            //var membroBancaMateus = new Banca { Tcc = tccMateus, Usuario = userGilson, TipoUsuario = tipoUsuarioMembroBanca };
            //var orientadorAna = new Banca { Tcc = tccAna, Usuario = userJislane, TipoUsuario = tipoUsuarioOrientador, Nota = 9.0 };
            //var coorientadorAna = new Banca { Tcc = tccAna, Usuario = userGilson, TipoUsuario = tipoUsuarioCoorientador, Nota = 8.5 };
            //var membroBancaAna = new Banca { Tcc = tccAna, Usuario = userJean, TipoUsuario = tipoUsuarioMembroBanca, Nota = 8.0 };
            //_context.Banca.AddRange(orientadorWillian, coorientadorWillian, orientadorAlex, coorientadorAlex, orientadorAna, coorientadorAna, membroBancaAna, orientadorMateus, coorientadorMateus, membroBancaMateus);

            _context.SaveChanges();
        }