public async Task <IActionResult> EditPcsScoring(int id, [Bind("PcsScoringId,Score2Target,Score1Lower")] PcsScoring pcsScoring) { if (id != pcsScoring.PcsScoringId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(pcsScoring); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PcsScoringExists(pcsScoring.PcsScoringId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(pcsScoring)); }
public async Task <IActionResult> PutBatch(int id, Batch batch) { if (id != batch.RequestId) { return(BadRequest()); } _context.Entry(batch).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BatchExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutBatch(long id, BatchDTO batchDTO) { if (id != batchDTO.Id) { return(BadRequest()); } var batch = await _context.Batches.FindAsync(id); if (batch == null) { return(NotFound()); } batch.DateUpdated = DateTime.Now; batch.Name = batchDTO.Name; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) when(!BatchExists(id)) { return(NotFound()); } return(NoContent()); }
public async Task <IActionResult> Create([Bind("ID,Name,DateStarted,ExpectedFinishDate,AmountOfWash,ExpectedWashPercent,ExpectedYield,ActualYield,PercentDiff,Notes")] Batch batch) { if (ModelState.IsValid) { _context.Add(batch); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(batch)); }
public async Task <IActionResult> Create([Bind("BatchReportId,OriginalReport,StreamName,Recipe,Campaign,BatchNo,WeekNo,StartTime,MakingTime,QATime,PreQaTemp,Visco,Ph,SG,Appearance,VisualColour,MeasuredColour,Odour,OverallQAStatus,StockTankAllocationTime,AllocatedTo,DropTime,TotalRecipeWeight,TotalActualWeight,VesselWeightIncrease,RecipeType,NewMakeTime")] BatchReport batchReport) { if (ModelState.IsValid) { _context.Add(batchReport); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(batchReport)); }
public async Task <IActionResult> Create([Bind("PcsTempTargetsId,RecipeType,Recipe,Target,UpperLimit,LowerLimit")] PcsTempTargets pcsTempTargets) { if (ModelState.IsValid) { _context.Add(pcsTempTargets); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(pcsTempTargets)); }
public async Task <IActionResult> Create([Bind("RecipeLimitsId,RecipeType,LimitTypes,Min,Max,GuageMax,Target,Tolerance")] RecipeLimits recipeLimits) { if (ModelState.IsValid) { _context.Add(recipeLimits); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(recipeLimits)); }
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(); } }
public Task <int> SaveChangesAsync() { return(_batchContext.SaveChangesAsync()); }
public async Task SaveChangesAsync() { await _context.SaveChangesAsync(); }