// PUT api/<controller>/5
public HttpResponseMessage Put(int id, [FromBody] Planting planting)
{
try
{
var dbQuery = from p in Context.Plantings
.Include(p => p.PlantingCrops.Select(pc => pc.MetricUnit))
.Include(p => p.PlantingCrops.Select(pc => pc.Crop))
.Include(p => p.PlantingFertilizers.Select(pa => pa.MetricUnit))
.Include(p => p.PlantingFertilizers.Select(pa => pa.Fertilizer))
.Include(p => p.Yields)
.Include(p => p.Yields.Select(py => py.MetricUnit))
.Where(p => p.Id == id)
select p;
var existingRecord = dbQuery.FirstOrDefault();
Context.Entry(existingRecord).CurrentValues.SetValues(planting);
if (existingRecord != null)
{
existingRecord.Season = planting.Season;
#region Update PlantingCrops
var plantingCropsToRemove = existingRecord.PlantingCrops.Where(existingPlantingCrop => planting.PlantingCrops.All(pc => !ObjectComparisonHelper.AreEqual(pc, existingPlantingCrop))).ToList();
if (plantingCropsToRemove.Count > 0)
{
foreach (var plantingCropToRemove in plantingCropsToRemove)
{
existingRecord.PlantingCrops.Remove(plantingCropToRemove);
}
}
foreach (var plantingCrop in planting.PlantingCrops)
{
if (existingRecord.PlantingCrops.All(pc => !ObjectComparisonHelper.AreEqual(pc, plantingCrop)))
{
plantingCrop.Crop = Context.Crops.FirstOrDefault(c => c.Id == plantingCrop.Crop.Id);
plantingCrop.MetricUnit = Context.MetricUnits.FirstOrDefault(mu => mu.Id == plantingCrop.MetricUnit.Id);
existingRecord.PlantingCrops.Add(plantingCrop);
}
}
#endregion
#region Update PlantingFertilizers
var plantingFertilizersToRemove = existingRecord.PlantingFertilizers.Where(existingPlantingFertilizer => planting.PlantingFertilizers.All(pf => !ObjectComparisonHelper.AreEqual(pf, existingPlantingFertilizer))).ToList();
if (plantingFertilizersToRemove.Count > 0)
{
foreach (var plantingFertilizerToRemove in plantingFertilizersToRemove)
{
existingRecord.PlantingFertilizers.Remove(plantingFertilizerToRemove);
}
}
foreach (var plantingFertilizer in planting.PlantingFertilizers)
{
if (existingRecord.PlantingFertilizers.All(pf => !ObjectComparisonHelper.AreEqual(pf, plantingFertilizer)))
{
plantingFertilizer.Fertilizer = Context.Fertilizers.FirstOrDefault(c => c.Id == plantingFertilizer.Fertilizer.Id);
plantingFertilizer.MetricUnit = Context.MetricUnits.FirstOrDefault(mu => mu.Id == plantingFertilizer.MetricUnit.Id);
existingRecord.PlantingFertilizers.Add(plantingFertilizer);
}
}
#endregion
#region Update Yields
var yieldsToRemove = existingRecord.Yields.Where(existingYield => planting.Yields.All(y => !ObjectComparisonHelper.AreEqual(y, existingYield))).ToList();
if (yieldsToRemove.Count > 0)
{
foreach (var yieldToRemove in yieldsToRemove)
{
existingRecord.Yields.Remove(yieldToRemove);
}
}
foreach (var yield in planting.Yields)
{
if (existingRecord.Yields.All(y => !ObjectComparisonHelper.AreEqual(y, yield)))
{
yield.MetricUnit = Context.MetricUnits.FirstOrDefault(mu => mu.Id == yield.MetricUnit.Id);
existingRecord.Yields.Add(yield);
}
}
#endregion
var tempParcel = Context.Parcels.Include(p => p.ParcelAreas).FirstOrDefault(p => p.Id == planting.Parcel.Id);
if (tempParcel != null)
{
tempParcel.GruntId = planting.Parcel.GruntId;
tempParcel.Name = planting.Parcel.Name;
tempParcel.OwnerName = planting.Parcel.OwnerName;
var tempParcelAreas = tempParcel.ParcelAreas.ToList();
var tempPlantingParcelAreas = planting.Parcel.ParcelAreas.ToList();
for (int i = 0; i < tempParcelAreas.Count; i++)
{
var muId = tempPlantingParcelAreas[i].MetricUnit.Id;
tempParcelAreas[i].MetricUnit = Context.MetricUnits.FirstOrDefault(mu => mu.Id == muId);
tempParcelAreas[i].Quantity = tempPlantingParcelAreas[i].Quantity;
}
tempParcel.ParcelAreas = tempParcelAreas;
existingRecord.Parcel = tempParcel;
}
Context.Plantings.AddOrUpdate(existingRecord);
Context.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, true));
}
throw new Exception("Planting with id " + id + " not found.");
}
catch (Exception ex)
{
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.Conflict, ExceptionMessageHelper.GetErrorMessage(ex)));
}
}
public static bool operator !=(Dish left, Dish right) => ObjectComparisonHelper.NotSame(left, right);