public dynamic getUseByCbid(AbroadFilter filter) { DateTime startday = DateTime.ParseExact(filter.startday, "dd/MM/yyyy", CultureInfo.InvariantCulture); DateTime endday = DateTime.ParseExact(filter.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 abroad in context.Toabroad on file.fileid equals abroad.fileid where abroad.thoigiandi >= startday && abroad.thoigiandi <= endday select new { user.madv, file.hotendangdung, file.avatar, file.ngayvaodangct, abroad.thoigiandi, abroad.thoigiantrove, abroad.lydo, abroad.brid, abroad.noiden, abroad.accept }; return(data); }
public dynamic filterAbroadByBox(AbroadFilter abroadFilter) { var data = from user in context.Users join file in context.Files on user.usid equals file.usid join abroad in context.Toabroad on file.fileid equals abroad.fileid where file.cbid == abroadFilter.cbid select new { user.madv, file.hotendangdung, file.avatar, file.ngayvaodangct, abroad.thoigiandi, abroad.thoigiantrove, abroad.lydo, abroad.brid, abroad.noiden }; if (abroadFilter.filter == null) { abroadFilter.filter = ""; } var filterby = abroadFilter.filter.Trim().ToLowerInvariant(); return(data.AsQueryable() .Where(n => n.madv.ToLowerInvariant().Contains(filterby) || n.hotendangdung.ToLowerInvariant().Contains(filterby) || n.noiden.ToLowerInvariant().Contains(filterby))); }
public DataRespond filterByBox(AbroadFilter abroadFilter) { DataRespond data = new DataRespond(); try { data.success = true; data.message = "filter success"; data.data = m_adToabroadResponsitory.filterAbroadByBox(abroadFilter); } catch (Exception e) { data.success = false; data.message = e.Message; data.error = e; } return(data); }
public DataRespond getUserByCbId(AbroadFilter abroadFilter) { DataRespond data = new DataRespond(); try { data.success = true; data.message = "success"; data.data = m_adToabroadResponsitory.getUseByCbid(abroadFilter); } catch (Exception e) { data.message = e.Message; data.error = e; data.success = false; } return(data); }