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();
}