public static void Eliminar(int idReserva)
        {
            // Operaciones.WriteLogsDebug("LibroDal", "Eliminar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), "Empezando a ejecutar el metodo acceso a datos para eliminar un Usuario"));

            SqlCommand command = null;

            // Proporcionar la cadena de consulta
            string queryString = @"UPDATE Prestamo SET Reserva=0
                                     WHERE IdPrestamo=@idPrestamo";

            try
            {
                command = OperacionesSQL.CreateBasicCommand(queryString);
                command.Parameters.AddWithValue("@idPrestamo", idReserva);
                OperacionesSQL.ExecuteBasicCommand(command);
            }
            catch (SqlException ex)
            {
                //Operaciones.WriteLogsRelease("LibroDal", "Eliminar", string.Format("{0} {1} Error: {1}", DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message));
                throw ex;
            }
            catch (Exception ex)
            {
                //Operaciones.WriteLogsRelease("LibroDal", "Eliminar", string.Format("{0} {1} Error: {1}", DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message));
                throw ex;
            }
            //Operaciones.WriteLogsDebug("LibroDal", "Eliminar", string.Format("{0} {1} Info: {1}", DateTime.Now.ToString(), DateTime.Now.ToString(), "Termino de ejecutar  el metodo acceso a datos para Eliminar un Cliente"));
        }
Пример #2
0
        public DataTable SelectLikeRPDM(byte opcionLike, string texto)
        {
            DataTable res   = new DataTable();
            string    query = @"SELECT * FROM VwListaRPDM WHERE [Nombre completo] like @texto  ";

            switch (opcionLike)
            {
            case 0:
                query = query + " AND Reserva =1 ";
                break;

            case 1:
                query = query + " AND Reserva =2";
                break;
            }
            query = query + " order by 7 desc";
            try
            {
                SqlCommand cmd = OperacionesSQL.CreateBasicCommand(query);
                cmd.Parameters.AddWithValue("@texto", "%" + texto + "%");
                res = OperacionesSQL.ExcecuteDataTableCommand(cmd);
            }
            catch (Exception)
            {
                throw;
            }
            return(res);
        }
Пример #3
0
        public static Prestamo ObtenerID()
        {
            Prestamo      prestamo = new Prestamo();
            SqlCommand    cmd      = null;
            SqlDataReader dr       = null;

            string query = @"SELECT max(idPrestamo) as IdPrestamo FROM Prestamo";

            try
            {
                cmd = OperacionesSQL.CreateBasicCommand(query);
                dr  = OperacionesSQL.ExecuteDataReaderCommand(cmd);
                while (dr.Read())
                {
                    prestamo = new Prestamo()
                    {
                        IdPrestamo = dr.GetInt32(0)
                    };
                }
            }
            catch (Exception ex)
            {
                //Operaciones.WriteLogsRelease("LibroDal", "Obtenet(Get)", string.Format("{0} {1} Error: {2}", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), ex.Message));
                throw ex;
            }
            finally
            {
                cmd.Connection.Close();
            }
            return(prestamo);
        }
Пример #4
0
        /// <summary>
        /// Actualiza Persona de la base de datos
        /// </summary>
        /// <param name="Persona"></param>
        public static void Multas(Prestamo prestamo)
        {
            // Operaciones.WriteLogsDebug("PersonaDal", "Actualizar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), "Empezando a ejecutar el metodo acceso a datos para eliminar un Persona"));
            SqlCommand command = null;
            // Proporcionar la cadena de consulta
            string queryString = @"UPDATE Prestamo SET Multas=1 , Monto_multas = @monto_multas
                                   WHERE IdPrestamo = @id";

            try
            {
                command = OperacionesSQL.CreateBasicCommand(queryString);
                command.Parameters.AddWithValue("@id", prestamo.IdPrestamo);
                //  command.Parameters.AddWithValue("@monto_multas", prestamo.);

                OperacionesSQL.ExecuteBasicCommand(command);
            }
            catch (SqlException ex)
            {
                //Operaciones.WriteLogsRelease("PersonaDal", "Actualizar", string.Format("{0} Error: {1}", DateTime.Now.ToString(), ex.Message));
                throw ex;
            }
            catch (Exception ex)
            {
                // Operaciones.WriteLogsRelease("PersonaDal", "Actualizar", string.Format("{0} Error: {1}", DateTime.Now.ToString(), ex.Message));
                throw ex;
            }

            //Operaciones.WriteLogsDebug("PersonaDal", "Actualizar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), "Termino de ejecutar  el metodo acceso a datos para Eliminar un Cliente"));
        }
