import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import java.util.ArrayList;

import pe.edu.idat.semana07sqlite.BE.ArticuloBE;
import pe.edu.idat.semana07sqlite.DAO.DataBaseManager;

public class ArticuloBL extends DataBaseManager {

    public ArticuloBL(Context context) {
        super(context);
    }
    //TODO METODO LISTAR ARTCULOS EN UN ARRAYLIST
    public ArrayList<ArticuloBE> getAllArticulo() {
        ArrayList<ArticuloBE> lst = null;
    try{
        SQLiteDatabase db = getReadableDatabase();
        Cursor c = db.rawQuery("SELECT * FROM maearticulo", null);
        if(c.moveToFirst()) {
            lst = new ArrayList<>();
            do {
                ArticuloBE item = new ArticuloBE();
                item.setArtCodigo(c.getString(0));
                item.setArtCodLin(c.getString(1));
                item.setArtDescri(c.getString(2));
                item.setArtAbrevi(c.getString(3));
                item.setArtCodEst(c.getInt(5));


                lst.add(item);
            }while(c.moveToNext());
        }
    } catch (Exception e){
        e.printStackTrace();
    }
        return lst;
    }
}