static void Main(string[] args) { using (var db = new UniversityResidenceDbContext(_connectionString)) { var employeeRepository = new EmployeeRepository(db); employeeRepository.GetWorksAs("Kuhar/ica").ForEach(e => Console.WriteLine($"{e.FirstName} {e.LastName}")); var residenceHallRepository = new ResidenceHallRepository(db); var hall = new ResidenceHall() { Name = "Novi dom", Adress = "negdje je" }; // residenceHallRepository.Add(hall); /*var h = residenceHallRepository.Get(hall.Id); * residenceHallRepository.Remove(h);*/ var studentRepository = new StudentRepository(db); var roomRepository = new RoomRepository(db); var stud = studentRepository.Get("00250724081"); if (stud.FindARoom(roomRepository)) { studentRepository.Update(stud); } } }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { // Add framework services. services.AddMvc(); // Add data references services.AddScoped <UniversityResidenceDbContext>(db => { var context = new UniversityResidenceDbContext(Configuration.GetConnectionString("DefaultConnection")); // context.ClearData(); // call this when you mess up the data // context.GenerateData(); // call the first time to fill database return(context); }); services.AddTransient <IEmployeeRepository, EmployeeRepository>(); services.AddTransient <IResidenceHallRepository, ResidenceHallRepository>(); services.AddTransient <IRoomRepository, RoomRepository>(); services.AddTransient <IStudentRepository, StudentRepository>(); }
protected GenericRepository(UniversityResidenceDbContext context, IDbSet <T> table) { _context = context; _table = table; }
public RoomRepository(UniversityResidenceDbContext context) : base(context, context.Rooms) { }
public ResidenceHallRepository(UniversityResidenceDbContext context) : base(context, context.Halls) { }
public EmployeeRepository(UniversityResidenceDbContext context) : base(context, context.Employees) { }
public StudentRepository(UniversityResidenceDbContext context) : base(context, context.Students) { }