public IEnumerable <Model.organization> Filter(Model.organization filterObj)
{
var db = new HealthvaultContext();
var ret = from o in db.organization
select o;
if (filterObj.identifier > 0)
{
ret = ret.Where(o => o.identifier == filterObj.identifier);
}
if (filterObj.address_city > 0)
{
ret = ret.Where(o => o.address_city == filterObj.address_city);
}
if (filterObj.partOf > 0)
{
ret = ret.Where(o => o.partOf == filterObj.partOf);
}
if (filterObj.type > 0)
{
ret = ret.Where(o => o.type == filterObj.type);
}
return(ret.ToList());
}
//lut_general_usages
public IEnumerable <lut_general_usages> lut_general_usages_GetTable(string stTableName)
{
var db = new HealthvaultContext();
return(from t in db.lut_general_usages
where t.table_name == stTableName
select t);
}
public IEnumerable <lut_organizationtype> lut_organizationtype_Filter(lut_organizationtype filterObj)
{
var db = new HealthvaultContext();
return(from c in db.lut_organizationtype
where (filterObj.Identifier > 0 && c.Identifier == filterObj.Identifier)
select c);
}
public IEnumerable <lut_city> lut_city_Filter(lut_city filterObj)
{
var db = new HealthvaultContext();
return(from c in db.lut_city
where (filterObj.Identifier > 0 && c.Identifier == filterObj.Identifier)
select c);
}
/*
* string Identifier,
* string addressCity
* string addressState
*
* */
/*
* blic IEnumerable<organization> GetOrganization( string Identifier,
* string addressCity,
* string partof,
* string type,
* string active,
* string addressState)
*/
public IEnumerable <Model.patient> Filter(Model.patient filterObj)
{
var db = new HealthvaultContext();
var ret = from o in db.patient
select o;
if (String.IsNullOrEmpty(filterObj.identifier) == false)
{
ret = ret.Where(o => o.identifier == filterObj.identifier);
}
if (filterObj.address_city > 0)
{
ret = ret.Where(o => o.address_city == filterObj.address_city);
}
if (String.IsNullOrEmpty(filterObj.address) == false)
{
ret = ret.Where(o => o.address.Contains(filterObj.address) == true);
}
if (filterObj.deceased == true)
{
ret = ret.Where(o => o.deceased == true);
if (filterObj.deceased_date > DateTime.MinValue)
{
ret = ret.Where(o => o.deceased_date == filterObj.deceased_date);
}
}
if (String.IsNullOrEmpty(filterObj.email) == false)
{
ret = ret.Where(o => o.email.Contains(filterObj.email) == true);
}
if (String.IsNullOrEmpty(filterObj.familyname) == false)
{
ret = ret.Where(o => o.familyname.Contains(filterObj.familyname) == true);
}
if (String.IsNullOrEmpty(filterObj.name) == false)
{
ret = ret.Where(o => o.name.Contains(filterObj.name) == true);
}
return(ret.ToList());
}
public IEnumerable <Model.organization> GetAll()
{
var db = new HealthvaultContext();
return(db.organization.ToList());
}
public IEnumerable <Model.patient> GetAll()
{
var db = new HealthvaultContext();
return(db.patient.ToList());
}
public IEnumerable <lut_city> lut_city_GetAll()
{
var db = new HealthvaultContext();
return(db.lut_city.ToList());
}
//lut_organizationtype
public IEnumerable <lut_organizationtype> lut_organizationtype_GetAll()
{
var db = new HealthvaultContext();
return(db.lut_organizationtype.ToList());
}
