public List <object[]> getAxisLabel(List <dropdown_list> skus, Helpers.Helpers.AxisType axisType) { List <object[]> listData = new List <object[]>(); foreach (dropdown_list s in skus) { object[] values = new object[2]; values[0] = s.description; values[1] = 0; listData.Add(values); } return(listData); }
public List <object[]> getAxisLabel(string drillDownLevelID, DateTime start_date, DateTime end_date, DateTime startOfWeek, Helpers.Helpers.AxisType axisType) { List <object[]> listData = new List <object[]>(); switch (drillDownLevelID) { //group by daily case "1": while (start_date <= end_date) { object[] values = new object[2]; values[0] = getLabelName(drillDownLevelID, start_date, 0, 0, 0, 0); values[1] = 0; listData.Add(values); start_date = start_date.AddDays(1); } break; //group by weekly case "2": int startWeek = 1; while (startOfWeek <= end_date) { object[] values = new object[2]; // pull out week values[0] = getLabelName(drillDownLevelID, start_date, startWeek, 0, 0, 0); values[1] = 0; listData.Add(values); startOfWeek = startOfWeek.AddDays(7); startWeek += 1; } break; //group by monthly case "3": start_date = new DateTime(start_date.Year, start_date.Month, 1); while (start_date <= end_date) { object[] values = new object[2]; // pull out month and year values[0] = getLabelName(drillDownLevelID, start_date, 0, start_date.Month, 0, start_date.Year); values[1] = 0; listData.Add(values); start_date = start_date.AddMonths(1); } break; //group by quarterly case "4": start_date = new DateTime(start_date.Year, start_date.Month, 1).AddMonths(6); end_date = end_date.AddMonths(6); while (start_date <= end_date) { object[] values = new object[2]; // pull out month and year values[0] = getLabelName(drillDownLevelID, start_date, 0, 0, (int)Math.Ceiling(start_date.Month / 3.0), start_date.Year); values[1] = 0; listData.Add(values); start_date = start_date.AddMonths(3); } break; default: break; } return(listData); }