static void Main(params int[] args)
{
var r = new Retriever();
var data = r.GetData();
foreach (var i in data)
{
Console.WriteLine(i);
}
}
private void Form1_Load(object sender, EventArgs e)
{
var r = new Retriever();
var data = r.GetData();
foreach (var in in data)
{
myLabel.Text += i;
}
}
public IActionResult LoadData()
{
// assign values of start and length from HttpContext
string start = HttpContext.Request.Form["start"].FirstOrDefault();
string length = HttpContext.Request.Form["length"].FirstOrDefault();
//sort and search params
string sortColumn = HttpContext.Request.Form["sortColumn"].FirstOrDefault();
string sortColumnDirection = HttpContext.Request.Form["sortDirection"].FirstOrDefault();
string searchValue = HttpContext.Request.Form["search"].FirstOrDefault();
var dapperResult = _softwareProducts.GetData(start, length, sortColumn, sortColumnDirection, searchValue);
return(Json(new { recordsFiltered = dapperResult.Size, recordsTotal = dapperResult.Size, data = dapperResult.Results }));
}