public SubmitBookingResponse Submit(int bookingId) { try { using (var db = new LomsContext()) { db.Connection.Open(); using (var transaction = db.Connection.BeginTransaction()) { var booking = db.Bookings.IncludeAll("ChargeInfo", "PaymentInfo.CreditCard", "PaymentInfo.CreditCard.Info", "PaymentInfo.CreditCard.Address", "PaymentInfo.BillingAccount", "PaymentInfo.BillingAccount.ChargeBack", "PaymentInfo.Items").FirstOrDefault(b => b.Id == bookingId); booking.Status = BookingStatus.Confirmed; db.Bookings.ApplyChanges(booking); db.SaveChanges(); var response = new SubmitBookingResponse(); response.CreatorEmails = db.AssociationUserEmails.Where(e => e.AssociationUserId == booking.CreatorId && e.IsActivated).Select(e => e.Email).ToList(); if (booking.PaymentInfo != null) { if (booking.PaymentInfo.CreditCard != null) { //add to saved billing if (!string.IsNullOrWhiteSpace(booking.PaymentInfo.CreditCard.SavedCreditCardNickname) && booking.PaymentInfo.CreditCard.SavedCreditCardId == 0) { var CreditCard = new AssociationUserCreditCard(); CreditCard.AssociationUserId = booking.PaymentInfo.AssociationUserId; CreditCard.TypeId = booking.PaymentInfo.CreditCard.TypeId; CreditCard.Holder = booking.PaymentInfo.CreditCard.Holder; CreditCard.ExpiryMonth = booking.PaymentInfo.CreditCard.ExpiryMonth; CreditCard.ExpiryYear = booking.PaymentInfo.CreditCard.ExpiryYear; CreditCard.Nickname = booking.PaymentInfo.CreditCard.SavedCreditCardNickname; db.AssociationUserCreditCards.ApplyChanges(CreditCard); db.SaveChanges(); CreditCard.Info = new AssociationUserCreditCardInfo(); CreditCard.Info.CardId = CreditCard.Id; CreditCard.Info.Number = booking.PaymentInfo.CreditCard.Info.Number; CreditCard.Info.CVC = booking.PaymentInfo.CreditCard.Info.CVC; db.AssociationUserCreditCardInfoes.ApplyChanges(CreditCard.Info); booking.PaymentInfo.CreditCard.SavedCreditCardId = CreditCard.Id; db.BookingPaymentCreditCards.ApplyChanges(booking.PaymentInfo.CreditCard); db.SaveChanges(); } //make default billing if (booking.PaymentInfo.CreditCard.SavedCrediCardIsDefaultBilling && booking.PaymentInfo.CreditCard.SavedCreditCardId != 0) { var defaultBilling = db.AssociationUserDefaultBillings.SingleOrDefault(b => b.AssociationUserId == booking.PaymentInfo.AssociationUserId); if (defaultBilling != null && defaultBilling.CreditCardId != booking.PaymentInfo.CreditCard.SavedCreditCardId) { defaultBilling.BillingAccountId = null; defaultBilling.CreditCardId = booking.PaymentInfo.CreditCard.SavedCreditCardId; } else if (defaultBilling == null) defaultBilling = new AssociationUserDefaultBilling() { AssociationUserId = booking.PaymentInfo.AssociationUserId, CreditCardId = booking.PaymentInfo.CreditCard.SavedCreditCardId }; db.AssociationUserDefaultBillings.ApplyChanges(defaultBilling); db.SaveChanges(); } } else if (booking.PaymentInfo.BillingAccount != null) { //add to saved billing if (!string.IsNullOrWhiteSpace(booking.PaymentInfo.BillingAccount.SavedBillingAccountNickname) && booking.PaymentInfo.BillingAccount.SavedBillingAccountId == 0) { var BillingAccount = new AssociationUserBillingAccount(); BillingAccount.BillingAccountId = booking.PaymentInfo.BillingAccount.BillingAccountId; BillingAccount.BillingCode = booking.PaymentInfo.BillingAccount.BillingCode; BillingAccount.Email = booking.PaymentInfo.BillingAccount.Email; BillingAccount.ContactPerson = booking.PaymentInfo.BillingAccount.ContactPerson; BillingAccount.ContactNumber = booking.PaymentInfo.BillingAccount.ContactNumber; BillingAccount.Name = booking.PaymentInfo.BillingAccount.SavedBillingAccountNickname; db.AssociationUserBillingAccounts.ApplyChanges(BillingAccount); db.SaveChanges(); booking.PaymentInfo.BillingAccount.SavedBillingAccountId = BillingAccount.Id; db.BookingPaymentBillingAccounts.ApplyChanges(booking.PaymentInfo.BillingAccount); db.SaveChanges(); } //make default billing if (booking.PaymentInfo.BillingAccount.SavedBillingAccountIsDefaultBilling && booking.PaymentInfo.BillingAccount.SavedBillingAccountId != 0) { var defaultBilling = db.AssociationUserDefaultBillings.SingleOrDefault(b => b.AssociationUserId == booking.PaymentInfo.AssociationUserId); if (defaultBilling != null && defaultBilling.BillingAccountId != booking.PaymentInfo.BillingAccount.SavedBillingAccountId) { defaultBilling.CreditCardId = null; defaultBilling.BillingAccountId = booking.PaymentInfo.BillingAccount.SavedBillingAccountId; } else if (defaultBilling == null) defaultBilling = new AssociationUserDefaultBilling() { AssociationUserId = booking.PaymentInfo.AssociationUserId, BillingAccountId = booking.PaymentInfo.BillingAccount.SavedBillingAccountId }; db.AssociationUserDefaultBillings.ApplyChanges(defaultBilling); db.SaveChanges(); } } } string issuedBy = ""; if (HttpContext.Current.User.IsInRole(RoleName.StaffUser)) issuedBy = "LIMOBOOK / STAFF"; else if (HttpContext.Current.User.IsInRole(RoleName.Client)) issuedBy = "LIMOBOOK / ONLINE"; db.BookingDispatchings.ApplyChanges( new BookingDispatching() { BookingId = booking.Id, Status = DispatchingStatus.Waiting, IssuedBy = issuedBy, IssueDate = DateTime.UtcNow } ); db.SaveChanges(); //remove original booking if (booking.OriginalId != 0) { db.Bookings.Where(b => b.Id == booking.OriginalId).ForEach(b => db.Bookings.DeleteObject(b)); db.SaveChanges(); } var paymentApi = PaymentApi.Get(CurrentAssociationId); db.BookingTransactionCreditCards.IncludeAll("Info").Where(t => t.BookingId == booking.Id && t.OrderDateTime == null).ForEach(t => { t.PaymentApi = paymentApi.Name; t.OrderNumber = booking.Id + "_" + DateTime.UtcNow.ToString("HHmmss"); t.OrderDateTime = DateTime.UtcNow; db.BookingTransactionCreditCards.ApplyChanges(t); db.SaveChanges(); //capture money if (t.OrderType == OrderType.Capture) paymentApi.Capture(t.Info.Number, t.Info.CVC, t.ExpiryYear, t.ExpiryMonth, t.OrderAmount, t.OrderNumber); else if (t.OrderType == OrderType.Refund) paymentApi.Refund(t.Info.Number, t.Info.CVC, t.ExpiryYear, t.ExpiryMonth, t.OrderAmount, t.OrderNumber, t.OriginalOrderNumber); }); transaction.Commit(); return response; } } } catch (PaymentApiException ex) { var response = new SubmitBookingResponse(); response.AddError("CreditCard", ex.ToString()); return response; } catch (Exception ex) { var response = new SubmitBookingResponse(); response.AddError("Response", ex.ToString()); return response; } }
public AssociationUserBillingAccount SaveUserBillingAccount(AssociationUserBillingAccount billingAccount) { using (var db = new LomsContext()) { db.Connection.Open(); using (var transaction = db.Connection.BeginTransaction()) { db.AssociationUserBillingAccounts.ApplyChanges(billingAccount); db.SaveChanges(); if (billingAccount.IsDefaultBilling) { var defaultBilling = db.AssociationUserDefaultBillings.SingleOrDefault(b => b.AssociationUserId == billingAccount.AssociationUserId); if (defaultBilling != null && defaultBilling.BillingAccountId != billingAccount.Id) { defaultBilling.BillingAccountId = billingAccount.Id; defaultBilling.CreditCardId = null; } else if (defaultBilling == null) defaultBilling = new AssociationUserDefaultBilling() { AssociationUserId = billingAccount.AssociationUserId, BillingAccountId = billingAccount.Id }; db.AssociationUserDefaultBillings.ApplyChanges(defaultBilling); db.SaveChanges(); } transaction.Commit(); } } using (var db = new LomsContext()) { billingAccount = db.AssociationUserBillingAccounts.IncludeAll("BillingAccount", "BillingAccount.Country").FirstOrDefault(a => a.Id == billingAccount.Id); billingAccount.IsDefaultBilling = 0 != db.AssociationUserDefaultBillings.Count(b => b.AssociationUserId == billingAccount.AssociationUserId && b.BillingAccountId == billingAccount.Id); return billingAccount; } }
public AssociationUserCreditCard SaveCreditCard(AssociationUserCreditCard card) { bool isAdd = card.Id == 0; using (var db = new LomsContext()) { db.Connection.Open(); using (var transaction = db.Connection.BeginTransaction()) { db.AssociationUserCreditCards.ApplyChanges(card); db.SaveChanges(); if (isAdd) { var info = new AssociationUserCreditCardInfo(); info.CardId = card.Id; info.Number = card.Number; info.CVC = card.CVC; db.AssociationUserCreditCardInfoes.ApplyChanges(info); db.SaveChanges(); } if (card.IsDefaultBilling) { var defaultBilling = db.AssociationUserDefaultBillings.SingleOrDefault(b => b.AssociationUserId == card.AssociationUserId); if (defaultBilling != null && defaultBilling.CreditCardId != card.Id) { defaultBilling.CreditCardId = card.Id; defaultBilling.BillingAccountId = null; } else if (defaultBilling == null) defaultBilling = new AssociationUserDefaultBilling() { AssociationUserId = card.AssociationUserId, CreditCardId = card.Id }; db.AssociationUserDefaultBillings.ApplyChanges(defaultBilling); db.SaveChanges(); } if (isAdd) { try { var paymentApi = PaymentApi.Get(CurrentAssociationId); paymentApi.PreAuth(card.Number, card.CVC, card.ExpiryYear, card.ExpiryMonth, "cc" + card.Id + "_" + DateTime.UtcNow.ToString("HHmmss")); } catch (Exception ex) { card.AddError("Entity", ex.Message); return card; } } transaction.Commit(); } } using (var db = new LomsContext()) { card = db.AssociationUserCreditCards.IncludeAll("Info").FirstOrDefault(a => a.Id == card.Id); card.Number = AssociationUserCreditCard.ObfuscateCreditCardNumber(card.Info.Number); card.Info = null; card.IsDefaultBilling = 0 != db.AssociationUserDefaultBillings.Count(b => b.AssociationUserId == card.AssociationUserId && b.CreditCardId == card.Id); card.AcceptChanges(); return card; } }
public bool Equals(AssociationUserDefaultBilling other) { if (ReferenceEquals(null, other)) return false; if (ReferenceEquals(this, other)) return true; if (other.AssociationUserId == 0 && AssociationUserId == 0) return false; else return other.AssociationUserId == AssociationUserId; }
public AssociationUserCreditCard SaveCreditCard(AssociationUserCreditCard card) { bool isAdd = card.Id == 0; using (var db = new LomsContext()) { db.Connection.Open(); using (var transaction = db.Connection.BeginTransaction()) { db.AssociationUserCreditCards.ApplyChanges(card); db.SaveChanges(); if (isAdd) { var info = new AssociationUserCreditCardInfo(); info.CardId = card.Id; info.Number = card.Number; info.CVC = card.CVC; db.AssociationUserCreditCardInfoes.ApplyChanges(info); db.SaveChanges(); } if (card.IsDefaultBilling) { var defaultBilling = db.AssociationUserDefaultBillings.SingleOrDefault(b => b.AssociationUserId == card.AssociationUserId); if (defaultBilling != null && defaultBilling.CreditCardId != card.Id) { defaultBilling.BillingAccountId = null; defaultBilling.CreditCardId = card.Id; } else if (defaultBilling == null) defaultBilling = new AssociationUserDefaultBilling() { AssociationUserId = card.AssociationUserId, CreditCardId = card.Id }; db.AssociationUserDefaultBillings.ApplyChanges(defaultBilling); db.SaveChanges(); } transaction.Commit(); } } using (var db = new LomsContext()) { card = db.AssociationUserCreditCards.IncludeAll("Info").FirstOrDefault(a => a.Id == card.Id); card.Number = ObfuscateCreditCardNumber(card.Info.Number); card.Info = null; card.AcceptChanges(); return card; } }
private void FixupDefaultBilling(AssociationUserDefaultBilling previousValue) { // This is the principal end in an association that performs cascade deletes. // Update the event listener to refer to the new dependent. if (previousValue != null) { ChangeTracker.ObjectStateChanging -= previousValue.HandleCascadeDelete; } if (DefaultBilling != null) { ChangeTracker.ObjectStateChanging += DefaultBilling.HandleCascadeDelete; } if (IsDeserializing) { return; } if (DefaultBilling != null) { DefaultBilling.AssociationUserId = Id; } if (ChangeTracker.ChangeTrackingEnabled) { if (ChangeTracker.OriginalValues.ContainsKey("DefaultBilling") && (ChangeTracker.OriginalValues["DefaultBilling"] == DefaultBilling)) { ChangeTracker.OriginalValues.Remove("DefaultBilling"); } else { ChangeTracker.RecordOriginalValue("DefaultBilling", previousValue); // This is the principal end of an identifying association, so the dependent must be deleted when the relationship is removed. // If the current state of the dependent is Added, the relationship can be changed without causing the dependent to be deleted. if (previousValue != null && previousValue.ChangeTracker.State != ObjectState.Added) { previousValue.MarkAsDeleted(); } } if (DefaultBilling != null && !DefaultBilling.ChangeTracker.ChangeTrackingEnabled) { DefaultBilling.StartTracking(); } } }