package beans;

import backup.GuitarBean;
import java.io.IOException;
import java.io.InputStream;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.faces.bean.ManagedBean;
import javax.enterprise.context.RequestScoped;
import javax.faces.application.FacesMessage;
import javax.faces.context.FacesContext;
import javax.inject.Inject;
import org.primefaces.event.FileUploadEvent;
import org.primefaces.model.UploadedFile;

@ManagedBean(name= "addBean")
@RequestScoped

public class AddBean implements Serializable{

    private static final long serialVersionUID = 1L;

@Inject GuitarBean guitarBean;

    private UploadedFile img;

    /*public UploadedFile getImg() {
        return img;
    }
    public void setImg(UploadedFile img) {
        this.img = img;
    }*/
    public void handleFileUpload(FileUploadEvent event) {

        this.img = event.getFile();

    }
    public void store(){

            try{

                InputStream fin = img.getInputstream();
                Class.forName("org.apache.derby.jdbc.ClientDriver");
                String url="jdbc:derby://192.168.1.2:1527/sample;user=app;password=app;";
                Connection con = DriverManager.getConnection(url);
                PreparedStatement ps= con.prepareStatement("insert into guitar(model,price,manf,descr,prvowner,img)values(?,?,?,?,?,?)");
                ps.setString(1, guitarBean.getModel());
                ps.setInt(2, guitarBean.getPrice());
                ps.setString(3, guitarBean.getManf());
                ps.setString(4, guitarBean.getDescr());
                ps.setString(5, guitarBean.getPrvowner());
                ps.setBinaryStream(6, fin);
                ps.executeUpdate();


            }
            catch(IOException | ClassNotFoundException | SQLException e){
                System.out.println("Exception-File Upload." + e.getMessage());
            }
        }



}