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
}
