public void AddApartmentPhoto(Apartment apartment, ApartmentPhoto photo)
{
Apartment Apartment = context
.Apartments
.Include(m => m.ApartmentPhotos)
.Include(m => m.DefaultPhoto)
.Where(m => m.ApartmentId == apartment.ApartmentId)
.FirstOrDefault();
Apartment.ApartmentPhotos.Add(photo);
context.SaveChanges();
if (Apartment.DefaultPhoto == null)
{
SetApartmentDefaultPhoto(Apartment, photo);
}
}
public void AddOption(Apartment aparment, ApartmentOption option)
{
ApartmentOption Option = context.ApartmentOptions.Find(option.ApartmentOptionId);
Apartment Apartment = context.Apartments.Include(m => m.ApartmentOptions).Where(m => m.ApartmentId == aparment.ApartmentId).FirstOrDefault();
if ((Apartment != null) && (Option != null) && (!Apartment.ApartmentOptions.Contains(Option)))
{
Apartment.ApartmentOptions.Add(Option);
context.SaveChanges();
}
}
public void AddApartment(Apartment apartment)
{
context.Apartments.Add(apartment);
context.SaveChanges();
}
public void UpdateCoords(Apartment apartment, ApartmentCoords coords)
{
Apartment Apartment = context
.Apartments
.Where(m => m.ApartmentId == apartment.ApartmentId).FirstOrDefault();
if (Apartment != null)
{
Apartment.Latitude = coords.Latitude;
Apartment.Longitude = coords.Longitude;
context.SaveChanges();
}
}
public void UpdateApartment(Apartment apartment)
{
context.Apartments.AddOrUpdate(e => e.ApartmentId, apartment);
context.SaveChanges();
}
public void SetApartmentDefaultPhoto(Apartment apartment, ApartmentPhoto photo)
{
Apartment Apartment = context
.Apartments
.Include(m => m.ApartmentPhotos)
.Where(m => m.ApartmentId == apartment.ApartmentId)
.FirstOrDefault();
Apartment.DefaultPhoto = photo;
context.SaveChanges();
}
public List<ApartmentPhoto> GetApartmentPhotos(Apartment apartment)
{
List<ApartmentPhoto> result = context
.Apartments
.Where(m => m.ApartmentId == apartment.ApartmentId)
.SelectMany(m => m.ApartmentPhotos).ToList();
return result;
}
public void ClearApartmentOptions(Apartment apartment)
{
Apartment clearApartment = context.Apartments.Include(m => m.ApartmentOptions).Where(m => m.ApartmentId == apartment.ApartmentId).FirstOrDefault();
List<ApartmentOption> AllOptions = clearApartment.ApartmentOptions.ToList();
foreach (ApartmentOption option in AllOptions)
{
RemoveOption(clearApartment, option);
}
context.SaveChanges();
}