public ApiModule(IDataServiceHostSettings dshs, IAuthorisation authorisation, IDataServiceDesignerDataService dsdDataService, ISchemaBrowserRepository sbRepository)
: base("api/dataServicedesigner")
{
_dshs = dshs;
_authorisation = authorisation;
_dsdDataService = dsdDataService;
_sbRepository = sbRepository;
Get[@"/availableschemas/{dataServiceName}", true] = async(args, ct) =>
{
string dataServiceName = args.dataServiceName;
var builder = new QueryBuilder <DomainDataService>()
.Filter(d => d.Property(p => p.Name).EqualTo(dataServiceName));
//.Expand(d => d.Connection);
var roleIds = await _authorisation.GetAdministratorRoleIdsAsync();
var queryResult = _dsdDataService.Query(new Query(builder.GetQuery()), BwfSystemUser, roleIds, string.Empty, _dshs.SystemToken, out var fault);
var dataService = queryResult?.Records?.SingleOrDefault() as DomainDataService;
if (dataService is null)
{
return(Response.AsJson(Enumerable.Empty <DbSchema>(), HttpStatusCode.BadRequest));
}
var schemas = _sbRepository.GetWhere <DbSchema>(s => s.Connection.Name == dataService.Connection.Name);
return(Response.AsJson(schemas));
};
}
public Task <bool> Invoke()
{
return(Task.Run(() =>
{
var builder = new QueryBuilder <DataServiceConnection>();
var roleIds = _authorisation.GetAdministratorRoleIdsAsync().Result;
var query = _dsdDataService.Query(new Query(builder.GetQuery()), BwfSystemUser, roleIds, string.Empty, _dshs.SystemToken, out var fault);
if (!(query is null) && query.Records.Count > 0)
{
var changeSet = new ChangeSet <long, DataServiceConnection>();
var itemRef = 1L;
foreach (var item in query.Records)
{
changeSet.AddCreate(itemRef++, item, Enumerable.Empty <long>(), Enumerable.Empty <long>());
}
_connectionManager.SynchConnections(changeSet, _dshs.SystemToken);
}
return true;
}));
}
public ApiModule(IDataServiceHostSettings dshs, IAuthorisation authorisation, IDataServiceDesignerDataService dsdDataService, ISchemaBrowserRepository sbRepository)
: base("api/dataservicedesigner")
{
_dshs = dshs;
_authorisation = authorisation;
_dsdDataService = dsdDataService;
_sbRepository = sbRepository;
Get[@"/availableschemas/{dataServiceName}", true] = async(args, ct) =>
{
string dataServiceName = args.dataServiceName;
var builder = new QueryBuilder <DomainDataService>()
.Filter(d => d.Property(p => p.Name).EqualTo(dataServiceName))
.Expand(d => d.Connection);
var roleIds = await _authorisation.GetAdministratorRoleIdsAsync();
var queryResult = _dsdDataService.Query(new Query(builder.GetQuery()), BwfSystemUser, roleIds, string.Empty, _dshs.SystemToken, out var fault);
var dataService = queryResult?.Records?.SingleOrDefault() as DomainDataService;
if (dataService is null)
{
return(Response.AsJson(Enumerable.Empty <DbSchema>(), HttpStatusCode.BadRequest));
}
var schemas = _sbRepository.GetWhere <DbSchema>(s => s.Connection.Name == dataService.Connection.Name);
return(Response.AsJson(schemas));
};
Get[@"generatetemplate/{solutionName}", true] = async(args, ct) => {
string solutionName = args.solutionName;
var solution = await GetSolution(solutionName);
return(await Task.Run(() =>
{
var templateGenerator = new TemplateGenerator();
var baseDir = AppDomain.CurrentDomain.BaseDirectory;
var zipPath = Path.Combine(baseDir, $"DownLoads\\{solutionName}");
var zipFile = templateGenerator.GenerateAllAndZip(solution, zipPath);
var stream = new FileStream(zipFile, FileMode.Open);
var response = new StreamResponse(() => stream, MimeTypes.GetMimeType(zipFile));
var fileName = Path.GetFileName(zipFile);
var attachment = response.AsAttachment(fileName);
return attachment;
}));
};
async Task <DataServiceSolution> GetSolution(string solutionName)
{
var builder = new QueryBuilder <DataServiceSolution>()
.Expand(p => p.DataServices[0].Solution)
.Expand(p => p.DataServices[0].Connection)
.Expand(p => p.DataServices[0].Schemas)
.Expand(p => p.DataServices[0].Schemas[0].Objects)
.Expand(p => p.DataServices[0].Schemas[0].Objects[0].Properties)
.Expand(p => p.DataServices[0].Schemas[0].References)
.Expand(p => p.DataServices[0].Schemas[0].References[0].Properties)
.Filter(d => d.Property(p => p.Name).EqualTo(solutionName));
var roleIds = await _authorisation.GetAdministratorRoleIdsAsync();
var queryResult = _dsdDataService.Query(new Query(builder.GetQuery()), BwfSystemUser, roleIds, string.Empty, _dshs.SystemToken, out var fault);
var solution = queryResult?.Records?.SingleOrDefault() as DataServiceSolution;
return(solution);
}
}