public bool Delete(int id)
{
bool status = false;
PhotoMenu tempPhotoMenu = this.dbcontext.PhotoMenus.Where(w => w.PhotoMenuID == id).FirstOrDefault();
if (tempPhotoMenu != null)
{
this.dbcontext.PhotoMenus.Remove(tempPhotoMenu);
this.dbcontext.SaveChanges();
status = true;
}
return(status);
}
public bool Update(PhotoMenu model)
{
bool status = false;
PhotoMenu tempPhotoMenu = this.dbcontext.PhotoMenus.Where(w => w.PhotoMenuID == model.PhotoMenuID).FirstOrDefault();
if (tempPhotoMenu != null)
{
tempPhotoMenu.MenuID = model.MenuID;
tempPhotoMenu.Filename = model.Filename;
tempPhotoMenu.GUIDFilename = model.GUIDFilename;
this.dbcontext.SaveChanges();
status = true;
}
return(status);
}
public int Create(PhotoMenu model)
{
this.dbcontext.PhotoMenus.Add(model);
this.dbcontext.SaveChanges();
return(model.PhotoMenuID);
}
protected override void Seed(MaharajaRestaurant.DAL.MaharajasDbContext context)
{
if (!context.Roles.Any(r => r.Name.ToUpper() == "ADMINISTRATOR"))
{
var store = new RoleStore <IdentityRole>(context);
var manager = new RoleManager <IdentityRole>(store);
var role = new IdentityRole {
Name = "ADMINISTRATOR"
};
manager.Create(role);
}
if (!context.Roles.Any(r => r.Name.ToUpper() == "CUSTOMER"))
{
var store = new RoleStore <IdentityRole>(context);
var manager = new RoleManager <IdentityRole>(store);
var role = new IdentityRole {
Name = "CUSTOMER"
};
manager.Create(role);
}
if (!context.Users.Any(u => u.UserName == "administrator"))
{
var store = new UserStore <ApplicationUser>(context);
var manager = new UserManager <ApplicationUser>(store);
var user = new ApplicationUser {
UserName = "******", Email = "*****@*****.**"
};
manager.Create(user, "asdQWE!@#");
manager.AddToRole(user.Id, "ADMINISTRATOR");
}
if (!context.Users.Any(u => u.UserName == "happycustomer"))
{
var store = new UserStore <ApplicationUser>(context);
var manager = new UserManager <ApplicationUser>(store);
var user = new ApplicationUser {
UserName = "******", Email = "*****@*****.**"
};
manager.Create(user, "asdQWE!@#");
manager.AddToRole(user.Id, "CUSTOMER");
}
if (!context.Menus.Any(u => u.Type == DAL.MenusType.Entrees))
{
/* Entrees starts here */
Menu menu0 = new Menu();
menu0.Name = "VEGETABLE SAMOSA";
menu0.Description = "Short pastry pockets filled with mashed potato, spices, peas and served with mint sauce.";
menu0.Type = MenusType.Entrees;
menu0.Price = 2.70;
menu0.WordAfterPrice = "(3pcs)";
menu0.HotScale = HotLevel.Mild;
context.Menus.AddOrUpdate(menu0);
context.SaveChanges();
PhotoMenu photo0_0 = new PhotoMenu();
photo0_0.MenuID = 1;
photo0_0.Filename = "VEGETABLE_SAMOSA_0.png";
photo0_0.GUIDFilename = "C2B6BAAA-0CF7-4BA8-BB29-FEF6FCA8FCFB.png";
context.PhotoMenus.AddOrUpdate(photo0_0);
context.SaveChanges();
PhotoMenu photo0_1 = new PhotoMenu();
photo0_1.MenuID = 1;
photo0_1.Filename = "VEGETABLE_SAMOSA_1.png";
photo0_1.GUIDFilename = "756A933D-08D0-4201-A8B4-EFB6F42A895F.png";
context.PhotoMenus.AddOrUpdate(photo0_1);
context.SaveChanges();
PhotoMenu photo0_2 = new PhotoMenu();
photo0_2.MenuID = 1;
photo0_2.Filename = "VEGETABLE_SAMOSA_2.png";
photo0_2.GUIDFilename = "D737A4D7-B162-4C16-80BC-AF58223327CF.png";
context.PhotoMenus.AddOrUpdate(photo0_2);
context.SaveChanges();
Menu menu1 = new Menu();
menu1.Name = "ONION PAKORA";
menu1.Description = "Slices of onions with herbs, lentils, spices blended in chick pea flour and served with mint sauce.";
menu1.Type = MenusType.Entrees;
menu1.Price = 1.20;
menu1.WordAfterPrice = "(per plate)";
menu1.HotScale = HotLevel.Hot;
context.Menus.AddOrUpdate(menu1);
context.SaveChanges();
PhotoMenu photo1_0 = new PhotoMenu();
photo1_0.MenuID = 2;
photo1_0.Filename = "ONION PAKORA_0.png";
photo1_0.GUIDFilename = "795123A9-E5D6-4D58-B304-33110D065A0D.png";
context.PhotoMenus.AddOrUpdate(photo1_0);
context.SaveChanges();
PhotoMenu photo1_1 = new PhotoMenu();
photo1_1.MenuID = 2;
photo1_1.Filename = "ONION PAKORA_1.png";
photo1_1.GUIDFilename = "D04AB26D-9CB9-47A0-A9AC-C876F6F2E868.png";
context.PhotoMenus.AddOrUpdate(photo1_1);
context.SaveChanges();
Menu menu2 = new Menu();
menu2.Name = "CHICKEN TIKKA";
menu2.Description = "Chicken thigh fillets marinated in yoghurt, spices, cooked in Tandoor and served with mint sauce.";
menu2.Type = MenusType.Entrees;
menu2.Price = 2.50;
menu2.WordAfterPrice = "(small plate)";
menu2.HotScale = HotLevel.Mild;
context.Menus.AddOrUpdate(menu2);
context.SaveChanges();
PhotoMenu photo2_0 = new PhotoMenu();
photo2_0.MenuID = 3;
photo2_0.Filename = "CHICKEN TIKKA_0.png";
photo2_0.GUIDFilename = "17950D52-F989-40B9-8B19-DFA0FA45AB7F.png";
context.PhotoMenus.AddOrUpdate(photo2_0);
context.SaveChanges();
PhotoMenu photo2_1 = new PhotoMenu();
photo2_1.MenuID = 3;
photo2_1.Filename = "CHICKEN TIKKA_0.png";
photo2_1.GUIDFilename = "E52D9F9F-30E0-49F4-BD4A-F9EEF7C01466.png";
context.PhotoMenus.AddOrUpdate(photo2_1);
context.SaveChanges();
}
/* Main Course starts here */
if (!context.Menus.Any(u => u.Type == DAL.MenusType.Main_Course))
{
Menu menu3 = new Menu();
menu3.Name = "CHICKEN BUTTER MASALA";
menu3.Description = "Boneless tandoori chicken cooked in onions, tomato, ginger, fresh coriander and finished with cream.";
menu3.Type = MenusType.Main_Course;
menu3.Price = 12.90;
menu3.WordAfterPrice = "/plate";
menu3.HotScale = HotLevel.Mild;
context.Menus.AddOrUpdate(menu3);
context.SaveChanges();
PhotoMenu photo3_0 = new PhotoMenu();
photo3_0.MenuID = 4;
photo3_0.Filename = "CHICKEN BUTTER MASALA_0.png";
photo3_0.GUIDFilename = "46B656A4-8353-41AE-85F2-1DF87A095639.png";
context.PhotoMenus.AddOrUpdate(photo3_0);
context.SaveChanges();
PhotoMenu photo3_1 = new PhotoMenu();
photo3_1.MenuID = 4;
photo3_1.Filename = "CHICKEN BUTTER MASALA_1.png";
photo3_1.GUIDFilename = "EE12E891-1597-427E-A9B2-4106B14EACDB.png";
context.PhotoMenus.AddOrUpdate(photo3_1);
context.SaveChanges();
PhotoMenu photo3_2 = new PhotoMenu();
photo3_2.MenuID = 4;
photo3_2.Filename = "CHICKEN BUTTER MASALA_2.png";
photo3_2.GUIDFilename = "454273D0-D239-46A7-AC90-DC2AFDCF0AA6.png";
context.PhotoMenus.AddOrUpdate(photo3_2);
context.SaveChanges();
Menu menu4 = new Menu();
menu4.Name = "ROGAN JOSH CHICKEN";
menu4.Description = "Lamb, chicken or beef pieces cooked in yogurt, tomato and spices - mild, medium or hot.";
menu4.Type = MenusType.Main_Course;
menu4.Price = 12.90;
menu4.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu4);
context.SaveChanges();
PhotoMenu photo4_0 = new PhotoMenu();
photo4_0.MenuID = 5;
photo4_0.Filename = "CHICKEN TIKKA_0.png";
photo4_0.GUIDFilename = "E52D9F9F-30E0-49F4-BD4A-F9EEF7C01466.png";
context.PhotoMenus.AddOrUpdate(photo4_0);
context.SaveChanges();
Menu menu5 = new Menu();
menu5.Name = "CHICKEN KORMA";
menu5.Description = "Boneless pieces of chicken cooked in cream and yoghurt and finished with cashew nut paste - mild.";
menu5.Type = MenusType.Main_Course;
menu5.Price = 14.90;
menu5.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu5);
context.SaveChanges();
PhotoMenu photo5_0 = new PhotoMenu();
photo5_0.MenuID = 6;
photo5_0.Filename = "CHICKEN_KORMA.png";
photo5_0.GUIDFilename = "9CF3E910-7ACE-4E58-9C5B-121127DEB7DD.png";
context.PhotoMenus.AddOrUpdate(photo5_0);
context.SaveChanges();
PhotoMenu photo5_1 = new PhotoMenu();
photo5_1.MenuID = 6;
photo5_1.Filename = "CHICKEN_KORMA.png";
photo5_1.GUIDFilename = "AF268FEC-40A8-4F07-82ED-2A16569B031D.png";
context.PhotoMenus.AddOrUpdate(photo5_1);
context.SaveChanges();
Menu menu6 = new Menu();
menu6.Name = "CHICKEN DOPIAZA";
menu6.Description = "Tender chicken pieces cooked with whole dried red chillies, sauteed onion, ginger and fresh coriander - medium hot.";
menu6.Type = MenusType.Main_Course;
menu6.Price = 14.90;
menu6.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu6);
context.SaveChanges();
PhotoMenu photo6_0 = new PhotoMenu();
photo6_0.MenuID = 7;
photo6_0.Filename = "CHICKEN_DOPIAZA.png";
photo6_0.GUIDFilename = "3B2FA8B0-EBC6-4CB8-90EC-15A43F740AC4.png";
context.PhotoMenus.AddOrUpdate(photo6_0);
context.SaveChanges();
PhotoMenu photo6_1 = new PhotoMenu();
photo6_1.MenuID = 7;
photo6_1.Filename = "CHICKEN_DOPIAZA.png";
photo6_1.GUIDFilename = "CB9D3887-A081-403D-AD1E-AB729503C9CB.png";
context.PhotoMenus.AddOrUpdate(photo6_1);
context.SaveChanges();
PhotoMenu photo6_2 = new PhotoMenu();
photo6_2.MenuID = 7;
photo6_2.Filename = "CHICKEN_DOPIAZA.png";
photo6_2.GUIDFilename = "FBFE59B2-258B-490F-A7F3-A10055E1CE32.png";
context.PhotoMenus.AddOrUpdate(photo6_2);
context.SaveChanges();
PhotoMenu photo6_3 = new PhotoMenu();
photo6_3.MenuID = 7;
photo6_3.Filename = "CHICKEN_DOPIAZA.png";
photo6_3.GUIDFilename = "A2796DAD-35AE-4040-8E58-1F094154A81F.png";
context.PhotoMenus.AddOrUpdate(photo6_3);
context.SaveChanges();
PhotoMenu photo6_4 = new PhotoMenu();
photo6_4.MenuID = 7;
photo6_4.Filename = "CHICKEN_DOPIAZA.png";
photo6_4.GUIDFilename = "035BAE4C-2F87-48E5-92B3-8A8D1002360C.png";
context.PhotoMenus.AddOrUpdate(photo6_4);
context.SaveChanges();
Menu menu7 = new Menu();
menu7.Name = "BHOONA GOSHT (Lamb / Beef)";
menu7.Description = "Lamb / beef marinated with garlic, ginger, capsicum and tomato, cooked in a hot pan to seal in the natural juices.- Med. Hot";
menu7.Type = MenusType.Main_Course;
menu7.Price = 16.90;
menu7.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu7);
context.SaveChanges();
PhotoMenu photo7_0 = new PhotoMenu();
photo7_0.MenuID = 8;
photo7_0.Filename = "BHOONA_GOSHT.png";
photo7_0.GUIDFilename = "C9389E29-791C-4D56-9430-68B1B4DA99D0.png";
context.PhotoMenus.AddOrUpdate(photo7_0);
context.SaveChanges();
Menu menu8 = new Menu();
menu8.Name = "ROCKLING TIKKA";
menu8.Description = "Succulent cubes of rockling with cream, yoghurt, lemon juice and chef’s selected spices, cooked in the tandoor.";
menu8.Type = MenusType.Main_Course;
menu8.Price = 17.50;
menu8.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu8);
context.SaveChanges();
PhotoMenu photo8_0 = new PhotoMenu();
photo8_0.MenuID = 9;
photo8_0.Filename = "ROCKLING_TIKKA.png";
photo8_0.GUIDFilename = "29512990-D9BD-4613-9E52-8FF50AF096A5.png";
context.PhotoMenus.AddOrUpdate(photo8_0);
context.SaveChanges();
Menu menu9 = new Menu();
menu9.Name = "BENGAL FISH CURRY";
menu9.Description = "Diced cubes of rockling cooked in a traditional Bengali style - Med.";
menu9.Type = MenusType.Main_Course;
menu9.Price = 17.90;
menu9.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu9);
context.SaveChanges();
PhotoMenu photo9_0 = new PhotoMenu();
photo9_0.MenuID = 10;
photo9_0.Filename = "BENGAL_FISH_CURRY.png";
photo9_0.GUIDFilename = "35DAC79C-6322-4317-ABD2-50A7D18AED33.png";
context.PhotoMenus.AddOrUpdate(photo9_0);
context.SaveChanges();
PhotoMenu photo9_1 = new PhotoMenu();
photo9_1.MenuID = 10;
photo9_1.Filename = "BENGAL_FISH_CURRY.png";
photo9_1.GUIDFilename = "1472844E-B704-4659-8311-7C01498F3D42.png";
context.PhotoMenus.AddOrUpdate(photo9_1);
context.SaveChanges();
PhotoMenu photo9_2 = new PhotoMenu();
photo9_2.MenuID = 10;
photo9_2.Filename = "BENGAL_FISH_CURRY.png";
photo9_2.GUIDFilename = "32D098D5-E18D-44E0-B896-62C3860F4742.png";
context.PhotoMenus.AddOrUpdate(photo9_2);
context.SaveChanges();
Menu menu10 = new Menu();
menu10.Name = "CRAB MASALA CURRY";
menu10.Description = "Crab meat lightly sauteed, tempered with mustard seeds, cooked with chopped onion and tomato, simmered in coconut milk with spices, garnished with shredded coconut and curry leaves.- Med / Hot.";
menu10.Type = MenusType.Main_Course;
menu10.Price = 19.90;
menu10.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu10);
context.SaveChanges();
}
/* Side Dishes starts here */
if (!context.Menus.Any(u => u.Type == DAL.MenusType.Side_Dishes))
{
Menu menu11 = new Menu();
menu11.Name = "Mango Chutney";
menu11.Description = "";
menu11.Type = MenusType.Side_Dishes;
menu11.Price = 3.50;
menu11.WordAfterPrice = "(small bowl)";
context.Menus.AddOrUpdate(menu11);
context.SaveChanges();
PhotoMenu photo11_0 = new PhotoMenu();
photo11_0.MenuID = 12;
photo11_0.Filename = "Mango_Chutney.png";
photo11_0.GUIDFilename = "E4CEF3A9-5C47-42BC-B5F4-50B3306D674F.png";
context.PhotoMenus.AddOrUpdate(photo11_0);
context.SaveChanges();
Menu menu12 = new Menu();
menu12.Name = "Mixed Pickles";
menu12.Description = "";
menu12.Type = MenusType.Side_Dishes;
menu12.Price = 3.50;
menu12.WordAfterPrice = "(small bowl)";
context.Menus.AddOrUpdate(menu12);
context.SaveChanges();
PhotoMenu photo12_0 = new PhotoMenu();
photo12_0.MenuID = 13;
photo12_0.Filename = "Mixed_Pickles.png";
photo12_0.GUIDFilename = "EE3484B8-38C7-4872-97D6-6E8A3EA7596D.png";
context.PhotoMenus.AddOrUpdate(photo12_0);
context.SaveChanges();
PhotoMenu photo12_1 = new PhotoMenu();
photo12_1.MenuID = 13;
photo12_1.Filename = "Mixed_Pickles.png";
photo12_1.GUIDFilename = "3A7D7035-BE3F-49FC-BAB2-2ED230D105EB.png";
context.PhotoMenus.AddOrUpdate(photo12_1);
context.SaveChanges();
}
/* Breads and Rice starts here */
if (!context.Menus.Any(u => u.Type == DAL.MenusType.Breads_and_Rice))
{
Menu menu13 = new Menu();
menu13.Name = "ZAFFARANI PULAO";
menu13.Description = "Basmati rice, tempered with cumin seeds in clarified butter and laced with saffron.";
menu13.Type = MenusType.Breads_and_Rice;
menu13.Price = 5.00;
menu13.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu13);
context.SaveChanges();
PhotoMenu photo13_0 = new PhotoMenu();
photo13_0.MenuID = 14;
photo13_0.Filename = "ZAFFARANI_PULAO.png";
photo13_0.GUIDFilename = "6A9DB57D-98C6-4542-9CF1-58414E6AE2F4.png";
context.PhotoMenus.AddOrUpdate(photo13_0);
context.SaveChanges();
Menu menu14 = new Menu();
menu14.Name = "HYDERABADI BIRIYANI(LAMB/ CHICKEN)";
menu14.Description = "Basmati rice cooked with diced lamb or chicken,Stock and specially prepared masala, garnished with fried onion.";
menu14.Type = MenusType.Breads_and_Rice;
menu14.Price = 11.50;
menu14.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu14);
context.SaveChanges();
Menu menu15 = new Menu();
menu15.Name = "VEGETABLE BIRIYANI";
menu15.Description = "Selection of seasonal vegetables cooked in a sealed pot with basmati rice and herbs.";
menu15.Type = MenusType.Breads_and_Rice;
menu15.Price = 11.50;
menu15.WordAfterPrice = "/plate";
context.Menus.AddOrUpdate(menu15);
context.SaveChanges();
PhotoMenu photo15_0 = new PhotoMenu();
photo15_0.MenuID = 16;
photo15_0.Filename = "HYDERABADI_BIRIYANI.png";
photo15_0.GUIDFilename = "38DE39D7-DCDD-4695-80F6-0396D8B6B9FD.png";
context.PhotoMenus.AddOrUpdate(photo15_0);
context.SaveChanges();
Menu menu16 = new Menu();
menu16.Name = "LONG GRAIN AROMATIC BASMATI RICE";
menu16.Description = "";
menu16.Type = MenusType.Breads_and_Rice;
menu16.Price = 11.50;
menu16.WordAfterPrice = "(small bowl)";
context.Menus.AddOrUpdate(menu16);
context.SaveChanges();
PhotoMenu photo16_0 = new PhotoMenu();
photo16_0.MenuID = 17;
photo16_0.Filename = "LONG_GRAIN_AROMATIC_BASMATI_RICE.png";
photo16_0.GUIDFilename = "984547A2-8357-42EA-A730-A927E463DA66.png";
context.PhotoMenus.AddOrUpdate(photo16_0);
context.SaveChanges();
Menu menu17 = new Menu();
menu17.Name = "NAAN";
menu17.Description = "Plain flour bread baked in the tandoor.";
menu17.Type = MenusType.Breads_and_Rice;
menu17.Price = 2.30;
menu17.WordAfterPrice = "/2pcs";
context.Menus.AddOrUpdate(menu17);
context.SaveChanges();
Menu menu18 = new Menu();
menu18.Name = "GARLIC NAAN";
menu18.Description = "Naan brushed with fresh garlic butter.";
menu18.Type = MenusType.Breads_and_Rice;
menu18.Price = 2.50;
menu18.WordAfterPrice = "/2pcs";
context.Menus.AddOrUpdate(menu18);
context.SaveChanges();
PhotoMenu photo18_0 = new PhotoMenu();
photo18_0.MenuID = 19;
photo18_0.Filename = "LONG_GRAIN_AROMATIC_BASMATI_RICE.png";
photo18_0.GUIDFilename = "827EDE4F-73F8-4D46-AB73-71092242A3A9.png";
context.PhotoMenus.AddOrUpdate(photo18_0);
context.SaveChanges();
PhotoMenu photo18_1 = new PhotoMenu();
photo18_1.MenuID = 19;
photo18_1.Filename = "LONG_GRAIN_AROMATIC_BASMATI_RICE.png";
photo18_1.GUIDFilename = "48531542-3DC3-4553-AB87-9630A320D366.png";
context.PhotoMenus.AddOrUpdate(photo18_1);
context.SaveChanges();
Menu menu19 = new Menu();
menu19.Name = "PESHAWARI NAAN";
menu19.Description = "Naan cooked with assorted dry fruits and nuts.";
menu19.Type = MenusType.Breads_and_Rice;
menu19.Price = 5.00;
menu19.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu19);
context.SaveChanges();
PhotoMenu photo19_0 = new PhotoMenu();
photo19_0.MenuID = 20;
photo19_0.Filename = "PESHAWARI_NAAN.png";
photo19_0.GUIDFilename = "99BB525B-8C9F-450A-9001-C649526CF2D1.png";
context.PhotoMenus.AddOrUpdate(photo19_0);
context.SaveChanges();
PhotoMenu photo19_1 = new PhotoMenu();
photo19_1.MenuID = 20;
photo19_1.Filename = "PESHAWARI_NAAN.png";
photo19_1.GUIDFilename = "29FF8BE9-FD94-44EB-AFAD-C29B3A583404.png";
context.PhotoMenus.AddOrUpdate(photo19_1);
context.SaveChanges();
Menu menu20 = new Menu();
menu20.Name = "PANEER POTATO KULCHA";
menu20.Description = "Bread stuffed with spiced paneer, potato, onion, garlic, coriander and chillies.";
menu20.Type = MenusType.Breads_and_Rice;
menu20.Price = 4.90;
menu20.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu20);
context.SaveChanges();
Menu menu21 = new Menu();
menu21.Name = "KHEEMA KULCHA";
menu21.Description = "Bread stuffed with minced lamb, spices and herbs.";
menu21.Type = MenusType.Breads_and_Rice;
menu21.Price = 4.00;
menu21.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu21);
context.SaveChanges();
PhotoMenu photo21_0 = new PhotoMenu();
photo21_0.MenuID = 22;
photo21_0.Filename = "KHEEMA_KULCHA.png";
photo21_0.GUIDFilename = "B9C88C79-78DC-4787-85ED-238C6B945ECA.png";
context.PhotoMenus.AddOrUpdate(photo21_0);
context.SaveChanges();
Menu menu22 = new Menu();
menu22.Name = "PARATHA";
menu22.Description = "Flaky wholemeal indian bread lightly fried in butter.";
menu22.Type = MenusType.Breads_and_Rice;
menu22.Price = 2.30;
menu22.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu22);
context.SaveChanges();
PhotoMenu photo22_0 = new PhotoMenu();
photo22_0.MenuID = 23;
photo22_0.Filename = "PARATHA.png";
photo22_0.GUIDFilename = "983B99CC-63AA-4C5C-957D-DA4B9FC27BC0.png";
context.PhotoMenus.AddOrUpdate(photo22_0);
context.SaveChanges();
Menu menu23 = new Menu();
menu23.Name = "ROTI";
menu23.Description = "Stone ground wholemeal indian bread baked in the tandoor.";
menu23.Type = MenusType.Breads_and_Rice;
menu23.Price = 2.50;
menu23.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu23);
context.SaveChanges();
PhotoMenu photo23_0 = new PhotoMenu();
photo23_0.MenuID = 24;
photo23_0.Filename = "ROTI.png";
photo23_0.GUIDFilename = "06409BB6-B146-4D3C-A7FD-3B02584177E7.png";
context.PhotoMenus.AddOrUpdate(photo23_0);
context.SaveChanges();
PhotoMenu photo23_1 = new PhotoMenu();
photo23_1.MenuID = 24;
photo23_1.Filename = "ROTI.png";
photo23_1.GUIDFilename = "E7D15EBD-CF15-444D-A687-CC355BC37037.png";
context.PhotoMenus.AddOrUpdate(photo23_1);
context.SaveChanges();
}
/* Desserts starts here */
if (!context.Menus.Any(u => u.Type == DAL.MenusType.Desserts))
{
Menu menu24 = new Menu();
menu24.Name = "MANGO / PISTA KULFI";
menu24.Description = "Special indian ice cream with saffron, cardamom powder made with mango / pistachio nuts.";
menu24.Type = MenusType.Breads_and_Rice;
menu24.Price = 4.90;
menu24.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu24);
context.SaveChanges();
PhotoMenu photo24_0 = new PhotoMenu();
photo24_0.MenuID = 25;
photo24_0.Filename = "MANGO_PISTA_KULFI.png";
photo24_0.GUIDFilename = "2F7426AC-6ABD-47D7-B1FA-EC9790DEF010.png";
context.PhotoMenus.AddOrUpdate(photo24_0);
context.SaveChanges();
Menu menu25 = new Menu();
menu25.Name = "GULAB JAMUN (2 PIECES)";
menu25.Description = "Cottage cheese balls fried in ghee, soaked in sugar syrup.";
menu25.Type = MenusType.Breads_and_Rice;
menu25.Price = 4.90;
menu25.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu25);
context.SaveChanges();
PhotoMenu photo25_0 = new PhotoMenu();
photo25_0.MenuID = 26;
photo25_0.Filename = "GULAB_JAMUN.png";
photo25_0.GUIDFilename = "A089B00B-0BB3-4597-A78E-84970A226ADA.png";
context.PhotoMenus.AddOrUpdate(photo25_0);
context.SaveChanges();
PhotoMenu photo25_1 = new PhotoMenu();
photo25_1.MenuID = 26;
photo25_1.Filename = "GULAB_JAMUN.png";
photo25_1.GUIDFilename = "CCF20935-20E8-4E0A-B189-87DE6011085B.png";
context.PhotoMenus.AddOrUpdate(photo25_1);
context.SaveChanges();
PhotoMenu photo25_2 = new PhotoMenu();
photo25_2.MenuID = 26;
photo25_2.Filename = "GULAB_JAMUN.png";
photo25_2.GUIDFilename = "45ED9507-4D27-48AE-8B68-3F750015F4DE.png";
context.PhotoMenus.AddOrUpdate(photo25_2);
context.SaveChanges();
}
/* Drinks starts here */
if (!context.Menus.Any(u => u.Type == DAL.MenusType.Drinks))
{
Menu menu26 = new Menu();
menu26.Name = "LASSI Sweetened yoghurt drink";
menu26.Description = "";
menu26.Type = MenusType.Drinks;
menu26.Price = 4.50;
menu26.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu26);
context.SaveChanges();
PhotoMenu photo26_0 = new PhotoMenu();
photo26_0.MenuID = 27;
photo26_0.Filename = "LASSI_Sweetened_Yoghurt_Drink.png";
photo26_0.GUIDFilename = "0340B7C7-E51A-43E6-AD0E-7982E028EF40.png";
context.PhotoMenus.AddOrUpdate(photo26_0);
context.SaveChanges();
PhotoMenu photo26_1 = new PhotoMenu();
photo26_1.MenuID = 27;
photo26_1.Filename = "LASSI_Sweetened_Yoghurt_Drink.png";
photo26_1.GUIDFilename = "3D1F13CF-0707-4EDF-9871-8C51BC19ADC8.png";
context.PhotoMenus.AddOrUpdate(photo26_1);
context.SaveChanges();
Menu menu27 = new Menu();
menu27.Name = "MANGO LASSI";
menu27.Description = "Yoghurt drink made with mango pulp.";
menu27.Type = MenusType.Drinks;
menu27.Price = 5.50;
menu27.WordAfterPrice = "";
context.Menus.AddOrUpdate(menu27);
context.SaveChanges();
PhotoMenu photo27_0 = new PhotoMenu();
photo27_0.MenuID = 28;
photo27_0.Filename = "MANGO LASSI_0.png";
photo27_0.GUIDFilename = "1C0EA585-809A-41CA-8BB2-FFAD524EFB0F.png";
context.PhotoMenus.AddOrUpdate(photo27_0);
context.SaveChanges();
PhotoMenu photo27_1 = new PhotoMenu();
photo27_1.MenuID = 28;
photo27_1.Filename = "MANGO LASSI_0.png";
photo27_1.GUIDFilename = "52A33270-A843-4599-B294-FF24C918EC11.png";
context.PhotoMenus.AddOrUpdate(photo27_1);
context.SaveChanges();
PhotoMenu photo27_2 = new PhotoMenu();
photo27_2.MenuID = 28;
photo27_2.Filename = "MANGO LASSI_0.png";
photo27_2.GUIDFilename = "667D3545-AE50-4813-B930-F825D2FEF5C4.png";
context.PhotoMenus.AddOrUpdate(photo27_2);
context.SaveChanges();
PhotoMenu photo27_3 = new PhotoMenu();
photo27_3.MenuID = 28;
photo27_3.Filename = "MANGO LASSI_0.png";
photo27_3.GUIDFilename = "CDC40A6D-5918-41CC-B3A6-227D7BAD9849.png";
context.PhotoMenus.AddOrUpdate(photo27_3);
context.SaveChanges();
}
/* Seeding the Reservation table */
if (context.Reservations.Count() == 0)
{
Reservation reservation_0 = new Reservation();
reservation_0.UserID = context.Users.Where(w => w.UserName.Contains("happycustomer")).FirstOrDefault().Id;
reservation_0.PaymentMethod = 0;
reservation_0.NumberOfPeople = "1-5";
reservation_0.Name = "Gracias Birthday Party";
reservation_0.Environment = 1;
reservation_0.Date = new DateTime(2014, 12, 31, 17, 30, 0);
reservation_0.CreatedDate = DateTime.Today;
context.Reservations.Add(reservation_0);
Reservation reservation_1 = new Reservation();
reservation_1.UserID = context.Users.Where(w => w.UserName.Contains("happycustomer")).FirstOrDefault().Id;
reservation_1.PaymentMethod = 1;
reservation_1.NumberOfPeople = "1-5";
reservation_1.Name = "Reno and Pete Wedding";
reservation_1.Environment = 0;
reservation_1.Date = new DateTime(2015, 1, 10, 10, 0, 0);
reservation_1.CreatedDate = DateTime.Today;
context.Reservations.Add(reservation_1);
Reservation reservation_2 = new Reservation();
reservation_2.UserID = context.Users.Where(w => w.UserName.Contains("happycustomer")).FirstOrDefault().Id;
reservation_2.PaymentMethod = 2;
reservation_2.NumberOfPeople = "5-10";
reservation_2.Name = "Rianka Baptism";
reservation_2.Environment = 1;
reservation_2.Date = new DateTime(2015, 3, 18, 10, 0, 0);
reservation_2.CreatedDate = DateTime.Today;
context.Reservations.Add(reservation_2);
Reservation reservation_3 = new Reservation();
reservation_3.UserID = context.Users.Where(w => w.UserName.Contains("happycustomer")).FirstOrDefault().Id;
reservation_3.PaymentMethod = 0;
reservation_3.NumberOfPeople = "20-40";
reservation_3.Name = "Martinsen Bachelor Party";
reservation_3.Environment = 1;
reservation_3.Date = new DateTime(2015, 2, 10, 20, 0, 0);
reservation_3.CreatedDate = DateTime.Today;
context.Reservations.Add(reservation_3);
context.SaveChanges();
}
}
