public IHttpActionResult Delete([FromBody] Models.Inventory.Cars carsEntry) { try { var context = new EntityModels.Prod8Entities(); var exists = context.CARS_AVAILABILTY_CONTROL_TAB.Where(x => x.LOCATION_NO == carsEntry.LocationNo).FirstOrDefault(); if (exists == null) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound) { ReasonPhrase = "No data found. Delete Failed" }); } context.CARS_AVAILABILTY_CONTROL_TAB.Remove(exists); context.SaveChanges(); return(Ok(true)); } catch (HttpResponseException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public IHttpActionResult Save([FromBody] Models.Inventory.Cars carsEntry, bool isAdd) { if (isAdd) { return(Add(carsEntry)); } else { return(Edit(carsEntry)); } }
private IHttpActionResult Add([FromBody] Models.Inventory.Cars carsEntry) { try { var context = new EntityModels.Prod8Entities(); //add new entry if (String.IsNullOrWhiteSpace(carsEntry.LocationNo) || String.IsNullOrWhiteSpace(carsEntry.LocationNo) || String.IsNullOrWhiteSpace(carsEntry.LocationNo) || String.IsNullOrWhiteSpace(carsEntry.LocationNo)) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound) { ReasonPhrase = "One or more data fields is empty, null, or just not defined." }); } var newCar = new EntityModels.CARS_AVAILABILTY_CONTROL_TAB() { LOCATION_NO = carsEntry.LocationNo, AVAILABILITY_CONTROL_ID = carsEntry.AvailabilityControlId, REQUESTED_BY = carsEntry.RequestedBy, WAREHOUSE = carsEntry.Warehouse, ROWVERSION = DateTime.Today }; context.CARS_AVAILABILTY_CONTROL_TAB.Add(newCar); context.SaveChanges(); var car = new Models.Inventory.Cars() { LocationNo = newCar.LOCATION_NO, AvailabilityControlId = newCar.AVAILABILITY_CONTROL_ID, RequestedBy = newCar.REQUESTED_BY, Warehouse = newCar.WAREHOUSE }; return(Ok(car)); } catch (HttpResponseException ex) { throw ex; } catch (Exception ex) { throw ex; } }
private IHttpActionResult Edit([FromBody] Models.Inventory.Cars carsEntry) { try { var context = new EntityModels.Prod8Entities(); var carEntryFromDB = context.CARS_AVAILABILTY_CONTROL_TAB.Where(x => x.LOCATION_NO == carsEntry.LocationNo).FirstOrDefault(); if (carEntryFromDB == null) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound) { ReasonPhrase = "No data for this entry exists." }); } //update entry then save carEntryFromDB.LOCATION_NO = carsEntry.LocationNo; carEntryFromDB.AVAILABILITY_CONTROL_ID = carsEntry.AvailabilityControlId; carEntryFromDB.REQUESTED_BY = carsEntry.RequestedBy; carEntryFromDB.WAREHOUSE = carsEntry.Warehouse; context.SaveChanges(); var car = new Models.Inventory.Cars() { LocationNo = carEntryFromDB.LOCATION_NO, AvailabilityControlId = carEntryFromDB.AVAILABILITY_CONTROL_ID, RequestedBy = carEntryFromDB.REQUESTED_BY, Warehouse = carEntryFromDB.WAREHOUSE }; return(Ok(car)); } catch (HttpResponseException ex) { throw ex; } catch (Exception ex) { throw ex; } }