private void Button_Click(object sender, RoutedEventArgs e)
{
var button = sender as Button;
var tag = button.Tag as string;
var tagInt = Convert.ToInt32(tag);
switch (tagInt)
{
case 0:
//Нажата кнопка "Выдать книгу"
checkOutBookWindow = new CheckOutBookWindow();
checkOutBookWindow.ShowDialog();
break;
case 1:
//Нажата кнопка "Выдать периодическое издание"
checkOutPeriodicalWindow = new CheckOutPeriodicalWindow();
checkOutPeriodicalWindow.ShowDialog();
break;
case 2:
//Нажата кнопка "Принять/продлить документ"
returnRenewWindow = new ReturnRenewWindow();
returnRenewWindow.ShowDialog();
break;
case 3:
//Нажата кнопка "Найти документ в базе данных"
mainSearchWindow = new SearchWindows.MainSearchWindow();
mainSearchWindow.ShowDialog();
break;
case 4:
//Нажата кнопка "Зарегистрировать читателя"
customerRegistrationWindow = new CustomerRegistrationWindow();
customerRegistrationWindow.ShowDialog();
break;
case 5:
//Нажата кнопка "Назад"
Close();
break;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var button = sender as Button;
var tag = button.Tag as string;
var tagInt = Convert.ToInt32(tag);
switch (tagInt)
{
case 0:
//Нажата кнопка "Поступление книги"
addBookMainWindow = new AddBookMainWindow();
addBookMainWindow.ShowDialog();
break;
case 1:
//Нажата кнопка "Поступление периодического издания"
addPeriodicalMainWindow = new AddPeriodicalMainWindow();
addPeriodicalMainWindow.ShowDialog();
break;
case 2:
//Нажата кнопка "Списание документа"
documentWriteOffWindow = new DocumentWriteOffWindows.MainDocumentWriteOffWindow();
documentWriteOffWindow.ShowDialog();
break;
case 3:
//Нажата кнопка "Невозвращенные документы"
overdueDocumentsOverviewWindow = new OverdueDocumentsOverviewWindow();
overdueDocumentsOverviewWindow.ShowDialog();
break;
case 4:
//Нажата кнопка "Поиск по базе данных документов"
mainSearchwindow = new SearchWindows.MainSearchWindow();
mainSearchwindow.ShowDialog();
break;
case 5:
//Нажата кнопка "Назад"
Close();
break;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
const string RenewDocumentQuery = @"update [Coursework_2018].[dbo].[CustomerDocumentInteraction] set DueDate=@dueDate, IfRenewed=1 where CDInteractionID=@currentCDIID";
const string AddRenewalDateQuery = @"insert [Coursework_2018].[dbo].[RenewalDates] (CDInteractionID, RenewalDate) values (@currentCDIID, getdate())";
const string SetStatusTakenQuery = "update [Coursework_2018].[dbo].[CustomerDocumentInteraction] set Status = 'Taken' where CDInteractionID = @id";
var button = sender as Button;
var tag = button.Tag as string;
var tagInt = Convert.ToInt32(tag);
switch (tagInt)
{
case 0:
//Нажата кнопка "Продлить книгу"
if (BooksDataGrid.SelectedItem != null)
{
QueryResultClasses.CustomerOverviewWindow_BooksDataGrid currentBook = (QueryResultClasses.CustomerOverviewWindow_BooksDataGrid)BooksDataGrid.SelectedItem;
if (currentBook.Status == "Taken" || currentBook.Status == "Overdue")
{
using (TheContext db = new TheContext())
{
TimeSpan month = new TimeSpan(31, 0, 0, 0);
db.Database.ExecuteSqlCommand(RenewDocumentQuery, new SqlParameter("@dueDate", currentBook.DueDate + month), new SqlParameter("currentCDIID", currentBook.CDInteractionID));
if (currentBook.DueDate + month > DateTime.Now)
{
db.Database.ExecuteSqlCommand(SetStatusTakenQuery, new SqlParameter("@id", currentBook.CDInteractionID));
}
db.Database.ExecuteSqlCommand(AddRenewalDateQuery, new SqlParameter("@currentCDIID", currentBook.CDInteractionID));
//Обновление данных в DataGrid:
BooksDataGridQueryResult = db.Database.SqlQuery <QueryResultClasses.CustomerOverviewWindow_BooksDataGrid>(BooksDataGridSqlQuery, new SqlParameter("@id", UserID)).ToList();
BooksDataGrid.ItemsSource = null;
BooksDataGrid.ItemsSource = BooksDataGridQueryResult;
MessageBox.Show("Книга продлена.");
}
}
else
{
MessageBox.Show("Выбранная книга уже возвращена в библиотеку.");
}
}
else
{
MessageBox.Show("Выберите книгу для продления.");
}
break;
case 1:
//Нажата кнопка "Продлить периодическое издание"
if (PeriodicalsDataGrid.SelectedItem != null)
{
QueryResultClasses.CustomerOverviewWindow_PeriodicalsDataGrid currentPeriodical = (QueryResultClasses.CustomerOverviewWindow_PeriodicalsDataGrid)PeriodicalsDataGrid.SelectedItem;
if (currentPeriodical.Status == "Taken" || currentPeriodical.Status == "Overdue")
{
using (TheContext db = new TheContext())
{
TimeSpan month = new TimeSpan(31, 0, 0, 0);
db.Database.ExecuteSqlCommand(RenewDocumentQuery, new SqlParameter("@dueDate", currentPeriodical.DueDate + month), new SqlParameter("currentCDIID", currentPeriodical.CDInteractionID));
if (currentPeriodical.DueDate + month > DateTime.Now)
{
db.Database.ExecuteSqlCommand(SetStatusTakenQuery, new SqlParameter("@id", currentPeriodical.CDInteractionID));
}
db.Database.ExecuteSqlCommand(AddRenewalDateQuery, new SqlParameter("@currentCDIID", currentPeriodical.CDInteractionID));
//Обновление данных в DataGrid:
PeriodicalsDataGridQueryResult = db.Database.SqlQuery <QueryResultClasses.CustomerOverviewWindow_PeriodicalsDataGrid>(PeriodicalsDataGridSqlQuery, new SqlParameter("@id", UserID)).ToList();
PeriodicalsDataGrid.ItemsSource = null;
PeriodicalsDataGrid.ItemsSource = PeriodicalsDataGridQueryResult;
MessageBox.Show("Периодическое издание продлено.");
}
}
else
{
MessageBox.Show("Выбранное издание уже возвращено в библиотеку.");
}
}
else
{
MessageBox.Show("Выберите периодическое издание для продления.");
}
break;
case 2:
//Нажата кнопка "Искать документ в базе данных"
SearchWindow = new SearchWindows.MainSearchWindow();
SearchWindow.ShowDialog();
break;
case 3:
//Нажата кнопка "Назад"
Close();
break;
}
}