//Our MultiplierManager event result.
public async void OnNumberFinishedMultiplyingAsync(object source, BatchAndNumberEventArgs e)
{
NumbersAndBatchesData n = new NumbersAndBatchesData();
BatchAndNumberFullInfo saveData = new BatchAndNumberFullInfo
{
BatchAndNumber = e.BatchAndNumber,
BatchAndNumberInputDetails = e.BatchAndNumberInput
};
await n.WriteBatchAndNumberToDatabase(saveData);
}
public async Task WriteBatchAndNumberToDatabase(BatchAndNumberFullInfo batchAndNumberFullInfo)
{
//I am given to understand that this is an antequated way to do this. I agree. I am however struggling to utilise the dependency injection native to EF Core, as at the top of this page.
//Right now, I just want to focus on functionality, but please be aware that I know this is not ideal.
var optionsBuilder = new DbContextOptionsBuilder <BatchContext>();
optionsBuilder.UseSqlServer("Server=(local)\\sqlexpress;Database=RuanGatesBDAssessmentDB;Trusted_Connection=True;MultipleActiveResultSets=True;");
var batch = new Batch();
batch.BatchElements = new List <BatchElement>();
batch.BatchAndNumberInput = new BatchAndNumberInput();
batch.BatchAndNumberInput.Batches = batchAndNumberFullInfo.BatchAndNumberInputDetails.Batches;
batch.BatchAndNumberInput.Numbers = batchAndNumberFullInfo.BatchAndNumberInputDetails.Numbers;
batch.CollectionId = batchAndNumberFullInfo.BatchAndNumberInputDetails.RequestId;
BatchElement batchElement = new BatchElement();
batchElement.BatchNumber = batchAndNumberFullInfo.BatchAndNumber.Batch;
batchElement.NumbersRemaining = 4;
batchElement.Aggregate = 12;
batchElement.NumbersInBatch = new List <NumberInBatch>();
NumberInBatch number = new NumberInBatch();
number.Number = batchAndNumberFullInfo.BatchAndNumber.Number;
batchElement.NumbersInBatch.Add(number);
batch.BatchElements.Add(batchElement);
batch.GrandTotal = 99;
using (var ctx = new BatchContext(optionsBuilder.Options))
{
ctx.Batches.Add(batch);
await ctx.SaveChangesAsync();
}
}
