static void CreatePersonFileFromManualList()
{
lstUniquePerson.Clear();
lstPerson.Clear();
int counter = 0;
counter++;
//insert list here
/*
* lstPerson.Add(new Person("Sally", "Maneval", "Sally Maneval", "215 High Blvd Apt 617", "", "Wilkes Barre", "18702", "PA", "", false, false, "54", "105598423", "", ""));
*/
lstPerson.RemoveAll(x => x.PMDClientID.ToString() != pmdClientID.ToString());
int originalcount = lstPerson.Count;
DistinctListGenerator dlg = new DistinctListGenerator();
lstUniquePerson = dlg.ReturnUniqueList(lstPerson);
int uniquecount = lstUniquePerson.Count;
Console.Out.WriteLine(originalcount.ToString() + " Original Count/" + uniquecount.ToString() + " Unique Count");
}
static void CreatePersonListFromFile()
{
lstUniquePerson.Clear();
lstPerson.Clear();
string thisfilename = "meridianwhitepages.txt";
thisfilename = "summacarewhitepages.txt";
thisfilename = "healthspringwhitepages.txt";
thisfilename = "scanwhitepages.txt";
thisfilename = "highmarkwhitepages.txt";
string filename = @"c:\whitepagesapi\" + thisfilename;
StreamReader sr = new StreamReader(filename);
string line;
int counter = 0;
//lstPerson.Add(new Person("Cynthia", "Sandahl", "Cynthia Sandahl", "7412 Rolling River Pkwy ", "","Nashvile", "", "TN", null, false, false,""));
//lstPerson.Add(new Person("Arlenda", "Flannel", "Arlenda Flannel", "5089 Welbourne Cove", "", "Arlington", "38002", "TN", null, false, false));
while ((line = sr.ReadLine()) != null)
{
string[] lineParser = line.Split(new char[] { '}', '\t' });
string firstname = lineParser[4].Trim();
string middleinitial = lineParser[5].Trim();
string lastname = lineParser[6].Trim();
string street = lineParser[7].Trim();
string street2 = lineParser[8].Trim();
string city = lineParser[9].Trim();
string state = lineParser[10].Trim();
string postalcode = lineParser[11].Trim();
string pmdclientid = lineParser[16].Trim();
string pmdpatientid = lineParser[2].Trim();
string dob = lineParser[17].Trim();
//placeholder for contract number
string contractnumber = "";
counter++;
lstPerson.Add(new Person(firstname, lastname, (firstname + " " + middleinitial + " " + lastname).Replace(" ", " "), street, street2, city, postalcode, state, null, true, false, pmdclientid, pmdpatientid, dob, contractnumber));
}
int originalcount = counter;
DistinctListGenerator dlg = new DistinctListGenerator();
lstUniquePerson = dlg.ReturnUniqueList(lstPerson);
int uniquecount = lstUniquePerson.Count;
Console.Out.WriteLine(originalcount.ToString() + " Original Count/" + uniquecount.ToString() + " Unique Count");
}
static void FillPerson()
{
//ability to send across a single person
//lstPerson.Add(new Person("Brian","Williams","Brian Williams", "2788 Aston Woods Lane", "", "Thompsons Station", "37179", "TN", null, false, false));
//lstPerson.Add(new Person("Rebecca","Williams","Rebecca Williams", "2788 Aston Woods Lane", "", "Thompsons Station", "37179", "TN", null, false, false));
//lstPerson.Add(new Person("Arlenda","Flannel","Arlenda Flannel", "5089 Welbourne Cove", "", "Arlington", "38002", "TN", null, false, false));
//11.28.17 - cynthia's manual search
lstPerson.Add(new Person("Jimmy", "Graham", "Jimmy Graham", "39 Frelinghuysen Ave", "Apt 6", "Battle Creek", "49017", "MI", "", false, false, "62", "107488413", "", ""));
//lstPerson.Add(new Person("Jimmy", "Graham", "Jimmy Graham", "140 W MICHIGAN", "", "Battle Creek", "49017", "MI", "", true, false, "62", "107488413", "", ""));
lstPerson.Add(new Person("Dewayne", "Harris", "Dewayne Harris", "15600 Honore Ave", "", "Harvey", "60426", "IL", "", false, false, "62", "107496440", "", ""));
int originalcount = lstPerson.Count;
DistinctListGenerator dlg = new DistinctListGenerator();
lstUniquePerson = dlg.ReturnUniqueList(lstPerson);
int uniquecount = lstUniquePerson.Count;
Console.Out.WriteLine(originalcount.ToString() + " Original Count/" + uniquecount.ToString() + " Unique Count");
}
static void CreatePersonListFromDataBase(bool ismtm, int pmdClientID)
{
lstUniquePerson.Clear();
lstPerson.Clear();
SQLDataActions sqlDA = new SQLDataActions();
int originalcount = 0;
//taking out as of 8/20/19 BDW
/*
* //DataTable dt = sqlDA.ReturnDemographicsDataPostGres(pmdClientID);
* DataTable dt = sqlDA.ReturnDemographicsDataODS(pmdClientID);
*
* originalcount = dt.Rows.Count;
*
* foreach (DataRow dr in dt.Rows)
* {
* //postgres
* //lstPerson.Add(new Person(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()));
* lstPerson.Add(new Person(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["zip_code"].ToString().Trim(), dr["state"].ToString().Trim(), null, true, false, pmdClientID.ToString(), dr["pmd_patient_id"].ToString(), dr["dob"].ToString(), dr["contractnumber"].ToString()));
* }
*/
//section new 12/20/2017
//use the missing numbers query as well
DataTable dt2 = sqlDA.ReturnPatientsWithoutPhoneNumbers(pmdClientID, ismtm);
originalcount += dt2.Rows.Count;
foreach (DataRow dr in dt2.Rows)
{
//postgres
//lstPerson.Add(new Person(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()));
lstPerson.Add(new Person(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["secondary_address"].ToString(), dr["city"].ToString().Trim(), dr["zip_code"].ToString().Trim(), dr["state"].ToString().Trim(), null, true, false, pmdClientID.ToString(), dr["pmd_patient_id"].ToString(), dr["dob"].ToString(), dr["contractnumber"].ToString()));
}
/*
* //section new 7/25/2019 BW
* //add in specific people i want to find numbers for
* if (DateTime.Now.Month >= 10)
* {
* DataTable dt3 = sqlDA.ReturnPatientsManualListCreatedToday(pmdClientID);
*
* originalcount += dt3.Rows.Count;
*
* foreach (DataRow dr in dt3.Rows)
* {
* //postgres
* //lstPerson.Add(new Person(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()));
* lstPerson.Add(new Person(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["zip_code"].ToString().Trim(), dr["state"].ToString().Trim(), null, true, false, pmdClientID.ToString(), dr["pmd_patient_id"].ToString(), dr["dob"].ToString(), dr["contractnumber"].ToString()));
* }
* }
*/
DistinctListGenerator dlg = new DistinctListGenerator();
lstUniquePerson = dlg.ReturnUniqueList(lstPerson);
int uniquecount = lstUniquePerson.Count;
Console.Out.WriteLine(originalcount.ToString() + " Original Count/" + uniquecount.ToString() + " Unique Count");
}
