public bool CreditCardDelete(CreditCard creditcard)
        {
            return Execute<bool>(dal =>
            {
                CreditCard creditcardDelete = dal.CreditCard.Where(x => x.CreditCardID == creditcard.CreditCardID).FirstOrDefault();
                if (creditcardDelete != null)
                {
                    dal.CreditCard.DeleteOnSubmit(creditcardDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool CreditCardUpdate(CreditCard creditcard)
        {
            return Execute<bool>(dal =>
               {
               CreditCard creditcardUpdate = dal.CreditCard.Where(x => x.CreditCardID == creditcard.CreditCardID).FirstOrDefault();
               if (creditcardUpdate != null)
               {
                   creditcardUpdate.CreditCardID = creditcard.CreditCardID;
                   creditcardUpdate.CardType = creditcard.CardType;
                   creditcardUpdate.CardNumber = creditcard.CardNumber;
                   creditcardUpdate.ExpMonth = creditcard.ExpMonth;
                   creditcardUpdate.ExpYear = creditcard.ExpYear;
                   creditcardUpdate.ModifiedDate = creditcard.ModifiedDate;
                   dal.SubmitChanges();
                   return true;
               }
               return false;

               });
        }
 partial void DeleteCreditCard(CreditCard instance);
 partial void UpdateCreditCard(CreditCard instance);
 partial void InsertCreditCard(CreditCard instance);
 public void CreditCardUpdate(CreditCard creditcard)
 {
     adventureWorks_BC.CreditCardUpdate(creditcard);
 }
 public void CreditCardAdd(CreditCard creditcard)
 {
     adventureWorks_BC.CreditCardAdd(creditcard);
 }