public static MovimientoDet Fetch(int id) { MovimientoDet m_entidad = new MovimientoDet(); using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "alm_movimientosdet_traerregistro"; command.Parameters.Add(new MySqlParameter("@n_id", id)); connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { m_entidad = SetObject(reader); } } } } return(m_entidad); }
public override void Delete() { using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { connection.Open(); using (MySqlTransaction transaction = connection.BeginTransaction()) { using (MySqlCommand command = connection.CreateCommand()) { try { MovimientoDet.DeleteAll(n_id, connection, transaction); command.Transaction = transaction; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "alm_movimientos_eliminar"; command.Parameters.Add(new MySqlParameter("@n_id", n_id)); int rows = command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } } }
public static ObservableListSource <MovimientoDet> FetchList(int n_idmov) { ObservableListSource <MovimientoDet> m_listentidad = new ObservableListSource <MovimientoDet>(); using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "alm_movimientosdet_listar"; command.Parameters.Add(new MySqlParameter("@n_idmov", n_idmov)); connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { MovimientoDet m_entidad = SetObject(reader); m_listentidad.Add(m_entidad); } } } } return(m_listentidad); }
private void GrabarMovimiento(MySqlConnection connection, MySqlTransaction transaction, bool isNew) { if (!isNew) { Movimiento movimientoAnterior = Movimiento.FetchPorInventario(this.n_id); if (movimientoAnterior != null) { movimientoAnterior.Delete(connection, transaction); } } Movimiento movimientoNuevo = new Movimiento(); movimientoNuevo.d_fchdoc = this.d_fchvig; movimientoNuevo.d_fching = this.d_fchvig; movimientoNuevo.n_idemp = this.n_idemp; movimientoNuevo.n_idtipmov = 1; movimientoNuevo.n_idclipro = 10293; movimientoNuevo.n_idtipdoc = 49; movimientoNuevo.c_numser = "0001"; movimientoNuevo.c_numdoc = TipoDocumento.UltimoNumero(this.n_idemp, 49, movimientoNuevo.c_numser); movimientoNuevo.n_idalm = this.n_idalm; movimientoNuevo.n_anotra = this.d_fchvig.Year; movimientoNuevo.n_idmes = this.d_fchvig.Month; movimientoNuevo.n_idtipope = 2; movimientoNuevo.n_tipite = 2; movimientoNuevo.n_docrefidtipdoc = 97; movimientoNuevo.n_docrefiddocref = this.n_id; movimientoNuevo.c_docrefnumser = this.c_numser; movimientoNuevo.c_docrefnumdoc = this._c_numdoc; movimientoNuevo.n_perid = 0; movimientoNuevo.n_prolog = 1; movimientoNuevo.MovimientoDets = new ObservableListSource <MovimientoDet>(); foreach (var hijo in InventarioInicialDets) { MovimientoDet movimientoDet = new MovimientoDet(); movimientoDet.n_idite = hijo.n_idite; movimientoDet.n_idpre = hijo.n_idunimed; movimientoDet.n_can = hijo.n_can; movimientoDet.c_numlot = "SIN LOTE"; movimientoDet.n_idtippro = 6; movimientoNuevo.MovimientoDets.Add(movimientoDet); } movimientoNuevo.Save(); }