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