private Order GetOrderById(int orderId) { var order = (from o in orderRepository.Query() where o.OrderId == orderId select o).SingleOrDefault(); return(order); }
public int CheckCustomerExists(string email, string pass) { int p = customerRepository.Count(); int q = customerRepository.Query().Where(x => x.Email == email && x.Parola == pass).Count(); if (q != 0) { int id = customerRepository.Query().Where(x => x.Email == email && x.Parola == pass).Select(x => x.CustomerId).FirstOrDefault(); return(id); } return(-1); }
public static int CheckCustomerExists(string email, string pass) { var data = from c in customerRepository.Query() where c.Email.Equals(email) select c; int q = customerRepository.Query().Where(x => x.Email == email && x.Parola == pass).Count(); if (q != 0) { int id = customerRepository.Query().Where(x => x.Email == email && x.Parola == pass).Select(x => x.CustomerId).FirstOrDefault(); return(id); } return(-1); }
public List <Product> GetProductsByName(string productName) { var products = (from p in productRepository.Query() where p.Name.Contains(productName) select p).ToList(); return(products); }
public List <Product> GetProductsOfOrder(int orderNumber) { //Have to run the queries separate as each repository uses a different database context and thus I cannot use join linq queries var productIds = (from op in orderProductRepository.Query() where op.OrderId == orderNumber select op.ProductId).ToList(); var products = (from p in productRepository.Query() where productIds.Contains(p.ProductId) select p).ToList(); return(products); }
public void UpdateOrderTotalPrice(int orderId) { var orderedProducts = (from op in orderProductRepository.Query() where op.OrderId == orderId select new { op.ProductId, op.Quantity }).ToList(); var products = (from p in productRepository.Query() select new { p.ProductId, p.Price }).ToList(); decimal price = 0; foreach (var product in orderedProducts) { var prod = products.SingleOrDefault(x => x.ProductId == product.ProductId); price += prod.Price * product.Quantity; } Order order = GetOrderById(orderId); order.TotalPrice = price; orderRepository.Update(order); }
static void Main(string[] args) { //Testing the OrderService EntityIO <Order> orderRepository = new EntityIO <Order>(); Console.WriteLine(orderRepository.Count()); Order ord = new Entities.Order(); ord.OrderDate = DateTime.Today; ord.ShipmentDate = DateTime.Today.AddDays(3); ord.CustomerId = 3; ord.TotalPrice = 0M; orderRepository.Insert(ord); var order = (from o in orderRepository.Query() where o.OrderId == 5 select o).SingleOrDefault(); Console.WriteLine(String.Format("Order with the id {0} has a total price of {1}, the order was made on {2} and the shipment is estimated on {3}", order.OrderId, order.TotalPrice, order.OrderDate, order.ShipmentDate)); //Add the 3 most expensive products to the order (useful, if if there was a 'menu of the day') EntityIO <Product> productRepository = new EntityIO <Product>(); var products = (from p in productRepository.Query() orderby p.Price descending select p).Take(3).ToList(); EntityIO <OrderProduct> orderProductRepository = new EntityIO <OrderProduct>(); foreach (var product in products) { OrderProduct orderProduct = new OrderProduct(); orderProduct.Quantity = products.GroupBy(p => product).ToList().Count(); orderProduct.OrderId = 5; orderProduct.ProductId = product.ProductId; orderProductRepository.Insert(orderProduct); } var orderedProducts = (from op in orderProductRepository.Query() where op.OrderId == 5 select new { op.ProductId, op.Quantity }).ToList(); var prroducts = (from p in productRepository.Query() select new { p.ProductId, p.Price }).ToList(); decimal price = 0; foreach (var product in orderedProducts) { var prod = prroducts.SingleOrDefault(x => x.ProductId == product.ProductId); price += prod.Price * product.Quantity; } Order ordern = (from o in orderRepository.Query() where o.OrderId == 5 select o).SingleOrDefault(); ordern.TotalPrice = price; orderRepository.Update(ordern); Console.WriteLine(String.Format("Order with the id {0} has a total price of {1}, the order was made on {2} and the shipment is estimated on {3}", ordern.OrderId, ordern.TotalPrice, ordern.OrderDate, ordern.ShipmentDate)); Console.ReadLine(); /* //Creates order * DateTime shipmentDate = DateTime.Today; * shipmentDate.AddDays(3); * * orderClient.CreateOrder(DateTime.Today, shipmentDate, 0, 2); * * //Add the 3 most expensive products to the order (useful, if if there was a 'menu of the day') * var products = productClient.GetTopMostExpensiveProducts(3); * //Manual conversion from ProductService.Product to OrderService.Product * var orderProducts = new List<OrderService.Product>(); * foreach(var prod in products) * { * var pr = new OrderService.Product(); * * pr.Name = prod.Name; * pr.Description = prod.Description; * pr.ProductId = prod.ProductId; * pr.Kcal = prod.Kcal; * pr.Price = prod.Price; * * orderProducts.Add(pr); * } * orderClient.AddProductsToOrder(5, orderProducts); * * Console.WriteLine("The order we have jut placed:"); * Console.WriteLine(orderClient.DisplayOrder(5)); */ }