// GET api/picture
        public Picture Get(string id, string picture_id)
        {
            Picture picture = new Picture();
            picture = pictureManagerService.Get(picture_id);
            if (picture == null || picture.url_general == null)
            {

                var resp = new HttpResponseMessage(HttpStatusCode.NotFound)
                {
                    Content = new StringContent(string.Format("No pictures with ID = {0}", id)),
                    ReasonPhrase = "Pictures ID Not Found",
                    StatusCode = HttpStatusCode.NotFound
                };
                throw new HttpResponseException(resp);

            }
            return picture;
        }
        private void addPicture(string item_id, Picture newPicture)
        {
            //pictures.Clear();
            String _query = "exec [sp_api_newPicture]  '" + newPicture.item_id + "'," + newPicture.num_photo + ",'" + newPicture.url_general + "','"+newPicture.path_general+"'";
            //BaseDatos conexion = new BaseDatos("SQL");   //Creando objetos de la base de datos
            conexion.Conectar();
            conexion.CrearComando(_query); //Comando indica que quiero encontrar
            DbDataReader DRConexion = conexion.EjecutarConsulta();
            while (DRConexion.Read())
            {

                picture = new Picture
                {
                    id = int.Parse(DRConexion.GetDecimal(0).ToString()),
                    item_id = DRConexion.GetString(1),
                    num_photo = DRConexion.GetInt32(2),
                    url_general = DRConexion.GetString(3)
                };

            }
            conexion.Desconectar();
        }
        // POST api/picture
        public Picture Post(string id, Picture pictureBase)
        {
            Picture newPicture = pictureManagerService.Add(id, pictureBase);

            if (newPicture == null || newPicture.url_general == "")
            {

                var resp = new HttpResponseMessage(HttpStatusCode.NotFound)
                {
                    Content = new StringContent(string.Format("No picture with ID = {0}", id)),
                    ReasonPhrase = "Picture ID Not Found",
                    StatusCode = HttpStatusCode.NotFound
                };
                throw new HttpResponseException(resp);

            }

            return newPicture;
        }
 public Picture Add(string id, Picture newPicture)
 {
     addPicture(id, newPicture);
     return picture;
 }
        private void getPicture(string id)
        {
            String _query = "exec [sp_api_getPicture] " + id;
            //BaseDatos conexion = new BaseDatos("SQL");   //Creando objetos de la base de datos
            conexion.Conectar();
            conexion.CrearComando(_query); //Comando indica que quiero encontrar
            DbDataReader DRConexion = conexion.EjecutarConsulta();
            while (DRConexion.Read())
            {

                picture = new Picture
                {
                    id = int.Parse(DRConexion.GetDecimal(0).ToString()),
                    item_id = DRConexion.GetString(1),
                    num_photo = DRConexion.GetInt32(2),
                    url_general = DRConexion.GetString(3),
                    path_general = DRConexion.GetString(4)
                };

            }
            conexion.Desconectar();
        }