public IHttpActionResult GetBikePart(int serialNumber, int componentID) { BikePartsViewModel bikeParts = null; using (var ctx = new BikeShopEntities()) { bikeParts = ctx.BIKEPARTS .Where(bp => bp.SERIALNUMBER == serialNumber && bp.COMPONENTID == componentID) .Select(bp => new BikePartsViewModel() { SERIALNUMBER = bp.SERIALNUMBER, COMPONENTID = bp.COMPONENTID, SUBSTITUTEID = bp.SUBSTITUTEID, LOCATION = bp.LOCATION, QUANTITY = bp.QUANTITY, DATEINSTALLED = bp.DATEINSTALLED, EMPLOYEEID = bp.EMPLOYEEID }).FirstOrDefault <BikePartsViewModel>(); } if (bikeParts == null) { return(NotFound()); } return(Ok(bikeParts)); }
public IHttpActionResult PostNewBikePart(BikePartsViewModel bp) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (var ctx = new BikeShopEntities()) { ctx.BIKEPARTS.Add(new BIKEPART() { SERIALNUMBER = bp.SERIALNUMBER, COMPONENTID = bp.COMPONENTID, SUBSTITUTEID = bp.SUBSTITUTEID, LOCATION = bp.LOCATION, QUANTITY = bp.QUANTITY, DATEINSTALLED = bp.DATEINSTALLED, EMPLOYEEID = bp.EMPLOYEEID }); ctx.SaveChanges(); } return(Ok()); }