public MenuPage GetMenuInfo() { var model = new MenuPage(); using (TomasosContext db = new TomasosContext()) { model.Matratter = db.Matratt.ToList(); model.Ingredins.MatrattProdukt = db.MatrattProdukt.ToList(); model.Ingredienses = db.Produkt.ToList(); model.mattratttyper = db.MatrattTyp.ToList(); } return(model); }
public OrderDetailView GetOrderDetail(int id) { var model = new OrderDetailView(); using (TomasosContext db = new TomasosContext()) { model.Order = db.Bestallning.FirstOrDefault(r => r.BestallningId == id); model.Order.Kund = db.Kund.FirstOrDefault(r => r.KundId == model.Order.KundId); model.Order.BestallningMatratt = db.BestallningMatratt.Where(r => r.BestallningId == id).ToList(); model.Matratter = db.Matratt.ToList(); } return(model); }
public void Delete(Kund c) { using (TomasosContext db = new TomasosContext()) { var order = db.Bestallning.Where(r => r.KundId == c.KundId); var bestallningmatratt = db.BestallningMatratt.Where(r => r.Bestallning.KundId == c.KundId); db.BestallningMatratt.RemoveRange(bestallningmatratt); db.Bestallning.RemoveRange(order); db.Kund.Remove(c); db.SaveChanges(); } }
public void UpdateRoleForUser(string changeRoleTo, string id, UserManager <IdentityUser> userManager, RoleManager <IdentityRole> roleManager) { using (TomasosContext db = new TomasosContext()) { var userToDelete = db.UserRoles.FirstOrDefault(r => r.UserId == id); db.UserRoles.Remove(userToDelete); db.SaveChanges(); var userRoles = db.Roles.FirstOrDefault(r => r.Name == changeRoleTo); userToDelete.RoleId = userRoles.Id; userToDelete.UserId = id; db.UserRoles.Add(userToDelete); db.SaveChanges(); } }
public void DeleteOrder(int id) { using (TomasosContext db = new TomasosContext()) { var order = db.Bestallning.FirstOrDefault(r => r.BestallningId == id); var bestallningmatratt = db.BestallningMatratt.Where(r => r.BestallningId == id); db.BestallningMatratt.RemoveRange(bestallningmatratt); db.Bestallning.Remove(order); db.SaveChanges(); } }
public OrdersViewModel GetOrdersAllOrders() { var model = new OrdersViewModel(); using (TomasosContext db = new TomasosContext()) { model.Orders = db.Bestallning.OrderByDescending(r => r.BestallningDatum).ToList(); foreach (var order in model.Orders) { order.Kund = db.Kund.FirstOrDefault(r => r.KundId == order.KundId); } } return(model); }
public bool AddIngrediens(Produkt produkt) { using (TomasosContext db = new TomasosContext()) { db.Produkt.FirstOrDefault(r => r.ProduktNamn == produkt.ProduktNamn); var ingrediens = db.Produkt.FirstOrDefault(r => r.ProduktNamn == produkt.ProduktNamn); if (ingrediens != null) { return(false); } db.Produkt.Add(produkt).Context.SaveChanges(); return(true); } }
public void Delete(int id) { using (TomasosContext db = new TomasosContext()) { var dish = db.Matratt.Include(r => r.MatrattProdukt) .Include(r => r.BestallningMatratt) .FirstOrDefault(r => r.MatrattId == id); db.MatrattProdukt.RemoveRange(dish.MatrattProdukt.ToList()); db.BestallningMatratt.RemoveRange(dish.BestallningMatratt.ToList()); db.Matratt.Remove(dish); db.SaveChanges(); } }
public void UpdateUser(Kund user, int customerid) { using (TomasosContext db = new TomasosContext()) { var customer = GetById(customerid); customer.Namn = user.Namn; customer.Gatuadress = user.Gatuadress; customer.Postnr = user.Postnr; customer.Postort = user.Postort; customer.Email = user.Email; customer.Telefon = user.Telefon; customer.AnvandarNamn = user.AnvandarNamn; customer.Losenord = user.Losenord; db.Kund.Update(customer); db.SaveChanges(); } }
private static void SeedProducts(TomasosContext context) { if (context.Matratt.ToList().Count == 1) { context.Matratt.AddRange( new Matratt() { MatrattNamn = "Hawaii", Beskrivning = "Fruktig och perfekt", Pris = 76, MatrattTyp = 1 }, new Matratt() { MatrattNamn = "Vesuvio", Beskrivning = "Lätt med få ingredienser", Pris = 55, MatrattTyp = 1 }, new Matratt() { MatrattNamn = "Capriccosa", Beskrivning = "Färska champinjoner med frisk nordisk smak", Pris = 79, MatrattTyp = 1 }, new Matratt() { MatrattNamn = "Kebabpizza", Beskrivning = "Kött i stora mängder med stark sås", Pris = 99, MatrattTyp = 1 }, new Matratt() { MatrattNamn = "Al tonno", Beskrivning = "Fisk för fiskälskare", Pris = 60, MatrattTyp = 1 } ); context.SaveChanges(); } }
public OrdersViewModel GetOrdersUnDelivered() { var model = new OrdersViewModel(); using (TomasosContext db = new TomasosContext()) { model.Orders = db.Bestallning.Where(r => r.Levererad == false) .OrderByDescending(r => r) .ToList(); foreach (var order in model.Orders) { var customer = new Kund(); order.Kund = db.Kund.FirstOrDefault(r => r.KundId == order.KundId); } } return(model); }
public UpdateViewModel(TomasosContext context, int id) { CurrentRatt = context.Matratt.SingleOrDefault(m => m.MatrattId == id); CurrentProdukter = (from p in context.Produkt join mp in context.MatrattProdukt on p.ProduktId equals mp.ProduktId join m in context.Matratt on mp.MatrattId equals m.MatrattId where m.MatrattId == id select p).ToList(); foreach (var item in CurrentProdukter) { Prodlist.Add(new SelectListItem(item.ProduktNamn, item.ProduktId.ToString())); } foreach (var item in context.Produkt) { AllProdlist.Add(new SelectListItem(item.ProduktNamn, item.ProduktId.ToString())); } AllProdlist = AllProdlist.OrderBy(p => p.Text).ToList(); }
public void SaveOrder(List <Matratt> matratter, int userid) { var customer = GetById(userid); var totalmoney = GetTotalPayment(matratter); var bestallning = new Bestallning() { BestallningDatum = DateTime.Now, KundId = customer.KundId, Totalbelopp = totalmoney, Levererad = false }; using (TomasosContext db = new TomasosContext()) { db.Add(bestallning); db.SaveChanges(); } SaveBestallningMatratter(matratter); }
public AddItemViewModel(TomasosContext context) { Matratttyper = new List <SelectListItem> { new SelectListItem("Pizza", "1"), new SelectListItem("Pasta", "2"), new SelectListItem("Sallad", "3") }; Ingredienslista = new List <SelectListItem>(); foreach (var item in context.Produkt) { Ingredienslista.Add(new SelectListItem(item.ProduktNamn, item.ProduktId.ToString())); } Ingredienslista = Ingredienslista.OrderBy(p => p.Text).ToList(); Ingredienser = new List <MultiSelectList> { new MultiSelectList(Ingredienslista) }; }
public async Task <UsersViewModel> GetAllUsers(List <Kund> customers, RoleManager <IdentityRole> roleManager, string roleToSearch, UserManager <IdentityUser> userManager) { var usersregitrered = new List <IdentityUser>(); using (TomasosContext db = new TomasosContext()) { usersregitrered = db.Users.ToList(); } var userViewModel = new UsersViewModel(); foreach (var customer in customers) { var userInfo = new UserRole(); var user = usersregitrered.FirstOrDefault(r => r.UserName == customer.AnvandarNamn); var role = await userManager.GetRolesAsync(user); var rolename = roleManager.FindByNameAsync(role[0]); userInfo.RoleName = role[0]; userInfo.Username = user.UserName; userInfo.RoleID = rolename.Result.Id; userInfo.Adress = customer.Gatuadress; userInfo.Name = customer.Namn; userInfo.UserID = user.Id; if (userInfo.RoleName == roleToSearch || roleToSearch == "All") { userViewModel.Customers.Add(userInfo); } } var list = roleManager.Roles; foreach (var item in list) { userViewModel.Roles.Add(item.Name); } return(userViewModel); }
public void SaveBestallningMatratter(List <Matratt> matratter) { var bestallningsmatrattlista = new List <BestallningMatratt>(); var id = 0; var first = 0; var count = 0; var nymatratter = matratter.OrderBy(r => r.MatrattNamn).ToList(); using (TomasosContext db = new TomasosContext()) { var listbestallning = db.Bestallning.OrderByDescending(r => r.BestallningDatum).ToList(); for (var i = 0; i < nymatratter.Count; i++) { if (id != nymatratter[i].MatrattId) { first++; var best = new BestallningMatratt(); id = nymatratter[i].MatrattId; best.BestallningId = listbestallning[0].BestallningId; best.MatrattId = nymatratter[i].MatrattId; best.Antal = 1; bestallningsmatrattlista.Add(best); } else if (id == nymatratter[i].MatrattId) { count = first - 1; bestallningsmatrattlista[count].Antal++; } } foreach (var item in bestallningsmatrattlista) { db.Add(item); db.SaveChanges(); } } }
public void EditCustomer(TomasosContext context, KundViewModel editedCustomer, Kund currentCustomer) { //var string //Kund changedCustomer = new Kund() //{ // KundId = currentCustomer.KundId, // AnvandarNamn = editedCustomer.AnvandarNamn, // Email = editedCustomer.Email, // Gatuadress = editedCustomer.Gatuadress, // Postnr = editedCustomer.Postnr, // Postort = editedCustomer.Postort, // Namn = editedCustomer.Namn, // Telefon = editedCustomer.Telefon, // Losenord = editedCustomer.Losenord //}; //foreach (PropertyInfo propertyInfo in currentCustomer.GetType().GetProperties()) //{ // if (propertyInfo.GetValue(changedCustomer, null) != null) // propertyInfo.SetValue(currentCustomer, propertyInfo.GetValue(changedCustomer, null), null); //} // context.Entry(currentCustomer).CurrentValues.SetValues(changedCustomer); context.SaveChanges(); }
public ManageRolesViewModel(TomasosContext context) { var RegUsers = (from k in context.Kund join i in context.AspNetUsers on k.IdentityId equals i.Id join ur in context.AspNetUserRoles on i.Id equals ur.UserId join r in context.AspNetRoles on ur.RoleId equals r.Id where r.Name == "Regular" select k).ToList(); var PremUsers = (from k in context.Kund join i in context.AspNetUsers on k.IdentityId equals i.Id join ur in context.AspNetUserRoles on i.Id equals ur.UserId join r in context.AspNetRoles on ur.RoleId equals r.Id where r.Name == "Premium" select k).ToList(); foreach (var item in RegUsers) { RegularUsers.Add(new SelectListItem(item.Namn, item.KundId.ToString())); } foreach (var item in PremUsers) { PremiumUsers.Add(new SelectListItem(item.Namn, item.KundId.ToString())); } }
public ProduktService(TomasosContext context) { _context = context; }
public AccountController(TomasosContext context) { _context = context; }
public OrderController(TomasosContext context) { _context = context; }
public AdministrationController(RoleManager <IdentityRole> roleManager, UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, TomasosContext context) { _roleManager = roleManager; _userManager = userManager; _signInManager = signInManager; _context = context; }
public DishRepository(TomasosContext context) { _context = context; }
public AdminController(TomasosContext dbContext, UserManager <ApplicationUser> userManager) { this.dbContext = dbContext; this.userManager = userManager; }
public EFCustomerRepository(TomasosContext context) { _context = context; }
public AdminController(UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, TomasosContext context) { _signInManager = signInManager; _userManager = userManager; _context = context; }
public MatController( TomasosContext context) { _context = context; }
public HomeController(TomasosContext context) { _context = context; }
public ManageOrdersViewModel(TomasosContext context) { FinishedOrders = context.Bestallning.Where(o => o.Levererad == true).Include(b => b.Kund).ToList(); ActiveOrders = context.Bestallning.Where(o => o.Levererad == false).Include(b => b.Kund).ToList(); }
public UserService(TomasosContext context) { _context = context; }