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