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