void GetBookById()
{
try
{
SqlConnection con = new SqlConnection(Strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("SELECT * from Book where BookId='" + TxtBookId.Text.Trim() + "';", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count >= 1)
{
TxtBookName.Text = dt.Rows[0]["BookName"].ToString();
TxtPublishDate.Text = dt.Rows[0]["PublishDate"].ToString();
TxtEdition.Text = dt.Rows[0]["Edition"].ToString();
TxtBookCost.Text = dt.Rows[0]["BookCost"].ToString().Trim();
TxtPages.Text = dt.Rows[0]["NoofPages"].ToString().Trim();
TxtActualStock.Text = dt.Rows[0]["ActualStock"].ToString().Trim();
TxtCurrentStock.Text = dt.Rows[0]["CurrentStock"].ToString().Trim();
TxtBookDescription.Text = dt.Rows[0]["BookDesc"].ToString();
TxtIssuedbooks.Text = "" + (Convert.ToInt32(dt.Rows[0]["ActualStock"].ToString()) - Convert.ToInt32(dt.Rows[0]["CurrentStock"].ToString()));
DPLLanguage.SelectedValue = dt.Rows[0]["Language"].ToString().Trim();
DPLPublisherName.SelectedValue = dt.Rows[0]["PublisherName"].ToString().Trim();
DPLAuthorName.SelectedValue = dt.Rows[0]["AuthorName"].ToString().Trim();
ListBGenre.ClearSelection();
string[] genre = dt.Rows[0]["genre"].ToString().Trim().Split(',');
for (int i = 0; i < genre.Length; i++)
{
for (int j = 0; j < ListBGenre.Items.Count; j++)
{
if (ListBGenre.Items[j].ToString() == genre[i])
{
ListBGenre.Items[j].Selected = true;
}
}
}
GlobalActualStock = Convert.ToInt32(dt.Rows[0]["ActualStock"].ToString().Trim());
GlobalCurrentStock = Convert.ToInt32(dt.Rows[0]["CurrentStock"].ToString().Trim());
GlobaIssuedBooks = GlobalActualStock - GlobalCurrentStock;
GlobalFilepath = dt.Rows[0]["BookImgLink"].ToString();
}
else
{
Response.Write("<script>alert('Invalid book Id');</script>");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}
