private dynamic SetDataView(List <Models.StrawmanViewSTDModel> data, List <Models.StrawmanViewSTDModel> source, string type) { if (data == null) { data = source; } else { foreach (Models.StrawmanViewSTDModel item in source) { Models.StrawmanViewSTDModel aux = data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market); if (aux == null) { data.Add(new Models.StrawmanViewSTDModel { brand = item.brand, channel = item.channel, market = item.market, col1 = 0, col2 = 0, col3 = 0, col4 = 0, col5 = 0, col6 = 0, }); } switch (type) { case NTSColumns.COL1: data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market).col1 = item.col1; break; case NTSColumns.COL2: data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market).col2 = item.col1; break; case NTSColumns.COL3: data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market).col3 = item.col1; break; case NTSColumns.INT: data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market)._internal = item.col1; break; case NTSColumns.LE: data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market)._le = item.col1; break; case NTSColumns.PBP: data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market)._pbp = item.col1; break; //case NTSColumns.LE_WC: // data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market)._lewc = item.col1; // break; //case NTSColumns.PBP_WC: // data.Find(m => m.channel == item.channel && m.brand == item.brand && m.market == item.market)._pbpwc = item.col1; // break; } } } return(data); }
private dynamic SetDataView(List <Models.StrawmanViewSTDModel> data, List <Models.StrawmanViewSTDModel> source, string type) { if (data == null) { data = source; } else { foreach (Models.StrawmanViewSTDModel item in source) { Models.StrawmanViewSTDModel data_item = data.Find(m => m.vorder == item.vorder && m.vid == item.vid && m.vparent == item.vparent); if (data_item == null) { data_item = new Models.StrawmanViewSTDModel { brand = item.brand, market = item.market, channel = item.channel, vorder = item.vorder, vid = item.vid, vparent = item.vparent } } ; switch (type) { case NTSColumns.COL1: data_item.col1 = item.col1; break; case NTSColumns.COL2: data_item.col2 = item.col1; break; case NTSColumns.COL3: data_item.col3 = item.col1; break; case NTSColumns.INT: data_item._internal = item.col1; break; case NTSColumns.LE: data_item._le = item.col1; break; case NTSColumns.PBP: data_item._pbp = item.col1; break; } } } return(data); }
private dynamic SetDataView(List <Models.StrawmanViewSTDModel> data, List <Models.StrawmanViewSTDModel> source, string type) { if (data == null) { data = source; } else { foreach (Models.StrawmanViewSTDModel item in source) { Models.StrawmanViewSTDModel data_item = data.Find(m => m.vgroup == item.vgroup && m.vid == item.vid); switch (type) { case NTSColumns.COL1: data_item.col1 = item.col1; break; case NTSColumns.COL2: data_item.col2 = item.col1; break; case NTSColumns.COL3: data_item.col3 = item.col1; break; case NTSColumns.INT: data_item._internal = item.col1; break; case NTSColumns.LE: data_item._le = item.col1; break; case NTSColumns.PBP: data_item._pbp = item.col1; break; } } } return(data); }
private dynamic GetData(string key) { switch (key) { case NTSTables.WRK_NTS_VIEW_DATA: List <Models.StrawmanViewSTDModel> lst = null; lst = (List <Models.StrawmanViewSTDModel>)SetDataView(lst, (List <Models.StrawmanViewSTDModel>)GetDataTOTAL(NTSPeriod.TWO_AGO), NTSColumns.COL1); lst = (List <Models.StrawmanViewSTDModel>)SetDataView(lst, (List <Models.StrawmanViewSTDModel>)GetDataTOTAL(NTSPeriod.LAST), NTSColumns.COL2); lst = (List <Models.StrawmanViewSTDModel>)SetDataView(lst, (List <Models.StrawmanViewSTDModel>)GetDataTOTAL(NTSPeriod.CURRENT), NTSColumns.COL3); lst = (List <Models.StrawmanViewSTDModel>)SetDataView(lst, (List <Models.StrawmanViewSTDModel>)GetDataINT(), NTSColumns.INT); lst = (List <Models.StrawmanViewSTDModel>)SetDataView(lst, (List <Models.StrawmanViewSTDModel>)GetDataLE(), NTSColumns.LE); //lst = (List<Models.StrawmanViewSTDModel>)SetDataView(lst, (List<Models.StrawmanViewSTDModel>)GetDataLE_WC(), NTSColumns.LE_WC); lst = (List <Models.StrawmanViewSTDModel>)SetDataView(lst, (List <Models.StrawmanViewSTDModel>)GetDataPBP(), NTSColumns.PBP); //lst = (List<Models.StrawmanViewSTDModel>)SetDataView(lst, (List<Models.StrawmanViewSTDModel>)GetDataPBP_WC(), NTSColumns.PBP_WC); List <Models.StrawmanViewSTDModel> lst_st = lst.FindAll(m => m.brand > 9000); foreach (Models.StrawmanViewSTDModel st in lst_st) { Models.StrawmanViewSTDModel t = st; } return(lst); default: List <StrawmanDBLibray.Entities.v_STRWM_MARKET_DATA> data = (List <StrawmanDBLibray.Entities.v_STRWM_MARKET_DATA>)Helpers.StrawmanDBLibrayData.Get(StrawmanDBLibray.Classes.StrawmanDataTables.v_STRWM_BRAND_DATA, true); List <StrawmanDBLibray.Entities.WRK_VIEWS_VARIABLES> var = (List <StrawmanDBLibray.Entities.WRK_VIEWS_VARIABLES>)Helpers.StrawmanDBLibrayData.Get(StrawmanDBLibray.Classes.StrawmanDataTables.WRK_VIEWS_VARIABLES, true); var = var.Where(m => m.VIEW == Classes.Default.Variables.STRAWMAN_COLORS) .Select(m => m).ToList(); List <Models.MarketDataModels> aux = data.Where(m => m.STATUS == "A").AsEnumerable() .GroupJoin(var, l => new { ID = "BRAND:" + l.BRAND.ToString() + ";MARKET:" + l.MARKET.ToString() }, v => new { ID = v.NAME }, (l, v) => new { l = l, v = v }) .SelectMany(f => f.v.DefaultIfEmpty(), (l, v) => new { l = l.l, v = v }).ToList() .Select(p => new Models.MarketDataModels { market = (decimal)p.l.MARKET, brand = (decimal)p.l.BRAND, channel = (decimal)p.l.CHANNEL, brand_name = p.l.BRAND_NAME, market_name = p.l.NAME, data = p.l.DATA, source = p.l.SOURCE, vgroup = p.l.GROUP, vorder = p.l.ORDER, vgorder = p.l.GROUP_ORDER, style = p.v == null ? "" : Helpers.StyleUtils.GetBGColor(p.v.VALUE, true) }).ToList(); return(aux); //return data//.Where(m => m.YEAR_PERIOD == Helpers.PeriodUtil.Year && m.MONTH_PERIOD == Helpers.PeriodUtil.Month || (m.YEAR_PERIOD == null && m.MONTH_PERIOD == null) && !m.SOURCE.Contains("MARKET")) // .Select(p => new Models.MarketDataModels // { // market = (decimal)p.MARKET, // brand = (decimal)p.BRAND, // channel = (decimal)p.CHANNEL, // brand_name = p.BRAND_NAME, // data = p.DATA, // market_name = p.NAME, // source = p.SOURCE, // vgroup = p.GROUP, // vorder = p.ORDER // }) // .ToList(); } }