public void ParsingTender() { using (var connect = ConnectToDb.GetDbConnection()) { connect.Open(); var selectTend = $"SELECT id_tender FROM {AppBuilder.Prefix}tender WHERE purchase_number = @purchase_number AND doc_publish_date = @doc_publish_date AND type_fz = @type_fz AND notice_version = @notice_version AND end_date = @end_date"; var cmd = new MySqlCommand(selectTend, connect); cmd.Prepare(); cmd.Parameters.AddWithValue("@purchase_number", _tn.PurNum); cmd.Parameters.AddWithValue("@doc_publish_date", _tn.DatePub); cmd.Parameters.AddWithValue("@type_fz", TypeFz); cmd.Parameters.AddWithValue("@notice_version", _tn.Status); cmd.Parameters.AddWithValue("@end_date", _tn.DateEnd); var dt = new DataTable(); var adapter = new MySqlDataAdapter { SelectCommand = cmd }; adapter.Fill(dt); if (dt.Rows.Count > 0) { return; } var s = DownloadString.DownLHttpPost(_tn.Href); if (string.IsNullOrEmpty(s)) { s = DownloadString.DownLHttpPost(_tn.Href.Replace( "https://market.lot-online.ru/app/SmallPurchaseCard/page?SmallPurchaseCard.smallPurchaseEntity=", "https://market.lot-online.ru/app/section/pochta/SmallPurchaseCard/page?SmallPurchaseCard.smallPurchaseEntity=")); } if (string.IsNullOrEmpty(s)) { Log.Logger("Empty string in ParsingTender()", _tn.Href); return; } var htmlDoc = new HtmlDocument(); htmlDoc.LoadHtml(s); var navigator = (HtmlNodeNavigator)htmlDoc.CreateNavigator(); var dateUpd = DateTime.Now; var(updated, cancelStatus) = UpdateTenderVersion(connect, _tn.PurNum, dateUpd); CreaateOrganizer(connect, out var organiserId); var idPlacingWay = 0; GetEtp(connect, out var idEtp); var idRegion = GetRegionFromString(_tn.RegionName, connect); var idTender = CreateTender(connect, idRegion, organiserId, idPlacingWay, idEtp, cancelStatus, dateUpd, updated); CreateCustomer(connect, out var customerId); AddAttachments(htmlDoc, connect, idTender); CreateLot(connect, idTender, customerId, htmlDoc); TenderKwords(connect, idTender); AddVerNumber(connect, _tn.PurNum, TypeFz); } }