private void GetNewDataBaseCategory() { clsCommonMethods obj = new clsCommonMethods(); var cate = from newcat in obj.GetAll_VW_Products() where !Categories.Select(cat => cat.CategoryName_V).ToList().Contains(newcat.CategoryName) && newcat.CategoryName != null select new { NewCategory = newcat.CategoryName, CategoryPath = newcat.Location }; gvLiveItems.DataSource = cate.Distinct().ToList(); gvLiveItems.DataBind(); //if (gvLiveItems.Rows.Count > 0) //{ // gvLiveItems.UseAccessibleHeader = true; // gvLiveItems.HeaderRow.TableSection = TableRowSection.TableHeader; // gvLiveItems.FooterRow.TableSection = TableRowSection.TableFooter; //} }
public List <vw_Product> GetAllProducts() { List <vw_Product> items = client.GetAll_VW_Products().ToList(); return(items); }