public static List <Advert> GetAdverts(string url) { HtmlNodeCollection content = RetrieveHtml(url); List <Advert> adverts = new List <Advert>(); Advert advert; if (content != null) { foreach (HtmlNode node in content) { try { advert = new Advert(); advert.Id = ParseHtml.ParseId(node); advert.Category = ParseHtml.ParseCategory(node); advert.Name = ParseHtml.ParseName(node); advert.Url = ParseHtml.ParseUrl(node); advert.Location = ParseHtml.ParseLocation(node); advert.Date = ParseHtml.ParseDate(node); advert.Price = ParseHtml.ParsePrice(node); advert.IsPromoted = ParseHtml.ParseIsPromoted(node); adverts.Add(advert); } catch { } } } return(adverts.OrderBy(x => x.Id).ToList()); }
public static bool IsAdvertExists(Advert advert) { string query = @"select iif(exists(select 1 from dbo.Advert where Adw_ForeignId = @Id),1,0) IsAdwExists"; DynamicParameters param = new DynamicParameters(); param.Add("Id", advert.Id); return(sqlConnection.ExecuteScalar <bool>(query, param)); }
public static string InsertAdvert(Advert advert, int searchid) { string query = @"insert into dbo.Advert(Adw_ForeignId, Adw_Name, Adw_Category, Adw_Location, Adw_Date, Adw_Price, Adw_Url, Adw_IsPromoted, Adw_SeLId) values (@Id, @Name, @Category, @Location, @Date, @Price, @Url, @IsPromoted, @SearchId) select top 1 'Poprawnie dodano ogłoszenie ' + Adw_ForeignId + ': ' + Adw_Name as Info from dbo.Advert where Adw_Id = SCOPE_IDENTITY()"; DynamicParameters param = new DynamicParameters(); param.Add("Id", advert.Id); param.Add("Name", advert.Name); param.Add("Category", advert.Category); param.Add("Location", advert.Location); param.Add("Date", advert.Date); param.Add("Price", advert.Price); param.Add("Url", advert.Url); param.Add("IsPromoted", advert.IsPromoted); param.Add("SearchId", searchid); return(sqlConnection.ExecuteScalar <string>(query, param)); }