internal void AddCategoriesAndFruits()
{
var torkad = new FruitCategory {
Name = "Torkad"
};
var färsk = new FruitCategory {
Name = "Färsk"
};
var mogen = new FruitCategory {
Name = "Mogen"
};
//_context.FruitCategories.Add(torkad); överflödigt här då den fattar att man ska lägga till ny kategori pga koden nedan
_context.Fruits.Add(new Fruit {
Name = "Päron", Category = mogen, Price = 19
});
_context.Fruits.Add(new Fruit {
Name = "Apelsin", Category = färsk, Price = 25
});
_context.Fruits.Add(new Fruit {
Name = "Persika", Category = torkad, Price = 55
});
_context.SaveChanges();
}
public void ClearDatabase()
{
foreach (var category in _context.FruitCategories)
{
_context.Remove(category);
}
foreach (var fruit in _context.Fruits)
{
_context.Remove(fruit);
}
// Alternativt: _context.RemoveRange(_context.Fruits);
_context.SaveChanges();
}
internal void AddCategoriesAndFruits()
{
//Skapar några fruktkategorier
var fc1 = new FruitCategory {
Name = "bär"
};
var fc2 = new FruitCategory {
Name = "citrus"
};
var fc3 = new FruitCategory {
Name = "Goe Frukter"
};
_context.FruitCategories.AddRange(fc1, fc2, fc3);
//Skapar några korgar
var b1 = new Basket {
Name = "Goe korgen"
};
var b2 = new Basket {
Name = "Äckle korgen"
};
var b3 = new Basket
{
Name = "FamiljeKorgen",
FruitInBaskets = new List <FruitInBasket> {
new FruitInBasket {
Fruit = new Fruit {
Name = "Durian", Price = 999, Category = fc1
}
},
new FruitInBasket {
Fruit = new Fruit {
Name = "Plommon", Price = 444, Category = fc1
}
},
new FruitInBasket {
Fruit = new Fruit {
Name = "Riskakafrukten", Price = 9999, Category = fc1
}
},
}
};
var b4 = new Basket
{
Name = "Göteborgskorgen",
FruitInBaskets = new List <FruitInBasket> {
new FruitInBasket {
Fruit = new Fruit {
Name = "Fillidutt", Price = 10000, Category = new FruitCategory {
Name = "Stenfrukter"
}
}
},
new FruitInBasket {
Fruit = new Fruit {
Name = "Kexchoklad", Price = 20, Category = new FruitCategory {
Name = "GöteborgsFrukter"
}
}
},
new FruitInBasket {
Fruit = new Fruit {
Name = "Riskakafrukten", Price = 741, Category = fc3
}
},
}
};
_context.Basket.AddRange(b1, b2, b3, b4);
//Skapar några frukter
var f1 = new Fruit {
Name = "banan", Price = 500, Category = fc1
};
var f2 = new Fruit {
Name = "äpple", Price = 100, Category = fc2
};
var f3 = new Fruit {
Name = "citron", Price = 140, Category = fc2
};
var f4 = new Fruit {
Name = "kaktus", Price = 720, Category = fc2
};
var f5 = new Fruit {
Name = "Vindruvor", Price = 10000, Category = fc3
};
var f6 = new Fruit {
Name = "Ananas", Price = 10050, Category = fc3
};
_context.Fruits.AddRange(f1, f2, f3, f4, f5, f6);
//Fyller i många-till-många relation m.h.a. KORG + FRUKT
var fib1 = new FruitInBasket {
Fruit = f1, Basket = b1
};
var fib2 = new FruitInBasket {
Fruit = f2, Basket = b1
};
var fib3 = new FruitInBasket {
Fruit = f3, Basket = b1
};
var fib4 = new FruitInBasket {
Fruit = f4, Basket = b2
};
_context.FruitInBasket.AddRange(fib1, fib2, fib3, fib4);
_context.SaveChanges();
}
public void AddCategoriesAndFruits()
{
var skenfrukt = new FruitCategory {
Name = "Skenfrukt"
};
var äktatorr = new FruitCategory {
Name = "Äkta Torr Frukt"
};
var äktasaftig = new FruitCategory {
Name = "Äkta Saftig Frukt"
};
var ananas = new Fruit {
Name = "Ananas", Category = skenfrukt, Price = 10.3M
};
var banan = new Fruit {
Name = "Banan", Category = äktatorr, Price = 5
};
var äpple = new Fruit {
Name = "Äpple", Category = skenfrukt, Price = 4
};
var kiwi = new Fruit {
Name = "Kiwi", Category = äktasaftig, Price = 3
};
var päron = new Fruit {
Name = "Päron", Category = äktasaftig, Price = 6
};
var basket1 = new Basket()
{
Name = "Min kundkorg",
FruitInBaskets = new List <FruitInBasket>
{
new FruitInBasket {
Fruit = ananas
},
new FruitInBasket {
Fruit = päron
}
}
};
var basket2 = new Basket()
{
Name = "Min kundkorg2",
FruitInBaskets = new List <FruitInBasket>
{
new FruitInBasket {
Fruit = äpple
},
new FruitInBasket {
Fruit = kiwi
}
}
};
var basket3 = new Basket()
{
Name = "Min kundkorg3",
FruitInBaskets = new List <FruitInBasket>
{
new FruitInBasket {
Fruit = ananas
},
new FruitInBasket {
Fruit = äpple
}
}
};
_context.FruitCategories.Add(skenfrukt);
_context.FruitCategories.Add(äktatorr);
_context.FruitCategories.Add(äktasaftig);
_context.Fruits.Add(äpple);
_context.Fruits.Add(ananas);
_context.Fruits.Add(kiwi);
_context.Fruits.Add(päron);
_context.Fruits.Add(banan);
_context.Baskets.Add(basket1);
_context.Baskets.Add(basket2);
_context.Baskets.Add(basket3);
_context.SaveChanges();
}
public void SaveChanges()
{
_context.SaveChanges();
}
