// <summary>
/// Description : Loads All Publisher list from Latest_Posted_BookProduct_View.
/// Stored Procedure : USP_Common_BookProduct_Load_AllPublisher
/// Associate Control: Executes in Page_Load event.
/// </summary>
private void LoadList_All_Publisher()
{
using (BC_Publisher objbcPublisher = new BC_Publisher())
{
DataTable dtPublisher = null;
try
{
dtPublisher = objbcPublisher.LoadList_All_Publisher(intCountryID, intSubcategoryID);
if (dtPublisher.Rows.Count > 0)
{
grvAllPublisher.DataSource = dtPublisher;
grvAllPublisher.DataBind();
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
}
/// <summary>
/// Loads Latest posted Booklist in the Middle page gridview by Publisher name.
/// USP: USP_Common_ItemListBook_ShowLatestPostedBookList_ByPublisher.sql
/// </summary>
/// <param name="intCountryID"></param>
/// <param name="intSecondSubcatID"></param>
private void LoadList_LatestPosted_BookProduct_ByPublisher(int intCountryID, int intSubcategoryID, string publisher)
{
dtBookList = new DataTable();
try
{
using (BC_Publisher bcPublisher = new BC_Publisher())
{
dtBookList = bcPublisher.LoadList_LatestPosted_BookProduct_ByPublisher(intCountryID, intSubcategoryID, publisher);
if (dtBookList.Rows.Count > 0)
{
grvItemList.DataSource = dtBookList;
grvItemList.DataBind();
}
}
}
catch (Exception ex)
{
lblSystemMessage.Text = ex.Message;
}
}
// <summary>
/// Description : Loads Top 10 Publisher list from Latest_Posted_BookProduct_View.
/// Stored Procedure : USP_Common_BookProduct_Load_AllPublisher
/// Associate Control: Executes in Page_Load event.
/// </summary>
private void LoadList_Top10_Publisher()
{
DataTable dtSecondSubcategory = null;
try
{
using (BC_Publisher objcPublisher = new BC_Publisher())
{
dtSecondSubcategory = objcPublisher.LoadList_Top10_Publisher(intCountryID, intSubcategoryID);
if (dtSecondSubcategory.Rows.Count > 0)
{
grvTopPublisher.DataSource = dtSecondSubcategory;
grvTopPublisher.DataBind();
}
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}