public static string GetRentalAccounting()
{
using (var courceProjectItems = new CourceProjectDbContext())
{
var premisesList = courceProjectItems.RentalPremises.ToList();
var adress = courceProjectItems.RentalPremises.Select(a => a.Building.Adress).ToList();
var userFullName = courceProjectItems.TenantRentalPremises.Select(a => a.FullName).ToList();
StringBuilder sb = new StringBuilder();
foreach (var item in premisesList)
{
if (item.RentalCheck == true)
{
sb.Append("Arended status: " + item.RentalCheck + "\nTenant: " +
courceProjectItems.TenantRentalPremises.Where(a => a.RentalPremisesId == item.RentalPremisesId).Select(a => a.FullName).FirstOrDefault() + "\nAdress: " +
courceProjectItems.Buildings.Where(a => a.BuildingID == item.BuildingID).Select(a => a.Adress).FirstOrDefault() + item.ToString());
sb.Append("------------------------------------------------------------\n");
}
else
{
sb.Append("Arended status: " + item.RentalCheck + "\nAdress: " +
courceProjectItems.Buildings.Where(a => a.BuildingID == item.BuildingID).Select(a => a.Adress).FirstOrDefault() + item.ToString());
sb.Append("------------------------------------------------------------\n");
}
}
return(sb.ToString());
}
}
public static int GetBackIdformDataBase(string login, int tenantRentalPremisesId)
{
using var users = new CourceProjectDbContext();
int tenantId = users.Tenants.Where(a => a.Login == login).Select(a => a.TenantId).FirstOrDefault();
return(users.TenantRentalPremises.Where(a => a.TenantId == tenantId && a.TenantRentalPremisesId < tenantRentalPremisesId).Select(a => a.RentalPremisesId).ToList().LastOrDefault());
}
public static string GetStatistic()
{
using (var courceProjectItems = new CourceProjectDbContext())
{
float profit;
float totalProfit = 0;
var premisesList = courceProjectItems.RentalPremises.ToList();
var adress = courceProjectItems.RentalPremises.Select(a => a.Building.Adress).ToList();
var userFullName = courceProjectItems.TenantRentalPremises.Select(a => a.FullName).ToList();
StringBuilder sb = new StringBuilder();
foreach (var item in premisesList)
{
if (item.RentalCheck == true)
{
profit = TotalRentalCost(item.RentalBeginDate, item.RentalEndDate, item.Price);
totalProfit += profit;
sb.Append("Arended status: " + item.RentalCheck + "\nTenant: " +
courceProjectItems.TenantRentalPremises.Where(a => a.RentalPremisesId == item.RentalPremisesId).Select(a => a.FullName).FirstOrDefault() + "\nAdress: " +
courceProjectItems.Buildings.Where(a => a.BuildingID == item.BuildingID).Select(a => a.Adress).FirstOrDefault() + item.ToString() + "Profit: " + profit + "\n");
sb.Append("------------------------------------------------------------\n");
}
else
{
sb.Append("Arended status: " + item.RentalCheck + "\nAdress: " +
courceProjectItems.Buildings.Where(a => a.BuildingID == item.BuildingID).Select(a => a.Adress).FirstOrDefault() + item.ToString() + "Profit: 0\n");
sb.Append("------------------------------------------------------------\n");
}
}
sb.Append("Total profit: " + totalProfit + "\n");
return(sb.ToString());
}
}
public static string GetRentalContract()
{
using (var courceProjectItems = new CourceProjectDbContext())
{
var tenantsRental = courceProjectItems.TenantRentalPremises.ToList();
StringBuilder sb = new StringBuilder();
float cost;
float totalCost = 0;
foreach (var item in tenantsRental)
{
cost = ArendetPremisesPageGeneration.TotalRentalCost(item.RentalPremisesId);
totalCost += cost;
sb.Append("Tenant: " + item.FullName + "\nAdress: " + item.Adress + "\nRental Number: " + item.RentalNumber +
"\nArea: " + courceProjectItems.RentalPremises.Where(a => a.RentalPremisesId == item.RentalPremisesId).Select(a => a.Area).FirstOrDefault() +
"\nPrice: " + courceProjectItems.RentalPremises.Where(a => a.RentalPremisesId == item.RentalPremisesId).Select(a => a.Price).FirstOrDefault() + "\nRental Begin Date: " +
courceProjectItems.RentalPremises.Where(a => a.RentalPremisesId == item.RentalPremisesId).Select(a => a.RentalBeginDate).FirstOrDefault() +
"\nRental End Date: " + courceProjectItems.RentalPremises.Where(a => a.RentalPremisesId == item.RentalPremisesId).Select(a => a.RentalEndDate).FirstOrDefault() +
"\nProfit: " + cost);
sb.Append("\n------------------------------------------------------------\n");
}
sb.Append("\n Total profit: " + totalCost);
return(sb.ToString());
}
}
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 RegistrationUser(string fullName, string login, string password)
{
var usersDb = new CourceProjectDbContext();
usersDb.Tenants.Add(new Tenant(fullName, login, password));
usersDb.SaveChanges();
}
public static (string, string) GetImages(int rentalPremisesId)
{
var bildings = new CourceProjectDbContext();
string rentalPremisesImage = bildings.RentalPremises.Where(a => a.RentalPremisesId == rentalPremisesId).Select(a => a.Image).FirstOrDefault();
string bildingPremisesImage = bildings.RentalPremises.Where(a => a.RentalPremisesId == rentalPremisesId).Select(a => a.Building.Image).FirstOrDefault();
return(rentalPremisesImage, bildingPremisesImage);
}
public static bool CheckRentalStatus(string login, int rentalPremisesId)
{
var buildingsItems = new CourceProjectDbContext();
var users = new CourceProjectDbContext();
int temp = users.Tenants.Where(a => a.Login == login).Select(a => a.TenantRentalPremises.Where(a => a.RentalPremisesId == rentalPremisesId)).First().Select(a => a.RentalPremisesId).First();
return(buildingsItems.RentalPremises.Where(a => a.RentalPremisesId == temp).First().RentalCheck);
}
public static float TotalRentalCost(int rentalId)
{
var rentalPremises = new CourceProjectDbContext();
string rentalBeginDate = rentalPremises.RentalPremises.Where(a => a.RentalPremisesId == rentalId).Select(a => a.RentalBeginDate).FirstOrDefault();
string rentalEndDate = rentalPremises.RentalPremises.Where(a => a.RentalPremisesId == rentalId).Select(a => a.RentalEndDate).FirstOrDefault();
float price = rentalPremises.RentalPremises.Where(a => a.RentalPremisesId == rentalId).Select(a => a.Price).FirstOrDefault();
float temp = (((DateTime.Parse(rentalEndDate).Year - DateTime.Parse(rentalBeginDate).Year) * 12) + DateTime.Parse(rentalEndDate).Month - DateTime.Parse(rentalBeginDate).Month) * price;
return(temp == 0 ? price : temp);
}
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 DataBase()
{
UserDataBase = new CourceProjectDbContext();
CoursesProjectDataBase = new CourceProjectDbContext();
CoursesProjectDataBase.Buildings.Load();
CoursesProjectDataBase.RentalPremises.Load();
UserDataBase.Accountants.Load();
UserDataBase.Administrators.Load();
UserDataBase.Owners.Load();
UserDataBase.Tenants.Load();
}
public static string GetRentalPremises(int id)
{
using (var bildings = new CourceProjectDbContext())
{
RentalPremises rentalPremises = bildings?.RentalPremises.Where(b => b.RentalPremisesId == id).FirstOrDefault();
string adress = bildings?.RentalPremises.Where(b => b.RentalPremisesId == id).Select(a => a.Building.Adress).FirstOrDefault().ToString();
return($"{adress} \n\n {rentalPremises.Price.ToString()} \n\n {rentalPremises.Area.ToString()} \n\n" +
$"{rentalPremises.RentalNumber.ToString()}");
}
}
public TenantPage(string login)
{
InitializeComponent();
_login = login;
using (var user = new CourceProjectDbContext())
{
InfoTextBox.Text = UserViewModel.GetInfoForUser(login);
}
}
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 bool CheckOldPassword(string login, string password)
{
using (var users = new CourceProjectDbContext())
{
var tenant = users.Tenants.Where(a => a.Login == login && a.Password == password).FirstOrDefault();
if (tenant != null)
{
return(true);
}
return(false);
}
}
public static bool CheckPlaceOnNull()
{
var bildings = new CourceProjectDbContext();
int temp = bildings.RentalPremises.Count();
if (temp == 0)
{
return(false);
}
else
{
return(true);
}
}
public static bool CheckBackPlaceId(int rentalPremisesId)
{
var bildings = new CourceProjectDbContext();
int temp = bildings.RentalPremises.Where(a => a.RentalPremisesId < rentalPremisesId && a.RentalCheck == false && a.RentalBeginDate == null).Count();
if (temp != 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool CheckBackPlaceId(string login, int tenantRentalPremisesId)
{
using var users = new CourceProjectDbContext();
int tenantId = users.Tenants.Where(a => a.Login == login).Select(a => a.TenantId).FirstOrDefault();
int temp = users.TenantRentalPremises.Where(a => a.TenantId == tenantId && a.TenantRentalPremisesId < tenantRentalPremisesId).Select(a => a.TenantRentalPremisesId).Count();
if (temp != 0)
{
return(true);
}
else
{
return(false);
}
}
public static string GetPriceList()
{
using (var buildingsItems = new CourceProjectDbContext())
{
var premisesList = buildingsItems.RentalPremises.ToList();
StringBuilder sb = new StringBuilder();
foreach (var item in premisesList)
{
sb.Append("Adress: " + buildingsItems.Buildings.Where(a => a.BuildingID == item.BuildingID).Select(a => a.Adress).FirstOrDefault() + "\nArea: " + item.Area + "\nPrice: " + item.Price + "\nRental Number: " + item.RentalNumber + "\n");
sb.Append("------------------------------------------------------------\n");
}
return(sb.ToString());
}
}
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 string GetTenants()
{
using (var courceProjectItems = new CourceProjectDbContext())
{
var tenantsRental = courceProjectItems.TenantRentalPremises.ToList();
StringBuilder sb = new StringBuilder();
foreach (var item in tenantsRental)
{
sb.Append("Tenant: " + item.FullName + "\nAdress: " + item.Adress + "\nRental Number: " + item.RentalNumber + "\nRental Begin Date: " +
courceProjectItems.RentalPremises.Where(a => a.RentalPremisesId == item.RentalPremisesId).Select(a => a.RentalBeginDate).FirstOrDefault() +
"\nRental End Date: " + courceProjectItems.RentalPremises.Where(a => a.RentalPremisesId == item.RentalPremisesId).Select(a => a.RentalEndDate).FirstOrDefault() + "\n");
sb.Append("------------------------------------------------------------\n");
}
return(sb.ToString());
}
}
public static string GetRentalPramses(string login)
{
using (var userItems = new CourceProjectDbContext())
{
var buildingsItems = new CourceProjectDbContext();
var premisesList = buildingsItems.RentalPremises.Where(a => a.RentalBeginDate != null && a.RentalCheck == false).ToList();
var adress = buildingsItems.RentalPremises.Where(a => a.RentalBeginDate != null && a.RentalCheck == false).Select(a => a.Building.Adress).ToList();
StringBuilder sb = new StringBuilder();
for (int i = 0; i < adress.Count; i++)
{
sb.Append("Adress: " + adress[i] + premisesList[i].ToString());
sb.Append("------------------------------------------------------------\n");
}
return(sb.ToString());
}
}
public static string GetInfoForUser(string login)
{
using (var user = new CourceProjectDbContext())
{
var users = new List <User>();
users.AddRange(user.Administrators);
users.AddRange(user.Accountants);
users.AddRange(user.Owners);
users.AddRange(user.Tenants);
foreach (var item in users)
{
if (item.Login == login)
{
return(item.ToString());
}
}
return(null);
}
}
public static User CheckAuthorization(string login, string password)
{
using (var user = new CourceProjectDbContext())
{
var users = new List <User>();
users.AddRange(user.Administrators);
users.AddRange(user.Accountants);
users.AddRange(user.Owners);
users.AddRange(user.Tenants);
foreach (var item in users)
{
if (item.Login == login && item.Password == password)
{
return(item);
}
}
return(null);
}
}
public static bool CheckLogin(string login)
{
using (var usersDb = new CourceProjectDbContext())
{
var users = new List <User>();
users.AddRange(usersDb.Administrators);
users.AddRange(usersDb.Accountants);
users.AddRange(usersDb.Owners);
users.AddRange(usersDb.Tenants);
foreach (var item in users)
{
if (item.Login == login)
{
return(false);
}
}
}
return(true);
}
public static string GetRentalPramses(string login)
{
using (var userItems = new CourceProjectDbContext())
{
var buildingsItems = new CourceProjectDbContext();
var premisesList = buildingsItems.RentalPremises.Where(a => a.RentalBeginDate != null && a.RentalCheck == false).ToList();
var adress = buildingsItems.RentalPremises.Where(a => a.RentalBeginDate != null && a.RentalCheck == false).Select(a => a.Building.Adress).ToList();
float cost;
float totalCost = 0;
StringBuilder sb = new StringBuilder();
for (int i = 0; i < adress.Count; i++)
{
cost = ArendetPremisesPageGeneration.TotalRentalCost(premisesList[i].RentalPremisesId);
totalCost += cost;
sb.Append("Adress: " + adress[i] + premisesList[i].ToString() + "Cost: " + cost + "\n");
sb.Append("------------------------------------------------------------\n");
}
sb.Append("Total Cost: " + totalCost);
return(sb.ToString());
}
}
public static int GetId()
{
using var bildings = new CourceProjectDbContext();
return(bildings.RentalPremises.Where(a => a.RentalCheck == false).FirstOrDefault().RentalPremisesId);
}
public static int GetBackIdformDataBase(int rentalPremisesId)
{
using var bildings = new CourceProjectDbContext();
return(bildings.RentalPremises.Where(a => a.RentalPremisesId < rentalPremisesId && a.RentalCheck == false && a.RentalBeginDate == null && a.RentalPremisesId != 0).ToList().Last().RentalPremisesId);
}
public static void Save()
{
using var users = new CourceProjectDbContext();
users.SaveChanges();
}
