protected async void btnAddBookAcept_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
lblError.Text = string.Empty;
serviceDAO service = new serviceDAO();
Book book = new Book();
book.IdAuthor = Int32.Parse(ddlAuthor.SelectedValue);
book.IdCategory = Int32.Parse(ddlCategory.SelectedValue);
book.ISBN = txtISBN.Text;
book.Title = txtTitle.Text;
book.Publisher = txtPublisher.Text;
service.AddBook(book);
ddlAuthor.SelectedValue = "0";
ddlCategory.SelectedValue = "0";
txtISBN.Text = txtTitle.Text = txtPublisher.Text = string.Empty;
await loadBooks(service, 0, 0);
ModalPopupExtender1.Hide();
}
catch (Exception Ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('An error has ocurred, please contact with your software provider');", true);
}
}
else
{
lblError.Text = "*All information is required";
ModalPopupExtender1.Show();
}
}
protected async void btnUpdate_Click(object sender, EventArgs e)
{
serviceDAO service = new serviceDAO();
try
{
if (btnUpdate.Text == "Add")
{
Category category = new Category();
category.Name = txtCategory.Text;
service.AddCategory(category);
await loadCategories(service, 0, 0);
txtCategory.Text = string.Empty;
}
else
{
List <Category> category = await service.GetCategory(Convert.ToInt32(lblIDHidden.Text));
category[0].Name = txtCategory.Text;
service.UpdateCategory(category[0]);
await loadCategories(service, 0, 0);
txtCategory.Text = string.Empty;
btnUpdate.Text = "Add";
}
}
catch (Exception Ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('An error has ocurred, please contact with your software provider');", true);
}
}
private async Task loadBooks(serviceDAO service, int init, int currentPage)
{
List <BookFull> books;
if (ddlAuthorsActives.SelectedValue == "0")
{
books = await service.GetAllBooksFull(0);
}
else
{
books = await service.GetAllBooksFull(Int32.Parse(ddlAuthorsActives.SelectedValue));
}
int fin = init + gvBooks.PageSize;
if (books != null && fin > books.Count)
{
fin = books.Count;
}
gvBooks.PageIndex = currentPage;
gvBooks.DataSource = books;
gvBooks.DataBind();
for (int i = init; i < fin; i++)
{
((ImageButton)gvBooks.Rows[i].Cells[6].Controls[0]).ImageUrl = "images/flags/" + books[i].Country + ".png";
((ImageButton)gvBooks.Rows[i].Cells[7].Controls[0]).Attributes.Add("OnClick", "if(!confirm('The entry will be deleted, are you sure?'))return false;");
}
}
private async Task loadAuthors(serviceDAO service, int init, int currentPage)
{
List <Author> authors = await service.GetAllAuthors();
int fin = init + gvAuthors.PageSize;
if (authors != null && fin > authors.Count)
{
fin = authors.Count;
}
gvAuthors.PageIndex = currentPage;
gvAuthors.DataSource = authors;
gvAuthors.DataBind();
for (int i = init; i < fin; i++)
{
List <Country> countries = await service.GetCountry(authors[i].IdCountry);
if (countries != null && countries.Count > 0)
{
((ImageButton)gvAuthors.Rows[i].Cells[3].Controls[0]).ImageUrl = "images/flags/" + countries[0].Code + ".png";
}
((ImageButton)gvAuthors.Rows[i].Cells[5].Controls[0]).Attributes.Add("OnClick", "if(!confirm('The entry will be deleted, are you sure?'))return false;");
}
}
protected async void gvCategories_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
serviceDAO service = new serviceDAO();
try
{
await loadCategories(service, (gvCategories.PageSize *e.NewPageIndex), e.NewPageIndex);
}
catch (Exception Ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('An error has ocurred, please contact with your software provider');", true);
}
}
private async Task loadAuthors(serviceDAO service)
{
List <Author> authors = await service.GetAllAuthors();
ddlAuthor.DataSource = authors;
ddlAuthor.DataValueField = "Id";
ddlAuthor.DataTextField = "Name";
ListItem selec = new ListItem("Select...", "0");
ddlAuthor.DataBind();
selec.Selected = true;
ddlAuthor.Items.Insert(0, selec);
}
private async Task loadCategories(serviceDAO service)
{
List <Category> category = await service.GetAllCategories();
ddlCategory.DataSource = category;
ddlCategory.DataValueField = "Id";
ddlCategory.DataTextField = "Name";
ListItem selec = new ListItem("Select...", "0");
ddlCategory.DataBind();
selec.Selected = true;
ddlCategory.Items.Insert(0, selec);
}
protected async void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
serviceDAO service = new serviceDAO();
try
{
await loadCategories(service, 0, 0);
}
catch (Exception Ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('An error has ocurred, please contact with your software provider');", true);
}
}
}
protected async void btnAddAuthor_Click(object sender, EventArgs e)
{
try
{
serviceDAO service = new serviceDAO();
if (Page.IsValid)
{
lblError.Text = string.Empty;
if (btnAddAuthor.Text == "Add")
{
Author author = new Author();
author.Name = txtAuthorName.Text;
author.LastName = txtAuthorLastName.Text;
author.IdCountry = Int32.Parse(ddlCountry.SelectedValue);
service.AddAuthor(author);
}
else
{
List <Author> author = await service.GetAuthor(Int32.Parse(lblIDAuthor.Text));
author[0].Name = txtAuthorName.Text;
author[0].LastName = txtAuthorLastName.Text;
author[0].IdCountry = Int32.Parse(ddlCountry.SelectedValue);
service.UpdateAuthor(author[0]);
await loadAuthors(service, 0, 0);
}
await loadAuthors(service, 0, 0);
txtAuthorName.Text = txtAuthorLastName.Text = string.Empty;
ddlCountry.SelectedValue = "0";
btnAddAuthor.Text = "Add";
}
else
{
lblError.Text = "*All information is required";
ModalPopupExtender1.Show();
}
}
catch (Exception Ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('An error has ocurred, please contact with your software provider');", true);
}
}
protected async void gvBooks_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "eliminar")
{
serviceDAO service = new serviceDAO();
try
{
List <Book> book = await service.GetBook(Convert.ToInt32(gvBooks.Rows[Convert.ToInt32(e.CommandArgument)].Cells[0].Text));
service.DeleteBook(book[0]);
await loadBooks(service, 0, 0);
}
catch (Exception Ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('An error has ocurred, please contact with your software provider');", true);
}
}
}
private async Task loadCategories(serviceDAO service, int init, int currentPage)
{
List <Category> categorias = await service.GetAllCategories();
int fin = init + gvCategories.PageSize;
if (categorias != null && fin > categorias.Count)
{
fin = categorias.Count;
}
gvCategories.PageIndex = currentPage;
gvCategories.DataSource = categorias;
gvCategories.DataBind();
for (int i = init; i < fin; i++)
{
((ImageButton)gvCategories.Rows[i].Cells[3].Controls[0]).Attributes.Add("OnClick", "if(!confirm('The entry will be deleted, are you sure?'))return false;");
}
}
protected async void gvAuthors_RowCommand(object sender, GridViewCommandEventArgs e)
{
serviceDAO service = new serviceDAO();
try
{
List <Author> author = await service.GetAuthor(Convert.ToInt32(gvAuthors.Rows[Convert.ToInt32(e.CommandArgument)].Cells[0].Text));
if (author != null && author.Count > 0)
{
if (e.CommandName == "editar")
{
ModalPopupExtender1.Show();
List <Author> authors = await service.GetAuthor(author[0].Id);
lblIDAuthor.Text = authors[0].Id.ToString();
txtAuthorName.Text = authors[0].Name;
txtAuthorLastName.Text = authors[0].LastName;
ddlCountry.SelectedValue = authors[0].IdCountry.ToString();
btnAddAuthor.Text = "Update";
}
else if (e.CommandName == "eliminar")
{
List <Book> bookAssignments = await service.GetAssignmentsAuthors(Convert.ToInt32(gvAuthors.Rows[Convert.ToInt32(e.CommandArgument)].Cells[0].Text));
if (bookAssignments != null && bookAssignments.Count > 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('Invalid operation, The item is assigned to one or more books');", true);
}
else
{
service.DeleteAuthor(author[0]);
await loadAuthors(service, 0, 0);
}
}
}
}
catch (Exception Ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('An error has ocurred, please contact with your software provider');", true);
}
}
private async Task loadAuthorsActives(serviceDAO service)
{
List <BookFull> books = await service.GetAllBooksFull(0);
foreach (BookFull bf in books)
{
ListItem item = new ListItem();
item.Text = bf.Author;
item.Value = bf.IdAuthor.ToString();
if (ddlAuthorsActives.Items.FindByValue(item.Value) == null)
{
ddlAuthorsActives.Items.Add(item);
}
}
ListItem selec = new ListItem("All", "0");
ddlAuthorsActives.DataBind();
selec.Selected = true;
ddlAuthorsActives.Items.Insert(0, selec);
}
protected async void ddlAuthorsActives_SelectedIndexChanged(object sender, EventArgs e)
{
serviceDAO service = new serviceDAO();
List <BookFull> books;
if (ddlAuthorsActives.SelectedValue == "0")
{
books = await service.GetAllBooksFull(0);
}
else
{
books = await service.GetAllBooksFull(Int32.Parse(ddlAuthorsActives.SelectedValue));
}
gvBooks.DataSource = books;
gvBooks.DataBind();
for (int i = 0; i < gvBooks.Rows.Count; i++)
{
((ImageButton)gvBooks.Rows[i].Cells[6].Controls[0]).ImageUrl = "images/flags/" + books[i].Country + ".png";
((ImageButton)gvBooks.Rows[i].Cells[7].Controls[0]).Attributes.Add("OnClick", "if(!confirm('The entry will be deleted, are you sure?'))return false;");
}
}
protected async void gvCategories_RowCommand(object sender, GridViewCommandEventArgs e)
{
serviceDAO service = new serviceDAO();
try
{
List <Category> category = await service.GetCategory(Convert.ToInt32(gvCategories.Rows[Convert.ToInt32(e.CommandArgument)].Cells[0].Text));
if (category != null && category.Count > 0)
{
if (e.CommandName == "editar")
{
txtCategory.Text = category[0].Name;
btnUpdate.Text = "Update";
lblIDHidden.Text = category[0].Id.ToString();
}
else if (e.CommandName == "eliminar")
{
List <Book> bookAssignments = await service.GetAssignmentsCategories(Convert.ToInt32(gvCategories.Rows[Convert.ToInt32(e.CommandArgument)].Cells[0].Text));
if (bookAssignments != null && bookAssignments.Count > 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('Invalid operation, The item is assigned to one or more books');", true);
}
else
{
service.DeleteCategory(category[0]);
await loadCategories(service, 0, 0);
}
}
}
}
catch (Exception Ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "alert('An error has ocurred, please contact with your software provider');", true);
}
}
