/// <summary> /// Отправка запроса в базу данных /// </summary> /// <param name="sql"></param> public void GoToDataBase(string sql) { try { SQLDataBase dataBase = new SQLDataBase(); dataBase.sql_upgade(sql); } catch (Exception exception) { MessageBox.Show(exception.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } }
/// <summary> /// Удаление /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ButDelete_Click(object sender, RoutedEventArgs e) { SQLDataBase dataBase = new SQLDataBase(); if (TabItemNatural.IsSelected) { if (list_natural_clients.SelectedItem != null) { var temp = list_natural_clients.SelectedItem as SimpleNaturalClient; Bank.Remove(list_natural_clients.SelectedItem); dataBase.sql_delete(temp); } } else if (TabItemLegal.IsSelected) { if (list_legal_clients.SelectedItem != null) { var temp = list_legal_clients.SelectedItem as SimpleLegalEnity; Bank.Remove(list_legal_clients.SelectedItem); dataBase.sql_delete(temp); } } else if (TabItemVip.IsSelected) { if (list_vip_legal_clients.SelectedItem != null) { var temp = list_vip_legal_clients.SelectedItem as VipLegalEnity; Bank.Remove(list_vip_legal_clients.SelectedItem); dataBase.sql_delete(temp); } else if (list_vip_Natural_clients.SelectedItem != null) { var temp = list_vip_Natural_clients.SelectedItem as VipNaturalClient; Bank.Remove(list_vip_Natural_clients.SelectedItem); dataBase.sql_delete(temp); } } Update(); }
/// <summary> /// Закрытие вклада /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void CloseContribution(object sender, RoutedEventArgs e) { SQLDataBase dataBase = new SQLDataBase(); if (client is SimpleNaturalClient) { var temp = client as SimpleNaturalClient; temp.Notify += SaveToLogContrubutionMessage; temp.CloseContribution(); temp.Notify -= SaveToLogContrubutionMessage; using (var cmd = new SqlCommand($@"UPDATE AllNaturalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckContribution] = @CheckContribution WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckContribution", SqlDbType.Decimal).Value = temp.CheckContribution; cmd.ExecuteNonQuery(); } } else if (client is SimpleLegalEnity) { var temp = client as SimpleLegalEnity; temp.Notify += SaveToLogContrubutionMessage; temp.CloseContribution(); temp.Notify -= SaveToLogContrubutionMessage; using (var cmd = new SqlCommand( $@"UPDATE AllLegalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckContribution] = @CheckContribution WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckContribution", SqlDbType.Decimal).Value = temp.CheckContribution; cmd.ExecuteNonQuery(); } } else if (client is VipLegalEnity) { var temp = client as VipLegalEnity; temp.Notify += SaveToLogContrubutionMessage; temp.CloseContribution(); temp.Notify -= SaveToLogContrubutionMessage; using (var cmd = new SqlCommand( $@"UPDATE AllVipLegalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckContribution] = @CheckContribution WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckContribution", SqlDbType.Decimal).Value = temp.CheckContribution; cmd.ExecuteNonQuery(); } } else if (client is VipNaturalClient) { var temp = client as VipNaturalClient; temp.Notify += SaveToLogContrubutionMessage; temp.CloseContribution(); temp.Notify -= SaveToLogContrubutionMessage; using (var cmd = new SqlCommand( $@"UPDATE AllVipNaturalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckContribution] = @CheckContribution WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckContribution", SqlDbType.Decimal).Value = temp.CheckContribution; cmd.ExecuteNonQuery(); } } Update(); }
/// <summary> /// Сохранить /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ButSerializ_Click(object sender, RoutedEventArgs e) { string[] sql = new string[Bank.naturals_clients.Count]; int number = 0; foreach (var item in Bank.naturals_clients) { sql[number] = $@" UPDATE AllNaturalClients SET [FirstName] = N'{item.FirstName}', [LastName] = N'{item.LastName}', [DateOfBirth] = '{Convert.ToDateTime(item.DateofBirth).ToString("yyyy-MM-dd")}', [reputation] = N'{(item as SimpleNaturalClient).reputation}',[Department] = N'{item.Department}', [AccountNumber] = {item.AccountNumber}, [AmountOfMoney] = {item.AmountOfMoney}, [CheckContribution] = {(item as SimpleNaturalClient).CheckContribution}, [CheckDebt] = {(item as SimpleNaturalClient).CheckDebt} WHERE Id = {item.ID} " + "\n"; number++; } try { SQLDataBase dataBase = new SQLDataBase(); dataBase.sql_upgade(sql); MessageBox.Show("Готово", "Complite", MessageBoxButton.OK, MessageBoxImage.Asterisk); } catch (Exception exception) { MessageBox.Show(exception.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } //Юр лица sql = new string[Bank.legals_clients.Count]; number = 0; foreach (var item in Bank.legals_clients) { sql[number] = $@" UPDATE AllLegalClients SET [Name] = N'{item.Name}', [DateOfBirth] = '{Convert.ToDateTime(item.DateofBirth).ToString("yyyy-MM-dd")}', [reputation] = N'{(item as SimpleLegalEnity).reputation}',[Department] = N'{item.Department}', [AccountNumber] = {item.AccountNumber}, [AmountOfMoney] = {item.AmountOfMoney}, [CheckContribution] = {(item as SimpleLegalEnity).CheckContribution}, [CheckDebt] = {(item as SimpleLegalEnity).CheckDebt} WHERE Id = {item.ID} " + "\n"; number++; } try { SQLDataBase dataBase = new SQLDataBase(); dataBase.sql_upgade(sql); MessageBox.Show("Готово", "Complite", MessageBoxButton.OK, MessageBoxImage.Asterisk); } catch (Exception exception) { MessageBox.Show(exception.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } //VIP sql = new string[Bank.vip_clients.Count]; number = 0; foreach (var item in Bank.vip_clients) { if (item is VipNaturalClient) { sql[number] = $@" UPDATE AllVipNaturalClients SET [FirstName] = N'{(item as VipNaturalClient).FirstName}', [LastName] = N'{(item as VipNaturalClient).LastName}', [DateOfBirth] = '{Convert.ToDateTime(item.DateofBirth).ToString("yyyy-MM-dd")}', [Department] = N'{item.Department}', [AccountNumber] = {item.AccountNumber}, [AmountOfMoney] = {item.AmountOfMoney}, [CheckContribution] = {item.CheckContribution}, [CheckDebt] = {item.CheckDebt} WHERE Id = {item.ID} " + "\n"; number++; } else { sql[number] = $@" UPDATE AllVipLegalClients SET [Name] = N'{(item as VipLegalEnity).Name}', [DateOfBirth] = '{Convert.ToDateTime(item.DateofBirth).ToString("yyyy-MM-dd")}', [Department] = N'{item.Department}', [AccountNumber] = {item.AccountNumber}, [AmountOfMoney] = {item.AmountOfMoney}, [CheckContribution] = {item.CheckContribution}, [CheckDebt] = {item.CheckDebt} WHERE Id = {item.ID} " + "\n"; number++; } } try { SQLDataBase dataBase = new SQLDataBase(); dataBase.sql_upgade(sql); MessageBox.Show("Готово", "Complite", MessageBoxButton.OK, MessageBoxImage.Asterisk); } catch (Exception exception) { MessageBox.Show(exception.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } }
/// <summary> /// Закрыть кредит /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void MenuItem_Click(object sender, RoutedEventArgs e) { SQLDataBase dataBase = new SQLDataBase(); if (TabItemNatural.IsSelected) { if (list_natural_clients.SelectedItem != null) { var temp = list_natural_clients.SelectedItem as SimpleNaturalClient; (list_natural_clients.SelectedItem as SimpleNaturalClient).Notify += SaveToLogCreditMessage; (list_natural_clients.SelectedItem as SimpleNaturalClient).CloseCredit(); (list_natural_clients.SelectedItem as SimpleNaturalClient).Notify -= SaveToLogCreditMessage; using (var cmd = new SqlCommand($@"UPDATE AllNaturalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckDebt] = @CheckDebt WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckDebt", SqlDbType.Decimal).Value = temp.CheckDebt; cmd.ExecuteNonQuery(); } } else { MessageBox.Show("Выберите клиента!", "WARNING", MessageBoxButton.OK, MessageBoxImage.Warning); } } if (TabItemLegal.IsSelected) { if (list_legal_clients.SelectedItem != null) { var temp = list_legal_clients.SelectedItem as SimpleLegalEnity; (list_legal_clients.SelectedItem as SimpleLegalEnity).Notify += SaveToLogCreditMessage; (list_legal_clients.SelectedItem as SimpleLegalEnity).CloseCredit(); (list_legal_clients.SelectedItem as SimpleLegalEnity).Notify -= SaveToLogCreditMessage; using (var cmd = new SqlCommand($@"UPDATE AllLegalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckDebt] = @CheckDebt WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckDebt", SqlDbType.Decimal).Value = temp.CheckDebt; cmd.ExecuteNonQuery(); } } else { MessageBox.Show("Выберите клиента!", "WARNING", MessageBoxButton.OK, MessageBoxImage.Warning); } } if (TabItemVip.IsSelected) { if (list_vip_legal_clients.SelectedItem != null) { var temp = list_vip_legal_clients.SelectedItem as VipLegalEnity; (list_vip_legal_clients.SelectedItem as VipClient).Notify += SaveToLogCreditMessage; (list_vip_legal_clients.SelectedItem as VipClient).CloseCredit(); (list_vip_legal_clients.SelectedItem as VipClient).Notify -= SaveToLogCreditMessage; using (var cmd = new SqlCommand($@"UPDATE AllVipLegalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckDebt] = @CheckDebt WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckDebt", SqlDbType.Decimal).Value = temp.CheckDebt; cmd.ExecuteNonQuery(); } } else if (list_vip_Natural_clients.SelectedItem != null) { var temp = list_vip_Natural_clients.SelectedItem as VipNaturalClient; (list_vip_Natural_clients.SelectedItem as VipClient).Notify += SaveToLogCreditMessage; (list_vip_Natural_clients.SelectedItem as VipClient).CloseCredit(); (list_vip_Natural_clients.SelectedItem as VipClient).Notify -= SaveToLogCreditMessage; using (var cmd = new SqlCommand($@"UPDATE AllVipNaturalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckDebt] = @CheckDebt WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckDebt", SqlDbType.Decimal).Value = temp.CheckDebt; cmd.ExecuteNonQuery(); } } else { MessageBox.Show("Выбере клиента!", "WARNING", MessageBoxButton.OK, MessageBoxImage.Warning); } } // dataBase.sql_upgade(sql); Update(); }
/// <summary> /// Кнопка закрытия клада /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void CloseContibution_Click(object sender, RoutedEventArgs e) { SQLDataBase dataBase = new SQLDataBase(); if (TabItemNatural.IsSelected) { if (list_natural_clients.SelectedItem != null) { var temp = list_natural_clients.SelectedItem as SimpleNaturalClient; (list_natural_clients.SelectedItem as SimpleNaturalClient).Notify += SaveToLogContrubutionMessage; (list_natural_clients.SelectedItem as SimpleNaturalClient).CloseContribution(); (list_natural_clients.SelectedItem as SimpleNaturalClient).Notify -= SaveToLogContrubutionMessage; using (var cmd = new SqlCommand($@"UPDATE AllNaturalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckContribution] = @CheckContribution WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckContribution", SqlDbType.Decimal).Value = temp.CheckContribution; cmd.ExecuteNonQuery(); } } } else if (TabItemLegal.IsSelected) { if (list_legal_clients.SelectedItem != null) { var temp = list_legal_clients.SelectedItem as SimpleLegalEnity; (list_legal_clients.SelectedItem as SimpleLegalEnity).Notify += SaveToLogContrubutionMessage; (list_legal_clients.SelectedItem as SimpleLegalEnity).CloseContribution(); (list_legal_clients.SelectedItem as SimpleLegalEnity).Notify -= SaveToLogContrubutionMessage; using (var cmd = new SqlCommand($@"UPDATE AllLegalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckContribution] = @CheckContribution WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckContribution", SqlDbType.Decimal).Value = temp.CheckContribution; cmd.ExecuteNonQuery(); } } } else if (TabItemVip.IsSelected) { if (list_vip_legal_clients.SelectedItem != null) { var temp = list_vip_legal_clients.SelectedItem as VipLegalEnity; (list_vip_legal_clients.SelectedItem as VipLegalEnity).Notify += SaveToLogContrubutionMessage; (list_vip_legal_clients.SelectedItem as VipLegalEnity).CloseContribution(); (list_vip_legal_clients.SelectedItem as VipLegalEnity).Notify -= SaveToLogContrubutionMessage; using (var cmd = new SqlCommand($@"UPDATE AllVipLegalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckContribution] = @CheckContribution WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckContribution", SqlDbType.Decimal).Value = temp.CheckContribution; cmd.ExecuteNonQuery(); } } else if (list_vip_Natural_clients.SelectedItem != null) { var temp = list_vip_Natural_clients.SelectedItem as VipNaturalClient; (list_vip_Natural_clients.SelectedItem as VipNaturalClient).Notify += SaveToLogContrubutionMessage; (list_vip_Natural_clients.SelectedItem as VipNaturalClient).CloseContribution(); (list_vip_Natural_clients.SelectedItem as VipNaturalClient).Notify -= SaveToLogContrubutionMessage; using (var cmd = new SqlCommand($@"UPDATE AllVipNaturalClients SET [AmountOfMoney] = @AmountOfMoney, [CheckContribution] = @CheckContribution WHERE Id = {temp.ID}", dataBase.connection)) { dataBase.connection.Open(); cmd.Parameters.Add("@AmountOfMoney", SqlDbType.Decimal).Value = temp.AmountOfMoney; cmd.Parameters.Add("@CheckContribution", SqlDbType.Decimal).Value = temp.CheckContribution; cmd.ExecuteNonQuery(); } } } Update(); }
/// <summary> /// Авторизация за клиента /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void GoClient(object sender, RoutedEventArgs e) { SQLDataBase dataBase = new SQLDataBase(); string dep = string.Empty; string sql = string.Empty; if (comboBox.Text == "Физ отдел") { dep = "AllNaturalClients"; } else if (comboBox.Text == "Юр отдел") { dep = "AllLegalClients"; } else if (comboBox.Text == "VIP отдел") { dep = "AllVipNaturalClients"; } sql = $@" SELECT * FROM {dep} WHERE Id = {BoxLogin.Text} "; try { using (var com = new SqlCommand(sql, dataBase.connection)) { dataBase.connection.Open(); SqlDataReader r = com.ExecuteReader(); if (!r.HasRows) { dep = "AllVipLegalClients"; sql = $@" SELECT * FROM {dep} WHERE Id = {BoxLogin.Text} "; } dataBase.connection.Close(); } } catch (Exception error) { MessageBox.Show(error.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } try { using (var com = new SqlCommand(sql, dataBase.connection)) { dataBase.connection.Open(); SqlDataReader r = com.ExecuteReader(); while (r.Read()) { if (comboBox.Text == "Физ отдел") { var temp = new SimpleNaturalClient(r.GetInt32(0), r["FirstName"].ToString(), r["LastName"].ToString(), r["Department"].ToString(), r.GetDateTime(3), r.GetDecimal(7)); temp.CheckContribution = r.GetDecimal(8).ToString(); temp.CheckDebt = r.GetDecimal(9).ToString(); ClientWindow clientWindow = new ClientWindow(Bank, temp); clientWindow.Activate(); clientWindow.Show(); } else if (comboBox.Text == "Юр отдел") { var temp = new SimpleLegalEnity(r.GetInt32(0), r["Name"].ToString(), r["Department"].ToString(), r.GetDateTime(2), r.GetDecimal(6)); temp.CheckContribution = r.GetDecimal(7).ToString(); temp.CheckDebt = r.GetDecimal(8).ToString(); ClientWindow clientWindow = new ClientWindow(Bank, temp); clientWindow.Activate(); clientWindow.Show(); } else if (comboBox.Text == "VIP отдел") { try { var temp = new VipNaturalClient(r.GetInt32(0), r["FirstName"].ToString(), r["LastName"].ToString(), r["Department"].ToString(), r.GetDateTime(3), r.GetDecimal(6)); temp.CheckContribution = r.GetDecimal(7).ToString(); temp.CheckDebt = r.GetDecimal(8).ToString(); ClientWindow clientWindow = new ClientWindow(Bank, temp); clientWindow.Activate(); clientWindow.Show(); } catch (Exception) { var temp = new VipLegalEnity(r.GetInt32(0), r["Name"].ToString(), r["Department"].ToString(), r.GetDateTime(2), r.GetDecimal(5)); temp.CheckContribution = r.GetDecimal(6).ToString(); temp.CheckDebt = r.GetDecimal(7).ToString(); ClientWindow clientWindow = new ClientWindow(Bank, temp); clientWindow.Activate(); clientWindow.Show(); } } } } } catch (Exception exception) { MessageBox.Show(exception.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } Close(); }
/// <summary> /// Десериализация /// </summary> /// <param name="mainWindow">Главное окно</param> private void Deserializ(MainWindow mainWindow) { //Физические лица Temptemp temptemp = ProgressiveValue; try { SQLDataBase dataBase = new SQLDataBase(); SqlDataReader reader = dataBase.sql_select("Физический"); if (reader.HasRows) { while (reader.Read()) { int itemID = reader.GetInt32(0); string itemFirstName = reader["FirstName"].ToString(); string itemLastName = reader["LastName"].ToString(); DateTime itemDateOfCreate = reader.GetDateTime(3); string itemRep = reader["reputation"].ToString(); string itemDepartment = reader["Department"].ToString(); decimal itemAmountOfMoney = reader.GetDecimal(7); var new_client = new SimpleNaturalClient(itemID, itemFirstName, itemLastName, itemDepartment, itemDateOfCreate, itemAmountOfMoney); new_client.CheckContribution = reader.GetDecimal(8).ToString(); new_client.CheckDebt = reader.GetDecimal(9).ToString(); Bank.naturals_clients.Add(new_client); var progress = new Progress <int>(value => Dispatcher.Invoke(temptemp, DispatcherPriority.Normal, value)); Task task1 = new Task(() => { Dispatcher.Invoke(ProgressiveZero); for (int i = 0; i < 100; i++) { Dispatcher.Invoke(delegate { label.Content = itemFirstName + itemDepartment; }); ((IProgress <int>)progress).Report(i); Thread.Sleep(1); } }); task1.Start(); Task.WaitAll(task1); task1.Dispose(); } } Dispatcher.Invoke(() => dataBase.ServerDisConnect()); Task task2 = new Task(() => { if (Bank.naturals_clients.Count > 0) { foreach (var VARIABLE in Bank.naturals_clients) { Dispatcher.Invoke(() => mainWindow.list_natural_clients.Items.Add(VARIABLE), DispatcherPriority.Normal); } } }); //Юр лица reader = dataBase.sql_select("Юридический"); if (reader.HasRows) { while (reader.Read()) { int itemID = reader.GetInt32(0); string itemName = reader["Name"].ToString(); DateTime itemDateOfCreate = reader.GetDateTime(2); string itemRep = reader["reputation"].ToString(); string itemDepartment = reader["Department"].ToString(); decimal itemAmountOfMoney = reader.GetDecimal(6); var new_client = new SimpleLegalEnity(itemID, itemName, itemDepartment, itemDateOfCreate, itemAmountOfMoney); new_client.CheckContribution = reader.GetDecimal(7).ToString(); new_client.CheckDebt = reader.GetDecimal(8).ToString(); Bank.legals_clients.Add(new_client); var progress = new Progress <int>(value => Dispatcher.Invoke(temptemp, DispatcherPriority.Normal, value)); Task task1 = new Task(() => { Dispatcher.Invoke(ProgressiveZero); for (int i = 0; i < 100; i++) { Dispatcher.Invoke(delegate { label.Content = itemName + itemDepartment; }); ((IProgress <int>)progress).Report(i); Thread.Sleep(1); } }); task1.Start(); Task.WaitAll(task1); task1.Dispose(); } } Dispatcher.Invoke(() => dataBase.ServerDisConnect()); Task task3 = new Task(() => { if (Bank.legals_clients.Count > 0) { foreach (var VARIABLE in Bank.legals_clients) { Dispatcher.Invoke(() => mainWindow.list_legal_clients.Items.Add(VARIABLE), DispatcherPriority.Normal); } } }); //VIP физ reader = dataBase.sql_select("VIP_физ"); if (reader.HasRows) { while (reader.Read()) { int itemID = reader.GetInt32(0); string itemFirstName = reader["FirstName"].ToString(); string itemLastName = reader["LastName"].ToString(); DateTime itemDateOfCreate = reader.GetDateTime(3); string itemDepartment = reader["Department"].ToString(); decimal itemAmountOfMoney = reader.GetDecimal(6); var new_client = new VipNaturalClient(itemID, itemFirstName, itemLastName, itemDepartment, itemDateOfCreate, itemAmountOfMoney); new_client.CheckContribution = reader.GetDecimal(7).ToString(); new_client.CheckDebt = reader.GetDecimal(8).ToString(); Bank.vip_clients.Add(new_client); var progress = new Progress <int>(value => Dispatcher.Invoke(temptemp, DispatcherPriority.Normal, value)); Task task1 = new Task(() => { Dispatcher.Invoke(ProgressiveZero); for (int i = 0; i < 100; i++) { Dispatcher.Invoke(delegate { label.Content = itemFirstName + itemDepartment; }); ((IProgress <int>)progress).Report(i); Thread.Sleep(1); } }); task1.Start(); Task.WaitAll(task1); task1.Dispose(); } } Dispatcher.Invoke(() => dataBase.ServerDisConnect()); Task task4 = new Task(() => { if (Bank.vip_clients.Count > 0) { foreach (var VARIABLE in Bank.vip_clients) { if (VARIABLE is VipNaturalClient) { Dispatcher.Invoke(() => mainWindow.list_vip_Natural_clients.Items.Add(VARIABLE), DispatcherPriority.Normal); } } } }); //VIP Юр reader = dataBase.sql_select("VIP_юр"); if (reader.HasRows) { while (reader.Read()) { int itemID = reader.GetInt32(0); string itemName = reader["Name"].ToString(); DateTime itemDateOfCreate = reader.GetDateTime(2); string itemDepartment = reader["Department"].ToString(); decimal itemAmountOfMoney = reader.GetDecimal(5); var new_client = new VipLegalEnity(itemID, itemName, itemDepartment, itemDateOfCreate, itemAmountOfMoney); new_client.CheckContribution = reader.GetDecimal(6).ToString(); new_client.CheckDebt = reader.GetDecimal(7).ToString(); Bank.vip_clients.Add(new_client); var progress = new Progress <int>(value => Dispatcher.Invoke(temptemp, DispatcherPriority.Normal, value)); Task task1 = new Task(() => { Dispatcher.Invoke(ProgressiveZero); for (int i = 0; i < 100; i++) { Dispatcher.Invoke(delegate { label.Content = itemName + itemDepartment; }); ((IProgress <int>)progress).Report(i); Thread.Sleep(1); } }); task1.Start(); Task.WaitAll(task1); task1.Dispose(); } } Dispatcher.Invoke(() => dataBase.ServerDisConnect()); Task task5 = new Task(() => { if (Bank.vip_clients.Count > 0) { foreach (var VARIABLE in Bank.vip_clients) { if (VARIABLE is VipLegalEnity) { Dispatcher.Invoke(() => mainWindow.list_vip_legal_clients.Items.Add(VARIABLE), DispatcherPriority.Normal); } } } }); task2.Start(); task3.Start(); task4.Start(); task5.Start(); Dispatcher.Invoke(() => mainWindow.Show()); Dispatcher.Invoke(() => mainWindow.Activate()); Task.WaitAll(task2, task3, task4, task5); task2.Dispose(); task3.Dispose(); task4.Dispose(); task5.Dispose(); Dispatcher.Invoke(Close); } catch (Exception e) { MessageBox.Show(e.Message); Dispatcher.Invoke(() => mainWindow.Show()); Dispatcher.Invoke(Close); } }
/// <summary> /// Поиск по Номеру счета /// </summary> /// <typeparam name="T"></typeparam> /// <param name="AccountNumber"></param> /// <param name="Department"></param> /// <returns></returns> public object Find <T>(int AccountNumber, string Department) { SQLDataBase dataBase = new SQLDataBase(); string dep = string.Empty; string sql = string.Empty; if (Department == "Физический") { dep = "AllNaturalClients"; } else if (Department == "Юридический") { dep = "AllLegalClients"; } else if (Department == "VIP") { dep = "AllVipNaturalClients"; } sql = $@" SELECT * FROM {dep} WHERE AccountNumber = {AccountNumber} "; try { using (var com = new SqlCommand(sql, dataBase.connection)) { dataBase.connection.Open(); SqlDataReader r = com.ExecuteReader(); if (!r.HasRows) { dep = "AllVipLegalClients"; sql = $@" SELECT * FROM {dep} WHERE AccountNumber = {AccountNumber} "; } dataBase.connection.Close(); } } catch (Exception) { } try { using (var com = new SqlCommand(sql, dataBase.connection)) { dataBase.connection.Open(); SqlDataReader r = com.ExecuteReader(); while (r.Read()) { if (Department == "Физический") { var temp = new SimpleNaturalClient(r.GetInt32(0), r["FirstName"].ToString(), r["LastName"].ToString(), r["Department"].ToString(), r.GetDateTime(3), r.GetDecimal(7)); temp.CheckContribution = r.GetDecimal(8).ToString(); temp.CheckDebt = r.GetDecimal(9).ToString(); return(temp); } else if (Department == "Юридический") { var temp = new SimpleLegalEnity(r.GetInt32(0), r["Name"].ToString(), r["Department"].ToString(), r.GetDateTime(2), r.GetDecimal(6)); temp.CheckContribution = r.GetDecimal(7).ToString(); temp.CheckDebt = r.GetDecimal(8).ToString(); return(temp); } else if (Department == "VIP") { try { var temp = new VipNaturalClient(r.GetInt32(0), r["FirstName"].ToString(), r["LastName"].ToString(), r["Department"].ToString(), r.GetDateTime(3), r.GetDecimal(6)); temp.CheckContribution = r.GetDecimal(7).ToString(); temp.CheckDebt = r.GetDecimal(8).ToString(); return(temp); } catch (Exception) { var temp = new VipLegalEnity(r.GetInt32(0), r["Name"].ToString(), r["Department"].ToString(), r.GetDateTime(2), r.GetDecimal(5)); temp.CheckContribution = r.GetDecimal(6).ToString(); temp.CheckDebt = r.GetDecimal(7).ToString(); return(temp); } } } } } catch (Exception exception) { MessageBox.Show(exception.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); return("NOT FOUND"); } return("NOT FOUND"); }