public IHttpActionResult PostNewBicycleTubeUsage(BicycleTubeUsageViewModel btu)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest("Invalid data."));
            }

            using (var ctx = new BikeShopEntities())
            {
                ctx.BICYCLETUBEUSAGEs.Add(new BICYCLETUBEUSAGE()
                {
                    SERIALNUMBER = btu.SERIALNUMBER,
                    TUBEID       = btu.TUBEID,
                    QUANTITY     = btu.QUANTITY
                });

                ctx.SaveChanges();
            }
            return(Ok());
        }
        public IHttpActionResult GetBicycleTubeUsage(int id)
        {
            BicycleTubeUsageViewModel bicycleTubeUsage = null;

            using (var ctx = new BikeShopEntities())
            {
                bicycleTubeUsage = ctx.BICYCLETUBEUSAGEs
                                   .Where(btu => btu.SERIALNUMBER == id)
                                   .Select(btu => new BicycleTubeUsageViewModel()
                {
                    SERIALNUMBER = btu.SERIALNUMBER,
                    TUBEID       = btu.TUBEID,
                    QUANTITY     = btu.QUANTITY
                }).FirstOrDefault <BicycleTubeUsageViewModel>();
            }
            if (bicycleTubeUsage == null)
            {
                return(NotFound());
            }
            return(Ok(bicycleTubeUsage));
        }