public bool UpdateDiscoint(discount discountObj)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
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 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 static Models.discount DiscountObjToModel(Types.discount obj)
{
Models.discount model = new Models.discount
{
id = obj.id,
code = obj.code,
title = obj.title,
description = obj.description,
valid_from = obj.valid_from,
valid_to = obj.valid_to,
discount_percentage = (float)obj.discount_percentage
};
return(model);
}
public static Types.discount DiscountModelToObj(Models.discount model)
{
Types.discount obj = new Types.discount
{
id = model.id,
code = model.code,
title = model.title,
description = model.description,
valid_from = model.valid_from,
valid_to = model.valid_to,
discount_percentage = model.discount_percentage
};
return(obj);
}
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 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 int AddBooking(int user_trr, int apartmentId, int dateFrom, int dateTo, int packagArrangementId, string discountCode)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
Models.discount discountModel = entities.discounts.FirstOrDefault(el => el.code.Equals(discountCode));
Models.booking bookingModel = new Models.booking
{
date_from = dateFrom,
date_to = dateTo,
arrangement_package_id = packagArrangementId,
discounts_id = discountModel != null ? discountModel.id : -1
};
return(bookingModel.id);
}
catch (Exception ex)
{
return(-1);
}
}
public bool DeleteDiscount(int discountId)
{
Models.apartma2Entities entities = new Models.apartma2Entities();
try
{
Models.discount discountModel = entities.discounts.FirstOrDefault(el => el.id.Equals(discountId));
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 AddBooking(int userId, int apartmentId, int dateFrom, int dateTo, int packagArrangementId, string discountCode)
{
Models.ApartmentEntities entities = new Models.ApartmentEntities();
try
{
Models.discount discountModel = entities.discounts.FirstOrDefault(el => el.code.Equals(discountCode));
Models.booking bookingModel = new Models.booking
{
customer_idcustomer = userId,
date_from = dateFrom,
date_to = dateTo,
arrangement_package_id = packagArrangementId,
discounts_id = discountModel != null ? discountModel.id : -1
};
return(true);
}
catch (Exception ex)
{
return(false);
}
}
