public ha_add_new_entry()
{
InitializeComponent();
DataContext = new ComboBoxViewModel();
tb_data.SelectedDate = DateTime.Today;
}
private void Select()
{
model = new ComboBoxViewModel();
try
{
connection.Open();
//sql = "select to_char(Дата,'dd-mm-yyyy') as \"Дата\", \"Основная категория\", Категория, Стоимость, Комментарий, id from mainSelect()";
sql = "select strftime('%d-%m-%Y',e.date) as \"Дата\", m.name as \"Основная категория\",n.name as Категория, ABS(e.cost) as Стоимость, e.comment as Комментарий, e.id as id from Entry as e " +
" left join NameCategory as n " +
" on e.name_category = n.id " +
" left join MainCategory as m " +
" on e.main_category = m.id " +
" order by e.date; ";
cmd = new SQLiteCommand(sql, connection);
cmd.ExecuteNonQuery();
SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(cmd);
dt = new DataTable("mainSelect()");
dataAdapter.Fill(dt);
dg.ItemsSource = dt.DefaultView;
connection.Close();
}
catch (Exception ex)
{
connection.Close();
}
}
public MainWindow()
{
connection_string = @"Data Source=db\homeaccountingdb.db; Version=3";
InitializeComponent();
tb_data.SelectedDate = DateTime.Today;
model = new ComboBoxViewModel();
DataContext = new ComboBoxViewModel();
}
public MainWindow()
{
string server = "localhost";
string port = "5432";
string user_id = "homeaccountingUser";
string password = "******";
string database = "homeaccountingtest";
connection_string = $"Server={server};Port={port};" +
$"User Id={user_id};Password={password};" +
$"Database={database};";
InitializeComponent();
tb_data.SelectedDate = DateTime.Today;
model = new ComboBoxViewModel();
DataContext = new ComboBoxViewModel();
}
private void Select()
{
model = new ComboBoxViewModel();
try
{
connection.Open();
sql = "select to_char(Дата,'dd-mm-yyyy') as \"Дата\", \"Основная категория\", Категория, Стоимость, Комментарий, id from mainSelect()";
cmd = new NpgsqlCommand(sql, connection);
cmd.ExecuteNonQuery();
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter(cmd);
dt = new DataTable("mainSelect()");
dataAdapter.Fill(dt);
dg.ItemsSource = dt.DefaultView;
connection.Close();
}
catch (Exception ex)
{
connection.Close();
}
}