private void updateButton_Click(object sender, EventArgs e)
{
addBook addBookOBj = new addBook();
addBookOBj.bID = int.Parse(bIDTextBox.Text);
addBookOBj.titel = titelTextBox.Text;
addBookOBj.cID = int.Parse(cIDTextBox.Text);
addBookOBj.isbn = isbnTextBox.Text;
addBookOBj.publisher = publisherTextBox.Text;
addBookOBj.edition = editionTextBox.Text;
addBookOBj.arthor = arthorTextBox.Text;
addBookOBj.copies = int.Parse(copiesTextBox.Text);
addBookBL bookBLOBj = new addBookBL();
bool result = bookBLOBj.UpdateBookAndSendToBL(addBookOBj);
if (result)
{
MessageBox.Show("Succesfuly Update!!!!");
this.PopulateGridView();
IntitialButtonMood();
CleanTextBar();
}
else
{
MessageBox.Show("ERROR!!");
}
}
public bool DeleteBookAndSendToBL(addBook addBookOBj)
{
if (addBookOBj.bID == 0 || addBookOBj.titel == "" || addBookOBj.cID == 0 || addBookOBj.isbn == "" || addBookOBj.publisher == "" || addBookOBj.edition == "" || addBookOBj.copies == 0)
{
return(false);
}
else
{
addBookDA addBookDAobj = new addBookDA();
bool result = addBookDAobj.DeleteBookFromDB(addBookOBj);
return(result);
}
}
public bool DeleteBookFromDB(addBook addBookOBj)
{
SqlConnection connection = DatabaseConnection.OpenAnSqlConnection();
string query = "Delete Book WHERE BID = " + addBookOBj.bID + " ";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateBookToDB(addBook addBookOBj)
{
SqlConnection connection = DatabaseConnection.OpenAnSqlConnection();
string query = "UPDATE Book SET Titel = '" + addBookOBj.titel + "', CID =" + addBookOBj.cID + ",ISBN='" + addBookOBj.isbn + "', Publisher ='" + addBookOBj.publisher + "', Edition = '" + addBookOBj.edition + "' , Arthor='" + addBookOBj.arthor + "' , Copies = " + addBookOBj.copies + " WHERE BID = " + addBookOBj.bID + " ";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool SaveNewBookToDB(addBook addBookOBj)
{
SqlConnection connection = DatabaseConnection.OpenAnSqlConnection();
string query = "INSERT INTO Book VALUES (" + addBookOBj.bID + ",'" + addBookOBj.titel + "', " + addBookOBj.cID + ",'" + addBookOBj.isbn + "', '" + addBookOBj.publisher + "', '" + addBookOBj.edition + "' , '" + addBookOBj.arthor + "' , " + addBookOBj.copies + ")";
SqlCommand command = new SqlCommand(query, connection);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 1)
{
return(true);
}
else
{
return(false);
}
}
public void ShowAddBookWindow()
{
addBook ab = new addBook();
ab.Show();
}
public void ShowAddBookWindow()
{
addBook ab = new addBook();
ab.Show();
}
