public List <DoacaoModel> GetDoacoesPendentes(String email, String senha)
{
Conexao bd = new Conexao();
List <DoacaoModel> doacoesPendentes = new List <DoacaoModel>();
try
{
bd.conectar();
#region CommandText
bd.cmd.CommandText =
" SELECT D.IdDoacao, I.NomeFantasia, D.DataEntrega, D.DataRetirada " +
" FROM tblDoador AS DOADOR " +
" INNER JOIN tblDoacao AS D " +
" ON D.fk_IdDoador = DOADOR.IdDoador " +
" INNER JOIN tblDetalheDoacao AS DD " +
" ON DD.fk_IdDoacao = D.IdDoacao " +
" INNER JOIN tblItemDetalhe AS ID " +
" ON ID.IdItemDetalhe = DD.fk_IdItemDetalhe " +
" INNER JOIN tblInstituicao AS I " +
" ON I.CNPJ = ID.fk_CNPJ " +
" WHERE DOADOR.Email LIKE @email AND DOADOR.Senha LIKE @senha " +
" AND D.Pendente = 1 " +
" GROUP BY D.IdDoacao, I.NomeFantasia, D.DataEntrega, D.DataRetirada " +
"";
bd.cmd.Parameters.AddWithValue("@email", email);
bd.cmd.Parameters.AddWithValue("@senha", senha);
#endregion
bd.dr = bd.cmd.ExecuteReader();
if (bd.dr.HasRows)
{
while (bd.dr.Read())
{
DoacaoModel doacao = new DoacaoModel();
doacao.Cod = bd.dr[0].ToString();
doacao.Instituicao = bd.dr[1].ToString();
doacao.DataParaDoar = bd.dr[2].ToString();
doacao.DataParaRetirada = bd.dr[3].ToString();
doacoesPendentes.Add(doacao);
}
}
bd.cmd.Parameters.Clear();
bd.fechaConexao();
}
catch (System.Data.SqlClient.SqlException)
{
bd.cmd.Parameters.Clear();
bd.fechaConexao();
doacoesPendentes = null;
}
return(doacoesPendentes);
}
public ActionResult <String> Post([FromBody] DoacaoModel value)
{
string APPID = "8415c4fb-f7cd-471d-ac73-5ffbb586db7f";
string APIKey = "tSQLNweF9i8UDEg/+/J8IvI+YpM8bPirEC0AhtAqzbE=";
bool Sucess;
Hall9001 objHall9001 = new Hall9001("https://bootcamp.profitfy.trade/", APPID, APIKey);
//Retorna os pares negociados na Profitfy
List <Markets> Markets = objHall9001.Markets(out Sucess);
return("0x9a138cfa1ccff75d03140c51af9780d6233292b8");
//return "1";
}
