/// <summary>
/// Добавления данных в определённую таблицу БД, ведённых пользователем!!!
/// </summary>
private void Btn_save_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
if (string.IsNullOrWhiteSpace(_contex.Name))
{
errors.AppendLine("Укажите название жанра");
}
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (_contex.id_Genre == 0)
{
BusinessLibraryEntities.GetContex().Genre.Add(_contex);
}
try
{
BusinessLibraryEntities.GetContex().SaveChanges();
MessageBox.Show("Информацию сохранена!!!");
AddFrame.frame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Экспорт в отчёт Excel
/// </summary>
private void btn_excel_Click(object sender, RoutedEventArgs e)
{
var allusers = BusinessLibraryEntities.GetContex().Avtor.ToList().OrderBy(p => p.Name).ToList();
var aplication = new Excel.Application();
aplication.SheetsInNewWorkbook = allusers.Count();
Excel.Workbook workbook = aplication.Workbooks.Add(Type.Missing);
int StartRowIndex = 1;
for (int i = 0; i < allusers.Count(); i++)
{
Excel.Worksheet worksheets = aplication.Worksheets.Item[i + 1];
worksheets.Name = allusers[i].Name;
worksheets.Cells[1][StartRowIndex] = "Имя Автора";
StartRowIndex++;
foreach (var date in BusinessLibraryEntities.GetContex().Avtor)
{
worksheets.Cells[1][StartRowIndex] = date.Name;
StartRowIndex++;
}
worksheets.Columns.AutoFit();
}
aplication.Visible = true;
}
/// <summary>
/// Обновление данных на странице при добавление, удаление, редактирование!!!
/// </summary>
private void Page_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e)
{
if (Visibility == Visibility.Visible)
{
BusinessLibraryEntities.GetContex().ChangeTracker.Entries().ToList().ForEach(p => p.Reload());
datagrid.ItemsSource = BusinessLibraryEntities.GetContex().Avtor.ToList();
}
}
/// <summary>
/// Поиск(фильтрация) данных по Имени поля
/// </summary>
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
string serch = Txtext.Text;
List <CourseLibrary.Avtor> avtors = BusinessLibraryEntities.GetContex().Avtor.ToList();
avtors = avtors.Where(a => a.Name.ToLower().Contains(serch.ToLower())).ToList();
datagrid.ItemsSource = avtors.ToList();
}
/// <summary>
/// Поиск(фильтрация) данных по Имени поля
/// </summary>
private void Txtext_TextChanged(object sender, TextChangedEventArgs e)
{
string serch = Txtext.Text;
List <Student> stud = BusinessLibraryEntities.GetContex().Student.ToList();
stud = stud.Where(a => a.Name.ToLower().Contains(serch.ToLower())).ToList();
datagrid.ItemsSource = stud.ToList();
}
/// <summary>
/// Поиск(фильтрация) данных по Имени поля
/// </summary>
private void Txtext_TextChanged(object sender, TextChangedEventArgs e)
{
string serch = Txtext.Text;
List <CourseLibrary.Avtorization> admin = BusinessLibraryEntities.GetContex().Avtorizations.ToList();
admin = admin.Where(a => a.Login.ToLower().Contains(serch.ToLower())).ToList();
datagrid.ItemsSource = admin.ToList();
}
/// <summary>
/// Редактирование записи
/// </summary>
private void btn_bild_Click(object sender, RoutedEventArgs e)
{
AddFrame.frame.Navigate(new AddPages.PStudent((sender as Button).DataContext as CourseLibrary.Student));
var ForRemoving = datagrid.SelectedItems.Cast <CourseLibrary.Student>().ToList(); //Выделение полей для удаления
BusinessLibraryEntities.GetContex().Student.RemoveRange(ForRemoving);
BusinessLibraryEntities.GetContex().SaveChanges();
}
/// <summary>
/// Поиск(фильтрация) данных по Имени поля
/// </summary>
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
string serch = Txtext.Text;
List <Book> books = BusinessLibraryEntities.GetContex().Books.ToList();
books = books.Where(a => a.Name.ToLower().Contains(serch.ToLower())).ToList();
datagrid.ItemsSource = books.ToList();
}
/// <summary>
/// Обьявления экземпляра нужной таблицы из БД, для манипуляциями самих данных
/// </summary>
public PStudent(Student selectStud)
{
InitializeComponent();
if (selectStud != null)
{
_contex = selectStud;
}
DataContext = _contex;
CMDaddress.ItemsSource = BusinessLibraryEntities.GetContex().Address.ToList();
CMDbook.ItemsSource = BusinessLibraryEntities.GetContex().Books.ToList();
}
/// <summary>
/// Обьявления экземпляра нужной таблицы из БД, для манипуляциями самих данных
/// </summary>
public PAvtorization(Avtorization selectedAvtoriz)
{
InitializeComponent();
if (selectedAvtoriz != null)
{
selectedAvtoriz = __contex;
}
this.DataContext = selectedAvtoriz;
cmb_profer.ItemsSource = BusinessLibraryEntities.GetContex().Profer.ToList();
DataContext = __contex;
}
/// <summary>
/// Обьявления экземпляра нужной таблицы из БД, для манипуляциями самих данных
/// </summary>
public PAccounting(Accounting selectedAccounting)
{
InitializeComponent();
if (selectedAccounting != null)
{
__contex = selectedAccounting;
}
cmb_profer.ItemsSource = BusinessLibraryEntities.GetContex().Profer.ToList();
cmb_stud.ItemsSource = BusinessLibraryEntities.GetContex().Student.ToList();
cmb_book.ItemsSource = BusinessLibraryEntities.GetContex().Books.ToList();
DataContext = __contex;
}
/// <summary>
/// Обьявления экземпляра нужной таблицы из БД, для манипуляциями самих данных
/// </summary>
public Pbook(Book selectedBook)
{
InitializeComponent();
if (selectedBook != null)
{
selectedBook = __contex;
}
this.DataContext = selectedBook;
cmb_genre.ItemsSource = BusinessLibraryEntities.GetContex().Genre.ToList();
cmb_avtor.ItemsSource = BusinessLibraryEntities.GetContex().Avtor.ToList();
DataContext = __contex;
}
/// <summary>
/// Добавления данных в определённую таблицу БД, ведённых пользователем!!!
/// </summary>
private void Btn_save_Click(object sender, RoutedEventArgs e)
{
StringBuilder errors = new StringBuilder();
if (string.IsNullOrWhiteSpace(_contex.Name))
{
errors.AppendLine("Укажите Имя");
}
if (string.IsNullOrWhiteSpace(_contex.FName))
{
errors.AppendLine("Укажите Фамилия");
}
if (string.IsNullOrWhiteSpace(_contex.LName))
{
errors.AppendLine("Укажите Отчество");
}
if (string.IsNullOrWhiteSpace(_contex.Specialty))
{
errors.AppendLine("Укажите название Специальности");
}
if (errors.Length > 0)
{
MessageBox.Show(errors.ToString());
return;
}
if (_contex.id_Profer == 0)
{
BusinessLibraryEntities.GetContex().Profer.Add(_contex);
}
try
{
BusinessLibraryEntities.GetContex().SaveChanges();
MessageBox.Show("Информацию сохранена!!!");
AddFrame.frame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Экспорт в отчёт Excel
/// </summary>
private void btn_excel_Click(object sender, RoutedEventArgs e)
{
var allusers = BusinessLibraryEntities.GetContex().Student.ToList().OrderBy(p => p.FName).ToList();
var aplication = new Excel.Application();
aplication.SheetsInNewWorkbook = allusers.Count();
Excel.Workbook workbook = aplication.Workbooks.Add(Type.Missing);
int StartRowIndex = 1;
for (int i = 0; i < allusers.Count(); i++)
{
Excel.Worksheet worksheets = aplication.Worksheets.Item[i + 1];
worksheets.Name = allusers[i].FName;
worksheets.Cells[1][StartRowIndex] = "Имя";
worksheets.Cells[2][StartRowIndex] = "Фамилия";
worksheets.Cells[3][StartRowIndex] = "Очество";
worksheets.Cells[4][StartRowIndex] = "Серия паспорта";
worksheets.Cells[5][StartRowIndex] = "Телефон";
worksheets.Cells[6][StartRowIndex] = "Адрес";
worksheets.Cells[7][StartRowIndex] = "Книга";
StartRowIndex++;
foreach (var date in BusinessLibraryEntities.GetContex().Student)
{
worksheets.Cells[1][StartRowIndex] = date.Name;
worksheets.Cells[2][StartRowIndex] = date.FName;
worksheets.Cells[3][StartRowIndex] = date.LName;
worksheets.Cells[4][StartRowIndex] = date.Pasport_seria;
worksheets.Cells[5][StartRowIndex] = date.Telephone;
worksheets.Cells[6][StartRowIndex] = date.Address.Strets;
worksheets.Cells[7][StartRowIndex] = date.Book.Name;
StartRowIndex++;
}
worksheets.Columns.AutoFit();
}
aplication.Visible = true;
}
/// <summary>
/// Добавления данных в определённую таблицу БД, ведённых пользователем!!!
/// </summary>
private void Btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
var _contex = new Avtorization();
BusinessLibraryEntities.GetContex().Avtorizations.Add(_contex);
_contex.Login = login.Text;
_contex.Password = password.Text;
_contex.Profer = (Profer)cmb_profer.SelectedItem;
BusinessLibraryEntities.GetContex().SaveChanges();
MessageBox.Show("Информацию сохранена!!!");
AddFrame.frame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Экспорт в отчёт Excel
/// </summary>
private void btn_excel_Click(object sender, RoutedEventArgs e)
{
var allusers = BusinessLibraryEntities.GetContex().Accounting.ToList().OrderBy(p => p.DateOfIssue).ToList();
var aplication = new Excel.Application();
aplication.SheetsInNewWorkbook = allusers.Count();
Excel.Workbook workbook = aplication.Workbooks.Add(Type.Missing);
int StartRowIndex = 1;
for (int i = 0; i < allusers.Count(); i++)
{
Excel.Worksheet worksheets = aplication.Worksheets.Item[i + 1];
worksheets.Name = allusers[i].NumberOfBooks;
worksheets.Cells[1][StartRowIndex] = "Руководитель";
worksheets.Cells[2][StartRowIndex] = "Студент";
worksheets.Cells[3][StartRowIndex] = "Книга";
worksheets.Cells[4][StartRowIndex] = "Дата выдачи";
worksheets.Cells[5][StartRowIndex] = "Дата принятия";
worksheets.Cells[6][StartRowIndex] = "Количество книг";
StartRowIndex++;
foreach (var date in BusinessLibraryEntities.GetContex().Accounting)
{
worksheets.Cells[1][StartRowIndex] = date.Profer.Name;
worksheets.Cells[2][StartRowIndex] = date.Student.Name;
worksheets.Cells[3][StartRowIndex] = date.Book.Name;
worksheets.Cells[4][StartRowIndex] = date.DateOfIssue.ToString("dd.MM.yyyy HH:mm");
worksheets.Cells[5][StartRowIndex] = date.DateOfAdoption;
worksheets.Cells[6][StartRowIndex] = date.NumberOfBooks;
StartRowIndex++;
}
worksheets.Columns.AutoFit();
}
aplication.Visible = true;
}
/// <summary>
/// Добавления данных в определённую таблицу БД, ведённых пользователем!!!
/// </summary>
private void Btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
var _contex = new Accounting();
BusinessLibraryEntities.GetContex().Accounting.Add(_contex);
_contex.Profer = (Profer)cmb_profer.SelectedItem;
_contex.Student = (Student)cmb_stud.SelectedItem;
_contex.Book = (Book)cmb_book.SelectedItem;
_contex.NumberOfBooks = Numberbook.Text;
BusinessLibraryEntities.GetContex().SaveChanges();
MessageBox.Show("Информацию сохранена!!!");
AddFrame.frame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Добавления данных в определённую таблицу БД, ведённых пользователем!!!
/// </summary>
private void Btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
var _contex = new Book();
BusinessLibraryEntities.GetContex().Books.Add(_contex);
_contex.Name = NameB.Text;
_contex.Genre = (Genre)cmb_genre.SelectedItem;
_contex.Avtor = (Avtor)cmb_avtor.SelectedItem;
_contex.NumberOfLines = numberoflines.Text;
_contex.Amount = amount.Text;
BusinessLibraryEntities.GetContex().SaveChanges();
MessageBox.Show("Информацию сохранена!!!");
AddFrame.frame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Удаление записи
/// </summary>
private void Btn_delete_Click(object sender, RoutedEventArgs e)
{
var ForRemoving = datagrid.SelectedItems.Cast <CourseLibrary.Avtor>().ToList(); //Выделение полей для удаления
if (MessageBox.Show($"Вы точно хотите удалить следущие {ForRemoving.Count()} Элементов???", "Внимание", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
try
{
BusinessLibraryEntities.GetContex().Avtor.RemoveRange(ForRemoving);
BusinessLibraryEntities.GetContex().SaveChanges();
MessageBox.Show("Данные удалены!!!");
datagrid.ItemsSource = BusinessLibraryEntities.GetContex().Avtor.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
/// <summary>
/// Экспорт в отчёт Excel
/// </summary>
private void btn_excel_Click(object sender, RoutedEventArgs e)
{
var allusers = BusinessLibraryEntities.GetContex().Books.ToList().OrderBy(p => p.Name).ToList();
var aplication = new Excel.Application();
aplication.SheetsInNewWorkbook = allusers.Count();
Excel.Workbook workbook = aplication.Workbooks.Add(Type.Missing);
int StartRowIndex = 1;
for (int i = 0; i < allusers.Count(); i++)
{
Excel.Worksheet worksheets = aplication.Worksheets.Item[i + 1];
worksheets.Name = allusers[i].Name;
worksheets.Cells[1][StartRowIndex] = "Имя";
worksheets.Cells[2][StartRowIndex] = "Жанр";
worksheets.Cells[3][StartRowIndex] = "Автор";
worksheets.Cells[4][StartRowIndex] = "Колчиство страниц в книге";
worksheets.Cells[5][StartRowIndex] = "Количество книг";
StartRowIndex++;
foreach (var date in BusinessLibraryEntities.GetContex().Books)
{
worksheets.Cells[1][StartRowIndex] = date.Name;
worksheets.Cells[2][StartRowIndex] = date.Genre.Name;
worksheets.Cells[3][StartRowIndex] = date.Avtor.Name;
worksheets.Cells[4][StartRowIndex] = date.NumberOfLines;
worksheets.Cells[5][StartRowIndex] = date.Amount;
StartRowIndex++;
}
worksheets.Columns.AutoFit();
}
aplication.Visible = true;
}
/// <summary>
/// Добавления данных в определённую таблицу БД, ведённых пользователем!!!
/// </summary>
private void Btn_save_Click(object sender, RoutedEventArgs e)
{
try
{
var __contex = new Student();
BusinessLibraryEntities.GetContex().Student.Add(__contex);
__contex.Name = Name.Text;
__contex.FName = FName.Text;
__contex.LName = LName.Text;
__contex.Pasport_seria = PsP.Text;
__contex.Telephone = Tel.Text;
__contex.Address = (Address)CMDaddress.SelectedItem;
__contex.Book = (Book)CMDbook.SelectedItem;
BusinessLibraryEntities.GetContex().SaveChanges();
MessageBox.Show("Информацию сохранена!!!");
AddFrame.frame.GoBack();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Экспорт в отчёт Excel
/// </summary>
private void btn_excel_Click(object sender, RoutedEventArgs e)
{
var allusers = BusinessLibraryEntities.GetContex().Profer.ToList().OrderBy(p => p.FName).ToList();
var aplication = new Excel.Application();
aplication.SheetsInNewWorkbook = allusers.Count();
Excel.Workbook workbook = aplication.Workbooks.Add(Type.Missing);
int StartRowIndex = 1;
for (int i = 0; i < allusers.Count(); i++)
{
Excel.Worksheet worksheets = aplication.Worksheets.Item[i + 1];
worksheets.Name = allusers[i].FName;
worksheets.Cells[1][StartRowIndex] = "Имя";
worksheets.Cells[2][StartRowIndex] = "Фамилия";
worksheets.Cells[3][StartRowIndex] = "Отчество";
worksheets.Cells[4][StartRowIndex] = "Специальность";
StartRowIndex++;
foreach (var date in BusinessLibraryEntities.GetContex().Profer)
{
worksheets.Cells[1][StartRowIndex] = date.Name;
worksheets.Cells[2][StartRowIndex] = date.FName;
worksheets.Cells[3][StartRowIndex] = date.LName;
worksheets.Cells[4][StartRowIndex] = date.Specialty;
StartRowIndex++;
}
worksheets.Columns.AutoFit();
}
aplication.Visible = true;
}
public Students()
{
InitializeComponent();
datagrid.ItemsSource = BusinessLibraryEntities.GetContex().Student.ToList();
}
public accountOtch()
{
InitializeComponent();
datagrid.ItemsSource = BusinessLibraryEntities.GetContex().Accounting.ToList();
}
public Books1()
{
InitializeComponent();
datagrid.ItemsSource = BusinessLibraryEntities.GetContex().Books.ToList();
}
public Avtor()
{
InitializeComponent();
datagrid.ItemsSource = BusinessLibraryEntities.GetContex().Avtor.ToList();
}
