public class Contact {

    private int CTC_ID;
    public Bitmap CTC_IMAGE;
    public String CTC_NOM;
    public String CTC_NUMERO;

    public Contact(){
    }

    public Contact(Bitmap CTC_IMAGE, String CTC_NOM, String CTC_NUMERO){
        this.CTC_IMAGE = CTC_IMAGE;
        this.CTC_NOM = CTC_NOM;
        this.CTC_NUMERO = CTC_NUMERO;
    }
    public Contact(String CTC_NOM, String CTC_NUMERO){
        this.CTC_NOM = CTC_NOM;
        this.CTC_NUMERO = CTC_NUMERO;
    }

    public int getCTC_ID(){
        return CTC_ID;
    }
    public Bitmap getCTC_IMAGE(){return CTC_IMAGE; }
    public String getCTC_NOM() {
        return CTC_NOM;
    }
    public String getCTC_NUMERO() {
        return CTC_NUMERO;
    }

    public void setCTC_ID(int CTC_ID) {
        this.CTC_ID = CTC_ID;
    }
    public void setCTC_IMAGE(Bitmap CTC_IMAGE) {
        this.CTC_IMAGE = CTC_IMAGE;
    }
    public void setCTC_NOM(String CTC_NOM) {
        this.CTC_NOM = CTC_NOM;
    }
    public void setCTC_NUMERO(String CTC_NUMERO) {
        this.CTC_NUMERO = CTC_NUMERO;
    }


    public String toString(){
        return "ID : "+CTC_ID+"nimage : "+CTC_IMAGE+"nnom : "+CTC_NOM+"nnumero : "+CTC_NUMERO;
    }
}

public ArrayList<Contact> fetchAllContactDetail() throws SQLException {
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor mCursor = db.query(TABLE_CONTACT, new String[]{"CTC_ID _id", KEY_CTC_IMAGE, KEY_CTC_IMAGE, KEY_CTC_NOM, KEY_CTC_NUMERO}, null, null, null, null, null);

    if (mCursor.moveToFirst()) {
        do {
            byte[] blob = mCursor.getBlob(mCursor.getColumnIndex(KEY_CTC_IMAGE));
            String name = mCursor.getString(mCursor.getColumnIndex(KEY_CTC_NOM));
            String numero = mCursor.getString(mCursor.getColumnIndex(KEY_CTC_NUMERO));
            contactListe.add(new Contact(Utility.getPhoto(blob), name, numero));
        } while (mCursor.moveToNext());
    }
    return contactListe;
}

public class ContactAdapter extends BaseAdapter {

    private Context mContext;
    ArrayList<Contact> contactList = new ArrayList<Contact>();

    // Constructor
    public ContactAdapter(Context c, ArrayList<Contact> contactList) {
        mContext = c;
        this.contactList = contactList;
    }


    @Override
    public int getCount() {
        return contactList.size();

    }

    @Override
    public Object getItem(int position) {
        return contactList.get(position);
    }

    @Override
    public long getItemId(int position) {
        return 0;
    }

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        LayoutInflater layoutInflater;
        layoutInflater = LayoutInflater.from(mContext);

        convertView= layoutInflater.inflate(R.layout.contact_item, null);

        // Lookup view for data population
        ImageView img = (ImageView) convertView.findViewById(R.id.img);
        TextView name = (TextView) convertView.findViewById(R.id.name);

        // Populate the data into the template view using the data object
        img.setImageBitmap(contactList.get(position).getCTC_IMAGE());
        name.setText(contactList.get(position).getCTC_NUMERO());
        // Return the completed view to render on screen
        return convertView;
    }
}