public bool UpdateCustomer(customer customerObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.customer customerModel = entities.customers.FirstOrDefault(el => el.id.Equals(customerObj.id) &&
el.first_name.Equals(customerObj.first_name) &&
el.last_name.Equals(customerObj.last_name));
if (customerModel != null)
{
customerModel.id = customerObj.id;
customerModel.first_name = customerObj.first_name;
customerModel.last_name = customerObj.last_name;
customerModel.email = customerObj.email;
customerModel.address = customerObj.address;
customerObj.password = customerObj.password;
entities.Entry(customerModel).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateDiscoint(discount discountObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.discount discountModel = entities.discounts.FirstOrDefault(el => el.id.Equals(discountObj.id));
if (discountModel != null)
{
discountModel.id = discountObj.id;
discountModel.code = discountObj.code;
discountModel.title = discountObj.title;
discountModel.valid_to = discountObj.valid_to;
discountModel.valid_from = discountObj.valid_from;
discountModel.discount_percentage = (float)discountObj.discount_percentage;
entities.Entry(discountModel).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdatePackageArrangements(arrangement_package arrangementObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.arrangement_package arrangementModel = entities.arrangement_package.FirstOrDefault(el => el.id.Equals(arrangementObj.id));
if (arrangementModel != null)
{
arrangementModel.id = arrangementObj.id;
arrangementModel.title = arrangementObj.title;
arrangementModel.description = arrangementObj.description;
arrangementModel.max_resevations = arrangementObj.max_reservations.ToString();
arrangementModel.valid_to = arrangementObj.valid_to;
arrangementModel.valid_from = arrangementObj.valid_from;
arrangementModel.price = (float)arrangementObj.price;
entities.Entry(arrangementModel).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateBooking(booking bookingObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
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);
}
}
private void test()
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
//Models.payment_method method = new Models.payment_method { card_number = "67890", bank_payment = false, id = 1 };
Models.payment_method method = entities.payment_method.FirstOrDefault(el => el.id == 1);
method.card_number = "123";
entities.Entry(method).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
}
catch (Exception ex)
{
}
}
public bool DeleteDiscount(discount discountObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.discount discountModel = entities.discounts.FirstOrDefault(el => el.id.Equals(discountObj.id));
if (discountModel != null)
{
entities.Entry(discountModel).State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool DeletePackageArrangments(arrangement_package arrangementObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.arrangement_package arrangementModel = entities.arrangement_package.FirstOrDefault(el => el.id.Equals(arrangementObj.id));
if (arrangementModel != null)
{
entities.Entry(arrangementModel).State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateApartment(apartment apartmentObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
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 bool DeleteCustomer(customer customerObj)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.customer customerModel = entities.customers.FirstOrDefault(el => el.id.Equals(customerObj.id) &&
el.first_name.Equals(customerObj.first_name) &&
el.last_name.Equals(customerObj.last_name));
if (customerModel != null)
{
entities.Entry(customerModel).State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
