private void RB_Return_Book_btn_Click(object sender, EventArgs e) { string Book_Name = RB_BookName_txtbox.Text; var book_detail = from item in data.BOOKDETAILS where item.NAME == Book_Name select item; int book_id = 0; foreach (var item in book_detail) { book_id = item.ID; } RETURN_BOOK return_book = new RETURN_BOOK() { BOOKDETAIL_ID = book_id, FINE = (RB_Fine_txtbox.Text), RETURN_DATE = DateTime.Now, USER_ID = user_id }; BOOKDETAIL book_check = data.BOOKDETAILS.Find(book_id); book_check.STATUS = false; data.RETURN_BOOKS.Add(return_book); data.SaveChanges(); MetroMessageBox.Show(this, "Success", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); }
/*BOOK DETAIL Section Ends*/ /*ISSUING BOOK SECTION SARTS*/ private void Issued_Save_btn_Click(object sender, EventArgs e) { if (IB_Catalog_Name_Combo.Text == "") { MetroMessageBox.Show(this, "Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { int book_id = (int)Issued_Book_Combo.SelectedValue; ISSUED_BOOK book_data = new ISSUED_BOOK { BOOKDETAIL_ID = book_id, ISSUED_BY = user_id, ISSUED_ON = DateTime.Now, ISSUED_TO = Issued_Issuedto_Combo.SelectedIndex + 1, DAY_LIMIT = Ib_issuuing_days_limit_combo.SelectedIndex + 1, IB_BOOKCAT = IB_Catalog_Name_Combo.SelectedIndex + 1, }; BOOKDETAIL book_check = data.BOOKDETAILS.Find(book_id); book_check.STATUS = true; data.ISSUED_BOOKS.Add(book_data); data.SaveChanges(); load_comboBoxes(); MetroMessageBox.Show(this, "Success", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void Delete_btn_Click(object sender, EventArgs e) { int id = (int)(BD_Gridview.CurrentRow.Cells[0].Value); BOOKDETAIL bookData = data.BOOKDETAILS.Find(id); data.BOOKDETAILS.Remove(bookData); data.SaveChanges(); load_comboBoxes(); }
private void Issued_Book_Combo_SelectedIndexChanged(object sender, EventArgs e) { int id = Issued_Book_Combo.SelectedIndex; BOOKDETAIL selected = Issued_Book_Combo.Items[id] as BOOKDETAIL; id = selected.ID; BOOKDETAIL data12 = data.BOOKDETAILS.Where(x => x.ID == id).SingleOrDefault(); Issued_Author_txtbox.Text = data12.AUTHOR_NAME; Issued_Lang_txtbox.Text = data12.LANGUAGE; Issued_publication_year_txtbox.Text = data12.PUBLICATION_YEAR; }
private void BD_Gridview_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { int id = Convert.ToInt16(BD_Gridview.CurrentRow.Cells[0].Value.ToString()); BOOKDETAIL bookData = data.BOOKDETAILS.Find(id); //Catalog_Combo.SelectedValue = bookData.Book_Catalog; Book_Name_Txtbox.Text = bookData.NAME; Language_Txtbox.Text = bookData.LANGUAGE; Number_of_Copies_txtbox.Text = bookData.NO_OF_COPIES_ACTUAL; Number_Of_Avilabe_Txtbox.Text = bookData.NO_OF_COPIES_CURRENT; Publication_Year_Txtbox.Text = bookData.PUBLICATION_YEAR; Author_Name_txtbox.Text = bookData.AUTHOR_NAME; }
private void BD_Gridview_RowHeaderMouseDoubleClick(object sender, DataGridViewCellEventArgs e) { id = (int)(BD_Gridview.CurrentRow.Cells[0].Value); BOOKDETAIL bookData = data.BOOKDETAILS.Find(id); Catalog_Combo.SelectedValue = bookData.Book_Catalog; Book_Name_Txtbox.Text = bookData.NAME; Language_Txtbox.Text = bookData.LANGUAGE; Number_of_Copies_txtbox.Text = bookData.NO_OF_COPIES_ACTUAL; Number_Of_Avilabe_Txtbox.Text = bookData.NO_OF_COPIES_CURRENT; Publication_Year_Txtbox.Text = bookData.PUBLICATION_YEAR; Author_Name_txtbox.Text = bookData.AUTHOR_NAME; Save_btn.Text = "Update"; Delete_btn.Enabled = true; }
private void Save_btn_Click(object sender, EventArgs e) { if (Save_btn.Text == "Save") { BOOKDETAIL bookData = new BOOKDETAIL { NAME = Book_Name_Txtbox.Text.Trim(), LANGUAGE = Language_Txtbox.Text.Trim(), NO_OF_COPIES_ACTUAL = Number_of_Copies_txtbox.Text.Trim(), NO_OF_COPIES_CURRENT = Number_Of_Avilabe_Txtbox.Text.Trim(), PUBLICATION_YEAR = Publication_Year_Txtbox.Text.Trim(), AUTHOR_NAME = Author_Name_txtbox.Text.Trim(), Book_Catalog = (int)Catalog_Combo.SelectedValue, USER_ID = user_id, STATUS = false, }; data.BOOKDETAILS.Add(bookData); data.SaveChanges(); bd_loaddata(); BD_Clear(); MessageBox.Show("Successfull"); } else if (Save_btn.Text == "Update") { id = (int)(BD_Gridview.CurrentRow.Cells[0].Value); BOOKDETAIL bookData = data.BOOKDETAILS.Find(id); bookData.Book_Catalog = (int)Catalog_Combo.SelectedValue; bookData.NAME = Book_Name_Txtbox.Text; bookData.LANGUAGE = Language_Txtbox.Text; bookData.NO_OF_COPIES_ACTUAL = Number_of_Copies_txtbox.Text; bookData.NO_OF_COPIES_CURRENT = Number_Of_Avilabe_Txtbox.Text; bookData.PUBLICATION_YEAR = Publication_Year_Txtbox.Text; bookData.AUTHOR_NAME = Author_Name_txtbox.Text; data.SaveChanges(); MessageBox.Show("Successfull"); Delete_btn.Enabled = false; Save_btn.Text = "New"; BD_Clear(); bd_loaddata(); } load_comboBoxes(); }
private void Update_btn_Click(object sender, EventArgs e) { if (Update_btn.Text == "Update") { int id = (int)(BD_Gridview.CurrentRow.Cells[0].Value); BOOKDETAIL bookData = data.BOOKDETAILS.Find(id); bookData.Book_Catalog = (int)Catalog_Combo.SelectedValue; bookData.NAME = Book_Name_Txtbox.Text; bookData.LANGUAGE = Language_Txtbox.Text; bookData.NO_OF_COPIES_ACTUAL = Number_of_Copies_txtbox.Text; bookData.NO_OF_COPIES_CURRENT = Number_Of_Avilabe_Txtbox.Text; bookData.PUBLICATION_YEAR = Publication_Year_Txtbox.Text; bookData.AUTHOR_NAME = Author_Name_txtbox.Text; data.SaveChanges(); MessageBox.Show("Successfull"); // BD_Clear(); BD_Dataload(); } load_comboBoxes(); }
private void Issued_Save_btn_Click(object sender, EventArgs e) { int book_id = (int)Issued_Book_Combo.SelectedValue; ISSUED_BOOK book_data = new ISSUED_BOOK { BOOKDETAIL_ID = book_id, ISSUED_BY = user_id, ISSUED_ON = DateTime.Now, ISSUED_TO = Issued_Issuedto_Combo.SelectedIndex + 1, DAY_LIMIT = Ib_issuuing_days_limit_combo.SelectedIndex + 1, IB_BOOKCAT = IB_Catalog_Name_Combo.SelectedIndex + 1, }; BOOKDETAIL book_check = data.BOOKDETAILS.Find(book_id); book_check.STATUS = true; data.ISSUED_BOOKS.Add(book_data); data.SaveChanges(); ib_loaddata(); IB_Clear(); load_comboBoxes(); }
/*BOOK DETAIL Section Starts*/ private void Save_btn_Click_1(object sender, EventArgs e) { if (Book_Name_Txtbox.Text == "") { MetroMessageBox.Show(this, "Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Language_Txtbox.Text == "") { MetroMessageBox.Show(this, "Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Number_Of_Avilabe_Txtbox.Text == "") { MetroMessageBox.Show(this, "Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Number_of_Copies_txtbox.Text == "") { MetroMessageBox.Show(this, "Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { BOOKDETAIL bookData = new BOOKDETAIL { NAME = Book_Name_Txtbox.Text.Trim(), LANGUAGE = Language_Txtbox.Text.Trim(), NO_OF_COPIES_ACTUAL = Number_of_Copies_txtbox.Text.Trim(), NO_OF_COPIES_CURRENT = Number_Of_Avilabe_Txtbox.Text.Trim(), PUBLICATION_YEAR = Publication_Year_Txtbox.Text.Trim(), AUTHOR_NAME = Author_Name_txtbox.Text.Trim(), Book_Catalog = (int)Catalog_Combo.SelectedValue, USER_ID = user_id, STATUS = false, }; data.BOOKDETAILS.Add(bookData); data.SaveChanges(); BD_Dataload(); MetroMessageBox.Show(this, "Successfull", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); load_comboBoxes(); } }