public SellerStats GetSellerStats(Guid sellerId) { using (var db = new SqlConnection(_connectionString)) { var sellerStats = new SellerStats(); var topProductInfo = GetTopProduct(sellerId); if (topProductInfo != null) { var topProduct = _productRepo.GetProductById(topProductInfo.MostSoldProduct); sellerStats.TopProduct = topProduct; sellerStats.TopProductAmountSold = topProductInfo.MostSoldAmount; } var topMonthProductInfo = GetTopProductForMonth(sellerId); if (topMonthProductInfo != null) { var topMonthProduct = _productRepo.GetProductById(topMonthProductInfo.MostSoldProduct); sellerStats.TopMonthProduct = topMonthProduct; sellerStats.TopMonthProductAmountSold = topMonthProductInfo.MostSoldAmount; } var totalSales = GetTotalSales(sellerId); var monthSales = GetTotalSalesForTheMonth(sellerId); sellerStats.TotalSales = totalSales; sellerStats.MonthSales = monthSales; return(sellerStats); } }
public SellerStats SellerSts(Guid SellerID) { SellerStats response = new SellerStats(); response.numSales = 0; response.sold = 0; response.owed = 0; var giftCards = from gc in db.GiftCards where gc.SellerID == SellerID.ToString() where gc.TotalIn != 0 select gc; if (giftCards.Count() > 0) { foreach (GiftCard gc in giftCards) { response.numSales += 1; response.sold += gc.TotalIn; if (gc.SalesDealRate != null) { response.owed += Math.Round(gc.TotalIn / 100 * gc.SalesDealRate, 2); } } } return response; }