private void PopulateDataGrid()
{
// Hide Controls
this.dvEmptyContent.Visible = false;
this.dvDataContent.Visible = false;
this.dvNoSearchResult.Visible = false;
// Search text
string searchText = this.txtSearch.Text.ToLower().Trim();
// Populate Items
DistributorPriceMarkupBO objPriceMarckup = new DistributorPriceMarkupBO();
LabelPriceMarkupBO objLabelPriceMarkup = new LabelPriceMarkupBO();
List <IGrouping <int, DistributorPriceMarkupBO> > lstPriceMarckups = new List <IGrouping <int, DistributorPriceMarkupBO> >();
List <IGrouping <int, LabelPriceMarkupBO> > lstLabelPriceMarkups = new List <IGrouping <int, LabelPriceMarkupBO> >();
if ((searchText != string.Empty) && (searchText != "search"))
{
lstPriceMarckups = (from o in objPriceMarckup.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList()
where o.Distributor != 0 && o.objDistributor.Name.ToLower().Contains(searchText)
orderby(int) o.Distributor
group o by(int) o.Distributor into g
select g).ToList();
lstLabelPriceMarkups = (from o in objLabelPriceMarkup.SearchObjects().AsQueryable().ToList()
where o.Label != 0 && o.objLabel.Name.ToLower().Contains(searchText)
orderby(int) o.Label
group o by(int) o.Label into g
select g).ToList();
}
else
{
lstPriceMarckups = (from o in objPriceMarckup.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList()
orderby(int) o.Distributor
group o by(int) o.Distributor into g
select g).ToList();
lstLabelPriceMarkups = (from o in objLabelPriceMarkup.SearchObjects().AsQueryable().ToList()
orderby(int) o.Label
group o by(int) o.Label into g
select g).ToList();
}
if (lstPriceMarckups.Count > 0)
{
this.dgPriceMarckups.AllowPaging = (lstPriceMarckups.Count > this.dgPriceMarckups.PageSize);
this.dgPriceMarckups.DataSource = lstPriceMarckups;
this.dgPriceMarckups.DataBind();
this.dvDataContent.Visible = true;
}
else if ((searchText != string.Empty && searchText != "search"))
{
this.lblSerchKey.Text = searchText;
this.dvDataContent.Visible = true;
this.dvNoSearchResult.Visible = true;
}
else
{
this.dvEmptyDistributor.Visible = true;
}
if (lstLabelPriceMarkups.Count > 0)
{
this.dgLabelPriceMarckups.AllowPaging = (lstLabelPriceMarkups.Count > this.dgLabelPriceMarckups.PageSize);
this.dgLabelPriceMarckups.DataSource = lstLabelPriceMarkups;
this.dgLabelPriceMarckups.DataBind();
}
else if ((searchText != string.Empty && searchText != "search"))
{
this.lblLabelSerchKey.Text = searchText;
this.dvDataContent.Visible = true;
this.dvNoSearchResultLabel.Visible = true;
}
else
{
this.dvEmptyLabel.Visible = true;
}
if (lstPriceMarckups.Count == 0 && lstLabelPriceMarkups.Count == 0)
{
this.dvEmptyContent.Visible = true;
this.btnAddPriceMarckup.Visible = false;
}
this.dgPriceMarckups.Visible = (lstPriceMarckups.Count > 0);
this.dgLabelPriceMarckups.Visible = (lstLabelPriceMarkups.Count > 0);
}
