public void InsertCopy(Copy copy)
{
using (MySqlConnection conn = new MySqlConnection(connString))
{
conn.Open();
MySqlCommand command = new MySqlCommand(INSERT_COPY, conn);
/* Add parameters into the command */
command.Parameters.AddWithValue("@copy_is_present", copy.copy_is_present);
command.Parameters.AddWithValue("@book_id", copy.book_id);
/* Executes the command */
command.ExecuteNonQuery();
}
}
public List<Copy> SelectAll()
{
List<Copy> copyList = new List<Copy>();
using (MySqlConnection conn = new MySqlConnection(connString))
{
conn.Open();
MySqlCommand command = new MySqlCommand(SELECT_ALL, conn);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Copy copy = new Copy();
copy.copy_id = reader.GetInt32(0);
copy.copy_is_present = reader.GetInt32(1);
copy.book_id = reader.GetInt32(2);
copyList.Add(copy);
}
}
return copyList;
}
public Copy SelectOne(int copyId)
{
Copy copy = new Copy();
using (MySqlConnection conn = new MySqlConnection(connString))
{
conn.Open();
MySqlCommand command = new MySqlCommand(SELECT_ONE, conn);
command.Parameters.AddWithValue("@copy_id", copyId);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
copy.copy_id = reader.GetInt32(0);
copy.book_id = reader.GetInt32(1);
copy.copy_is_present = reader.GetInt32(2);
}
reader.Close();
}
return copy;
}
protected void Button3_Click(object sender, EventArgs e)
{
//prida zaznam do kopie
DatabaseLibrary.Copy copy = new DatabaseLibrary.Copy();
copy.copy_is_present = Convert.ToInt32(TextBox_copy_isPresent.Text);
copy.book_id = Convert.ToInt32(ddl_copy_bookID.SelectedValue);
new DatabaseLibrary.CopyTable().InsertCopy(copy);
Response.Redirect(Request.RawUrl);
}
public List<Copy> SelectAllPresentByBook(int bookId)
{
List<Copy> copyList = new List<Copy>();
using (MySqlConnection conn = new MySqlConnection(connString))
{
conn.Open();
MySqlCommand command = new MySqlCommand(SELECT_ALLPRESENT_BY_BOOK_ID, conn);
command.Parameters.AddWithValue("@book_id", bookId);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Copy copy = new Copy();
copy.copy_id = reader.GetInt32(0);
copy.copy_is_present = reader.GetInt32(1);
copy.book_id = reader.GetInt32(2);
copyList.Add(copy);
}
}
return copyList;
}