API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 13th, 2016
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 20.94 KB | None | 0 0
raw download clone embed print report
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using Wild8.Models;
  6. using Wild8.Utils;
  7.  
  8. namespace Wild8.DAL
  9. {
  10.     public class RestaurauntInitializer : System.Data.Entity.DropCreateDatabaseAlways<RestaurauntContext>
  11.     {
  12.         protected override void Seed(RestaurauntContext context)
  13.         {
  14.             var addOns = new List<AddOn>
  15.             {
  16.                 new AddOn { AddOnID = "Lepinja", Price = 10M },
  17.                 new AddOn { AddOnID = "Ajvar", Price = 5M },
  18.                 new AddOn { AddOnID = "Luk", Price = 5M },
  19.                 new AddOn { AddOnID = "Pomfrit", Price = 6M },
  20.                 new AddOn { AddOnID = "Kroketi", Price = 6M },
  21.  
  22.                 new AddOn { AddOnID = "Gauda", Price = 7M },
  23.                 new AddOn { AddOnID = "Mozzarela", Price = 7M },
  24.                 new AddOn { AddOnID = "Gorgonzola", Price = 7M },
  25.                 new AddOn { AddOnID = "Parmezan", Price = 7M },
  26.                 new AddOn { AddOnID = "Masline", Price = 7M },
  27.             };
  28.             addOns.ForEach(s => context.AddOns.Add(s));
  29.             context.SaveChanges();
  30.  
  31.             generateGrill(context);
  32.             generatePizzas(context);
  33.             generateSandwitches(context);
  34.             generateSalads(context);
  35.  
  36.             var comments = new List<Comment>
  37.             {
  38.                 new Comment { Username = "Filip Gulan", Message = "Restoran je the best ono ej.", Grade = 4, CommentDate = DateTime.Now},
  39.                 new Comment { Username = "Fredi Saric", Message = "Restorant ti je sranje stari mooj nemilo", Grade = 1, CommentDate = DateTime.Now },
  40.                 new Comment { Username = "Matej Janjic", Message = "Smrid ti restoran", Grade = 2, CommentDate = DateTime.Now },
  41.                 new Comment { Username = "Josip", Message = "sdsafsafasasfasasfas", Grade = 3 , MealID = 1, CommentDate = DateTime.Now },
  42.                 new Comment { Username = "Superhik", Message = "Nema lošeg vina s češnjakom. 1/10 smeće totalno.", Grade = 1, CommentDate = DateTime.Now }
  43.             };
  44.  
  45.             comments.ForEach(s => context.Comments.Add(s));
  46.             context.SaveChanges();
  47.  
  48.             var employees = new List<Employee>
  49.             {
  50.                 new Employee { EmployeeID = "dlatecki", Password = TextUtils.SHA256Hash("pass_dlatecki"), FirstName = "Domagoj", LastName = "Latečki", Email = "domagoj.latecki@fer.hr", PhoneNumber = "0036478777", Address = "nema", City = "Zagreb", PostCode = "10000", Title = "Code monkey", AdminRights = false, isEmployed=true },
  51.                 new Employee { EmployeeID = "fgulan", Password = TextUtils.SHA256Hash("pass_fgulan"), FirstName = "Filip", LastName = "Gulan", Email = "filip.gulan@fer.hr", PhoneNumber = "0036479428", Address = "raja", City = "Galovac", PostCode = "23222", Title = "Sync monkey", AdminRights = true, isEmployed=true },
  52.                 new Employee { EmployeeID = "fredi", Password = TextUtils.SHA256Hash("pass_fredi"), FirstName = "Fredi", LastName = "Šarić", Email = "fredi@saric@fer.hr", PhoneNumber = "0036477353", Address = "bez", City = "Zagreb", PostCode = "10000", Title = "Alpha monkey", AdminRights = true, isEmployed=true },
  53.                 new Employee { EmployeeID = "majinlizard", Password = TextUtils.SHA256Hash("pass_majinlizard"), FirstName = "Kenneth", LastName = "Kostrešević", Email = "kenneth.kostreševic@fer.hr", PhoneNumber = "0036482290", Address = "zavičaja", City = "Zagreb", PostCode = "10000", Title = "Doc monkey", AdminRights = false, isEmployed=true },
  54.                 new Employee { EmployeeID = "mjanjic", Password = TextUtils.SHA256Hash("pass_mjanjic"), FirstName = "Matej", LastName = "Janić", Email = "matej.janjic@fer.hr", PhoneNumber = "0036481160", Address = "nit", City = "Zagreb", PostCode = "10000", Title = "Design monkey", AdminRights = false, isEmployed=false },
  55.                 new Employee { EmployeeID = "tin007", Password = TextUtils.SHA256Hash("pass_tin007"), FirstName = "Tin", LastName = "Trčak", Email = "tin.trcak@fer.hr", PhoneNumber = "0036460856", Address = "miline", City = "Zagreb", PostCode = "10000", Title = "Doc monkey", AdminRights = false, isEmployed=true },
  56.                 new Employee { EmployeeID = "tyrannizer", Password = TextUtils.SHA256Hash("pass_tyrannizer"), FirstName = "Jan", LastName = "Kelemen", Email = "jan.kelemen@fer.hr", PhoneNumber = "0036479753", Address = "bez", City = "Varaždin", PostCode = "42000", Title = "Code monkey", AdminRights = false , isEmployed=true},
  57.             };
  58.             employees.ForEach(e => context.Employees.Add(e));
  59.             context.SaveChanges();
  60.  
  61.             var orders = new List<Order>
  62.             {
  63.                 new Order { AcceptanceDate = new DateTime(2015, 1, 1), TotalPrice = 220.00M, Address = "adr", UserNote = "atn",  Email = "mail", EmpolyeeID = "dlatecki", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr", OrderDetails = new List<OrderDetail> {
  64.                     new OrderDetail { Count = 10, MealName = "Ćevapi", MealType = "Mala porcija", OrderID = 1  },
  65.                     new OrderDetail { Count = 1, MealName = "Nesto", MealType = "Mala porcija", OrderID = 1 }
  66.                 } },
  67.                 new Order { AcceptanceDate = new DateTime(2015, 1, 1), TotalPrice = 50.00M, Address = "adr",  UserNote = "atn", Email = "mail", EmpolyeeID = "fgulan", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr",OrderDetails = new List<OrderDetail> {
  68.                     new OrderDetail { Count = 1, MealName = "Ražnjiči", MealType = "Mala porcija", OrderID = 2},
  69.                     new OrderDetail { Count = 1, MealName = "Svinjska vratina", MealType = "Mala porcija", OrderID = 2}
  70.                 } },
  71.                 new Order { AcceptanceDate = new DateTime(2015, 3, 1), TotalPrice = 70.00M, Address = "adr", UserNote = "atn",  Email = "mail", EmpolyeeID = "fredi", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr",  OrderDetails = new List<OrderDetail> {
  72.                     new OrderDetail { Count = 1, MealName = "Ražnjiči", MealType = "Mala porcija", OrderID = 3},
  73.                     new OrderDetail { Count = 2, MealName = "Svinjska vratina", MealType = "Mala porcija", OrderID = 3 }
  74.                 } },
  75.                 new Order { AcceptanceDate = new DateTime(2015, 4, 1), TotalPrice = 50.00M, Address = "adr", UserNote = "atn",  Email = "mail", EmpolyeeID = "majinlizard", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr",  OrderDetails = new List<OrderDetail> {
  76.                     new OrderDetail { Count = 1, MealName = "Slavonska", MealType = "Jumbo", OrderID = 4 },
  77.                     new OrderDetail { Count = 1, MealName = "Svinjska vratina", MealType = "Mala porcija", OrderID = 4 }
  78.                 } },
  79.                 new Order { AcceptanceDate = new DateTime(2015, 5, 1), TotalPrice = 40.00M, Address = "adr",  UserNote = "atn",  Email = "mail", EmpolyeeID = "mjanjic", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr",  OrderDetails = new List<OrderDetail> {
  80.                     new OrderDetail { Count = 1, MealName = "Slavonska", MealType = "Srednja", OrderID = 4 },
  81.                     new OrderDetail { Count = 1, MealName = "Ražnjiči", MealType = "Mala porcija", OrderID = 4 }
  82.                 } },
  83.                 new Order { AcceptanceDate = new DateTime(2015, 5, 1), TotalPrice = 40.00M, Address = "adr",  UserNote = "atn",  Email = "mail", EmpolyeeID = "mjanjic", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr", OrderDetails = new List<OrderDetail> {
  84.                     new OrderDetail { Count = 1, MealName = "Slavonska", MealType = "Mala", OrderID = 4},
  85.                     new OrderDetail { Count = 1, MealName = "Ražnjiči", MealType = "Mala porcija", OrderID = 4}
  86.                 } },
  87.                 new Order { AcceptanceDate = new DateTime(2015, 5, 1), TotalPrice = 40.00M, Address = "adr",UserNote = "atn",  Email = "mail", EmpolyeeID = "mjanjic", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr", OrderDetails = new List<OrderDetail> {
  88.                     new OrderDetail { Count = 1, MealName = "Slavonska", MealType = "Jumbo", OrderID = 4 },
  89.                     new OrderDetail { Count = 1, MealName = "Ražnjiči", MealType = "Mala porcija", OrderID = 4 }
  90.                 } },
  91.                 new Order { AcceptanceDate = new DateTime(2015, 5, 1), TotalPrice = 40.00M, Address = "adr", UserNote = "atn", Email = "mail", EmpolyeeID = "mjanjic", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr", OrderDetails = new List<OrderDetail> {
  92.                     new OrderDetail { Count = 1, MealName = "Slavonska", MealType = "Mala", OrderID = 4 },
  93.                     new OrderDetail { Count = 1, MealName = "Ražnjiči", MealType = "Mala porcija", OrderID = 4}
  94.                 } },
  95.                 new Order { AcceptanceDate = new DateTime(2015, 5, 1), TotalPrice = 40.00M, Address = "adr", UserNote = "atn", Email = "mail", EmpolyeeID = "mjanjic", Name = "name", OrderDate = DateTime.Now, PhoneNumber = "nmbr",  OrderDetails = new List<OrderDetail> {
  96.                     new OrderDetail { Count = 1, MealName = "Slavonska", MealType = "Srednja", OrderID = 4 },
  97.                     new OrderDetail { Count = 1, MealName = "Ražnjiči", MealType = "Mala porcija", OrderID = 4 }
  98.                 } }
  99.             };
  100.             orders.ForEach(e => context.Orders.Add(e));
  101.             context.SaveChanges();
  102.         }
  103.  
  104.         private void generatePizzas(RestaurauntContext context)
  105.         {
  106.             Category cat = new Category { Name = "Pizze" };
  107.             var pizzas = new List<Meal>
  108.             {
  109.                 new Meal { Name = "Margharita", NumberOfOrders = 0, Description = "Rajčica, sir", Category = cat, ImagePath = "todo", IsAvailable = true },
  110.                 new Meal { Name = "Funghi", NumberOfOrders = 0, Description = "Rajčica, sir, šampinjoni", Category = cat, ImagePath = "todo", IsAvailable = true },
  111.                 new Meal { Name = "Vesuvio", NumberOfOrders = 0, Description = "Rajčica, sir, šunka", Category = cat, ImagePath = "todo", IsAvailable = true },
  112.                 new Meal { Name = "Capricciosa", NumberOfOrders = 0, Description = "Rajčica, sir, šunka, šampinjoni", Category = cat, ImagePath = "todo", IsAvailable = true },
  113.                 new Meal { Name = "Quattro formaggio", NumberOfOrders = 0, Description = "Rajčica, 4 vrste sira", Category = cat, ImagePath = "todo", IsAvailable = true },
  114.                 new Meal { Name = "Al tonno", NumberOfOrders = 0, Description = "Rajčica, sir, tunjevina", Category = cat, ImagePath = "todo", IsAvailable = true },
  115.                 new Meal { Name = "Frutti di mare", NumberOfOrders = 0, Description = "Rajčica, sir, plodovi mora", Category = cat, ImagePath = "todo", IsAvailable = true },
  116.                 new Meal { Name = "Vegetariana", NumberOfOrders = 0, Description = "Rajčica, sir, paprika, kukuruz, šampinjoni", Category = cat, ImagePath = "todo", IsAvailable = true },
  117.                 new Meal { Name = "Prosccuiuto", NumberOfOrders = 0, Description = "Rajčica, sir, pršut", Category = cat, ImagePath = "todo", IsAvailable = true },
  118.                 new Meal { Name = "Slavonska", NumberOfOrders = 0, Description = "Rajčica, sir, šunka, šampinjoni, kulen, špek", Category = cat, ImagePath = "todo", IsAvailable = true },
  119.                 new Meal { Name = "Napolitana", NumberOfOrders = 0, Description = "Rajčica, sir, šunka, šampinjoni, špek, jaje", Category = cat, ImagePath = "todo", IsAvailable = true },
  120.                 new Meal { Name = "Mexicana", NumberOfOrders = 0, Description = "Rajčica, sir, šunka, špek, kukuruz, tabasco, paprika", Category = cat, ImagePath = "todo", IsAvailable = true },
  121.                 new Meal { Name = "Picante", NumberOfOrders = 0, Description = "Rajčica, sir, šunka, špek, feferoni", Category = cat, ImagePath = "todo", IsAvailable = true },
  122.                 new Meal { Name = "Zagrebačka", NumberOfOrders = 0, Description = "Rajčica, sir, šunka, šampinjoni, svj. paprika, kiselo vrhnje, špek", Category = cat, ImagePath = "todo", IsAvailable = true },
  123.                 new Meal { Name = "Asterix", NumberOfOrders = 0, Description = "Rajčica, sir, šunka, špek, kulen, jaje", Category = cat, ImagePath = "todo", IsAvailable = true },
  124.                 new Meal { Name = "Lovačka", NumberOfOrders = 0, Description = "Rajčica, sir, šunka, šampinjoni, kulen, ljuti feferoni", Category = cat, ImagePath = "todo", IsAvailable = true },
  125.                 new Meal { Name = "Baranjska", NumberOfOrders = 0, Description = "Rajčica, sir, šunk,a kulen, ljuti feferoni, luk, špek", Category = cat, ImagePath = "todo", IsAvailable = true }
  126.             };
  127.             pizzas.ForEach(s => context.Meals.Add(s));
  128.  
  129.             foreach (Meal m in pizzas)
  130.             {
  131.                 var pizzaTypes = new List<MealType>
  132.                 {
  133.                     new MealType { Meal = m, MealTypeName = "Mala", Price = 30 },
  134.                     new MealType { Meal = m, MealTypeName = "Srednja", Price = 35 },
  135.                     new MealType { Meal = m, MealTypeName = "Jumbo", Price = 70 }
  136.                 };
  137.                 pizzaTypes.ForEach(t => context.MealTypes.Add(t));
  138.  
  139.                 var pizzaAddOns = new List<MealAddOn>
  140.                 {
  141.                     new MealAddOn { Meal = m, AddOnID = "Gauda" },
  142.                     new MealAddOn { Meal = m, AddOnID = "Mozzarela"},
  143.                     new MealAddOn { Meal = m, AddOnID = "Gorgonzola"},
  144.                     new MealAddOn { Meal = m, AddOnID = "Parmezan"},
  145.                     new MealAddOn { Meal = m, AddOnID = "Masline"},
  146.                 };
  147.                 pizzaAddOns.ForEach(a => context.MealAddOns.Add(a));
  148.             }
  149.             context.SaveChanges();
  150.         }
  151.  
  152.         private void generateGrill(RestaurauntContext context)
  153.         {
  154.             Category cat = new Category { Name = "Jela s roštilja" };
  155.             var grill = new List<Meal>
  156.         {
  157.                 new Meal { Name = "Ćevapi", NumberOfOrders = 0, Description = "", Category = cat, ImagePath = "todo", IsAvailable = true },
  158.                 new Meal { Name = "Pljeskavica", NumberOfOrders = 0, Description = "", Category = cat, ImagePath = "todo", IsAvailable = true },
  159.                 new Meal { Name = "Pljeskavica punjena", NumberOfOrders = 0, Description = "", Category = cat, ImagePath = "todo", IsAvailable = true },
  160.                 new Meal { Name = "Ražnjiči", NumberOfOrders = 0, Description = "Svinjsko meso", Category = cat, ImagePath = "todo", IsAvailable = true },
  161.                 new Meal { Name = "Ražnjiči", NumberOfOrders = 0, Description = "Pileće meso", Category = cat, ImagePath = "todo", IsAvailable = true },
  162.                 new Meal { Name = "Svinjska vratina", NumberOfOrders = 0, Description = "", Category = cat, ImagePath = "todo", IsAvailable = true },
  163.                 new Meal { Name = "Naravni", NumberOfOrders = 0, Description = "Svinjsko meso", Category = cat, ImagePath = "todo", IsAvailable = true },
  164.                 new Meal { Name = "Naravni", NumberOfOrders = 0, Description = "Pileće meso", Category = cat, ImagePath = "todo", IsAvailable = true },
  165.                 new Meal { Name = "Miješano meso", NumberOfOrders = 0, Description = "", Category = cat, ImagePath = "todo", IsAvailable = true },
  166.                 new Meal { Name = "Punjeni lungić", NumberOfOrders = 0, Description = "Sir, šunka", Category = cat, ImagePath = "todo", IsAvailable = true },
  167.         };
  168.             grill.ForEach(s => context.Meals.Add(s));
  169.  
  170.             foreach (Meal m in grill)
  171.             {
  172.                 var grillTypes = new List<MealType>
  173.                 {
  174.                     new MealType { Meal = m, MealTypeName = "Mala porcija", Price = 30 },
  175.                     new MealType { Meal = m, MealTypeName = "Velika porcija", Price = 45},
  176.                 };
  177.                 grillTypes.ForEach(t => context.MealTypes.Add(t));
  178.  
  179.                 var grillAddOns = new List<MealAddOn>
  180.                 {
  181.                     new MealAddOn { Meal = m, AddOnID = "Lepinja" },
  182.                     new MealAddOn { Meal = m, AddOnID = "Ajvar"},
  183.                     new MealAddOn { Meal = m, AddOnID = "Luk"},
  184.                     new MealAddOn { Meal = m, AddOnID = "Pomfrit"},
  185.                     new MealAddOn { Meal = m, AddOnID = "Kroketi"},
  186.                 };
  187.                 grillAddOns.ForEach(a => context.MealAddOns.Add(a));
  188.             }
  189.             context.SaveChanges();
  190.         }
  191.  
  192.         private void generateSandwitches(RestaurauntContext context)
  193.         {
  194.             Category cat = new Category { Name = "Sendviči" };
  195.             var sandwitches = new List<Meal>
  196.             {
  197.                 new Meal { Name = "Šunka", NumberOfOrders = 0, Description = "Domaća lepinja, sir, šunka, povrće, umak", Category = cat, ImagePath = "todo", IsAvailable = true },
  198.                 new Meal { Name = "Kvočko", NumberOfOrders = 0, Description = "Domaća lepinja, piletina, povrće, umak", Category = cat, ImagePath = "todo", IsAvailable = true },
  199.                 new Meal { Name = "Kulen", NumberOfOrders = 0, Description = "Domaća lepinja, sir, kulen, povrće, umak", Category = cat, ImagePath = "todo", IsAvailable = true },
  200.                 new Meal { Name = "Vratina", NumberOfOrders = 0, Description = "Domaća lepinja, sir, vratina, povrće, umak", Category = cat, ImagePath = "todo", IsAvailable = true },
  201.                 new Meal { Name = "Pršut", NumberOfOrders = 0, Description = "Domaća lepinja, sir, pršut, povrće, umak", Category = cat, ImagePath = "todo", IsAvailable = true },
  202.                 new Meal { Name = "Tuna", NumberOfOrders = 0, Description = "Domaća lepinja, sir, tuna, povrće, umak", Category = cat, ImagePath = "todo", IsAvailable = true }
  203.             };
  204.  
  205.             foreach (Meal m in sandwitches)
  206.             {
  207.                 var sandwitchTypes = new List<MealType>
  208.                 {
  209.                     new MealType { Meal = m, MealTypeName = "Mali", Price = 15 },
  210.                     new MealType { Meal = m, MealTypeName = "Veliki", Price = 25 },
  211.                 };
  212.                 sandwitchTypes.ForEach(t => context.MealTypes.Add(t));
  213.  
  214.                 var sandwitchAddOns = new List<MealAddOn>
  215.                 {
  216.                     new MealAddOn { Meal = m, AddOnID = "Ajvar"},
  217.                     new MealAddOn { Meal = m, AddOnID = "Luk"},
  218.                     new MealAddOn { Meal = m, AddOnID = "Pomfrit"},
  219.                 };
  220.                 sandwitchAddOns.ForEach(a => context.MealAddOns.Add(a));
  221.             }
  222.             context.SaveChanges();
  223.         }
  224.  
  225.         private void generateSalads(RestaurauntContext context)
  226.         {
  227.             Category cat = new Category { Name = "Salate" };
  228.             var salads = new List<Meal>
  229.             {
  230.                 new Meal { Name = "Pollo", NumberOfOrders = 0, Description = "Miješana salata s piletnom sa žara, dresing", Category = cat, ImagePath = "todo", IsAvailable = true },
  231.                 new Meal { Name = "Tonno", NumberOfOrders = 0, Description = "Tjestenina, miješana salata, tuna, dresing", Category = cat, ImagePath = "todo", IsAvailable = true },
  232.                 new Meal { Name = "Piletina", NumberOfOrders = 0, Description = "Tjestenina, piletina sa žara, kukur, paprika ,dresing", Category = cat, ImagePath = "todo", IsAvailable = true },
  233.                 new Meal { Name = "Meksička", NumberOfOrders = 0, Description = "Tjestanina, grah, kukuruz, luk, piletina, paprika ,ljuti dresing", Category = cat, ImagePath = "todo", IsAvailable = true },
  234.                 new Meal { Name = "Gurmanska", NumberOfOrders = 0, Description = "Tjestenina, sir, šunka, paprika, rajčica, dresing", Category = cat, ImagePath = "todo", IsAvailable = true },
  235.                 new Meal { Name = "Kraljevska", NumberOfOrders = 0, Description = "Piletina, paprika, rajčica, zelena salata, kuhano jaje, dresing", Category = cat, ImagePath = "todo", IsAvailable = true },
  236.                 new Meal { Name = "Grčka", NumberOfOrders = 0, Description = "Zelena salata, paprika, rajčcia, sir, mozzarela, dresing", Category = cat, ImagePath = "todo", IsAvailable = true },
  237.                 new Meal { Name = "Šefova", NumberOfOrders = 0, Description = "Miješana salata, piletina, mozzarela, prženi špek, dresing", Category = cat, ImagePath = "todo", IsAvailable = true },
  238.             };
  239.  
  240.             foreach (Meal m in salads)
  241.             {
  242.                 var saladTypes = new List<MealType>
  243.                 {
  244.                     new MealType { Meal = m, MealTypeName = "Mala", Price = 10 },
  245.                     new MealType { Meal = m, MealTypeName = "Velika", Price = 25 },
  246.                 };
  247.                 saladTypes.ForEach(t => context.MealTypes.Add(t));
  248.  
  249.                 var saladAddOns = new List<MealAddOn>
  250.                 {
  251.                     new MealAddOn { Meal = m, AddOnID = "Masline"},
  252.                     new MealAddOn { Meal = m, AddOnID = "Luk"},
  253.                 };
  254.                 saladAddOns.ForEach(a => context.MealAddOns.Add(a));
  255.             }
  256.             context.SaveChanges();
  257.         }
  258.     }
  259. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!