public IActionResult GetColumns(int accountId, int formId)
{
try
{
_logger.Log(LogLevel.Information, "columns");
_logger.Log(LogLevel.Critical, "columns test");
if (!_accountRepository.AccountExists(accountId))
{
_logger.LogInformation($"Account with id {accountId} wasn't found when accessing columns.");
return(NotFound());
}
if (!_formRepository.FormExists(formId))
{
_logger.LogInformation($"Form with id {formId} wasn't found when accessing forms.");
return(NotFound());
}
var columnsForForm = _formRepository.GetColumnForForm(formId);
var columnsForFormResults =
Mapper.Map <IEnumerable <ColumnDto> >(columnsForForm);
return(Ok(columnsForFormResults));
}
catch (Exception ex)
{
_logger.LogCritical($"Exception while getting column for form with id {formId}.", ex);
return(StatusCode(500, "A problem happened while handling your request."));
}
}
public IActionResult CreateAction(int accountId, int formId,
[FromBody] FormActionsDto formAction)
{
if (formAction == null)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (!_accountRepository.AccountExists(accountId))
{
return(NotFound());
}
if (!_formRepository.FormExists(formId))
{
return(NotFound());
}
var columnEntity = _formRepository.GetDistinctColumnForForm(formId);
if (columnEntity == null)
{
return(NotFound());
}
else
{
try
{
var clientTablePrefix = Startup.Configuration["AppSettings:clientTablePrefix"];
var clientConnectionString = Startup.Configuration["ConnectionStrings:connFDClientData"];
ClientDBHelper clientDBHelper = new ClientDBHelper(accountId, formId, clientConnectionString, clientTablePrefix);
if (clientDBHelper.TableExists(clientDBHelper.GetClientTableName()))
{
clientDBHelper.UpdateTable(columnEntity);
}
else
{
clientDBHelper.CreateTable(columnEntity);
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
return(Ok());
}
