private void BindGrid()
{
AuthorManager manager = new AuthorImpXMLManager();
GridView1.DataSource = manager.FindAll();
GridView1.DataBind();
}
private void FillComboBox(GridViewRowEventArgs e)
{
EditorialManager managerEditorial = new EditorialImpXMLManager();
AuthorManager managerAuthor = new AuthorImpXMLManager();
GenreManager managerGenre = new GenreImpXMLManager();
DropDownList AuthorDrop = (DropDownList)e.Row.FindControl("AuthorDropDown");
DropDownList GenreDrop = (DropDownList)e.Row.FindControl("GenreDropDown");
DropDownList EditorialDrop = (DropDownList)e.Row.FindControl("EditorialDropDown");
if (AuthorDrop != null)
{
AuthorDrop.DataSource = managerAuthor.FindAll();
AuthorDrop.DataTextField = "Name";
AuthorDrop.DataValueField = "Id";
AuthorDrop.DataBind();
}
if (GenreDrop != null)
{
GenreDrop.DataSource = managerGenre.FindAll();
GenreDrop.DataTextField = "Description";
GenreDrop.DataValueField = "Id";
GenreDrop.DataBind();
}
if (EditorialDrop != null)
{
EditorialDrop.DataSource = managerEditorial.FindAll();
EditorialDrop.DataTextField = "Name";
EditorialDrop.DataValueField = "Id";
EditorialDrop.DataBind();
}
dpGenre.DataSource = managerGenre.FindAll();
dpGenre.DataTextField = "Description";
dpGenre.DataValueField = "Id";
dpGenre.DataBind();
dpEditorial.DataSource = managerEditorial.FindAll();
dpEditorial.DataTextField = "Name";
dpEditorial.DataValueField = "Id";
dpEditorial.DataBind();
dpAuthor.DataSource = managerAuthor.FindAll();
dpAuthor.DataTextField = "Name";
dpAuthor.DataValueField = "Id";
dpAuthor.DataBind();
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int authorId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
AuthorManager manager = new AuthorImpXMLManager();
Author author = new Author();
string date = Request.Form["txtBirthdate"];
author.Id = authorId;
author.Name = (row.FindControl("txtName") as TextBox).Text;
author.LastName = (row.FindControl("txtLastName") as TextBox).Text;
author.BirthDate = Convert.ToDateTime(date);
manager.Update(authorId, author);
GridView1.EditIndex = -1;
this.BindGrid();
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int authorId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
AuthorManager manager = new AuthorImpXMLManager();
Author author = manager.FindOne(authorId);
manager.Delete(author);
this.BindGrid();
}
catch (Exception)
{
Response.Redirect("AuthorsInfo.aspx");
}
}
protected void Insert(object sender, EventArgs e)
{
if (!(String.IsNullOrWhiteSpace(txtName.Text) && String.IsNullOrWhiteSpace(txtISBN.Text)))
{
BookManager manager = new BookImpXMLManager();
EditorialManager managerEditorial = new EditorialImpXMLManager();
AuthorManager managerAuthor = new AuthorImpXMLManager();
GenreManager managerGenre = new GenreImpXMLManager();
Book book = new Book();
try
{
book.Author_Id = Convert.ToInt32(dpAuthor.SelectedItem.Value);
book.Name = txtName.Text;
book.ISBN = txtISBN.Text;
book.Published_Date = Convert.ToDateTime(Request.Form["date"].ToString());
book.Editorial_Id = Convert.ToInt32(dpEditorial.SelectedItem.Value);
book.Genre_Id = Convert.ToInt32(dpGenre.SelectedItem.Value);
book.Genre = managerGenre.FindOne(Convert.ToInt32(dpGenre.SelectedItem.Value));
book.Editorial = managerEditorial.FindOne(Convert.ToInt32(dpEditorial.SelectedItem.Value));
book.Author = managerAuthor.FindOne(Convert.ToInt32(dpAuthor.SelectedItem.Value));
manager.Add(book);
}
catch (Exception exception)
{
Response.Redirect("BookView.aspx");
}
errorMe.Text = "";
}
else
{
errorMe.Text = "NO se pueden dejar campos vacios";
}
this.BindGrid();
}
