private void ReturnBookButton_Click(object sender, EventArgs e) { string id; try { id = CopyListView.SelectedItems[0].SubItems[0].Text; } catch (ArgumentOutOfRangeException ex) { MessageManager.ShowMessageBox("Please select a book ID", "Error"); return; } string[] columns = { "Reader", "Borrowed" }; string[] values = { "NULL", "NULL" }; string[] conditions = { $"{userId} = Reader", $"{id} = ID" }; database.UpdateTable(ControllerDB.Table.Copy, columns, values, conditions); PopulateTable(); }
private void CheckoutButton_Click(object sender, EventArgs e) { try { string isbn = CopyListView.SelectedItems[0].SubItems[0].Text; if (CopyListView.SelectedItems[0].SubItems[3].Text == "0") { MessageManager.ShowMessageBox("There are no copies left", "Error"); return; } string[] columns = { "Reader", "Borrowed" }; string[] values = { String.Format("{0:D7}", previousWindow.userId), "GETDATE()" }; string[] conditions = { ("ID in (SELECT TOP 1 id from db_owner.Copy " + $"WHERE READER IS NULL AND ISBN = {isbn} ORDER BY NEWID())") }; database.UpdateTable(ControllerDB.Table.Copy, columns, values, conditions); this.Hide(); } catch (System.ArgumentOutOfRangeException ex) { MessageManager.ShowMessageBox("Please select a book ISBN", "Error"); } }