//Obtiene los datos por artÃculo
public ActionResult GetItemConfig(string _type, string _market, string _brand, string _channel)
{
Models.ItemsConfigModel model = GetMasterData(_market, _brand, _channel);
List <StrawmanDBLibray.Entities.v_TMP_MASTER_DATA> data = (List <StrawmanDBLibray.Entities.v_TMP_MASTER_DATA>)GetData(Constants.V_TMP_MASTER_DATA);
List <StrawmanDBLibray.Entities.ROSETTA_LOADER> nielsen_data = (List <StrawmanDBLibray.Entities.ROSETTA_LOADER>)GetData(Constants.ROSETTA_LOADER);
List <StrawmanDBLibray.Entities.ROSETTA_STONE> nts_data = (List <StrawmanDBLibray.Entities.ROSETTA_STONE>)GetData(Constants.ROSETTA_STONE);
model.nielsen_data = nielsen_data.Where(m => m.CHANNEL_ID == int.Parse(_channel))
.Select(m => new Models.Nielsen_Data
{
market = m.MARKET_ID,
brand = m.BRAND_ID,
channel = m.CHANNEL_ID,
market_description = m.DESCRIPTION,
brand_description = m.DESCRIPTION,
market_row = (int?)m.EXCEL_ROW,
brand_row = m.BRAND_ID != null?(int?)m.EXCEL_ROW: null,
}).ToList();
model.nts_data = nts_data.Where(m => m.CHANNEL == decimal.Parse(_channel))
.Select(m => new Models.NTS_Data {
market = m.MARKET,
brand = m.BRAND,
channel = m.CHANNEL,
eurocode = m.EUROCODE,
id = m.ID
}).ToList();
model.groups_data = new Models.Groups_Data();
model.type = _type;
return(PartialView(ITEM_EDIT, model));
}
public ActionResult GetItemsConfigData(string _market, string _brand, string _channel)
{
List <StrawmanDBLibray.Entities.v_TMP_MASTER_DATA> mst_data = (List <StrawmanDBLibray.Entities.v_TMP_MASTER_DATA>)GetData(Constants.V_TMP_MASTER_DATA);
List <StrawmanDBLibray.Entities.v_TMP_STRWM_DATA> strwm_data = (List <StrawmanDBLibray.Entities.v_TMP_STRWM_DATA>)GetData(Constants.V_TMP_STRWM_DATA);
List <StrawmanDBLibray.Entities.v_TMP_NTS_DATA> nts_data = (List <StrawmanDBLibray.Entities.v_TMP_NTS_DATA>)GetData(Constants.V_TMP_NTS_DATA);
var ret_mst = mst_data.Where(m => m.MARKET == (int.Parse(_market)) && m.BRAND == (int.Parse(_brand)) && m.CHANNEL == (int.Parse(_channel))).Select(m => m).FirstOrDefault();
var ret_strw = strwm_data.Where(m => m.MARKET == (int.Parse(_market)) && m.BRAND == (int.Parse(_brand))).Select(m => new
{
m.MARKET,
m.BRAND,
CHANNEL = mst_data.Find(n => n.MARKET == m.MARKET && n.BRAND == m.BRAND).CHANNEL,
m.MARKET_DESCRIPTION,
m.BRAND_DESCRIPTION,
m.MARKET_MONTH,
m.MARKET_YTD,
m.MARKET_MAT,
m.MARKET_TOTAL,
m.BRAND_MONTH,
m.BRAND_YTD,
m.BRAND_MAT,
m.BRAND_TOTAL
}).FirstOrDefault();
var ret_nts = nts_data.Where(m => m.MARKET == (int.Parse(_market)) && m.BRAND == (int.Parse(_brand))).Select(m => new
{
m.MARKET,
m.BRAND,
m.CHANNEL,
m.NAME,
m.AMOUNTH
}).FirstOrDefault();
StrawmanApp.Models.ItemsConfigModel ret = new Models.ItemsConfigModel
{
market = _market,
brand = _brand,
channel = _channel,
market_description = (ret_mst == null)?null:ret_mst.MARKET_NAME,
brand_description = (ret_mst == null) ? null : ret_mst.BRAND_NAME,
market_month = (ret_strw == null)?null:ret_strw.MARKET_MONTH,
market_ytd = (ret_strw == null)?null:ret_strw.MARKET_YTD,
market_mat = (ret_strw == null)?null:ret_strw.MARKET_MAT,
market_total = (ret_strw == null)?null:ret_strw.MARKET_TOTAL,
brand_month = (ret_strw == null)?null:ret_strw.BRAND_MONTH,
brand_ytd = (ret_strw == null)?null:ret_strw.BRAND_YTD,
brand_mat = (ret_strw == null)?null:ret_strw.BRAND_MAT,
brand_total = (ret_strw == null)?null:ret_strw.BRAND_TOTAL,
nts_name = (ret_nts == null)?null:ret_nts.NAME,
nts_amount = (ret_nts == null)?null:ret_nts.AMOUNTH
};
return(PartialView(ITEM_DATA, ret));
}
//Editar artÃculo
public ActionResult ShowItemCaracts(string _market, string _brand, string _channel)
{
Models.ItemsConfigModel model = GetMasterData(_market, _brand, _channel);
return(View(model));
}
