public static void RegistrationUser(string fullName, string login, string password)
{
var usersDb = new CourceProjectDbContext();
usersDb.Tenants.Add(new Tenant(fullName, login, password));
usersDb.SaveChanges();
}
public static void AddToBasket(string login, int rentalPremisesId, string rentalBeginDate, string rentalEndDate)
{
using (var userItems = new CourceProjectDbContext())
{
int tenantId = userItems.Tenants.Where(a => a.Login == login).Select(a => a.TenantId).First();
string fullName = userItems.Tenants.Where(a => a.Login == login).Select(a => a.FullName).First();
using var buildingsItems = new CourceProjectDbContext();
string adress = buildingsItems.RentalPremises.
Where(a => a.RentalPremisesId == rentalPremisesId).
Select(a => a.Building).Select(a => a.Adress).FirstOrDefault();
int rentalNumber = buildingsItems.RentalPremises.
Where(a => a.RentalPremisesId == rentalPremisesId).
Select(a => a.RentalNumber).First();
var chengeRentalPremises = buildingsItems.RentalPremises.Where(a => a.RentalPremisesId == rentalPremisesId).FirstOrDefault();
chengeRentalPremises.RentalBeginDate = rentalBeginDate;
chengeRentalPremises.RentalEndDate = rentalEndDate;
var item = new TenantRentalPremises()
{
RentalPremisesId = rentalPremisesId, TenantId = tenantId, FullName = fullName, Adress = adress, RentalNumber = rentalNumber
};
userItems.TenantRentalPremises.Add(item);
buildingsItems.SaveChanges();
userItems.SaveChanges();
}
}
public static void Change(string login, string password)
{
using (var users = new CourceProjectDbContext())
{
var tenant = users.Tenants.Where(a => a.Login == login).FirstOrDefault();
tenant.Password = password;
users.SaveChanges();
}
}
public static void AddToBasket(string login, int rentalPremisesId, string rentalBeginDate, string rentalEndDate)
{
using (var userItems = new CourceProjectDbContext())
{
var chengeRentalPremises = userItems.Tenants.Where(a => a.Login == login).Select(a => a.RentalPremises.Where(a => a.RentalPremisesId == rentalPremisesId)).FirstOrDefault().FirstOrDefault();
chengeRentalPremises.RentalBeginDate = rentalBeginDate;
chengeRentalPremises.RentalEndDate = rentalEndDate;
userItems.SaveChanges();
}
}
public static void AcceptRentalPramses()
{
var buildingsItems = new CourceProjectDbContext();
var premisesList = buildingsItems.RentalPremises.Where(a => a.RentalBeginDate != null && a.RentalCheck == false).ToList();
foreach (var item in premisesList)
{
item.RentalCheck = true;
}
buildingsItems.SaveChanges();
}
public static void СancelButton()
{
var buildingsItems = new CourceProjectDbContext();
var usersItems = new CourceProjectDbContext();
var premisesList = buildingsItems.RentalPremises.Where(a => a.RentalBeginDate != null && a.RentalCheck == false).ToList();
for (int i = 0; i < premisesList.Count; i++)
{
int temp = premisesList[i].RentalPremisesId;
usersItems.RentalPremises.Remove(usersItems.RentalPremises.Where(a => a.RentalPremisesId == temp).Select(a => a).First());
premisesList[i].RentalBeginDate = null;
premisesList[i].RentalEndDate = null;
}
usersItems.SaveChanges();
buildingsItems.SaveChanges();
}
public static void Save()
{
using var users = new CourceProjectDbContext();
users.SaveChanges();
}
