public async Task <IEnumerable <Gateway> > FindAsync(QueryGateway queryGateway)
{
var q = _context.Gateways.Include(p => p.Devices).AsNoTracking();
if (!String.IsNullOrEmpty(queryGateway.Name))
{
q = q.Where(e => e.Name == queryGateway.Name);
}
return(await q.ToListAsync());
}
public void Install(string dbScriptPath, string connectionString, string adminLogin, string adminPassword, string rootUrl)
{
var script = File.ReadAllText(dbScriptPath, Encoding.UTF8);
var databaseName = Regex.Match(connectionString, @"initial catalog=(.+?);").Groups[1].Value;
script = script.Replace("$(DatabaseName)", databaseName)
.Replace("'admin'", $"'{adminLogin}'")
.Replace("21232f297a57a5a743894a0e4a801fc3", SecurityService.CalculateHash(adminPassword))
.Replace("http://localhost:4014", rootUrl);
script = Regex.Replace(script, "--.*$", "");
script = Regex.Replace(script, "/\\*.*\\*/ ", "", RegexOptions.Multiline);
var queryGateway = new QueryGateway(connectionString);
queryGateway.ExecBatch(script);
}
public Task <IEnumerable <Gateway> > FindAsync(QueryGateway query)
{
return(_gatewayRepo.FindAsync(query));
}
