public IActionResult getDeviceswithSorting(String SortColumn, String SortDirection) { Db.Connection.Open(); var query = new devices(Db); var result = query.SortAlldevices(SortColumn, SortDirection); Db.Connection.Close(); return(Ok(result)); }