public static List <PieChartData> GetOpenedDocumentsStatByType(int currentSellerId) { var items = new List <PieChartData>(); var statsFromDB = Interlex.DataLayer.DB.GetOpenedDocumentsStatByType(currentSellerId); foreach (var r in statsFromDB) { var item = new PieChartData(); if (r["type_id"].ToString() == "3") { if (r["product_id"].ToString() == "1") { item.Label = "Legal Doctrine"; } else if (r["product_id"].ToString() == "2") { item.Label = "Finance doc"; } item.Data = int.Parse(r["count"].ToString()); items.Add(item); } else { if (items.Any(i => i.Label == r["type_id"].ToString())) { var curMemorizedItem = items.Where(i => i.Label == r["type_id"].ToString()).FirstOrDefault(); items.Remove(curMemorizedItem); curMemorizedItem.Data += int.Parse(r["count"].ToString()); curMemorizedItem.Label = r["type_id"].ToString(); items.Add(curMemorizedItem); } else { item.Data = int.Parse(r["count"].ToString()); item.Label = r["type_id"].ToString(); items.Add(item); } } } return(items); }
public static List <PieChartData> GetOpenedDocumentsStatByLanguage(int currentSellerId) { var items = new List <PieChartData>(); var statsFromDB = Interlex.DataLayer.DB.GetOpenedDocumentsStatByLanguage(currentSellerId); foreach (var r in statsFromDB) { var item = new PieChartData(); item.Label = r["lang_name"].ToString(); item.Data = int.Parse(r["count"].ToString()); items.Add(item); } return(items); }