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