public IHttpActionResult PostNewEmployee(BikeTubesViewModel bt) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (var ctx = new BikeShopEntities()) { ctx.BIKETUBES.Add(new BIKETUBE() { SERIALNUMBER = bt.SERIALNUMBER, TUBENAME = bt.TUBENAME, TUBEID = bt.TUBEID, LENGTH = bt.LENGTH }); ctx.SaveChanges(); } return(Ok()); }
public IHttpActionResult GetBikeTube(int id, string tubeName) { BikeTubesViewModel bikeTubes = null; using (var ctx = new BikeShopEntities()) { bikeTubes = ctx.BIKETUBES .Where(bt => bt.SERIALNUMBER == id && bt.TUBENAME == tubeName) .Select(bt => new BikeTubesViewModel() { SERIALNUMBER = bt.SERIALNUMBER, TUBENAME = bt.TUBENAME, TUBEID = bt.TUBEID, LENGTH = bt.LENGTH }).FirstOrDefault <BikeTubesViewModel>(); } if (bikeTubes == null) { return(NotFound()); } return(Ok(bikeTubes)); }