public IList <userOrder> getuserOrder(userOrder order) { string fetchOrder = $"SELECT CUST_VEND_ADMIN_ID,ORDER_ID,ISSUE_DTLS,MOBILE_CMPNY_DESC,MOBILE_VER_DESC, FINAL_COST FROM USER_TBL ut INNER JOIN ORDER_TABLE ot ON ut.CUST_VEND_ADMIN_ID=ot.FK_CUST_VEND_ADMIN_ID INNER JOIN ORDER_STATUS os ON ut.CUST_VEND_ADMIN_ID=os.FK_CUST_VEND_ADMIN_ID INNER JOIN MOBILE_TYPE mt ON mt.FK_CUST_VEND_ADMIN_ID=ut.CUST_VEND_ADMIN_ID INNER JOIN MOBILE_VER_TYPE mv ON mv.FK_CUST_VEND_ADMIN_ID=ut.CUST_VEND_ADMIN_ID WHERE LOWER(LOGIN_ID) = '{order.LoginId.ToLowerInvariant()}' && LOWER (ORDER_ID) = '{ order.OrderID.ToString()} '"; var dtResult = MySqlOrderHelper.ExecuteQuery(fetchOrder); var userorder = FilluserOrderModel(dtResult); return(userorder); }
public IHttpActionResult getuserOrder([FromBody] userOrder order) { var orderRepo = new OrderRepository(); var userOrder = orderRepo.getuserOrder(order); if (userOrder == null) { return(NotFound()); } return(Ok(userOrder)); }
private IList <userOrder> FilluserOrderModel(DataTable dtOrders) { var userorderList = new List <userOrder>(); if (null != dtOrders && dtOrders.Rows.Count > 0) { foreach (DataRow row in dtOrders.Rows) { var userorder = new userOrder(); userorder.OrderID = Convert.ToInt32(row["ORDER_ID"]); userorder.IssueDetails = Convert.ToString(row["ISSUE_DTLS"]); userorder.mobileCompany = Convert.ToString(row["MOBILE_CMPNY_DESC"]); userorder.mobileversion = Convert.ToString(row["MOBILE_VER_DESC"]); userorder.FinalCost = Convert.ToInt32(row["FINAL_COST"]); userorderList.Add(userorder); } } return(userorderList); }