/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package se.miun.roja1201;

import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.util.List;
import javax.ejb.Stateless;
import javax.imageio.ImageIO;
import javax.inject.Named;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.TypedQuery;
import static se.miun.roja1201.FileUtils.encodeToString;
import static se.miun.roja1201.FileUtils.getFileExtension;

/**
 *
 * @author Admin
 */
@Named
@Stateless
public class GuitarsList {
    @PersistenceContext(unitName = "WebApplicationFINALPU")
    private EntityManager em;
    public List<Guitars> getGuitars(){
        return em.createNamedQuery("Guitars.findAll", Guitars.class).getResultList();
    }
    public List<Guitars> getGuitarsByName(String name){
        return em.createNamedQuery("Guitars.findByName", Guitars.class).setParameter("name", name).getResultList();
    }
    public List<Guitars> getGuitarsBySold(boolean sold){
        return em.createNamedQuery("Guitars.findBySold", Guitars.class).setParameter("sold", sold).getResultList();
    }
    public List<Guitars> getGuitarsByGuitarrID(int id){
        return em.createNamedQuery("Guitars.findByGuitarrID", Guitars.class).setParameter("guitarrID", id).getResultList();
    }
    public List<Guitars> getGuitarsForDesktop(){
        TypedQuery<Guitars> guitarsQuery =
            em.createNamedQuery("Guitars.findAll", Guitars.class);
        List <Guitars> resultFromQuery= guitarsQuery.getResultList();
        try {
            for(Guitars it: resultFromQuery){
                String imageSRC = ("C:\\Users\\Admin\\Documents\\NetBeansProjects\\WebApplicationFINAL\\web\\"+it.getImagePath());
                System.out.println(imageSRC);
                String imgstr;
                System.out.println(imageSRC);
                BufferedImage img = ImageIO.read(new File(imageSRC));
                System.out.println("1");
                String extension= getFileExtension(new File(it.getImagePath()));
                System.out.println("2");
                imgstr = encodeToString(img, extension );
                System.out.println("3");
                //it.setImagePath(imgstr);
                it.setImage(imgstr);
                System.out.println("4");
                System.out.println(imgstr);
            }
        } catch (IOException ex) {
                System.out.println(ex);
        }
        return resultFromQuery;
    }
    public void addGuitar(Guitars guitars){
        em.persist(guitars);
        em.flush();
    }
}