/// <summary>
/// Loads Specific Category and SubcategoryItems of a selected Province.
/// </summary>
private void LoadList_ProvinceItems_BySubcategory()
{
try
{
using (BC_Classifieds_Item bcClassified = new BC_Classifieds_Item())
{
dtProductList = bcClassified.LoadList_Province_ClassifiedItems_BySubcategory(CategoryID, SubcategoryID, intProvinceID);
//FilterNo = Filter.ByLocationSubcategory.ToString();
FilterType = Filter.ByLocationCategory;
if (dtProductList.Rows.Count > 0)
{
this.InitializeGridView(dtProductList);
}
else
{
this.EmptyGridView();
}
}
}
catch (Exception exp)
{
lblSystemMessage.Text = exp.Message;
}
}
/// <summary>
/// Loads all Province with Number of Posted Classified items Posted For Specific Classified Category.
/// </summary>
private void LoadList_CL_Items_ByProvince(int intCategoryID)
{
try
{
using (BC_Classifieds_Item bcClassifiedItems = new BC_Classifieds_Item())
{
DataTable dtClassified = bcClassifiedItems.LoadList_CL_Items_ByProvince(intCategoryID);
if (dtClassified.Rows.Count > 0)
{
dlstProvince.DataSource = dtClassified;
dlstProvince.DataBind();
}
else
{
dlstProvince.DataSource = null;
dlstProvince.DataBind();
this.Visible = false;
}
}
}
catch (Exception Exp)
{
Response.Write(Exp.Message.ToString());
}
}
/// <summary>
/// Loads Negotiable Classified Items By their Subcategory.
/// </summary>
/// <param name="intProvinceID"></param>
/// <param name="intCategoryID"></param>
private void LoadList_Negotiable_ClassifiedItems_BySubcategory()
{
try
{
using (BC_Classifieds_Item bcClassified = new BC_Classifieds_Item())
{
SubcategoryID = Convert.ToInt32(SubcategoryID);
dtProductList = bcClassified.LoadList_Negotiable_ClassifiedItems_BySubcategory(CategoryID, SubcategoryID);
//FilterNo = Filter.ByNegotiableSubcategory.ToString();
FilterType = Filter.ByNegotiableSubcategory;
if (dtProductList.Rows.Count > 0)
{
this.InitializeGridView(dtProductList);
}
else
{
//grvItemList.DataSource = null;
//grvItemList.DataBind();
this.EmptyGridView();
}
}
}
catch (Exception exp)
{
lblSystemMessage.Text = exp.Message;
}
}
/// <summary>
/// Loads All items of specific Category Under Specific Province And Specific Area.
/// </summary>
/// <param name="intAreaID"></param>
/// <param name="intCategoryID"></param>
private void LoadList_ClassifiedItems_ByProvince_Category_Area(int intAreaID, int intCategoryID)
{
try
{
using (BC_Classifieds_Item bcClassified = new BC_Classifieds_Item())
{
dtProductList = bcClassified.LoadList_Classified_Items_By_Province_Area_Category(intAreaID, intCategoryID);
//FilterNo = Filter.ByArea.ToString();
FilterType = Filter.ByArea;
if (dtProductList.Rows.Count > 0)
{
this.InitializeGridView(dtProductList);
}
else
{
this.EmptyGridView();
}
}
}
catch (Exception exp)
{
lblSystemMessage.Text = exp.Message;
}
}
/// <summary>
/// Loads all the Area name inside Dhaka.
/// </summary>
private void LoadList_DhakaArea()
{
int DhakaProvinceID = 18;
try
{
using (BC_Classifieds_Item bcClassified = new BC_Classifieds_Item())
{
DataTable dt = bcClassified.LoadList_CL_Dhaka_Area(DhakaProvinceID);
if (dt.Rows.Count > 0)
{
ddlLocation.Items.Clear();
ddlLocation.Items.Add(new ListItem("Select Area", "-1"));
ddlLocation.DataSource = dt;
ddlLocation.DataValueField = "AreaID";
ddlLocation.DataTextField = "Area";
ddlLocation.DataBind();
}
}
}
catch (Exception Exp)
{
lblSystemMessage.Text = Exp.Message.ToString();
}
}
/// <summary>
/// Loads all Classified Category with Number of items posted in that Category.
/// USP: USP_Classified_LeftMenu_LoadAllCategory_WithNoOf_Items
/// </summary>
private void LoadList_ClassifiedCategory_WithNoOf_Items()
{
try
{
using (BC_Classifieds_Item bcClassifiedItems = new BC_Classifieds_Item())
{
DataTable dtClassified = bcClassifiedItems.LoadList_ClassifiedCategory_WithNoOf_Items("bangladesh");
if (dtClassified.Rows.Count > 0)
{
grvCategory.DataSource = dtClassified;
grvCategory.DataBind();
}
}
}
catch (Exception Exp)
{
lblSystemMessage.Text = Exp.Message.ToString();
}
}
/// <summary>
/// Loads all Province with Number of Posted Classified items Posted For All Classified Category.
/// </summary>
private void LoadList_CL_Items_AllProvince(string strCountry)
{
try
{
using (BC_Classifieds_Item bcClassifiedItems = new BC_Classifieds_Item())
{
dtClassified = bcClassifiedItems.LoadList_CL_Items_AllProvince(strCountry);
if (dtClassified.Rows.Count > 0)
{
dlst.DataSource = dtClassified;
dlst.DataBind();
}
}
}
catch (Exception Exp)
{
lblSystemMessage.Text = Exp.Message.ToString();
}
}
private void LoadList_Classified_Housing_WithNoOf_Items(string _Country, int _SubcategoryID)
{
try
{
using (BC_Classifieds_Item bcClassifiedItems = new BC_Classifieds_Item())
{
DataTable dtClassified = bcClassifiedItems.LoadList_Classified_Housing_WithNoOf_Items(_Country, _SubcategoryID);
if (dtClassified.Rows.Count > 0)
{
NoOfItems = dtClassified.Rows[0]["NoOfItems"].ToString();
ImageClassName = dtClassified.Rows[0]["ImageClassName"].ToString();
Country = dtClassified.Rows[0]["Country"].ToString();
}
}
}
catch (Exception Exp)
{
lblSystemMessage.Text = Exp.Message.ToString();
}
}
///// <summary>
///// Loads only Classified Category
///// </summary>
//private void LoadRecord_ClassifiedCategory()
//{
// try
// {
// using (BOC_Classifieds_ProductProfile bocProductProfile = new BOC_Classifieds_ProductProfile())
// {
// EOC_PropertyBean eocPropertyBean = new EOC_PropertyBean();
// eocPropertyBean.Country_CountryID = intCountryID;
// ddlCategory.Items.Clear();
// ddlCategory.Items.Add(new ListItem("All Category", "-1"));
// DataTable dtCategory = bocProductProfile.LoadRecord_ClassifiedCategory(eocPropertyBean);
// if (dtCategory.Rows.Count > 0)
// {
// ddlCategory.DataSource = dtCategory;
// ddlCategory.DataValueField = "CategoryID";
// ddlCategory.DataTextField = "Category";
// ddlCategory.DataBind();
// }
// else
// {
// lblSystemMessage.Text = "No category found.";
// }
// }
// }
// catch (Exception Exp)
// {
// lblSystemMessage.Text = Exp.Message.ToString();
// }
//}
/// <summary>
/// Loads Number of Negotiable Classified Items.
/// </summary>
private void LoadNumberOf_NegotiableItems()
{
try
{
using (BC_Classifieds_Item bcClassifiedItems = new BC_Classifieds_Item())
{
dtClassified = bcClassifiedItems.LoadNumberOf_NegotiableItems(Convert.ToInt32(CategoryID));
if (dtClassified.Rows.Count > 0)
{
repNegotiable.DataSource = dtClassified;
repNegotiable.DataBind();
}
else
{
NumberOfNegotiableItems = 0;
}
}
}
catch (Exception Exp)
{
lblSystemMessage.Text = Exp.Message.ToString();
}
}
