private NotificarPermissaoDoacao FillUserstItem(SqlDataReader reader) { var item = new NotificarPermissaoDoacao(); item.IdDoador = int.Parse(reader["IdDoador"].ToString()); item.Email = reader["Email"].ToString(); item.Nome = reader["Nome"].ToString(); item.PhoneNumber = reader["PhoneNumber"].ToString(); item.Sexo = int.Parse(reader["Sexo"].ToString()); item.TipoSangue = int.Parse(reader["TipoSangue"].ToString()); return(item); }
/// <summary> /// Condução que notifica os usuários que eles já podem doar /// </summary> /// <returns></returns> public IEnumerable <NotificarPermissaoDoacao> NotificarPermissaoDoacao() { var result = new List <NotificarPermissaoDoacao>(); //var connectionString = "Data Source=bloodclick.database.windows.net;Initial Catalog=bloodclick;User Id=adm;Password=Teste@123;MultipleActiveResultSets=true;"; var connectionString = "Server=(localdb)\\mssqllocaldb;Database=BloodClick;Trusted_Connection=True;MultipleActiveResultSets=true;"; using (SqlConnection conn = new SqlConnection(connectionString)) { try { SqlCommand command = new SqlCommand("[dbo].[NotificarPermissaoDoacao]", conn); command.CommandType = CommandType.StoredProcedure; conn.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { //var item = FillUserstItem(reader); var item = new NotificarPermissaoDoacao(); item.IdDoador = int.Parse(reader["IdDoador"].ToString()); item.Email = reader["Email"].ToString(); item.Nome = reader["Nome"].ToString(); item.PhoneNumber = reader["PhoneNumber"].ToString(); item.Sexo = int.Parse(reader["Sexo"].ToString()); item.TipoSangue = int.Parse(reader["TipoSangue"].ToString()); result.Add(item); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(result); }