private dynamic GetDataByType(string NTSType, int?cad)
{
int _year = cad == null? 0:(int)cad;
List <StrawmanDBLibray.Entities.WRK_NTS_VIEW_DATA> data = (List <StrawmanDBLibray.Entities.WRK_NTS_VIEW_DATA>)GetSessionData(NTSTables.WRK_NTS_VIEW_DATA);
List <StrawmanDBLibray.Entities.v_WRK_FRANCHISE_MASTER> mster = (List <StrawmanDBLibray.Entities.v_WRK_FRANCHISE_MASTER>)Helpers.StrawmanDBLibrayData.Get(StrawmanDBLibray.Classes.StrawmanDataTables.v_WRK_FRANCHISE_MASTER, true);
var q = data.Where(m => m.YEAR_PERIOD == Helpers.PeriodUtil.Year - _year && m.MONTH_PERIOD == Helpers.PeriodUtil.Month && m.BRAND < 9000 && m.MARKET < 9000 && m.TYPE == NTSType).AsEnumerable()
.Join(mster.Where(m => m.TYPE == Classes.StrawmanViews.MARKET).AsEnumerable()
, d => new { _channel = d.CHANNEL, _market = d.MARKET, _brand = d.BRAND }, m => new { _channel = m.CHANNEL, _market = m.MARKET, _brand = (decimal?)m.BRAND }, (d, m) => new { d = d, m = m })
.AsEnumerable()
.Select(p => new Models.MarketViewChannelModels {
col1 = (decimal?)p.d.AMOUNT * p.m.CFG, col2 = 0, col3 = 0, col4 = 0, col5 = 0, col6 = 0, vid = (decimal)p.m.FRANCHISE_ID, vparent = p.m.PARENT_ID
})
.AsEnumerable();
var fdata = new MarketViewFranchiseController().GetFormatedData(q, Classes.StrawmanColumns.NTS);
//List<StrawmanDBLibray.Entities.v_WRK_NTS_DATA_FRANCHISE> data = (List<StrawmanDBLibray.Entities.v_WRK_NTS_DATA_FRANCHISE>)GetSessionData(NTSTables.v_WRK_NTS_DATA_FRANCHISE);
return(fdata
.Select(p => new Models.StrawmanViewSTDModel
{
vid = p.vid,
vorder = p.vorder,
vparent = p.vparent,
col1 = p.col1
})
.ToList());
}
