private void btn_add_book_Click(object sender, EventArgs e)
{
string sid = tb_id_book.Text.Trim();
string name = tb_name_book.Text.ToString().Trim();
string author = tb_author_book.Text.ToString().Trim();
string category = cb_category_book.SelectedItem.ToString().Trim();
string sstock = tb_stock_book.Text.ToString().Trim();
if (category.Equals("Select"))
{
category = "";
}
if (!isValidString(sid))
{
sid = "0";
}
if (isValidString(sid) && isValidString(name) && isValidString(author) && isValidString(category) && isValidString(sstock))
{
int id = int.Parse(sid);
int stock = int.Parse(sstock);
BookControls bookControls = new BookControls();
Book book = bookControls.SearchBook(id);
if (book == null)
{
book = new Book(id, name, author, category, stock);
bookControls = new BookControls(book);
bool isAdded = bookControls.AddUser();
if (isAdded)
{
if (cb_search_book.SelectedIndex == cb_search_book.FindStringExact(book.Category.Trim()))
{
LoadBooks();
}
else
{
cb_search_book.SelectedIndex = cb_search_book.FindStringExact(book.Category.Trim());
}
ClearViews();
MessageBox.Show("Book Added.");
}
else
{
MessageBox.Show("Book can not be Added.");
}
}
else
{
MessageBox.Show("Book Already Exists.");
}
}
else
{
MessageBox.Show("Please Enter All Info.");
}
}
private int getAllBooks()
{
BookControls bookControls = new BookControls();
List <Book> books = bookControls.LoadBooks("All");
int count = 0;
foreach (Book b in books)
{
count++;
}
return(count);
}
private void btn_book_enter_issue_Click(object sender, EventArgs e)
{
string sid = tb_book_id_issue.Text.ToString().Trim();
if (isValidString(sid))
{
int id = int.Parse(sid);
BookControls bookControls = new BookControls();
Book book = bookControls.SearchBook(id);
if (book != null)
{
IssueControls issueControls = new IssueControls();
List <Issue> allIssue = issueControls.LoadIssuesByStatus("Issued");
List <Issue> issuedIssue = new List <Issue>();
foreach (Issue i in allIssue)
{
if (i.Status.Equals("Issued"))
{
issuedIssue.Add(i);
}
}
int count = 0;
foreach (Issue i in issuedIssue)
{
if (i.BookId == id)
{
count++;
}
}
int total = book.Stock - count;
lbl_book_info_issue.Text = "Total Book Remained: " + total;
if (total > 0)
{
btn_add_issue.Enabled = true;
tb_book_id_issue.Enabled = false;
btn_book_enter_issue.Enabled = false;
}
}
else
{
MessageBox.Show("No Book Found.");
}
}
else
{
MessageBox.Show("Please Enter Book Id.");
}
}
private void SearchBook(int id)
{
BookControls bookControls = new BookControls();
Book book = bookControls.SearchBook(id);
if (book != null)
{
tb_id_book.Text = book.Id.ToString().Trim();
tb_name_book.Text = book.Name;
tb_author_book.Text = book.Author;
cb_category_book.SelectedIndex = cb_category_book.FindStringExact(book.Category.Trim());
tb_stock_book.Text = book.Stock.ToString().Trim();
}
else
{
MessageBox.Show("No Book Found.");
}
}
public void SearchIssue(int id)
{
IssueControls issueControls = new IssueControls();
Issue issue = issueControls.SearchIssue(id);
if (issue != null)
{
string user_name = issue.UserName;
int book_id = issue.BookId;
UserControls userControls = new UserControls();
User user = userControls.SearchUser(user_name, "user");
BookControls bookControls = new BookControls();
Book book = bookControls.SearchBook(book_id);
if (user != null && book != null)
{
tb_issue_id_issue.Text = issue.Id.ToString().Trim();
tb_user_name_issue.Text = issue.UserName.Trim();
tb_book_id_issue.Text = issue.BookId.ToString().Trim();
cb_status_issue.SelectedIndex = cb_status_issue.FindStringExact(issue.Status.Trim());
dtp_issue_date_issue.Value = DateTime.ParseExact(issue.IssueDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
dtp_tobe_return_issue.Value = DateTime.ParseExact(issue.TobeRetunDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
if (issue.ReturnDate.Equals("nill"))
{
dtp_return_date_issue.Value = DateTime.Now;
}
else
{
dtp_return_date_issue.Value = DateTime.ParseExact(issue.ReturnDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
EnableViews();
cb_search_issue.SelectedIndex = cb_search_issue.FindStringExact("User");
gv_info_issue.DataSource = issueControls.LoadIssuesByUser(user_name);
}
else
{
MessageBox.Show("User or Book Doesn't Exist.");
}
}
else
{
MessageBox.Show("Issue Doesn't Exist.");
}
}
private void btn_delete_book_Click(object sender, EventArgs e)
{
string sid = tb_id_book.Text.ToString().Trim();
BookControls bookControls = new BookControls();
if (isValidString(sid))
{
int id = int.Parse(sid);
Book book = bookControls.SearchBook(id);
if (book != null)
{
bool isDeleted = bookControls.DeleteBook(id);
if (isDeleted)
{
if (cb_search_book.SelectedIndex == cb_search_book.FindStringExact(book.Category.Trim()))
{
LoadBooks();
}
else
{
cb_search_book.SelectedIndex = cb_search_book.FindStringExact(book.Category.Trim());
}
ClearViews();
MessageBox.Show("Book Deleted.");
}
else
{
MessageBox.Show("Book can not be Deleted.");
}
}
else
{
MessageBox.Show("Book Doesn't Exist.");
}
}
else
{
MessageBox.Show("Enter Book Id.");
}
}
private void LoadBooks()
{
BookControls bookControls = new BookControls();
gv_info_book.DataSource = bookControls.LoadBooks(cb_search_book.SelectedItem.ToString().Trim());
}
