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