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