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); } }