public static ResponseViewModel<List<GetProductWiseOrders_Result>> GetProductWiseOrder()
{
ResponseViewModel<List<GetProductWiseOrders_Result>> response = new ResponseViewModel<List<GetProductWiseOrders_Result>>();
using (EcommerceEntities entities = new EcommerceEntities())
{
/*List<Product> products = new List<Product>();
products = entities.Products.ToList();
foreach(var product in products)
{
ProductWiseOrderViewModel viewModel = new ProductWiseOrderViewModel();
viewModel.ProductName = product.Name;
viewModel.NoOfOrders = 0;
viewModelList.Add(viewModel);
}
List<GetProductWiseOrders_Result> result = entities.GetProductWiseOrders().ToList();
foreach (var product in viewModelList)
{
foreach (var singleResult in result)
{
if (singleResult.ProductName == product.ProductName)
{
product.NoOfOrders = Convert.ToInt32(singleResult.NoOfOrders);
}
product.OrderCount = Convert.ToInt32(singleResult.OrderCount);
product.ProductCount = Convert.ToInt32(singleResult.ProductCount);
product.CustomerCount = Convert.ToInt32(singleResult.CustomerCount);
}
}*/
List<GetProductWiseOrders_Result> result = entities.GetProductWiseOrders().ToList();
response.Data = result;
return response;
}
}