public ExamItemsPagination PreviewForSelect(string examId)
{
ExamItemsPagination pagination = new ExamItemsPagination();
string query1 = $"EXECUTE SP_PreviewForSelect '{examId}'";
pagination.Items = _db.Database.SqlQuery <MannualItems>(query1).ToList();
return(pagination);
}
public ExamItemsPagination MannualItems(int page)
{
ExamItemsPagination pagination = new ExamItemsPagination();
string query1 = $"EXECUTE SP_MannualItems {page}";
pagination.Items = _db.Database.SqlQuery <MannualItems>(query1).ToList();
string query2 = $"EXECUTE SP_ExamItemsTotalRows";
pagination.TotalRows = _db.Database.SqlQuery <int>(query2).FirstOrDefault();
return(pagination);
}
