Example #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            var files = Directory.GetFiles(@"D:\dev\CarCrawler\src\GetCarQueryApi\cars\");
            var list  = new List <YearMakeModel>();
            var data  = new DataAccess.Data();

            foreach (var f in files)
            {
                var yym = DansCSharpLibrary.Serialization.XmlSerialization.ReadFromXmlFile <List <YearMakeModel> >(f);
                //list.AddRange(yym);
                foreach (var car in yym)
                {
                    data.InsertYearMakeModel(car.year, car.make_display, car.model_name);
                }
            }
        }
Example #2
0
 private void GetRss()
 {
     try
     {
         var ccDal = new DataAccess.Data();
         var feeds = ccDal.GetActiveFeeds();
         foreach (var feedrow in feeds)
         {
             if (!feedrow.FeedActive)
             {
                 continue;
             }
             var feed = RssFeed.Create(new Uri(feedrow.FeedRssLink));
             if (feed.Channel.HasExtensions)
             {
                 feed.Channel.FindExtension(DublinCoreElementSetSyndicationExtension.MatchByType);
             }
             foreach (var item in feed.Channel.Items)
             {
                 if (item.HasExtensions)
                 {
                     var dcExt = item.FindExtension(DublinCoreElementSetSyndicationExtension.MatchByType) as
                                 DublinCoreElementSetSyndicationExtension;
                     if (dcExt != null)
                     {
                         ccDal.InsertRawData(dcExt.Context.Date.ToLocalTime(), item.Link.AbsoluteUri, WebUtility.HtmlDecode(item.Title), WebUtility.HtmlDecode(item.Description), feedrow.Id);
                     }
                 }
             }
         }
     }
     catch (Exception ex)
     {
         logger.Error(ex.Message);
     }
 }
Example #3
0
        private void GetRss()
        {
            try
            {
                var ccDal = new DataAccess.Data();
                var feeds = ccDal.GetActiveFeeds();
                foreach (var feedrow in feeds)
                {
                    if (!feedrow.FeedActive)
                        continue;
                    var feed = RssFeed.Create(new Uri(feedrow.FeedRssLink));
                    if (feed.Channel.HasExtensions)
                    {
                        feed.Channel.FindExtension(DublinCoreElementSetSyndicationExtension.MatchByType);

                    }
                    foreach (var item in feed.Channel.Items)
                    {
                        if (item.HasExtensions)
                        {

                            var dcExt = item.FindExtension(DublinCoreElementSetSyndicationExtension.MatchByType) as
                                        DublinCoreElementSetSyndicationExtension;
                            if (dcExt != null)
                            {
                                ccDal.InsertRawData(dcExt.Context.Date.ToLocalTime(), item.Link.AbsoluteUri, WebUtility.HtmlDecode(item.Title), WebUtility.HtmlDecode(item.Description), feedrow.Id);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                logger.Error(ex.Message);
            }
        }
Example #4
0
 protected void Session_Start()
 {
     Session["pubs"] = new DataAccess.Data(ConfigurationManager.ConnectionStrings["pubs"].ConnectionString);
 }
Example #5
0
 private void button2_Click(object sender, EventArgs e)
 {
     var files = Directory.GetFiles(@"D:\dev\CarCrawler\src\GetCarQueryApi\cars\");
     var list = new List<YearMakeModel>();
     var data = new DataAccess.Data();
     foreach (var f in files)
     {
        var yym = DansCSharpLibrary.Serialization.XmlSerialization.ReadFromXmlFile<List<YearMakeModel>>(f);
         //list.AddRange(yym);
         foreach (var car in yym)
         {
             data.InsertYearMakeModel(car.year, car.make_display, car.model_name);
         }
     
     }
 }
Example #6
0
 /// <summary>
 /// Constructor por default
 /// </summary>
 public BaseRepository()
 {
     data = new DataAccess.Data();
 }