//insert customer
 public HttpResponseMessage Post(BookingShareModel customer)
 {
     if (ModelState.IsValid)
     {
         db.AddBookingShare(customer);
         HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, customer);
         response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = customer.BookingShareID }));
         return response;
     }
     else
     {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
     }
 }
 public int EditBookingShare(BookingShareModel model)
 {
     Hashtable HT = new Hashtable();
     HT.Add("BookingShareID", model.BookingShareID);
     HT.Add("PassengerID", model.PassengerID);
     HT.Add("BookingType", model.BookingType);
     HT.Add("VehicalType", model.VehicalType);
     HT.Add("PickupPoint", model.PickupPoint);
     HT.Add("DestinationPoint", model.DestinationPoint);
     HT.Add("PickupTime", model.PickupTime);
     HT.Add("DropTime", model.DropTime);
     HT.Add("ServiceDate", model.ServiceDate);
     HT.Add("ShareDate", model.ShareDate);
     HT.Add("Amount", model.Amount);
     HT.Add("DriverTip", model.DriverTip);
     HT.Add("nWayPaid", model.nWayPaid);
     int i = dbContext.ExecuteSP("udp_BookingShare_ups", HT);
     return i;
 }
 //update customer
 public HttpResponseMessage Put(int id, BookingShareModel customer)
 {
     if (!ModelState.IsValid)
     {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
     }
     if (id != customer.BookingShareID)
     {
         return Request.CreateResponse(HttpStatusCode.BadRequest);
     }
     try
     {
         db.EditBookingShare(customer);
     }
     catch (DbUpdateConcurrencyException ex)
     {
         return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
     }
     return Request.CreateResponse(HttpStatusCode.OK);
 }