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);
}
