private void btn_AddFi_Click(object sender, RoutedEventArgs e)
{
int size;
if (!this.fileid_select.Text.Equals("") &&
this.format_select.SelectedIndex != -1 &&
int.TryParse(this.filesize_select.Text, out size))
{
SqlTransaction trans = null;
SqlCommand comm = null;
try
{
comm = connection.CreateCommand();
trans = connection.BeginTransaction("BookAdding");
comm.CommandText = "insert into Files(file_id, format, file_size) values ('" +
this.fileid_select.Text + "', '" +
((ComboBoxItem)this.format_select.Items[this.format_select.SelectedIndex]).Content + "', " +
size.ToString() + ")";
comm.Transaction = trans;
comm.ExecuteNonQuery();
trans.Commit();
FillForm();
this.datagrid.ItemsSource = GetTables.GetFiles(this.connection).DefaultView;
}
catch (Exception ex)
{
this.errors.Text = ex.Message + '\n' + this.errors.Text;
}
}
else
{
this.errors.Text = "Все поля заполни слыш" + '\n' + this.errors.Text;
}
}
private void btn_AddAu_Click(object sender, RoutedEventArgs e)
{
if (!this.fio_select.Text.Equals("") && !this.country_select.Text.Equals(""))
{
SqlTransaction trans = null;
SqlCommand comm = null;
try
{
comm = connection.CreateCommand();
trans = connection.BeginTransaction("AuthAdding");
comm.CommandText = "insert into Authors(FIO, country) values ('" +
this.fio_select.Text + "', '" +
this.country_select.Text + "')";
comm.Transaction = trans;
comm.ExecuteNonQuery();
trans.Commit();
this.datagrid.ItemsSource = GetTables.GetAuthors(this.connection).DefaultView;
FillForm();
}
catch (Exception ex)
{
this.errors.Text = ex.Message + '\n' + this.errors.Text;
}
}
}
private void search_field_TextChanged(object sender, TextChangedEventArgs e)
{
try
{
if (!this.search_field.Text.Equals(""))
{
this.datagrid.ItemsSource = GetTables.Search(((DataView)datagrid.ItemsSource).Table.TableName, this.search_field.Text, connection).DefaultView;
}
}
catch (Exception ex)
{
this.errors.Text = ex.Message + '\n' + this.errors.Text;
}
}
private void FillForm()
{
files = GetTables.GetFiles(this.connection);
authors = GetTables.GetAuthors(this.connection);
for (int i = 0; i < files.Rows.Count; i++)
{
this.file_select.Items.Add(files.Rows[i][0]);
}
for (int i = 0; i < authors.Rows.Count; i++)
{
this.auth_select.Items.Add(authors.Rows[i][0]);
}
this.file_select.SelectedIndex = 0;
this.auth_select.SelectedIndex = 0;
}
private void btn_delBook_Click(object sender, RoutedEventArgs e)
{
var selectedItem = datagrid.SelectedItem;
if (selectedItem != null)
{
try
{
if (((DataView)datagrid.ItemsSource).Table.TableName.Equals("Books"))
{
SqlCommand comm = connection.CreateCommand();
comm.CommandText = "delete Books where title like '" +
((DataRowView)selectedItem).Row.ItemArray[0] + "'";
comm.ExecuteNonQuery();
FillBookList();
}
else if (((DataView)datagrid.ItemsSource).Table.TableName.Equals("Files"))
{
SqlCommand comm = connection.CreateCommand();
comm.CommandText = "delete Files where file_id like '" +
((DataRowView)selectedItem).Row.ItemArray[0] + "'";
comm.ExecuteNonQuery();
this.datagrid.ItemsSource = GetTables.GetFiles(this.connection).DefaultView;
FillForm();
}
else
{
SqlCommand comm = connection.CreateCommand();
comm.CommandText = "delete Authors where FIO like '" +
((DataRowView)selectedItem).Row.ItemArray[0] + "'";
comm.ExecuteNonQuery();
this.datagrid.ItemsSource = GetTables.GetAuthors(this.connection).DefaultView;
FillForm();
}
}
catch (Exception ex)
{
this.errors.Text = ex.Message + '\n' + this.errors.Text;
}
}
}
private void btn_showAuthors_Click(object sender, RoutedEventArgs e)
{
this.datagrid.ItemsSource = GetTables.GetAuthors(this.connection).DefaultView;
}
