public NewRentedPlace(int rentalPremisesId) { using (var bildings = new BildingsDbContext()) { RentalPremises = bildings.RentalPremises.Where(b => b.RentalPremisesId == rentalPremisesId).First(); Adress = bildings.RentalPremises.Where(b => b.RentalPremisesId == rentalPremisesId).Select(a => a.Building.Adress).First().ToString(); } }
public static (string, string) GetImages(string login) { var users = new UsersDbContext(); int tenantRentalPremisesId = users.Tenants.Where(a => a.Login == login).Select(a => a.TenantRentalPremises.FirstOrDefault().TenantRentalPremisesId).First(); var bildings = new BildingsDbContext(); string rentalPremisesImage = bildings.RentalPremises.Where(a => a.RentalPremisesId == tenantRentalPremisesId).Select(a => a.Image).FirstOrDefault(); string bildingPremisesImage = bildings.RentalPremises.Where(a => a.RentalPremisesId == tenantRentalPremisesId).Select(a => a.Building.Image).FirstOrDefault(); return(rentalPremisesImage, bildingPremisesImage); }
public ViewModel() { UserDataBase = new UsersDbContext(); CoursesProjectDataBase = new BildingsDbContext(); CoursesProjectDataBase.Buildings.Load(); CoursesProjectDataBase.RentalPremises.Load(); UserDataBase.Accountants.Load(); UserDataBase.Administrators.Load(); UserDataBase.Owners.Load(); UserDataBase.Tenants.Load(); UserDataBase.TenantRentalPremises.Load(); }
public MainWindow() { InitializeComponent(); Frame.Navigate(new AuthorizationPage()); /* * var temp = new List<Tenant>(); * var temp1 = new List<User>(); * * using (var ctx = new UsersDbContext()) * { * var stud = new Tenant() { Login = "******", FullName = "Putin V V", Password = "******", RetalPremisesId = { 1, 2, 3 }, Balance = 50 }; * ctx.Tenants.Add(stud); * * ctx.SaveChanges(); * }*/ using (var ctx = new BildingsDbContext()) {/* * var stud = new Building() { Adress = "Gromova", Image = "1.png" }; * ctx.Buildings.Add(stud); * * var stud1 = new RentalPremises() { Area = 45, RentalNumber = 1, Image = "2.png", BuildingID = 1 }; * ctx.RentalPremises.Add(stud1); * * var stud2 = new PriceList(); * ctx.PriceLists.Add(stud2); * * ctx.SaveChanges(); */ // var f = ctx.PriceLists.Where(b => b.RentalPremises.RentalPremisesId == 1).Select(a => a.RentalPremises.Building.Adress); // MessageBox.Show(f.FirstOrDefault()); } }