protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
RelatorioDAO dao = new RelatorioDAO();
NpgsqlDataReader dataReader = new RelatorioDAO().RelatorioValoresCondominio();
gridView1.DataSource = dao.RelatorioValoresCondominio();
gridView1.DataBind();
/*
* Fechando
* */
dataReader.Close();
dao.CloseCon();
}
}
public void MoradoresInadimplentes()
{
RelatorioDAO relatorioDao = new RelatorioDAO();
List<String[]> list = relatorioDao.RelatorioMoradoresInadimplentes();
Assert.IsTrue(list.Count == 1);
}
public void ConsultaValoresCondominio()
{
RelatorioDAO relatorioDao = new RelatorioDAO();
List<String[]> list = relatorioDao.RelatorioValoresCondominio2();
float somatorio = 0;
foreach(String[] linha in list) {
somatorio += float.Parse(linha[4], CultureInfo.InvariantCulture.NumberFormat);
}
Assert.IsTrue(list.Count == 1 && somatorio == 82); // 30+ 12 + 40
}