private static void InsertPatientRecord(Patient patient,string connection )
 {
 }
        private static void ImportDemographics()
        {

            string patientID = string.Empty;
            string firstName = string.Empty;
            string lastName = string.Empty;
            string Middle = string.Empty;
            string dateOfBirth = string.Empty;
            string age = string.Empty;
            string sex = string.Empty;
            string address1 = string.Empty;
            string address2 = string.Empty;
            string city = string.Empty;
            string state = string.Empty;
            string zip = string.Empty;
            string phone = string.Empty;

            StreamReader importFile = null;
            string line = string.Empty;

            importFile = File.OpenText("E:\\backups\\demographics.csv");

            while ((line = importFile.ReadLine()) != null)
            {
                string[] demographics = line.Split(',');

                patientID = StripCharacters(demographics[0]);
                firstName = StripCharacters(demographics[1]);
                lastName = StripCharacters(demographics[2]);
                Middle = StripCharacters(demographics[3]);
                dateOfBirth = StripCharacters(demographics[6]);
                age = StripCharacters(demographics[7]);
                sex = StripCharacters(demographics[8]);
                address1 = StripCharacters(demographics[10]);
                address2 = StripCharacters(demographics[11]);
                city = StripCharacters(demographics[12]);
                state = StripCharacters(demographics[13]);
                zip = StripCharacters(demographics[14]);
                phone = StripCharacters(demographics[15]);

                Patient patient = new Patient();
                patient.PatientID = patientID;
                patient.FirstName = firstName;
                patient.LastName = lastName;
                patient.Middle = Middle;
                patient.Address1 = address1;
                patient.Address2 = address2;
                patient.City = city;
                patient.State = state;
                patient.Zip = zip;
                patient.Phone = phone;
                patient.DateOfBirth = dateOfBirth;
                patient.Age = age;
                patient.Sex = sex;

                InsertPatient(patient,connection);

            }
        }
        private static void InsertPatient(Patient patient, string connection)
        {
            try
            {
                using (SqlConnection db = new SqlConnection(connection))
                {
                    string query = "INSERT INTO [Patients]("
                        + " [PatientID],[FirstName],[Middle],[LastName],[Address1],[Address2],[City]"
                        + " ,[State],[Zip],[Phone],[Sex],[DateOfBirth],[Age]"
                        + " )"
                        + " VALUES("
                        + " @PatientID,@FirstName,@Middle,@LastName,@Address1,@Address2,@City"
                        + " ,@State,@Zip,@Phone,@Sex,@DateOfBirth,@Age";

                    int rowsAffectd = db.Execute(query, new
                    {
                        @PatientID = patient.PatientID,
                        @FirstName = patient.FirstName,
                        @Middle = patient.Middle,
                        @LastName = patient.LastName,
                        @Address1 = patient.Address1,
                        @Address2 = patient.Address2,
                        @City = patient.City,
                        @State = patient.State,
                        @Zip = patient.Zip,
                        @Phone = patient.Phone,
                        @Sex = patient.Sex,
                        @DateOfBirth = patient.DateOfBirth,
                        @Age = patient.Age
                    }
                );
                    int rr = rowsAffectd;
                }
                // File.Copy(file.FullName, "E:\\temp\\" + temp[2]);
            }
            catch (Exception er)
            {
                string s1 = er.ToString();
                //Log.LogMessage(er.ToString());
                //return patients;
            }
        }