/// <summary> /// Get Average list of all month state vise /// </summary> /// <returns>List of Avg</returns> private List <double> getAverageList() { List <double> result = new List <double>(); foreach (State state in StateList) { result.Add(Math.Round((RegionSaleList.Where(rs => rs.StateId == state.Id).Sum(S => S.Sales)) / (double)MonthList.Count, 1)); } return(result); }
/// <summary> /// Get total list of all month state vise /// </summary> /// <returns> total list</returns> private List <int> getTotalList() { List <int> result = new List <int>(); foreach (State state in StateList) { result.Add(RegionSaleList.Where(rs => rs.StateId == state.Id).Sum(S => S.Sales)); } return(result); }
/// <summary> /// Get Median list of all month state vise /// </summary> /// <returns>List of Median</returns> private List <int> getMediaList() { List <int> result = new List <int>(); foreach (State state in StateList) { int[] monthList1 = new int[12]; foreach (Month month in MonthList) { RegionSale model = RegionSaleList.AsEnumerable().Where(rs => rs.StateId == state.Id && rs.MonthId == month.Id).FirstOrDefault(); monthList1[month.Id - 1] = model == null ? 0: model.Sales; } Array.Sort(monthList1); result.Add((monthList1[(monthList1.Length / 2) - 1] + monthList1[monthList1.Length / 2]) / 2); } return(result); }