public bool Run(NgTableParams model, ref IQueryable <Database.Employer> repository, NgTable <EmployerViewModel> result, ICoreUser Employer, IUnitOfWork db)
{
var ngTransformer = new QueryToNgTable <EmployerViewModel>();
var query = EmployerMapper.MapDbModelQueryToViewModelQuery(repository);
ngTransformer.ToNgTableDataSet(model, query, result);
return(true);
}
public async Task <IActionResult> Detail(string id)
{
var post = this._postService.GetById(id);
var employer = _employerService.GetAll().Where(e => e.Id == post.EmployerId).First();
var user = _userManager.Users.Where(u => u.Id == employer.UserId).First();
var employerModel = EmployerMapper.MapOne(employer, user);
var viewModel = new PostDetailViewModel(post, employerModel);
return(View(viewModel));
}
public bool Run(EmployerViewModel model, IUnitOfWork unitOfWork, Response <EmployerViewModel> result, ICoreUser Employer)
{
var newCustom = EmployerMapper.MapInsertModelToDbModel(model);
unitOfWork.With <Database.Employer>().Add(newCustom);
unitOfWork.SaveChanges();
var newCustomResult = EmployerMapper.MapDbModelToViewModel(newCustom);
result.Body = newCustomResult;
return(true);
}
public bool Run(EmployerViewModel model, ref IQueryable <Database.Employer> repository, IUnitOfWork unitOfWork, Response <EmployerViewModel> result, ICoreUser Employer)
{
var dbModel = repository.Single(c => c.Id == model.Id); // you need to be using the primary key could be composit
var updatedDbModel = EmployerMapper.MapInsertModelToDbModel(model, dbModel);
unitOfWork.With <Database.Employer>().Update(updatedDbModel);
unitOfWork.SaveChanges();
var newCustomResult = EmployerMapper.MapDbModelToViewModel(updatedDbModel);
result.Body = newCustomResult;
return(true);
}
public EmployerDataProvider(
ILogService logger,
IConfigurationService configurationService,
IWcfService <EmployerLookupSoap> service,
IPostalAddressSearchService postalAddressSearchService)
{
_logger = logger;
_configurationService = configurationService;
_service = service;
_postalAddressSearchService = postalAddressSearchService;
_employerMapper = new EmployerMapper();
}
public static async Task Run(
[QueueTrigger("employers", Connection = "AzureWebJobsStorage")] string employersJson,
ILogger log,
ExecutionContext context)
{
var logPrefix = GetLogPrefix();
log.LogInformation($"{logPrefix}: {employersJson}");
var employerFromFile = JsonConvert.DeserializeObject <FileUploadEmployer>(employersJson);
var config = new ConfigurationBuilder()
.SetBasePath(context.FunctionAppDirectory)
.AddJsonFile("local.settings.json", true, true)
.AddEnvironmentVariables()
.Build();
var sqlConnectionString = config.GetConnectionString("Sql");
var fileUploadContext = new FileUploadContext(sqlConnectionString);
var getEmployerQuery = new GetEmployerQuery(fileUploadContext);
var employerInSql = await getEmployerQuery.Execute(employerFromFile.Account);
var employer = EmployerMapper.Map(employerFromFile, employerInSql);
if (employerInSql == null)
{
log.LogInformation($"{logPrefix} Creating Employer: {employerFromFile.Account}");
var createEmployerCommand = new CreateEmployerCommand(fileUploadContext);
await createEmployerCommand.Execute(employer);
log.LogInformation($"{logPrefix} Created Employer: {employerFromFile.Account}");
}
else
{
var areEqual = employerInSql.Equals(employer);
if (!areEqual)
{
log.LogInformation($"{logPrefix} Updating Employer: {employerFromFile.Account}");
var updateEmployerCommand = new UpdateEmployerCommand(fileUploadContext);
await updateEmployerCommand.Execute(employer);
log.LogInformation($"{logPrefix} Updated Employer: {employerFromFile.Account}");
}
}
log.LogInformation($"{logPrefix} Processed Employer: {employerFromFile.Account}");
}
public Response <EmployerViewModel> Run(EmployerViewModel model, ref IQueryable <Database.Employer> repository, IUnitOfWork unitOfWork, Response <EmployerViewModel> result, ICoreUser Employer)
{
var itemToUpdate = repository.SingleOrDefault(c => c.Id == model.Id);
if (itemToUpdate != null)
{
var newCustomResult = EmployerMapper.MapDbModelToViewModel(itemToUpdate);
result.Body = newCustomResult;
result.Success = true;
}
else
{
result.Success = false;
result.LogError("Error viewing Employers");
}
return(result);
}
