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