public static int BulkSetAllocation(RioDbContext dbContext, ParcelAllocationUpsertDto parcelAllocationUpsertDto)
{
// delete existing parcel allocations
var existingParcelAllocations = dbContext.ParcelAllocation.Where(x => x.WaterYear == parcelAllocationUpsertDto.WaterYear && x.ParcelAllocationTypeID == parcelAllocationUpsertDto.ParcelAllocationTypeID);
if (existingParcelAllocations.Any())
{
dbContext.ParcelAllocation.RemoveRange(existingParcelAllocations);
dbContext.SaveChanges();
}
var parcels = dbContext.Parcel.AsNoTracking().OrderBy(x => x.ParcelID).ToList();
foreach (var parcel in parcels)
{
var parcelAllocation = new ParcelAllocation
{
ParcelID = parcel.ParcelID,
WaterYear = parcelAllocationUpsertDto.WaterYear,
ParcelAllocationTypeID = parcelAllocationUpsertDto.ParcelAllocationTypeID,
AcreFeetAllocated = parcelAllocationUpsertDto.AcreFeetAllocated * (decimal)parcel.ParcelAreaInAcres
};
dbContext.ParcelAllocation.Add(parcelAllocation);
}
dbContext.SaveChanges();
return(parcels.Count);
}
public static List <ParcelAllocationDto> Upsert(RioDbContext dbContext, int parcelID, List <ParcelAllocationUpsertDto> parcelAllocationUpsertDtos)
{
// delete existing parcel allocations
var existingParcelAllocations = dbContext.ParcelAllocation.Where(x => x.ParcelID == parcelID);
if (existingParcelAllocations.Any())
{
dbContext.ParcelAllocation.RemoveRange(existingParcelAllocations);
dbContext.SaveChanges();
}
foreach (var parcelAllocationUpsertDto in parcelAllocationUpsertDtos)
{
var parcelAllocation = dbContext.ParcelAllocation
.SingleOrDefault(x => x.ParcelID == parcelID && x.WaterYear == parcelAllocationUpsertDto.WaterYear && x.ParcelAllocationTypeID == parcelAllocationUpsertDto.ParcelAllocationTypeID);
if (parcelAllocation == null)
{
parcelAllocation = new ParcelAllocation
{
ParcelID = parcelID,
WaterYear = parcelAllocationUpsertDto.WaterYear,
ParcelAllocationTypeID = parcelAllocationUpsertDto.ParcelAllocationTypeID
};
dbContext.ParcelAllocation.Add(parcelAllocation);
}
parcelAllocation.AcreFeetAllocated = parcelAllocationUpsertDto.AcreFeetAllocated;
}
dbContext.SaveChanges();
return(ListByParcelID(dbContext, parcelID));
}
public static ParcelAllocationDto AsDto(this ParcelAllocation parcelAllocation)
{
return(new ParcelAllocationDto()
{
ParcelAllocationTypeID = parcelAllocation.ParcelAllocationTypeID,
ParcelID = parcelAllocation.ParcelID,
WaterYear = parcelAllocation.WaterYear,
AcreFeetAllocated = parcelAllocation.AcreFeetAllocated,
ParcelAllocationID = parcelAllocation.ParcelAllocationID
});
}