public async Task Add(JobDetail jobDetail)
{
var newSequenceId = await _jobContext.JobIdentifierSequences.MaxAsync(_ => _.Id) + 1; //check this
Entities.JobDetail jobDetailEntity = new Entities.JobDetail()
{
Identifier = jobDetail.Identifier + "00000000" + newSequenceId,
Name = jobDetail.Name,
Description = jobDetail.Description,
EffectiveStartDate = jobDetail.EffectiveStartDate,
Type = (int)jobDetail.Type
};
//jobDetailEntity.Identifier += "00000000" + latestSequenceId + 1;
Entities.JobIdentifierSequence jobIdentifierSequence = new Entities.JobIdentifierSequence();
await _jobContext.JobIdentifierSequences.AddAsync(jobIdentifierSequence); //_jobIdentifierSequenceRepository.Get();
await _jobContext.JobDetails.AddAsync(jobDetailEntity); // either change the identity column or change the reading logic
Entities.ActionState actionState = new Entities.ActionState() // check this : is it a good practice when we have a seperate ActionStateRepository
{
ActionId = (int)jobDetail.ActionState.Action,
StatusId = (int)jobDetail.ActionState.Status,
JobDetail = jobDetailEntity,
EIN = 12323,// temp
UserName = "******",
ActionDateTime = jobDetail.ActionState.ActionDateTime
};
await _jobContext.ActionStates.AddAsync(actionState);
await _jobContext.SaveChangesAsync();
}
public async Task Add(ActionState actionState)
{
Entities.ActionState actionStateEntity = new Entities.ActionState()
{
ActionId = (int)actionState.Action,
StatusId = (int)actionState.Status,
ActionDateTime = actionState.ActionDateTime,
JobId = actionState.JobId,
Notes = actionState.Notes,
EIN = 12323,
UserName = "******"
};
await _jobContext.AddAsync(actionStateEntity);
await _jobContext.SaveChangesAsync();
}