private List <Entities.MonthlyCommentsModel> GetCommentsData() { List <Entities.MonthlyCommentsModel> lst = new List <Entities.MonthlyCommentsModel>(); using (Entities.godzillaCommentsEntities db = new Entities.godzillaCommentsEntities()) { var q = db.v_WRK_MONTHLY_COMMENTS_DATA .Select(m => m).ToList(); lst = q .Where(p => p.YEAR_PERIOD == Helpers.PeriodUtil.Year && p.MONTH_PERIOD == Helpers.PeriodUtil.Month) .Select(m => new Entities.MonthlyCommentsModel { name = m.NAME, month_market_growth = m.MONTH_MARKET_GROWTH, month_brand_growth = m.MONTH_BRAND_GROWTH, month_market_share = m.MONTH_MARKET_SHARE, month_pt = m.MONTH_PT, ytd_market_growth = m.YTD_MARKET_GROWTH, ytd_brand_growth = m.YTD_BRAND_GROWTH, ytd_market_share = m.YTD_MARKET_SHARE, ytd_pt = m.YTD_PT }).ToList(); } return(lst); }
public ActionResult GetComments() { using (Entities.godzillaCommentsEntities db = new Entities.godzillaCommentsEntities()) { var t = db.v_WRK_MONTHLY_COMMENTS_DATA .Where(m => m.CHANNEL < 9 && m.MONTH_PERIOD == Helpers.PeriodUtil.Month && m.YEAR_PERIOD == Helpers.PeriodUtil.Year) .Select(m => m).ToList(); ViewBag.CommentsData = t.ToList(); } ViewBag.UpdateAction = CONTROLLER + "/GetCommentsByChannel"; ViewBag.EditAction = CONTROLLER + "/GetCommentById"; ViewBag.CurrentUser = Helpers.UserUtils.UserName; return(PartialView(MONTHLYCOMMENTS_COMMENTS, GetCommentsText())); }
private List <Entities.LETTERS_COMMENT_DATA> GetCommentsText(int?_channel) { List <Entities.LETTERS_COMMENT_DATA> lst = new List <Entities.LETTERS_COMMENT_DATA>(); using (Entities.godzillaCommentsEntities db = new Entities.godzillaCommentsEntities()) { var q = db.LETTERS_COMMENT_DATA .Where(m => m.TYPE == Entities.CommentTypes.MONTHLY_COMMENTS && m.MONTH_PERIOD == Helpers.PeriodUtil.Month && m.YEAR_PERIOD == Helpers.PeriodUtil.Year && (_channel == null || (_channel != null && m.LETTER_ID == _channel))) .Select(m => m).ToList(); lst = q.Select(m => m).ToList(); } return(lst); }