public static void SeedProjects(FPISContext context) { if (!context.Projects.Any()) { var projectsData = System.IO.File.ReadAllText("../Seed/Data/ProjectData.json"); var projects = JsonConvert.DeserializeObject <List <Project> >(projectsData); foreach (Project project in projects) { project.DecisionMaker = context.Employees .FirstOrDefault(x => x.Name == project.DecisionMaker.Name && x.Surname == project.DecisionMaker.Surname); project.InternalMentor = context.Employees .FirstOrDefault(x => x.Name == project.InternalMentor.Name && x.Surname == project.InternalMentor.Surname); project.ProjectProposal = context.ProjectProposals .FirstOrDefault(x => x.Name == project.ProjectProposal.Name); if (project.Applications != null) { foreach (Application application in project.Applications) { application.Student = context.Students .FirstOrDefault(x => x.Index == application.Student.Index); application.StudentID = application.Student.StudentID; } } context.Projects.Add(project); } context.SaveChanges(); } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, FPISContext dbContext) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } //app.UseHttpsRedirection(); app.UseCors(x => x .AllowAnyMethod() .AllowAnyHeader() .SetIsOriginAllowed(origin => true) // allow any origin ); app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); endpoints.MapHub <HubConfig>("/mysignal"); }); //app.UseCors(x => x.AllowAnyOrigin().AllowAnyMethod().AllowAnyHeader()); app.UseAuthentication(); dbContext.Database.EnsureCreated(); app.UseGraphiQl("/graphql"); //znaci da mi je poziv endpointa: localhost/5000/graphql app.UseGraphQL <ISchema>(); }
public static void SeedCities(FPISContext context) { var citiesData = System.IO.File.ReadAllText("../Seed/Data/CityData.json"); var cities = JsonConvert.DeserializeObject <List <City> >(citiesData); foreach (var city in cities) { context.Cities.Add(city); } context.SaveChanges(); }
public static void SeedPositions(FPISContext context) { if (!context.Positions.Any()) { var positionsData = System.IO.File.ReadAllText("../Seed/Data/PositionData.json"); var positions = JsonConvert.DeserializeObject <List <Position> >(positionsData); foreach (var position in positions) { context.Positions.Add(position); } context.SaveChanges(); } }
public static void SeedStudents(FPISContext context) { if (!context.Students.Any()) { var studentsData = System.IO.File.ReadAllText("../Seed/Data/StudentData.json"); var students = JsonConvert.DeserializeObject <List <Student> >(studentsData); foreach (Student student in students) { context.Students.Add(student); } context.SaveChanges(); } }
public static void SeedScientificAreas(FPISContext context) { if (!context.ScientificAreas.Any()) { var areasData = System.IO.File.ReadAllText("../Seed/Data/ScientificAreaData.json"); var areas = JsonConvert.DeserializeObject <List <ScientificArea> >(areasData); foreach (var area in areas) { context.ScientificAreas.Add(area); } context.SaveChanges(); } }
public static void SeedCompanies(FPISContext context) { if (!context.Companies.Any()) { var companyData = System.IO.File.ReadAllText("../Seed/Data/CompanyData.json"); var companies = JsonConvert.DeserializeObject <List <Company> >(companyData); foreach (var company in companies) { foreach (var location in company.Locations) { location.City = context.Cities.FirstOrDefault(l => l.Name == location.City.Name); location.CityID = location.City.CityID; } byte[] passwordHash, passwordSalt; CreatePasswordHash("tea", out passwordHash, out passwordSalt); company.PasswordHash = passwordHash; company.PasswordSalt = passwordSalt; context.Companies.Add(company); } context.SaveChanges(); } }
public static void SeedProjectsProposals(FPISContext context) { if (!context.ProjectProposals.Any()) { var proposalsData = System.IO.File.ReadAllText("../Seed/Data/ProjectProposalData.json"); var proposals = JsonConvert.DeserializeObject <List <ProjectProposal> >(proposalsData); foreach (var proposal in proposals) { proposal.Company = context.Companies .FirstOrDefault(x => x.Name == proposal.Company.Name); proposal.ExternalMentor = context.ExternalMentors .FirstOrDefault(x => x.Name == proposal.ExternalMentor.Name && x.Surname == proposal.ExternalMentor.Surname); foreach (ProjectCoveringSubject subject in proposal.Subjects) { subject.ScientificArea = context.ScientificAreas .FirstOrDefault(x => x.Name == subject.ScientificArea.Name); } context.ProjectProposals.Add(proposal); } context.SaveChanges(); } }
public static void SeedEmployees(FPISContext context) { if (!context.Employees.Any()) { var employeesData = System.IO.File.ReadAllText("../Seed/Data/EmployeeData.json"); var employees = JsonConvert.DeserializeObject <List <Employee> >(employeesData); foreach (var emp in employees) { emp.Positions = new List <EmployeePosition>(); switch (emp.Username) { case "miki": { emp.Positions.Add(new EmployeePosition { PositionID = context.Positions.FirstOrDefault(x => x.Name == "Декан").PositionID, DateFrom = DateTime.Today.AddYears(-2) }); break; } case "aco": { emp.Positions.Add(new EmployeePosition { PositionID = context.Positions.FirstOrDefault(x => x.Name == "Продекан за наставу").PositionID, DateFrom = DateTime.Today.AddYears(-2) }); break; } case "sanja": { emp.Positions.Add(new EmployeePosition { PositionID = context.Positions.FirstOrDefault(x => x.Name == "Продекан за међународну сарадњу").PositionID, DateFrom = DateTime.Today.AddYears(-2) }); break; } case "aki": { emp.Positions.Add(new EmployeePosition { PositionID = context.Positions.FirstOrDefault(x => x.Name == "Продекан за организацију и финансије").PositionID, DateFrom = DateTime.Today.AddYears(-2) }); break; } case "mare": { emp.Positions.Add(new EmployeePosition { PositionID = context.Positions.FirstOrDefault(x => x.Name == "Продекан за научно-истраживачки рад").PositionID, DateFrom = DateTime.Today.AddYears(-2) }); break; } case "goca": { emp.Positions.Add(new EmployeePosition { PositionID = context.Positions.FirstOrDefault(x => x.Name == "Секретар факултета").PositionID, DateFrom = DateTime.Today.AddYears(-2) }); break; } case "irc": { emp.Positions.Add(new EmployeePosition { PositionID = context.Positions.FirstOrDefault(x => x.Name == "Ирц админ").PositionID, DateFrom = DateTime.Today.AddYears(-2) }); break; } } byte[] passwordHash, passwordSalt; CreatePasswordHash("1234", out passwordHash, out passwordSalt); emp.PasswordHash = passwordHash; emp.PasswordSalt = passwordSalt; context.Employees.Add(emp); } context.SaveChanges(); } }
public Repository(FPISContext context) { this.context = context; _entities = context.Set <T>(); }