private void button1_Click(object sender, EventArgs e)
{
//Worksheet currentSheet = Globals.Hoja1.GetActiveWorkSheet();
if (val_vacios())
{
if (!val_monto())
{
MessageBox.Show("El monto debe ser un valor numerico mayor a 0");
}
else
{
if (!val_plazo())
{
MessageBox.Show("El plazo debe ser un valor numerico y entero mayor a 0");
}
else
{
if (!val_interes())
{
MessageBox.Show("El interes debe ser un valor numerico mayor a 0");
}
else
{
double monto = Double.Parse(this.monto.Text);
int plazo = Int32.Parse(this.plazo.Text);
double interes = Double.Parse(this.interes.Text);
double couta;
//vamos a calcular el monto
using (WSFinanciera.Service1Client cliente = new WSFinanciera.Service1Client())
{
//calculamos la cuta que nos quedara
couta = Math.Round(cliente.getCuota(monto, plazo, interes), 4);
Worksheet currentSheet = Globals.Hoja1.GetActiveWorkSheet();
currentSheet.Range["C16"].Value = couta;
cliente.Close();
}
}
}
}
}
else
{
MessageBox.Show("Debe completar todos los campos");
}
}
private void button1_Click(object sender, RibbonControlEventArgs e)
{
double monto = Double.Parse(this.txtMonto.Text);
int plazo = Int32.Parse(this.txtPlazo.Text);
double interes = Double.Parse(this.txtInteres.Text);
double couta;
//vamos a calcular el monto
using (WSFinanciera.Service1Client cliente = new WSFinanciera.Service1Client())
{
//calculamos la cuta que nos quedara
couta = Math.Round(cliente.getCuota(monto, plazo, interes), 4);
Worksheet currentSheet = Globals.Hoja1.GetActiveWorkSheet();
currentSheet.Range["B4"].Value = couta;
cliente.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
limpiar();
if (!val_monto())
{
MessageBox.Show("El monto debe ser un valor numerico mayor a 0");
}
else
{
if (!val_plazo())
{
MessageBox.Show("El inters debe ser un valor numerico mayor a 0");
}
else
{
if (!val_interes())
{
MessageBox.Show("El interes debe ser un valor numerico mayor a 0");
}
else
{
limpiar();
double monto = Double.Parse(this.monto.Text);
int plazo = Int32.Parse(this.plazo.Text);
double interes = Double.Parse(this.interes.Text);
double couta;
using (WSFinanciera.Service1Client cliente = new WSFinanciera.Service1Client())
{
//calculamos la cuta que nos quedara
couta = Math.Round(cliente.getCuota(monto, plazo, interes), 4);
Worksheet currentSheet = Globals.Hoja1.GetActiveWorkSheet();
currentSheet.Range["C16"].Value = couta;
//tamaño de la fila
//llenar la lista
var Datos = cliente.getTabla_Amortizacion(monto, plazo, interes);
filaF = Datos.Length;
int i = 17;
foreach (var dato in Datos)
{
currentSheet.Range["F" + i].Value = dato.periodo;
currentSheet.Range["F" + i].Borders.LineStyle = XlLineStyle.xlContinuous;
currentSheet.Range["G" + i].Value = dato.cuota;
currentSheet.Range["G" + i].Borders.LineStyle = XlLineStyle.xlContinuous;
currentSheet.Range["H" + i].Value = dato.interes;
currentSheet.Range["H" + i].Borders.LineStyle = XlLineStyle.xlContinuous;
currentSheet.Range["I" + i].Value = dato.abonoKs;
currentSheet.Range["I" + i].Borders.LineStyle = XlLineStyle.xlContinuous;
currentSheet.Range["J" + i].Value = dato.saldo;
currentSheet.Range["J" + i].Borders.LineStyle = XlLineStyle.xlContinuous;
i++;
}
//currentSheet.Columns.AutoFit();
cliente.Close();
}
}
}
}
}