public async Task <DatailVM> GetDetailData()
{
DatailVM response = new DatailVM();
var query = (from q in dBContext.Questions
join c in dBContext.Comments on q.QuestionId equals c.QuestionId
where c.CGOLD != null &&
q.Active &&
(q.Label || q.LabelComplete) &&
q.UserId == 2
select c
).ToList();
response.Total = query.Count();
response.Good = query.Where(x => x.CGOLD == "Good").Count();
response.Potential = query.Where(x => x.CGOLD == "Potential").Count();
response.Bad = query.Where(x => x.CGOLD == "Bad").Count();
response.NullCount = query.Where(x => x.CGOLD == "" || string.IsNullOrEmpty(x.CGOLD)).Count();
response.Active = dBContext.Questions.Where(x => x.Active).Count();
response.Reject = dBContext.Questions.Where(x => x.Reject).Count();
response.Adv = dBContext.Questions.Where(x => x.IsAdv).Count();
return(response);
}
public IActionResult Detail()
{
DatailVM model = SemEvalRepository.GetDetailData().Result;
return(View(model));
}
