コード例 #1
0
        public List <ProductModel> GetProductBySupplierAndName(string supplier, string name)
        {
            int tempNum = 0;
            var query   = from p in context.GetArtikelByName(supplier, name)
                          select new ProductModel
            {
                Gloss           = p.Gloss,
                Gramatura       = p.Gramatura,
                Kategorija      = p.Kategorija,
                Naziv           = p.NAZIV,
                StevilkaArtikel = p.StArtikla,
                Tek             = p.Tek,
                Velikost        = p.Velikost,
                Dobavitelj      = p.DOBAVITELJ
            };

            var list = query.ToList();

            // če ne vrne artikla potem preverimo še direct v Pantheon bazi
            if (list.Count == 0)
            {
                var queryP = from p in context.GetArtikelByNamePantheonOnly(supplier, name)
                             select new ProductModel
                {
                    Naziv           = p.NAZIV,
                    StevilkaArtikel = p.StArtikla,
                    Dobavitelj      = p.DOBAVITELJ
                };

                var listP = queryP.ToList();

                if (listP.Count == 1)
                {
                    foreach (var itemP in listP)
                    {
                        ExtractDataFromName(itemP);
                        itemP.TempID = tempNum++;
                    }

                    return(listP);
                }
            }

            foreach (var item in list)
            {
                item.TempID = tempNum++;
            }

            return(list);
        }