private List <ProviderMpiVo> GetData(QueryGridProvider queryInfo)
{
var resultPro = new List <ProviderMpiVo>();
var providerList = new List <ProviderMpiVo>();
using (var context = new DefaulDataContext())
{
var provider = (from item in context.ProviderAgencies
select item);
bool isQuery = false;
if (!string.IsNullOrEmpty(queryInfo.Npi))
{
provider = provider.Where(o => o.Npi.ToLower().Contains(queryInfo.Npi.ToLower()));
isQuery = true;
}
else if (!string.IsNullOrEmpty(queryInfo.Mpi))
{
provider = provider.Where(o => o.Mpi.ToLower().Contains(queryInfo.Mpi.ToLower()));
isQuery = true;
}
else if (!string.IsNullOrEmpty(queryInfo.AgencyName))
{
provider = provider.Where(o => o.Name.ToLower().Contains(queryInfo.AgencyName.ToLower()));
isQuery = true;
}
if (!isQuery)
{
return(new List <ProviderMpiVo>());
}
providerList = (from p in provider
select new ProviderMpiVo()
{
Id = p.Mpi,
Mpi = p.Mpi,
Npi = p.Npi,
Name = p.Name,
Address1 = p.Address1,
Address2 = p.Address2,
City = p.City,
State = p.State,
Zip = p.Zip,
Phone = p.Phone,
Email = p.Email,
}).ToList();
resultPro = providerList.ToList();
}
foreach (var item in providerList.Where(item => !CheckEffectiveDate(item.Mpi)))
{
resultPro.Remove(item);
}
return(resultPro);
}
public dynamic GetListProvider(QueryGridProvider queryInfo)
{
var finalResult = GetData(queryInfo);
var total = finalResult.Count();
dynamic result = new ExpandoObject();
result.Data = finalResult.Skip(queryInfo.skip).Take(queryInfo.take);
result.TotalRowCount = total;
return(result);
}
