void ProductSearchResults_Loaded(object sender, RoutedEventArgs e)
        {
            libraries.Database db = libraries.Database.getDatabase();

            System.Collections.Generic.List<libraries.ProductInformation.ProductInformationData> listdata = new List<libraries.ProductInformation.ProductInformationData>();
            string cat = "";
            string pname = "";
            foreach (System.Collections.Generic.KeyValuePair<string, string> item in NavigationContext.QueryString)
            {
                if (item.Key == "pname")
                {
                    pname = item.Value;
                }
                else if (item.Key == "cat")
                {
                    cat = item.Value;
                }
            }
            if (cat.Length > 0 && pname.Length > 0)
            {
                listdata = db.getProductInfoDB().getProductListByNameAndCategory(pname, cat);
            }
            else if (cat.Length > 0)
            {
                listdata = db.getProductInfoDB().getProductListByCategory(cat);
            }
            else if (pname.Length > 0)
            {
                listdata = db.getProductInfoDB().getProductListByName(pname);
            }
            else
            {
                listdata = db.getProductInfoDB().getProductList();
            }
            if (listdata != null)
            {
                Uri image;
                Uri company;
                Uri product;
                foreach (libraries.ProductInformation.ProductInformationData item in listdata)
                {
                    if (item.imageurl == null||item.imageurl.Length<2)
                        image = null;
                    else
                        image = new Uri(item.imageurl);

                    company = new Uri(resources.DBRes.companyProductsListPage + "?companyid="+item.CompanyID,UriKind.Relative);
                    product = new Uri(resources.DBRes.productVideoPage + "?productid=" + item.ProductID, UriKind.Relative);

                    Advertiser.controls.ProductItem pi = new controls.ProductItem(company,image,product,this.NavigationService);

                    pi.initData(libraries.Database.getDatabase().getCompaniesDB().getCompany(item.CompanyID).CompanyName, item.ProductName, item.ProductDescription);
                    searchResultsList.Children.Add(pi);
                }

            }
        }
        void CompanyProducts_Loaded(object sender, RoutedEventArgs e)
        {
            libraries.Database db = libraries.Database.getDatabase();

            System.Collections.Generic.List<libraries.ProductInformation.ProductInformationData> listdata = new List<libraries.ProductInformation.ProductInformationData>();
            string companyID = "";

            foreach (System.Collections.Generic.KeyValuePair<string, string> item in NavigationContext.QueryString)
            {
                if (item.Key == "companyid")
                {
                    companyID = item.Value;
                }
            }
            if (companyID.Length > 0)
            {
                listdata = db.getProductInfoDB().getProductListByCompany(companyID);
                libraries.CompanyInformation.CompanyInformationData cid = libraries.Database.getDatabase().getCompaniesDB().getCompany(companyID);
                this.PageTitle.Text = cid.CompanyName.ToUpper() + " Products";
            }
            else
                return;

            if (listdata != null)
            {
                Uri image;
                Uri company;
                Uri product;
                foreach (libraries.ProductInformation.ProductInformationData item in listdata)
                {
                    if (item.imageurl == null || item.imageurl.Length < 2)
                        image = null;
                    else
                        image = new Uri(item.imageurl);

                    company = new Uri(resources.DBRes.companyProductsListPage + "?companyid=" + item.CompanyID, UriKind.Relative);
                    product = new Uri(resources.DBRes.productVideoPage + "?productid=" + item.ProductID, UriKind.Relative);

                    Advertiser.controls.ProductItem pi = new controls.ProductItem(company, image, product, this.NavigationService);

                    pi.initData(libraries.Database.getDatabase().getCompaniesDB().getCompany(item.CompanyID).CompanyName, item.ProductName, item.ProductDescription);
                    companyProductsList.Children.Add(pi);
                }

            }
        }