public static void Main()
{
//Create and initialize the database
Database.SetInitializer(new MigrateDatabaseToLatestVersion
<SchoolContext, School.Data.Migrations.Configuration>());
var context = new SchoolContext();
using (context)
{
var school = new TownSchool { Name = "School", Location = "Town" };
var firstStudent = new Student { FirstName = "Ivan", LastName = "Ivanov", Age = 9, Grade = 4, TownSchool = school };
var secondStudent = new Student { FirstName = "Peter", LastName = "Petrov", Age = 15, Grade = 9, TownSchool = school };
var firstMark = new Mark { Subject = "Math", Value = 5, Student = firstStudent };
var secondMark = new Mark { Subject = "History", Value = 4, Student = secondStudent };
var thirdMark = new Mark { Subject = "IT", Value = 6, Student = secondStudent };
context.Marks.Add(firstMark);
context.Marks.Add(secondMark);
context.Marks.Add(thirdMark);
context.Students.Add(firstStudent);
context.Students.Add(secondStudent);
context.TownSchools.Add(school);
context.SaveChanges();
}
}
public IEnumerable<MarkModel> GetStudentMarks(int studentId)
{
var context = new SchoolContext();
var student = context.Set<Student>().Where(st => st.Id == studentId).FirstOrDefault();
IEnumerable<MarkModel> marks = student.Marks
.Select(m => new MarkModel()
{
Id = m.Id,
Subject = m.Subject,
Score = m.Score
}).ToList(); ;
return marks;
}
public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <SchoolContext, Configuration>());
using (var db = new SchoolContext())
{
var getStudents = from s in db.Students
select s.Name;
foreach (var student in getStudents)
{
Console.WriteLine(student);
}
}
}
public IQueryable<StudentModel> GetAll()
{
AddStudentsToDB();
var context = new SchoolContext();
IQueryable<StudentModel> students = context.Set<Student>()
.Select(x => new StudentModel()
{
Id = x.Id,
Fname = x.Fname,
Lname = x.Lname,
Grade = x.Grade,
Age = x.Age
}); ;
return students;
}
public object GetService(Type serviceType)
{
if (serviceType == typeof(UniversityController))
{
var context = new SchoolContext();
var repository = new DbSchoolRepository(context);
return new UniversityController(repository);
}
else if (serviceType == typeof(StudentController))
{
var context = new SchoolContext();
var repository = new DbStudentRepository(context);
return new StudentController(repository);
}
else
{
return null;
}
}
// GET api/values
public IEnumerable<StudentModel> GetAll()
{
AddStudentsToDB();
var context = new SchoolContext();
IEnumerable<StudentModel> students = context.Set<Student>().ToList()
.Select(x => new StudentModel()
{
Id = x.Id,
Fname = x.Fname,
Lname = x.Lname,
Grade = x.Grade,
Age = x.Age,
Marks = x.Marks.Select(m => new MarkModel
{
Id = m.Id,
Subject = m.Subject,
Score = m.Score
}).ToList()
}).ToList(); ;
return students;
}
public object GetService(Type serviceType)
{
var context = new SchoolContext();
if (serviceType == typeof(MarksController))
{
var repository = new DbMarksReposiotry(context);
return new MarksController(repository);
}
else if (serviceType == typeof(StudentsController))
{
var repository = new DbStudentsRepository(context);
return new StudentsController(repository);
}
else if (serviceType == typeof(TownSchoolsController))
{
var repository = new DbTownSchoolsRepository(context);
return new TownSchoolsController(repository);
}
else
{
return null;
}
}
public UniversityController()
{
var dbContext = new SchoolContext();
this.universityRepository = new DbSchoolRepository(dbContext);
}
public MarksController()
{
var dbContext = new SchoolContext();
this.markRepository = new DbMarksReposiotry(dbContext);
}
public TownSchoolsController()
{
var dbContext = new SchoolContext();
this.townSchoolRepository = new DbTownSchoolsRepository(dbContext);
}
public StudentController()
{
var dbContext = new SchoolContext();
this.studentRepository = new DbStudentRepository(dbContext);
}
private void AddStudentsToDB()
{
var context = new SchoolContext();
if (context.Set<Student>().ToList().Count == 0)
{
context.Students.Add(
new Student
{
Fname = "Doncho",
Lname = "Minkov",
Grade = 3,
Age = 25,
Marks = new List<Mark>()
{
new Mark { Subject = "Math", Score = 4 },
new Mark { Subject = "JavaScript", Score = 6 }
}
});
context.Students.Add(
new Student
{
Fname = "Nikolay",
Lname = "Kostov",
Grade = 2,
Age = 222,
Marks = new List<Mark>()
{
new Mark { Subject = "MVC", Score = 6},
new Mark { Subject = "JavaScript", Score = 5}
}
});
context.Students.Add(
new Student
{
Fname = "Ivaylo",
Lname = "Kendov",
Grade = 1,
Age = 225,
Marks = new List<Mark>()
{
new Mark { Subject = "OOP", Score = 4 },
new Mark { Subject = "C#", Score = 6 }
}
});
context.Students.Add(
new Student
{
Fname = "Georgi",
Lname = "Georgiev",
Grade = 1,
Age = 219
});
context.Students.Add(
new Student
{
Fname = "Asya",
Lname = "Georgieva",
Grade = 2,
Age = 228,
Marks = new List<Mark>()
{
new Mark { Subject = "Automation Testing", Score = 6 },
new Mark { Subject = "Manual Testing", Score = 4 }
}
});
context.SaveChanges();
}
}
