Linq+File
Can you give me some tips ?
I only created seed file info writer to create and fill file with data (Step 1 and 2)
Let's make two txt.file
1) Customers.txt
2) Orders.txt
Customers table
3: CustomerID, CustomerName
1|Lasha
2|Beka
3|Dimitri
Orders table
: OrderID, Date, Product, Price, CustomerID
1|20201212|Coca-cola|3.0|1
2|20201111|Pepsi|3.0/2
3|20200909|Staropramen|4.0/2
4|20201212|Argo|2.0|3
There must be at least 5 users and at least 20 orders. (Fill in the details as you wish)
We need to extract the following type of report:
1. The number of orders for each customer. For example: CustomerID - 1, Order Count-2
The total price of each customer's orders. For example: CustomerID - 1, SumAmount -2 10.5
3. Minimum order price for each customer. For example: CustomerID - 1, MinAmount-0.6
4. Only customers who have more than one order. CustomerID-1, Order Count-2
5. Only customers whose average order is greater than 10. CustomerID-1, AvgAmount-12.5
Best solution is with Aggregate functions in Ling, as well as Having clauses in Ling. Classic Foreach should only be used when printing.
I only created seed file info writer to create and fill file with data (Step 1 and 2)
Let's make two txt.file
1) Customers.txt
2) Orders.txt
Customers table
3: CustomerID, CustomerName
1|Lasha
2|Beka
3|Dimitri
Orders table
: OrderID, Date, Product, Price, CustomerID
1|20201212|Coca-cola|3.0|1
2|20201111|Pepsi|3.0/2
3|20200909|Staropramen|4.0/2
4|20201212|Argo|2.0|3
There must be at least 5 users and at least 20 orders. (Fill in the details as you wish)
We need to extract the following type of report:
1. The number of orders for each customer. For example: CustomerID - 1, Order Count-2
The total price of each customer's orders. For example: CustomerID - 1, SumAmount -2 10.5
3. Minimum order price for each customer. For example: CustomerID - 1, MinAmount-0.6
4. Only customers who have more than one order. CustomerID-1, Order Count-2
5. Only customers whose average order is greater than 10. CustomerID-1, AvgAmount-12.5
Best solution is with Aggregate functions in Ling, as well as Having clauses in Ling. Classic Foreach should only be used when printing.
