@@ -30,51 +30,51 @@ public string Post([FromBody] Order transaction)
3030 }
3131
3232
33- // GET ORDERS
33+ // GET ALL
3434 [ Authorize ( Roles = "Admin" ) ]
35- [ HttpGet ( "order " ) ]
36- public IEnumerable < UserOrder > GetOrder ( )
35+ [ HttpGet ( "Order " ) ]
36+ public IEnumerable < UserOrder > Get ( )
3737 {
38- var usersOrder = from o in order_context . Set < Order > ( )
39- join u in order_context . Set < Users > ( )
40- on o . UserId equals u . UserId
41- select new UserOrder
42- {
43- TransactionId = o . TransactionId ,
38+ var u_o_Joint = from o in order_context . Set < Order > ( )
39+ join u in order_context . Set < Users > ( )
40+ on o . UserId equals u . UserId
41+ select new UserOrder
42+ {
43+ TransactionId = o . TransactionId ,
4444
45- MemberId = o . MemberId ,
46- ProductName = o . ProductName ,
47- RequiredDate = o . RequiredDate ,
48- Quantities = o . Quantities ,
49- UserId = o . UserId ,
50- FirstName = u . FirstName ,
51- LastName = u . LastName ,
52- Email = u . Email ,
53- } ;
54- return usersOrder . ToList ( ) ;
45+ MemberId = o . MemberId ,
46+ ProductName = o . ProductName ,
47+ RequiredDate = o . RequiredDate ,
48+ Quantities = o . Quantities ,
49+ UserId = o . UserId ,
50+ FirstName = u . FirstName ,
51+ LastName = u . LastName ,
52+ Email = u . Email ,
53+ } ;
54+ return u_o_Joint . ToList ( ) ;
5555 }
5656
5757 [ HttpGet ( "email/{email}" ) ]
58- public IEnumerable < UserOrder > GetOrderById ( string email )
58+ public IEnumerable < UserOrder > GetById ( string email )
5959 {
60- var usersOrder = from o in order_context . Set < Order > ( )
61- join u in order_context . Set < Users > ( )
62- on o . UserId equals u . UserId
63- select new UserOrder
64- {
65- TransactionId = o . TransactionId ,
60+ var u_o_Joint = from o in order_context . Set < Order > ( )
61+ join u in order_context . Set < Users > ( )
62+ on o . UserId equals u . UserId
63+ select new UserOrder
64+ {
65+ TransactionId = o . TransactionId ,
6666
67- MemberId = o . MemberId ,
68- ProductName = o . ProductName ,
69- RequiredDate = o . RequiredDate ,
70- Quantities = o . Quantities ,
67+ MemberId = o . MemberId ,
68+ ProductName = o . ProductName ,
69+ RequiredDate = o . RequiredDate ,
70+ Quantities = o . Quantities ,
7171
72- UserId = o . UserId ,
73- FirstName = u . FirstName ,
74- LastName = u . LastName ,
75- Email = u . Email ,
76- } ;
77- return usersOrder . ToList ( ) . Where ( x => x . Email == email ) ;
72+ UserId = o . UserId ,
73+ FirstName = u . FirstName ,
74+ LastName = u . LastName ,
75+ Email = u . Email ,
76+ } ;
77+ return u_o_Joint . ToList ( ) . Where ( x => x . Email == email ) ;
7878 }
7979
8080 }
0 commit comments