public ActionResult GetChartByChannel(string type) { ViewBag.ChartTitle = "Spain - Total Business by Channel - J&J Value Performance"; db = new Models.ChartsClassesDataContext(); db.CommandTimeout = 50000; List <Models.ChartByChannelModels> lst = GetChartsPc(GetChartByChannelData(type)); db.Dispose(); return(PartialView(BYCHANNEL, lst)); }
public ActionResult GetChartByType(string type) { ViewBag.ChartTitle = getChartTitle(type); db = new Models.ChartsClassesDataContext(); db.CommandTimeout = 50000; Models.ChartModel chart = GetChartByFranchiseData(type); List <Models.ChartByChannelModels> lst = chart.chart_ytd; db.Dispose(); ViewBag.ChartModel = lst; return(PartialView(GENERIC, chart)); }
private void SetChartTable(string table) { List <Models.ChartByChannelModels> lst = null; using (Models.ChartsClassesDataContext ddb = new Models.ChartsClassesDataContext()) { switch (table) { case "v_CHARTS_LM": var query = from p in ddb.v_CHARTS_LM where (p.YEAR_PERIOD == Helpers.PeriodUtil.Year && p.MONTH_PERIOD == Helpers.PeriodUtil.Month) select new Models.ChartByChannelModels { vgroup = p.GROUP, brand = p.BRAND, market = p.MARKET, lm_market_share_l = p.LATEST, lm_market_share_p = p.PREVIOUS, lm_grouth_c = p.GROUTH_CATEGORY, lm_grouth_jj = p.GROUTH_J_J, channel_name = p.NAME, lm_grouth_c_pc = 0, lm_grouth_jj_pc = 0, lm_market_share_l_pc = 0, lm_market_share_p_pc = 0, mat_grouth_c = 0, mat_grouth_c_pc = 0, mat_grouth_jj = 0, mat_grouth_jj_pc = 0, mat_market_share_l = 0, mat_market_share_l_pc = 0, mat_market_share_p = 0, mat_market_share_p_pc = 0, mat_market_size = 0, mat_market_size_pc = 0, pbp_grouth_c = 0, pbp_grouth_jj = 0, pbp_market_size = 0, pbp_share_l = 0, pbp_share_p = 0, ytd_grouth_c = 0, ytd_grouth_c_pc = 0, ytd_grouth_jj = 0, ytd_grouth_jj_pc = 0, ytd_market_share_l = 0, ytd_market_share_l_pc = 0, ytd_market_share_p = 0, ytd_market_share_p_pc = 0, type = p.CHART }; lst = (query.ToList()); break; case "v_CHARTS_MAT_MARKET": query = from p in db.v_CHARTS_MAT_MARKET where (p.YEAR_PERIOD == Helpers.PeriodUtil.Year && p.MONTH_PERIOD == Helpers.PeriodUtil.Month) select new Models.ChartByChannelModels { vgroup = p.GROUP, brand = p.BRAND, market = p.MARKET, mat_market_share_l = p.LATEST, mat_market_share_p = p.PREVIOUS, mat_grouth_c = p.GROUTH_CATEGORY, mat_grouth_jj = p.GROUTH_J_J, mat_market_size = p.MARKET_SIZE, lm_market_share_l = p.LATEST, lm_market_share_p = p.PREVIOUS, lm_grouth_c = p.GROUTH_CATEGORY, lm_grouth_jj = p.GROUTH_J_J, channel_name = p.NAME, lm_grouth_c_pc = 0, lm_grouth_jj_pc = 0, lm_market_share_l_pc = 0, lm_market_share_p_pc = 0, mat_grouth_c_pc = 0, mat_grouth_jj_pc = 0, mat_market_share_l_pc = 0, mat_market_share_p_pc = 0, mat_market_size_pc = 0, pbp_grouth_c = 0, pbp_grouth_jj = 0, pbp_share_l = 0, pbp_share_p = 0, pbp_market_size = 0, ytd_grouth_c = 0, ytd_grouth_c_pc = 0, ytd_grouth_jj = 0, ytd_grouth_jj_pc = 0, ytd_market_share_l = 0, ytd_market_share_l_pc = 0, ytd_market_share_p = 0, ytd_market_share_p_pc = 0, type = p.CHART }; lst = (query.ToList()); break; case "v_CHARTS_YTD": query = from p in db.v_CHARTS_YTD where (p.YEAR_PERIOD == Helpers.PeriodUtil.Year && p.MONTH_PERIOD == Helpers.PeriodUtil.Month) select new Models.ChartByChannelModels { vgroup = p.GROUP, brand = p.BRAND, market = p.MARKET, ytd_market_share_l = p.LATEST, ytd_market_share_p = p.PREVIOUS, ytd_grouth_c = p.GROUTH_CATEGORY, ytd_grouth_jj = p.GROUTH_J_J, lm_market_share_l = p.LATEST, lm_market_share_p = p.PREVIOUS, lm_grouth_c = p.GROUTH_CATEGORY, lm_grouth_jj = p.GROUTH_J_J, channel_name = p.NAME, lm_grouth_c_pc = 0, lm_grouth_jj_pc = 0, lm_market_share_l_pc = 0, lm_market_share_p_pc = 0, mat_grouth_c = 0, mat_grouth_c_pc = 0, mat_grouth_jj = 0, mat_grouth_jj_pc = 0, mat_market_share_l = 0, mat_market_share_l_pc = 0, mat_market_share_p = 0, mat_market_share_p_pc = 0, mat_market_size = 0, mat_market_size_pc = 0, pbp_grouth_c = 0, pbp_grouth_jj = 0, pbp_share_l = 0, pbp_share_p = 0, pbp_market_size = 0, ytd_grouth_c_pc = 0, ytd_grouth_jj_pc = 0, ytd_market_share_l_pc = 0, ytd_market_share_p_pc = 0, type = p.CHART }; lst = (query.ToList()); break; case "v_CHARTS_PBP": query = from p in db.v_CHARTS_PBP where (p.YEAR_PERIOD == Helpers.PeriodUtil.Year && p.MONTH_PERIOD == Helpers.PeriodUtil.Month) select new Models.ChartByChannelModels { vgroup = p.GROUP, brand = p.BRAND, market = p.MARKET, pbp_grouth_c = p.GROUTH_CATEGORY, pbp_grouth_jj = p.GROUTH_J_J, pbp_share_l = p.LATEST, pbp_share_p = p.PREVIOUS, pbp_market_size = p.MARKET_SIZE, lm_market_share_l = 0, lm_market_share_p = 0, lm_grouth_c = 0, lm_grouth_jj = 0, channel_name = p.NAME, lm_grouth_c_pc = 0, lm_grouth_jj_pc = 0, lm_market_share_l_pc = 0, lm_market_share_p_pc = 0, mat_grouth_c = 0, mat_grouth_c_pc = 0, mat_grouth_jj = 0, mat_grouth_jj_pc = 0, mat_market_share_l = 0, mat_market_share_l_pc = 0, mat_market_share_p = 0, mat_market_share_p_pc = 0, mat_market_size = 0, mat_market_size_pc = 0, ytd_grouth_c = 0, ytd_grouth_c_pc = 0, ytd_grouth_jj = 0, ytd_grouth_jj_pc = 0, ytd_market_share_l = 0, ytd_market_share_l_pc = 0, ytd_market_share_p = 0, ytd_market_share_p_pc = 0, type = p.CHART }; lst = query.ToList(); break; case "v_CHART_PBP_FRANCHISE": query = from p in db.v_CHART_PBP_FRANCHISE where (p.CHART == "FRANCHISE") && (p.YEAR_PERIOD == Helpers.PeriodUtil.Year && p.MONTH_PERIOD == Helpers.PeriodUtil.Month) select new Models.ChartByChannelModels { vgroup = p.GROUP, brand = p.BRAND, market = p.MARKET, pbp_grouth_c = p.GROUTH_CATEGORY, pbp_grouth_jj = p.GROUTH_J_J, pbp_share_l = (decimal?)p.LATEST, pbp_share_p = (decimal?)p.PREVIOUS, pbp_market_size = p.MARKET_SIZE, lm_market_share_l = 0, lm_market_share_p = 0, lm_grouth_c = 0, lm_grouth_jj = 0, channel_name = p.NAME, lm_grouth_c_pc = 0, lm_grouth_jj_pc = 0, lm_market_share_l_pc = 0, lm_market_share_p_pc = 0, mat_grouth_c = 0, mat_grouth_c_pc = 0, mat_grouth_jj = 0, mat_grouth_jj_pc = 0, mat_market_share_l = 0, mat_market_share_l_pc = 0, mat_market_share_p = 0, mat_market_share_p_pc = 0, mat_market_size = 0, mat_market_size_pc = 0, ytd_grouth_c = 0, ytd_grouth_c_pc = 0, ytd_grouth_jj = 0, ytd_grouth_jj_pc = 0, ytd_market_share_l = 0, ytd_market_share_l_pc = 0, ytd_market_share_p = 0, ytd_market_share_p_pc = 0, type = p.CHART }; lst = query.ToList(); break; case "v_CHART_PBP_ADULTS_SKINCARE": query = from p in db.v_CHART_PBP_ADULTS_SKINCARE where (p.YEAR_PERIOD == Helpers.PeriodUtil.Year && p.MONTH_PERIOD == Helpers.PeriodUtil.Month) select new Models.ChartByChannelModels { vgroup = p.GROUP, brand = p.BRAND, market = p.MARKET, pbp_grouth_c = (decimal?)p.GROUTH_CATEGORY, pbp_grouth_jj = (decimal?)p.GROUTH_J_J, pbp_share_l = (decimal?)p.LATEST, pbp_share_p = (decimal?)p.PREVIOUS, pbp_market_size = p.MARKET_SIZE, lm_market_share_l = 0, lm_market_share_p = 0, lm_grouth_c = 0, lm_grouth_jj = 0, channel_name = p.NAME, lm_grouth_c_pc = 0, lm_grouth_jj_pc = 0, lm_market_share_l_pc = 0, lm_market_share_p_pc = 0, mat_grouth_c = 0, mat_grouth_c_pc = 0, mat_grouth_jj = 0, mat_grouth_jj_pc = 0, mat_market_share_l = 0, mat_market_share_l_pc = 0, mat_market_share_p = 0, mat_market_share_p_pc = 0, mat_market_size = 0, mat_market_size_pc = 0, ytd_grouth_c = 0, ytd_grouth_c_pc = 0, ytd_grouth_jj = 0, ytd_grouth_jj_pc = 0, ytd_market_share_l = 0, ytd_market_share_l_pc = 0, ytd_market_share_p = 0, ytd_market_share_p_pc = 0, type = p.CHART }; lst = query.ToList(); break; default: break; } } SetSessionObject(table, lst); }