public static async Task <AggregatedAmountsFact> Load(WaDEContext db, AggregatedAmountsFactBuilderOptions opts) { opts.OrganizationsDim = opts.OrganizationsDim ?? await OrganizationsDimBuilder.Load(db); opts.ReportingUnitsDim = opts.ReportingUnitsDim ?? await ReportingUnitsDimBuilder.Load(db); opts.VariablesDim = opts.VariablesDim ?? await VariablesDimBuilder.Load(db); opts.WaterSourcesDim = opts.WaterSourcesDim ?? await WaterSourcesDimBuilder.Load(db); opts.MethodsDim = opts.MethodsDim ?? await MethodsDimBuilder.Load(db); var item = Create(opts); db.AggregatedAmountsFact.Add(item); await db.SaveChangesAsync(); return(item); }
public static AggregatedAmountsFact Create(AggregatedAmountsFactBuilderOptions opts) { var faker = new Faker <AggregatedAmountsFact>() .RuleFor(a => a.OrganizationId, f => opts.OrganizationsDim?.OrganizationId ?? OrganizationsDimBuilder.GenerateId()) .RuleFor(a => a.ReportingUnitId, f => opts.ReportingUnitsDim?.ReportingUnitId ?? ReportingUnitsDimBuilder.GenerateId()) .RuleFor(a => a.VariableSpecificId, f => opts.VariablesDim?.VariableSpecificId ?? VariablesDimBuilder.GenerateId()) .RuleFor(a => a.PrimaryUseCategoryCV, f => opts.PrimaryBeneficialUsesCv?.Name) .RuleFor(a => a.WaterSourceId, f => opts.WaterSourcesDim?.WaterSourceId ?? WaterSourcesDimBuilder.GenerateId()) .RuleFor(a => a.MethodId, f => opts.MethodsDim?.MethodId ?? MethodsDimBuilder.GenerateId()) .RuleFor(a => a.TimeframeStartId, f => opts.TimeframeStart?.DateId) .RuleFor(a => a.TimeframeEndId, f => opts.TimeframeEnd?.DateId) .RuleFor(a => a.DataPublicationDateID, f => opts.DataPublicationDate?.DateId) .RuleFor(a => a.DataPublicationDoi, f => f.Random.Word()) .RuleFor(a => a.ReportYearCv, f => opts.ReportYearCv?.Name) .RuleFor(a => a.Amount, f => f.Random.Double(0, 5000)) .RuleFor(a => a.InterbasinTransferToId, f => f.Random.AlphaNumeric(20)) .RuleFor(a => a.InterbasinTransferFromId, f => f.Random.AlphaNumeric(20)); switch (opts.RecordType ?? (new Faker()).PickRandom <AggregatedAmountsRecordType>()) { case AggregatedAmountsRecordType.Ag: faker.RuleFor(a => a.IrrigatedAcreage, f => f.Random.Double(0, 10000)) .RuleFor(a => a.CropTypeCV, f => opts.CropType?.Name) .RuleFor(a => a.IrrigationMethodCV, f => opts.IrrigationMethod?.Name) .RuleFor(a => a.AllocationCropDutyAmount, f => f.Random.Double(0, 50000)); break; case AggregatedAmountsRecordType.Power: faker.RuleFor(a => a.PowerGeneratedGwh, f => f.Random.Double(0, 10000)); break; case AggregatedAmountsRecordType.Civilian: faker.RuleFor(a => a.PopulationServed, f => f.Random.Long(0, 10000000)) .RuleFor(a => a.CommunityWaterSupplySystem, f => f.Address.City()) .RuleFor(a => a.CustomerTypeCV, f => opts.CustomerType?.Name) .RuleFor(a => a.SDWISIdentifierCV, f => opts.SDWISIdentifier?.Name); break; } return(faker); }