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