public IActionResult Project([FromQuery] string project_id) { Project project = _context.Project.Include(s => s.IdCompanyNavigation) .Include(s => s.IdProjectTypeNavigation) .Include(s => s.IdStudentNavigation) .Include(s => s.IdBusinessAreaNavigation) .Where(p => p.IdProject.ToString() == project_id).FirstOrDefault(); var projectAdvisors = _context.ProjectAdvisor.Where(pa => pa.IdProject.ToString() == project_id) .Include(pa => pa.IdSchoolMentorNavigation).ToList(); var projectTechnologies = _context.ProjectTechnology.Where(pt => pt.IdProject.ToString() == project_id) .Include(pt => pt.IdTechnologyNavigation).ToList(); var projectDocument = _context.ProjectDocument.Where(pt => pt.IdProject.ToString() == project_id).ToList(); if (project != null) { project.ProjectAdvisor = projectAdvisors; project.ProjectTechnology = projectTechnologies; project.Views += 1; _context.Project.Update(project); _context.SaveChanges(); } return(View(new LoginViewModel { Project = project })); }
public CompanyUnitTests() { var optionsBuilder = new DbContextOptionsBuilder <HUBEI_DBContext>(); optionsBuilder.UseInMemoryDatabase(); _context = new HUBEI_DBContext(optionsBuilder.Options); _context.District.Add(new District() { IdDistrict = 1, Description = "Margem Sul" }); _context.Company.Add(new Company() { IdCompany = 1, Description = "Esta Empresa", Name = "Empresa", Email = "*****@*****.**", IdDistrict = 1 }); _context.SaveChanges(); _controller = new CompanyController(_context, null); }
public StudentUnitTests() { var optionsBuilder = new DbContextOptionsBuilder <HUBEI_DBContext>(); optionsBuilder.UseInMemoryDatabase(); _context = new HUBEI_DBContext(optionsBuilder.Options); _controller = new BackOfficeController(_context, null); _context.StudentBranch.Add(new StudentBranch() { IdStudentBranch = 1, Description = "Ramo" }); _context.District.Add(new District() { IdDistrict = 1, Description = "Margem Sul" }); _context.Address.Add(new Address() { IdAddress = 1, PostalCode = "2475-123", Address1 = "rua", Door = "2", Locality = "Sul", IdDistrict = 1, }); _context.Student.Add(new Student() { IdStudent = 1, BirthDate = new DateTime(1999, 01, 01), Email = "*****@*****.**", IdAddress = 1, IdStudentBranch = 1, Name = "Estudante", StudentNumber = 150221066, Telephone = 911111111, }); _context.SaveChanges(); }
public ProjectUnitTests() { var optionsBuilder = new DbContextOptionsBuilder <HUBEI_DBContext>(); optionsBuilder.UseInMemoryDatabase(); _context = new HUBEI_DBContext(optionsBuilder.Options); _controller = new ProjectController(_context, null); _context.Project.Add(new Project() { IdProject = 1, Title = "project1", Description = "Margem Sul", Report = new byte[100], ProjectDate = new DateTime(2018, 01, 01), IsVisible = true, Views = 10, Downloads = 4, Grade = 17, Video = null, IdProjectType = 1, IdCompany = 1, IdStudent = 1, IdBusinessArea = 1 }); _context.BusinessArea.Add(new BusinessArea() { IdBusinessArea = 1, Description = "Descrição do BusinessArea" }); _context.ProjectType.Add(new ProjectType() { IdProjectType = 1, Description = "Tipo1" }); _context.StudentBranch.Add(new StudentBranch() { IdStudentBranch = 1, Description = "Ramo" }); _context.Student.Add(new Student() { IdStudent = 1, BirthDate = new DateTime(), Email = "*****@*****.**", IdAddress = 1, IdStudentBranch = 1, Name = "Estudante", StudentNumber = 150221066, Telephone = 911111111, }); _context.Address.Add(new Address() { IdAddress = 1, PostalCode = "2475-123", Address1 = "rua", Door = "2", Locality = "Sul", IdDistrict = 1, }); _context.District.Add(new District() { IdDistrict = 1, Description = "Margem Sul" }); _context.Company.Add(new Company() { IdCompany = 1, Description = "Esta Empresa", Name = "Empresa", Email = "*****@*****.**", IdDistrict = 1 }); _context.SaveChanges(); }
public IActionResult Student(BOStudentViewModel model) { if (!User.Identity.IsAuthenticated) { TempData["Got-Error"] = "true"; TempData["Login-Message"] = "É necessário iniciar sessão"; return(RedirectToAction("Index", "Home")); } _context.Address.Add(model.Address); Student std = new Student { Email = model.Student.Email, Name = model.Student.Name, BirthDate = model.Student.BirthDate, Telephone = model.Student.Telephone, StudentNumber = model.Student.StudentNumber, IdStudentBranchNavigation = _context.StudentBranch.Where(sb => sb.IdStudentBranch == model.Student.IdStudentBranch).FirstOrDefault(), IdAddressNavigation = model.Address }; _context.Student.Add(std); _context.SaveChanges(); TempData["HasAlert"] = "true"; TempData["AlertMessage"] = "Student added successfully."; return(RedirectToAction("Students", "BackOffice")); }
public StatisticsUnitTests() { var optionsBuilder = new DbContextOptionsBuilder <HUBEI_DBContext>(); optionsBuilder.UseInMemoryDatabase(); _context = new HUBEI_DBContext(optionsBuilder.Options); _controller = new StatisticsController(_context, null); _context.District.Add(new District() { IdDistrict = 1, Description = "Margem Sul" }); _context.Address.Add(new Address() { IdAddress = 1, IdDistrict = 1, Address1 = "Address", Door = "23", Locality = "Baixa", PostalCode = "2835-123", }); _context.Company.Add(new Company() { IdCompany = 1, Description = "Esta Empresa", Name = "Empresa", Email = "*****@*****.**", IdDistrict = 1 }); _context.StudentBranch.Add(new StudentBranch() { IdStudentBranch = 1, Description = "Ramo" }); _context.Student.Add(new Student() { IdStudent = 1, BirthDate = new DateTime(), Email = "*****@*****.**", IdAddress = 1, IdStudentBranch = 1, Name = "Estudante", StudentNumber = 150221066, Telephone = 911111111, }); _context.Technology.Add(new Technology() { IdTechnology = 1, Description = "Tecnologia" }); _context.BusinessArea.Add(new BusinessArea() { IdBusinessArea = 1, Description = "BA", }); _context.SchoolMentor.Add(new SchoolMentor() { IdSchoolMentor = 1, Name = "Nome", Email = "*****@*****.**", }); _context.Project.Add(new Project() { IdProject = 1, Title = "project1", Description = "Margem Sul", Report = new byte[100], ProjectDate = new DateTime().Date, IsVisible = true, Views = 10, Downloads = 4, Grade = 17, Video = null, IdBusinessArea = 1 }); _context.ProjectAdvisor.Add(new ProjectAdvisor() { IdProject = 1, IdSchoolMentor = 1 }); _context.ProjectTechnology.Add(new ProjectTechnology() { IdProject = 1, IdTechnology = 1 }); _context.SaveChanges(); }