public long EditQuerySqlScript(long id, string sqlScript)
{
var savedQuery = Context.Queries.FirstOrDefault(x => x.Id == id);
var query = JsonConvert.DeserializeObject <PagedQueryModel>(savedQuery.QueryText);
if (savedQuery == null)
{
throw new BadRequestException("Query doesn't exist");
}
var saveScriptModel = new SqlScriptSaveModel
{
Name = savedQuery.Name,
CategoryId = savedQuery.CategoryId,
SqlRequest = new SqlRequestModel
{
ConnectionStringName = query?.ConnectionStringName,
PaginationModel = query?.PagingModel,
SqlScript = sqlScript
}
};
var newId = AddSqlScript(saveScriptModel);
DeleteQuery(id);
return(newId);
}
public long AddSqlScript(SqlScriptSaveModel sqlScript)
{
var model = new SqlScript
{
CategoryId = sqlScript.CategoryId,
Name = sqlScript.Name,
SqlScriptText = JsonConvert.SerializeObject(sqlScript.SqlRequest),
Parameters = JsonConvert.SerializeObject(sqlScript.Parameters)
};
Context.SqlScripts.Add(model);
Context.SaveChanges();
return(model.Id);
}
public long AddScript([FromBody] SqlScriptSaveModel script)
{
return(dataManager.AddSqlScript(script));
}
public long AddSqlScript(SqlScriptSaveModel script)
{
return(dal.AddSqlScript(script));
}
