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();
}
}
