private void booksAddButton_Click(object sender, EventArgs e)
{
if (titleTextBox.Text == "" || yearTextBox.Text == "" || authorsBooksCombobox.SelectedItem == null || publishersBooksCombobox.SelectedItem == null || genreBooksCombobox.SelectedItem == null || locationBooksCombobox.SelectedItem == null)
{
MessageBox.Show("Preverite vnos. Eno izmed polij ni napolnjeno.");
}
else
{
databaseController dbc = new databaseController();
int id_b = 0;
string title = titleTextBox.Text;
string summary = Convert.ToString(summaryTextBox.Text);
string year = Convert.ToString(yearTextBox.Text);
int lost = 0;
string publish_date = Convert.ToString(DateTime.Now.Date.ToString("MM/dd/yyyy"));
if (lostBookCheckBox.Checked)
{
lost = 1;
}
else
{
lost = 0;
}
#region genre_id
string selectedGenre1 = genreBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedGenre1 = selectedGenre1.Trim();
string[] GenreID1 = selectedGenre1.Split('|');
selectedGenre1 = GenreID1[1].Trim();
int genre_id = Convert.ToInt32(GenreID1[0].Trim());
#endregion
#region publisher_id
string selectedPublisher = publishersBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedPublisher = selectedPublisher.Trim();
string[] PublisherID = selectedPublisher.Split('|');
selectedPublisher = PublisherID[1].Trim();
int publisher_id = Convert.ToInt32(PublisherID[0].Trim());
selectedPublisher = publishersNameTextBox.Text;
MessageBox.Show(Convert.ToString(publisher_id));
#endregion
#region location_id
string selectedLocation = locationBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedLocation = selectedLocation.Trim();
string[] LocationID = selectedLocation.Split('|');
selectedLocation = LocationID[1].Trim();
string postalcode = LocationID[2].Trim();
int location_idd = Convert.ToInt32(LocationID[0].Trim());
MessageBox.Show("locationid" + Convert.ToString(location_idd) + selectedLocation + postalcode);
#endregion
Books b = new Books(id_b, title, summary, year, lost, genre_id, publisher_id, location_idd);
dbc.SaveBooks(b);
dbc.idBooks(b);
int book_id = 0;
foreach (int k in dbc.idBooks(b))
{
book_id = k;
}
//getting genre id
#region genre_id
string selectedGenre = genreBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedGenre = selectedGenre.Trim();
string[] GenreID = selectedGenre.Split('|');
selectedGenre = GenreID[1].Trim();
int id_g = Convert.ToInt32(GenreID[0].Trim());
//selectedGenre = genresNametextBox.Text;
//g_description = genresDescriptionrichTextBox.Text;
#endregion
//getting author id
#region author_id
string selectedAuthor = authorsBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedAuthor = selectedAuthor.Trim();
string[] AuthorID = selectedAuthor.Split('|');
selectedAuthor = AuthorID[1].Trim();
string surname = AuthorID[2].Trim();
int id_a = Convert.ToInt32(AuthorID[0].Trim());
#endregion
//getting book_id
Book_Authors ba = new Book_Authors(id_a, book_id);
dbc.SaveBooksAuthors(ba);
DateTime currentDateTime = DateTime.Now;
Rents rentss = new Rents(0, 0, Convert.ToString(currentDateTime), book_id, 0);
dbc.SaveBookRents(rentss);
bookslistBox.Items.Clear();
OutputBooks();
userUnLendedBookslistBox.Items.Clear();
userLendedBookslistBox.Items.Clear();
//OutputBooksOnRents_Lended();
OutputBooksOnRents_UnLended();
}
}
private void booksAddButton_Click(object sender, EventArgs e)
{
ratingNumeric.Minimum = 1;
ratingNumeric.Maximum = 10;
databaseController dbc = new databaseController();
int id_b = 0;
string title = titleTextBox.Text;
int total_pages = Convert.ToInt32(numOfPages.Value);
int rating = Convert.ToInt32(ratingNumeric.Value);
string publish_date = Convert.ToString(DateTime.Now.Date.ToString("MM/dd/yyyy"));
string summary = Convert.ToString(summaryTextBox.Text);
//getting location id in bookstab
#region location_id
string selectedLocation = locationBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedLocation = selectedLocation.Trim();
string[] LocationID = selectedLocation.Split('|');
selectedLocation = LocationID[1].Trim();
string postalcode = LocationID[2].Trim();
int id_l = Convert.ToInt32(LocationID[0].Trim());
#endregion
//getting publisher id in books tab
#region publisher_id
string selectedPublisher = publishersBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedPublisher = selectedPublisher.Trim();
string[] PublisherID = selectedPublisher.Split('|');
selectedPublisher = PublisherID[1].Trim();
string description = PublisherID[2].Trim();
int id_p = Convert.ToInt32(PublisherID[0].Trim());
selectedPublisher = publishersNameTextBox.Text;
description = publishersDescriptionRichTextBox.Text;
#endregion
Books b = new Books(id_b, title, summary, year, lost, genre_id);
dbc.SaveBooks(b);
//getting genre id
#region genre_id
string selectedGenre = genreBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedGenre = selectedGenre.Trim();
string[] GenreID = selectedGenre.Split('|');
selectedGenre = GenreID[1].Trim();
string g_description = GenreID[2].Trim();
int id_g = Convert.ToInt32(GenreID[0].Trim());
//selectedGenre = genresNametextBox.Text;
//g_description = genresDescriptionrichTextBox.Text;
#endregion
//getting author id
#region author_id
string selectedAuthor = authorsBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedAuthor = selectedAuthor.Trim();
string[] AuthorID = selectedAuthor.Split('|');
selectedAuthor = AuthorID[1].Trim();
string surname = AuthorID[2].Trim();
string middlename = AuthorID[3].Trim();
int id_a = Convert.ToInt32(AuthorID[0].Trim());
#endregion
//getting book_id
#region book_id
List <string> listOfBookss = new List <string>();
using (NpgsqlConnection con = new NpgsqlConnection("Server=hattie.db.elephantsql.com; User Id=oxbcwgvz;" + "Password=igpiilcYjHtSKKDcs3wuGd15RtjskDzP; Database=oxbcwgvz;"))
{
con.Open();
string query = "SELECT id_b FROM books WHERE(title='" + title + "' AND total_pages='" + total_pages + "' AND rating='" + rating + "' AND publisher_id='" + id_p + "' AND location_id='" + id_l + "')";
NpgsqlCommand com = new NpgsqlCommand(query, con);
NpgsqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
int id_bb = reader.GetInt32(0);
listOfBookss.Add(id_bb + "");
}
con.Close();
}
string prvi = listOfBookss.ElementAt(0);
int idbb = Convert.ToInt32(prvi);
#endregion
Book_Authors ba = new Book_Authors(idbb, id_a);
dbc.SaveBooksAuthors(ba);
Book_Genres bg = new Book_Genres(idbb, id_g);
dbc.SaveBooksGenres(bg);
bookslistBox.Items.Clear();
OutputBooks();
}
