//getting customerdetail by orderId
        public CustomerDetailViewModel getOrderDetailById (int id)
        {
            OrderDetailInput_Output detailParam = new OrderDetailInput_Output() { OrderId = id };
            var orderDetailResult = detailContext.OrderDetailById.CallStoredProc(detailParam);
            OrdersDetailResultSet customerDetailsFromDb = orderDetailResult.ToList<OrdersDetailResultSet>()[0];
            CustomerDetailViewModel detailForProduct = new CustomerDetailViewModel();

            CustomerDetailViewModel customerDetailModel = new CustomerDetailViewModel()
            {
                orderId = customerDetailsFromDb.OrderId,
                CustomerName = customerDetailsFromDb.CustomerName,
                OrderStatus = customerDetailsFromDb.OrderStatus,
                OrderStatusId = customerDetailsFromDb.OrderStatusId,
                OrderNote = customerDetailsFromDb.OrderNote,
                OrderNumber = customerDetailsFromDb.OrderNumber,
                PhoneNumber = customerDetailsFromDb.PhoneNumber,
                DeliveryAddress = customerDetailsFromDb.DeliveryAddress,
                DeliveryDateTime = customerDetailsFromDb.DeliveryDateTime,
                Locationlat = customerDetailsFromDb.LocationLat,
                Locationlng = customerDetailsFromDb.LocationLng,
                VendorName=customerDetailsFromDb.VendorName
                
            };
            return customerDetailModel;
        }
        //getting product detail by orderId
        public List<ProductDetailViewModel> ProductListById(int id)
        {
            OrderDetailInput_Output detailParam = new OrderDetailInput_Output() { OrderId = id };
            var orderDetailResult = detailContext.OrderDetailById.CallStoredProc(detailParam);
            List<ProductDetailResultSet> productDetailsfromDb = orderDetailResult.ToList<ProductDetailResultSet>();
            List<ProductDetailViewModel> productsList = new List<ProductDetailViewModel>();
            foreach(var productItem in productDetailsfromDb)
            {
                ProductDetailViewModel productModel = new ProductDetailViewModel()
                {
                    ProductId = productItem.ProductId,
                    ProductName = productItem.ProductName,
                    Amount = productItem.Amount,
                    CategoryName = productItem.CategoryName,
                    ItemNote = productItem.OrderNote,
                    Price = productItem.Price,
                    Quantity = productItem.Quantity
                };
                productsList.Add(productModel);
            }
            return productsList;

        }
 //getting amount detail by orderId
 public List<AmountDetailViewModel> AmountListById(int id)
 {
     OrderDetailInput_Output detailParam = new OrderDetailInput_Output() { OrderId = id };
     var orderDetailResult = detailContext.OrderDetailById.CallStoredProc(detailParam);
     List<AmountDetailResultSet> amountDetailsfromDb = orderDetailResult.ToList<AmountDetailResultSet>();
     List<AmountDetailViewModel> amountDetailList = new List<AmountDetailViewModel>();
     foreach (var amountItem in amountDetailsfromDb)
     {
         AmountDetailViewModel amountModel = new AmountDetailViewModel()
         {
             RowId=amountItem.RowId,
             Label=amountItem.Label,
             Value=amountItem.Value
         };
         amountDetailList.Add(amountModel);
     }
     return amountDetailList;
 }