public async Task <IActionResult> UpdateHousingDataObject(long id, HousingDataDTO housingDataDTO) { if (id != housingDataDTO.ID) { return(BadRequest()); } //_context.Entry(housingDataObject).State = EntityState.Modified;Original Project Code Generated This. var houseDataObject = await _context.HousingDataObjects.FindAsync(id); if (houseDataObject == null) { return(NotFound()); } //Database Columns that match the Object. houseDataObject.ID = housingDataDTO.ID; houseDataObject.Longitude = housingDataDTO.Longitude; houseDataObject.Latitude = housingDataDTO.Latitude; houseDataObject.Housing_Median_Age = housingDataDTO.Housing_Median_Age; houseDataObject.Total_Rooms = housingDataDTO.Total_Rooms; houseDataObject.Bedrooms = housingDataDTO.Bedrooms; houseDataObject.Population = housingDataDTO.Population; houseDataObject.HouseHolds = housingDataDTO.HouseHolds; houseDataObject.Median_Income = housingDataDTO.Median_Income; houseDataObject.Median_House_Value = housingDataDTO.Median_House_Value; houseDataObject.Ocean_Proximity = housingDataDTO.Ocean_Proximity; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!HousingDataObjectExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <HousingDataDTO> > CreateHousingDataObject(HousingDataDTO housingDataDTO) { var housingDataObject = new HousingDataObject { ID = housingDataDTO.ID, Longitude = housingDataDTO.Longitude, Latitude = housingDataDTO.Latitude, Housing_Median_Age = housingDataDTO.Housing_Median_Age, Total_Rooms = housingDataDTO.Total_Rooms, Bedrooms = housingDataDTO.Bedrooms, Population = housingDataDTO.Population, HouseHolds = housingDataDTO.HouseHolds, Median_Income = housingDataDTO.Median_Income, Median_House_Value = housingDataDTO.Median_House_Value, Ocean_Proximity = housingDataDTO.Ocean_Proximity //More Database Columns go here... }; _context.HousingDataObjects.Add(housingDataObject); await _context.SaveChangesAsync(); //return CreatedAtAction("GetHousingDataObject", new { id = housingDataObject.ID }, housingDataObject);//Originally Generated Code Piece return(CreatedAtAction(nameof(GetHousingDataObject), new { id = housingDataObject.ID }, HousingDataToDTO(housingDataObject)));//Web API Doc Code Piece }