private void bookid_textbox_Leave(object sender, EventArgs e)
{
bool available;
if (bookid_textbox.Text != "")
{
string name = Library_Methods.find_bookname(int.Parse(bookid_textbox.Text), out available);
if (name.Equals("default", StringComparison.OrdinalIgnoreCase))
{
AlertBox.ShowDialog("No Books Available..Check BookID.", AlertBox.AlertType.warning, true);
booknm_TextBox.Text = "";
bookid_textbox.Text = "";
bookid_textbox.Focus();
}
else if (available)
{
booknm_TextBox.Text = name;
AlertBox.ShowDialog("No One Issue This Book...", AlertBox.AlertType.warning, true);
booknm_TextBox.Text = "";
bookid_textbox.Text = "";
bookid_textbox.Focus();
}
else
{
booknm_TextBox.Text = name;
int grno;
string Stud_name;
Library_Methods.find_return_details(int.Parse(bookid_textbox.Text), out grno, out Stud_name);
grno_TextBox.Text = grno.ToString();
studentnm_TextBox.Text = Stud_name;
}
}
}
private void add_button_Click(object sender, EventArgs e)
{
if (valid())
{
if (Library_Methods.check_book(int.Parse(bookid_textbox.Text)))
{
Library_Entity le = new Library_Entity()
{
bookid = int.Parse(bookid_textbox.Text),
booknm = booknm_TextBox.Text,
categoryid = int.Parse(select_category_comboBox.SelectedValue.ToString()),
authornm = authornm_TextBox.Text,
publisernm = publisernm_TextBox.Text,
price = int.Parse(price_numericUpDown.Value.ToString())
};
int flag = Library_Methods.Add_book(le);
if (flag > 0)
{
AlertBox.ShowDialog("Add Book Sucessfully", AlertBox.AlertType.success, true);
loadDatagridview();
}
}
else
{
AlertBox.ShowDialog("Already Available BookID", AlertBox.AlertType.warning, true);
bookid_textbox.Focus();
}
}
}
private void bookid_textbox_Leave(object sender, EventArgs e)
{
bool available;
if (bookid_textbox.Text != "")
{
string name = Library_Methods.find_bookname(int.Parse(bookid_textbox.Text), out available);
if (name.Equals("default", StringComparison.OrdinalIgnoreCase))
{
AlertBox.ShowDialog("No Books Available..Check BookID.", AlertBox.AlertType.warning, true);
booknm_TextBox.Text = "";
bookid_textbox.Text = "";
bookid_textbox.Focus();
}
else if (!available)
{
booknm_TextBox.Text = name;
AlertBox.ShowDialog("This Book Is Already Taken...", AlertBox.AlertType.warning, true);
booknm_TextBox.Text = "";
bookid_textbox.Text = "";
bookid_textbox.Focus();
}
else
{
booknm_TextBox.Text = name;
}
}
}
private void loadCategory()
{
DataTable dt_Category = Library_Methods.load_category_Datagridview();
select_category_comboBox.DataSource = dt_Category;
select_category_comboBox.DisplayMember = "Category_Name";
select_category_comboBox.ValueMember = "Category_ID";
}
private void loadDatagridview()
{
DataTable dt = Library_Methods.load_Book_Datagridview();
Book_dataGridView.DataSource = null;
Book_dataGridView.DataSource = dt;
//Book_dataGridView.Columns[0].Visible = false;
}
private void add_button_Click(object sender, EventArgs e)
{
if (valid())
{
Library_Entity le = new Library_Entity()
{
grno = int.Parse(grno_TextBox.Text),
bookid = int.Parse(bookid_textbox.Text),
date = dateTimePicker2.Value
};
Library_Methods.borrow_book(le);
AlertBox.ShowDialog("Added successfull.", AlertBox.AlertType.success, true);
clear();
}
}
private void add_button_Click(object sender, EventArgs e)
{
if (category_TextBox.Text != "")
{
Library_Entity le = new Library_Entity()
{
category_name = category_TextBox.Text
};
Library_Methods.Add_category(le);
AlertBox.ShowDialog("Category Add Successfully...", AlertBox.AlertType.success, true);
Category_dataGridView.Columns.RemoveAt(Category_dataGridView.Columns.Count - 1);
loadCategory();
}
else
{
AlertBox.ShowDialog("Please Enter Category...", AlertBox.AlertType.warning, true);
category_TextBox.BackColor = Color.Pink;
}
}
private void loadCategory()
{
dt_Category = Library_Methods.load_category_Datagridview();
Category_dataGridView.DataSource = dt_Category;
Category_dataGridView.AutoGenerateColumns = false;
if (!Category_dataGridView.Columns.Contains("remove"))
{
DataGridViewLinkColumn dc = new DataGridViewLinkColumn()
{
Text = "Remove",
HeaderText = "Edit",
Name = "remove",
UseColumnTextForLinkValue = true,
LinkColor = Color.Crimson,
LinkBehavior = LinkBehavior.HoverUnderline
};
Category_dataGridView.Columns.Insert(Category_dataGridView.Columns.Count, dc);
Category_dataGridView.Columns[0].Visible = false;
}
}
private void add_button_Click(object sender, EventArgs e)
{
if (valid())
{
Library_Entity le = new Library_Entity()
{
bookid = int.Parse(bookid_textbox.Text),
date = returnbook_datetimepicker.Value
};
int flag = Library_Methods.return_book(le);
if (flag != null)
{
AlertBox.ShowDialog("Return Successfully...", AlertBox.AlertType.success, true);
clear();
}
else
{
AlertBox.ShowDialog("Return Canceled...", AlertBox.AlertType.error, true);
}
}
}
private void grno_TextBox_Leave(object sender, EventArgs e)
{
if (grno_TextBox.Text != "")
{
string name = Library_Methods.find_studentnm(int.Parse(grno_TextBox.Text));
if (name == "default")
{
AlertBox.ShowDialog("No Student Available..Check Grno.", AlertBox.AlertType.warning, true);
studentnm_TextBox.Text = "";
grno_TextBox.Text = "";
}
else
{
studentnm_TextBox.Text = name;
}
}
else
{
studentnm_TextBox.Text = "";
}
}
private void Category_dataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
DataGridView dgv = sender as DataGridView;
string ctnm = "";
if (dgv.Rows.Count > 0)
{
ctnm = dgv.Rows[e.RowIndex].Cells[1].Value.ToString();
if (e.ColumnIndex == 2)
{
int affectedRows = Library_Methods.Delete_category(ctnm);
if (affectedRows > 0)
{
AlertBox.ShowDialog("Category Deleted Successfully", AlertBox.AlertType.success, true);
Category_dataGridView.Columns.RemoveAt(Category_dataGridView.Columns.Count - 1);
loadCategory();
}
}
}
}
}
