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.payment_method PaymentObjToModel(Types.payment_method obj)
{
Models.payment_method model = new Models.payment_method
{
id = obj.id,
card_number = obj.card_number,
bank_payment = (bool)obj.bank_payment
};
return(model);
}
public static Types.payment_method PaymentModelToObj(Models.payment_method model)
{
Types.payment_method obj = new Types.payment_method
{
id = model.id,
card_number = model.card_number,
bank_payment = (bool)model.bank_payment
};
return(obj);
}
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 HttpResponseMessage Post([FromBody] Models.payment_method objPaymentMethod, long?created_by)
{
try
{
if (string.IsNullOrEmpty(objPaymentMethod.payment_method_name))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Payment method name is Empty"
}, formatter));
}
else
{
if (paymentMethodRepository.CheckDuplicatePaymentMethod(objPaymentMethod.payment_method_name))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Payment method name Exists"
}, formatter));
}
else
{
payment_method insert_payment_method = new payment_method
{
payment_method_name = objPaymentMethod.payment_method_name,
is_active = true,
is_deleted = false,
created_by = objPaymentMethod.created_by,
created_date = DateTime.Now
};
paymentMethodRepository.InsertPaymentMethod(insert_payment_method, created_by);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Payment method save successfully"
}, formatter));
}
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
public HttpResponseMessage Delete([FromBody] Models.payment_method objPaymentMethod, long?updated_by)
{
try
{
bool deletePaymentmethod = paymentMethodRepository.DeletePaymentMethod(objPaymentMethod.payment_method_id, updated_by);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Payment method Deleted Successfully."
}, formatter));
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
public HttpResponseMessage Put([FromBody] Models.payment_method objPaymentMethod, long?updated_by)
{
try
{
if (string.IsNullOrEmpty(objPaymentMethod.payment_method_name))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Payment method name is Empty"
}, formatter));
}
else
{
payment_method update_payment_method = new payment_method
{
payment_method_id = objPaymentMethod.payment_method_id,
payment_method_name = objPaymentMethod.payment_method_name,
is_active = objPaymentMethod.is_active,
is_deleted = objPaymentMethod.is_deleted,
created_by = objPaymentMethod.created_by,
created_date = DateTime.Now
};
paymentMethodRepository.UpdatePaymentMethod(update_payment_method, updated_by);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Payment method update successfully"
}, formatter));
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
