public PartialViewResult MarketView()
{
using (StrawmanApp.Models.DataClasses1DataContext db = new Models.DataClasses1DataContext())
{
return(PartialView());
}
}
//
// GET: /MarketData/
public ActionResult Index()
{
using (StrawmanApp.Models.DataClasses1DataContext db = new Models.DataClasses1DataContext())
{
//ViewBag.MarketData =query.ToList().AsEnumerable();
return(PartialView());
}
}
//
// GET: /Market_YTD/
public ActionResult Index()
{
StrawmanApp.Models.DataClasses1DataContext db = new Models.DataClasses1DataContext();
var query = from p in db.v_WRK_MARKET_YTD
where (p.YEAR_PERIOD == Helpers.PeriodUtil.Year && p.MONTH_PERIOD == Helpers.PeriodUtil.Month)
select new Models.Market_YTDModels {
market = p.MARKET, brand = p.BRAND, ytd_2013 = p.YTD_COL1, ytd_2014 = p.YTD_COL2, pc_vs_py = p.PCVSPY
};
ViewBag.Market_YTD = query.ToList().AsEnumerable();
return(View(ViewBag.Market_YTD));
}
private List <Entities.KpiModel> GetKPIModel(string table_name, bool?cache)
{
List <Entities.KpiModel> lst = null;
if (GetSessionObject(table_name) != null && (cache ?? true))
{
return((List <Entities.KpiModel>)GetSessionObject(table_name));
}
else
{
switch (table_name)
{
case BRAND_CONTRIBUTION:
List <StrawmanDBLibray.Entities.BRAND_CONTRIBUTION> bcdata = (List <StrawmanDBLibray.Entities.BRAND_CONTRIBUTION>)Helpers.StrawmanDBLibrayData.Get(StrawmanDBLibray.Classes.StrawmanDataTables.BRAND_CONTRIBUTION, false);
List <StrawmanDBLibray.Entities.KPI_MASTER> mster = (List <StrawmanDBLibray.Entities.KPI_MASTER>)Helpers.StrawmanDBLibrayData.Get(StrawmanDBLibray.Classes.StrawmanDataTables.KPI_MASTER);
return(mster.GroupJoin(bcdata.Where(m => (m.YEAR_PERIOD == Helpers.PeriodUtil.Year && m.MONTH_PERIOD == Helpers.PeriodUtil.Month)).AsEnumerable(), m => new { _id = m.ID }, b => new { _id = b.ID }, (m, b) => new { m = m, b = b }).AsEnumerable()
.SelectMany(f => f.b.DefaultIfEmpty(), (m, b) => new { m = m.m, b = b }).AsEnumerable()
.Select(m => new Entities.KpiModel
{
NAME = m.m.NAME,
COL1 = m.b == null?0: m.b.COL1 ?? 0,
COL2 = m.b == null?0: m.b.COL2 ?? 0,
COL3 = m.b == null?0: m.b.COL3 ?? 0,
ID = m.m.ID,
KPI_COLUMN = BRAND_CONTRIBUTION,
KPI = m.m.ID
}).ToList());
case v_WRK_KPI:
using (Models.DataClasses1DataContext db = new Models.DataClasses1DataContext())
{
db.CommandTimeout = 50000;
var q = db.v_WRK_KPI
.Where(m => (m.YEAR_PERIOD == Helpers.PeriodUtil.Year && m.MONTH_PERIOD == Helpers.PeriodUtil.Month) ||
(m.YEAR_PERIOD == null && m.MONTH_PERIOD == null))
.Select(m => new Entities.KpiModel
{
NAME = m.NAME,
COL1 = m.COL1,
COL2 = (decimal?)m.COL2,
COL3 = (decimal?)m.COL3,
COLPC1 = m.COL1,
COLPC2 = (decimal?)m.COL2,
COLPC3 = (decimal?)m.COL3,
GROUP = m.GROUP,
KPI = m.KPI,
KPI_COLUMN = m.KPI_COLUMN,
ID = m.ID
});
lst = q.ToList();
}
break;
case MASTER_DATA:
using (StrawmanDBLibray.Entities.godzillaDBLibraryEntity db = new StrawmanDBLibray.Entities.godzillaDBLibraryEntity())
{
var t = db.KPI_MASTER.OrderBy(m => m.ORDER).Select(m => new Entities.KpiModel
{
NAME = m.NAME,
GROUP = m.GROUP,
KPI = m.ID,
isHead = m.GROUP == 0 || m.NAME.Equals("MASS") || m.NAME.Equals("OTC") || m.NAME.Equals("BEAUTY")
});
lst = t.ToList();
}
break;
}
SetSessionObject(table_name, lst);
}
return(lst);
}
