private IList <getorder> FillgetorderModel(DataTable dtOrders) { var getorderList = new List <getorder>(); if (null != dtOrders && dtOrders.Rows.Count > 0) { foreach (DataRow row in dtOrders.Rows) { var order = new getorder(); order.OrderID = Convert.ToInt32(row["ORDER_ID"]); order.CustVendorAdminID = Convert.ToInt32(row["FK_CUST_VEND_ADMIN_ID"]); order.AssignedtoVendorID = Convert.ToInt32(row["ASSIGNED_TO_VENDOR_ID"]); order.IssuesTypeID = Convert.ToInt32(row["FK_ISSUE_TYPE_ID"]); order.IssueDetails = Convert.ToString(row["ISSUE_DTLS"]); order.IEMI = Convert.ToString(row["IEMI"]); order.MobileCompID = Convert.ToInt32(row["FK_MOBILE_CMPNY_ID"]); order.MobileVersionTypeID = Convert.ToInt32(row["FK_MOBILE_VER_TYPE_ID"]); order.InitialQuote = Convert.ToInt32(row["INITIAL_QUOTE"]); order.EstimatedQuote = Convert.ToInt32(row["ESTIMATED_QUOTE"]); order.FinalCost = Convert.ToInt32(row["FINAL_COST"]); order.OrderPlacedDate = Convert.ToDateTime(row["ORDER_PLACED_DATE"]); order.EstimatedTimetoDeliver = Convert.ToDateTime(row["ESTIMIATED_DATE_OF_DELIVER"]); UserStatus userStatus; if (Enum.TryParse <UserStatus>(row["ORDER_ID"].ToString(), out userStatus)) { order.OrderID = Convert.ToInt32(row["ORDER_ID"]); } getorderList.Add(order); } } return(getorderList); }
// private object user; public getorder GetOrder(getorder getorder) { // string fetchOrder = $"SELECT * FROM Mobifix_DB.ORDER_TABLE WHERE LOWER ORDER_ID() = '{ OrderID.ToString() }'"; string fetchOrder = $"SELECT * FROM Mobifix_DB.ORDER_TABLE WHERE LOWER (ORDER_ID) = '{ getorder.OrderID.ToString()}'"; var dtResult = MySqlOrderHelper.ExecuteQuery(fetchOrder); var getorders = FillgetorderModel(dtResult); return(getorders.FirstOrDefault <getorder>()); }
public IHttpActionResult GetOrder([FromBody] getorder getorder) { var getorderRepo = new OrderRepository(); var getorders = getorderRepo.GetOrder(getorder); if (getorders == null) { return(NotFound()); } return(Ok(getorders)); }