public dynamic GetListNpi(QueryGridPhysicianVo 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);
}
private List <PhysicianGridVo> GetData(QueryGridPhysicianVo queryInfo)
{
var resultNpi = new List <PhysicianGridVo>();
var npiList = new List <PhysicianGridVo>();
using (var context = new DefaulDataContext())
{
var npis = (from item in context.PhysicianNpis
select item);
bool isQuery = false;
if (!string.IsNullOrEmpty(queryInfo.NPI))
{
npis = npis.Where(o => o.Npi == queryInfo.NPI);
isQuery = true;
}
else
{
if (!string.IsNullOrEmpty(queryInfo.FirstName))
{
npis = npis.Where(o => o.FirstName.ToUpper() == queryInfo.FirstName.ToUpper());
isQuery = true;
}
if (!string.IsNullOrEmpty(queryInfo.LastName))
{
npis = npis.Where(o => o.LastName.ToUpper() == queryInfo.LastName.ToUpper());
isQuery = true;
}
}
if (!isQuery)
{
return(new List <PhysicianGridVo>());
}
npiList = (from p in npis
select new PhysicianGridVo()
{
Mpi = p.Mpi,
Npi = p.Npi,
FirstName = p.FirstName,
LastName = p.LastName,
MiddleName = p.MiddleName,
Address1 = p.Address1,
Address2 = p.Address2,
City = p.City,
State = p.State,
Zip = p.Zip,
ZipExtension = p.ZipExtension,
Phone = p.Phone,
Fax = "",
ClinicName = "",
EffectiveDateText = p.EffectiveDateText,
}).ToList();
resultNpi = npiList.ToList();
}
foreach (var item in npiList.Where(item => !CheckEffectiveDate(item.Npi)))
{
resultNpi.Remove(item);
}
return(resultNpi);
}
