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)); }