//insert customer
 public HttpResponseMessage Post(DriverFareOfferModel fareOffer)
 {
     if (ModelState.IsValid)
     {
         db.AddDriverFareOffer(fareOffer);
         HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, fareOffer);
         response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = fareOffer.DriverFareOfferID}));
         return response;
     }
     else
     {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
     }
 }
 public int EditDriverFareOffer(DriverFareOfferModel model)
 {
     Hashtable HT = new Hashtable();
     HT.Add("DriverFareOfferID", model.DriverFareOfferID);
     HT.Add("DriverID", model.DriverID);
     HT.Add("OfferFrom", model.OfferFrom);
     HT.Add("OfferTo", model.OfferTo);
     HT.Add("Details", model.Details);
     HT.Add("CrDate", model.CrDate);
     HT.Add("Status", model.Status);
     HT.Add("UserName", model.UserName);
     HT.Add("Fare", model.Fare);
     int i = dbContext.ExecuteSP("udp_DriverFareOffer_ups", HT);
     return i;
 }
 //update customer
 public HttpResponseMessage Put(int id, DriverFareOfferModel fareOffer)
 {
     if (!ModelState.IsValid)
     {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
     }
     if (id != fareOffer.DriverFareOfferID)
     {
         return Request.CreateResponse(HttpStatusCode.BadRequest);
     }
     try
     {
         db.EditDriverFareOffer(fareOffer);
     }
     catch (DbUpdateConcurrencyException ex)
     {
         return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
     }
     return Request.CreateResponse(HttpStatusCode.OK);
 }