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)); }