private void Add_Click_Func(bool is_edit) { description = tb_description.Text.Replace('\'', ' '); name = (tb_name.Text.Trim()).Replace('\'', ' '); author = cb_author.SelectedItem.ToString(); publisher = cb_publisher.SelectedItem.ToString(); category = cb_category.SelectedItem.ToString(); shelf = cb_shelf.SelectedItem.ToString(); count = (int)numUpDown_count.Value; date = DateTime.Now.ToString(); pic_new_source_path = picture_event.Pic_source_file; lbl_message.Text = ""; // Validations if (tb_name.Text.Trim() == "Book's Name" || tb_name.Text.Trim() == "") { lbl_message.Text = "* Please enter book's name."; lbl_message.ForeColor = Color.Red; tb_name.Focus(); return; } if (cb_author.SelectedIndex == 0) { lbl_message.Text = "* Please choose an author."; lbl_message.ForeColor = Color.Red; cb_author.Focus(); return; } if (cb_publisher.SelectedIndex == 0) { lbl_message.Text = "* Please choose a publisher."; lbl_message.ForeColor = Color.Red; cb_publisher.Focus(); return; } if (cb_category.SelectedIndex == 0) { lbl_message.Text = "* Please choose a category."; lbl_message.ForeColor = Color.Red; cb_category.Focus(); return; } if (tb_description.Text == "Description..." || tb_description.Text == "") { lbl_message.Text = "* Please enter description."; lbl_message.ForeColor = Color.Red; tb_description.Focus(); return; } if (cb_shelf.SelectedIndex == 0) { lbl_message.Text = "* Please choose a shelf."; lbl_message.ForeColor = Color.Red; cb_shelf.Focus(); return; } if (pic_new_source_path == null || pic_new_source_path == pic_default_file) { lbl_message.Text = "* Please choose a picture."; lbl_message.ForeColor = Color.Red; tb_description.Focus(); picture_event.Choose_Image(); return; } Join_Tables(); if (is_edit == false) { picture_event.Copy_The_Picture(name); pic_new_source_path = picture_event.Pic_source_file; Book book = new Book(0, author_id, publisher_id, category_id, main_page.Manager.Employee_id, shelf_id, name, count, date, description, pic_new_source_path, 0, 0); book.Add(); Clear(); } else { if (change_image) { Picture_Events.Delete_The_Picture(book_to_edit.Cover_path_file); picture_event.Copy_The_Picture(name); main_page.Remove_Image_From_Cover_List(book_to_edit.Book_id); book_to_edit.Cover_path_file = picture_event.Pic_source_file; book_to_edit.Cover_Pic_to_Image_List(); change_image = false; } lbl_message.Text = "*Book changed successfully"; lbl_message.ForeColor = Color.LightGreen; book_to_edit.Author_id = author_id; book_to_edit.Publisher_id = publisher_id; book_to_edit.Category_id = category_id; book_to_edit.Shelf_id = shelf_id; book_to_edit.Count = count; book_to_edit.Name = name; book_to_edit.Description = description; book_to_edit.Edit(); main_page.Pnl_book_list.VerticalScroll.Value = 0; main_page.Book_search_list.Delete_All_List(); main_page.Main_book_list.Draw_All_Books(); main_page.Book_searched_already = false; main_page.Main_shelf_list.Delete_All_List(); Shelf.Show_All_Shelf(main_page); } }