public int AddApartment(apartment apartmentObj)
{
try
{
Models.apartma2Entities entities = new Models.apartma2Entities();
Models.apartment apartmentModel = new Models.apartment
{
accessible = apartmentObj.accessible,
air_conditioning = apartmentObj.air_conditioning,
class_stars = apartmentObj.class_stars,
description = apartmentObj.description,
latitude = (float?)apartmentObj.latitude,
longitude = (float?)apartmentObj.longitude,
no_extra_beds = apartmentObj.no_extra_beds,
no_single_beds = apartmentObj.no_single_beds,
no_king_beds = apartmentObj.no_king_beds,
tv = apartmentObj.tv,
title = apartmentObj.title,
pet_friendly = apartmentObj.pet_friendly,
internet = apartmentObj.internet,
kitchen = apartmentObj.kitchen
};
entities.apartments.Add(apartmentModel);
entities.SaveChanges();
return(apartmentModel.id);
}
catch (Exception ex)
{
return(-1);
}
}
public int MakeBooking(string user_trr, int apartmentId, int dateFrom, int dateTo, int package_arrangment_id, string discountCode, bool bank_payment)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
Models.apartment apartmentModel = entities.apartments.FirstOrDefault(el => el.id.Equals(apartmentId));
if (apartmentModel != null)
{
Models.payment_method method = new Models.payment_method();
method.bank_payment = bank_payment; // true -> e-bull; false -> card
method.card_number = user_trr.ToString();
Models.booking newBooking = new Models.booking();
newBooking.customer_trr = user_trr;
newBooking.apartment_idapartment = apartmentId;
newBooking.date_from = dateFrom;
newBooking.date_to = dateTo;
newBooking.payment_method = method;
if (bank_payment)
{
newBooking.status = "pending";
}
else
{
newBooking.status = "paid";
}
Models.arrangement_package arrangementModel = entities.arrangement_package.FirstOrDefault(el => el.id.Equals(package_arrangment_id));
Models.discount discountModel = entities.discounts.FirstOrDefault(el => el.code.Equals(discountCode));
if (arrangementModel != null)
{
newBooking.arrangement_package_id = arrangementModel.id;
}
if (discountModel != null)
{
newBooking.discounts_id = discountModel.id;
}
entities.bookings.Add(newBooking);
entities.SaveChanges();
return(newBooking.id);
}
else
{
return(-1);
}
}
catch (Exception ex)
{
return(-1);
}
}
public apartment FindApartment(int id, int numOfBeds, string apartmentNumber)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.apartment apartmentModel = entities.apartments.FirstOrDefault(el => el.id.Equals(id));
if (apartmentModel != null)
{
apartment apartmentObj = new apartment
{
id = apartmentModel.id,
title = apartmentModel.title,
description = apartmentModel.description,
latitude = (double)apartmentModel.latitude,
longitude = (double)apartmentModel.longitude,
no_king_beds = (int)apartmentModel.no_king_beds,
no_extra_beds = (int)apartmentModel.no_extra_beds,
no_single_beds = (int)apartmentModel.no_single_beds,
pet_friendly = (bool)apartmentModel.pet_friendly,
internet = (bool)apartmentModel.internet,
air_conditioning = (bool)apartmentModel.air_conditioning,
tv = (bool)apartmentModel.tv,
kitchen = (bool )apartmentModel.kitchen,
accessible = (bool)apartmentModel.accessible,
class_stars = (int)apartmentModel.class_stars
};
return(apartmentObj);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public static Models.apartment ApartmentObjToModel(Types.apartment obj)
{
Models.apartment model = new Models.apartment
{
id = obj.id,
title = obj.title,
description = obj.description,
latitude = (int)obj.latitude,
longitude = (int)obj.longitude,
no_extra_beds = (int)obj.no_extra_beds,
no_king_beds = (int)obj.no_king_beds,
no_single_beds = (int)obj.no_single_beds,
pet_friendly = (bool)obj.pet_friendly,
internet = (bool)obj.internet,
air_conditioning = (bool)obj.air_conditioning,
tv = (bool)obj.tv,
kitchen = (bool)obj.kitchen,
accessible = (bool)obj.accessible,
class_stars = (int)obj.class_stars
};
return(model);
}
public bool DeleteApartment(apartment apartmentObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.apartment apartmentModel = entities.apartments.FirstOrDefault(el => el.id.Equals(apartmentObj.id));
if (apartmentModel != null)
{
entities.Entry(apartmentModel).State = System.Data.Entity.EntityState.Deleted;
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateApartment(apartment apartmentObj)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
Models.apartment apartmentModel = entities.apartments.FirstOrDefault(el => el.id.Equals(apartmentObj.id));
if (apartmentModel != null)
{
apartmentModel.accessible = apartmentObj.accessible;
apartmentModel.air_conditioning = apartmentObj.air_conditioning;
apartmentModel.class_stars = apartmentObj.class_stars;
apartmentModel.description = apartmentObj.description;
apartmentModel.latitude = (float?)apartmentObj.latitude;
apartmentModel.longitude = (float?)apartmentObj.longitude;
apartmentModel.no_extra_beds = apartmentObj.no_extra_beds;
apartmentModel.no_single_beds = apartmentObj.no_single_beds;
apartmentModel.no_king_beds = apartmentObj.no_king_beds;
apartmentModel.tv = apartmentObj.tv;
apartmentModel.title = apartmentObj.title;
apartmentModel.pet_friendly = apartmentObj.pet_friendly;
apartmentModel.internet = apartmentObj.internet;
apartmentModel.kitchen = apartmentObj.kitchen;
entities.Entry(apartmentModel).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public static Types.apartment ApartmentModelToObj(Models.apartment model)
{
Types.apartment obj = new Types.apartment
{
id = model.id,
title = model.title,
description = model.description,
latitude = (int)model.latitude,
longitude = (int)model.longitude,
no_extra_beds = (int)model.no_extra_beds,
no_king_beds = (int)model.no_king_beds,
no_single_beds = (int)model.no_single_beds,
pet_friendly = (bool)model.pet_friendly,
internet = (bool)model.internet,
air_conditioning = (bool)model.air_conditioning,
tv = (bool)model.tv,
kitchen = (bool)model.kitchen,
accessible = (bool)model.accessible,
class_stars = (int)model.class_stars
};
return(obj);
}
