public async Task <IHttpActionResult> GetMBL_SightDetails(int id) { MBL_SightDetails mBL_SightDetails = await db.MBL_SightDetails.FindAsync(id); if (mBL_SightDetails == null) { return(NotFound()); } return(Ok(mBL_SightDetails)); }
public async Task <IHttpActionResult> PostMBL_SightDetails(SightingData postData) { try { //This is currently redundant, as user cannot enter a location on UI. They have to manually select one from the drop-down. int locationID; if (!int.TryParse(postData.locationSelected.ToString(), out locationID)) { //it's a new location, add it to location lookup LocationLookup locationEntity = new LocationLookup() { Name = postData.locationSelected.ToString(), GridReference = postData.gridReference, boolManuallyAddedRecord = true, boolApprovedByAdmin = false }; db.LocationLookups.Add(locationEntity); db.SaveChanges(); //get new location ID locationID = locationEntity.LocationID; } //convert date time from web page into SQL format DateTime tempSightDate = Convert.ToDateTime(postData.dt); DateTime tempSightTime = Convert.ToDateTime(postData.myTime); DateTime sightDate = tempSightDate.Date; TimeSpan sightTime = tempSightTime.TimeOfDay; DateTime sightDateTime = sightDate.Date.Add(sightTime); var newSightDetails = new MBL_SightDetails { SightReportUserID = postData.sightReportUserID, LocationID = locationID, GridReference = postData.gridReference, SightDateTime = sightDateTime, SubmitDateTime = DateTime.Now }; db.MBL_SightDetails.Add(newSightDetails); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = newSightDetails.SightDetailsID }, newSightDetails)); } catch (Exception ex) { var error = ex.InnerException.Message; return(BadRequest("Error saving Sight details - " + error)); } }
public async Task <IHttpActionResult> DeleteMBL_SightDetails(int id) { MBL_SightDetails mBL_SightDetails = await db.MBL_SightDetails.FindAsync(id); if (mBL_SightDetails == null) { return(NotFound()); } db.MBL_SightDetails.Remove(mBL_SightDetails); await db.SaveChangesAsync(); return(Ok(mBL_SightDetails)); }