// GET: /<controller>/ public IActionResult Index() { ViewData["Message"] = "Client"; NaQulResponseViewModel model = new NaQulResponseViewModel(); return(View(model)); }
public ActionResult GetData(string text) { // List<string> queries = new List<string>(){ // "SELECT * FROM Employees;", // "SELECT * FROM Customers;" // }; NaQulResponseViewModel model = new NaQulResponseViewModel(); model.Text = text; try { var queries = GetQueries(text); foreach (var query in queries) { try { var connectionString = configHelper.GetClientDbConnectionString(); var result = new DBHelper(connectionString).GetDataFromDB(query); if (result.Tables[0].Rows.Count > 0) { model.Results.Add(new Result(query, result.Tables[0])); } } catch (Exception ex) { } } } catch (Exception ex) { model.Message = "Internal Server error in naqul backend server"; } if (model.Results.Count > 0) { var naqulConnection = configHelper.GetNaqulDbConnectionString(); var db = new DBHelper(naqulConnection); db.SaveSqlQuery(text); } return(View("Index", model)); }