private void BindBookRecordsGridView() { DataSet ds = new DataSet(); try { ds = objBookDetailsBLL.GetBookRecords(); if (ds.Tables[0].Rows.Count > 0) { grdBookDetails.DataSource = ds; grdBookDetails.DataBind(); } else { grdBookDetails.DataSource = null; grdBookDetails.DataBind(); } } catch (Exception ex) { Response.Write("Oops! error occured:" + ex.Message.ToString()); } finally { objBookDetailsBEL = null; objBookDetailsBLL = null; } }
protected void grdBookDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { int Book_Id = Convert.ToInt32(grdBookDetails.DataKeys[e.RowIndex].Value); objBookDetailsBEL.BookId = Book_Id; try { int retVal = objBookDetailsBLL.DeleteBookRecord(objBookDetailsBEL); if (retVal > 0) { lblStatus.Text = "Book detail deleted successfully"; lblStatus.ForeColor = System.Drawing.Color.Green; ClearControls(); BindBookRecordsGridView(); } else { lblStatus.Text = "Book details couldn't be deleted"; lblStatus.ForeColor = System.Drawing.Color.Red; } } catch (Exception ex) { Response.Write("Oops! error occured:" + ex.Message.ToString()); } finally { objBookDetailsBEL = null; objBookDetailsBLL = null; } }
protected void btnSubmit_Click(object sender, EventArgs e) { objBookDetailsBEL.BookName = txtBookName.Text.Trim(); objBookDetailsBEL.Author = txtAuthor.Text.Trim(); objBookDetailsBEL.Publisher = txtPublisher.Text.Trim(); objBookDetailsBEL.Price = Convert.ToDecimal(txtPrice.Text); try { int retVal = objBookDetailsBLL.SaveBookDetails(objBookDetailsBEL); if (retVal > 0) { lblStatus.Text = "Book detail saved successfully"; lblStatus.ForeColor = System.Drawing.Color.Green; ClearControls(); BindBookRecordsGridView(); } else { lblStatus.Text = "Book details couldn't be saved"; lblStatus.ForeColor = System.Drawing.Color.Red; } } catch (Exception ex) { Response.Write("Oops! error occured:" + ex.Message.ToString()); } finally { objBookDetailsBEL = null; objBookDetailsBLL = null; } }
protected void grdBookDetails_RowUpdating(object sender, GridViewUpdateEventArgs e) { objBookDetailsBEL.BookId = Convert.ToInt32(grdBookDetails.DataKeys[e.RowIndex].Value); objBookDetailsBEL.BookName = ((TextBox)(grdBookDetails.Rows[e.RowIndex].FindControl("txtBookNameEdit"))).Text.Trim(); objBookDetailsBEL.Author = ((TextBox)(grdBookDetails.Rows[e.RowIndex].FindControl("txtAuthorEdit"))).Text.Trim(); objBookDetailsBEL.Publisher = ((TextBox)(grdBookDetails.Rows[e.RowIndex].FindControl("txtPublisherEdit"))).Text.Trim(); objBookDetailsBEL.Price = Convert.ToDecimal(((TextBox)(grdBookDetails.Rows[e.RowIndex].FindControl("txtPriceEdit"))).Text.Trim()); try { int retVal = objBookDetailsBLL.UpdateBookRecord(objBookDetailsBEL); if (retVal > 0) { lblStatus.Text = "Book detail updated successfully"; lblStatus.ForeColor = System.Drawing.Color.Green; ClearControls(); grdBookDetails.EditIndex = -1; BindBookRecordsGridView(); } else { lblStatus.Text = "Book details couldn't be updated"; lblStatus.ForeColor = System.Drawing.Color.Red; } } catch (Exception ex) { Response.Write("Oops! error occured:" + ex.Message.ToString()); } finally { objBookDetailsBEL = null; objBookDetailsBLL = null; } }