public List <Faculty> FindUniversity(TypeOfSubject typeOfFirstSubject,
TypeOfSubject typeOfSecondSubject, TypeOfSubject typeOfThirdSubject, int numberOfFirstSubject,
int numberOfSecondSubject, int numberOfThirdSubject)
{
var result = new List <Faculty>();
using (var dbContext = new RecommenderSystemContext(_options))
{
var universities = dbContext.Universities;
foreach (var university in universities)
{
foreach (var faculty in university.Faculties)
{
if (faculty.PassingPoints.Any(x => x.TypeOfSubject == typeOfFirstSubject) &&
faculty.PassingPoints.Any(x => x.TypeOfSubject == typeOfSecondSubject) &&
faculty.PassingPoints.Any(x => x.TypeOfSubject == typeOfThirdSubject))
{
if (faculty.PassingPoints.FirstOrDefault(x => x.TypeOfSubject == typeOfFirstSubject)
.MinPoint <= numberOfFirstSubject &&
faculty.PassingPoints.FirstOrDefault(x => x.TypeOfSubject == typeOfSecondSubject)
.MinPoint <= numberOfSecondSubject &&
faculty.PassingPoints.FirstOrDefault(x => x.TypeOfSubject == typeOfThirdSubject)
.MinPoint <= numberOfThirdSubject)
{
result.Add(faculty);
}
}
}
}
}
return(result);
}
public async Task <University> UpdateUniversityAsync(University university)
{
using (var dbContext = new RecommenderSystemContext(_options))
{
dbContext.Entry(university).State = EntityState.Modified;
await dbContext.SaveChangesAsync();
}
return(university);
}
public async Task DeleteUniversityAsync(int id)
{
using (var dbContext = new RecommenderSystemContext(_options))
{
var university = await dbContext.Universities.FirstOrDefaultAsync(u => u.Id == id);
dbContext.Entry(university).State = EntityState.Deleted;
await dbContext.SaveChangesAsync();
}
}
public async Task <University> GetUniversityAsync(int id)
{
University university = null;
using (var dbContext = new RecommenderSystemContext(_options))
{
university = await dbContext.Universities.FirstOrDefaultAsync(u => u.Id == id);
}
return(university);
}
public async Task <EntityEntry <University> > AddUniversityAsync(University university)
{
EntityEntry <University> result = null;
using (var dbContext = new RecommenderSystemContext(_options))
{
result = dbContext.Universities.Add(university);
await dbContext.SaveChangesAsync();
}
return(result);
}
public IEnumerable <University> GetUniversityAsync()
{
var result = new List <University>();
using (var dbContext = new RecommenderSystemContext(_options))
{
result = dbContext.Universities.ToList();
dbContext.SaveChanges();
}
return(result);
}
