private void SelectForUpdate(object obj)
{
updateModel = UpdateMapper.OrganizationViewModelToOrganizationModel(this);
kontragentModelUpdate = upsateRepo.FindOrgForUpdate(updateModel);
Organization.UNPOrg = kontragentModelUpdate.OrgForUpdate?.UNPOrg;
Organization.FullNameOrg = kontragentModelUpdate.OrgForUpdate?.FullNameOrg;
Organization.ShortNameOrg = kontragentModelUpdate.OrgForUpdate?.ShortNameOrg;
Organization.BrokerOpinion = kontragentModelUpdate.OrgForUpdate?.BrokerOpinion;
Organization.AuditorOpinion = kontragentModelUpdate.OrgForUpdate?.AuditorOpinion;
Organization.SectionHeadOpinion = kontragentModelUpdate.OrgForUpdate?.SectionHeadOpinion;
Organization.DescriptionOrg = kontragentModelUpdate.OrgForUpdate?.DescriptionOrg;
Organization.CreateDateOrg = kontragentModelUpdate.OrgForUpdate.CreateDateOrg;
Organization.SelectedCountry = Countries.FirstOrDefault(x => x.NameCountry == kontragentModelUpdate.OrgForUpdate.CountyrOrg);
Organization.SelectedSection = Section.FirstOrDefault(x => x.NameSection == kontragentModelUpdate.OrgForUpdate.NameSection);
Organization.OwnershipOrg = kontragentModelUpdate.OrgForUpdate.OwnershipOrg;
Organization.TaxDebt = kontragentModelUpdate.OrgForUpdate.TaxDebt;
Organization.DebtsEnforcementDocuments = kontragentModelUpdate.OrgForUpdate.DebtsEnforcementDocuments;
Organization.FalseBusiness = kontragentModelUpdate.OrgForUpdate.FalseBusiness;
Organization.SpecialRisc = kontragentModelUpdate.OrgForUpdate.SpecialRisc;
Organization.ExecuteProc = kontragentModelUpdate.OrgForUpdate.ExecuteProc;
Organization.BankruptcyProc = kontragentModelUpdate.OrgForUpdate.BankruptcyProc;
Organization.LiquidationProc = kontragentModelUpdate.OrgForUpdate.LiquidationProc;
Organization.BrokerClient = kontragentModelUpdate.OrgForUpdate.BrokerClient;
Organization.PrevBrokerClient = kontragentModelUpdate.OrgForUpdate.PrevBrokerClient;
Organization.Manufacturer = kontragentModelUpdate.OrgForUpdate.Manufacturer;
Organization.NegativData = kontragentModelUpdate.OrgForUpdate.NegativData;
Organization.Reputation = kontragentModelUpdate.OrgForUpdate.Reputation;
Organization.ExchengeTradingDisorders = kontragentModelUpdate.OrgForUpdate.ExchengeTradingDisorders;
Organization.SecondAccred = kontragentModelUpdate.OrgForUpdate.SecondAccred;
Organization.ForcedDeposite = kontragentModelUpdate.OrgForUpdate.ForcedDeposite;
Organization.Deposit = kontragentModelUpdate.OrgForUpdate.Deposit;
Organization.RecomendDeposit = kontragentModelUpdate.OrgForUpdate.RecomendDeposit;
Person.DescriptionPers = kontragentModelUpdate.PersForUpdate?.DescriptionPers;
Person.HeadName = kontragentModelUpdate.PersForUpdate?.HeadName;
Person.OwnerName = kontragentModelUpdate.PersForUpdate?.OwnerName;
Person.SelectedCountry = Countries.FirstOrDefault(x => x.NameCountry == kontragentModelUpdate.PersForUpdate.СountryPers);
Person.PrevLiquidated = kontragentModelUpdate.PersForUpdate.PrevBankruptcy;
Person.PrevBankruptcy = kontragentModelUpdate.PersForUpdate.PrevBankruptcy;
Person.PrevStateDebt = kontragentModelUpdate.PersForUpdate.PrevStateDebt;
Person.PrevTaxDebt = kontragentModelUpdate.PersForUpdate.PrevTaxDebt;
Person.PrevExecuteProc = kontragentModelUpdate.PersForUpdate.PrevExecuteProc;
Person.NegativDataPers = kontragentModelUpdate.PersForUpdate.NegativDataPers;
Organization.RiskLevel = kontragentModelUpdate.OrgForUpdate.RiscLevel.ToString();
}
public static UpdateOrgViewModel UpdKontraToUpdOrgViewModel(KontragentModelUpdate updateOrgModel)
{
var orgForUppdates = new UpdateOrgViewModel
{
UNPOrg = updateOrgModel.OrgForUpdate.UNPOrg,
ShortNameOrg = updateOrgModel.OrgForUpdate.ShortNameOrg,
FullNameOrg = updateOrgModel.OrgForUpdate.FullNameOrg,
DescriptionOrg = updateOrgModel.OrgForUpdate.DescriptionOrg,
BrokerOpinion = updateOrgModel.OrgForUpdate.BrokerOpinion,
SectionHeadOpinion = updateOrgModel.OrgForUpdate.SectionHeadOpinion,
AuditorOpinion = updateOrgModel.OrgForUpdate.AuditorOpinion,
ForcedDeposite = updateOrgModel.OrgForUpdate.ForcedDeposite,
};
// orgForUppdates.ExchengeTradingDisorders.Value = updateOrgModel.OrgForUpdate.ExchengeTradingDisorders;..
/* orgForUppdates.OwnershipOrg.Value = updateOrgModel.OrgForUpdate.OwnershipOrg;
* orgForUppdates.TaxDebt.Value = updateOrgModel.OrgForUpdate.TaxDebt;
* orgForUppdates.DebtsEnforcementDocuments.Value = updateOrgModel.OrgForUpdate.DebtsEnforcementDocuments;
* orgForUppdates.FalseBusiness.Value = updateOrgModel.OrgForUpdate.FalseBusiness;
* orgForUppdates.SpecialRisc.Value = updateOrgModel.OrgForUpdate.SpecialRisc;
* orgForUppdates.ExecuteProc.Value = updateOrgModel.OrgForUpdate.ExecuteProc;
* orgForUppdates.BankruptcyProc.Value = updateOrgModel.OrgForUpdate.BankruptcyProc;
* orgForUppdates.LiquidationProc.Value = updateOrgModel.OrgForUpdate.LiquidationProc;
* orgForUppdates.BrokerClient.Value = updateOrgModel.OrgForUpdate.BrokerClient;
* orgForUppdates.PrevBrokerClient.Value = updateOrgModel.OrgForUpdate.PrevBrokerClient;
*
* orgForUppdates.Manufacturer.Value = updateOrgModel.OrgForUpdate.Manufacturer;
*
* orgForUppdates.NegativData.Value = updateOrgModel.OrgForUpdate.NegativData;
* orgForUppdates.Reputation.Value = updateOrgModel.OrgForUpdate.Reputation;*/
return(orgForUppdates);
}
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());
}
