public void AddNew(Book newBook)
{
MySqlConnection conn = new MySqlConnection(MyConnection.connectionString);
MySqlCommand comm = new MySqlCommand();
String strQuery = null;
try
{
conn.Open();
strQuery = "INSERT INTO tblBook(BookNo,Status,Category) VALUES ('" + newBook.BookNo + "','" + newBook.Status + "','" + newBook.Category + "')";
comm.Connection = conn;
comm.CommandText = strQuery;
comm.ExecuteNonQuery();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message, SystemVariable.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conn.Close();
}
public bool BookNoExist(Book newBook)
{
MySqlConnection conn = new MySqlConnection(MyConnection.connectionString);
MySqlCommand comm = new MySqlCommand();
MySqlDataReader reader = null;
String strQuery = null;
//default
bool value = false;
strQuery = "SELECT * FROM tblBook WHERE BookNo='" + newBook.BookNo + "' AND Category='" + newBook.Category + "'";
try
{
conn.Open();
comm.Connection = conn;
comm.CommandText = strQuery;
reader = comm.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
value = true;
}
reader.Close();
value = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, SystemVariable.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
value = false;
}
conn.Close();
return value;
}