private static void GetAllRentalObjectsWithOnePhoto()
{
Console.WriteLine("\n\nRental objects");
using (var context = new CabinContext())
{
var cabins = (from r in context.RentalObjects
join p in context.Photos on r.Id equals p.RentalObjectId
join a in context.Addresses on r.AddressId equals a.Id
where r.Photos.Count == 1
select new {
r,
p,
a
})
.ToList();
foreach (var cabin in cabins)
{
var weekStr = "";
var o = cabin.r;
Console.WriteLine("\n\n" + o.Description);
Console.WriteLine(o.Address.StreetAddress + ", " + o.Address.City);
Console.WriteLine("Number of Photos: " + o.Photos.Count());
}
}
}
private static void AddBooking()
{
//parameters
var weekId = 74;
var rentalObjectId = 1;
var context = new CabinContext();
var person = context.Persons.Where(x => x.LastName == "Bernadotte").FirstOrDefault();
var rObj = context.RentalObjectWeeks
.Include(x => x.RentalObject)
.Where(x => x.Booking == null && x.WeekId == weekId && x.RentalObjectId == rentalObjectId).FirstOrDefault();
rObj.Booking = new Booking
{
Person = person
};
var i = context.SaveChanges();
Console.WriteLine(String.Format("Added {0} booking", i));
}
private static void AddAvailableWeeksToObject()
{
//Parameters
var wId = new List <int> {
79, 80, 81, 82
};
var context = new CabinContext();
var obj = context.RentalObjects
.Where(x => x.Id == 2)
.Include(x => x.AvailableWeeks)
.Single();
foreach (var w in wId)
{
obj.AvailableWeeks.Add(new RentalObjectWeek
{
WeekId = w,
});
}
var i = context.SaveChanges();
Console.WriteLine(String.Format("Added {0} weeks available for rent", i));
}
private static void SearchAvailableObjectsByAddress(string searchStr)
{
var context = new CabinContext();
searchStr = searchStr.ToLower();
var cabins = context.RentalObjectWeeks
.Where(x => x.BookingId == null)
.Where(x => x.RentalObject.Address.City.Contains(searchStr))
.Include(x => x.RentalObject)
.ThenInclude(x => x.Address)
.Include(x => x.Week)
.OrderBy(x => x.Week)
.GroupBy(x => x.Week.NoWeek)
.ToList();
if (cabins != null)
{
Console.WriteLine("\n\nAvailable Weeks & Cabins");
}
foreach (var cabin in cabins)
{
foreach (var obj in cabin)
{
var c = obj.RentalObject;
Console.WriteLine("\nWeek: " + obj.Week.NoWeek + " " + obj.Week.Year.ToString("yyyy"));
Console.WriteLine(c.Description);
Console.WriteLine("Address: " + c.Address.StreetAddress + ", " + c.Address.City);
}
}
}
private static void DeletePerson()
{
//parameters
var id = 4;
var context = new CabinContext();
var person = context.Persons.Find(4);
context.Persons.Remove(person);
context.SaveChanges();
}
private static void AddAvailableWeekToObject()
{
//Parameters
var wId = 78;
var context = new CabinContext();
var obj = context.RentalObjects
.Where(x => x.Id == 2)
.Include(x => x.AvailableWeeks)
.Single();
obj.AvailableWeeks.Add(new RentalObjectWeek
{
WeekId = wId,
});
var i = context.SaveChanges();
Console.WriteLine(String.Format("Added {0} week available for rent", i));
}
private static void GetAllBookings()
{
var context = new CabinContext();
var bookings = context.Bookings
.Include(x => x.BookedWeeks)
.ThenInclude(x => x.RentalObject)
.Include(x => x.BookedWeeks)
.ThenInclude(x => x.Week)
.Include(x => x.Person)
.ToList();
foreach (var b in bookings)
{
Console.WriteLine("\nBookingId: " + b.Id);
Console.WriteLine(b.Person.FirstName + " " + b.Person.LastName);
foreach (var bw in b.BookedWeeks)
{
Console.WriteLine(bw.RentalObject.Description);
Console.WriteLine("Week: " + bw.Week.NoWeek + " " + bw.Week.Year.ToString("yyyy"));
Console.WriteLine(bw.Price + "SEK");
}
}
}
public Seeder(CabinContext context)
{
_context = context;
}
