public TransferWindow()
{
InitializeComponent();
AccountGrid.AutoGenerateColumns = false;
AccountGrid.ItemsSource = SourseAccount;
//SQLFunctionscs.OpenConnection(MainWindow.ParentWindow.Bullder, "SELECT CU.CurrencySign FROM CURRENCY AS CU;", SQLFunctionscs.ComboBoxAdd, CurrencyBox);
SQLFunctionscs.OpenConnection(MainWindow.ParentWindow.Bullder, $"SELECT AccountCode FROM ACCOUNT WHERE ClientID = {MainWindow.ParentWindow.IDCode}", SQLFunctionscs.ComboBoxAdd, FromAccountBox);
SQLFunctionscs.OpenConnection(MainWindow.ParentWindow.Bullder, $"SELECT AccountCode FROM ACCOUNT WHERE ClientID = {MainWindow.ParentWindow.IDCode}", SQLFunctionscs.ComboBoxAdd, ToAccountBox);
SQLFunctionscs.OpenConnection(MainWindow.ParentWindow.Bullder, $"SELECT * FROM dbo.ShowAccounts({MainWindow.ParentWindow.IDCode});", SQLFunctionscs.CollectionAdd, SourseAccount);
using (var Connection = new SqlConnection(MainWindow.ParentWindow.Bullder.ConnectionString))
{
Connection.Open();
using (var Command = new SqlCommand("SELECT CU.CurrencySign, Cu.CurrencyID FROM CURRENCY AS CU;", Connection))
{
var Reader = Command.ExecuteReader();
while (Reader.Read())
{
CurrencyDict[Reader.GetString(0)] = Reader.GetInt32(1);
}
}
}
CurrencyBox.ItemsSource = CurrencyDict.Keys;
}
private void OpenAccountButton_Click(object sender, RoutedEventArgs e)
{
SQLFunctionscs.ConectionFunc(
MainWindow.ParentWindow.Bullder, $"INSERT INTO ACCOUNT(AccountCode, ClientID, CurrencyID, MoneyValue)" +
$" VALUES({AccountInputCodebox.Text},{MainWindow.ParentWindow.IDCode},{CurrencyDict[CurrencyBox.SelectedItem.ToString()]}, 0);");
SourseAccount.Clear();
SQLFunctionscs.OpenConnection(MainWindow.ParentWindow.Bullder, $"SELECT * FROM dbo.ShowAccounts({MainWindow.ParentWindow.IDCode});", SQLFunctionscs.CollectionAdd, SourseAccount);
}
private void DepositButton_Click(object sender, RoutedEventArgs e)
{
var paramDict = new Dictionary <string, string>
{
["@Value"] = MoneyValueBox.Text,
["@AccountCode"] = FromAccountBox.SelectedItem.ToString(),
["@CurrencyID"] = CurrencyDict[CurrencyBox.SelectedItem.ToString()].ToString()
};
SQLFunctionscs.SQLStoredProcedure(MainWindow.ParentWindow.Bullder, "dbo.depositMoney", paramDict);
SourseAccount.Clear();
SQLFunctionscs.OpenConnection(MainWindow.ParentWindow.Bullder, $"SELECT * FROM dbo.ShowAccounts({MainWindow.ParentWindow.IDCode});", SQLFunctionscs.CollectionAdd, SourseAccount);
}
private void CloseAccountButton_Click(object sender, RoutedEventArgs e)
{
try
{
SQLFunctionscs.ConectionFunc(MainWindow.ParentWindow.Bullder, $"DELETE FROM ACCOUNT WHERE AccountCode = '{AccountGrid.SelectedItem.ToString()}'");
SourseAccount.Clear();
SQLFunctionscs.OpenConnection(MainWindow.ParentWindow.Bullder, $"SELECT * FROM dbo.ShowAccounts({MainWindow.ParentWindow.IDCode});", SQLFunctionscs.CollectionAdd, SourseAccount);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void UseTransferMoney(ObservableCollection <ClientAccount> SourseCollection, string Value, string FromAccount, string ToAccount)
{
using (var Connection = new SqlConnection(MainWindow.ParentWindow.Bullder.ConnectionString))
{
Connection.Open();
using (var Command = new SqlCommand("dbo.TransferMoney", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Add(new SqlParameter("@Value", Value));
Command.Parameters.Add(new SqlParameter("@fromCode", FromAccount));
Command.Parameters.Add(new SqlParameter("@ToCode", ToAccount));
Command.ExecuteNonQuery();
}
}
SourseCollection.Clear();
SQLFunctionscs.OpenConnection(MainWindow.ParentWindow.Bullder, $"SELECT * FROM dbo.ShowAccounts({MainWindow.ParentWindow.IDCode});", SQLFunctionscs.CollectionAdd, SourseCollection);
}
private void CodeTransferButton_Click(object sender, RoutedEventArgs e)
{
SQLFunctionscs.UseTransferMoney(SourseAccount, MoneyValueBox.Text, FromAccountBox.SelectedItem.ToString(), AccountCodeBox.Text);
}