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