//public delegate void Report(string strReport);
DataSet GetNextURLs()
{
Report(string.Format("----- Trying to get the next {0} Urls -----", intStepUrls));
DataSet dsetURLS = TEXCSDBUtil.DBStoredProcExecDataSet(sqcnMain, "dbo.sp_SW_SelectGreekURLIDs",
new string[] { "@intFromURLID", "@intToURLID" },
new object[] { intLastUrlAsked + 1, intLastUrlAsked + intStepUrls });
intLastUrlAsked += intStepUrls;
Report(string.Format("----- Succesfully got {0} Urls. Tried to get {1} Urls -----", dsetURLS.Tables[0].Rows.Count, intStepUrls));
return(dsetURLS);
}
//---------------------------------------------------------------------------------------
public ArrayList GetGreekOutLinks(int intURLID)
{
ArrayList arlsResult = new ArrayList();
using (DataSet dsetURLS = TEXCSDBUtil.DBStoredProcExecDataSet(sqcnMain, "dbo.sp_SW_SelectGreekOutLinks",
new string[] { "@intURLID" },
new object[] { intURLID }))
{
if ((dsetURLS != null) && (dsetURLS.Tables[0] != null) && (dsetURLS.Tables[0].Rows.Count > 0))
{
foreach (DataRow dtrwIter in dsetURLS.Tables[0].Rows)
{
arlsResult.Add((int)dtrwIter["cwlg_to_url_id"]);
}
}
}
return(arlsResult);
}