public JsonResult getAgeGroup(int id, string Region) { //Filter by both ADID / Region AgeGrouping ag = new AgeGrouping(); List<AddsHistory> Ad = InitData.lstAddsHistory.Where(kvp => kvp.Region == Region).ToList<AddsHistory>(); //rm.AdId = InitData.lstAdds[0].AgeGroup; ag.Region = Ad[0].Region; ag.Under_5_Years = Ad.Where(kvp => kvp.AgeGroup == "Under 5 Years").ToList<AddsHistory>()[0].Views; ag._5_to_13Years = Ad.Where(kvp => kvp.AgeGroup == "5 to 13Years").ToList<AddsHistory>()[0].Views; ag._14_to_17_Years = Ad.Where(kvp => kvp.AgeGroup == "14 to 17 Years").ToList<AddsHistory>()[0].Views; ag._18_to_24_Years = Ad.Where(kvp => kvp.AgeGroup == "_18 to 24 Years").ToList<AddsHistory>()[0].Views; ag._25_to_44_Years = Ad.Where(kvp => kvp.AgeGroup == "25 to 44 Years").ToList<AddsHistory>()[0].Views; ag._45_to_64_Years = Ad.Where(kvp => kvp.AgeGroup == "45 to 64 Years").ToList<AddsHistory>()[0].Views; ag._65_Years_and_Over = Ad.Where(kvp => kvp.AgeGroup == "65 Years and Over").ToList<AddsHistory>()[0].Views; return Json(ag); }
public JsonResult getAgeGroup(string Param) { //string[] paramArray = Param.Split('&'); string id = "";// = paramArray[0]; id = "1"; string Region = ""; //= paramArray[1]; Region = "California"; //Filter by both ADID / Region List<AgeGrouping> agList = new List<AgeGrouping>(); AgeGrouping ag = new AgeGrouping(); //List<AddsHistory> Ad = InitData.lstAddsHistory.Where(kvp => kvp.Region == Region).ToList<AddsHistory>(); List<AddsHistory> Ad = InitData.lstAddsHistory; //rm.AdId = InitData.lstAdds[0].AgeGroup; //ag.Region = Ad[0].Region; //ag.Under_5_Years = Ad.Where(kvp => kvp.AgeGroup == "Under 5 Years").ToList<AddsHistory>()[0].Views; //ag._5_to_13Years = Ad.Where(kvp => kvp.AgeGroup == "5 to 13Years").ToList<AddsHistory>()[0].Views; //ag._14_to_17_Years = Ad.Where(kvp => kvp.AgeGroup == "14 to 17 Years").ToList<AddsHistory>()[0].Views; //ag._18_to_24_Years = Ad.Where(kvp => kvp.AgeGroup == "_18 to 24 Years").ToList<AddsHistory>()[0].Views; //ag._25_to_44_Years = Ad.Where(kvp => kvp.AgeGroup == "25 to 44 Years").ToList<AddsHistory>()[0].Views; //ag._45_to_64_Years = Ad.Where(kvp => kvp.AgeGroup == "45 to 64 Years").ToList<AddsHistory>()[0].Views; //ag._65_Years_and_Over = Ad.Where(kvp => kvp.AgeGroup == "65 Years and Over").ToList<AddsHistory>()[0].Views; #region test data if (Param != "CA" && Param != "TX" && Param != "NY") { ag = new AgeGrouping(); ag.Region = Param; ag.Under_5_Years = 32; ag._5_to_13Years = 25; ag._14_to_17_Years = 68; ag._18_to_24_Years = 45; ag._25_to_44_Years = 23; ag._45_to_64_Years = 46; ag._65_Years_and_Over = 67; agList.Add(ag); } else { ag = new AgeGrouping(); ag.Region = "CA"; ag.Under_5_Years = 45; ag._5_to_13Years = 55; ag._14_to_17_Years = 23; ag._18_to_24_Years = 12; ag._25_to_44_Years = 29; ag._45_to_64_Years = 32; ag._65_Years_and_Over = 47; agList.Add(ag); ag = new AgeGrouping(); ag.Region = "TX"; ag.Under_5_Years = 43; ag._5_to_13Years = 33; ag._14_to_17_Years = 56; ag._18_to_24_Years = 67; ag._25_to_44_Years = 14; ag._45_to_64_Years = 74; ag._65_Years_and_Over = 32; agList.Add(ag); ag = new AgeGrouping(); ag.Region = "NY"; ag.Under_5_Years = 15; ag._5_to_13Years = 45; ag._14_to_17_Years = 37; ag._18_to_24_Years = 85; ag._25_to_44_Years = 45; ag._45_to_64_Years = 84; ag._65_Years_and_Over = 75; agList.Add(ag); } #endregion return Json(agList); }