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