private bool FillForJuridicial(int id) { using SqlConnection sqlConnection = new SqlConnection(DataBase.ConnectionString); try { sqlConnection.Open(); SqlCommand command = new SqlCommand("SELECT * FROM [MortrageJuridicial] WHERE (Id = @Id)", sqlConnection); command.Parameters.AddWithValue("Id", id); SqlDataReader sqlReader = command.ExecuteReader(); sqlReader.Read(); int idModel = Convert.ToInt32(sqlReader["Id_Model"]); decimal currentSum = Convert.ToDecimal(sqlReader["CurrentSum"]); DateTime termEnd = Convert.ToDateTime(sqlReader["TermEnd"]); DateTime termStart = Convert.ToDateTime(sqlReader["TermStart"]); sqlReader.Close(); SqlCommand command1 = new SqlCommand("SELECT * FROM [MortrageModel] WHERE (Id = @Id)", sqlConnection); command1.Parameters.AddWithValue("Id", idModel); SqlDataReader sqlReader1 = command1.ExecuteReader(); sqlReader1.Read(); string name = Convert.ToString(sqlReader1["Name"]); CurrentModel = new MortrageModel(name); CurrentUser = new MortrageUser(currentSum, termStart, termEnd, (IMortrageModel)CurrentModel, currentSum); sqlReader1.Close(); sqlConnection.Close(); return(true); } catch (SqlException ex) { throw new Exception("Работа базы данных нарушена", ex); } finally { sqlConnection.Close(); } }
public MortrageCollection(MortrageModel mortrageModel, MortrageUser mortrageUser, Mortrage mortrage) { Id = mortrage.Id; Name = mortrageModel.Name; CurrentSum = Convert.ToDecimal(mortrageUser.InitialSum.ToString("N1")); TermStart = mortrageUser.TermStart; TermEnd = mortrageUser.TermEnd; AnnualRate = Convert.ToDecimal((mortrageModel.AnnualRate * 100).ToString("N1")); }
public MortrageControl(MortrageModel mortrageModel, IPerson person) { InitializeComponent(); _mortrageModel = mortrageModel; _person = person; mortrageModel.AnnualRate = Convert.ToDecimal((mortrageModel.AnnualRate * 100).ToString("N1")); mortrageModel.MinInitialSum = Convert.ToDecimal(mortrageModel.MinInitialSum.ToString("N1")); mortrageModel.MaxInitialSum = Convert.ToDecimal(mortrageModel.MaxInitialSum.ToString("N1")); mortrageModel.MinInitialFee = Convert.ToDecimal(mortrageModel.MinInitialFee.ToString("N1")); mortrageModel.MaxInitialFee = Convert.ToDecimal(mortrageModel.MaxInitialFee.ToString("N1")); mortrageModel.TypePayment = "Аннуитетный платеж"; DataContext = mortrageModel; }
private void MenuButton_Click(object sender, RoutedEventArgs e) { DebitCardModel debitCardModel; DebitCardControl debitCardControl; CreditCardModel creditCardModel; CreditCardControl creditCardControl; DepositModelData depositModelData; DepositControl depositControl; ConsumerCreditModel consumerCreditModel; ConsumerCreditControl consumerCreditControl; MortrageModel mortrageModel; MortrageControl mortrageControl; Button button = (Button)sender; switch (button.Content) { case "Молодежная карта": debitCardModel = new DebitCardModel("Молодежная карта"); debitCardControl = new DebitCardControl(debitCardModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(debitCardControl); break; case "Золотая карта": debitCardModel = new DebitCardModel("Золотая карта"); debitCardControl = new DebitCardControl(debitCardModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(debitCardControl); break; case "Классическая карта": debitCardModel = new DebitCardModel("Классическая карта"); debitCardControl = new DebitCardControl(debitCardModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(debitCardControl); break; case "Премиальная кредитная карта": creditCardModel = new CreditCardModel("Премиальная кредитная карта"); creditCardControl = new CreditCardControl(creditCardModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(creditCardControl); break; case "Золотая кредитная карта": creditCardModel = new CreditCardModel("Золотая кредитная карта"); creditCardControl = new CreditCardControl(creditCardModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(creditCardControl); break; case "Цифровая кредитная карта": creditCardModel = new CreditCardModel("Цифровая кредитная карта"); creditCardControl = new CreditCardControl(creditCardModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(creditCardControl); break; case "Вклад «Победная ставка»": depositModelData = new DepositModelData("Вклад «Победная ставка»"); depositControl = new DepositControl(depositModelData, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(depositControl); break; case "Вклад «Выгодное решение»": depositModelData = new DepositModelData("Вклад «Выгодное решение»"); depositControl = new DepositControl(depositModelData, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(depositControl); break; case "Вклад «Копилка»": depositModelData = new DepositModelData("Вклад «Копилка»"); depositControl = new DepositControl(depositModelData, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(depositControl); break; case "Кредит на любые цели": consumerCreditModel = new ConsumerCreditModel("Кредит на любые цели"); consumerCreditControl = new ConsumerCreditControl(consumerCreditModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(consumerCreditControl); break; case "Кредит для молодежи": consumerCreditModel = new ConsumerCreditModel("Кредит для молодежи"); consumerCreditControl = new ConsumerCreditControl(consumerCreditModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(consumerCreditControl); break; case "Кредит для пенсионеров": consumerCreditModel = new ConsumerCreditModel("Кредит для пенсионеров"); consumerCreditControl = new ConsumerCreditControl(consumerCreditModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(consumerCreditControl); break; case "Кредит «Стандартный»": consumerCreditModel = new ConsumerCreditModel("Кредит «Стандартный»"); consumerCreditControl = new ConsumerCreditControl(consumerCreditModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(consumerCreditControl); break; case "Ипотека на готовое жилье": mortrageModel = new MortrageModel("Ипотека на готовое жилье"); mortrageControl = new MortrageControl(mortrageModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(mortrageControl); break; case "Ипотека на новостройки": mortrageModel = new MortrageModel("Ипотека на новостройки"); mortrageControl = new MortrageControl(mortrageModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(mortrageControl); break; case "Ипотека без взноса": mortrageModel = new MortrageModel("Ипотека без взноса"); mortrageControl = new MortrageControl(mortrageModel, _person); _mainWindow.PageMenu.Children.Clear(); _mainWindow.PageMenu.Children.Add(mortrageControl); break; } }