protected void btnDelete_Click(object sender, EventArgs e)
 {
     try
     {
         clsIssuerDetails obj = new clsIssuerDetails();
         if (obj.UpDelIssuer(issuerid, txtfname.Text, txtlname.Text, txtPhoneno.Text, txtEmail.Text, txtAddress.Text, txtCity.Text, txtState.Text) > 0)
         {
             lblMessage.Text = "updated successfully";
         }
         else
         {
             lblMessage.Text = "request failed";
         }
     }
     catch (Exception ex)
     {
         lblMessage.Text = ex.Message;
     }
 }
    public void GetData()
    {
        Session["IId"] = Session["IssuerId"];
        issuerid       = Convert.ToInt32(Session["IId"]);
        if (issuerid == 0)
        {
            return;
        }
        clsIssuerDetails obj = new clsIssuerDetails();
        DataSet          ds  = obj.GetIssuer(issuerid);

        txtfname.Text   = ds.Tables[0].Rows[0]["FirstName"].ToString();
        txtlname.Text   = ds.Tables[0].Rows[0]["LastName"].ToString();
        txtPhoneno.Text = ds.Tables[0].Rows[0]["PhoneNo"].ToString();
        txtEmail.Text   = ds.Tables[0].Rows[0]["Email"].ToString();
        txtAddress.Text = ds.Tables[0].Rows[0]["Address"].ToString();
        txtCity.Text    = ds.Tables[0].Rows[0]["City"].ToString();
        txtState.Text   = ds.Tables[0].Rows[0]["State"].ToString();
    }