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));
}
}
