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 }); }