private void ultimos_pagamentos_Load(object sender, EventArgs e)
{
PessoaDAL pd = new PessoaDAL();
List <Lixo> l = pd.ListarLixo();
for (int i = 0; i < l.Count; i++)
{
dataGridView1.Rows.Add(new object[] { l[i].Nome_Cliente, l[i].Produto, l[i].Data_Pagamento, l[i].Valor_Pago, l[i].Cod_Lixeira });
}
Decimal soma = pd.SomaDividas();
lblquantomedevem.Text = Convert.ToString(soma);
///////////////////////////////////////////////////////////////////////////////////// somantorio de dividas no dia
DateTime dt1 = new DateTime();
dt1 = DateTime.Now;
String data1 = dt1.ToString();
Decimal somatoriodia = 0;
Decimal somatoriomes = 0;
for (int i = 0; i < (dataGridView1.Rows.Count) - 1; i++)
{
if ((dataGridView1.Rows[i].Cells[2].Value.ToString())[0].Equals(data1[0]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[1].Equals(data1[1]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[3].Equals(data1[3]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[4].Equals(data1[4]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[6].Equals(data1[6]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[7].Equals(data1[7]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[8].Equals(data1[8]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[9].Equals(data1[9]))// pegando as datas de hoje
{
somatoriodia = somatoriodia + Convert.ToDecimal(dataGridView1.Rows[i].Cells[3].Value.ToString());
}
}
lblquantomepagaramhje.Text = Convert.ToString(somatoriodia);
for (int i = 0; i < (dataGridView1.Rows.Count) - 1; i++)
{
if ((dataGridView1.Rows[i].Cells[2].Value.ToString())[3].Equals(data1[3]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[4].Equals(data1[4]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[6].Equals(data1[6]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[7].Equals(data1[7]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[8].Equals(data1[8]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[9].Equals(data1[9])) // pegando as datas de hoje
{
somatoriomes = somatoriomes + Convert.ToDecimal(dataGridView1.Rows[i].Cells[3].Value.ToString());
}
}
lblmepagaramessemes.Text = Convert.ToString(somatoriomes);
}