public booking GetBooking(int id, int userId, int apartmentId, int dateFrom, int dateTo)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
Models.booking bookingModel = entities.bookings.FirstOrDefault(el => el.id.Equals(id) || el.customer_trr.Equals(userId) || el.apartment.id.Equals(apartmentId) ||
(el.date_from >= dateFrom && el.date_to <= dateTo));
if (bookingModel != null)
{
booking bookingObj = new booking
{
id = bookingModel.id,
date_from = bookingModel.date_from,
date_to = bookingModel.date_to,
//customer = ApartmentTypeConverter.CustomerModelToObj(bookingModel.customer),
apartment = ApartmentTypeConverter.ApartmentModelToObj(bookingModel.apartment),
status = ApartmentTypeConverter.BookingStatusStringToEnum(bookingModel.status),
discount = ApartmentTypeConverter.DiscountModelToObj(bookingModel.discount),
payment = ApartmentTypeConverter.PaymentModelToObj(bookingModel.payment_method)
};
return(bookingObj);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateBooking(booking bookingObj)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
Models.booking bookingModel = entities.bookings.FirstOrDefault(el => el.id.Equals(bookingObj.id));
if (bookingModel != null)
{
bookingModel.id = bookingObj.id;
bookingModel.date_from = bookingObj.date_from;
bookingModel.date_to = bookingObj.date_to;
bookingModel.status = bookingObj.status.ToString();
bookingModel.apartment = ApartmentTypeConverter.ApartmentObjToModel(bookingObj.apartment);
//bookingModel.customer = ApartmentTypeConverter.CustomerObjToModel(bookingObj.customer);
bookingModel.payment_method = ApartmentTypeConverter.PaymentObjToModel(bookingObj.payment);
bookingModel.discount = ApartmentTypeConverter.DiscountObjToModel(bookingObj.discount);
entities.Entry(bookingModel).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public arrangement_package[] GetPackageArrangments(int dateFrom, int dateTo)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
List <Models.arrangement_package> packageModels = entities.arrangement_package.Where(el => el.valid_from >= dateFrom && el.valid_to <= dateTo).ToList();
return(packageModels.Select(el => ApartmentTypeConverter.ArrangmentModelToObj(el)).ToArray());
}
catch (Exception ex)
{
return(null);
}
}
public int AddDiscount(discount discountObj)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
Models.discount discountModel = ApartmentTypeConverter.DiscountObjToModel(discountObj);
entities.discounts.Add(discountModel);
entities.SaveChanges();
return(discountModel.id);
}
catch (Exception ex)
{
return(-1);
}
}
public int AddPackageArrangments(arrangement_package arrangmentObj)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
Models.arrangement_package arrangmentModel = ApartmentTypeConverter.ArrangmentObjToModel(arrangmentObj);
entities.arrangement_package.Add(arrangmentModel);
entities.SaveChanges();
return(arrangmentModel.id);
}
catch (Exception ex)
{
return(-1);
}
}
public bool AddCustomer(customer customerObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.customer customerModel = ApartmentTypeConverter.CustomerObjToModel(customerObj);
entities.customers.Add(customerModel);
entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool AddDiscount(discount discountObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.discount discountModel = ApartmentTypeConverter.DiscountObjToModel(discountObj);
entities.discounts.Add(discountModel);
entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool AddPackageArrangments(arrangement_package arrangmentObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.arrangement_package arrangmentModel = ApartmentTypeConverter.ArrangmentObjToModel(arrangmentObj);
entities.arrangement_package.Add(arrangmentModel);
entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public List <Types.apartment> Search(int dateFrom, int dateTo, int numOfBeds)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
List <Models.apartment> result = entities.apartments.ToList();
if (numOfBeds != -1)
{
result = entities.apartments.Where(ap => ap.no_single_beds + ap.no_king_beds * 2 + ap.no_extra_beds >= numOfBeds).ToList();
}
if (dateFrom != -1 && dateTo != -1)
{
List <Models.apartment> tmp = entities.apartments.ToList();
foreach (Models.apartment ap in result)
{
if (ap.bookings.Count > 0)
{
Models.booking b = ap.bookings.FirstOrDefault(el => el.date_from >= dateFrom || el.date_to <= dateTo);
if (b == null)
{
tmp.Add(ap);
}
}
else
{
tmp.Add(ap);
}
}
result = tmp;
}
return(result.Select(el => ApartmentTypeConverter.ApartmentModelToObj(el)).ToList());
}
catch (Exception ex)
{
return(new List <Types.apartment>());
}
}
public customer FindCustomer(int id, string firstName, string lastName, string taxNumber)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.customer customerModel = entities.customers.FirstOrDefault(el => el.id.Equals(id) && el.first_name.Equals(firstName) && el.last_name.Equals(lastName));
if (customerModel != null)
{
return(ApartmentTypeConverter.CustomerModelToObj(customerModel));
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public List <Types.apartment> AdvancedSearch(int dateFrom, int dateTo, int numOfKingBeds, int numOfSingleBeds, int numOfExtraBeds,
bool petFriendly, bool internet, bool airContitioning, bool tv, bool kitchen,
int stars, bool balcony, bool accessable)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
List <Models.apartment> result = entities.apartments.ToList();
// filter by avilability
if (dateFrom != -1 && dateTo != -1)
{
List <Models.apartment> tmp = entities.apartments.ToList();
foreach (Models.apartment ap in result)
{
if (ap.bookings.Count > 0)
{
Models.booking b = ap.bookings.FirstOrDefault(el => el.date_from >= dateFrom || el.date_to <= dateTo);
if (b == null)
{
tmp.Add(ap);
}
}
else
{
tmp.Add(ap);
}
}
result = tmp;
}
if (numOfKingBeds != -1)
{
result = result.Where(ap => ap.no_king_beds >= numOfKingBeds).ToList();
}
if (numOfSingleBeds != -1)
{
result = result.Where(ap => ap.no_single_beds >= numOfSingleBeds).ToList();
}
if (numOfExtraBeds != -1)
{
result = result.Where(ap => ap.no_extra_beds >= numOfExtraBeds).ToList();
}
if (petFriendly)
{
result = result.Where(ap => ap.pet_friendly == true).ToList();
}
if (petFriendly)
{
result = result.Where(ap => ap.pet_friendly == true).ToList();
}
if (internet)
{
result = result.Where(ap => ap.internet == true).ToList();
}
if (airContitioning)
{
result = result.Where(ap => ap.air_conditioning == true).ToList();
}
if (tv)
{
result = result.Where(ap => ap.tv == true).ToList();
}
if (kitchen)
{
result = result.Where(ap => ap.kitchen == true).ToList();
}
if (stars != -1)
{
result = result.Where(ap => ap.class_stars >= stars).ToList();
}
if (balcony)
{
result = result.Where(ap => ap.balcony == true).ToList();
}
if (accessable)
{
result = result.Where(ap => ap.accessible == true).ToList();
}
return(result.Select(el => ApartmentTypeConverter.ApartmentModelToObj(el)).ToList());
}
catch (Exception ex)
{
return(new List <Types.apartment>());
}
}
