private static void CreateProviderListFromDataBase()
{
lstUniqueProvider.Clear();
lstProviders.Clear();
SQLDataActions sqlDA = new SQLDataActions();
//DataTable dt = sqlDA.ReturnProviderList();
DataTable dt = new DataTable();
int originalcount = dt.Rows.Count;
foreach (DataRow dr in dt.Rows)
{
//postgres
//lstProvider.Add(new Provider(dr["firstname"].ToString().Trim(), dr["lastname"].ToString().Trim(), dr["firstname"].ToString().Trim() + " " + dr["middleinitial"].ToString().Trim() + " " + dr["lastname"].ToString().Trim(), dr["street"].ToString().Trim(), "", dr["city"].ToString().Trim(), dr["zipcode"].ToString().Trim(), dr["state"].ToString().Trim(), null, false, false, dr["dob"].ToString()));
lstProviders.Add(new Providers(dr["name"].ToString().Trim(), dr["street"].ToString().Trim(), "", dr["city"].ToString().Trim(), dr["zip_code"].ToString().Trim(), dr["state"].ToString().Trim(), null, true, false, null, dr["npi"].ToString()));
}
DistinctListGenerator dlg = new DistinctListGenerator();
lstUniqueProvider = dlg.ReturnUniqueList(lstProviders);
int uniquecount = lstUniqueProvider.Count;
Console.Out.WriteLine(originalcount.ToString() + " Original Count/" + uniquecount.ToString() + " Unique Count");
}
static void FillProvider()
{
//ability to send across a single person
/*
* lstProviders.Add(new Providers("Michael Khadavi", "315 Business Loop 70 W", "", "Columbia", "652033248", "MO", "", false, false, "", "1003050204"));
*/
int originalcount = lstProviders.Count;
DistinctListGenerator dlg = new DistinctListGenerator();
lstUniqueProvider = dlg.ReturnUniqueList(lstProviders);
int uniquecount = lstUniqueProvider.Count;
Console.Out.WriteLine(originalcount.ToString() + " Original Count/" + uniquecount.ToString() + " Unique Count");
}