public List <accccc> GetDichVu()
{
int from = 1;
int to = 3;
int ID = 61;
List <dynamic> arr = new List <dynamic>();
arr.AddRange((from p in sql.tblNews where p.STATUS == 1 && (p.CATEGORYID.IndexOf(ID + ";") > -1 || p.CATEGORYID.Replace(";", "").Equals(ID.ToString()))select new { id = p.ID, time = p.CREATED_DATE, type = 0 }).OrderByDescending(d => d.time).Take(to));
arr.AddRange((from p in sql.tblQuizs where p.Status == 1 select new { id = p.ID, time = p.CreateDate, type = 1 }).OrderByDescending(d => d.time).Take(to));
arr = arr.OrderByDescending(d => d.time).ToList();
List <accccc> arrRe = new List <accccc>();
to = to > arr.Count ? arr.Count : to;
for (int i = from - 1; i < to; i++)
{
dynamic nData = arr[i];
accccc _data = new accccc();
int nId = Convert.ToInt32(nData.id);
if (nData.type == 0)
{
tblNew _new = (from p in sql.tblNews where p.ID == nId select p).FirstOrDefault();
_data.ID = _new.ID;
_data.CATEGORYNAME = "0";
_data.TITLE = _new.TITLE;
_data.IMAGE = _new.IMAGE;
_data.SUMMARY = _new.SUMMARY;
_data.CREATED_DATE = _new.CREATED_DATE;
_data.RowNumber = to - (to - i);
_data.RecordsTotal = to + 1;
arrRe.Add(_data);
}
else
{
tblQuiz _quiz = (from p in sql.tblQuizs where p.ID == nId select p).FirstOrDefault();
_data.ID = _quiz.ID;
_data.CATEGORYNAME = "quiz";
_data.TITLE = _quiz.Title;
_data.IMAGE = _quiz.Img;
_data.SUMMARY = _quiz.Des;
_data.CREATED_DATE = _quiz.CreateDate;
_data.RowNumber = to - (to - i);
_data.RecordsTotal = to + 1;
arrRe.Add(_data);
}
}
return(arrRe);
}
public List <accccc> GetHoTro()
{
int ID = 49;
List <accccc> arrRe = new List <accccc>();
foreach (var _new in (from p in sql.tblNews where p.STATUS == 1 && (p.CATEGORYID.IndexOf(ID + ";") > -1 || p.CATEGORYID.Replace(";", "").Equals(ID.ToString())) select p).OrderByDescending(d => d.CREATED_DATE).Take(3))
{
accccc _data = new accccc();
_data.CATEGORYNAME = "0";
_data.ID = _new.ID;
_data.TITLE = _new.TITLE;
_data.IMAGE = _new.IMAGE;
_data.SUMMARY = _new.SUMMARY;
_data.CREATED_DATE = _new.CREATED_DATE;
arrRe.Add(_data);
}
return(arrRe);
}
public List <accccc> GetTracNghiem(int page)
{
int pageSize = 4;
List <accccc> arrRe = new List <accccc>();
foreach (var _new in (from p in sql.tblQuizs where p.Status == 1 select p).OrderByDescending(d => d.CreateDate).Skip((page - 1) * pageSize).Take(pageSize))
{
accccc _data = new accccc();
_data.CATEGORYNAME = "quiz";
_data.ID = _new.ID;
_data.TITLE = _new.Title;
_data.IMAGE = _new.Img;
_data.SUMMARY = _new.Des;
_data.CREATED_DATE = _new.CreateDate;
arrRe.Add(_data);
}
return(arrRe);
}
