public DataTable GetEnrollmentData()
{
Database db = new Database("CLAIMS");
try
{
DataTable dt = db.ExecuteString("select top 100 a.MEMBER,A.FIRSTNAME,a.RELCOD,a.LASTNAME,a.MIDINIT,b.SOCSEC,b.HOMEPH,b.ADRLN1,b.ADRLN2,b.CITYCD,b.STACOD,b.ZIPCOD,b.BTHDAT,b.SEXCOD,b.EMAIL from Member as a join Demograp as b on a.MEMBER=b.MEMBNO").Tables[0];
if (dt != null)
return dt;
else
return null;
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
finally
{
db.Close();
}
}
public DataTable GetHealthCoverage(string memID)
{
Database db = new Database("CLAIMS");
string query = "select MEMBER,EXPDAT,BENPKG,EFFDAT from MembCovr where MembCovr.MEMBER='" + memID + "'";
try
{
DataTable dt = db.ExecuteString(query).Tables[0];
if (dt != null)
return dt;
else
return null;
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
finally
{
db.Close();
}
}
