public User_PaymentDTO GetUser_Payment(int user_paymentID)
{
bool lockWasTaken = false;
User_PaymentDTO user_paymentDTO = null;
using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) {
try {
Monitor.Enter(dbContext, ref lockWasTaken);
User_Payment user_payment = dbContext.User_Payment.Where(x => x.User_Payment_Id == user_paymentID).FirstOrDefault();
if (user_payment != null)
{
user_paymentDTO = ConvertUser_PaymentToUser_PaymentDTO(user_payment);
}
if (lockWasTaken)
{
Monitor.Exit(dbContext);
lockWasTaken = false;
}
} catch (Exception) {
if (lockWasTaken)
{
Monitor.Exit(dbContext);
lockWasTaken = false;
}
throw;
}
return(user_paymentDTO);
}
}
public IHttpActionResult GetUser_Payment(int?reservationID)
{
if (reservationID == null || reservationID == 0)
{
return(BadRequest("User_PaymentID cannot be null"));
}
User_PaymentDTO reservation = reservationSvc.GetUser_Payment((int)reservationID);
return(Ok(reservation));
}
public IHttpActionResult AddUser_Payment([FromBody] User_PaymentDTO reservationDTO)
{
if (reservationDTO == null)
{
return(BadRequest("User_PaymentDTO cannot be null"));
}
int reservationID = reservationSvc.AddUser_Payment(reservationDTO);
return(Ok(reservationID));
}
public int AddUser_Payment(User_PaymentDTO user_paymentDTO)
{
try {
User_Payment user_payment = ConvertUser_PaymentDTOToUser_Payment(user_paymentDTO);
using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) {
dbContext.User_Payment.Add(user_payment);
dbContext.SaveChanges();
}
return(user_payment.User_Payment_Id);
} catch (Exception) {
throw;
}
}
private static User_Payment ConvertUser_PaymentDTOToUser_Payment(User_PaymentDTO user_paymentDTO)
{
return(new User_Payment {
User_Payment_Id = user_paymentDTO.User_Payment_Id,
Card_Id = user_paymentDTO.Card_Id,
Creation_Date = user_paymentDTO.Creation_Date,
Payment_Method_Ref_Id = user_paymentDTO.Payment_Method_Ref_Id,
PayPal_Id = user_paymentDTO.PayPal_Id,
Card = user_paymentDTO.Card != null ? new Card()
{
Card_Id = user_paymentDTO.Card.Card_Id, Card_Number = user_paymentDTO.Card.Card_Number, Creation_Date = user_paymentDTO.Card.Creation_Date, CVC = user_paymentDTO.Card.CVC, Expiration_Date = user_paymentDTO.Card.Expiration_Date, User_Id = user_paymentDTO.Card.User_Id
} : null,
Payment_Method_Ref = user_paymentDTO.Payment_Method_Ref != null ? new Payment_Method_Ref()
{
Payment_Method_Ref_Id = user_paymentDTO.Payment_Method_Ref.Payment_Method_Ref_Id, Payment_Method = user_paymentDTO.Payment_Method_Ref.Payment_Method
} : null
});
}
