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 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 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 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); } }
public bool AddApartment(apartment apartmentObj) { Models.ApartmentEntities entities = new Models.ApartmentEntities(); try { 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(true); } 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 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 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); } }