public UpdateViewModel()
{
UpdataOrg = new RelayCommand(UpdateOrganization);
Clean = new RelayCommand(Clear);
SelectOrg = new RelayCommand(SelectForUpdate);
DelOrg = new RelayCommand(DeleteOrg);
updateModel = new UpdateOrgModel();
upsateRepo = new UpdateRepository();
_countryRepository = new CountryRepository(); //создаем экземпляр класса CountryRepository, который унаследован от интрефейса ICountryRepository
List <CountryModel> countries = _countryRepository.GetCountries(); // создаем список объектов с типом CountryModel при помощи метода обязательного (Интрерфес) методом GetCountries из репы
var countryVM = CountryMapper.CountryModelToCountryViewModel(countries); // при помощи статического метода CountryModelToCountryViewModel из класса CountryMapper приводим тип из Модели во Вью модель, чтобы наша вью модель могла работать с данными
_sectionRepository = new SectionRepository();
List <SectionModel> sections = _sectionRepository.GetSections();
var sectionVM = SectionMappers.SectionModelToSectionViewModel(sections);
Countries = countryVM;
Section = sectionVM;
Person = new UpdatePersViewModel(countryVM)
{
};
Organization = new UpdateOrgViewModel(countryVM, sectionVM)
{
CreateDateOrg = new DateTime()
};
}
public static UpdateOrgModel DateTimeToRiscDateTime(UpdateViewModel updateViewModel)
{
var orgForUppdates = new UpdateOrgModel
{
UNPOrg = updateViewModel.UNPOrg,
ShortNameOrg = updateViewModel.ShortNameOrg,
FullNameOrg = updateViewModel.FullNameOrg,
SharedVariable = updateViewModel.SharedVariable,
//OwnershipOrg = updateViewModel.OwnershipOrg.Value
};
return(orgForUppdates);
}
public static UpdateOrgModel OrganizationViewModelToOrganizationModel(UpdateViewModel updateViewModel)
{
var orgForUppdates = new UpdateOrgModel
{
UNPOrg = updateViewModel.UNPOrg,
ShortNameOrg = updateViewModel.ShortNameOrg,
FullNameOrg = updateViewModel.FullNameOrg,
SharedVariable = updateViewModel.SharedVariable,
//OwnershipOrg = updateViewModel.OwnershipOrg
};
return(orgForUppdates);
}
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 UpdOrgModelToUpdOrgViewModel(UpdateOrgModel updateOrgModel)
{
var orgForUppdates = new UpdateOrgViewModel
{
//SelectedCountry = updateOrgModel.SelectedCountry?.NameCountry,
//NameSection = updateOrgModel.NameSection,
// SelectedSection = updateOrgModel.SelectedSection?.NameSection,
//CountyrOrg = updateOrgModel.CountyrOrg,
UNPOrg = updateOrgModel.UNPOrg,
ShortNameOrg = updateOrgModel.ShortNameOrg,
FullNameOrg = updateOrgModel.FullNameOrg,
DescriptionOrg = updateOrgModel.DescriptionOrg,
BrokerOpinion = updateOrgModel.BrokerOpinion,
SectionHeadOpinion = updateOrgModel.SectionHeadOpinion,
AuditorOpinion = updateOrgModel.AuditorOpinion,
ForcedDeposite = updateOrgModel.ForcedDeposite,
OwnershipOrg = updateOrgModel.OwnershipOrg
};
//orgForUppdates.ExchengeTradingDisorders.Value = new UpdateOrgViewModel().OwnershipOrg.Value;
/* orgForUppdates.OwnershipOrg.Value = updateOrgModel.OwnershipOrg;
* orgForUppdates.TaxDebt.Value = updateOrgModel.TaxDebt;
* orgForUppdates.DebtsEnforcementDocuments.Value = updateOrgModel.DebtsEnforcementDocuments;
* orgForUppdates.FalseBusiness.Value = updateOrgModel.FalseBusiness;
* orgForUppdates.SpecialRisc.Value = updateOrgModel.SpecialRisc;
* orgForUppdates.ExecuteProc.Value = updateOrgModel.ExecuteProc;
* orgForUppdates.BankruptcyProc.Value = updateOrgModel.BankruptcyProc;
* orgForUppdates.LiquidationProc.Value = updateOrgModel.LiquidationProc;
* // orgForUppdates.BrokerClient.Value = updateOrgModel.BrokerClient;
* orgForUppdates.PrevBrokerClient.Value = updateOrgModel.PrevBrokerClient;
*
* orgForUppdates.Manufacturer.Value = updateOrgModel.Manufacturer;
*
* orgForUppdates.NegativData.Value = updateOrgModel.NegativData;
* orgForUppdates.Reputation.Value = updateOrgModel.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());
}
public KontragentModelUpdate(UpdateOrgModel orgModelForUpdate, UpdatePersModel persModelForUpdate)
{
OrgForUpdate = orgModelForUpdate;
PersForUpdate = persModelForUpdate;
}
