Exemple #1
0
        public resultTransaction CRUD()
        {
            var result = new resultTransaction();
            var dt     = new DataTable();

            try
            {
                dt = oEntradas.GetData(@operacion, ref result.idOut, ref result.hasError, ref result.noError, ref result.messageError,
                                       @idEntrada, @idProveedor, @idUsuarioAlta, @fechaAlta, @nombreEntrega, @total, @folio, @activo,
                                       @indexInicio, @indexFin);

                result.dtResult = dt;
                return(result);
            }
            catch (SqlException ex)
            {
                result.hasError     = true;
                result.dtResult     = dt;
                result.noError      = ex.ErrorCode;
                result.messageError = string.Format("Error: {0} , {1}, {2} , {3}", ex.Message, ex.Procedure, ex.Source, ex.LineNumber);
                result.idOut        = "";

                return(result);
            }
        }
Exemple #2
0
        public resultTransaction CRUD()
        {
            var result = new resultTransaction();
            var dt     = new DataTable();

            try
            {
                dt = oSalidasPartidas.GetData(@operacion, ref result.idOut, ref result.hasError, ref result.noError, ref result.messageError,
                                              @idPartida, @idSalida, @idProducto, @code, @nombre, @cantidad, @activo,
                                              @indexInicio, @indexFin);

                result.dtResult = dt;
                return(result);
            }
            catch (SqlException ex)
            {
                result.hasError     = true;
                result.dtResult     = dt;
                result.noError      = ex.ErrorCode;
                result.messageError = string.Format("Error: {0} , {1}, {2} , {3}", ex.Message, ex.Procedure, ex.Source, ex.LineNumber);
                result.idOut        = "";

                return(result);
            }
        }
Exemple #3
0
        public resultTransaction CRUD()
        {
            var result = new resultTransaction();
            var dt     = new DataTable();

            try
            {
                dt = oUsuarios.GetData(@operacion, ref result.idOut, ref result.hasError, ref result.noError, ref result.messageError,
                                       @idUsuario, @idRol, @nombre, @usuario, @psw, @idDepto, @telefono, @celular, @correo, @idUsuarioA, @activo,
                                       @indexInicio, @indexFin);

                result.dtResult = dt;
                return(result);
            }
            catch (SqlException ex)
            {
                result.hasError     = true;
                result.dtResult     = dt;
                result.noError      = ex.ErrorCode;
                result.messageError = string.Format("Error: {0} , {1}, {2} , {3}", ex.Message, ex.Procedure, ex.Source, ex.LineNumber);
                result.idOut        = "";

                return(result);
            }
        }
Exemple #4
0
        public resultTransaction CRUD()
        {
            var result = new resultTransaction();
            var dt     = new DataTable();

            try
            {
                dt = oProductos.GetData(@operacion, ref result.idOut, ref result.hasError, ref result.noError, ref result.messageError,
                                        @idProducto, @nombre, @descripcion, @idGrupo, @codigo, @total, @minimo, @maximo, @idUm, @idUsuario, @activo,
                                        @indexInicio, @indexFin, @precioUnit);

                result.dtResult = dt;
                return(result);
            }
            catch (SqlException ex)
            {
                result.hasError     = true;
                result.dtResult     = dt;
                result.noError      = ex.ErrorCode;
                result.messageError = string.Format("Error: {0} , {1}, {2} , {3}", ex.Message, ex.Procedure, ex.Source, ex.LineNumber);
                result.idOut        = "";

                return(result);
            }
        }
Exemple #5
0
        public resultTransaction CRUD()
        {
            var result = new resultTransaction();
            var dt     = new DataTable();

            try
            {
                dt = oBitacora.GetData(@operacion, ref result.idOut, ref result.hasError, ref result.noError, ref result.messageError,
                                       @id, @fechaAlta, @detalles, @folio, @indexInicio, @indexFin);

                result.dtResult = dt;
                return(result);
            }
            catch (SqlException ex)
            {
                result.hasError     = true;
                result.dtResult     = dt;
                result.noError      = ex.ErrorCode;
                result.messageError = string.Format("Error: {0} , {1}, {2} , {3}", ex.Message, ex.Procedure, ex.Source, ex.LineNumber);
                result.idOut        = "";

                return(result);
            }
        }
Exemple #6
0
        public resultTransaction CRUD()
        {
            var result = new resultTransaction();
            var dt     = new DataTable();

            try
            {
                dt = oRol.GetData(@operacion, ref result.idOut, ref result.hasError, ref result.noError, ref result.messageError,
                                  @idRol, @rol, @idUsuario, @activo);

                result.dtResult = dt;
                return(result);
            }
            catch (SqlException ex)
            {
                result.hasError     = true;
                result.dtResult     = dt;
                result.noError      = ex.ErrorCode;
                result.messageError = string.Format("Error: {0} , {1}, {2} , {3}", ex.Message, ex.Procedure, ex.Source, ex.LineNumber);
                result.idOut        = "";

                return(result);
            }
        }