private List <Models.ChartByChannelModels> GetChartByChannelData(string type)
{
var typ = ((List <StrawmanDBLibray.Entities.WRK_VIEWS_VARIABLES>)Helpers.StrawmanDBLibrayData.Get(StrawmanDBLibray.Classes.StrawmanDataTables.WRK_VIEWS_VARIABLES))
.Where(m => m.VIEW == "CHART BY CONFIG" && m.NAME == type).Select(m => m.VALUE).FirstOrDefault();
if (typ == null)
{
return(null);
}
var grp = (List <StrawmanDBLibray.Entities.GROUP_MASTER>)Helpers.StrawmanDBLibrayData.Get(StrawmanDBLibray.Classes.StrawmanDataTables.GROUP_MASTER);
var grpd = grp.Join(((List <StrawmanDBLibray.Entities.GROUP_CONFIG>)Helpers.StrawmanDBLibrayData.Get(StrawmanDBLibray.Classes.StrawmanDataTables.GROUP_CONFIG))
.Where(m => m.TYPE_ID == int.Parse(typ)).AsEnumerable(),
m => new { _id = m.ID }, c => new { _id = (decimal)c.GROUP_ID },
(m, c) => new
{
order = c.ID,
id = c.BRAND,
name = m.NAME,
source = c.SOURCE,
brand = c.BRAND,
market = c.MARKET
});
if (grpd == null)
{
return(null);
}
MarketViewFranchiseController mfranchise = new MarketViewFranchiseController();
BrandViewFranchiseController bfranchise = new BrandViewFranchiseController();
MarketViewChannelController mchannel = new MarketViewChannelController();
BrandViewChannelController bchannel = new BrandViewChannelController();
MarketViewController mstrawm = new MarketViewController();
BrandViewController bstrawm = new BrandViewController();
string vtype = Classes.StrawmanViews.MAT;
var f_data_market_MAT = mfranchise.GetMarketViewData(vtype);
var f_data_brand_MAT = bfranchise.GetBrandViewData(vtype);
var c_data_market_MAT = mchannel.GetMarketViewData(vtype);
var c_data_brand_MAT = bchannel.GetBrandViewData(vtype);
var s_data_market_MAT = (List <Models.StrawmanViewSTDModel>)mstrawm.GetMarketViewData(StrawmanDBLibray.Classes.StrawmanDataTables.WRK_MARKET_MAT);
var s_data_brand_MAT = (List <Models.StrawmanViewSTDModel>)bstrawm.GetBrandViewData(StrawmanDBLibray.Classes.StrawmanDataTables.WRK_BRAND_MAT);
var fdata_MAT = GetCalcChartData(f_data_market_MAT, f_data_brand_MAT);
var cdata_MAT = GetCalcChartData(c_data_market_MAT, c_data_brand_MAT);
var sdata_MAT = GetCalcChartData(s_data_market_MAT, s_data_brand_MAT, "STRAWMAN");
vtype = Classes.StrawmanViews.YTD;
var f_data_market_YTD = mfranchise.GetMarketViewData(vtype);
var f_data_brand_YTD = bfranchise.GetBrandViewData(vtype);
var c_data_market_YTD = mchannel.GetMarketViewData(vtype);
var c_data_brand_YTD = bchannel.GetBrandViewData(vtype);
var fdata_YTD = GetCalcChartData(f_data_market_YTD, f_data_brand_YTD);
var cdata_YTD = GetCalcChartData(c_data_market_YTD, c_data_brand_YTD);
vtype = Classes.StrawmanViews.MONTH;
var f_data_market_LM = mfranchise.GetMarketViewData(vtype);
var f_data_brand_LM = bfranchise.GetBrandViewData(vtype);
var c_data_market_LM = mchannel.GetMarketViewData(vtype);
var c_data_brand_LM = bchannel.GetBrandViewData(vtype);
var fdata_LM = GetCalcChartData(f_data_market_LM, f_data_brand_LM);
var cdata_LM = GetCalcChartData(c_data_market_LM, c_data_brand_LM);
vtype = Classes.StrawmanViews.BOY;
var f_data_market_BOY = mfranchise.GetMarketViewData(vtype);
var f_data_brand_BOY = bfranchise.GetBrandViewData(vtype);
var c_data_market_BOY = mchannel.GetMarketViewData(vtype);
var c_data_brand_BOY = bchannel.GetBrandViewData(vtype);
vtype = Classes.StrawmanViews.TOTAL;
var f_data_market_PBP = mfranchise.GetMarketViewData(vtype).Join(f_data_market_BOY, t => new{ _id = t.vid }, b => new{ _id = b.vid }, (t, b) => new Models.MarketViewChannelModels
{
vid = t.vid,
col1 = t.col3,
col2 = b._le
}).ToList();
var f_data_brand_PBP = bfranchise.GetBrandViewData(vtype).Join(f_data_brand_BOY, t => new { _id = t.vid }, b => new { _id = b.vid }, (t, b) => new Models.MarketViewChannelModels
{
vid = t.vid,
col1 = t.col3,
col2 = b._le
}).ToList();
var c_data_market_PBP = mchannel.GetMarketViewData(vtype).Join(c_data_market_BOY, t => new { _id = t.vid }, b => new { _id = b.vid }, (t, b) => new Models.StrawmanViewSTDModel
{
vid = t.vid,
col1 = t.col3,
col2 = b._le
}).ToList();
var c_data_brand_PBP = bchannel.GetBrandViewData(vtype).Join(c_data_brand_BOY, t => new { _id = t.vid }, b => new { _id = b.vid }, (t, b) => new Models.StrawmanViewSTDModel
{
vid = t.vid,
col1 = t.col3,
col2 = b._le
}).ToList();
var fdata_PBP = GetCalcChartData(f_data_market_PBP, f_data_brand_PBP);
var cdata_PBP = GetCalcChartData(c_data_market_PBP, c_data_brand_PBP);
return(grpd.Select(p => new Models.ChartByChannelModels
{
channel_name = p.name,
vid = (decimal)p.id,
mat_market_size = p.source == "FRANCHISE"? fdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().market_size: p.source == "STRAWMAN"? sdata_MAT.Where(m => m.brand == p.brand && m.market == p.market).FirstOrDefault().market_size: cdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().market_size,
mat_market_share_l = p.source == "FRANCHISE" ? fdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().market_share_l : cdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().market_share_l,
mat_market_share_p = p.source == "FRANCHISE" ? fdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().market_share_p : cdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().market_share_p,
ytd_market_share_l = p.source == "FRANCHISE" ? fdata_YTD.Where(m => m.vid == p.id).FirstOrDefault().market_share_l : cdata_YTD.Where(m => m.vid == p.id).FirstOrDefault().market_share_l,
ytd_market_share_p = p.source == "FRANCHISE" ? fdata_YTD.Where(m => m.vid == p.id).FirstOrDefault().market_share_p : cdata_YTD.Where(m => m.vid == p.id).FirstOrDefault().market_share_p,
lm_market_share_l = p.source == "FRANCHISE" ? fdata_LM.Where(m => m.vid == p.id).FirstOrDefault().market_share_l : cdata_LM.Where(m => m.vid == p.id).FirstOrDefault().market_share_l,
lm_market_share_p = p.source == "FRANCHISE" ? fdata_LM.Where(m => m.vid == p.id).FirstOrDefault().market_share_p : cdata_LM.Where(m => m.vid == p.id).FirstOrDefault().market_share_p,
mat_grouth_c = p.source == "FRANCHISE" ? fdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().grouth_c : cdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().grouth_c,
mat_grouth_jj = p.source == "FRANCHISE" ? fdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().grouth_jj : cdata_MAT.Where(m => m.vid == p.id).FirstOrDefault().grouth_jj,
ytd_grouth_c = p.source == "FRANCHISE" ? fdata_YTD.Where(m => m.vid == p.id).FirstOrDefault().grouth_c : cdata_YTD.Where(m => m.vid == p.id).FirstOrDefault().grouth_c,
ytd_grouth_jj = p.source == "FRANCHISE" ? fdata_YTD.Where(m => m.vid == p.id).FirstOrDefault().grouth_jj : cdata_YTD.Where(m => m.vid == p.id).FirstOrDefault().grouth_jj,
lm_grouth_c = p.source == "FRANCHISE" ? fdata_LM.Where(m => m.vid == p.id).FirstOrDefault().grouth_c : cdata_LM.Where(m => m.vid == p.id).FirstOrDefault().grouth_c,
lm_grouth_jj = p.source == "FRANCHISE" ? fdata_LM.Where(m => m.vid == p.id).FirstOrDefault().grouth_jj : cdata_LM.Where(m => m.vid == p.id).FirstOrDefault().grouth_jj,
pbp_market_size = p.source == "FRANCHISE" ? (double)fdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().market_size : (double)cdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().market_size,
pbp_grouth_c = p.source == "FRANCHISE" ? fdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().grouth_c : cdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().grouth_c,
pbp_grouth_jj = p.source == "FRANCHISE" ? fdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().grouth_jj : cdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().grouth_jj,
pbp_share_p = p.source == "FRANCHISE" ? fdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().market_share_p: cdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().market_share_p,
pbp_share_l = p.source == "FRANCHISE" ? fdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().market_share_l : cdata_PBP.Where(m => m.vid == p.id).FirstOrDefault().market_share_l,
}).ToList());
}
