// Use at CakeChart.cshtml >LoadData >url: "/Home/CakeData"
public JsonResult CakeData()
{
using (var context = new CakeDbContext())
{
// Fetch all Cake
var list = new List <CakeModel>();
foreach (var cake in context.CakeDbSet.ToList())
{
list.Add(new CakeModel
{
Id = cake.Id,
CakeName = cake.CakeName,
EatenYear2019 = cake.EatenYear2019,
EatenYear2015 = cake.EatenYear2015,
EatenYear2010 = cake.EatenYear2010,
EatenYear2005 = cake.EatenYear2005
});
}
return(Json(list));
}
}
public IActionResult Create([FromForm] CakeModel newCakeModel)
{
if (ModelState.IsValid)
{
using (var context = new CakeDbContext())
{
// Create database if it does not exist
context.Database.EnsureCreated();
context.CakeDbSet.Add(newCakeModel);
// Commit changes
context.SaveChanges();
}
// return RedirectToAction("Index");
return(RedirectToAction("CakeChart"));
}
else
{
return(View(newCakeModel));
}
}
/// <sammary>
/// CakeChart
/// </sammary>
public IActionResult CakeChart()
{
using (var context = new CakeDbContext())
{
// Clear and reset database
// context.Database.EnsureDeleted();
// Create database if it does not exist
context.Database.EnsureCreated();
// Add records: Id is autoincremented by default
// context.CakeDbSet.Add(new CakeModel { CakeName = "Cheese", EatenYear2019 = 10, EatenYear2015 = 11, EatenYear2010 = 12, EatenYear2005 = 13 });
// context.CakeDbSet.Add(new CakeModel { CakeName = "Fruit Tart", EatenYear2019 = 20, EatenYear2015 = 21, EatenYear2010 = 22, EatenYear2005 = 23 });
// context.CakeDbSet.Add(new CakeModel { CakeName = "Chocolate", EatenYear2019 = 30, EatenYear2015 = 31, EatenYear2010 = 32, EatenYear2005 = 33 });
// context.CakeDbSet.Add(new CakeModel { CakeName = "Strawberry", EatenYear2019 = 40, EatenYear2015 = 41, EatenYear2010 = 42, EatenYear2005 = 43 });
// Commit changes
// context.SaveChanges();
// Fetch all Cake
var list = new List <CakeModel>();
foreach (var cake in context.CakeDbSet.ToList())
{
list.Add(new CakeModel
{
Id = cake.Id,
CakeName = cake.CakeName,
EatenYear2019 = cake.EatenYear2019,
EatenYear2015 = cake.EatenYear2015,
EatenYear2010 = cake.EatenYear2010,
EatenYear2005 = cake.EatenYear2005
});
}
return(View(list));
}
}
public OrderRepository(CakeDbContext appDbContext, Cart shoppingCart)
{
_appDbContext = appDbContext;
_shoppingCart = shoppingCart;
}
private Cart(CakeDbContext cakeDbContext)
{
this.cakeDbContext = cakeDbContext;
}
public CakeRepository(CakeDbContext cakeContext)
{
this.cakeContext = cakeContext;
}
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, CakeDbContext context)
{
app.UseDeveloperExceptionPage();
app.UseStatusCodePages();
app.UseStaticFiles();
app.UseSession();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "drinkdetails",
template: "Drink/Details/{drinkId?}",
defaults: new { Controller = "Drink", action = "Details" });
routes.MapRoute(
name: "categoryfilter",
template: "Cake/{action}/{category?}",
defaults: new { Controller = "Cake", action = "List" });
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{Id?}");
});
DbInitializer.Initialize(context);
}
public static void Initialize(CakeDbContext context)
{
context.Database.EnsureCreated();
if (!context.Catgoryes.Any())
{
context.Catgoryes.AddRange(Categories.Select(c => c.Value));
}
if (!context.Cakes.Any())
{
context.AddRange
(
new Cake
{
Name = "Čokoladna kraljica",
Price = 7.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Čokoladne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2017/03/cokoladna-kraljica.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2017/03/cokoladna-kraljica.jpg"
},
new Cake
{
Name = "Mlečna čokoladna torta ",
Price = 12.95M,
ShortDescription = "Cocktail made of cola, lime and rum.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Čokoladne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2017/02/mlecna-cokoladna-torta.jpg",
InStock = true,
IsPerferedCake = false,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2017/02/mlecna-cokoladna-torta.jpg"
},
new Cake
{
Name = "Torta sa orasima",
Price = 8.95M,
ShortDescription = "Lorem ipsumdolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Čokoladne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/12/torta-sa-orasima.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/12/torta-sa-orasima.jpg"
},
new Cake
{
Name = "Grilijas torta",
Price = 10.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Čokoladne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/11/grilijas-torta.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/11/grilijas-torta.jpg"
},
new Cake
{
Name = "Monte",
Price = 12.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Čokoladne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/02/IMG_7334.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/02/IMG_7334.jpg"
},
new Cake
{
Name = "Plazma torta sa bananama",
Price = 15.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Voćne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2017/05/plazma-torta-sa-bananama.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2017/05/plazma-torta-sa-bananama.jpg"
},
new Cake
{
Name = "Voćna Torta",
Price = 10.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Voćne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/07/torta-sa-breskvama-vocna-torta.jpg",
InStock = false,
IsPerferedCake = false,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/07/torta-sa-breskvama-vocna-torta.jpg"
},
new Cake
{
Name = "Torta sa jaogdama",
Price = 12.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Voćne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/05/torta-sa-jagodama.jpg",
InStock = false,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/05/torta-sa-jagodama.jpg"
},
new Cake
{
Name = "Bloddy berry torta",
Price = 13.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Voćne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/04/bloddy-berry-torta.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/04/bloddy-berry-torta.jpg"
},
new Cake
{
Name = "Cheesecake sa šumskim voćem",
Price = 15.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Voćne"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2015/06/cizkejk-sa-sumskim-vocem-cheesecake.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2015/06/cizkejk-sa-sumskim-vocem-cheesecake.jpg"
},
new Cake
{
Name = "Brza torta sa plazma keksom i orasima",
Price = 12.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Brze"],
ImageUrl = "https://domacirecepti.net/wp-content/uploads/2016/01/brza-torta-sa-plazma-keksom-i-orasima.jpg",
InStock = false,
IsPerferedCake = true,
ImageThumbnailUrl = "https://domacirecepti.net/wp-content/uploads/2016/01/brza-torta-sa-plazma-keksom-i-orasima.jpg"
},
new Cake
{
Name = "Beli andjeo torta",
Price = 19.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Brze"],
ImageUrl = "https://domacirecepti.net/wp-content/uploads/2017/05/torta-beli-andjeo-thumb.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://domacirecepti.net/wp-content/uploads/2017/05/torta-beli-andjeo-thumb.jpg"
},
new Cake
{
Name = "Torta sa TOTO keksom",
Price = 12.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Brze"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/08/toto-torta-3.jpg",
InStock = false,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/08/toto-torta-3.jpg"
},
new Cake
{
Name = "Šeherezada torta",
Price = 16.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Brze"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/05/seherezada.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/05/seherezada.jpg"
},
new Cake
{
Name = "Fanta jafa torta",
Price = 14.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Brze"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/11/fanta-jafa-torta.jpg",
InStock = false,
IsPerferedCake = false,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/11/fanta-jafa-torta.jpg"
},
new Cake
{
Name = "Brza plazma torta",
Price = 12.95M,
ShortDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit.",
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec tortor eros, interdum in dolor at, blandit pellentesque metus. Nulla dapibus ornare nisi vitae posuere. Mauris arcu nibh, bibendum id nulla vitae, vestibulum iaculis augue. Maecenas ut posuere turpis, at vulputate sapien. Pellentesque vel nisi vitae felis commodo rutrum. Integer sagittis sed leo vel aliquam.",
Category = Categories["Brze"],
ImageUrl = "https://brzikolaci.com/wp-content/uploads/2016/01/brza-plazma-torta.jpg",
InStock = true,
IsPerferedCake = true,
ImageThumbnailUrl = "https://brzikolaci.com/wp-content/uploads/2016/01/brza-plazma-torta.jpg"
}
);
}
context.SaveChanges();
}
