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));
}
