private string GetNameOfBankWitchRealizesTranzaction(string cardid)
{
DbMenagmentProvider db = new DbMenagmentProvider();
List <Card> list;
try
{
list = db.IssuedCardByBank();
}
catch (FileNotFoundException)
{
throw new FileNotFoundException();
}
catch
{
throw new Exception();
}
var bankName =
from element in list
where element.CardId == cardid
select new Bank
{
Name = element.IssuedBy
};
try
{
return(bankName.FirstOrDefault().Name);
}
catch (NullReferenceException)
{
throw new CardNotFoundException();
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
TransactionsListView.Items.Clear();
DbMenagmentProvider db = new DbMenagmentProvider();
List <Transaction> transactionsList;
try
{
transactionsList = db.GetTransactionsList();
}
catch (FileNotFoundException exce)
{
MessageBox.Show("Nie odnaleziono na dysku pliku z listą tranzakcji. {0}", exce.Message);
return;
}
catch (Exception exce)
{
MessageBox.Show(string.Format("Nieoczekiwany błąd: {0}", exce.Message));
return;
}
foreach (var item in transactionsList)
{
this.TransactionsListView.Items.Add(item);
}
LoadTransactionsListButton.Content = "Odśwież";
}
private void RemoveBankButton_Click(object sender, RoutedEventArgs e)
{
string bank = "";
try
{
bank = BanksListBox.SelectedItem.ToString();
}
catch (NullReferenceException)
{
MessageBox.Show("Wybierz bank do usunięcia");
return;
}
catch (Exception exce)
{
MessageBox.Show(string.Format("Nieoczekiwany błąd podczas usuwania banku", exce.Message));
}
try
{
DbMenagmentProvider db = new DbMenagmentProvider();
db.RemoveBank(bank);
}
catch (Exception exce)
{
MessageBox.Show("Usunięcie banku z listy nie powiodło się {0}", exce.Message);
}
UpdateListOfBanks();
}
private void AddBank_Click(object sender, RoutedEventArgs e)
{
string bank = "";
if (AddBankTextBox.Text.Count() != 0)
{
bank = AddBankTextBox.Text;
}
else
{
AddBankTextBox.Text = "Okno jest puste";
AddBankTextBox.Background = Brushes.Red;
return;
}
DbMenagmentProvider db = new DbMenagmentProvider();
try
{
db.AddBank(bank);
}
catch (Exception exce)
{
MessageBox.Show(string.Format("Nie można dodać banku: {0}", exce.Message));
return;
}
UpdateListOfBanks();
}
private void RemoveCompany(object sender, RoutedEventArgs e)
{
string companyToRemove = "";
try
{
companyToRemove = CompaniesListBox.SelectedItem.ToString();
}
catch (NullReferenceException)
{
MessageBox.Show("Proszę wybrać któraś z firm do usunięcia");
return;
}
catch (Exception exce)
{
MessageBox.Show(string.Format("Nieoczekiwany błąd", exce.Message));
return;
}
DbMenagmentProvider db = new DbMenagmentProvider();
try
{
db.RemoveCompany(companyToRemove);
}
catch (FileNotFoundException exce)
{
MessageBox.Show("Nie można usunąć firmy z listy, ponieważ nie odnaleziono pliku. {0}", exce.Message);
return;
}
UpdateListOfCompanies();
}
public void Filter_test()
{
DbMenagmentProvider db = new DbMenagmentProvider();
List <Transaction> transactionsList = db.GetTransactionsList();
var newTransactionsList =
(from transaction in transactionsList
where transaction.Amount >= 200 &&
transaction.Amount <= 300
select transaction).ToList();
Assert.AreEqual(newTransactionsList.Count, 2);
}
private void RefreshShoppingPlacesButton_Click(object sender, RoutedEventArgs e)
{
DbMenagmentProvider db = new DbMenagmentProvider();
try
{
List <Company> list = db.ProvideListWithCompanies();
ListWithShopsListBox.ItemsSource = list;
}
catch (FileNotFoundException exce)
{
MessageBox.Show("Nie odnaleziono pliku z listą firm. Sprawdź czy plik istnieje. {0}", exce.Message);
}
catch (Exception exce)
{
MessageBox.Show("Nieoczekiwany błąd przy aktualizowaniu listy firm. {0}", exce.Message);
}
}
private void UpdateListOfBanks()
{
DbMenagmentProvider db = new DbMenagmentProvider();
try
{
List <Bank> list = db.ProvideListWithBanks();
BanksListBox.ItemsSource = list;
}
catch (FileNotFoundException exce)
{
MessageBox.Show("Nie odnaleziono pliku z listą banków. Sprawdź czy plik istnieje. {0}", exce.Message);
}
catch (Exception exce)
{
MessageBox.Show("Nieoczekiwany błąd przy aktualizowaniu listy banów. {0}", exce.Message);
}
}
private void AddCompany_Click(object sender, RoutedEventArgs e)
{
string companyName = "";
string companyType = "";
//walidacja danych
if (CompanyNameTextBox.Text.Count() != 0)
{
companyName = CompanyNameTextBox.Text;
}
else
{
CompanyNameTextBox.Text = "Okno jest puste";
CompanyNameTextBox.Background = Brushes.Red;
return;
}
if (CompanyTypeComboBox.Text.Count() != 0)
{
companyType = CompanyTypeComboBox.Text;
}
else
{
MessageBox.Show("Nie wybrano typu firmy");
return;
}
DbMenagmentProvider db = new DbMenagmentProvider();
try
{
db.AddCompany(new Company(companyName, companyType));
}
catch (Exception exce)
{
MessageBox.Show("Nieoczekiwany błąd przy dodawaniu nowej firmy: {0}", exce.Message);
}
this.UpdateListOfCompanies();
}
public bool RealizeRequest(double amount, string reciver, string cardid, string currency)
{
bool ifAccepted = false;
try
{
this.SelectedBank = new Bank(GetNameOfBankWitchRealizesTranzaction(cardid));
ifAccepted = SelectedBank.RealizeRequestFromAuthorizationCentre(amount, cardid);
}
catch (CardNotFoundException)
{
throw new IndexOutOfRangeException();
}
catch (Exception)
{
throw new Exception();
}
try
{
DbMenagmentProvider db = new DbMenagmentProvider();
db.SaveTransactionToDataBase(new Transaction()
{
Amount = amount,
Currency = currency,
DateTime = DateTime.Now.Date.ToShortDateString(),
ReciverOfAmount = reciver,
UsedCardId = cardid,
IfAccepted = ifAccepted ? "Accepted" : "Not accepted"
});
}
catch
{
throw new DataBaseSavingException();
}
return(ifAccepted);
}
private void SearchButton_Click(object sender, RoutedEventArgs e)
{
TransactionsListView.Items.Clear();
DbMenagmentProvider db = new DbMenagmentProvider();
List <Transaction> transactionsList;
try
{
transactionsList = db.GetTransactionsList();
}
catch (FileNotFoundException exce)
{
MessageBox.Show(string.Format("Błąd: {0}", exce.Message.ToString()));
return;
}
catch (Exception exce)
{
MessageBox.Show(string.Format("Nieoczekiwany błąd podczas filtrowania listy tranzakcji {0}", exce.Message));
return;
}
string currencyValue = CurrencyFilterComboBox.Text;
int fromValue = 0, toValue = Int32.MaxValue;
string date = "";
string status;
string reciver = "";
string cardId = "";
string currency = "";
//obsługa zakresu tranzakcji
try
{
fromValue = Int32.Parse(MinValueFilterTextBox.Text);
}
catch (FormatException)
{
fromValue = 0;
}
try
{
toValue = Int32.Parse(MaxValueFilterTextBox.Text);
}
catch (FormatException)
{
toValue = Int32.MaxValue;
}
transactionsList = transactionsList.Where(x => x.Amount >= fromValue && x.Amount <= toValue).ToList();
//obsluga kalendarza
if (DayOfTransactionCalendar.SelectedDate.HasValue)
{
date = DayOfTransactionCalendar.SelectedDate.Value.ToShortDateString();
transactionsList = transactionsList.Where(x => x.DateTime == date).ToList();
}
//obsługa zaakceptowanie/niezaakceptowane
if (StatusCheckBox.IsChecked.Value)
{
status = "Accepted";
//MessageBox.Show("checked");
transactionsList = transactionsList.Where(x => x.IfAccepted == status).ToList();
}
//obsługa obiorcy
if (ReciverFilterTextBox.Text != reciver)
{
reciver = ReciverFilterTextBox.Text;
transactionsList = transactionsList.Where(x => x.ReciverOfAmount == reciver).ToList();
}
//obsługa nr id karty
if (CardIdFilterTextBox.Text != cardId)
{
cardId = CardIdFilterTextBox.Text;
transactionsList = transactionsList.Where(x => x.UsedCardId == cardId).ToList();
}
//obsługa waluty
if (CurrencyFilterComboBox.Text != "Dowolna")
{
currency = CurrencyFilterComboBox.Text;
transactionsList = transactionsList.Where(x => x.Currency == currency).ToList();
}
foreach (var item in transactionsList)
{
this.TransactionsListView.Items.Add(item);
}
}