public async Task <IActionResult> Update([FromBody] UpdateRecordCommand command)
{
var userId = Guid.Parse(GetUserId());
command.UserId = userId.ToString();
await _mediator.Send(command);
return(new OkResult());
}
public void Update(string recordType, Guid id, [FromBody] Record record)
{
IDataSource data = new Postgres(connectionString);
DataService service = new DataService();
service.data = data;
record.Id = id;
record.Type = recordType;
UpdateRecordCommand command = new UpdateRecordCommand()
{
Target = record
};
UpdateRecordResult result = (UpdateRecordResult)service.Execute(command);
}
public async Task <RecordVM> Update(UpdateRecordCommand command)
{
return(await _mediator.Send(command));
}
public ResultBase Execute(CommandBase command)
{
data.Open();
ResultBase output = null;
switch (command)
{
case CreateRecordCommand _:
{
CreateRecordCommand createCommand = (CreateRecordCommand)command;
RecordType type = data.GetRecordType(createCommand.Target.Type);
List <string> sourceFieldNames = type.Fields.Select(t => t.Name).ToList();
foreach (string field in createCommand.Target.Data.Keys)
{
if (!sourceFieldNames.Contains(field))
{
throw new MissingFieldException($"Record with type {createCommand.Target.Type} doesn't have the column {field}");
}
}
if (createCommand.Target.Id == Guid.Empty)
{
createCommand.Target.Id = Guid.NewGuid();
}
createCommand.Target["createdon"] = DateTime.Now;
createCommand.Target["modifiedon"] = DateTime.Now;
Guid result = this.data.CreateRecord(createCommand.Target);
output = new CreateRecordResult()
{
RecordId = result
};
break;
}
case RetrieveRecordCommand _:
{
RetrieveRecordCommand retrieveCommand = (RetrieveRecordCommand)command;
RecordType type = data.GetRecordType(retrieveCommand.Type);
List <string> fieldsToGet;
if (retrieveCommand.AllFields)
{
fieldsToGet = EnsureIdColumn(type.FieldNames, retrieveCommand.Type);
}
else
{
string badFieldName = retrieveCommand.Fields.FirstOrDefault(f => !type.FieldNames.Contains(f));
if (badFieldName != null)
{
throw new Exception($"Record Type {retrieveCommand.Type} doesn't contain the field {badFieldName}");
}
fieldsToGet = retrieveCommand.Fields;
}
output = new RetrieveRecordResult()
{
Result = this.data.RetrieveRecord(retrieveCommand.Type, retrieveCommand.Id, fieldsToGet)
};
break;
}
case CreateRecordTypeCommand _:
{
CreateRecordTypeCommand createCommand = (CreateRecordTypeCommand)command;
createCommand.Target.Fields.Add(new PrimaryField()
{
Name = createCommand.Target.TableName + "Id"
});
createCommand.Target.Fields.Add(new DateTimeField()
{
Name = "createdon", Nullable = false
});
createCommand.Target.Fields.Add(new DateTimeField()
{
Name = "modifiedon", Nullable = false
});
this.data.CreateRecordType(createCommand.Target);
output = new CreateRecordTypeResult();
break;
}
case RetrieveAllCommand _:
{
RetrieveAllCommand retreiveCommand = (RetrieveAllCommand)command;
if (retreiveCommand.Columns == null)
{
retreiveCommand.Columns = new List <string>();
}
BasicQuery query = new BasicQuery()
{
Columns = EnsureIdColumn(retreiveCommand.Columns, retreiveCommand.RecordType),
RecordType = retreiveCommand.RecordType,
};
var result = this.data.Query(query);
output = new RetrieveAllResult()
{
Result = result
};
break;
}
case RetrieveRecordTypeCommand _:
{
RetrieveRecordTypeCommand retrievecommand = (RetrieveRecordTypeCommand)command;
var result = this.data.GetRecordType(retrievecommand.RecordType);
output = new RetrieveRecordTypeResult()
{
Type = result
};
break;
}
case DeleteRecordCommand _:
{
DeleteRecordCommand deleteCommand = (DeleteRecordCommand)command;
this.data.DeleteRecord(deleteCommand.Type, deleteCommand.Id);
output = new DeleteRecordResult();
break;
}
case UpdateRecordCommand _:
{
UpdateRecordCommand updateCommand = (UpdateRecordCommand)command;
this.data.UpdateRecord(updateCommand.Target);
output = new UpdateRecordResult();
break;
}
case RetrieveAllRecordTypesCommand _:
{
var allTypes = this.data.RetrieveAllRecordTypes();
output = new RetrieveAllRecordTypesResult()
{
RecordTypes = allTypes
};
break;
}
case AddFieldToRecordTypeCommand castedCommand:
{
this.data.AddFieldToRecordType(castedCommand.RecordType, castedCommand.Field);
output = new AddFieldToRecordTypeResult();
}
break;
case RemoveFieldFromRecordTypeCommand castedCommand:
{
this.data.RemoveFieldFromRecordType(castedCommand.RecordType, castedCommand.FieldName);
output = new RemoveFieldFromRecordTypeResult();
break;
}
case DeleteRecordTypeCommand castedCommand:
{
var recordType = this.data.GetRecordType(castedCommand.RecordType);
this.data.DeleteRecordType(recordType.RecordTypeId);
break;
}
case QueryRecordsCommand castedCommand:
{
var query = castedCommand.Query;
query.Columns = EnsureIdColumn(query.Columns, query.RecordType);
var result = this.data.Query(query);
output = new QueryRecordsResult()
{
Result = result
};
break;
}
default:
{
throw new Exception("Unknown command");
}
}
data.Close();
return(output);
}
public IActionResult Put([FromBody] UpdateRecordCommand command)
{
return(HandleResult(() => updateRecordHandler.Run(command)));
}