private void genReporte(string sdate, string edate)
{
Cliente c = new Cliente();
DataTable dt = c.IngresoMensual(sdate, edate);
// clienteListalv. = dt;
int[] colsize = { 90, 70, 250, 60, 90, 90, 90 };
LlenarLista llenar = new LlenarLista(this.m_list, dt, colsize);
//FillList(this.m_list, dt);
SqlDataReader ingreso = c.IngresoMensualSuma(sdate, edate);
//populate total
ListViewItem item = new ListViewItem();
item.Text = "TOTAL";
item.SubItems.Add("-");
item.SubItems.Add("-");
item.SubItems.Add("-");
if (ingreso.Read())
{
item.SubItems.Add(ingreso["Capital"].ToString()); //capital
item.SubItems.Add(ingreso["Interes"].ToString()); //interes
// item.SubItems.Add(ingreso["Mora"].ToString()); //mora place holder
item.SubItems.Add(ingreso["Monto"].ToString());
double capitalstr = 0.00;
double interesstr = 0.00;
double morastr = 0.00;
double t = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
if (ingreso["Interes"].ToString() != "")
{
interesstr = Double.Parse(ingreso["Interes"].ToString());
}
if (ingreso["Mora"].ToString() != "")
{
morastr = Double.Parse(ingreso["Mora"].ToString());
}
capitallb.Text = String.Format("{0:C}", capitalstr);
interestlb.Text = String.Format("{0:C}", interesstr);
moralb.Text = String.Format("{0:C}", morastr);
t = capitalstr + interesstr + morastr;
totallb.Text = String.Format("{0:C}", t);
}
this.m_list.Items.Add(item);
this.m_list.ResumeLayout();
}
private void genReporte(string sdate, string edate)
{
Cliente c = new Cliente();
DataTable dt = c.IngresoMensual(sdate, edate);
// clienteListalv. = dt;
int[] colsize = {90,70,250,60,90,90,90 };
LlenarLista llenar = new LlenarLista(this.m_list, dt,colsize);
//FillList(this.m_list, dt);
SqlDataReader ingreso = c.IngresoMensualSuma(sdate, edate);
//populate total
ListViewItem item = new ListViewItem();
item.Text = "TOTAL";
item.SubItems.Add("-");
item.SubItems.Add("-");
item.SubItems.Add("-");
if (ingreso.Read())
{
item.SubItems.Add(ingreso["Capital"].ToString()); //capital
item.SubItems.Add(ingreso["Interes"].ToString()); //interes
// item.SubItems.Add(ingreso["Mora"].ToString()); //mora place holder
item.SubItems.Add(ingreso["Monto"].ToString());
double capitalstr = 0.00;
double interesstr = 0.00;
double morastr = 0.00;
double t = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
if (ingreso["Interes"].ToString() != "")
{
interesstr = Double.Parse(ingreso["Interes"].ToString());
}
if (ingreso["Mora"].ToString() != "")
{
morastr = Double.Parse(ingreso["Mora"].ToString());
}
capitallb.Text = String.Format("{0:C}", capitalstr);
interestlb.Text = String.Format("{0:C}", interesstr);
moralb.Text = String.Format("{0:C}", morastr);
t = capitalstr + interesstr + morastr;
totallb.Text = String.Format("{0:C}", t);
}
this.m_list.Items.Add(item);
this.m_list.ResumeLayout();
}
private void loadIngresoAno()
{
string todaymes = DateTime.Now.ToString("yyyy-01-01");
string today = DateTime.Now.ToString("yyyy-MM-dd");
Cliente c = new Cliente();
SqlDataReader ingreso = c.IngresoMensualSuma(todaymes, today);
//populate total
if (ingreso.Read())
{
double capitalstr = 0.00;
double interesstr = 0.00;
double morastr = 0.00;
double t = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
if (ingreso["Interes"].ToString() != "")
{
interesstr = Double.Parse(ingreso["Interes"].ToString());
}
if (ingreso["Mora"].ToString() != "")
{
morastr = Double.Parse(ingreso["Mora"].ToString());
}
anocapitallb.Text = String.Format("{0:N}", capitalstr);
anointereslb.Text = String.Format("{0:N}", interesstr);
anomoralb.Text = String.Format("{0:N}", morastr);
t = capitalstr + interesstr + morastr;
anototallb.Text = String.Format("{0:N}", t);
}
ingreso.Close();
}
private void loadIngresoAno()
{
string todaymes = DateTime.Now.ToString("yyyy-01-01");
string today = DateTime.Now.ToString("yyyy-MM-dd");
Cliente c = new Cliente();
SqlDataReader ingreso = c.IngresoMensualSuma(todaymes, today);
//populate total
if (ingreso.Read())
{
double capitalstr = 0.00;
double interesstr = 0.00;
double morastr = 0.00;
double t = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
if (ingreso["Interes"].ToString() != "")
{
interesstr = Double.Parse(ingreso["Interes"].ToString());
}
if (ingreso["Mora"].ToString() != "")
{
morastr = Double.Parse(ingreso["Mora"].ToString());
}
anocapitallb.Text = String.Format("{0:N}", capitalstr);
anointereslb.Text = String.Format("{0:N}", interesstr);
anomoralb.Text = String.Format("{0:N}", morastr);
t = capitalstr + interesstr + morastr;
anototallb.Text = String.Format("{0:N}", t);
}
ingreso.Close();
}