public int EditDriverCreditCard(DriverCreditCardModel model)
 {
     Hashtable HT = new Hashtable();
     HT.Add("DriverCreditCardID", model.DriverCreditCardID);
     HT.Add("DriverID", model.DriverID);
     HT.Add("CardType", model.CardType);
     HT.Add("CardNo", model.CardNo);
     HT.Add("ExpiryDate", model.ExpiryDate);
     HT.Add("NameOnCard", model.NameOnCard);
     HT.Add("AddDate", model.AddDate);
     int i = dbContext.ExecuteSP("udp_DriverCreditCard_ups", HT);
     return i;
 }
 //insert customer
 public HttpResponseMessage Post(DriverCreditCardModel creditCard)
 {
     if (ModelState.IsValid)
     {
         db.AddDriverCreditCard(creditCard);
         HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, creditCard);
         response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = creditCard.DriverCreditCardID }));
         return response;
     }
     else
     {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
     }
 }
 //update customer
 public HttpResponseMessage Put(int id, DriverCreditCardModel creditCard)
 {
     if (!ModelState.IsValid)
     {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
     }
     if (id != creditCard.DriverCreditCardID)
     {
         return Request.CreateResponse(HttpStatusCode.BadRequest);
     }
     try
     {
         db.EditDriverCreditCard(creditCard);
     }
     catch (DbUpdateConcurrencyException ex)
     {
         return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
     }
     return Request.CreateResponse(HttpStatusCode.OK);
 }