public async Task <JsonResult> SaveAll(string lineBalancingStates) { var error = false; var count = 0; var lineBalancingViewModels = JsonConvert.DeserializeObject <List <LineBalancingViewModel> >(lineBalancingStates); int particularLineId = 0; var loggedInUser = await _userManager.FindByNameAsync(HttpContext.User.Identity.Name); foreach (var lineBalancingViewModel in lineBalancingViewModels) { particularLineId = lineBalancingViewModel.ParticularLineBalancingId; break; } foreach (var lineBalancingViewModel in lineBalancingViewModels) { var lineBalancingState = new LineBalancingState(); lineBalancingState.ParticularLineBalancingId = lineBalancingViewModel.ParticularLineBalancingId; lineBalancingState.OperationName = lineBalancingViewModel.OperationName; lineBalancingState.OperationId = lineBalancingViewModel.OperationId; lineBalancingState.MachineId = lineBalancingViewModel.MachineId; lineBalancingState.OperatorId1 = lineBalancingViewModel.OperatorId1; lineBalancingState.OperatorId2 = lineBalancingViewModel.OperatorId2; lineBalancingState.OperatorId3 = lineBalancingViewModel.OperatorId3; lineBalancingState.OperatorId4 = lineBalancingViewModel.OperatorId4; lineBalancingState.OperatorNo1 = lineBalancingViewModel.OperatorNo1; lineBalancingState.OperatorNo2 = lineBalancingViewModel.OperatorNo2; lineBalancingState.OperatorNo3 = lineBalancingViewModel.OperatorNo3; lineBalancingState.OperatorNo4 = lineBalancingViewModel.OperatorNo4; lineBalancingState.CycleTime1 = lineBalancingViewModel.CycleTime1; lineBalancingState.CycleTime2 = lineBalancingViewModel.CycleTime2; lineBalancingState.CycleTime3 = lineBalancingViewModel.CycleTime3; lineBalancingState.CycleTime4 = lineBalancingViewModel.CycleTime4; lineBalancingState.AllocatedTime1 = lineBalancingViewModel.AllocatedTime1; lineBalancingState.AllocatedTime2 = lineBalancingViewModel.AllocatedTime2; lineBalancingState.AllocatedTime3 = lineBalancingViewModel.AllocatedTime3; lineBalancingState.AllocatedTime4 = lineBalancingViewModel.AllocatedTime4; lineBalancingState.Output1 = lineBalancingViewModel.Output1; lineBalancingState.Output2 = lineBalancingViewModel.Output2; lineBalancingState.Output3 = lineBalancingViewModel.Output3; lineBalancingState.Output4 = lineBalancingViewModel.Output4; if (lineBalancingViewModel.RowId != -1) { lineBalancingState.Id = lineBalancingViewModel.RowId; _context.LineBalancingStates.Update(lineBalancingState); try { await _context.SaveChangesAsync(); if (particularLineId != 0) { var particularLine = await _context.ParticularLineBalancings.Where(m => m.Id == particularLineId).FirstOrDefaultAsync(); particularLine.Who = loggedInUser.UserName; _context.ParticularLineBalancings.Update(particularLine); await _context.SaveChangesAsync(); } count++; } catch { error = true; } } else { _context.LineBalancingStates.Add(lineBalancingState); try { await _context.SaveChangesAsync(); count++; } catch { error = true; } } } if (error == false) { return(new JsonResult(count)); } else { return(new JsonResult(false)); } }
public async Task <JsonResult> Save(string data) { var lineBalancingViewModels = JsonConvert.DeserializeObject <LineBalancingViewModel>(data); var loggedInUser = await _userManager.FindByNameAsync(HttpContext.User.Identity.Name); var lineBalancingState = new LineBalancingState(); lineBalancingState.ParticularLineBalancingId = lineBalancingViewModels.ParticularLineBalancingId; lineBalancingState.OperationName = lineBalancingViewModels.OperationName; lineBalancingState.OperationId = lineBalancingViewModels.OperationId; lineBalancingState.MachineId = lineBalancingViewModels.MachineId; lineBalancingState.OperatorId1 = lineBalancingViewModels.OperatorId1; lineBalancingState.OperatorId2 = lineBalancingViewModels.OperatorId2; lineBalancingState.OperatorId3 = lineBalancingViewModels.OperatorId3; lineBalancingState.OperatorId4 = lineBalancingViewModels.OperatorId4; lineBalancingState.OperatorNo1 = lineBalancingViewModels.OperatorNo1; lineBalancingState.OperatorNo2 = lineBalancingViewModels.OperatorNo2; lineBalancingState.OperatorNo3 = lineBalancingViewModels.OperatorNo3; lineBalancingState.OperatorNo4 = lineBalancingViewModels.OperatorNo4; lineBalancingState.CycleTime1 = lineBalancingViewModels.CycleTime1; lineBalancingState.CycleTime2 = lineBalancingViewModels.CycleTime2; lineBalancingState.CycleTime3 = lineBalancingViewModels.CycleTime3; lineBalancingState.CycleTime4 = lineBalancingViewModels.CycleTime4; lineBalancingState.AllocatedTime1 = lineBalancingViewModels.AllocatedTime1; lineBalancingState.AllocatedTime2 = lineBalancingViewModels.AllocatedTime2; lineBalancingState.AllocatedTime3 = lineBalancingViewModels.AllocatedTime3; lineBalancingState.AllocatedTime4 = lineBalancingViewModels.AllocatedTime4; lineBalancingState.Output1 = lineBalancingViewModels.Output1; lineBalancingState.Output2 = lineBalancingViewModels.Output2; lineBalancingState.Output3 = lineBalancingViewModels.Output3; lineBalancingState.Output4 = lineBalancingViewModels.Output4; if (lineBalancingViewModels.RowId != -1) { lineBalancingState.Id = lineBalancingViewModels.RowId; _context.LineBalancingStates.Update(lineBalancingState); await _context.SaveChangesAsync(); var particularLine = await _context.ParticularLineBalancings.Where(m => m.Id == lineBalancingState.ParticularLineBalancingId).FirstOrDefaultAsync(); particularLine.Who = loggedInUser.UserName; _context.ParticularLineBalancings.Update(particularLine); await _context.SaveChangesAsync(); return(new JsonResult(lineBalancingState.Id)); } else { _context.LineBalancingStates.Add(lineBalancingState); await _context.SaveChangesAsync(); var particularLine = await _context.ParticularLineBalancings.Where(m => m.Id == lineBalancingState.ParticularLineBalancingId).FirstOrDefaultAsync(); particularLine.Who = loggedInUser.UserName; _context.ParticularLineBalancings.Update(particularLine); await _context.SaveChangesAsync(); return(new JsonResult(lineBalancingState.Id)); } }