Esempio n. 1
0
        private static List <Provider> SetProvidersFromReader(SqlDataReader reader)
        {
            var providerList = new List <Provider>();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    providerList.Add(new Provider
                    {
                        npi  = reader["NPI"].ToString(),
                        name = new ProviderName
                        {
                            first  = reader["FIRSTNAME"].ToString(),
                            middle = reader["MIDDLENAME"].ToString(),
                            last   = reader["LASTNAME"].ToString(),
                            suffix = String.IsNullOrEmpty(reader["SUFFIX"].ToString())
                                ? null : reader["Suffix"].ToString()
                        },
                        address = new Address
                        {
                            address   = reader["LINE1"].ToString(),
                            address_2 = reader["LINE2"].ToString(),
                            city      = reader["CITY"].ToString(),
                            state     = reader["STATE"].ToString(),
                            zip       = reader["ZIP"].ToString()
                        },
                        specialty = new List <string>
                        {
                            EnumUtility.Convert(
                                (DentalProviderSpecialty)Enum.Parse(typeof(DentalProviderSpecialty),
                                                                    reader["PROVIDERSPECIALTY"].ToString()))
                        },
                        phone           = reader["PHONENUMBER"].ToString(),
                        networks        = reader["NETWORK"].ToString(),
                        network_type    = reader["NETWORKTYPE"].ToString(),
                        import_type     = reader["IMPORTTYPE"].ToString(),
                        accepting       = Boolean.Parse(reader["NEWPATIENTS"].ToString()),
                        last_updated_on = DateTime.Today.ToString("yyyy-MM-dd")
                    });
                }
            }
            return(providerList);
        }