public IActionResult MyOrders()
{
//Get the orders bound to the current userId
//The email
string userEmail = this.HttpContext.Session.GetString("User");
//tbl_orders
Dictionary <string, object> dic = new Dictionary <string, Object>();
dic.Add("in_givenEmail", userEmail);
List <Order> orders = ProcedureCall <Order> .returnResultList(dic, "util_GetOrders");
//Instantiate lists
List <List <tbl_orderhistory> > orderHistories = new List <List <tbl_orderhistory> >();
List <tbl_orderstatus> orderStatuses = new List <tbl_orderstatus>();
List <OfferedLabourerService> olsList = new List <OfferedLabourerService>();
//Get all the relevant data
for (int i = 0; i < orders.Count; i++)
{
Dictionary <string, Object> dic2 = new Dictionary <string, Object>();
dic2.Add("in_orderid", orders[i].fld_OrderId);
//tbl orderhistory
List <tbl_orderhistory> orderhistories = ProcedureCall <tbl_orderhistory> .returnResultList(dic2, "util_GetOrderHistories").OrderByDescending(s => s.fld_ActionDate).ToList();
//tbl_orderstatus
tbl_orderstatus orderstatus = ProcedureCall <tbl_orderstatus> .ExecuteReader(dic2, "util_GetOrderStatuses");
//tbl_offeredlabourerservice
OfferedLabourerService ols = EsOLSQuery <OfferedLabourerService> .findByOfferedServiceId(orders[i].fld_OfferedServiceId);
//Add it all to their respectiv lists
orderStatuses.Add(orderstatus);
olsList.Add(ols);
orderHistories.Add(orderhistories);
}
Tuple <List <Order>, List <tbl_orderstatus>, List <List <tbl_orderhistory> >, List <OfferedLabourerService> > tuple = Tuple.Create(orders, orderStatuses, orderHistories, olsList);
return(View(tuple));
}