private void ClearForm()
{
TitleTextBox.Clear();
FileNameTextBox.Clear();
AuthorTextBox.Clear();
AlbumTextBox.Clear();
}
private void SaveButton_Click(object sender, EventArgs e)
{
new LogController().AddLogEntry(TitleTextBox.Text, DateTimePicker.Value, StartTimeTimePicker.Value, EndTimeTimePicker.Value, HoursWorkedTimePicker.Value, DescriptionTextBox.Text, AuthorTextBox.Text);
TitleTextBox.Clear();
DescriptionTextBox.Clear();
AuthorTextBox.Clear();
MessageBox.Show("New log entry added!", "Log added!");
}
/// <summary>
/// Clears fields and sets necessary fields to prepare for
/// save.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void NewBookButton_Click(object sender, EventArgs e)
{
AuthorTextBox.Clear();
TitleTextBox.Clear();
ISBNTextBox.Clear();
PriceTextBox.Clear();
BookSelectBox.Enabled = false;
SaveButton.Enabled = true;
CancelButton.Enabled = true;
}
private void SaveButton_Click(object sender, EventArgs e)
{
// Check for empty boxes.
if (AuthorTextBox.Text == "" || TitleTextBox.Text == "" || ISBNTextBox.Text == "" || PriceTextBox.Text == "" ||
!Regex.IsMatch(AuthorTextBox.Text, author) || !Regex.IsMatch(TitleTextBox.Text, title) || !Regex.IsMatch(ISBNTextBox.Text, isbn) ||
!Regex.IsMatch(PriceTextBox.Text, price))
{
MessageBox.Show("Invalid Entry:\nAuthor must be First Last\nISBN must be digits only\nPrice must be $xxx.xx format");
return;
}
// Display messagebox -> If user clicks no, cancel database update.
if (MessageBox.Show("Confirm Update?", "", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
string ConnectionString = "server=localhost;user=root;database=book store;password="******"Insert into books values(null,'{TitleTextBox.Text}','{AuthorTextBox.Text}','{ISBNTextBox.Text}','{PriceTextBox.Text}')";
cmd.Connection = DBConnect;
cmd.ExecuteNonQuery();
DBConnect.Close();
AuthorTextBox.Clear();
TitleTextBox.Clear();
ISBNTextBox.Clear();
PriceTextBox.Clear();
// Call function to update the combobox with new book added.
BookSelectComboBox_Click(sender, e);
BookSelectBox.Enabled = true;
SaveButton.Enabled = false;
MessageBox.Show("Book added to database.");
return;
}
// Else update the currently selected book
cmd.CommandText = $"Update books set title='{TitleTextBox.Text}', author='{AuthorTextBox.Text}',isbn='{ISBNTextBox.Text}',price='{PriceTextBox.Text}' where title='{BookSelectBox.Text}'";
cmd.Connection = DBConnect;
cmd.ExecuteNonQuery();
DBConnect.Close();
MessageBox.Show("Book successfully updated.");
}
/// <summary>
/// Event handler for EditAuthorButton click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void EditAuthorButton_Click(object sender, RoutedEventArgs e)
{
//Opens a new EditAuthorDialog dialog window.
EditAuthorDialog ead = new EditAuthorDialog(this, controller);
if ((bool)ead.ShowDialog()) //if dialog returns true (changes confirmed)
{
changedAuthor = ead.Result; //set changed author to the result of dialog window
//reflect change in control
AuthorTextBox.Clear();
AuthorTextBox.Text = String.Format("{0} {1}", changedAuthor.FirstName, changedAuthor.LastName);
}
}
private void CleanUp()
{
TitleTextBox.Clear();
AuthorTextBox.Clear();
DescTextBox.Clear();
ShortcutTextBox.Clear();
IdTextBox.Clear();
ToolTipTextBox.Clear();
DefaultTextBox.Clear();
CodeRichTextBox.Clear();
LiteralListBox.Items.Clear();
LiteralList.Clear();
foreach (TreeNode tn in DllAndNamespaceTreeView.Nodes)
{
tn.Checked = false;
}
}
