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"); }