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