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;
}
