public FinanceirosType selectByAssociacao(AssociacaoType assoc, string ano, string mes)
{
FinanceirosType types = new FinanceirosType();
MySqlConnection con = new MySqlConnection(Dados.StringConexao);
string SQL = "SELECT * FROM financeiro " +
"WHERE id_associacao = @id " +
"AND YEAR(financeiro.`data`) = @ano " +
"AND MONTH(financeiro.`data`) = @mes " +
"ORDER BY `data`, `id_financeiro`";
MySqlCommand cmd = new MySqlCommand(SQL, con);
cmd.Parameters.AddWithValue("@id", assoc.IdAssociacao);
cmd.Parameters.AddWithValue("@ano", ano);
cmd.Parameters.AddWithValue("@mes", mes);
con.Open();
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
types.Add(execReader(dr));
}
return(types);
}
public FinanceirosType selectByAssociacao(AssociacaoType assoc, string ano, string mes)
{
FinanceirosType types = new FinanceirosType();
MySqlConnection con = new MySqlConnection(Dados.StringConexao);
string SQL = "SELECT * FROM financeiro " +
"WHERE id_associacao = @id " +
"AND YEAR(financeiro.`data`) = @ano " +
"AND MONTH(financeiro.`data`) = @mes " +
"ORDER BY `data`, `id_financeiro`";
MySqlCommand cmd = new MySqlCommand(SQL, con);
cmd.Parameters.AddWithValue("@id", assoc.IdAssociacao);
cmd.Parameters.AddWithValue("@ano", ano);
cmd.Parameters.AddWithValue("@mes", mes);
con.Open();
MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
types.Add(execReader(dr));
}
return types;
}
