protected void ButInsert_Click(object sender, EventArgs e)
{
// Set book
Books book = new Books();
book.Title = boxTitle.Text;
book.Author = boxAuthor.Text;
book.SectionId = Convert.ToInt32(ddlSection.SelectedValue);
book.Ibsn = Convert.ToInt32(boxIbsn.Text);
// Set Copy
Copy copy = new Copy();
DateTime renewD = DateTime.ParseExact(boxRenewal.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
copy.RenewalDate = renewD;
DateTime purchaseD = DateTime.ParseExact(boxPurchase.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
copy.PurchaseDate = purchaseD;
// Set the number of copies
int numberCopies = Convert.ToInt32(boxCopies.Text);
// Insert Book and go the list page
int bookId = BBooks.insert(book, copy, numberCopies);
Response.Redirect("~/Book/MainList.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// Get the index of the book to update
index = Convert.ToInt32(Request.QueryString["bookId"]);
// Get the record and save it in viewstate
bookToUpdate = BBooks.getById(index);
ViewState["bookToUpdate"] = bookToUpdate;
// Load Section dropDownList
ddlSection.DataSource = BSection.getAll();
ddlSection.DataTextField = "Name";
ddlSection.DataValueField = "SectionId";
ddlSection.DataBind();
// Fill the textBoxes
boxTitle.Text = bookToUpdate.Title;
boxAuthor.Text = bookToUpdate.Author;
ddlSection.SelectedValue = bookToUpdate.SectionId.ToString();
boxIbsn.Enabled = false;
boxIbsn.Text = bookToUpdate.Ibsn.ToString();
}
}
protected void filterBySectionAndCopy()
{
// 1.- Get latest datasource
allBooks = (List <BookDTO>)ViewState["allBooks"];
// 2.- Filter by Section and fill Grid
if (DropDownSection.SelectedValue != "-1")
{
allBooks = BBooks.getBookDTOBySection(allBooks, DropDownSection.SelectedItem.Text);
}
// 3.- Filter by copy and fill Grid
if (DropDownCopies.SelectedValue != "-1")
{
allBooks = BBooks.getBookDTOByCopies(allBooks, Convert.ToInt32(DropDownCopies.SelectedValue));
}
// 5.- Filter by author or title
allBooks = BBooks.getBookDTOByAuthorOrTitle(allBooks, TextBoxSearch.Text);
// 4.- Fill Grid and save it in viewState
ViewState["filterBooks"] = allBooks;
GridMainList.DataSource = allBooks;
GridMainList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
// Fill the grid
List <BookDTO> allBooks = new List <BookDTO>();
allBooks = BBooks.getBookDTOAll();
GridUpdateList.DataSource = allBooks;
GridUpdateList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
// Fill the grid
List <Books> allBooks = new List <Books>();
allBooks = BBooks.getAll();
gridBookList.DataSource = allBooks;
gridBookList.DataBind();
// Insert Books
Books book = new Books();
}
protected void ButUpdate_Click(object sender, EventArgs e)
{
// Gets record to update
bookToUpdate = (Books)ViewState["bookToUpdate"];
// Modify record
bookToUpdate.Title = boxTitle.Text;
bookToUpdate.Author = boxAuthor.Text;
bookToUpdate.SectionId = Convert.ToInt32(ddlSection.SelectedValue);
// Update record and goes to MainList.aspx
BBooks.update(bookToUpdate);
Response.Redirect("~/Book/MainList.aspx");
}
protected void buttonInsertBook_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// Insert books
Books book = new Books();
book.Title = boxTitle.Text;
book.Author = boxAuthor.Text;
book.SectionId = Convert.ToInt32(boxSection.Text);
BBooks.insert(book);
Response.Redirect("~/ListBooks.aspx");
}
}
protected void boxIbsn_TextChanged(object sender, EventArgs e)
{
// Enable Fields
boxTitle.Enabled = true;
//boxTitle.Text = "";
boxAuthor.Enabled = true;
//boxAuthor.Text = "";
ddlSection.Enabled = true;
// Validate text field
literalIbsn.Text = "";
int value;
if (!int.TryParse(boxIbsn.Text, out value))
{
literalIbsn.Text = writeDigitsLabel();
}
// If textBox contains data and is a number it does the logic
if (!string.IsNullOrEmpty(boxIbsn.Text) && int.TryParse(boxIbsn.Text, out value))
{
int ibsnToCheck = Convert.ToInt32(boxIbsn.Text);
int bookId = BBooks.ibsnExist(ibsnToCheck);
// If ibsn exist, some controls are filled and ibsn is blocked
if (bookId > 0)
{
// Get the book record
Books book = new Books();
book = BBooks.getById(bookId);
// Book: Fill fields and diable them
boxTitle.Enabled = false;
boxTitle.Text = book.Title;
boxAuthor.Enabled = false;
boxAuthor.Text = book.Author;
ddlSection.Enabled = false;
ddlSection.SelectedValue = book.SectionId.ToString();
}
}
}
protected void ButDelete_Click(object sender, EventArgs e)
{
changeColorTextBox();
// Get record from viewstate
bookToUpdate = (Books)ViewState["bookToUpdate"];
// Delete record in COPIES kand goes to DeleteList.aspx
try
{
BBooks.deleteAllCopiesById(bookToUpdate.BookId);
Response.Redirect("~/Book/MainList.aspx");
}
catch (Exception generalException)
{
PanelDeleteBook.Visible = true;
LiteralDeleteBook.Text = generalException.Message;
}
}
public void AddBook(Book b)
{
BBooks.Add(b);
}
