protected void DisplayQueries()
    {
        BloodBL           bl     = new BloodBL();
        List <RaiseQuery> rqList = bl.GetAllQueries();

        GridViewResolveQueries.DataSource = rqList;
        GridViewResolveQueries.DataBind();
    }
    protected void ResolvedButtonActive(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.Equals("Resolved"))
        {
            int     rowIndex = Convert.ToInt32(e.CommandArgument);
            int     id       = int.Parse(GridViewResolveQueries.Rows[rowIndex].Cells[0].Text);
            BloodBL bl       = new BloodBL();

            string  solution1       = GridViewResolveQueries.Rows[rowIndex].Cells[4].Text;
            TextBox solutionTextBox = (TextBox)GridViewResolveQueries.FindControl("txtSolution");
            //Response.Write("<script>alert('"+solution1+"');</script>");
            //Response.Write("<script>alert('" + solutionTextBox.Text + "');</script>");
            //if (bl.UpdateQuery("Resolved", solution1, id) == 1)
            if (bl.UpdateQuery("Resolved", "yet to solve", id) == 1)
            {
                Response.Write("<script>alert('Query Updated Successfully');</script>");
            }
            else
            {
                Response.Write("<script>alert('Error in Query Updating');</script>");
            }
            DisplayQueries();
        }
    }