private void ButtonSearch_Click(object sender, RoutedEventArgs e)
{
initial = new InitializationFinans();
txtMoney.Text = initial.SelectBySolid(dataBase.DBName, dataBase.ConnectionString, DateTime.Parse(DataFirst.SelectedDate.ToString()), DateTime.Parse(DataLast.SelectedDate.ToString()));
TxtDay.Text = initial.SelectByDay(dataBase.DBName, dataBase.ConnectionString, DateTime.Parse(DataFirst.SelectedDate.ToString()), DateTime.Parse(DataLast.SelectedDate.ToString()));
txtType.Text = initial.SelectByTitle(dataBase.DBName, dataBase.ConnectionString, DateTime.Parse(DataFirst.SelectedDate.ToString()), DateTime.Parse(DataLast.SelectedDate.ToString()));
}
private void ButtonSend_Click(object sender, RoutedEventArgs e)
{
initial = new InitializationFinans();
try
{
initial.InsertWallet(dataBase.DBName, dataBase.ConnectionString, int.Parse(textnumber.Text), comboType.SelectedValue.ToString(), textComment.Text, DateTime.Parse(textCalendar.Text));
MessageBox.Show("Տվյալները հաջողությամբ գրանցվեցին");
}
catch (Exception)
{
MessageBox.Show("Տվյալները չեն գրանցվել ");
}
}
public MainWindow()
{
InitializeComponent();
dataBase = new FinanceDataBase("Finance");
initial = new InitializationFinans();
dataBase.CreateDB().Wait();
dataBase.CreateTable().Wait();
comboType.ItemsSource = initial.SelectCategory(dataBase.DBName, dataBase.ConnectionString);
if (comboType.Items.Count < 1)
{
initial.InsertCategories(dataBase.DBName, dataBase.ConnectionString);
comboType.ItemsSource = initial.SelectCategory(dataBase.DBName, dataBase.ConnectionString);
}
}
