Example #1
0
        public void AddToProcessQueue(string link, int parentId, int websiteId, int sessionId)
        {
            using ItsyBitsyDbContext context = new ItsyBitsyDbContext();
            var newItem = new ProcessQueue()
            {
                Link      = link,
                ParentId  = parentId,
                SessionId = sessionId,
                WebsiteId = websiteId
            };

            context.ProcessQueue.Add(newItem);
            context.SaveChanges();
        }
Example #2
0
        public int SaveLink(DownloadResult response, int websiteId, int sessionId)
        {
            try
            {
                using ItsyBitsyDbContext context = new ItsyBitsyDbContext();
                var newPage = new Page()
                {
                    SessionId     = sessionId,
                    StatusCode    = response.Status,
                    WebsiteId     = websiteId,
                    Uri           = response.Uri,
                    ContentType   = (byte)response.ContentType,
                    DownloadTime  = response.DownloadTime,
                    ContentLength = response.ContentLengthBytes
                };
                context.Page.Add(newPage);

                if (response.ParentId.HasValue)
                {
                    var newPageRelation = new PageRelation()
                    {
                        ParentPageId = response.ParentId.Value,
                        ChildPage    = newPage,
                    };
                    context.PageRelation.Add(newPageRelation);
                }

                context.SaveChanges();

                return(newPage.Id);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
Example #3
0
 public void RemoveQueuedItems(IEnumerable <ProcessQueue> successfullyQueued)
 {
     using ItsyBitsyDbContext context = new ItsyBitsyDbContext();
     context.ProcessQueue.RemoveRange(successfullyQueued);
     context.SaveChanges();
 }