Ejemplo n.º 1
0
        //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);
        }
Ejemplo n.º 2
0
//---------------------------------------------------------------------------------------

        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);
        }