public static void executeSQL(string Code)
{
MainWindow.openConnection();
MainWindow.DT.Clear();
MainWindow.SQL = Code;
MainWindow.cmd.CommandType = System.Data.CommandType.Text;
MainWindow.cmd.CommandText = MainWindow.SQL;
MainWindow.Adapter.SelectCommand = MainWindow.cmd;
MainWindow.Adapter.Fill(MainWindow.DT);
MainWindow.closeConnection();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
MainWindow.openConnection();
if (MainWindow.DT.Rows.Count <= 0)
{
MainWindow.SQL = "USE [billing_simple.]; SELECT [payer_email], [recipient_email], [sum], [currency], [billing_date], [comment] FROM billing;";
MainWindow.cmd.CommandType = CommandType.Text;
MainWindow.cmd.CommandText = MainWindow.SQL;
MainWindow.Adapter.SelectCommand = MainWindow.cmd;
MainWindow.Adapter.Fill(MainWindow.DT);
}
MainWindow.Adapter.Update(MainWindow.DT);
MainWindow.closeConnection();
}
private void Window_Loaded(object Sender, RoutedEventArgs e)
{
MainWindow.openConnection();
MainWindow.SQL = "USE [billing_simple.]; SELECT [payer_email], [recipient_email], [sum], [currency], [billing_date], [comment] FROM billing;";
MainWindow.cmd.CommandType = CommandType.Text;
MainWindow.cmd.CommandText = MainWindow.SQL;
MainWindow.Adapter.SelectCommand = MainWindow.cmd;
MainWindow.Adapter.Fill(MainWindow.DT);
SQLGrid.ItemsSource = MainWindow.DT.DefaultView;
MainWindow.closeConnection();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
MainWindow.openConnection();
MainWindow.SQL = "use billing_simple.; insert into billing(payer_email,recipient_email,sum,currency,billing_date,comment) values ('" + payer.Text + "','" + recipient.Text + "','" + sum.Text + "','" + currency.Text + "','" + date.Text + "','" + comment.Text + "');";
MainWindow.cmd.CommandType = CommandType.Text;
MainWindow.cmd.CommandText = MainWindow.SQL;
int LCount = MainWindow.cmd.ExecuteNonQuery();
if (LCount > 0)
{
MessageBox.Show("Счет выписан!);");
}
MainWindow.closeConnection();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
MainWindow.openConnection();
MainWindow.SQL = "use[billing_simple.] SELECT* FROM billing WHERE sum > " + Text.Text + " and sum< " + Text2.Text + "";
MainWindow.cmd.CommandType = CommandType.Text;
MainWindow.cmd.CommandText = MainWindow.SQL;
try
{
MainWindow.SqlReader = MainWindow.cmd.ExecuteReader();
}
catch (SqlException)
{
MessageBox.Show("Ошибка выполнения");
MainWindow.closeConnection();
return;
}
MainWindow.DT.Clear();
MainWindow.DT.Load(MainWindow.SqlReader);
MainWindow.closeConnection();
}
