Пример #1
0
        public List <Rehber> KayitListe()
        {
            List <Rehber> RehberListesi = new List <Rehber>();

            try
            {
                SqlDataReader reader = dll.KayitListe();
                while (reader.Read())
                {
                    RehberListesi.Add(new Rehber
                    {
                        ID                 = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0),
                        Isim               = reader.IsDBNull(1) ? string.Empty : reader.GetString(1),
                        Soyisim            = reader.IsDBNull(2) ? string.Empty : reader.GetString(2),
                        TelefonNumarasiI   = reader.IsDBNull(3) ? string.Empty : reader.GetString(3),
                        TelefonNumarasiII  = reader.IsDBNull(4) ? string.Empty : reader.GetString(4),
                        TelefonNumarasiIII = reader.IsDBNull(5) ? string.Empty : reader.GetString(5),
                        EmailAdres         = reader.IsDBNull(6) ? string.Empty : reader.GetString(6),
                        WebAdres           = reader.IsDBNull(7) ? string.Empty : reader.GetString(7),
                        Aciklama           = reader.IsDBNull(8) ? string.Empty : reader.GetString(8)
                    });
                }
                reader.Close();
            }
            catch (Exception e)
            {
            }
            finally
            {
                dll.BaglantiAyarla();
            }
            return(RehberListesi);
        }