public static void truncarDataGrid(DataGridView dataGridView, int ordenTruncado)
{
Herramientas h = new Herramientas();
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
for (int j = 0; j < dataGridView.Columns.Count; j++)
{
if (dataGridView.Rows[i].Cells[j].Value is Double)
{
dataGridView.Rows[i].Cells[j].Value = h.TruncadoMarcelo(Convert.ToDouble(dataGridView.Rows[i].Cells[j].Value), 4);
}
}
}
}
private void btnF_Click(object sender, EventArgs e)
{
dataTablaBase.Rows.Clear();
GeneradorTabla generador = new GeneradorTabla();
Herramientas h = new Herramientas();
double[,] matriz;
h.valoresInexistentes(this, gbVariables);
//Variables auxiliares
int cantidadDias = Convert.ToInt32(txtCantidadDia.Text);
int cantidadSimulaciones = Convert.ToInt32(txtSimulaciones.Text);
double acumulada = 0;
double acumuladaProm = 0;
double reserva = Convert.ToInt32(txtReserva.Text);
//TODOS LAS FUNCIONES MATRIZ = GENERAR.TABLABASE tienen el valor booleano invertido
for (int j = 0; j < cantidadSimulaciones; j++)
{
if (cbVariables.Checked)
{
//If para ver si se trabaja con numeros aleatorios o los fijos
if (cbNumerosAleatorios.Checked)
{
if (cbDiaAnterior.Checked)
{
for (int i = 0; i < cantidadDias; i++)
{
matriz = generador.tablaBase1(Convert.ToInt32(reserva),
Convert.ToDouble(txtPrecioVenta.Text), Convert.ToDouble(txtPrecioVentaCementerio.Text), Convert.ToDouble(txtPrecioCompra.Text), Convert.ToDouble(txtPrecioCompraFaltantes.Text),
cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, false, acumulada);
reserva = matriz[0, 4];
acumulada = matriz[0, 7];
if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == (Convert.ToInt32(txtCantidadDia.Text)) - 1)
{
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
//Rnd Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
//Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
//Rnd Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
//Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
}
}
dataTablaBase.Rows.Add();
h.formatearDataGridTexto(dataTablaBase);
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);
acumulada = 0;
reserva = Convert.ToDouble(txtReserva.Text);
}
else
{
for (int i = 0; i < cantidadDias; i++)
{
matriz = generador.tablaBase1(Convert.ToInt32(reserva),
Convert.ToDouble(txtPrecioVenta.Text), Convert.ToDouble(txtPrecioVentaCementerio.Text), Convert.ToDouble(txtPrecioCompra.Text), Convert.ToDouble(txtPrecioCompraFaltantes.Text),
cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, false, acumulada);
acumulada = matriz[0, 7];
if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == (Convert.ToInt32(txtCantidadDia.Text)) - 1)
{
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
//Rnd Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
//Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
//Rnd Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
//Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
}
}
dataTablaBase.Rows.Add();
h.formatearDataGridTexto(dataTablaBase);
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);
acumulada = 0;
}
}
else
{
if (cbDiaAnterior.Checked)
{
for (int i = 0; i < 20; i++)
{
matriz = generador.tablaBase1(Convert.ToInt32(reserva),
Convert.ToDouble(txtPrecioVenta.Text), Convert.ToDouble(txtPrecioVentaCementerio.Text), Convert.ToDouble(txtPrecioCompra.Text), Convert.ToDouble(txtPrecioCompraFaltantes.Text),
cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, true, acumulada);
reserva = matriz[0, 4];
acumulada = matriz[0, 7];
if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == 20 - 1)
{
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
//Rnd Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
//Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
//Rnd Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
//Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
}
}
dataTablaBase.Rows.Add();
h.formatearDataGridTexto(dataTablaBase);
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);
acumulada = 0;
reserva = Convert.ToDouble(txtReserva.Text);
}
else
{
for (int i = 0; i < 20; i++)
{
matriz = generador.tablaBase1(Convert.ToInt32(reserva),
Convert.ToDouble(txtPrecioVenta.Text), Convert.ToDouble(txtPrecioVentaCementerio.Text), Convert.ToDouble(txtPrecioCompra.Text), Convert.ToDouble(txtPrecioCompraFaltantes.Text),
cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, true, acumulada);
//reserva = matriz[0, 2];
acumulada = matriz[0, 7];
if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == 20 - 1)
{
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
//Rnd Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
//Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
//Rnd Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
//Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
}
}
dataTablaBase.Rows.Add();
h.formatearDataGridTexto(dataTablaBase);
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);
acumulada = 0;
//reserva = Convert.ToDouble(txtReserva.Text);
}
}
}
//Variables False
else
{
if (cbNumerosAleatorios.Checked)
{
if (cbDiaAnterior.Checked)
{
for (int i = 0; i < cantidadDias; i++)
{
matriz = generador.tablaBase1(Convert.ToInt32(reserva), 12, 1.2, 8, 11, cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, false, acumulada);
reserva = matriz[0, 4];
acumulada = matriz[0, 7];
if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == (Convert.ToInt32(txtCantidadDia.Text)) - 1)
{
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
//Rnd Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
//Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
//Rnd Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
//Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
}
}
dataTablaBase.Rows.Add();
h.formatearDataGridTexto(dataTablaBase);
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);
acumulada = 0;
reserva = Convert.ToDouble(txtReserva.Text);
}
else
{
//ACA
for (int i = 0; i < cantidadDias; i++)
{
matriz = generador.tablaBase1(Convert.ToInt32(reserva), 12, 1.2, 8, 11, cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, false, acumulada);
//reserva = matriz[0, 2];
acumulada = matriz[0, 7];
if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == (Convert.ToInt32(txtCantidadDia.Text)) - 1) //MODIFIQUE ESTE
{
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
//Rnd Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
//Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
//Rnd Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
//Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
}
}
dataTablaBase.Rows.Add();
h.formatearDataGridTexto(dataTablaBase);
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);
acumulada = 0;
}
}
//Aleatorios False
else
{
if (cbDiaAnterior.Checked)
{
for (int i = 0; i < 20; i++)
{
matriz = generador.tablaBase1(Convert.ToInt32(reserva), 12, 1.2, 8, 11, cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, true, acumulada);
reserva = matriz[0, 4];
acumulada = matriz[0, 7];
if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == 20 - 1)//CAMBIO 2
{
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
//Rnd Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
//Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
//Rnd Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
//Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
}
}
dataTablaBase.Rows.Add();
h.formatearDataGridTexto(dataTablaBase);
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);
acumulada = 0;
reserva = Convert.ToDouble(txtReserva.Text);
}
else
{
for (int i = 0; i < 20; i++)
{
matriz = generador.tablaBase1(Convert.ToInt32(reserva), 12, 1.2, 8, 11, cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, true, acumulada);
//reserva = matriz[0, 2];
acumulada = matriz[0, 7];
if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == 20 - 1)
{
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
//Rnd Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
//Clima
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
//Rnd Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
//Demanda
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
}
}
dataTablaBase.Rows.Add();
h.formatearDataGridTexto(dataTablaBase);
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
dataTablaBase.Rows.Add();
dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);
acumulada = 0;
}
}
}
Console.WriteLine("Simulacion F finalizada");
}
txtPromedioGanancia.Text = h.TruncadoMarcelo((acumuladaProm / Convert.ToDouble(txtSimulaciones.Text)), 4).ToString();
Herramientas.truncarDataGrid(dataTablaBase, 4);
}