public void AddCreditCardChangeHistory(int customerID, int creditCardTypeID, string creditCardNo, string creditCardHolderName, string creditCardIDNo, DateTime creditCardExpireDate) { var ccChangeHistory = new CreditCardChangeHistory(); ccChangeHistory.CustomerID = customerID; ccChangeHistory.CreditCardTypeID = creditCardTypeID; ccChangeHistory.CreditCardNo = creditCardNo; ccChangeHistory.CreditCardHolderName = creditCardHolderName; ccChangeHistory.CreditCardExpiredDate = creditCardExpireDate; ccChangeHistory.CreditCardIDNo = creditCardIDNo; EntityHelper.SetAuditFieldForUpdate(ccChangeHistory, principal.Identity.Name); context.Add(ccChangeHistory); context.SaveChanges(); }
public void AddCreditCardChangeHistory(int customerID, int creditCardTypeID, string creditCardNo, string creditCardHolderName, string creditCardIDNo, DateTime creditCardExpireDate) { CreditCardChangeHistory ccChangeHistory = new CreditCardChangeHistory(); ccChangeHistory.CustomerID = customerID; ccChangeHistory.CreditCardTypeID = creditCardTypeID; ccChangeHistory.CreditCardNo = creditCardNo; ccChangeHistory.CreditCardHolderName = creditCardHolderName; ccChangeHistory.CreditCardExpiredDate = creditCardExpireDate; ccChangeHistory.CreditCardIDNo = creditCardIDNo; EntityHelper.SetAuditFieldForUpdate(ccChangeHistory, HttpContext.Current.User.Identity.Name); ctx.CreditCardChangeHistories.InsertOnSubmit(ccChangeHistory); ctx.SubmitChanges(); }
public void UpdateCreditCardInfo(string barcode, int creditCardTypeID, int bankID, string cardHolderName, string cardHolderIDNo, string creditCardNo, DateTime expiredDate, string reason) { Customer customer = context.Customers.SingleOrDefault(c => c.Barcode == barcode && c.BillingTypeID != 1); if (customer != null) { // ReSharper disable once InconsistentNaming CreditCardChangeHistory lastCC = context.CreditCardChangeHistories.Where(cch => cch.CustomerID == customer.ID).OrderByDescending(cch => cch.ChangedWhen).Take(1).SingleOrDefault(); if (lastCC != null) { if (lastCC.CreditCardTypeID == creditCardTypeID && lastCC.BankID == bankID && lastCC.CreditCardHolderName == cardHolderName && lastCC.CreditCardIDNo == cardHolderIDNo && lastCC.CreditCardExpiredDate == expiredDate && lastCC.CreditCardNo == creditCardNo) { throw new Exception("Cannot found any change information since last information of credit card was saved."); } } var cc = new CreditCardChangeHistory(); cc.Customer = customer; cc.CreditCardTypeID = creditCardTypeID; cc.BankID = bankID; cc.CreditCardHolderName = cardHolderName; cc.CreditCardIDNo = cardHolderIDNo; cc.CreditCardNo = creditCardNo; cc.CreditCardExpiredDate = expiredDate; cc.Reason = reason; cc.ChangedWhen = DateTime.Now; cc.ChangedWho = principal.Identity.Name; context.Add(cc); customer.BankID = bankID; customer.CreditCardTypeID = creditCardTypeID; customer.CardHolderID = cardHolderIDNo; customer.CardHolderName = cardHolderName; customer.CardNo = creditCardNo; customer.ExpiredDate = expiredDate; context.SaveChanges(); } }