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