private async Task <bool> DeleteIrisFilesFromSolr() { try { var url = $"{_url}/select?fl=id,uid&q=*:*"; using (var client = new HttpClient()) { var result = await client.GetAsync(url); string resultContent = await result.Content.ReadAsStringAsync(); dynamic d = JsonConvert.DeserializeObject <dynamic>(resultContent); var response = d.response; Int64 numFound = Numerics.GetInt(response.numFound); if (numFound > 0) { using (var httpClient = new HttpClient()) { url = url + $"&start=0&rows={numFound}"; var httpResult = await client.GetAsync(url); string httpResultContent = await httpResult.Content.ReadAsStringAsync(); dynamic httpD = JsonConvert.DeserializeObject <dynamic>(httpResultContent); var httpResponse = httpD.response; string docs = Convert.ToString(httpResponse.docs); List <epd_search_delete_model> solr = JsonConvert.DeserializeObject <List <epd_search_delete_model> >(docs); SQLHandler sqlHandler = new SQLHandler(_connectionString); var search = sqlHandler.ExecuteAsListUsingQuery <string>("Select uid From epd_search ; "); solr.RemoveAll(x => search.Any(y => y == x.uid.FirstOrDefault())); foreach (var item in solr) { var dl = await DeleteRecord(item.id); } } } } return(true); } catch (Exception) { return(false); } }
private void btnExecuteAsListUsingSQLQuery_Click(object sender, EventArgs e) { try { lblTitle.Text = "Execute As List Using SQL Query : GET LIST OF CITIES"; string query = QueryBase.GetAllFrom(eTables.city); List <City> lstCities = null; Task.Factory.StartNew(() => { lstCities = sqlHandler.ExecuteAsListUsingQuery <City>(query); }).Wait(); dgvResult.DataSource = lstCities; } catch (Exception ex) { DisplayError(ex.Message); } }
public async Task <string> Sync() { try { SQLHandler sqlHandler = new SQLHandler(_connectionString); var search = sqlHandler.ExecuteAsListUsingQuery <epd_search_model>("Select * From epd_search ; "); foreach (var item in search) { await FindRecord(item); var add = await AddRecord(item); } await DeleteIrisFilesFromSolr(); return("200"); } catch (System.Exception ex) { return(ex.Message); // HANDLE YOUR EXCEPTION HERE } }