public virtual Product GetProductById(int productId) { using (var context = new JPNFinalProjectContext()) { return(context.Product.Include(x => x.ProductCategory).Where(x => x.ProductId == productId).Single()); } }
public virtual ProductCategory GetCategoryById(int id) { using (var context = new JPNFinalProjectContext()) { return(context.ProductCategory.Where(x => x.ProductCategoryId == id).Include(x => x.ParentProductCategory).Single()); } }
public virtual List <Product> GetAllProducts() { using (var context = new JPNFinalProjectContext()) { return(context.Product.Include(x => x.ProductCategory).ToList()); } }
public virtual List <Business> GetBusinesses() { using (var context = new JPNFinalProjectContext()) { return(context.Business.Include(x => x.Address).ToList()); } }
public virtual int SaveOrder(Order order) { using (var context = new JPNFinalProjectContext()) { context.Order.Add(order); context.SaveChanges(); return(context.Order.Last().OrderId); } }
public virtual Person GetPersonByOrderId(int orderId) { using (var context = new JPNFinalProjectContext()) { var personId = context.Order.Where(x => x.OrderId == orderId).Select(x => x.PersonId).Single(); return(context.Person.Where(x => x.PersonId == personId).Include(x => x.Address).Select(x => x).Single()); } }
public virtual void AddCategory(ProductCategory category) { using (var context = new JPNFinalProjectContext()) { context.Add(category); context.SaveChanges(); } }
public virtual int SavePerson(Person person) { using (var context = new JPNFinalProjectContext()) { context.Person.Add(person); context.SaveChanges(); return(context.Person.Last().PersonId); } }
public virtual List <OrderProduct> GetOrderProducts(int orderId) { using (var context = new JPNFinalProjectContext()) { return(context.OrderProduct.Where(x => x.OrderId == orderId).Select(x => x) .Include(x => x.Product) .ToList()); } }
public virtual Business GetBusinessOrder(int orderId) { using (var context = new JPNFinalProjectContext()) { return(context.BusinessOrder.Where(x => x.OrderId == orderId) .Select(x => x.Business) .Single()); } }
public virtual int SaveBusiness(Business business) { using (var context = new JPNFinalProjectContext()) { context.Business.Add(business); context.SaveChanges(); return(context.Business.Last().BusinessId); } }
public virtual List <Business> GetBusinessesByPostal(string postalCode) { using (var context = new JPNFinalProjectContext()) { return(context.Business .Where(x => x.Address.PostalCode == postalCode) .Include(x => x.Address) .ToList()); } }
public virtual void SaveOrderProduct(List <OrderProduct> orderProducts) { using (var context = new JPNFinalProjectContext()) { foreach (var op in orderProducts) { context.OrderProduct.Add(op); } context.SaveChanges(); } }
public virtual void AddRandomProduct(Product input, int CategoryID) { using (var context = new JPNFinalProjectContext()) { var cat = context.ProductCategory.FirstOrDefault(x => x.ProductCategoryId == CategoryID); input.ProductCategory = cat; context.Product.Add(input); context.SaveChanges(); } }
public virtual void SaveBusinessOrder(int businessId, int orderId) { using (var context = new JPNFinalProjectContext()) { BusinessOrder entity = new BusinessOrder() { BusinessId = businessId, OrderId = orderId }; context.BusinessOrder.Add(entity); context.SaveChanges(); } }
public virtual List <ProductCategory> GetAllCategoriesWithProducts() { using (var context = new JPNFinalProjectContext()) { return(context.ProductCategory .Include(x => x.Product) .Include(x => x.ParentProductCategory) .Where(x => x.Product.Count != 0) .ToList()); } }
public virtual List <Order> GetOrders() { using (var context = new JPNFinalProjectContext()) { return(context.Order .Include(x => x.Person) .Include(x => x.Person.Address) .Include(x => x.BusinessOrder) .Include(x => x.OrderProduct) .ToList()); } }
public virtual List <Product> GetAllProductsByIdV2(List <OrderProduct> orderProducts) { using (var context = new JPNFinalProjectContext()) { List <Product> products = new List <Product>(); foreach (var op in orderProducts) { var p = context.Product.Where(x => x.ProductId == op.ProductId).Select(x => x).Single(); products.Add(p); } return(products); } }
public virtual void DeleteOrder(int orderId) { using (var context = new JPNFinalProjectContext()) { var businessOrder = context.BusinessOrder.Where(x => x.OrderId == orderId).Select(x => x).Single(); context.BusinessOrder.Remove(businessOrder); var orderProducts = context.OrderProduct.Where(x => x.OrderId == orderId).Select(x => x).ToList(); orderProducts.ForEach(x => context.OrderProduct.Remove(x)); var order = context.Order.Where(x => x.OrderId == orderId).Select(x => x).Single(); var person = context.Person.Where(x => x.PersonId == order.PersonId).Select(x => x).Single(); context.Person.Remove(person); context.Order.Remove(order); context.SaveChanges(); } }
public virtual void DeleteProductsFromOrder(int orderId, List <int> productIds) { using (var context = new JPNFinalProjectContext()) { foreach (var pId in productIds) { foreach (var op in context.OrderProduct.Where(x => x.OrderId == orderId).Select(x => x).ToList()) { if (op.ProductId == pId) { context.OrderProduct.Remove(op); context.SaveChanges(); } } } var priceSum = context.OrderProduct.Where(x => x.OrderId == orderId).Select(x => x.Price).ToList().Sum(); var VATFromPrice = (priceSum / 100) * 25; var priceWithVAT = priceSum + VATFromPrice; context.Order.Where(x => x.OrderId == orderId).Select(x => x).Single().TotalPrice = priceWithVAT; context.SaveChanges(); } }
public static void Seed() { var streets = new List <string>() { "Møllebakken 17", "Møllebakken 48", "Bakkelunden 92", "Præstelund 60", "Mølleløkken 55" }; var postalcodes = new List <string>() { "5260", "5250", "5700", "5800", "5000" }; var cities = new List <string>() { "Odense S", "Odense SV", "Svendborg", "Nyborg", "Odense C" }; var businessNames = new List <string>() { "Matas Odense S", "Matas Odense C", "Matas Nyborg", "Matas Svendborg" }; var phonenumbers = new List <string>() { "61634047", "43257692", "78593871", "12893738", "56784721" }; var businessEmail = new List <string>() { "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**" }; var personNames = new List <string>() { "Ida Iversen", "Mads Moelgaard", "Christa Christensen", "Lars Lersø", "Jette Jerspersen" }; var categoryNames = new List <string>() { "Barbering", "Skraber", "Hudpleje", "Ansigtpleje" }; // Creating using (var context = new JPNFinalProjectContext()) { //address for (int i = 0; i < streets.Count; i++) { context.Address.Add(new Address() { Street = streets[i], PostalCode = postalcodes[i], City = cities[i], Country = "Denmark" }); } //business context.SaveChanges(); for (int i = 0; i < businessNames.Count; i++) { context.Business.Add(new Business() { Name = businessNames[i], Address = context.Address.Where(x => x.Street == streets[i]).FirstOrDefault(), Phone = phonenumbers[i], Email = businessEmail[i], OperationalHour = "24/7" }); } //person context.SaveChanges(); for (int i = 0; i < streets.Count; i++) { context.Person.Add(new Person() { Name = personNames[i], Email = "*****@*****.**", Password = "******", Phone = phonenumbers[i], Type = "????", Address = context.Address.Where(x => x.Street == streets[i]).FirstOrDefault() }); } context.SaveChanges(); // Productcategories context.ProductCategory.Add(new ProductCategory() { Name = "Barbering", ParentProductCategory = null }); context.ProductCategory.Add(new ProductCategory() { Name = "Skraber", ParentProductCategory = context.ProductCategory.Where(x => x.Name == "Barbering").FirstOrDefault() }); context.ProductCategory.Add(new ProductCategory() { Name = "Hudpleje", ParentProductCategory = null }); context.ProductCategory.Add(new ProductCategory() { Name = "Ansigtpleje", ParentProductCategory = context.ProductCategory.Where(x => x.Name == "Hudpleje").FirstOrDefault() }); context.SaveChanges(); // products context.Product.Add(new Product() { Name = "Matas Fugtighedscreme 250 ml", Price = 54, Description = "Matas Fugtighedscreme 250 ml", ItemNumber = "34897537", Amount = 500, DeliveryTime = new DateTimeOffset(), ProductCategory = context.ProductCategory.Where(x => x.Name == "Ansigtpleje").FirstOrDefault() }); context.Product.Add(new Product() { Name = "baKblade barberblade", Price = 129, Description = "3-pak barberblade til baKblade rygskraber", ItemNumber = "34297537", Amount = 50, DeliveryTime = new DateTimeOffset(), ProductCategory = context.ProductCategory.Where(x => x.Name == "Skraber").FirstOrDefault() }); context.Product.Add(new Product() { Name = "Barberians cph, Barber Kniv", Price = 700, Description = "Barberians cph, Barber Kniv", ItemNumber = "14297537", Amount = 5, DeliveryTime = new DateTimeOffset(), ProductCategory = context.ProductCategory.Where(x => x.Name == "Skraber").FirstOrDefault() }); context.SaveChanges(); // Product product context.BusinessProduct.Add(new BusinessProduct() { Business = context.Business.Where(x => x.Name == "Matas Odense S").FirstOrDefault(), Product = context.Product.Where(x => x.Name == "Barberians cph, Barber Kniv").FirstOrDefault() }); context.BusinessProduct.Add(new BusinessProduct() { Business = context.Business.Where(x => x.Name == "Matas Nyborg").FirstOrDefault(), Product = context.Product.Where(x => x.Name == "baKblade barberblade").FirstOrDefault() }); context.BusinessProduct.Add(new BusinessProduct() { Business = context.Business.Where(x => x.Name == "Matas Svendborg").FirstOrDefault(), Product = context.Product.Where(x => x.Name == "Matas Fugtighedscreme 250 ml").FirstOrDefault() }); context.SaveChanges(); } }
public virtual Order GetOrderByOrderNumber(int orderId) { using (var context = new JPNFinalProjectContext()) { return(context.Order.Include(x => x.Person).Include(x => x.Person.Address).Include(x => x.BusinessOrder).Include(x => x.OrderProduct).Where(x => x.OrderId == orderId).Select(x => x).Single()); } }
public virtual Business GetBusinessById(int id) { using (var context = new JPNFinalProjectContext()) { return(context.Business.Where(x => x.BusinessId == id).Select(x => x).Include(x => x.Address).First()); } }