Пример #5
0
        public DataTable SelectLikeFullLibro(string texto)
        {
            DataTable res   = new DataTable();
            string    query = @"SELECT * FROM VwfullLibro WHERE Nombre LIKE @texto ORDER BY 2";

            try
            {
                SqlCommand cmd = OperacionesSQL.CreateBasicCommand(query);
                cmd.Parameters.AddWithValue("@texto", "%" + texto + "%");
                res = OperacionesSQL.ExcecuteDataTableCommand(cmd);
            }
            catch (Exception)
            {
                throw;
            }
            return(res);
        }
        public DataTable SelectReservaLibro(int id)
        {
            DataTable res   = new DataTable();
            string    query = @"  SELECT * FROM VwReserbaPersona WHERE [Id Persona]=@id ORDER BY 5";

            try
            {
                SqlCommand cmd = OperacionesSQL.CreateBasicCommand(query);
                cmd.Parameters.AddWithValue("@id", id);
                res = OperacionesSQL.ExcecuteDataTableCommand(cmd);
            }
            catch (Exception)
            {
                throw;
            }
            return(res);
        }
Пример #7
0
        public DataTable SelectLikeActualizarFecha(string texto)
        {
            DataTable res   = new DataTable();
            string    query = @" SELECT * FROM VwActualizarFecha WHERE Reserva=2 AND [Nombre completo] like @texto  ";

            try
            {
                SqlCommand cmd = OperacionesSQL.CreateBasicCommand(query);
                cmd.Parameters.AddWithValue("@texto", "%" + texto + "%");
                res = OperacionesSQL.ExcecuteDataTableCommand(cmd);
            }
            catch (Exception)
            {
                throw;
            }
            return(res);
        }
        public DataTable Contar(int id)
        {
            DataTable dt    = new DataTable();
            string    query = "SELECT COUNT (reserva) FROM Prestamo WHERE idUsuario=@id AND reserva=1";

            try
            {
                SqlCommand cmd = OperacionesSQL.CreateBasicCommand(query);
                cmd.Parameters.AddWithValue("@id", id);
                dt = OperacionesSQL.ExcecuteDataTableCommand(cmd);
            }
            catch (Exception err)
            {
                MessageBox.Show("Error al insertar el cliente" + err);
                throw err;
            }
            return(dt);
        }
Пример #9
0
        /// <summary>
        /// Metodo para obtener  un empleado
        /// </summary>
        /// <param name="id">Identificado del empleado </param>
        /// <returns>Empleado</returns>
        public static Prestamo Obtener(int id)
        {
            Prestamo      prestamo = new Prestamo();
            SqlCommand    cmd      = null;
            SqlDataReader dr       = null;

            string query = @"select * from Prestamo
                             where idPrestamo= @id";

            try
            {
                cmd = OperacionesSQL.CreateBasicCommand(query);
                cmd.Parameters.AddWithValue("@id", id);
                dr = OperacionesSQL.ExecuteDataReaderCommand(cmd);
                while (dr.Read())
                {
                    prestamo = new Prestamo()
                    {
                        IdPrestamo      = dr.GetInt32(0),
                        FechaPrestamo   = dr.GetDateTime(2),
                        FechaDevolucion = dr.GetDateTime(5),
                        Reserva         = dr.GetInt32(4),
                        //Fecha_hora_reserva = dr.GetDateTime(4),
                        //Multas = dr.GetInt32(5),
                        //Monto_multas = dr.GetInt32(6),
                        IdUsuario = dr.GetInt16(1),
                        IdLibro   = dr.GetInt32(3)
                    };
                }
            }
            catch (Exception ex)
            {
                //Operaciones.WriteLogsRelease("PersonaDal", "Obtenet(Get)", string.Format("{0} {1} Error: {2}", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), ex.Message));
                throw ex;
            }
            finally
            {
                cmd.Connection.Close();
            }

            return(prestamo);
        }