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 }