public new void Work44()
{
string xml = GetXml(File);
int idCustomer = 0;
int idSupplier = 0;
string idContract = ((string)J44.SelectToken("export.contract.id") ?? "").Trim();
if (String.IsNullOrEmpty(idContract))
{
Log.Logger("У контракта нет id", File);
return;
}
string pNumber = idContract;
string regnum = ((string)J44.SelectToken("export.contract.regNum") ?? "").Trim();
string currentContractStage = ((string)J44.SelectToken("export.contract.currentContractStage") ?? "")
.Trim();
string placing =
((string)J44.SelectToken("export.contract.foundation.fcsOrder.order.placing") ?? "").Trim();
if (String.IsNullOrEmpty(placing))
{
placing = ((string)J44.SelectToken("export.contract.foundation.oosOrder.order.placing") ?? "").Trim();
}
string url = ((string)J44.SelectToken("export.contract.href") ?? "").Trim();
string signDate = ((string)J44.SelectToken("export.contract.signDate") ?? "").Trim();
string singleCustomerReasonCode =
((string)J44.SelectToken("export.contract.foundation.fcsOrder.order.singleCustomer.reason.code") ?? "")
.Trim();
if (String.IsNullOrEmpty(singleCustomerReasonCode))
{
singleCustomerReasonCode =
((string)J44.SelectToken("export.contract.foundation.oosOrder.order.singleCustomer.reason.code") ??
"").Trim();
}
string singleCustomerReasonName =
((string)J44.SelectToken("export.contract.foundation.fcsOrder.order.singleCustomer.reason.name") ?? "")
.Trim();
if (String.IsNullOrEmpty(singleCustomerReasonName))
{
singleCustomerReasonName =
((string)J44.SelectToken("export.contract.foundation.oosOrder.order.singleCustomer.reason.name") ??
"").Trim();
}
string fz = "44";
string notificationNumber =
((string)J44.SelectToken("export.contract.foundation.fcsOrder.order.notificationNumber") ?? "").Trim();
if (String.IsNullOrEmpty(notificationNumber))
{
notificationNumber =
((string)J44.SelectToken("export.contract.foundation.oosOrder.order.notificationNumber") ?? "")
.Trim();
}
if (String.IsNullOrEmpty(notificationNumber))
{
notificationNumber = "Нет номера";
}
int lotNumber = (int?)J44.SelectToken("export.contract.foundation.fcsOrder.order.lotNumber") ?? 0;
if (lotNumber == 0)
{
lotNumber = (int?)J44.SelectToken("export.contract.foundation.oosOrder.order.lotNumber") ?? 0;
}
if (lotNumber == 0)
{
lotNumber = 1;
}
string contractPrice = ((string)J44.SelectToken("export.contract.priceInfo.price") ?? "").Trim();
/*decimal contract_price = decimal.Parse(contract_price_s, NumberStyles.Any, CultureInfo.InvariantCulture);*/
string currency = ((string)J44.SelectToken("export.contract.priceInfo.currency.name") ?? "").Trim();
int versionNumber = (int?)J44.SelectToken("export.contract.versionNumber") ?? 0;
int cancel = 0;
string executionStartDate =
((string)J44.SelectToken("export.contract.executionPeriod.startDate") ?? "").Trim();
string executionEndDate = ((string)J44.SelectToken("export.contract.executionPeriod.endDate") ??
"").Trim();
using (MySqlConnection connect = ConnectToDb.GetDbConnection())
{
connect.Open();
if (!String.IsNullOrEmpty(regnum) && versionNumber != 0)
{
string selectGetMax =
$"SELECT MAX(version_number) as m FROM {Program.Prefix}od_contract WHERE regnum = @regnum";
MySqlCommand cmd = new MySqlCommand(selectGetMax, connect);
cmd.Prepare();
cmd.Parameters.AddWithValue("@regnum", regnum);
object resultm = cmd.ExecuteScalar();
int? maxNumber = (int?)(!Convert.IsDBNull(resultm) ? resultm : null);
if (maxNumber != null)
{
if (versionNumber > maxNumber)
{
string updateC = $"UPDATE {Program.Prefix}od_contract SET cancel=1 WHERE regnum= @regnum";
MySqlCommand cmd2 = new MySqlCommand(updateC, connect);
cmd2.Prepare();
cmd2.Parameters.AddWithValue("@regnum", regnum);
cmd2.ExecuteNonQuery();
}
else
{
cancel = 1;
}
}
}
string customerRegnumber = ((string)J44.SelectToken("export.contract.customer.regNum") ?? "").Trim();
if (!String.IsNullOrEmpty(customerRegnumber))
{
string selectCustomer =
$"SELECT id FROM {Program.Prefix}od_customer WHERE regNumber = @customer_regnumber";
MySqlCommand cmd3 = new MySqlCommand(selectCustomer, connect);
cmd3.Prepare();
cmd3.Parameters.AddWithValue("@customer_regnumber", customerRegnumber);
MySqlDataReader reader = cmd3.ExecuteReader();
bool resRead = reader.HasRows;
if (resRead)
{
reader.Read();
idCustomer = reader.GetInt32("id");
reader.Close();
}
else
{
reader.Close();
string kppCustomer = ((string)J44.SelectToken("export.contract.customer.kpp") ?? "").Trim();
string innCustomer = ((string)J44.SelectToken("export.contract.customer.inn") ?? "").Trim();
string fullNameCustomer =
((string)J44.SelectToken("export.contract.customer.fullName") ?? "").Trim();
string postalAddressCustomer = "";
int contractsCountCustomer = 1;
string contractsSumCustomer = contractPrice;
int contracts223CountCustomer = 0;
decimal contracts223SumCustomer = 0.0m;
string ogrnCustomer = "";
string regionCodeCustomer = "";
string phoneCustomer = "";
string faxCustomer = "";
string emailCustomer = "";
string contactNameCustomer = "";
string addCustomer =
$"INSERT INTO {Program.Prefix}od_customer SET regNumber = @customer_regnumber, inn = @inn_customer, " +
$"kpp = @kpp_customer, contracts_count = @contracts_count_customer, contracts223_count = @contracts223_count_customer," +
$"contracts_sum = @contracts_sum_customer, contracts223_sum = @contracts223_sum_customer," +
$"ogrn = @ogrn_customer, region_code = @region_code_customer, full_name = @full_name_customer," +
$"postal_address = @postal_address_customer, phone = @phone_customer, fax = @fax_customer," +
$"email = @email_customer, contact_name = @contact_name_customer";
MySqlCommand cmd4 = new MySqlCommand(addCustomer, connect);
cmd4.Prepare();
cmd4.Parameters.AddWithValue("@customer_regnumber", customerRegnumber);
cmd4.Parameters.AddWithValue("@inn_customer", innCustomer);
cmd4.Parameters.AddWithValue("@kpp_customer", kppCustomer);
cmd4.Parameters.AddWithValue("@contracts_count_customer", contractsCountCustomer);
cmd4.Parameters.AddWithValue("@contracts223_count_customer", contracts223CountCustomer);
cmd4.Parameters.AddWithValue("@contracts_sum_customer", contractsSumCustomer);
cmd4.Parameters.AddWithValue("@contracts223_sum_customer", contracts223SumCustomer);
cmd4.Parameters.AddWithValue("@ogrn_customer", ogrnCustomer);
cmd4.Parameters.AddWithValue("@region_code_customer", regionCodeCustomer);
cmd4.Parameters.AddWithValue("@full_name_customer", fullNameCustomer);
cmd4.Parameters.AddWithValue("@postal_address_customer", postalAddressCustomer);
cmd4.Parameters.AddWithValue("@phone_customer", phoneCustomer);
cmd4.Parameters.AddWithValue("@fax_customer", faxCustomer);
cmd4.Parameters.AddWithValue("@email_customer", emailCustomer);
cmd4.Parameters.AddWithValue("@contact_name_customer", contactNameCustomer);
int addC = cmd4.ExecuteNonQuery();
idCustomer = (int)cmd4.LastInsertedId;
AddCustomerEvent?.Invoke(addC);
}
}
var testSup = J44.SelectToken("export.contract.suppliers");
if (testSup != null && testSup.Type != JTokenType.Null)
{
var suppliers = testSup.SelectToken("supplier") ?? new JArray();
var enumerable = suppliers as IList <JToken> ?? suppliers.ToList();
if (enumerable.Any())
{
var sup = enumerable.First();
if (sup.Type == JTokenType.Property)
{
sup = enumerable.First().Parent;
}
string supplierInn = ((string)sup.SelectToken("legalEntityRF.INN") ?? "").Trim();
if (String.IsNullOrEmpty(supplierInn))
{
supplierInn = ((string)sup.SelectToken("individualPersonRF.INN") ?? "").Trim();
}
if (String.IsNullOrEmpty(supplierInn))
{
supplierInn = ((string)sup.SelectToken("legalEntityForeignState.INN") ?? "").Trim();
}
if (String.IsNullOrEmpty(supplierInn))
{
supplierInn =
((string)sup.SelectToken("legalEntityForeignState.taxPayerCode") ?? "").Trim();
}
if (String.IsNullOrEmpty(supplierInn))
{
supplierInn =
((string)sup.SelectToken("individualPersonForeignState.registerInRFTaxBodies.INN") ??
"").Trim();
}
if (String.IsNullOrEmpty(supplierInn))
{
supplierInn = ((string)sup.SelectToken("individualPersonForeignState.taxPayerCode") ?? "")
.Trim();
}
if (String.IsNullOrEmpty(supplierInn))
{
supplierInn = ((string)sup.SelectToken("individualPersonForeignState.INN") ?? "").Trim();
}
if (!String.IsNullOrEmpty(supplierInn))
{
string kppSupplier = ((string)sup.SelectToken("legalEntityRF.KPP") ?? "").Trim();
if (String.IsNullOrEmpty(kppSupplier))
{
kppSupplier = ((string)sup.SelectToken("individualPersonRF.KPP") ?? "").Trim();
}
if (String.IsNullOrEmpty(kppSupplier))
{
kppSupplier =
((string)sup.SelectToken(
"individualPersonForeignState.registerInRFTaxBodies.KPP") ?? "").Trim();
}
string selectSupplier =
$"SELECT id FROM {Program.Prefix}od_supplier WHERE inn = @supplier_inn AND kpp = @kpp_supplier";
MySqlCommand cmd5 = new MySqlCommand(selectSupplier, connect);
cmd5.Prepare();
cmd5.Parameters.AddWithValue("@supplier_inn", supplierInn);
cmd5.Parameters.AddWithValue("@kpp_supplier", kppSupplier);
MySqlDataReader reader = cmd5.ExecuteReader();
bool resRead = reader.HasRows;
if (resRead)
{
reader.Read();
idSupplier = reader.GetInt32("id");
reader.Close();
}
else
{
reader.Close();
string contactphoneSupplier =
((string)sup.SelectToken("legalEntityRF.contactPhone") ?? "").Trim();
if (String.IsNullOrEmpty(contactphoneSupplier))
{
contactphoneSupplier =
((string)sup.SelectToken("individualPersonRF.contactPhone") ?? "").Trim();
}
if (String.IsNullOrEmpty(contactphoneSupplier))
{
contactphoneSupplier =
((string)sup.SelectToken(
"legalEntityForeignState.placeOfStayInRegCountry.contactPhone") ?? "").Trim();
}
if (String.IsNullOrEmpty(contactphoneSupplier))
{
contactphoneSupplier =
((string)sup.SelectToken(
"individualPersonForeignState.placeOfStayInRegCountry.contactPhone") ?? "")
.Trim();
}
string contactemailSupplier =
((string)sup.SelectToken("legalEntityRF.contactEMail") ?? "").Trim();
if (String.IsNullOrEmpty(contactemailSupplier))
{
contactemailSupplier =
((string)sup.SelectToken("individualPersonRF.contactEMail") ?? "").Trim();
}
if (String.IsNullOrEmpty(contactemailSupplier))
{
contactemailSupplier =
((string)sup.SelectToken(
"legalEntityForeignState.placeOfStayInRegCountry.contactEMail") ?? "").Trim();
}
if (String.IsNullOrEmpty(contactemailSupplier))
{
contactemailSupplier =
((string)sup.SelectToken(
"individualPersonForeignState.placeOfStayInRegCountry.contactEMail") ?? "")
.Trim();
}
string organizationnameSupplier =
((string)sup.SelectToken("legalEntityRF.fullName") ?? "").Trim();
if (String.IsNullOrEmpty(organizationnameSupplier))
{
organizationnameSupplier =
((string)sup.SelectToken("legalEntityForeignState.fullName") ?? "").Trim();
}
if (String.IsNullOrEmpty(organizationnameSupplier))
{
string lastname = ((string)sup.SelectToken("individualPersonRF.lastName") ?? "")
.Trim();
if (String.IsNullOrEmpty(lastname))
{
lastname = ((string)sup.SelectToken("individualPersonForeignState.lastName") ??
"").Trim();
}
string firsname = ((string)sup.SelectToken("individualPersonRF.firstName") ?? "")
.Trim();
if (String.IsNullOrEmpty(firsname))
{
firsname =
((string)sup.SelectToken("individualPersonForeignState.firstName") ?? "")
.Trim();
}
string middlename =
((string)sup.SelectToken("individualPersonRF.middleName") ?? "").Trim();
if (String.IsNullOrEmpty(middlename))
{
middlename =
((string)sup.SelectToken("individualPersonForeignState.middleName") ?? "")
.Trim();
}
if (!String.IsNullOrEmpty(lastname) || !String.IsNullOrEmpty(firsname) ||
!String.IsNullOrEmpty(middlename))
{
organizationnameSupplier = $"{lastname} {firsname} {middlename}".Trim();
}
}
int contractsCountSupplier = 1;
string contractsSumSupplier = contractPrice;
int contracts223CountSupplier = 0;
decimal contracts223SumSupplier = 0.0m;
string ogrnSupplier = "";
string regionCodeSupplier = "";
string postalAddressSupplier = "";
string contactfaxSupplier = "";
string contactNameSupplier = "";
string addSupplier =
$"INSERT INTO {Program.Prefix}od_supplier SET inn = @supplier_inn, kpp = @kpp_supplier, " +
$"contracts_count = @contracts_count, " +
$"contracts223_count = @contracts223_count, contracts_sum = @contracts_sum, " +
$"contracts223_sum = @contracts223_sum, ogrn = @ogrn,region_code = @region_code, " +
$"organizationName = @organizationName,postal_address = @postal_address, " +
$"contactPhone = @contactPhone,contactFax = @contactFax, " +
$"contactEMail = @contactEMail,contact_name = @contact_name";
MySqlCommand cmd6 = new MySqlCommand(addSupplier, connect);
cmd6.Prepare();
cmd6.Parameters.AddWithValue("@supplier_inn", supplierInn);
cmd6.Parameters.AddWithValue("@kpp_supplier", kppSupplier);
cmd6.Parameters.AddWithValue("@contracts_count", contractsCountSupplier);
cmd6.Parameters.AddWithValue("@contracts223_count", contracts223CountSupplier);
cmd6.Parameters.AddWithValue("@contracts_sum", contractsSumSupplier);
cmd6.Parameters.AddWithValue("@contracts223_sum", contracts223SumSupplier);
cmd6.Parameters.AddWithValue("@ogrn", ogrnSupplier);
cmd6.Parameters.AddWithValue("@region_code", regionCodeSupplier);
cmd6.Parameters.AddWithValue("@organizationName", organizationnameSupplier);
cmd6.Parameters.AddWithValue("@postal_address", postalAddressSupplier);
cmd6.Parameters.AddWithValue("@contactPhone", contactphoneSupplier);
cmd6.Parameters.AddWithValue("@contactFax", contactfaxSupplier);
cmd6.Parameters.AddWithValue("@contactEMail", contactemailSupplier);
cmd6.Parameters.AddWithValue("@contact_name", contactNameSupplier);
int addS = cmd6.ExecuteNonQuery();
idSupplier = (int)cmd6.LastInsertedId;
AddSupplierEvent?.Invoke(addS);
}
}
}
}
int idOdContract = 0;
string selectContract =
$"SELECT id FROM {Program.Prefix}od_contract WHERE id_contract = @id_contract AND region_code = @region_code";
MySqlCommand cmd7 = new MySqlCommand(selectContract, connect);
cmd7.Prepare();
cmd7.Parameters.AddWithValue("@id_contract", idContract);
cmd7.Parameters.AddWithValue("@region_code", Region);
MySqlDataReader readerC = cmd7.ExecuteReader();
if (readerC.HasRows)
{
readerC.Read();
idOdContract = readerC.GetInt32("id");
readerC.Close();
string deleteProducts =
$"DELETE FROM {Program.Prefix}od_contract_product WHERE id_od_contract = @id_od_contract";
MySqlCommand cmd8 = new MySqlCommand(deleteProducts, connect);
cmd8.Prepare();
cmd8.Parameters.AddWithValue("@id_od_contract", idOdContract);
cmd8.ExecuteNonQuery();
string updateContract =
$"UPDATE {Program.Prefix}od_contract SET p_number = @p_number, regnum = @regnum, " +
$"current_contract_stage = @current_contract_stage, placing = @placing, " +
$"region_code = @region_code, url = @url, sign_date = @sign_date, " +
$"single_customer_reason_code = @single_customer_reason_code, single_customer_reason_name = @single_customer_reason_name, " +
$"fz = @fz, notification_number = @notification_number, lot_number = @lot_number, " +
$"contract_price = @contract_price, currency = @currency, version_number = @version_number, " +
$"execution_start_date = @execution_start_date, execution_end_date = @execution_end_date, " +
$"id_customer = @id_customer, id_supplier = @id_supplier, xml = @xml WHERE id = @id_od_contract";
MySqlCommand cmd9 = new MySqlCommand(updateContract, connect);
cmd9.Prepare();
cmd9.Parameters.AddWithValue("@p_number", pNumber);
cmd9.Parameters.AddWithValue("@regnum", regnum);
cmd9.Parameters.AddWithValue("@current_contract_stage", currentContractStage);
cmd9.Parameters.AddWithValue("@placing", placing);
cmd9.Parameters.AddWithValue("@region_code", Region);
cmd9.Parameters.AddWithValue("@url", url);
cmd9.Parameters.AddWithValue("@sign_date", signDate);
cmd9.Parameters.AddWithValue("@single_customer_reason_code", singleCustomerReasonCode);
cmd9.Parameters.AddWithValue("@single_customer_reason_name", singleCustomerReasonName);
cmd9.Parameters.AddWithValue("@fz", fz);
cmd9.Parameters.AddWithValue("@notification_number", notificationNumber);
cmd9.Parameters.AddWithValue("@lot_number", lotNumber);
cmd9.Parameters.AddWithValue("@contract_price", contractPrice);
cmd9.Parameters.AddWithValue("@currency", currency);
cmd9.Parameters.AddWithValue("@version_number", versionNumber);
cmd9.Parameters.AddWithValue("@execution_start_date", executionStartDate);
cmd9.Parameters.AddWithValue("@execution_end_date", executionEndDate);
cmd9.Parameters.AddWithValue("@id_customer", idCustomer);
cmd9.Parameters.AddWithValue("@id_supplier", idSupplier);
cmd9.Parameters.AddWithValue("@xml", xml);
cmd9.Parameters.AddWithValue("@id_od_contract", idOdContract);
int updC = cmd9.ExecuteNonQuery();
UpdateContractEvent?.Invoke(updC);
}
else
{
readerC.Close();
string insertContract =
$"INSERT INTO {Program.Prefix}od_contract SET id_contract = @id_contract, p_number = @p_number, regnum = @regnum, " +
$"current_contract_stage = @current_contract_stage, placing = @placing, " +
$"region_code = @region_code, url = @url, sign_date = @sign_date, " +
$"single_customer_reason_code = @single_customer_reason_code, single_customer_reason_name = @single_customer_reason_name, " +
$"fz = @fz, notification_number = @notification_number, lot_number = @lot_number, " +
$"contract_price = @contract_price, currency = @currency, version_number = @version_number, " +
$"execution_start_date = @execution_start_date, execution_end_date = @execution_end_date, " +
$"id_customer = @id_customer, id_supplier = @id_supplier, cancel = @cancel, xml = @xml";
MySqlCommand cmd10 = new MySqlCommand(insertContract, connect);
cmd10.Prepare();
cmd10.Parameters.AddWithValue("@id_contract", idContract);
cmd10.Parameters.AddWithValue("@p_number", pNumber);
cmd10.Parameters.AddWithValue("@regnum", regnum);
cmd10.Parameters.AddWithValue("@current_contract_stage", currentContractStage);
cmd10.Parameters.AddWithValue("@placing", placing);
cmd10.Parameters.AddWithValue("@region_code", Region);
cmd10.Parameters.AddWithValue("@url", url);
cmd10.Parameters.AddWithValue("@sign_date", signDate);
cmd10.Parameters.AddWithValue("@single_customer_reason_code", singleCustomerReasonCode);
cmd10.Parameters.AddWithValue("@single_customer_reason_name", singleCustomerReasonName);
cmd10.Parameters.AddWithValue("@fz", fz);
cmd10.Parameters.AddWithValue("@notification_number", notificationNumber);
cmd10.Parameters.AddWithValue("@lot_number", lotNumber);
cmd10.Parameters.AddWithValue("@contract_price", contractPrice);
cmd10.Parameters.AddWithValue("@currency", currency);
cmd10.Parameters.AddWithValue("@version_number", versionNumber);
cmd10.Parameters.AddWithValue("@execution_start_date", executionStartDate);
cmd10.Parameters.AddWithValue("@execution_end_date", executionEndDate);
cmd10.Parameters.AddWithValue("@id_customer", idCustomer);
cmd10.Parameters.AddWithValue("@id_supplier", idSupplier);
cmd10.Parameters.AddWithValue("@cancel", cancel);
cmd10.Parameters.AddWithValue("@xml", xml);
int addContr = cmd10.ExecuteNonQuery();
idOdContract = (int)cmd10.LastInsertedId;
AddContractEvent?.Invoke(addContr);
}
var testProd = J44.SelectToken("export.contract.products");
if (testProd != null && testProd.Type != JTokenType.Null)
{
var products = testProd.SelectToken("product");
if (products.Any())
{
List <JToken> listP = new List <JToken>();
if (products.Type == JTokenType.Array)
{
foreach (var p in products)
{
listP.Add(p);
}
}
else
{
listP.Add(products);
}
if (listP.Count == 0)
{
Log.Logger("У контракта нет продуктов", File);
return;
}
MySqlTransaction transaction = connect.BeginTransaction();
foreach (var prod in listP)
{
int okpd2GroupCode = 0;
string okpd2GroupLevel1Code = "";
int okpdGroupCode = 0;
string okpdGroupLevel1Code = "";
string nameP = ((string)prod.SelectToken("name") ?? "").Trim();
nameP = Regex.Replace(nameP, @"\t|\n|\r", "");
if (String.IsNullOrEmpty(nameP))
{
nameP = "Нет названия";
}
string okpd2Code = ((string)prod.SelectToken("OKPD2.code") ?? "").Trim();
if (!String.IsNullOrEmpty(okpd2Code))
{
GetOkpd(okpd2Code, out okpd2GroupCode, out okpd2GroupLevel1Code);
}
string okpd2Name = ((string)prod.SelectToken("OKPD2.name") ?? "").Trim();
string okpdCode = ((string)prod.SelectToken("OKPD.code") ?? "").Trim();
if (!String.IsNullOrEmpty(okpdCode))
{
GetOkpd(okpdCode, out okpdGroupCode, out okpdGroupLevel1Code);
}
string okpdName = ((string)prod.SelectToken("OKPD.name") ?? "").Trim();
string price = ((string)prod.SelectToken("price") ?? "").Trim();
/*decimal price = decimal.Parse(price_s, NumberStyles.Any, CultureInfo.InvariantCulture);*/
string quantity = ((string)prod.SelectToken("quantity") ?? "").Trim();
/*decimal quantity =
* decimal.Parse(quantity_s, NumberStyles.Any, CultureInfo.InvariantCulture);*/
string sumP = ((string)prod.SelectToken("sum") ?? "").Trim();
/*decimal sum_p = decimal.Parse(sum_p_s, NumberStyles.Any, CultureInfo.InvariantCulture);*/
string sid = ((string)prod.SelectToken("sid") ?? "").Trim();
string okei = ((string)prod.SelectToken("OKEI.nationalCode") ?? "").Trim();
string insertProd =
$"INSERT INTO {Program.Prefix}od_contract_product SET id_od_contract = @id_od_contract, " +
$"name = @name_p, okpd2_code = @okpd2_code, okpd_code = @okpd_code, okpd2_group_code = @okpd2_group_code, " +
$"okpd_group_code = @okpd_group_code, okpd2_group_level1_code = @okpd2_group_level1_code, " +
$"okpd_group_level1_code = @okpd_group_level1_code, price = @price, okpd2_name = @okpd2_name, " +
$"okpd_name = @okpd_name, quantity = @quantity, okei = @okei, sum = @sum, sid = @sid";
MySqlCommand cmd11 = new MySqlCommand(insertProd, connect);
cmd11.Transaction = transaction;
cmd11.Prepare();
cmd11.Parameters.AddWithValue("@id_od_contract", idOdContract);
cmd11.Parameters.AddWithValue("@name_p", nameP);
cmd11.Parameters.AddWithValue("@okpd2_code", okpd2Code);
cmd11.Parameters.AddWithValue("@okpd_code", okpdCode);
cmd11.Parameters.AddWithValue("@okpd2_group_code", okpd2GroupCode);
cmd11.Parameters.AddWithValue("@okpd_group_code", okpdGroupCode);
cmd11.Parameters.AddWithValue("@okpd2_group_level1_code", okpd2GroupLevel1Code);
cmd11.Parameters.AddWithValue("@okpd_group_level1_code", okpdGroupLevel1Code);
cmd11.Parameters.AddWithValue("@price", price);
cmd11.Parameters.AddWithValue("@okpd2_name", okpd2Name);
cmd11.Parameters.AddWithValue("@okpd_name", okpdName);
cmd11.Parameters.AddWithValue("@quantity", quantity);
cmd11.Parameters.AddWithValue("@okei", okei);
cmd11.Parameters.AddWithValue("@sum", sumP);
cmd11.Parameters.AddWithValue("@sid", sid);
int addP = cmd11.ExecuteNonQuery();
AddProductEvent?.Invoke(addP);
}
transaction.Commit();
}
}
}
}
public void Work223()
{
string xml = GetXml(File);
//Console.WriteLine(J223);
int idCustomer = 0;
int idSupplier = 0;
JToken c = J223.SelectToken("performanceContract.body.item.performanceContractData");
if (!c.IsNullOrEmpty())
{
string idContract = ((string)c.SelectToken("guid") ?? "").Trim();
if (String.IsNullOrEmpty(idContract))
{
Log.Logger("У контракта нет id", File);
return;
}
List <JToken> products = GetElements(c, "positions.position");
List <JToken> products2 = GetElements(c, "docs.doc");
string pNumber = idContract;
string regnum = ((string)c.SelectToken("registrationNumber") ?? "").Trim();
//Console.WriteLine(regnum);
string signNumber = ((string)c.SelectToken("contractRegNumber") ?? "").Trim();
string currentContractStage = "";
string placing = "";
string Url = ((string)c.SelectToken("urlOOS") ?? "").Trim();
DateTime signDate = (DateTime?)c.SelectToken("contractInfo.contractDate") ?? DateTime.MinValue;
string singleCustomerReasonCode = "";
string singleCustomerReasonName = "";
string fz = "223";
string notificationNumber = ((string)c.SelectToken("contractInfo.name") ?? "").Trim();
int lotNumber = 1;
decimal contractPrice = (decimal?)c.SelectToken("positions.total") ?? 0.00m;
if (contractPrice == 0.00m)
{
contractPrice = (decimal?)c.SelectToken("docs.total") ?? 0.00m;
}
string currency = "";
if (products.Count > 0)
{
currency = ((string)products[0].SelectToken("currency.code") ?? "").Trim();
}
else if (products2.Count > 0)
{
currency = ((string)products2[0].SelectToken("currency.code") ?? "").Trim();
}
int versionNumber = (int?)c.SelectToken("version") ?? 0;
int cancel = 0;
DateTime executionStartDate = signDate;
DateTime executionEndDate = (DateTime?)c.SelectToken("createDateTime") ?? DateTime.MinValue;
using (Contract223Context db = new Contract223Context())
{
if (!String.IsNullOrEmpty(regnum) && versionNumber != 0)
{
var maxNumber = db.Contracts223.Where(p => p.RegNum == regnum).Select(p => p.VersionNumber)
.DefaultIfEmpty(0).Max();
//Console.WriteLine(maxNumber);
if (versionNumber > maxNumber)
{
var Contr223 = db.Contracts223.Where(p => p.RegNum == regnum);
foreach (var c223 in Contr223)
{
c223.Cancel = 1;
db.Entry(c223).State = EntityState.Modified;
}
db.SaveChanges();
}
else
{
cancel = 1;
}
}
Customer cus = null;
string kppCustomer = ((string)c.SelectToken("customer.mainInfo.kpp") ?? "").Trim();
string innCustomer = ((string)c.SelectToken("customer.mainInfo.inn") ?? "").Trim();
//Console.WriteLine(innCustomer);
if (!String.IsNullOrEmpty(innCustomer))
{
cus = db.Customers.FirstOrDefault(p => p.Inn == innCustomer && p.Kpp == kppCustomer);
}
//Console.WriteLine(cus);
var contr = db.Contracts223.Include(p => p.Products).FirstOrDefault(
p => p.IdContract == idContract && p.RegionCode == Region);
if (contr != null)
{
contr.IdContract = idContract;
contr.PNumber = pNumber;
contr.RegNum = regnum;
contr.CurrentContractStage = currentContractStage;
contr.Placing = placing;
contr.RegionCode = Region;
contr.Url = Url;
contr.SignDate = signDate;
contr.SingleCustomerReasonCode = singleCustomerReasonCode;
contr.SingleCustomerReasonName = singleCustomerReasonName;
contr.Fz = fz;
contr.NotificationNumber = notificationNumber;
contr.LotNumber = lotNumber;
contr.ContractPrice = contractPrice;
contr.Currency = currency;
contr.VersionNumber = versionNumber;
contr.ExecutionStartDate = executionStartDate;
contr.ExecutionEndDate = executionEndDate;
if (cus == null)
{
contr.CustomerId = idCustomer;
}
else
{
contr.Customer = cus;
}
contr.SupplierId = idSupplier;
contr.Xml = xml;
contr.SignNumber = signNumber;
db.Entry(contr).State = EntityState.Modified;
db.SaveChanges();
UpdateContractEvent?.Invoke(1);
foreach (var p in contr.Products.ToList())
{
db.Products.Remove(p);
db.Entry(p).State = EntityState.Deleted;
}
db.SaveChanges();
}
else
{
contr = new Contract223
{
IdContract = idContract,
PNumber = pNumber,
RegNum = regnum,
CurrentContractStage = currentContractStage,
Placing = placing,
RegionCode = Region,
Url = Url,
SignDate = signDate,
SingleCustomerReasonCode = singleCustomerReasonCode,
SingleCustomerReasonName = singleCustomerReasonName,
Fz = fz,
NotificationNumber = notificationNumber,
LotNumber = lotNumber,
ContractPrice = contractPrice,
Currency = currency,
VersionNumber = versionNumber,
ExecutionStartDate = executionStartDate,
ExecutionEndDate = executionEndDate,
SupplierId = idSupplier,
Xml = xml,
SignNumber = signNumber
};
if (cus == null)
{
contr.CustomerId = 0;
}
else
{
contr.Customer = cus;
}
db.Contracts223.Add(contr);
db.SaveChanges();
AddContractEvent?.Invoke(1);
}
if (products.Count > 0)
{
List <Product> pr = new List <Product>();
foreach (var pr223 in products)
{
var docs = GetElements(pr223, "docs.doc");
if (docs.Count == 0)
{
continue;
}
int okpd2GroupCode = 0;
string okpd2GroupLevel1Code = "";
int okpdGroupCode = 0;
string okpdGroupLevel1Code = "";
string nameP = ((string)docs[0].SelectToken("contractPosition.name") ?? "").Trim();
//Console.WriteLine(nameP);
nameP = Regex.Replace(nameP, @"\s+", " ");
if (String.IsNullOrEmpty(nameP))
{
nameP = "Нет названия";
}
string okpd2Code =
((string)docs[0].SelectToken("contractPosition.okpd2.code") ?? "").Trim();
if (!String.IsNullOrEmpty(okpd2Code))
{
GetOkpd(okpd2Code, out okpd2GroupCode, out okpd2GroupLevel1Code);
}
string okpd2Name =
((string)docs[0].SelectToken("contractPosition.okpd2.name") ?? "").Trim();
string okpdCode = ((string)docs[0].SelectToken("contractPosition.okpd.code") ?? "").Trim();
if (!String.IsNullOrEmpty(okpdCode))
{
GetOkpd(okpdCode, out okpdGroupCode, out okpdGroupLevel1Code);
}
string okpdName = ((string)docs[0].SelectToken("contractPosition.okpd.name") ?? "").Trim();
decimal sumP = (decimal?)pr223.SelectToken("price") ?? 0.00m;
decimal quantity = (decimal?)docs[0].SelectToken("qty") ?? 0.00m;
decimal price = 0.00m;
if (quantity != 0.00m)
{
price = sumP / quantity;
}
string sid = "";
string okei = ((string)docs[0].SelectToken("okei.name") ?? "").Trim();
Product p223 = new Product
{
Name = nameP,
Okpd2Code = okpd2Code,
OkpdCode = okpdCode,
Okpd2GroupCode = okpd2GroupCode,
OkpdGroupCode = okpdGroupCode,
Okpd2GroupLevel1Code = okpd2GroupLevel1Code,
OkpdGroupLevel1Code = okpdGroupLevel1Code,
Price = price,
Okpd2Name = okpd2Name,
OkpdName = okpdName,
Quantiity = quantity,
Okei = okei,
Sum = sumP,
Sid = sid,
Contract223 = contr
};
pr.Add(p223);
AddProductEvent?.Invoke(1);
}
db.Products.AddRange(pr);
db.SaveChanges();
}
else if (products2.Count > 0)
{
List <Product> pr = new List <Product>();
foreach (var pr223 in products2)
{
int okpd2GroupCode = 0;
string okpd2GroupLevel1Code = "";
int okpdGroupCode = 0;
string okpdGroupLevel1Code = "";
string nameP = ((string)pr223.SelectToken("contractPosition.name") ?? "").Trim();
//Console.WriteLine(nameP);
nameP = Regex.Replace(nameP, @"\s+", " ");
if (String.IsNullOrEmpty(nameP))
{
nameP = "Нет названия";
}
string okpd2Code =
((string)pr223.SelectToken("contractPosition.okpd2.code") ?? "").Trim();
if (!String.IsNullOrEmpty(okpd2Code))
{
GetOkpd(okpd2Code, out okpd2GroupCode, out okpd2GroupLevel1Code);
}
string okpd2Name =
((string)pr223.SelectToken("contractPosition.okpd2.name") ?? "").Trim();
string okpdCode = ((string)pr223.SelectToken("contractPosition.okpd.code") ?? "").Trim();
if (!String.IsNullOrEmpty(okpdCode))
{
GetOkpd(okpdCode, out okpdGroupCode, out okpdGroupLevel1Code);
}
string okpdName = ((string)pr223.SelectToken("contractPosition.okpd.name") ?? "").Trim();
decimal sumP = (decimal?)pr223.SelectToken("price") ?? 0.00m;
decimal quantity = (decimal?)pr223.SelectToken("qty") ?? 0.00m;
decimal price = 0.00m;
if (quantity != 0.00m)
{
price = sumP / quantity;
}
string sid = "";
string okei = ((string)pr223.SelectToken("okei.name") ?? "").Trim();
Product p223 = new Product
{
Name = nameP,
Okpd2Code = okpd2Code,
OkpdCode = okpdCode,
Okpd2GroupCode = okpd2GroupCode,
OkpdGroupCode = okpdGroupCode,
Okpd2GroupLevel1Code = okpd2GroupLevel1Code,
OkpdGroupLevel1Code = okpdGroupLevel1Code,
Price = price,
Okpd2Name = okpd2Name,
OkpdName = okpdName,
Quantiity = quantity,
Okei = okei,
Sum = sumP,
Sid = sid,
Contract223 = contr
};
pr.Add(p223);
AddProductEvent?.Invoke(1);
}
db.Products.AddRange(pr);
db.SaveChanges();
}
}
}
else
{
//Log.Logger("Не могу найти тег performanceContractData", File);
}
}
