public BookHandler(Books BookInfo, frmBookViewer.SaveOrUpdateDelete saveOrUpdateDelete, string old_ISBN, out bool success)
{
if (saveOrUpdateDelete == frmBookViewer.SaveOrUpdateDelete.Save)
{
qry = "INSERT INTO Books (Title,Author,ISBN,Year,Pages,Price,In_Stock,Hired_Out,pic)" +
"VALUES (@Title,@Author,@ISBN,@Year,@Pages,@Price,@In_Stock,@Hired_Out,@pic)";
}
else if (saveOrUpdateDelete == frmBookViewer.SaveOrUpdateDelete.Update)
{
qry = "UPDATE Books SET Title = @Title,Author = @Author,ISBN = @ISBN,Year = @Year," +
"Pages = @Pages,Price = @Price,In_Stock = @In_Stock,Hired_Out = @Hired_Out, pic = @pic WHERE ISBN = @OLD_ISBN";
}
else
{
qry = "DELETE FROM Books WHERE ISBN = @ISBN";
}
using (MySqlConnection Connection = new MySqlConnection(MyConString))
{
success = false;
try
{
MySqlCommand cmd = new MySqlCommand(qry, Connection);
cmd.Parameters.Add(new MySqlParameter("@Title", (object)BookInfo.Title));
cmd.Parameters.Add(new MySqlParameter("@Author", (object)BookInfo.Author));
cmd.Parameters.Add(new MySqlParameter("@ISBN", (object)BookInfo.ISBN));
cmd.Parameters.Add(new MySqlParameter("@Year", (object)BookInfo.Year));
cmd.Parameters.Add(new MySqlParameter("@Pages", (object)BookInfo.Pages));
cmd.Parameters.Add(new MySqlParameter("@Price", (object)BookInfo.Price));
cmd.Parameters.Add(new MySqlParameter("@In_Stock", (object)BookInfo.In_Stock));
cmd.Parameters.Add(new MySqlParameter("@Hired_Out", (object)BookInfo.Hired_Out));
cmd.Parameters.Add(new MySqlParameter("@pic", (object)BookInfo.pic));
cmd.Parameters.Add(new MySqlParameter("@OLD_ISBN", (object)old_ISBN));
Connection.Open();
cmd.ExecuteNonQuery();
success = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Connection.Close();
}
}
}
private void List()
{
using (MySqlConnection Connection = new MySqlConnection(MyConString))
{
try
{
Connection.Open();
MySqlCommand cmd = new MySqlCommand(qry, Connection);
MySqlDataReader reader;
reader = cmd.ExecuteReader();
int Count = 0;
if (reader.HasRows)
{
while (reader.Read())
{
Books BookInfo = new Books
{
Title = reader["Title"].ToString(),
Author = reader["Author"].ToString(),
ISBN = reader["ISBN"].ToString(),
Year = reader["Year"].ToString(),
Pages = int.Parse(reader["Pages"].ToString()),
Price = decimal.Parse(reader["Price"].ToString()),
In_Stock = int.Parse(reader["In_Stock"].ToString()),
Hired_Out = int.Parse(reader["Hired_Out"].ToString()),
pic = (byte[])reader["pic"],
};
Test[Count] = BookInfo;
Count++;
}
}
else
{
MessageBox.Show("No Books where found", "Books", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Connection.Close();
}
}
}
public BookHandler(out Books[] books)
{
ListWithOutFilter();
books = Test;
}
public BookHandler(out Books[] books, string Column, string Value)
{
ListWithFilter(Column, Value);
books = Test;
}
private bool SaveOrUpdateOrDeleteSQL(SaveOrUpdateDelete saveOrUpdateDelete)
{
bool success;
if (coverPictureBox.ImageLocation == null)
{
coverPictureBox.ImageLocation = Application.StartupPath + "\\No_Image.jpeg";
}
Books BookInfo = new Books
{
Title = titleTextBox.Text,
Author = authorTextBox.Text,
ISBN = isbnTextBox.Text,
Year = yearTextBox.Text,
Pages = int.Parse(pagesTextBox.Text),
Price = decimal.Parse(priceTextBox.Text, NumberStyles.Any),
pic = ReadFile(coverPictureBox.ImageLocation),
In_Stock = int.Parse(instocktextBox.Text),
Hired_Out = int.Parse(hiredtextBox.Text),
};
new BookHandler(BookInfo, saveOrUpdateDelete, Old_ISBN, out success);
return success;
}
