private void btnSaveEdit_Click(object sender, EventArgs e) { if (IsReadyToEdit()) { string sqlForExecute = string.Empty; try { sqlForExecute = "UPDATE " + tableName + " SET " + "Boton_descripcion = '" + txtDescripcion.Text.Trim().Replace("'", "''") + "'" + ", Boton_ruta_imagen = '" + txtRuta.Text + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE " + formWhereField + " = " + botonId; if (DataUtil.Update(sqlForExecute)) { MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { string sqlForExecute = string.Empty; try { string habilitado = DataUtil.GetString(cbEstado.SelectedItem) == "SI" ? "1" : "0"; sqlForExecute = "UPDATE mesa SET " + "Mesa_descripcion = '" + txtDescripcion.Text.Trim().Replace("'", "''") + "'" + ", Mesa_habilitado = '" + habilitado + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE Mesa_id = " + mesaID; if (DataUtil.Update(sqlForExecute)) { MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); DialogResult = DialogResult.OK; this.Close(); } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } }
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 btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { string sqlForExecute = string.Empty; try { string categoriaWhere = "Producto_categoria_descripcion = '" + DataUtil.GetString(cbCategoria.SelectedItem) + "'"; if (adding) { sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Producto_sub_categoria_descripcion," + "Producto_categoria_id," + "Estado," + "Fecha_creacion," + "Creado_por," + "Fecha_actualizacion," + "Actualizado_por)" + " VALUES (" + DataUtil.GetNewId(tableName) + "," + "'" + txtDescripcion.Text.Trim() + "'," + "'" + DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_id", categoriaWhere) + "'," + "'" + cbEstado.SelectedItem + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'" + ")"; } else { sqlForExecute = "UPDATE " + tableName + " SET " + " Producto_sub_categoria_descripcion = '" + txtDescripcion.Text.Trim() + "'" + ", Producto_categoria_id = '" + DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_id", categoriaWhere) + "'" + ", Estado = '" + cbEstado.SelectedItem + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE " + formWhereField + " = " + txtCodigo.Text; } if (DataUtil.Update(sqlForExecute)) { MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); if (adding) { this.Close(); } } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } }
private void btnDisassociate_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Está seguro de desasociar el boton actual?", "Desasociar", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (DataUtil.Update("DELETE FROM " + tableName + " WHERE " + formWhereField + " = " + botonId)) { MessageBox.Show(string.Format("Se desasocio el boton correctamente.", 1), "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } }
private void UpdateCurrentAccount() { string sqlForExecute = string.Empty; try { DataUtil.Update("DELETE FROM pedido_detalle WHERE Pedido_id = " + pedidoIDView + ""); foreach (DataGridViewRow row in dgwCuenta.Rows) { string descuentoValue = DataUtil.GetString(row.Cells[4].Value); if (descuentoValue.Equals(string.Empty)) { descuentoValue = "null"; } sqlForExecute = "INSERT INTO pedido_detalle (" + "Pedido_detalle_id," + "Pedido_id," + "Linea," + "Codigo_Producto," + "Descripcion_Producto," + "Descuento," + "Cantidad," + "Impreso)" + " VALUES (" + DataUtil.GetNewId("pedido_detalle") + "," + pedidoIDView + "," + "'" + DataUtil.GetString(row.Cells[0].Value) + "'," + "" + DataUtil.GetString(row.Cells[1].Value) + "," + "'" + DataUtil.GetString(row.Cells[3].Value).Replace("'", "''") + "'," + "" + descuentoValue + "," + "'" + DataUtil.GetString(row.Cells[2].Value) + "'," + "0" + ")"; DataUtil.UpdateThrow(sqlForExecute); } sqlForExecute = "UPDATE pedido SET " + "Last_Line = " + lineGrid0 + "" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE Pedido_id = " + pedidoIDView; DataUtil.UpdateThrow(sqlForExecute); } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } }
private void InsertarValoresReporte(string descripcion, string valor) { string sqlForExecute = "INSERT INTO Reporte_Turno (" + "Descripcion," + "Valor," + "Turno_id)" + " VALUES (" + "'" + descripcion + "'," + "'" + valor + "'," + "" + lblTurno.Text + "" + ")"; DataUtil.Update(sqlForExecute); }
private void btnDeleteProducto_Click(object sender, EventArgs e) { DataGridViewSelectedRowCollection Seleccionados = dgwReceta.SelectedRows; foreach (DataGridViewRow item in Seleccionados) { DialogResult diagResult = MessageBox.Show("Está seguro de eliminar el producto seleccionado?", "Eliminar", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (diagResult == DialogResult.Yes) { if (DataUtil.Update("DELETE FROM movimientos WHERE Movimiento_id = " + item.Cells["MOVIMIENTO_ID"].Value.ToString() + "")) { this.dgwReceta.Rows.RemoveAt(item.Index); } } } }
private void btnSave_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show(@"Está seguro de abrir el turno?", @"Abrir", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (IsReadyToSave()) { try { if (adding) { txtCodigo.Text = DataUtil.GetString(DataUtil.GetNewId(tableName)); sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Estado," + "Fondo_inicial_total," + "Venta_total," + "Fecha_apertura," + "Aperturado_por)" + " VALUES (" + txtCodigo.Text + "," + "'ABIERTO'," + "" + txtFondoInicialTotal.Text + "," + "'0.00'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'" + ")"; } if (DataUtil.Update(sqlForExecute)) { AgregarTurnoEstacion(DataUtil.GetInt(txtCodigo.Text)); if (adding) { this.Close(); } } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message + " " + sqlForExecute); } } } }
protected virtual void DeleteData() { DialogResult result = MessageBox.Show(@"Está seguro de eliminar el registro actual?", @"Eliminar", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (ExistRecord()) { if (DataUtil.Update("DELETE FROM " + tableName + " WHERE " + formWhereField + " = " + idToDelete)) { MessageBox.Show(string.Format("Se eliminó {0} elemento(s).", 1), @"Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); idToDelete = string.Empty; this.Close(); } } } }
private void btnAddCargo_Click(object sender, EventArgs e) { if (cbEstacion.SelectedItem != null && txtMontoInicial.Text.Trim() != string.Empty) { if (!ExisteEstacion(((System.Web.UI.WebControls.ListItem)(cbEstacion.SelectedItem)).Text)) { lineGrid = lineGrid + 1; string[] row = { DataUtil.GetString(lineGrid), ((System.Web.UI.WebControls.ListItem)(cbEstacion.SelectedItem)).Text, txtMontoInicial.Text, ((System.Web.UI.WebControls.ListItem)(cbEstacion.SelectedItem)).Value }; dgwCuenta.Rows.Add(row); CalculoMontoInicial(DataUtil.GetDouble(txtMontoInicial.Text), true); if (!adding) { sqlForExecute = "UPDATE " + tableName + " SET Fondo_inicial_total = " + txtFondoInicialTotal.Text + "" + " WHERE " + formWhereField + " = " + txtCodigo.Text; DataUtil.Update(sqlForExecute); sqlForExecute = "INSERT INTO Turno_Estacion (" + "Turno_id," + "Estacion_id," + "Linea," + "Fondo_inicial)" + " VALUES (" + txtCodigo.Text + "," + ((System.Web.UI.WebControls.ListItem)(cbEstacion.SelectedItem)).Value + "," + "'" + DataUtil.GetString(lineGrid) + "'," + "" + txtMontoInicial.Text + "" + ")"; DataUtil.UpdateThrow(sqlForExecute); } cbEstacion.Text = string.Empty; txtMontoInicial.Text = AppConstant.GeneralInfo.MontoCaja; cbEstacion.Focus(); } } else { cbEstacion.Focus(); MessageBox.Show(@"Debe ingresar la estacion y el monto inicial.", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnAnular_Click(object sender, EventArgs e) { string refValue = string.Empty; if (IsReadyToSave()) { if (frmInputBox.InputBox("Ingresar codigo de autorizacion", "Codigo", "empleado", "password", "1", ref refValue, true, AppConstant.GeneralInfo.PasswordAnulaciones) == DialogResult.OK) { string sqlForExecute = string.Empty; try { sqlForExecute = "UPDATE pedido SET " + "Comentarios = '" + txtComentarios.Text.Trim() + "'" + ", Estado = 'C'" + ", Fecha_anulacion = '" + DateTime.Now + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE pedido_id = " + pedidoID; DataUtil.UpdateThrow(sqlForExecute); if (mesaID != 0) { sqlForExecute = "UPDATE mesa SET " + "Mesa_estado = 'LIBRE'," + "Pedido_id = null" + " WHERE Mesa_id = " + mesaID; DataUtil.UpdateThrow(sqlForExecute); } if (DataUtil.Update(sqlForExecute)) { MessageBox.Show("Registro anulado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } } }
private void btnAssociate_Click(object sender, EventArgs e) { if (IsReadyToAssociate()) { string sqlForExecute = string.Empty; try { if (adding) { sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Producto_sub_categoria_id," + "Producto_id," + "Boton_descripcion," + "Boton_ruta_imagen," + "Fecha_creacion," + "Creado_por," + "Fecha_actualizacion," + "Actualizado_por)" + " VALUES (" + botonId + "," + subCategoriaId + "," + txtCodigo.Text + "," + "'" + txtDescripcion.Text.Trim().Replace("'", "''") + "'," + "'" + txtRuta.Text + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'" + ")"; } if (DataUtil.Update(sqlForExecute)) { MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } }
private void AgregarTurnoEstacion(int turnoId) { DataUtil.Update("DELETE FROM Turno_Estacion WHERE " + formWhereField + " = " + turnoId); foreach (DataGridViewRow row in dgwCuenta.Rows) { sqlForExecute = "INSERT INTO Turno_Estacion (" + "Turno_id," + "Estacion_id," + "Linea," + "Fondo_inicial)" + " VALUES (" + turnoId + "," + DataUtil.GetInt(row.Cells[3].Value) + "," + "'" + DataUtil.GetString(row.Cells[0].Value) + "'," + "" + DataUtil.GetString(row.Cells[2].Value) + "" + ")"; DataUtil.UpdateThrow(sqlForExecute); } }
private void UpdateLog(int recordId, string field, string oldValue, string newValue) { var sqlForExecute = "INSERT INTO Estacion_Log (" + "Estacion_Log_id," + "Estacion_id," + "Campo," + "Valor_antiguo," + "Valor_nuevo," + "Fecha_actualizacion," + "Actualizado_por)" + " VALUES (" + DataUtil.GetNewId("Estacion_Log") + "," + recordId + "," + "'" + field + "'," + "'" + oldValue + "'," + "'" + newValue + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'" + ")"; DataUtil.Update(sqlForExecute); }
private void btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { try { string sqlUpdate = "UPDATE empleado SET " + "[password] = '" + txtNewPassword.Text.Trim() + "'" + " WHERE [password] = '" + txtOldPassword.Text.Trim() + "'"; if (DataUtil.Update(sqlUpdate)) { MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } }
private void frmCloseTurn_Load(object sender, EventArgs e) { DataUtil.Update("DELETE FROM reporte_turno"); GetTurnInfo(); int turnoID = DataUtil.GetInt(lblTurno.Text); CargarTurnoEstacion(turnoID); CargarTurnoOrdenesPagadas(turnoID); CargarInformacionExtra(turnoID); CargarGastos(turnoID); CargarProductos(turnoID); if (TurnoIDValue != 0) { lblTurnoLabel.Text = @"Turno Cerrado:"; btnCerrarTurno.Visible = false; } txtVentaTotal.Text = txtDetalleTotal.Text; txtBalance.Text = DataUtil.GetString(DataUtil.GetDouble(txtFondoInicialTotal.Text) + DataUtil.GetDouble(txtDetalleTotal.Text) + _montoDeposito - _montoRetiro); InsertarValoresReporte("Venta Total", txtVentaTotal.Text); InsertarValoresReporte("Balance de Cajas", txtBalance.Text); }
protected override void DeleteData() { if (lblCategoria.Text.Equals("SI")) { MessageBox.Show("No se pueden borrar categorias del sistema.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DialogResult result = MessageBox.Show("Está seguro de eliminar el registro actual?", "Eliminar", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (ExistRecord()) { if (DataUtil.Update("DELETE FROM " + tableName + " WHERE " + formWhereField + " = " + txtCodigo.Text)) { MessageBox.Show(string.Format("Se eliminó {0} elemento(s).", 1), "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } } } }
private void btnDelete_Click(object sender, EventArgs e) { if (isRecordSelected()) { DialogResult diagResult = MessageBox.Show("Está seguro de eliminar el movimiento seleccionado?", "Eliminar", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (diagResult == DialogResult.Yes) { DataGridViewSelectedRowCollection Seleccionados = dgwCuenta.SelectedRows; foreach (DataGridViewRow item in Seleccionados) { if (DataUtil.Update("DELETE FROM movimientos WHERE Movimiento_id = " + item.Cells["MOVIMIENTO_ID"].Value.ToString() + "")) { if (DataUtil.GetString(item.Cells["Tipo_movimiento"].Value) == "DEPOSITO") { totalDeposito = totalDeposito - DataUtil.GetDouble(item.Cells["ImporteNeto"].Value); } else { totalRetiro = totalRetiro - DataUtil.GetDouble(item.Cells["ImporteNeto"].Value); } totalGeneral = totalRetiro + totalDeposito; txtDepositro.Text = totalDeposito.ToString(DataUtil.Format.Decimals); txtRetiro.Text = totalRetiro.ToString(DataUtil.Format.Decimals); txtTotal.Text = totalGeneral.ToString(DataUtil.Format.Decimals); this.dgwCuenta.Rows.RemoveAt(item.Index); } } } } else { MessageBox.Show("Seleccione un registro", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { string sqlForExecute = string.Empty; try { if (adding) { sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Proveedor_nombre," + "Proveedor_ruc," + "Proveedor_Telefono," + "Proveedor_Fax," + "Proveedor_web," + "Proveedor_email," + "Proveedor_comentarios," + "Proveedor_contacto," + "Estado," + "Fecha_creacion," + "Creado_por," + "Fecha_actualizacion," + "Actualizado_por)" + " VALUES (" + DataUtil.GetNewId(tableName) + "," + "'" + txtNombre.Text.Trim() + "'," + "'" + txtDocumento.Text.Trim() + "'," + "'" + txtTelefono.Text.Trim() + "'," + "'" + txtFax.Text.Trim() + "'," + "'" + txtWeb.Text.Trim() + "'," + "'" + txtEmail.Text.Trim() + "'," + "'" + txtComentarios.Text.Trim() + "'," + "'" + txtContacto.Text.Trim() + "'," + "'" + cbEstado.SelectedItem + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'" + ")"; } else { sqlForExecute = "UPDATE " + tableName + " SET " + "Proveedor_nombre = '" + txtNombre.Text.Trim() + "'" + ", Proveedor_ruc = '" + txtDocumento.Text.Trim() + "'" + ", Proveedor_Telefono = '" + txtTelefono.Text.Trim() + "'" + ", Proveedor_Fax = '" + txtFax.Text.Trim() + "'" + ", Proveedor_web = '" + txtWeb.Text.Trim() + "'" + ", Proveedor_email = '" + txtEmail.Text.Trim() + "'" + ", Proveedor_comentarios = '" + txtComentarios.Text.Trim() + "'" + ", Proveedor_contacto = '" + txtContacto.Text.Trim() + "'" + ", Estado = '" + cbEstado.SelectedItem + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE " + formWhereField + " = " + txtCodigo.Text; } if (DataUtil.Update(sqlForExecute)) { MessageBox.Show(@"Registro grabado correctamente", @"Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); if (adding) { this.Close(); } } } catch (Exception ex) { MessageBox.Show(@"Error en Grabar: " + ex.Message); } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { try { string sqlForExecute; if (adding) { txtCodigo.Text = DataUtil.GetString(DataUtil.GetNewId(tableName)); sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Cliente_apellidos," + "Cliente_nombres," + "Cliente_direccion," + "Telefono_casa," + "Telefono_celular," + "Telefono_trabajo," + "Documento," + "Tipo_documento," + "Comentario," + "Email_principal," + "Estado," + "Fecha_creacion," + "Creado_por," + "Fecha_actualizacion," + "Actualizado_por)" + " VALUES (" + txtCodigo.Text + "," + "'" + txtApellidos.Text.Trim().Replace("'", "''") + "'," + "'" + txtNombres.Text.Trim().Replace("'", "''") + "'," + "'" + txtDireccion.Text.Trim() + "'," + "'" + txtTelefono.Text.Trim() + "'," + "'" + txtCelular.Text.Trim() + "'," + "'" + txtTrabajo.Text.Trim() + "'," + "'" + txtDocumento.Text.Trim() + "'," + "'" + cbTipo.SelectedItem + "'," + "'" + txtComentarios.Text.Trim() + "'," + "'" + cbEmail.SelectedItem + "'," + "'" + cbEstado.SelectedItem + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'" + ")"; } else { sqlForExecute = "UPDATE " + tableName + " SET " + "Cliente_nombres = '" + txtNombres.Text.Trim().Replace("'", "''") + "'" + ", Cliente_apellidos = '" + txtApellidos.Text.Trim().Replace("'", "''") + "'" + ", Cliente_direccion = '" + txtDireccion.Text.Trim() + "'" + ", Telefono_casa = '" + txtTelefono.Text.Trim() + "'" + ", Telefono_celular = '" + txtCelular.Text.Trim() + "'" + ", Telefono_trabajo = '" + txtTrabajo.Text.Trim() + "'" + ", Email_principal = '" + cbEmail.SelectedItem + "'" + ", Comentario = '" + txtComentarios.Text.Trim() + "'" + ", Documento = '" + txtDocumento.Text.Trim() + "'" + ", Tipo_documento = '" + cbTipo.SelectedItem + "'" + ", Estado = '" + cbEstado.SelectedItem + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE " + formWhereField + " = " + txtCodigo.Text; } if (DataUtil.Update(sqlForExecute)) { MessageBox.Show(@"Registro grabado correctamente", @"Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); if (adding) { if (CreateSpecial) { if (cbTipo.SelectedItem.Equals("RUC")) { AppConstant.Customer.ClienteNombre = txtApellidos.Text.Trim(); } else { AppConstant.Customer.ClienteNombre = txtApellidos.Text.Trim() + ", " + txtNombres.Text.Trim(); } AppConstant.Customer.ClienteCodigo = txtCodigo.Text; AppConstant.Customer.ClienteTelefono = txtTelefono.Text; AppConstant.Customer.ClienteDireccion = txtDireccion.Text; AppConstant.Customer.ClienteDocumento = txtDocumento.Text; AppConstant.Customer.ClienteTipoDocumento = cbTipo.SelectedItem.ToString(); } Close(); } } } catch (Exception ex) { MessageBox.Show(@"Error en Grabar: " + ex.Message); } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { var dtpFechaNacimientoObj = "'" + DataUtil.GetString(dtpFechaNacimiento.Value) + "'"; var dtpFechaIngresoObj = "'" + DataUtil.GetString(dtpFechaIngreso.Value) + "'"; if (dtpFechaNacimiento.Value == DateTime.MinValue) { dtpFechaNacimientoObj = "null"; } if (dtpFechaIngreso.Value == DateTime.MinValue) { dtpFechaIngresoObj = "null"; } try { string sqlForExecute; if (adding) { sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Nombres_empleado," + "Apellidos_empleado," + "Direccion," + "Telefono_fijo," + "Celular," + "Email," + "Fecha_nacimiento," + "Fecha_ingreso," + "[Password]," + "Comentarios," + "Estado," + "Cargo," + "Fecha_creacion," + "Creado_por," + "Fecha_actualizacion," + "Actualizado_por)" + " VALUES (" + DataUtil.GetNewId(tableName) + "," + "'" + txtNombres.Text.Trim() + "'," + "'" + txtApellidos.Text.Trim() + "'," + "'" + txtDireccion.Text.Trim() + "'," + "'" + txtTelefono.Text.Trim() + "'," + "'" + txtCelular.Text.Trim() + "'," + "'" + txtEmail.Text.Trim() + "'," + "" + dtpFechaNacimientoObj + "," + "" + dtpFechaIngresoObj + "," + "'" + txtPassword.Text.Trim() + "'," + "'" + txtComentarios.Text.Trim() + "'," + "'" + cbEstado.SelectedItem + "'," + "'" + cbCargo.SelectedItem + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'" + ")"; } else { sqlForExecute = "UPDATE " + tableName + " SET " + "Nombres_empleado = '" + txtNombres.Text.Trim() + "'" + ", Apellidos_empleado = '" + txtApellidos.Text.Trim() + "'" + ", Direccion = '" + txtDireccion.Text.Trim() + "'" + ", Telefono_fijo = '" + txtTelefono.Text.Trim() + "'" + ", Celular = '" + txtCelular.Text.Trim() + "'" + ", Email = '" + txtEmail.Text.Trim() + "'" + ", Comentarios = '" + txtComentarios.Text.Trim() + "'" + ", Estado = '" + cbEstado.SelectedItem + "'" + ", Cargo = '" + cbCargo.SelectedItem + "'" + ", Fecha_nacimiento = " + dtpFechaNacimientoObj + "" + ", Fecha_ingreso = " + dtpFechaIngresoObj + "" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE " + formWhereField + " = " + txtCodigo.Text; } if (DataUtil.Update(sqlForExecute)) { MessageBox.Show(@"Registro grabado correctamente", @"Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); if (adding) { Close(); } } } catch (Exception ex) { MessageBox.Show(@"Error en Grabar: " + ex.Message); } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { var tableId = 0; try { string sqlForExecute; if (adding) { tableId = DataUtil.GetNewId(tableName); sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Estacion_descripcion," + "Persona_asignada," + "Estado," + "Fecha_creacion," + "Creado_por," + "Fecha_actualizacion," + "Actualizado_por)" + " VALUES (" + tableId + "," + "'" + txtDescripcion.Text.Trim() + "'," + "'" + ((System.Web.UI.WebControls.ListItem)(cbCajero.SelectedItem)).Value + "'," + "'" + cbEstado.SelectedItem + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'" + ")"; } else { sqlForExecute = "UPDATE " + tableName + " SET " + "Estacion_descripcion = '" + txtDescripcion.Text.Trim() + "'" + ", Estado = '" + cbEstado.SelectedItem + "'" + ", Persona_asignada = '" + ((System.Web.UI.WebControls.ListItem)(cbCajero.SelectedItem)).Value + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + " WHERE " + formWhereField + " = " + txtCodigo.Text; } if (DataUtil.Update(sqlForExecute)) { if (adding) { UpdateLog(tableId, "Cajero Asignado", string.Empty, cbCajero.SelectedItem.ToString()); } else { oldEstado = DataUtil.GetString(cbEstado.SelectedItem); if (personaAsignadaOld != DataUtil.GetString(cbCajero.SelectedItem)) { UpdateLog(tableId, "Cajero Asignado", personaAsignadaOld, cbCajero.SelectedItem.ToString()); } } MessageBox.Show(@"Registro grabado correctamente", @"Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); if (adding) { Close(); } } } catch (Exception ex) { MessageBox.Show(@"Error en Grabar: " + ex.Message); } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { string sqlForExecute = string.Empty; try { string categoriaWhere = "Producto_categoria_descripcion = '" + DataUtil.GetString(cbCategoria.SelectedItem) + "'"; string subCategoriaWhere = "Producto_sub_categoria_descripcion = '" + DataUtil.GetString(cbSubCategoria.SelectedItem) + "'"; string proveedorWhere = "Proveedor_nombre = '" + DataUtil.GetString(cbProveedor.SelectedItem) + "'"; string proveedorValue = "null"; if (DataUtil.GetString(cbProveedor.SelectedItem) != string.Empty) { proveedorValue = DataUtil.FindSingleRow("proveedor", "Proveedor_id", proveedorWhere); } string alertaFueraStock = cbStock.Checked ? "1" : "0"; if (adding) { txtCodigo.Text = DataUtil.GetString(DataUtil.GetNewId(tableName)); if (DataUtil.GetString(cbProveedor.SelectedItem) != string.Empty) { proveedorValue = "'" + proveedorValue + "',"; } else { proveedorValue = "" + proveedorValue + ","; } string descripcion = txtDescripcion.Text.Trim(); if (DataUtil.GetString(cbTipoProducto.SelectedItem).Equals("ADICIONAL")) { descripcion = "- " + txtDescripcion.Text.Trim(); } sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Producto_descripcion," + "Producto_descripcion_corta," + "Producto_categoria_id," + "Producto_sub_categoria_id," + "Proveedor_id," + "Precio_proveedor," + "Margen_ganancia," + "Precio_final," + "Producto_tipo," + "Cantidad_actual," + "Alerta_fuera_stock," + "Cantidad_fuera_stock," + "Fecha_creacion," + "Creado_por," + "Fecha_actualizacion," + "Actualizado_por," + "Estado)" + " VALUES (" + txtCodigo.Text + "," + "'" + descripcion.Replace("'", "''") + "'," + "'" + txtDescripcionCorta.Text.Replace("'", "''") + "'," + "'" + DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_id", categoriaWhere) + "'," + "'" + DataUtil.FindSingleRow("producto_sub_categoria", "Producto_sub_categoria_id", subCategoriaWhere) + "'," + proveedorValue + "'" + txtPrecioProveedor.Text.Trim() + "'," + "'" + txtMargen.Text.Trim() + "'," + "'" + txtPrecioFinal.Text.Trim() + "'," + "'" + cbTipoProducto.SelectedItem + "'," + "'" + txtStock.Text.Trim() + "'," + "'" + alertaFueraStock + "'," + "'" + txtStockAlert.Text.Trim() + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + cbEstado.SelectedItem + "'" + ")"; } else { if (DataUtil.GetString(cbProveedor.SelectedItem) != string.Empty) { proveedorValue = ", Proveedor_id = '" + proveedorValue + "'"; } else { proveedorValue = ", Proveedor_id = " + proveedorValue + ""; } sqlForExecute = "UPDATE " + tableName + " SET " + "Producto_descripcion = '" + txtDescripcion.Text.Trim().Replace("'", "''") + "'" + ",Producto_descripcion_corta = '" + txtDescripcionCorta.Text.Trim().Replace("'", "''") + "'" + ", Producto_categoria_id = '" + DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_id", categoriaWhere) + "'" + ", Producto_sub_categoria_id = '" + DataUtil.FindSingleRow("producto_sub_categoria", "Producto_sub_categoria_id", subCategoriaWhere) + "'" + proveedorValue + ", Precio_proveedor = '" + txtPrecioProveedor.Text.Trim() + "'" + ", Margen_ganancia = '" + txtMargen.Text.Trim() + "'" + ", Precio_final = '" + txtPrecioFinal.Text.Trim() + "'" + ", Producto_tipo = '" + cbTipoProducto.SelectedItem + "'" + ", Cantidad_actual = '" + txtStock.Text.Trim() + "'" + ", Alerta_fuera_stock = '" + alertaFueraStock + "'" + ", Cantidad_fuera_stock = '" + txtStockAlert.Text.Trim() + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + ", Estado = '" + cbEstado.SelectedItem + "'" + " WHERE " + formWhereField + " = " + txtCodigo.Text; } if (DataUtil.Update(sqlForExecute)) { MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); if (adding) { if (createSpecial) { AppConstant.Product.ProductoDescription = txtDescripcion.Text.Trim(); AppConstant.Product.ProductoDescriptionCorta = txtDescripcionCorta.Text.Trim(); AppConstant.Product.ProductoCodigo = txtCodigo.Text; AppConstant.Product.ProductoPrecio = txtPrecioFinal.Text; AppConstant.Product.ProductoPrecioProveedor = txtPrecioProveedor.Text; } this.Close(); } else { oldEstado = DataUtil.GetString(cbEstado.SelectedItem); } } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } }
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); } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsReadyToSave()) { string sqlForExecute = string.Empty; try { string grupoWhere = "Insumo_grupo_descripcion = '" + DataUtil.GetString(cbGrupo.SelectedItem) + "'"; string insumoWhere = "Insumo_descripcion = '" + DataUtil.GetString(cbInsumoBase.SelectedItem) + "'"; string proveedorWhere = "Proveedor_nombre = '" + DataUtil.GetString(cbProveedor.SelectedItem) + "'"; string proveedorValue = "null"; string insumoValue = "null"; if (DataUtil.GetString(cbProveedor.SelectedItem) != string.Empty) { proveedorValue = DataUtil.FindSingleRow("proveedor", "Proveedor_id", proveedorWhere); } if (DataUtil.GetString(cbInsumoBase.SelectedItem) != string.Empty) { insumoValue = DataUtil.FindSingleRow("insumo", "Insumo_id", proveedorWhere); } if (adding) { txtCodigo.Text = DataUtil.GetString(DataUtil.GetNewId(tableName)); if (DataUtil.GetString(cbProveedor.SelectedItem) != string.Empty) { proveedorValue = "'" + proveedorValue + "',"; } else { proveedorValue = "" + proveedorValue + ","; } if (DataUtil.GetString(cbInsumoBase.SelectedItem) != string.Empty) { insumoValue = "'" + insumoValue + "',"; } else { insumoValue = "" + insumoValue + ","; } sqlForExecute = "INSERT INTO " + tableName + " (" + formWhereField + "," + "Insumo_grupo_id," + "Presentacion_descripcion," + "Ultimo_costo," + "Costo_promedio," + "IGV," + "Costo_impuesto," + "Proveedor_id," + "Insumo_base_id," + "Rendimiento_valor," + "Rendimiento_unidad," + "Fecha_creacion," + "Creado_por," + "Fecha_actualizacion," + "Actualizado_por," + "Estado)" + " VALUES (" + txtCodigo.Text + "," + "'" + DataUtil.FindSingleRow("Insumo_grupo", "Insumo_grupo_id", grupoWhere) + "'," + "'" + txtDescripcion.Text.Replace("'", "''") + "'," + "'" + txtUltimoCosto.Text.Trim() + "'," + "'" + txtCostoPromedio.Text.Trim() + "'," + "'" + txtIGV.Text.Trim() + "'," + "'" + txtCostoImpuesto.Text.Trim() + "'," + proveedorValue + insumoValue + "'" + txtRendimiento.Text.Trim() + "'," + "'" + txtRendimientoUnidad.Text.Trim() + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + DateTime.Now + "'," + "'" + AppConstant.EmployeeInfo.Codigo + "'," + "'" + cbEstado.SelectedItem + "'" + ")"; } else { if (DataUtil.GetString(cbProveedor.SelectedItem) != string.Empty) { proveedorValue = ", Proveedor_id = '" + proveedorValue + "'"; } else { proveedorValue = ", Proveedor_id = " + proveedorValue + ""; } if (DataUtil.GetString(cbInsumoBase.SelectedItem) != string.Empty) { insumoValue = ", Insumo_base_id = '" + insumoValue + "'"; } else { insumoValue = ", Insumo_base_id = " + insumoValue + ""; } sqlForExecute = "UPDATE " + tableName + " SET " + " Insumo_grupo_id = '" + DataUtil.FindSingleRow("Insumo_grupo", "Insumo_grupo_id", grupoWhere) + "'" + ",Presentacion_descripcion = '" + txtDescripcion.Text.Trim().Replace("'", "''") + "'" + ",Ultimo_costo = '" + txtUltimoCosto.Text.Trim() + "'" + ",Costo_promedio = '" + txtCostoPromedio.Text.Trim() + "'" + ",IGV = '" + txtIGV.Text.Trim() + "'" + ",Costo_impuesto = '" + txtCostoImpuesto.Text.Trim() + "'" + proveedorValue + insumoValue + ",Rendimiento_valor = '" + txtRendimiento.Text.Trim() + "'" + ",Rendimiento_unidad = '" + txtRendimientoUnidad.Text.Trim() + "'" + ", Fecha_actualizacion = '" + DateTime.Now + "'" + ", Actualizado_por = '" + AppConstant.EmployeeInfo.Codigo + "'" + ", Estado = '" + cbEstado.SelectedItem + "'" + " WHERE " + formWhereField + " = " + txtCodigo.Text; } if (DataUtil.Update(sqlForExecute)) { MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); if (adding) { this.Close(); } } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } }
public static DialogResult InputBox(string title, string promptText, string tableName, string fieldName, string fieldRef, ref string value, bool validateKey, bool showDialog) { DialogResult dialogResult = DialogResult.OK; if (showDialog) { Form form = new Form(); Label label = new Label(); TextBox textBox = new TextBox(); Button buttonOk = new Button(); Button buttonCancel = new Button(); form.Text = title; label.Text = promptText; if (validateKey) { textBox.PasswordChar = '*'; } textBox.Text = value; buttonOk.Text = "OK"; buttonCancel.Text = "Cancel"; buttonOk.DialogResult = DialogResult.OK; buttonCancel.DialogResult = DialogResult.Cancel; label.SetBounds(9, 20, 372, 13); textBox.SetBounds(12, 36, 372, 20); textBox.CharacterCasing = CharacterCasing.Upper; buttonOk.SetBounds(228, 72, 75, 23); buttonCancel.SetBounds(309, 72, 75, 23); label.AutoSize = true; textBox.Anchor = textBox.Anchor | AnchorStyles.Right; buttonOk.Anchor = AnchorStyles.Bottom | AnchorStyles.Right; buttonCancel.Anchor = AnchorStyles.Bottom | AnchorStyles.Right; form.ClientSize = new Size(396, 107); form.Controls.AddRange(new Control[] { label, textBox, buttonOk, buttonCancel }); form.ClientSize = new Size(Math.Max(300, label.Right + 10), form.ClientSize.Height); form.FormBorderStyle = FormBorderStyle.FixedDialog; form.StartPosition = FormStartPosition.CenterScreen; form.MinimizeBox = false; form.MaximizeBox = false; form.AcceptButton = buttonOk; form.CancelButton = buttonCancel; dialogResult = form.ShowDialog(); value = textBox.Text.Trim(); if (validateKey) { if (value != string.Empty) { string sWhere = "codigo_empleado = " + fieldRef + " AND " + fieldName + " = '" + value + "'"; if (DataUtil.FindSingleRow(tableName, fieldName, sWhere) == string.Empty) { MessageBox.Show("El password es incorrecto.", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Warning); dialogResult = DialogResult.Cancel; } } else { dialogResult = DialogResult.Cancel; } } else { if (value != string.Empty) { string sWhere = fieldName + " = '" + value + "'"; if (DataUtil.FindSingleRow(tableName, fieldName, sWhere) != string.Empty) { MessageBox.Show("El registro ya existe en la base de datos.", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { try { string sqlInsert = string.Empty; if (tableName.Equals("cliente_email")) { sqlInsert = "INSERT INTO " + tableName + " (" + fieldName + "," + "cliente_id)" + " VALUES (" + "'" + DataUtil.GetString(value) + "'," + fieldRef + ")"; } else { sqlInsert = "INSERT INTO " + tableName + " (" + fieldName + ")" + " VALUES (" + "'" + DataUtil.GetString(value) + "')"; } if (DataUtil.Update(sqlInsert)) { MessageBox.Show("Registro grabado correctamente", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("Error en Grabar: " + ex.Message); } } } else { dialogResult = DialogResult.Cancel; } } } return(dialogResult); }