private void LlenarGridView()
{
foreach (var item in ModelSecadorVertical.Llenargrid())
{
var row = (DataGridViewRow)dtgVertical.Rows[0].Clone();
row.Cells[0].Value = item.IdLinea;
row.Cells[1].Value = item.Circuito;
row.Cells[2].Value = item.Fecha;
row.Cells[3].Value = item.MInicial;
row.Cells[4].Value = item.MFinal;
row.Cells[5].Value = item.MEnjuague;
row.Cells[6].Value = item.TAInicial;
row.Cells[7].Value = item.TAFinal;
row.Cells[8].Value = item.TAEnjuague;
row.Cells[9].Value = item.TTA;
row.Cells[10].Value = item.TipoLavado;
row.Cells[11].Value = item.TLInicial;
row.Cells[12].Value = item.TLFinal;
row.Cells[13].Value = item.TLEnjuague;
row.Cells[14].Value = item.TTLavado;
row.Cells[15].Value = item.Color1;
row.Cells[16].Value = item.Color2;
row.Cells[17].Value = item.Titulacion;
row.Cells[18].Value = item.RT1;
row.Cells[19].Value = item.RT2;
row.Cells[20].Value = item.Operador;
row.Cells[21].Value = item.Analista;
dtgVertical.Rows.Add(row);
}
}
private void exportacionFechaYTitulacionesToolStripMenuItem_Click(object sender, EventArgs e)
{
ModelSecadorVertical.DisplayInExcelTitulaciones();
{
MessageBox.Show(@"Exportación Realizada Con Exitó!!", @"Guardado", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
private void toolStripBtnEliminar_Click(object sender, EventArgs e)
{
if (MessageBox.Show(@"Esta Seguro Que Desea Eliminar El Registro", @"Estas Seguro??",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
if (ModelSecadorVertical.Eliminar(ModelSecadorVertical.SVerticalSelect.IdLinea) > 0)
{
MessageBox.Show(@"Registro Eliminado Correctamente!", @"Registro Eliminado", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
LimpiarGrid();
}
else
{
MessageBox.Show(@"Se Cancelo La Eliminacion", @"Eliminacion Cancelada", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
}
}
private void toolStripBtnGuardar_Click(object sender, EventArgs e)
{
var pSV = new ModelSecadorVertical
{
Circuito = cmbCircuito.SelectedItem.ToString(),
Fecha = dtpSecadorVertical.Value.Year + "/" + dtpSecadorVertical.Value.Month + "/" + dtpSecadorVertical.Value.Day +
"/" + dtpSecadorVertical.Value.Hour + "/" + dtpSecadorVertical.Value.Minute + "/" + dtpSecadorVertical.Value.Second,
MInicial = txtMInicial.Text.Trim(),
MFinal = txtMFinal.Text.Trim(),
MEnjuague = txtMEnjuague.Text.Trim(),
TAInicial = txtTAInicial.Text.Trim(),
TAFinal = txtTAFinal.Text.Trim(),
TAEnjuague = txtTAEnjuague.Text.Trim(),
TTA = lblTTA.Text.Trim(),
TipoLavado = cmbLavado.SelectedItem.ToString(),
TLInicial = txtTLInicial.Text.Trim(),
TLFinal = txtTLFinal.Text.Trim(),
TLEnjuague = txtTLEnjuague.Text.Trim(),
TTLavado = lblTTL.Text.Trim(),
Color1 = cmbSolucion.SelectedItem.ToString(),
Color2 = cmbSolucion2.SelectedItem.ToString(),
Titulacion = cmbTitulacion.SelectedItem.ToString(),
RT1 = txtRT1.Text.Trim(),
RT2 = txtRT2.Text.Trim(),
Operador = cmbOperador.SelectedItem.ToString(),
Analista = cmbAnalista.SelectedItem.ToString()
};
var resultado = ModelSecadorVertical.Agregar(pSV);
if (resultado > 0)
{
MessageBox.Show(@"Registro Guardado Con Exito!!", @"Guardado", MessageBoxButtons.OK, MessageBoxIcon.Information);
LimpiarGrid();
}
else
{
MessageBox.Show(@"No Se Pudo Guardar El Registro", @"Fallo!!", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
private void toolStripBtnActualizar_Click(object sender, EventArgs e)
{
ModelSecadorVertical pSV = new ModelSecadorVertical
{
IdLinea = ModelSecadorVertical.SVerticalSelect.IdLinea,
Circuito = cmbCircuito.SelectedItem.ToString(),
Fecha = dtpSecadorVertical.Value.Year + "/" + dtpSecadorVertical.Value.Month + "/" + dtpSecadorVertical.Value.Day +
"/" + dtpSecadorVertical.Value.Hour + "/" + dtpSecadorVertical.Value.Minute + "/" + dtpSecadorVertical.Value.Second,
MInicial = txtMInicial.Text.Trim(),
MFinal = txtMFinal.Text.Trim(),
MEnjuague = txtMEnjuague.Text.Trim(),
TAInicial = txtTAInicial.Text.Trim(),
TAFinal = txtTAFinal.Text.Trim(),
TAEnjuague = txtTAEnjuague.Text.Trim(),
TTA = lblTTA.Text.Trim(),
TipoLavado = cmbLavado.SelectedItem.ToString(),
TLInicial = txtTLInicial.Text.Trim(),
TLFinal = txtTLFinal.Text.Trim(),
TLEnjuague = txtTLEnjuague.Text.Trim(),
TTLavado = lblTTL.Text.Trim(),
Color1 = cmbSolucion.SelectedItem.ToString(),
Color2 = cmbSolucion2.SelectedItem.ToString(),
Titulacion = cmbTitulacion.SelectedItem.ToString(),
RT1 = txtRT1.Text.Trim(),
RT2 = txtRT2.Text.Trim(),
Operador = cmbOperador.SelectedItem.ToString(),
Analista = cmbAnalista.SelectedItem.ToString()
};
if (ModelSecadorVertical.Actualizar(pSV) > 0)
{
MessageBox.Show("Los Datos Se Actualizaron", "Datos Actualizados", MessageBoxButtons.OK, MessageBoxIcon.Information);
LimpiarGrid();
}
else
{
MessageBox.Show("No Se Pudo Actualizar", "Error al Actualizar", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void toolStripBtnBuscar_Click(object sender, EventArgs e)
{
var encontro = true;
foreach (var item in ModelSecadorVertical.Buscar(cmbCircuito.SelectedItem.ToString()))
{
if (encontro)
{
dtgVertical.Rows.Clear();
dtgVertical.Refresh();
}
var row = (DataGridViewRow)dtgVertical.Rows[0].Clone();
row.Cells[0].Value = item.IdLinea;
row.Cells[1].Value = item.Circuito;
row.Cells[2].Value = item.Fecha;
row.Cells[3].Value = item.MInicial;
row.Cells[4].Value = item.MFinal;
row.Cells[5].Value = item.MEnjuague;
row.Cells[6].Value = item.TAInicial;
row.Cells[7].Value = item.TAFinal;
row.Cells[8].Value = item.TAEnjuague;
row.Cells[9].Value = item.TTA;
row.Cells[10].Value = item.TipoLavado;
row.Cells[11].Value = item.TLInicial;
row.Cells[12].Value = item.TLFinal;
row.Cells[13].Value = item.TLEnjuague;
row.Cells[14].Value = item.TTLavado;
row.Cells[15].Value = item.Color1;
row.Cells[16].Value = item.Color2;
row.Cells[17].Value = item.Titulacion;
row.Cells[18].Value = item.RT1;
row.Cells[19].Value = item.RT2;
row.Cells[20].Value = item.Operador;
row.Cells[21].Value = item.Analista;
dtgVertical.Rows.Add(row);
encontro = false;
}
}
private void dtgVertical_DoubleClick(object sender, EventArgs e)
{
if (dtgVertical.SelectedRows.Count == 1)
{
if (dtgVertical.CurrentRow != null)
{
ModelSecadorVertical.ObtenerSV(Convert.ToInt32(dtgVertical.CurrentRow.Cells[0].Value));
}
cmbCircuito.SelectedItem = ModelSecadorVertical.SVerticalSelect.Circuito;
dtpSecadorVertical.Text = ModelSecadorVertical.SVerticalSelect.Fecha;
txtMInicial.Text = ModelSecadorVertical.SVerticalSelect.MEnjuague;
txtMFinal.Text = ModelSecadorVertical.SVerticalSelect.MFinal;
txtMEnjuague.Text = ModelSecadorVertical.SVerticalSelect.MEnjuague;
txtTAInicial.Text = ModelSecadorVertical.SVerticalSelect.TAInicial;
txtTAFinal.Text = ModelSecadorVertical.SVerticalSelect.TAFinal;
txtTAEnjuague.Text = ModelSecadorVertical.SVerticalSelect.TAEnjuague;
lblTTA.Text = ModelSecadorVertical.SVerticalSelect.TTA;
cmbLavado.SelectedItem = ModelSecadorVertical.SVerticalSelect.TipoLavado;
txtTLInicial.Text = ModelSecadorVertical.SVerticalSelect.TLInicial;
txtTLFinal.Text = ModelSecadorVertical.SVerticalSelect.TLFinal;
txtTLEnjuague.Text = ModelSecadorVertical.SVerticalSelect.TLEnjuague;
lblTTL.Text = ModelSecadorVertical.SVerticalSelect.TTLavado;
cmbSolucion.SelectedItem = ModelSecadorVertical.SVerticalSelect.Color1;
cmbSolucion2.SelectedItem = ModelSecadorVertical.SVerticalSelect.Color2;
cmbTitulacion.SelectedItem = ModelSecadorVertical.SVerticalSelect.Titulacion;
txtRT1.Text = ModelSecadorVertical.SVerticalSelect.RT1;
txtRT2.Text = ModelSecadorVertical.SVerticalSelect.RT2;
cmbOperador.SelectedItem = ModelSecadorVertical.SVerticalSelect.Operador;
cmbAnalista.SelectedItem = ModelSecadorVertical.SVerticalSelect.Analista;
}
else
{
MessageBox.Show(@"debe de seleccionar una fila");
}
}
