public List <Rate> rates()
{
var data = new List <Rate>();
try
{
var db = new DB();
var Query = @"select ap.id, ap.images, ap.min_price, ap.type_description, ap.num_beds, r.message_rate,r.rate, ap.free_from, ap.free_to,ap.address, ap.num_baths,ap.num_bedrooms, ap.area,ap.cost_per_person from rate r
Right JOIN apartments ap ON (r.apartment_id = ap.id)";
var cmd = new NpgsqlCommand();
cmd.CommandText = Query;
cmd.Connection = db.npgsqlConnection;
NpgsqlDataReader DataReader;
DataReader = cmd.ExecuteReader();
cmd.Dispose();
if (DataReader.HasRows)
{
while (DataReader.Read())
{
var ap = new Apartments();
ap.id = Convert.ToInt32(DataReader.GetValue(0));
ap.free_from = Convert.ToDateTime(DataReader.GetValue(7));
ap.free_to = Convert.ToDateTime(DataReader.GetValue(8));
ap.address = DataReader.GetValue(9).ToString();
var apartment = new ApartmentsDetails();
var imagestring = "<img src=' " + DataReader.GetValue(1).ToString() + " ' style='height:80px; width:80px'>";
apartment.images = imagestring;
apartment.min_price = Convert.ToSingle(DataReader.GetValue(2));
apartment.type_description = DataReader.GetValue(3).ToString();
apartment.num_beds = Convert.ToInt32(DataReader.GetValue(4));
apartment.num_baths = Convert.ToInt32(DataReader.GetValue(10));
apartment.num_bedrooms = Convert.ToInt32(DataReader.GetValue(11));
apartment.area = Convert.ToInt32(DataReader.GetValue(12));
apartment.cost_per_person = Convert.ToSingle(DataReader.GetValue(13));
apartment.apartment = ap;
var temp = 0;
if (DataReader["rate"] != DBNull.Value)
{
temp = Convert.ToInt32(DataReader.GetValue(6));
}
data.Add(new Rate
{
message_rate = DataReader.GetValue(5).ToString(),
apartment = apartment,
rate = temp
});
}
}
DataReader.Close();
DataReader.Dispose();
db.close();
data = data.OrderByDescending(a => a.apartment.min_price).ToList();
}
catch (Exception ex)
{
}
return(data);
}
private static void SetRelationalProperties()
{
foreach (var owner in Owners.Where(o => o.Id.HasValue))
{
owner.Apartments = Apartments.Where(a =>
{
if (a.OwnerId != owner.Id.Value)
{
return(false);
}
a.Owner = owner;
a.OwnerId = owner.Id.Value;
return(true);
}).ToArray();
}
foreach (var building in Buildings.Where(b => b.Id.HasValue))
{
building.Apartments = Apartments.Where(a =>
{
if (a.BuildingId != building.Id.Value)
{
return(false);
}
a.Building = building;
a.BuildingId = building.Id.Value;
return(true);
}).ToArray();
}
}
public ActionResult Edit(string Id, Apartments apartments)
{
apartments.objectId = Id;
apartments.id = new Random().Next();
_apartmentsService.Update(Id, apartments);
return(RedirectToAction(nameof(Index)));
}
public void AddReservation(Reservation reservation)
{
reservation.ReservedApartment = Apartments.Where(a => a.IsDeleted == false && a.Id == reservation.ReservedApartment.Id).FirstOrDefault();
reservation.Guest = Users.Where(u => u.IsDeleted == false && u.Username == reservation.Guest.Username).FirstOrDefault() as Guest;
Reservations.Add(reservation);
SaveChanges();
}
public async Task ManageFavorite(Apartment apartment)
{
Loading = true;
if (apartment.IsFavorite)
{
apartment.IsFavorite = false;
var favorite = DataService.Favorites.FirstOrDefault(x => x.ApartmentId == apartment.Id);
await DataService.SyncFavorites.DeleteAsync(favorite);
DataService.Favorites.Remove(favorite);
Apartments.Remove(apartment);
}
else
{
apartment.IsFavorite = true;
var favorite = new Favorite
{
Id = Guid.NewGuid().ToString(),
UserId = DataService.User.Id,
ApartmentId = apartment.Id
};
await DataService.SyncFavorites.InsertAsync(favorite);
DataService.Favorites.Add(favorite);
}
await DataService.SyncApartments.UpdateAsync(apartment);
Loading = false;
}
public void RemoveUser(string username)
{
var us = Users.SingleOrDefault(i => i.Username == username);
var apartments = Apartments.Where(i => i.Host.Username == us.Username && i.IsDeleted == false);
foreach (var item in apartments)
{
RemoveApartment(item.Id);
}
var comments = Comments.Where(c => c.IsDeleted == false && c.GuestThaWroteComment.Username == username);
foreach (var item in comments)
{
RemoveComment(item);
}
var reservations = Reservations.Where(r => r.IsDeleted == false && r.Guest.Username == username);
foreach (var item in reservations)
{
RemoveReservation(item);
}
us.IsDeleted = true;
SaveChanges();
}
public ActionResult <Apartments> Create(Apartments apartment)
{
apartment.id = new Random().Next();
_apartmentsService.Create(apartment);
return(CreatedAtRoute("Details", new { id = apartment.objectId.ToString() }, apartment));
}
public Apartments Get(int id)
{
Apartments apartment = null;
_dbRead.Execute(
"ApartmentsGetById",
new[]
{
new SqlParameter("@id", id)
},
r => apartment = new Apartments()
{
Id = Read <int>(r, "Id"),
id_Estate = Read <int>(r, "id_Estate"),
Id_StairCase = Read <int?>(r, "Id_StairCase"),
Name = Read <string>(r, "Name"),
Number = Read <int>(r, "Number"),
HasHeatHelp = Read <bool?>(r, "HasHeatHelp"),
Telephone = Read <string>(r, "Telephone"),
Password = Read <string>(r, "Password"),
Email = Read <string>(r, "Email"),
ExtraInfo = Read <string>(r, "ExtraInfo"),
Dependents = Read <int>(r, "Dependents"),
CreatedDate = Read <DateTime>(r, "CreatedDate"),
CotaIndiviza = Read <decimal?>(r, "CotaIndiviza"),
FondRulment = Read <decimal?>(r, "FondRulment"),
FondReparatii = Read <decimal?>(r, "FondReparatii")
});
return(apartment);
}
public ActionResult DeleteConfirmed(int id)
{
Apartments apartments = db.Apartments.Find(id);
db.Apartments.Remove(apartments);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public List <Apartment> GetMyApartments(long profileId)
{
return(Apartments.Where(m => m.ProfileId == profileId)
.Include(m => m.Type)
.Include(m => m.ApartmentOptions)
.Include(m => m.ApartmentPhotos.Select(k => k.Links))
.ToList());
}
public static Apartments Add(Apartments apartment)
{
var result = GetContext().Apartments.Add(apartment);
GetContext().SaveChanges();
return(result);
}
private static decimal?GetValue(Apartments apartment, int year, int month, DebtTypes debtType)
{
decimal?value = null;
int twoMonthsAgo = month - 2;
int yearOfTwoMonthsAgo = year;
if (month - 2 < 1)
{
yearOfTwoMonthsAgo = year - 1;
twoMonthsAgo = month - 2 + 12;
}
switch (debtType.Id)
{
case (int)DebtType.LunarExpense:
break;
case (int)DebtType.Restants:
value = GetAllUnpaiedOfType(apartment, yearOfTwoMonthsAgo, twoMonthsAgo + 1,
DebtType.LunarExpense).Sum(ad => ad.Value);
break;
case (int)DebtType.Penalties:
if (!apartment.Associations.penaltyRate.HasValue)
{
return(null);
}
decimal?intermediatevalue = 0m;
var apDebts = GetAllUnpaiedOfType(apartment, yearOfTwoMonthsAgo, twoMonthsAgo,
DebtType.LunarExpense);
foreach (var apDebt in apDebts)
{
if (!apDebt.Value.HasValue)
{
continue;
}
var valueToAdd = apDebt.Value.Value * 30 * apartment.Associations.penaltyRate.Value;
intermediatevalue = intermediatevalue + valueToAdd;
}
break;
case (int)DebtType.RulmentFond:
//see how we should store it
// determin date of finish
break;
case (int)DebtType.Repairfond:
//see how we should store it
// determin date of finish
break;
}
return(value);
}
public void AddApartment(Apartment apartment)
{
if (Apartments == null)
{
Apartments = new List <Apartment>();
}
Apartments.Add(apartment);
Document.SetPropertyValue("Apartments", Apartments);
}
/// <summary>
/// Добавить асинхронно нового пользователя
/// </summary>
/// <param name="aps"></param>
/// <returns></returns>
public async Task AddApartmentAsync(Apartments aps)
{
var apartmentAdd = await context.Apartments.FindAsync(aps.Id);
if (apartmentAdd == null)
{
context.Add(aps);
await context.SaveChangesAsync();
}
}
public override bool IsValid(object value)
{
Apartments validatableApartments = value as Apartments;
if (validatableApartments.Number <= 0)
{
return(false);
}
return(true);
}
public IActionResult Create(Apartments apartments)
{
if (ModelState.IsValid)
{
apartments.id = new Random().Next();
_apartmentsService.Create(apartments);
return(RedirectToAction(nameof(Index)));
}
return(View(apartments));
}
public void AddComment(Comment comment, int apartmentId)
{
var apartment = Apartments.Where(a => a.IsDeleted == false && a.Id == apartmentId).FirstOrDefault();
var guest = Users.Where(u => u.IsDeleted == false && u.Username == comment.GuestThaWroteComment.Username).FirstOrDefault() as Guest;
comment.GuestThaWroteComment = guest;
comment.Apartment = apartment;
Comments.Add(comment);
SaveChanges();
}
public void LoadApartments()
{
Apartments.Add(new Apartment(1001, "street 1", 1, "3 star",
new AparType(3, 3, 50, true, true, true, true, "very well located")));
Apartments.Add(new Apartment(1002, "street 2", 1, "3 star",
new AparType(3, 3, 50, true, true, true, true, "very well located")));
Apartments.Add(new Apartment(1003, "street 2", 1, "3 star",
new AparType(3, 3, 50, true, true, true, true, "very well located")));
Apartments.Add(new Apartment(2001, "street 1", 1, "3 star",
new AparType(3, 3, 50, true, true, true, true, "very well located")));
Apartments.Add(new Apartment(2002, "street 2", 1, "3 star",
new AparType(3, 3, 50, true, true, true, true, "very well located")));
Apartments.Add(new Apartment(2003, "street 2", 1, "3 star",
new AparType(3, 3, 50, true, true, true, true, "very well located")));
Apartments.Add(new Apartment(3001, "street 1", 1, "3 star",
new AparType(3, 3, 50, true, true, true, true, "very well located")));
Apartments.Add(new Apartment(3002, "street 2", 1, "3 star",
new FrCity {
Name = "Marseille", ImageUrl = "../assets/Marsay.jpg"
},
new AparType(3, 3, 50, true, true, true, true, "very well located"),
new Owner("id 1", "mmm", "123456")));
Apartments.Add(new Apartment(3003, "street 2", 1, "3 star",
new FrCity {
Name = "Marseille", ImageUrl = "../assets/Marsay.jpg"
},
new AparType(3, 3, 50, true, true, true, true, "very well located"),
new Owner("id 1", "ttt", "123456")));
Apartments.Add(new Apartment(4001, "street 1", 1, "3 star",
new FrCity {
Name = "Montpellie", ImageUrl = "../assets/Nice.jpg"
},
new AparType(3, 3, 50, true, true, true, true, "very well located"),
new Owner("id 1", "ggg", "123456")));
Apartments.Add(new Apartment(4002, "street 2", 1, "3 star",
new FrCity {
Name = "Nice", ImageUrl = "../assets/Nice.jpg"
},
new AparType(3, 3, 50, true, true, true, true, "very well located"),
new Owner("id 1", "sss", "123456")));
Apartments.Add(new Apartment(4003, "street 2", 1, "3 star",
new FrCity {
Name = "Lion", ImageUrl = "../assets/Nice.jpg"
},
new AparType(3, 3, 50, true, true, true, true, "very well located"),
new Owner("id 1", "xxx", "123456")));
}
internal decimal GetApartmentArea(int apartmentId)
{
var apartment = Apartments.FirstOrDefault(a => a.ApartmentId == apartmentId);
if (apartment is null)
{
throw new ArgumentNullException($"No Apartment With {apartmentId} Id Exists");
}
return(apartment.Area);
}
internal IEnumerable <(int PayerId, int DaysLived, int OccupantCount)> GetApartmentPayerResidenceInfos(DateTime from, DateTime to, int apartmentId)
{
var apartment = Apartments.FirstOrDefault(a => a.ApartmentId == apartmentId);
if (apartment is null)
{
throw new ArgumentNullException($"No Apartment With {apartmentId} Id Exists");
}
return(apartment.GetPayerResisdenceInfo(from, to));
}
private async Task Delete(int id)
{
var apartment = Apartments.FirstOrDefault(p => p.Id.Equals(id));
var confirmed = await Js.InvokeAsync <bool>("confirm", $"Are you sure you want to delete the apartment with Id: {apartment.Id}?");
if (confirmed)
{
await OnDeleted.InvokeAsync(id);
}
}
public List <ApartmentsDetails> GetApartments()
{
try
{
var db = new DB();
var Query = @"select user_id, id, address, reach_place, free_from, free_to, max_people,min_price, cost_per_person,description,num_beds,num_baths,
num_bedrooms,area,rules,images,lonlat, type_description from apartments";
var cmd = new NpgsqlCommand();
cmd.CommandText = Query;
cmd.Connection = db.npgsqlConnection;
NpgsqlDataReader DataReader;
DataReader = cmd.ExecuteReader();
cmd.Dispose();
if (DataReader.HasRows)
{
while (DataReader.Read())
{
var apartmentObject = new Apartments();
apartmentObject.id = Convert.ToInt32(DataReader.GetValue(1));
apartmentObject.address = DataReader.GetValue(2).ToString();
apartmentObject.free_from = Convert.ToDateTime(DataReader.GetValue(4));
apartmentObject.free_to = Convert.ToDateTime(DataReader.GetValue(5));
data.Add(new ApartmentsDetails
{
user_id = Convert.ToInt32(DataReader.GetValue(0)),
reach_place = DataReader.GetValue(3).ToString(),
max_people = Convert.ToInt32(DataReader.GetValue(6)),
min_price = Convert.ToSingle(DataReader.GetValue(7)),
cost_per_person = Convert.ToSingle(DataReader.GetValue(8)),
description = DataReader.GetValue(9).ToString(),
num_beds = Convert.ToInt32(DataReader.GetValue(10)),
num_baths = Convert.ToInt32(DataReader.GetValue(11)),
num_bedrooms = Convert.ToInt32(DataReader.GetValue(12)),
area = Convert.ToInt32(DataReader.GetValue(13)),
rules = DataReader.GetValue(14).ToString(),
images = DataReader.GetValue(15).ToString(),
lonlat = DataReader.GetValue(16).ToString(),
type_description = DataReader.GetValue(17).ToString(),
apartment = apartmentObject
});
}
}
DataReader.Close();
DataReader.Dispose();
data = data.OrderByDescending(a => a.user_id).ToList();
db.close();
}
catch (Exception ex)
{
}
return(data);
}
public void Add(Apartment apartment)
{
if (Apartments == null)
{
Apartments = new List <Apartment>();
}
if (Contain(apartment))
{
throw new InvalidOperationException("Apartment has already existed!");
}
Apartments.Add(apartment);
}
/// <summary>
/// Сохранение апартамента
/// </summary>
/// <param name="aps"></param>
public void SaveApartment(Apartments aps)
{
if (aps.Id == 0)
{
context.Apartments.Add(aps);
}
else
{
context.Entry(aps).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
context.SaveChanges();
}
public void EditApartment(Apartment apartment)
{
var apa = Apartments.SingleOrDefault(s => s.Id == apartment.Id);
Entry(apa).CurrentValues.SetValues(apartment);
apa.Amenities = new List <Amenities>();
foreach (var item in apartment.Amenities)
{
apa.Amenities.Add(Amenities.SingleOrDefault(s => s.Id == item.Id));
}
SaveChanges();
}
public IActionResult Edit(Apartments apartments)
{
if (ModelState.IsValid)
{
_repository.SaveApartments(apartments);
TempData["message"] = $"Номер {apartments.Number} успешно сохранен";
return(RedirectToAction("List"));
}
else
{
return(View(apartments));
}
}
public static SqlString GetStreet(SqlString address)
{
if (address.IsNull)
{
return(null);
}
if (string.IsNullOrWhiteSpace(address.Value))
{
return(null);
}
try
{
var s = address.Value.Replace(".", "");
var la = s.Split(' ').ToList();
if (AllDigits(la[0]))
{
la.RemoveAt(0);
}
if (Quadrants.Contains(la[0].ToUpper()))
{
la.RemoveAt(0);
}
la.Reverse();
if (AllDigits(la[0]))
{
la.RemoveAt(0);
}
if (la[0].StartsWith("#"))
{
la.RemoveAt(0);
}
if (Apartments.Contains(la[0].ToUpper()))
{
la.RemoveAt(0);
}
if (StreetTypes.Contains(la[0].ToUpper()))
{
la.RemoveAt(0);
}
la.Reverse();
var street = string.Join(" ", la);
return(street);
}
catch (Exception)
{
return(null);
}
}
public void RemoveUser(User user)
{
var us = Users.SingleOrDefault(i => i.Username == user.Username);
var apartments = Apartments.Where(i => i.Host.Username == us.Username && i.IsDeleted == false);
foreach (var item in apartments)
{
item.IsDeleted = true;
}
us.IsDeleted = true;
SaveChanges();
}
// GET: Apartments/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Apartments apartments = db.Apartments.Include(a => a.ApartmentType).ToList().Find(x => x.Id == id);
if (apartments == null)
{
return(HttpNotFound());
}
return(View(apartments));
}
public override bool IsValid(object value)
{
IEnumerable <Apartments> listOfApartments = db.Apartments;
Apartments validatableApartments = value as Apartments;
foreach (Apartments a in listOfApartments)
{
if (validatableApartments.Number == a.Number)
{
return(false);
}
}
return(true);
}
