private void btnAddCargo_Click(object sender, EventArgs e)
{
if (IsReadyToSaveFirst())
{
int movimientoID = DataUtil.GetNewId("movimientos");
string tipoMovimiento = "RETIRO";
if (rbtnDeposito.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
totalDeposito = totalDeposito + DataUtil.GetDouble(txtImporte.Text);
tipoMovimiento = "DEPOSITO";
}
else
{
totalRetiro = totalRetiro + DataUtil.GetDouble(txtImporte.Text);
}
string sqlForExecute = "INSERT INTO movimientos (" +
"Movimiento_id," +
"Turno_id," +
"Estacion_id," +
"Tipo_movimiento," +
"Concepto," +
"Referencia," +
"Importe," +
"Fecha_creacion," +
"Creado_por)" +
" VALUES (" +
movimientoID + "," +
"" + lblTurno.Text + "," +
"" + ((System.Web.UI.WebControls.ListItem)(cbEstacion.SelectedItem)).Value + "," +
"'" + tipoMovimiento + "'," +
"'" + txtConcepto.Text.Trim() + "'," +
"'" + txtReferencia.Text.Trim() + "'," +
"'" + DataUtil.GetDouble(txtImporte.Text) + "'," +
"'" + DateTime.Now + "'," +
"'" + AppConstant.EmployeeInfo.Codigo + "'" +
")";
if (DataUtil.Update(sqlForExecute))
{
totalGeneral = totalRetiro + totalDeposito;
txtDepositro.Text = totalDeposito.ToString(DataUtil.Format.Decimals);
txtRetiro.Text = totalRetiro.ToString(DataUtil.Format.Decimals);
txtTotal.Text = totalGeneral.ToString(DataUtil.Format.Decimals);
string[] row = { DataUtil.GetString(movimientoID),
DataUtil.GetString(tipoMovimiento),
DataUtil.GetString(txtConcepto.Text.Trim()),
DataUtil.GetCurrency(txtImporte.Text),
DataUtil.GetString(DateTime.Now) };
dgwCuenta.Rows.Add(row);
txtConcepto.Text = string.Empty;
txtReferencia.Text = string.Empty;
txtImporte.Text = string.Empty;
MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtConcepto.Focus();
}
}
}
private void btnCerrarTurno_Click(object sender, EventArgs e)
{
var result = MessageBox.Show(@"Desea cerrar el turno actual?", @"Turno", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
string sqlForExecute;
foreach (DataGridViewRow row in dgwEstaciones.Rows)
{
sqlForExecute = "INSERT INTO Turno_Cierre (" +
"Turno_Cierre_id," +
"Turno_id," +
"Estacion_id," +
"Estacion_texto," +
"Grid," +
"Descripcion," +
"Cantidad," +
"Importe)" +
" VALUES (" +
DataUtil.GetString(DataUtil.GetNewId("Turno_Cierre")) + "," +
lblTurno.Text + "," +
"" + DataUtil.GetString(row.Cells[0].Value) + "," +
"'" + DataUtil.GetString(row.Cells[1].Value) + "'," +
"'dgwEstaciones'," +
"'" + DataUtil.GetString(row.Cells[1].Value).Replace("'", "''") + "'," +
"0," +
"" + DataUtil.GetCurrency(row.Cells[2].Value) + "" +
")";
DataUtil.UpdateThrow(sqlForExecute);
}
foreach (DataGridViewRow row in dgwCuentas.Rows)
{
sqlForExecute = "INSERT INTO Turno_Cierre (" +
"Turno_Cierre_id," +
"Turno_id," +
"Estacion_id," +
"Estacion_texto," +
"Grid," +
"Descripcion," +
"Cantidad," +
"Importe)" +
" VALUES (" +
DataUtil.GetString(DataUtil.GetNewId("Turno_Cierre")) + "," +
lblTurno.Text + "," +
"" + DataUtil.GetString(row.Cells[4].Value) + "," +
"'" + DataUtil.GetString(row.Cells[0].Value) + "'," +
"'dgwCuentas'," +
"'" + DataUtil.GetString(row.Cells[1].Value).Replace("'", "''") + "'," +
"" + DataUtil.GetString(row.Cells[2].Value) + "," +
"" + DataUtil.GetCurrency(row.Cells[3].Value) + "" +
")";
DataUtil.UpdateThrow(sqlForExecute);
}
foreach (DataGridViewRow row in dgwMovimientos.Rows)
{
sqlForExecute = "INSERT INTO Turno_Cierre (" +
"Turno_Cierre_id," +
"Turno_id," +
"Estacion_id," +
"Estacion_texto," +
"Grid," +
"Descripcion," +
"Cantidad," +
"Importe)" +
" VALUES (" +
DataUtil.GetString(DataUtil.GetNewId("Turno_Cierre")) + "," +
lblTurno.Text + "," +
"" + DataUtil.GetString(row.Cells[4].Value) + "," +
"'" + DataUtil.GetString(row.Cells[0].Value) + "'," +
"'dgwMovimientos'," +
"'" + DataUtil.GetString(row.Cells[1].Value).Replace("'", "''") + "'," +
"" + DataUtil.GetString(row.Cells[2].Value) + "," +
"" + DataUtil.GetCurrency(row.Cells[3].Value) + "" +
")";
DataUtil.UpdateThrow(sqlForExecute);
}
foreach (DataGridViewRow row in dgwExtra.Rows)
{
sqlForExecute = "INSERT INTO Turno_Cierre (" +
"Turno_Cierre_id," +
"Turno_id," +
"Estacion_id," +
"Estacion_texto," +
"Grid," +
"Descripcion," +
"Cantidad," +
"Importe)" +
" VALUES (" +
DataUtil.GetString(DataUtil.GetNewId("Turno_Cierre")) + "," +
lblTurno.Text + "," +
"null," +
"''," +
"'dgwExtra'," +
"'" + DataUtil.GetString(row.Cells[0].Value).Replace("'", "''") + "'," +
"" + DataUtil.GetString(row.Cells[1].Value) + "," +
"0" +
")";
DataUtil.UpdateThrow(sqlForExecute);
}
sqlForExecute = "UPDATE turno SET " +
"Estado = 'CERRADO'" +
", Fecha_cierre = '" + DateTime.Now + "'" +
", Cerrado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" +
", Venta_total = '" + txtVentaTotal.Text + "'" +
" WHERE Turno_id = " + lblTurno.Text;
DataUtil.UpdateThrow(sqlForExecute);
ImprimirReporteTurno();
MessageBox.Show(@"Turno cerrado correctamente", @"Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information);
AppConstant.Turno.Codigo = string.Empty;
AppConstant.Turno.FechaHora = string.Empty;
AppConstant.Turno.Estado = string.Empty;
Close();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsReadyToSave() && IsReadyToSaveFont())
{
try
{
var valueAnulaciones = "0";
var valueNotaVenta = "0";
var valueDividirCuentas = "0";
var valueCambioMesero = "0";
var valueReImpresiones = "0";
var valueCambioMesa = "0";
var valueContrasenaSalir = "0";
var valueEliminarProducto = "0";
var valuePreviewBar = "0";
var valuePreviewCocina = "0";
var valuePreviewBoletas = "0";
var valuePreviewRecibos = "0";
var valuePreviewReportes = "0";
var valueBarTexto = "0";
var valueCocinaTexto = "0";
var valueMostrarIgvBoleta = "0";
if (cbAnulaciones.Checked)
{
valueAnulaciones = "1";
}
if (cbNotaVenta.Checked)
{
valueNotaVenta = "1";
}
if (cbDividirCuentas.Checked)
{
valueDividirCuentas = "1";
}
if (cbCambioMesero.Checked)
{
valueCambioMesero = "1";
}
if (cbReImpresiones.Checked)
{
valueReImpresiones = "1";
}
if (cbCambioMesa.Checked)
{
valueCambioMesa = "1";
}
if (cbContrasenaSalir.Checked)
{
valueContrasenaSalir = "1";
}
if (cbEliminarProducto.Checked)
{
valueEliminarProducto = "1";
}
if (cbPreviewBar.Checked)
{
valuePreviewBar = "1";
}
if (cbPreviewCocina.Checked)
{
valuePreviewCocina = "1";
}
if (cbPreviewBoletas.Checked)
{
valuePreviewBoletas = "1";
}
if (cbPreviewRecibos.Checked)
{
valuePreviewRecibos = "1";
}
if (cbPreviewReportes.Checked)
{
valuePreviewReportes = "1";
}
if (cbBarTexto.Checked)
{
valueBarTexto = "1";
}
if (cbCocinaTexto.Checked)
{
valueCocinaTexto = "1";
}
if (cbMostrarIGVBoletas.Checked)
{
valueMostrarIgvBoleta = "1";
}
var sqlForExecute = "UPDATE Impresora SET " +
" Font_header = '" + DataUtil.GetDouble(txtFontHeaderBar.Text) + "'" +
", Font_detail = '" + DataUtil.GetDouble(txtFontDetailBar.Text) + "'" +
", Ruta = '" + cbBar.Text + "'" +
", Preview = '" + valuePreviewBar + "'" +
", Texto = '" + valueBarTexto + "'" +
" WHERE tipo = 'B'";
DataUtil.Update(sqlForExecute);
sqlForExecute = "UPDATE Impresora SET " +
" Font_header = '" + DataUtil.GetDouble(txtFontHeaderCocina.Text) + "'" +
", Font_detail = '" + DataUtil.GetDouble(txtFontDetailCocina.Text) + "'" +
", Ruta = '" + cbCocina.Text + "'" +
", Preview = '" + valuePreviewCocina + "'" +
", Texto = '" + valueCocinaTexto + "'" +
" WHERE tipo = 'C'";
DataUtil.Update(sqlForExecute);
sqlForExecute = "UPDATE Impresora SET " +
" Font_header = '" + DataUtil.GetDouble(txtFontHeaderBoletas.Text) + "'" +
", Font_detail = '" + DataUtil.GetDouble(txtFontDetailBoletas.Text) + "'" +
", Ruta = '" + cbBoletas.Text + "'" +
", Preview = '" + valuePreviewBoletas + "'" +
" WHERE tipo = 'L'";
DataUtil.Update(sqlForExecute);
sqlForExecute = "UPDATE Impresora SET " +
" Font_header = '" + DataUtil.GetDouble(txtFontHeaderRecibos.Text) + "'" +
", Font_detail = '" + DataUtil.GetDouble(txtFontDetailRecibos.Text) + "'" +
", Ruta = '" + cbRecibos.Text + "'" +
", Preview = '" + valuePreviewRecibos + "'" +
" WHERE tipo = 'R'";
DataUtil.Update(sqlForExecute);
sqlForExecute = "UPDATE Impresora SET " +
" Font_header = '" + DataUtil.GetDouble(txtFontHeaderReportes.Text) + "'" +
", Font_detail = '" + DataUtil.GetDouble(txtFontDetailReportes.Text) + "'" +
", Ruta = '" + cbReportes.Text + "'" +
", Preview = '" + valuePreviewReportes + "'" +
" WHERE tipo = 'P'";
DataUtil.Update(sqlForExecute);
sqlForExecute = "UPDATE configuracion_general SET " +
" Nombre_compania = '" + txtCompania.Text.Trim().Replace("'", "''") + "'" +
", Razon_social = '" + txtRazonSocial.Text.Trim().Replace("'", "''") + "'" +
", Documento_compania = '" + txtRUC.Text.Trim() + "'" +
", Telefono1_compania = '" + txtTelefono.Text.Trim() + "'" +
", Telefono2_compania = '" + txtFax.Text.Trim() + "'" +
", Telefono3_compania = '" + txtMobile.Text.Trim() + "'" +
", Direccion_compania = '" + txtDireccion.Text.Trim().Replace("'", "''") + "'" +
", Direccion_fiscal = '" + txtDireccionFiscal.Text.Trim().Replace("'", "''") + "'" +
", Mensaje_recibo_1 = '" + txtLinea1.Text.Trim().Replace("'", "''") + "'" +
", Mensaje_recibo_2 = '" + txtLinea2.Text.Trim().Replace("'", "''") + "'" +
", Mensaje_recibo_3 = '" + txtLinea3.Text.Trim().Replace("'", "''") + "'" +
", Ruta_logo_compania = '" + txtLogo.Text.Trim().Replace("'", "''") + "'" +
", Departamento = '" + txtDepartamento.Text.Trim().Replace("'", "''") + "'" +
", Provincia = '" + txtProvincia.Text.Trim().Replace("'", "''") + "'" +
", Urbanizacion = '" + txtUrbanizacion.Text.Trim().Replace("'", "''") + "'" +
", Codigo_Postal = '" + txtCodigoPostal.Text.Trim().Replace("'", "''") + "'" +
", Alegra_Usuario = '" + txtAlegraUsuario.Text.Trim().Replace("'", "''") + "'" +
", Alegra_Token = '" + txtAlegraToken.Text.Trim().Replace("'", "''") + "'" +
", Email_compania = '" + txtEmail.Text.Trim().Replace("'", "''") + "'" +
", Web_compania = '" + txtWeb.Text.Trim().Replace("'", "''") + "'" +
", IGV = '" + txtIGV.Text.Trim() + "'" +
", Monto_caja = '" + DataUtil.GetCurrency(txtCaja.Text) + "'" +
", Fecha_actualizacion = '" + DateTime.Now + "'" +
", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" +
", Ultima_boleta = '" + txtBoleta.Text.Trim() + "'" +
", Ultima_factura = '" + txtFactura.Text.Trim() + "'" +
", Prefijo_Boleta = '" + txtPrefijoBoleta.Text.Trim() + "'" +
", Prefijo_Factura = '" + txtPrefijoFactura.Text.Trim() + "'" +
", Ultima_Nota_Credito = '" + txtNotaCredito.Text.Trim() + "'" +
", Ultima_Nota_Debito = '" + txtNotaDebito.Text.Trim() + "'" +
", Prefijo_Nota_Credito = '" + txtPrefijoNotaCredito.Text.Trim() + "'" +
", Prefijo_Nota_Debito = '" + txtPrefijoNotaDebito.Text.Trim() + "'" +
", Contrasena_Anulaciones = '" + valueAnulaciones + "'" +
", Contrasena_NotaVenta = '" + valueNotaVenta + "'" +
", Contrasena_DividirCuenta = '" + valueDividirCuentas + "'" +
", Contrasena_CambioMesero = '" + valueCambioMesero + "'" +
", Contrasena_ReImpresiones = '" + valueReImpresiones + "'" +
", Contrasena_CambioMesa = '" + valueCambioMesa + "'" +
", Contrasena_Salir = '" + valueContrasenaSalir + "'" +
", Contrasena_EliminarProducto = '" + valueEliminarProducto + "'" +
", Mostrar_IGV_Boleta = '" + valueMostrarIgvBoleta + "'";
if (!DataUtil.Update(sqlForExecute))
{
return;
}
MessageBox.Show(@"Registro grabado correctamente", @"Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
Close();
}
catch (Exception ex)
{
MessageBox.Show(@"Error en Grabar: " + ex.Message);
}
}
}
