public KontragentModelUpdate FindOrgForUpdate(UpdateOrgModel orgModelForUpdate)
{
UpdateOrgModel searchOrg = new UpdateOrgModel();
UpdatePersModel searchPer = new UpdatePersModel();
KontragentModelUpdate kontragent = new KontragentModelUpdate();
using (SqlConnection sqlConnection = new SqlConnection(connectionStringSQL))
{
sqlConnection.Open();
SqlCommand SelectForUpdatecomm = new SqlCommand("Select_For_Apdate", sqlConnection);
SelectForUpdatecomm.CommandType = CommandType.StoredProcedure;
SelectForUpdatecomm.Parameters.AddWithValue("UNP_Org", orgModelForUpdate.SharedVariable);
SelectForUpdatecomm.Parameters.AddWithValue("Short_Name_Org", orgModelForUpdate.ShortNameOrg);
SelectForUpdatecomm.Parameters.AddWithValue("Full_Name_Org", orgModelForUpdate.FullNameOrg);
SqlDataReader sqlDataReader = SelectForUpdatecomm.ExecuteReader();
if (sqlDataReader.HasRows != true)
{
SelectForUpdatecomm.Cancel();
sqlDataReader.Close();
SelectForUpdatecomm = new SqlCommand("Select_For_Apdate", sqlConnection);
SelectForUpdatecomm.CommandType = CommandType.StoredProcedure;
SelectForUpdatecomm.Parameters.AddWithValue("UNP_Org", orgModelForUpdate.UNPOrg);
SelectForUpdatecomm.Parameters.AddWithValue("Short_Name_Org", orgModelForUpdate.SharedVariable);
SelectForUpdatecomm.Parameters.AddWithValue("Full_Name_Org", orgModelForUpdate.FullNameOrg);
sqlDataReader = SelectForUpdatecomm.ExecuteReader();
}
if (sqlDataReader.HasRows != true)
{
SelectForUpdatecomm.Cancel();
sqlDataReader.Close();
SelectForUpdatecomm = new SqlCommand("Select_For_Apdate", sqlConnection);
SelectForUpdatecomm.CommandType = CommandType.StoredProcedure;
SelectForUpdatecomm.Parameters.AddWithValue("UNP_Org", orgModelForUpdate.UNPOrg);
SelectForUpdatecomm.Parameters.AddWithValue("Short_Name_Org", orgModelForUpdate.ShortNameOrg);
SelectForUpdatecomm.Parameters.AddWithValue("Full_Name_Org", orgModelForUpdate.SharedVariable);
sqlDataReader = SelectForUpdatecomm.ExecuteReader();
}
if (sqlDataReader.HasRows != true)
{
if (kontragent.OrgForUpdate == null || kontragent.PersForUpdate == null)
{
MessageBox.Show("Организация не найдена в базе данных", "Ошибка организации ", MessageBoxButton.OK, MessageBoxImage.Error);
}
searchOrg = new UpdateOrgModel();
searchPer = new UpdatePersModel();
KontragentModelUpdate kontr = new KontragentModelUpdate();
kontr.OrgForUpdate = searchOrg;
kontr.PersForUpdate = searchPer;
return(kontr);
}
int count = 0;
while (sqlDataReader.Read())
{
count += 1;
searchOrg.UNPOrg = Convert.ToString(sqlDataReader["UNP_Org"]);
searchOrg.ShortNameOrg = Convert.ToString(sqlDataReader["Short_Name_Org"]);
searchOrg.FullNameOrg = Convert.ToString(sqlDataReader["Full_Name_Org"]);
searchOrg.CreateDateOrg = Convert.ToDateTime(sqlDataReader["Create_date_Org"]);
searchOrg.CountyrOrg = Convert.ToString(sqlDataReader["Name_Country"]);
searchOrg.NameSection = Convert.ToString(sqlDataReader["Name_Section"]);
searchOrg.DescriptionOrg = Convert.ToString(sqlDataReader["Description_Org"]);
searchOrg.BrokerOpinion = Convert.ToString(sqlDataReader["Broker_Opinion"]);
searchOrg.SectionHeadOpinion = Convert.ToString(sqlDataReader["Section_Head_Opinion"]);
searchOrg.AuditorOpinion = Convert.ToString(sqlDataReader["Auditor_Opinion"]);
searchOrg.OwnershipOrg = Convert.ToBoolean(sqlDataReader["Ownership_Org"]);
searchOrg.TaxDebt = Convert.ToBoolean(sqlDataReader["Tax_Debt"]);
searchOrg.DebtsEnforcementDocuments = Convert.ToBoolean(sqlDataReader["Debts_Enforcement_Documents"]);
searchOrg.FalseBusiness = Convert.ToBoolean(sqlDataReader["False_Business"]);
searchOrg.SpecialRisc = Convert.ToBoolean(sqlDataReader["Special_Risc"]);
searchOrg.ExecuteProc = Convert.ToBoolean(sqlDataReader["Execute_Proc"]);
searchOrg.BankruptcyProc = Convert.ToBoolean(sqlDataReader["Bankruptcy_Proc"]);
searchOrg.LiquidationProc = Convert.ToBoolean(sqlDataReader["Liquidation_Proc"]);
searchOrg.Resident = Convert.ToBoolean(sqlDataReader["Resident"]);
searchOrg.BrokerClient = Convert.ToBoolean(sqlDataReader["Broker_Client"]);
searchOrg.PrevBrokerClient = Convert.ToBoolean(sqlDataReader["Prev_Broker_Client"]);
searchOrg.Tradingexperience = Convert.ToBoolean(sqlDataReader["Trading_experience"]);
searchOrg.Trader = Convert.ToBoolean(sqlDataReader["Trader"]);
searchOrg.Manufacturer = Convert.ToBoolean(sqlDataReader["Manufacturer"]);
searchOrg.RecomendDeposit = Convert.ToString(sqlDataReader["Рекомендуемый вид задатка"]);
searchOrg.Deposit = Convert.ToString(sqlDataReader["Вид задатка"]);
searchOrg.FirstAccred = Convert.ToBoolean(sqlDataReader["First_Accred"]);
searchOrg.SecondAccred = Convert.ToBoolean(sqlDataReader["Second_Accred"]);
searchOrg.ExchengeTradingDisorders = Convert.ToBoolean(sqlDataReader["Exchenge_Trading_Disorders"]);
searchOrg.NegativData = Convert.ToBoolean(sqlDataReader["Negativ_Data"]);
searchPer.NegativDataPers = Convert.ToBoolean(sqlDataReader["Negativ_Data_Pers"]);
searchOrg.Reputation = Convert.ToBoolean(sqlDataReader["Reputation"]);
searchOrg.RiscLevel = Convert.ToInt32(sqlDataReader["Степень риска"]);
searchOrg.ForcedDeposite = Convert.ToBoolean(sqlDataReader["Forced_Deposite"]);
searchPer.СountryPers = Convert.ToString(sqlDataReader["Country_Pers"]);
searchPer.OwnerName = Convert.ToString(sqlDataReader["Owner_Name"]);
searchPer.HeadName = Convert.ToString(sqlDataReader["Head_Name"]);
searchPer.DescriptionPers = Convert.ToString(sqlDataReader["Description_Pers"]);
searchPer.PrevLiquidated = Convert.ToBoolean(sqlDataReader["Prev_Liquidated"]);
searchPer.PrevBankruptcy = Convert.ToBoolean(sqlDataReader["Prev_Bankruptcy"]);
searchPer.PrevStateDebt = Convert.ToBoolean(sqlDataReader["Prev_State_Debt"]);
searchPer.PrevTaxDebt = Convert.ToBoolean(sqlDataReader["Prev_Tax_Debt"]);
searchPer.PrevExecuteProc = Convert.ToBoolean(sqlDataReader["Prev_Execute_Proc"]);
searchPer.NegativDataPers = Convert.ToBoolean(sqlDataReader["Prev_Execute_Proc"]);
kontragent = new KontragentModelUpdate(searchOrg, searchPer);
if (count > 1)
{
MessageBox.Show($"По заданному параметру \"{orgModelForUpdate.SharedVariable}\" найдено более одной организации!\nДля избежания некорректного форматирования данных нпишите УНП или название организации более подробно.", "Ошибка организации ", MessageBoxButton.OK, MessageBoxImage.Error);
return(new KontragentModelUpdate());
}
}
sqlDataReader.Close();
sqlConnection.Close();
}
return(kontragent ?? new KontragentModelUpdate());
}
public KontragentModelUpdate(UpdateOrgModel orgModelForUpdate, UpdatePersModel persModelForUpdate)
{
OrgForUpdate = orgModelForUpdate;
PersForUpdate = persModelForUpdate;
}
