/// <summary>
 /// Loads Latest posted Book list by Auhtor name.
 /// USP: USP_Common_ItemListBook_ShowLatestPostedBookList_ByAuthor
 /// </summary>
 /// <param name="author"></param>
 /// <param name="country"></param>
 /// <returns></returns>
 private void LoadList_LatestPosted_BookProduct_ByAuthor(string author, int country, int intSubcategory)
 {
     dtBookList = new DataTable();
     try
     {
         using (BC_Author bcAuthor = new BC_Author())
         {
             dtBookList = bcAuthor.LoadList_LatestPosted_BookProduct_ByAuthor(author, country, intSubcategoryID);
             if (dtBookList.Rows.Count > 0)
             {
                 grvItemList.DataSource = dtBookList;
                 grvItemList.DataBind();
             }
         }
     }
     catch (Exception ex)
     {
         lblSystemMessage.Text = ex.Message;
     }
 }
    // <summary>
    /// Description      : Loads Lists of all Authors.
    /// Stored Procedure : USP_Common_BookProduct_Load_AllAuthor
    /// Associate Control: Executes in Page_Load event.
    /// </summary>
    private void LoadList_All_Author()
    {
        DataTable dtAuthor = null;

        try
        {
            using (BC_Author objbcAuthor = new BC_Author())
            {
                dtAuthor = objbcAuthor.LoadList_All_Author(intCountryID, intSubcategoryID);
                if (dtAuthor.Rows.Count > 0)
                {
                    grvAllAuthor.DataSource = dtAuthor;
                    grvAllAuthor.DataBind();
                }
            }
        }
        catch (Exception ex)
        {
            Response.Write("Error: " + ex.Message);
        }
    }
    // <summary>
    /// Description      : Loads Lists of Top 10 Authors.
    /// Stored Procedure : USP_Common_BookProduct_Load_Top10Author
    /// Associate Control: Executes in Page_Load event.
    /// </summary>
    private void LoadList_Top10_Author()
    {
        DataTable dtAuthor = null;

        intCountryID = Convert.ToInt32(selectedLocation);
        try
        {
            using (BC_Author objbcAuthor = new BC_Author())
            {
                dtAuthor = objbcAuthor.LoadList_Top10_Author(intCountryID, intSubcategoryID);
                if (dtAuthor.Rows.Count > 0)
                {
                    grvTopAuthor.DataSource = dtAuthor;
                    grvTopAuthor.DataBind();
                }
            }
        }
        catch (Exception ex)
        {
            Response.Write("Error: " + ex.Message);
        }
    }