コード例 #1
0
        internal void UpdateDB(List<OkPneuTire> TireList)
        {
            DataClassesDataContext db = new DataClassesDataContext();
            foreach (var i in TireList)
            {
                if (i.ExternalStore > 0) i.ProdejniCena = i.NakupniCena;
                else if (i.NakupniCenaCZ > 0) i.ProdejniCena = i.NakupniCenaCZ;
                else i.ProdejniCena = i.NakupniCenaEU;

                if (!db.SuplierTiresOKpneus.Any(u => u.EAN == i.EAN))
                {
                    try
                    {
                        db.InsertTire(i.EAN, i.Manufacturer, i.Detail, i.ExternalStore, i.code, 0, i.ProdejniCena, i.Name, i.Season[0], i.Description, i.ImageURL);
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("error" + ex);
                    }
                }
                else
                {
                    db.UpdateTires(i.EAN, i.ProdejniCena, i.ExternalStore);
                }
            }
        }