public dynamic getDisByCbId(DisFilter disFilter)
{
DateTime startday = DateTime.ParseExact(disFilter.startday, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime endday = DateTime.ParseExact(disFilter.endday, "dd/MM/yyyy", CultureInfo.InvariantCulture);
var data = from user in context.Users
join file in context.Files
on user.usid equals file.usid
join dis in context.Discipline
on file.fileid equals dis.fileid
where dis.daycreate >= startday && file.cbid == disFilter.cbid &&
dis.daycreate <= endday
select new
{
user.madv,
file.hotendangdung,
file.avatar,
file.ngayvaodangct,
dis.daycreate,
dis.noidung,
dis.dsid,
dis.accept,
user.usid
};
return(data);
}
public dynamic filteDisByBox(DisFilter disFilter)
{
var data = from user in context.Users
join file in context.Files
on user.usid equals file.usid
join dis in context.Discipline
on file.fileid equals dis.fileid
where file.cbid == disFilter.cbid
select new
{
user.madv,
file.fileid,
file.hotendangdung,
file.avatar,
file.ngayvaodangct,
dis.daycreate,
dis.noidung
};
if (disFilter.filter == null)
{
disFilter.filter = "";
}
var filterby = disFilter.filter.Trim().ToLowerInvariant();
return(data.AsQueryable()
.Where(n =>
n.madv.ToLowerInvariant().Contains(filterby) ||
n.hotendangdung.ToLowerInvariant().Contains(filterby) ||
n.noidung.ToLowerInvariant().Contains(filterby)));
}
public DataRespond filterByBox(DisFilter disFilter)
{
DataRespond data = new DataRespond();
try
{
data.success = true;
data.message = "filter success";
data.data = m_adDisciplineResponsitory.filteDisByBox(disFilter);
}
catch (Exception e)
{
data.message = e.Message;
data.success = false;
data.error = e;
}
return(data);
}
