public void AddBookWithAuthors(BookVM book)
{
var _book = new Book()
{
Title = book.Title,
Description = book.Description,
IsRead = book.IsRead,
DateRead = book.IsRead ? book.DateRead.Value : null,
Rate = book.IsRead ? book.Rate.Value : null,
Genre = book.Genre,
CoverUrl = book.CoverUrl,
DateAdded = DateTime.Now,
PublisherId = book.PublisherId
};
_context.Books.Add(_book);
_context.SaveChanges();
foreach (var id in book.AuthorIds)
{
var _book_author = new Book_Authors()
{
BookId = _book.Id,
AuthorId = id
};
_context.Book_Authors.Add(_book_author);
_context.SaveChanges();
}
}
private void booksDeleteButton_Click(object sender, EventArgs e)
{
databaseController dbc = new databaseController();
string selectedBook = bookslistBox.SelectedItem.ToString();//exception needs to be handled
selectedBook = selectedBook.Trim();
string[] BookID = selectedBook.Split('|');
selectedBook = BookID[1].Trim();
int total_pages = Convert.ToInt32(BookID[2].Trim());
int id_b = Convert.ToInt32(BookID[0].Trim());
string publish_date = BookID[4].Trim();
int rating = Convert.ToInt32(BookID[3].Trim());
string summary = BookID[5].Trim();
int publisher_id = Convert.ToInt32(BookID[6].Trim());
int location_id = Convert.ToInt32(BookID[7].Trim());
int id_g = 0;
Books b = new Books(id_b, selectedBook, summary, year, lost, genre_id);
Book_Genres bg = new Book_Genres(id_b, id_g);
dbc.DeleteBooksGenres(bg);
Book_Authors ba = new Book_Authors(id_b, id_g);
dbc.DeleteBooksAuthors(ba);
dbc.DeleteBooks(b);
bookslistBox.Items.Clear();
OutputBooks();
}
public ActionResult DeleteConfirmed(int id)
{
Book_Authors book_Authors = db.Book_Authors.Find(id);
db.Book_Authors.Remove(book_Authors);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteRelation(long book_id, string fname, string lname)
{
long id = db.Authors.Where(a => a.firstName == fname && a.lastName == lname).Select(a => a.id).First();
Book_Authors ba = db.Book_Authors.Where(a => a.AuthorId == id && a.BookId == book_id).First();
db.Book_Authors.Remove(ba);
db.TrySaveChanges();
return(RedirectToAction("Details", "Books", new { id = book_id }));
}
public void SaveBooksAuthors(Book_Authors Book_AuthorsToSave)
{
using (SQLiteConnection con = new SQLiteConnection("data source=Knjiznica_projektt.db"))
{
con.Open();
string query = "INSERT INTO book_authors (author_id, book_id) VALUES((SELECT id_a FROM authors WHERE id_a='" + Book_AuthorsToSave.author_id + "'), '" + Book_AuthorsToSave.book_id + "');";
SQLiteCommand com = new SQLiteCommand(query, con);
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
}
public void DeleteBooksAuthors(Book_Authors Book_AuthorsToDelete)
{
using (SQLiteConnection con = new SQLiteConnection("data source=Knjiznica_projektt.db"))
{
con.Open();
string query = "DELETE FROM book_authors WHERE(book_id='" + Book_AuthorsToDelete.book_id + "' AND author_id='" + Book_AuthorsToDelete.author_id + "');";
SQLiteCommand com = new SQLiteCommand(query, con);
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
}
public ActionResult Edit([Bind(Include = "Books_AuthorID,AuthorID,BookID")] Book_Authors book_Authors)
{
if (ModelState.IsValid)
{
db.Entry(book_Authors).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AuthorID = new SelectList(db.Authors, "AuthorID", "FirstName", book_Authors.AuthorID);
ViewBag.BookID = new SelectList(db.Books, "BookID", "Title", book_Authors.BookID);
return(View(book_Authors));
}
public void UpdateBooksAuthors(Book_Authors Book_AuthorsToUpdate)
{
using (SQLiteConnection con = new SQLiteConnection("data source=Knjiznica_projektt.db"))
{
con.Open();
string query = "UPDATE book_authors SET author_id='" + Book_AuthorsToUpdate.newid + "', book_id='" + Book_AuthorsToUpdate.book_id + "' WHERE id_ba='" + Book_AuthorsToUpdate.id_ba + "';";
SQLiteCommand com = new SQLiteCommand(query, con);
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
}
public void UpdateBooksAuthors(Book_Authors Book_AuthorsToUpdate)
{
//List<string> listOfLocations = new List<string>();
using (NpgsqlConnection con = new NpgsqlConnection("Server=hattie.db.elephantsql.com; User Id=oxbcwgvz;" + "Password=igpiilcYjHtSKKDcs3wuGd15RtjskDzP; Database=oxbcwgvz;"))
{
con.Open();
string query = "UPDATE book_authors SET author_id='" + Book_AuthorsToUpdate.author_id + "' WHERE book_id='" + Book_AuthorsToUpdate.book_id + "';";
NpgsqlCommand com = new NpgsqlCommand(query, con);
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
}
public void SaveBooksAuthors(Book_Authors Book_AuthorsToSave)
{
// List<string> listOfLocations = new List<string>();
using (NpgsqlConnection con = new NpgsqlConnection("Server=hattie.db.elephantsql.com; User Id=oxbcwgvz;" + "Password=igpiilcYjHtSKKDcs3wuGd15RtjskDzP; Database=oxbcwgvz;"))
{
con.Open();
string query = "INSERT INTO book_authors (book_id, author_id) VALUES((SELECT id_b FROM books WHERE id_b='" + Book_AuthorsToSave.book_id + "'), (SELECT id_a FROM authors WHERE id_a='" + Book_AuthorsToSave.author_id + "'));";
NpgsqlCommand com = new NpgsqlCommand(query, con);
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
}
// GET: Book_Authors/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Book_Authors book_Authors = db.Book_Authors.Find(id);
if (book_Authors == null)
{
return(HttpNotFound());
}
return(View(book_Authors));
}
// GET: Book_Authors/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Book_Authors book_Authors = db.Book_Authors.Find(id);
if (book_Authors == null)
{
return(HttpNotFound());
}
ViewBag.AuthorID = new SelectList(db.Authors, "AuthorID", "FirstName", book_Authors.AuthorID);
ViewBag.BookID = new SelectList(db.Books, "BookID", "Title", book_Authors.BookID);
return(View(book_Authors));
}
public List <int> ReadAuthorsID(Book_Authors Book_AuthorsToGetID)
{
List <int> listOfAuthorsID = new List <int>();
using (SQLiteConnection con = new SQLiteConnection("data source=Knjiznica_projektt.db"))
{
con.Open();
string query = "SELECT author_id FROM book_authors WHERE book_id='" + Book_AuthorsToGetID.book_id + "';";
SQLiteCommand com = new SQLiteCommand(query, con);
SQLiteDataReader reader = com.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
listOfAuthorsID.Add(id);
}
con.Close();
return(listOfAuthorsID);
}
}
public List <int> idBookAuthors(Book_Authors ToReadIDs)
{
List <int> listOfIDs = new List <int>();
using (SQLiteConnection con = new SQLiteConnection("data source=Knjiznica_projektt.db"))
{
con.Open();
string query = "SELECT id_ba FROM book_authors WHERE (author_id=" + ToReadIDs.author_id + " AND book_id=" + ToReadIDs.book_id + ");";
SQLiteCommand com = new SQLiteCommand(query, con);
SQLiteDataReader reader = com.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
listOfIDs.Add(id);
}
com.Dispose();
con.Close();
return(listOfIDs);
}
}
public ActionResult Create(long book_id, [Bind(Include = "id,firstName,lastName,birthDate,sex,birthPlace,BIO,photo")] Authors authors)
{
if (ModelState.IsValid)
{
long author_id;
BooksController bc = new BooksController();
if (bc.IsInDatabase(authors.firstName, authors.lastName, 3) == false)
{
db.Authors.Add(authors);
db.SaveChanges();
author_id = authors.id;
}
else
{
author_id = db.Authors.Where(a => a.firstName == authors.firstName && a.lastName == authors.lastName).Select(a => a.id).First();
}
if (book_id != 0)
{
Book_Authors bk = new Book_Authors()
{
BookId = book_id,
AuthorId = author_id
};
db.Book_Authors.Add(bk);
db.TrySaveChanges();
}
return(RedirectToAction("Details", "Books", new { id = book_id }));
}
return(View(authors));
}
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();
}
public ActionResult Create(CombinedDataModels newBook)
{
if (ModelState.IsValid)
{
long book_id;
long author_id;
long genre_id;
long series_id;
//***************************check if title, author, genre and series are in database************************
if (IsInDatabase(newBook.Books.title, null, 0) == false)
{
Books book;
if (newBook.cover == null)
{
book = new Books()
{
title = newBook.Books.title,
year = newBook.Books.year,
description = newBook.Books.description,
cover = null
}
}
;
else
{
book = new Books()
{
title = newBook.Books.title,
year = newBook.Books.year,
description = newBook.Books.description,
cover = newBook.cover.FileName
};
newBook.cover.SaveAs(HttpContext.Server.MapPath(ConfigurationManager.AppSettings["bookCovers"]) + book.cover);
}
db.Books.Add(book);
db.TrySaveChanges();
book_id = book.id;
}
else
{
book_id = db.Books.Where(b => b.title == newBook.Books.title).Select(b => b.id).First();
}
if (IsInDatabase(newBook.Authors.firstName, newBook.Authors.lastName, 3) == false)
{
Authors author;
if (newBook.photo == null)
{
author = new Authors()
{
firstName = newBook.Authors.firstName,
lastName = newBook.Authors.lastName,
birthDate = newBook.Authors.birthDate,
birthPlace = newBook.Authors.birthPlace,
BIO = newBook.Authors.BIO,
photo = null,
sex = newBook.Authors.sex
}
}
;
else
{
author = new Authors()
{
firstName = newBook.Authors.firstName,
lastName = newBook.Authors.lastName,
birthDate = newBook.Authors.birthDate,
birthPlace = newBook.Authors.birthPlace,
BIO = newBook.Authors.BIO,
photo = newBook.photo.FileName,
sex = newBook.Authors.sex
};
newBook.photo.SaveAs(HttpContext.Server.MapPath(ConfigurationManager.AppSettings["authorPhotos"]) + author.photo);
}
db.Authors.Add(author);
db.TrySaveChanges();
author_id = author.id;
}
else
{
author_id = db.Authors.Where(a => a.firstName == newBook.Authors.firstName && a.lastName == newBook.Authors.lastName).Select(a => a.id).First();
}
if (BookIsBounded(book_id, author_id, 0) == false)
{
Book_Authors bk = new Book_Authors()
{
BookId = book_id,
AuthorId = author_id
};
db.Book_Authors.Add(bk);
}
if (IsInDatabase(newBook.Genres.genre, null, 1) == false)
{
Genres genre = new Genres()
{
genre = newBook.Genres.genre
};
db.Genres.Add(genre);
db.TrySaveChanges();
genre_id = genre.id;
}
else
{
genre_id = db.Genres.Where(g => g.genre == newBook.Genres.genre).Select(g => g.id).First();
}
if (IsInDatabase(newBook.Series.series, null, 2) == false)
{
Series series = new Series()
{
series = newBook.Series.series
};
db.Series.Add(series);
db.TrySaveChanges();
series_id = series.id;
}
else
{
series_id = db.Series.Where(s => s.series == newBook.Series.series).Select(s => s.id).First();
}
if (BookIsBounded(book_id, genre_id, 1) == false)
{
Book_Genres bg = new Book_Genres()
{
BookId = book_id,
GenreId = genre_id
};
db.Book_Genres.Add(bg);
}
if (BookIsBounded(book_id, series_id, 2) == false)
{
Book_Series bs = new Book_Series()
{
BookId = book_id,
SeriesId = series_id
};
db.Book_Series.Add(bs);
}
db.TrySaveChanges();
return(RedirectToAction("Index", "Books"));
}
return(View(newBook));
}
private void booksUpdateButton_Click(object sender, EventArgs e)
{
databaseController dbc = new databaseController();
string selectedBook = bookslistBox.SelectedItem.ToString();//exception needs to be handled
MessageBox.Show(selectedBook);
selectedBook = selectedBook.Trim();
string[] BookID = selectedBook.Split('|');
selectedBook = BookID[1].Trim();
int id_b = Convert.ToInt32(BookID[0].Trim());
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
//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 description_genre = GenreID[2].Trim();
int id_g = Convert.ToInt32(GenreID[0].Trim());
int id_aa = 0;
#endregion
#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
Book_Authors ba = new Book_Authors(id_b, id_a);
dbc.UpdateBooksAuthors(ba);
Book_Genres bg = new Book_Genres(id_b, id_g);
dbc.UpdateBooksGenres(bg);
Books b = new Books(id_b, title, summary, year, lost, genre_id);
dbc.UpdateBooks(b);
bookslistBox.Items.Clear();
OutputBooks();
}
private void booksDeleteButton_Click(object sender, EventArgs e)
{
if (bookslistBox.SelectedItem == null)
{
MessageBox.Show("Nobena knjiga ni izbrana.");
}
else
{
databaseController dbc = new databaseController();
string selectedBook = bookslistBox.SelectedItem.ToString();//exception needs to be handled
selectedBook = selectedBook.Trim();
string[] BookID = selectedBook.Split('|');
int id_b = Convert.ToInt32(BookID[0].Trim());
selectedBook = BookID[1].Trim();//title
string author_name = BookID[2].Trim();
string author_surname = BookID[3].Trim();
int lost = Convert.ToInt32(BookID[4].Trim());
string year = BookID[5].Trim();
string location_name = BookID[6].Trim();
string publisher_name = BookID[7].Trim();
string genre_genretype = BookID[8].Trim();
int id_g = 0;
Authors aid = new Authors(0, author_name, author_surname);
dbc.idAuthors(aid);
int author_id = 0;
foreach (int k in dbc.idAuthors(aid))
{
author_id = k;
}
Locations lid = new Locations(0, location_name, "");
dbc.idLocations(lid);
int location_id = 0;
foreach (int k in dbc.idLocations(lid))
{
location_id = k;
}
Publishers pid = new Publishers(0, publisher_name);
dbc.idPublishers(pid);
int publisher_id = 0;
foreach (int k in dbc.idPublishers(pid))
{
publisher_id = k;
}
Genres gid = new Genres(0, genre_genretype);
dbc.idGenres(gid);
int genre_id = 0;
foreach (int k in dbc.idGenres(gid))
{
genre_id = k;
}
Books b = new Books(id_b, selectedBook, "", year, lost, genre_id, publisher_id, location_id);
#region author_id
Book_Authors id = new Book_Authors(0, id_b);
dbc.ReadAuthorsID(id);
int id_a = 0;
foreach (int k in dbc.ReadAuthorsID(id))
{
id_a = k;
}
/*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
Book_Authors ba = new Book_Authors(author_id, id_b);
//MessageBox.Show("author"+Convert.ToString(author_id), "book" + Convert.ToString(id_b));
dbc.DeleteBooksAuthors(ba);
dbc.DeleteBooks(b);
bookslistBox.Items.Clear();
OutputBooks();
userUnLendedBookslistBox.Items.Clear();
userLendedBookslistBox.Items.Clear();
//OutputBooksOnRents_Lended();
OutputBooksOnRents_UnLended();
}
}
private void booksUpdateButton_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();
string selectedBook = bookslistBox.SelectedItem.ToString();//exception needs to be handled
selectedBook = selectedBook.Trim();
string[] BookID = selectedBook.Split('|');
int id_b = Convert.ToInt32(BookID[0].Trim());
selectedBook = BookID[1].Trim();//title
string author_name = BookID[2].Trim();
string author_surname = BookID[3].Trim();
int lost = Convert.ToInt32(BookID[4].Trim());
string year = BookID[5].Trim();
string location_name = BookID[6].Trim();
string publisher_name = BookID[7].Trim();
string genre_genretype = BookID[8].Trim();
int id_g = 0;
string summary = summaryTextBox.Text;
#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());
#endregion
#region location_id
string selectedLocation = locationBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedLocation = selectedLocation.Trim();
string[] LocationID = selectedLocation.Split('|');
int location_id = Convert.ToInt32(LocationID[0].Trim());
#endregion
#region author_id
string selectedAuthor = authorsBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedAuthor = selectedAuthor.Trim();
string[] AuthorID = selectedAuthor.Split('|');
int author_id_waiting = Convert.ToInt32(AuthorID[0].Trim());//nov id
#endregion
Authors aid = new Authors(0, author_name, author_surname);//tastar id
dbc.idAuthors(aid);
int author_id = 0;
foreach (int k in dbc.idAuthors(aid))
{
author_id = k;
}
Book_Authors baid = new Book_Authors(author_id, id_b);//poiscem id v book authors z pomocjo ttih idejev
dbc.idBookAuthors(baid);
int book_authors_id = 0;
foreach (int k in dbc.idBookAuthors(baid))
{
book_authors_id = k;
}
Books b = new Books(id_b, selectedBook, summary, year, lost, genre_id, publisher_id, location_id);
Book_Authors ba = new Book_Authors(author_id, id_b, book_authors_id, author_id_waiting);
dbc.UpdateBooksAuthors(ba);
dbc.UpdateBooks(b);
bookslistBox.Items.Clear();
OutputBooks();
userUnLendedBookslistBox.Items.Clear();
userLendedBookslistBox.Items.Clear();
//OutputBooksOnRents_Lended();
OutputBooksOnRents_UnLended();
}
}
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();
}
}
