public static string getStringFromUrl(string Url)
{
string json = string.Empty;
try
{
if (count < proxyList.Count())
{
using (WebClient wc = new WebClient())
{
ProxyModel p = proxyList[count];
WebProxy webProxy = new WebProxy(p.IP, p.Port);
wc.Proxy = webProxy;
var str = wc.DownloadString(Url);
json = JObject.Parse(str).ToString();
}
}
else
{
_updateProxyList();
}
}
catch (Exception ex)
{
LoggerUtility.Write(ex.Message, Url);
count++;
if (count >= proxyList.Count)
{
_updateProxyList();
}
LoggerUtility.Write("Changing IP to ", proxyList[count].IP);
return(getStringFromUrl(Url));
}
return(json);
}
public static DataSet GetDataSetFromExcelFile(string file, string sheetName)
{
try
{
DataSet ds = new DataSet();
string connectionString = GetConnectionString(file);
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
// Get all rows from the Sheet
cmd.CommandText = "SELECT * FROM [" + sheetName + "$]";
DataTable dt = new DataTable();
dt.TableName = sheetName;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(dt);
ds.Tables.Add(dt);
cmd = null;
conn.Close();
}
return(ds);
}
catch (Exception ex)
{
LoggerUtility.Write("Error Reading File", ex.Message);
throw;
}
}
private static void _updateProxyList()
{
LoggerUtility.Write("Proxy List Ended", "Updating List");
proxyList = pm.UpdateProxyList();
count = 0;
}