public class PlaceOrder extends AppCompatActivity{

    ListView myListview;// Place Order listview
    String str ;
    Spinner spnCategory; // Catergory filter
    ArrayList<GetandSet> details = new ArrayList<GetandSet>();
    ItemCustomAdapter customAdapter; // custom adapter template
    CustomArrayAdapter customArrayAdapter;
    ArrayList<GetandSet> productOrders = new ArrayList<GetandSet>(); // to store list of selected views
    ArrayList<Integer> positionArr = new ArrayList<Integer>(); // to store list of selected position
    GetandSet getandSet ;

    private static int counter = 1;

    TextView title,countTv;
    ImageView imgback, imgMenu,imgcart;
    MySQLiteDatabase mysqlitedatabase;



    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_place_order);

        title = (TextView) findViewById(R.id.title);
        countTv = (TextView) findViewById(R.id.count_tv);
        imgback = (ImageView) findViewById(R.id.img_back);
        imgMenu = (ImageView) findViewById(R.id.img_menu);
        imgcart= (ImageView) findViewById(R.id.img_cart);

        mysqlitedatabase = new MySQLiteDatabase(getApplicationContext(),null,null,1);
        SQLiteDatabase db = mysqlitedatabase.getWritableDatabase();
        Cursor cursor = db.rawQuery("SELECT  * FROM MenuMaster", null);

        title.setText("Place Order");

        imgback.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                startActivity(new Intent(PlaceOrder.this, DashBoard.class));
                finish();
                counter = 1;
            }
        });

        imgMenu.setVisibility(View.INVISIBLE);

        myListview = (ListView)findViewById(R.id.my_list_view);//defined list_view
        spnCategory = (Spinner)findViewById(R.id.spn_place_category);//defined category
        loadSpinnerData();
        showList();
    }

    //Binding Adapter and list view and Showing Data from database
    public void showList() {
        final Cursor c1 = mysqlitedatabase.selectQuery("SELECT * FROM MenuMaster ");
        if (c1 != null && c1.getCount() != 0) {
            if (c1.moveToFirst()) {
                do {
                    getandSet = new GetandSet();

                    getandSet.setMenu_name(c1.getString(c1.getColumnIndex("menu_name")));
                    getandSet.setMenu_rate(c1.getString(c1.getColumnIndex("menu_rate")));
                    getandSet.setMenu_Remark(c1.getString(c1.getColumnIndex("menu_Remark")));
                    getandSet.setMenu_Qty(c1.getInt(c1.getColumnIndex("menu_qty")));

                    details.add(getandSet);

                } while (c1.moveToNext());
            }
        }
        c1.close();
        customAdapter = new ItemCustomAdapter(PlaceOrder.this, details);
        myListview.setAdapter(customAdapter);
        //display all data
        //On Item Click Listener
        myListview.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> parent, View view, int position, long id) {

                str = Integer.toString(counter++);
                countTv.setText(str);//shopping cart counter

                positionArr.add(position);// getting clicked position
                HashSet<Integer> hashSet = new HashSet<Integer>();
                hashSet.addAll(positionArr);
                positionArr.clear();
                positionArr.addAll(hashSet);// assigning position serialy

                int len = myListview.getCount();//list view size

                for (int i = 0; i < len; i++) {

                    if (position == i) {

                        getandSet = new GetandSet();
                        getandSet.setMenu_name(customAdapter.DETAILS.get(i).getMenu_name());
                        getandSet.setMenu_rate(customAdapter.DETAILS.get(i).getMenu_rate());
                        getandSet.setMenu_Remark(customAdapter.DETAILS.get(i).getMenu_Remark());
                        getandSet.setMenu_Qty(customAdapter.DETAILS.get(i).getMenu_Qty());

                        productOrders.add(getandSet);

                    }
                }

                customAdapter.viewHolder.txtQuantity.setText(String.valueOf(customAdapter.DETAILS.get(position).getMenu_Qty()));
                    onimgButtonClick();
                }
            });
    }

    @Override
    public void onBackPressed() {
        finish();
    }

    public void onimgButtonClick()
    {
        imgcart.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(PlaceOrder.this,MyOrderedBill.class);
                intent.putExtra("selected_list", positionArr);//sending positions
                intent.putExtra("selected_order",productOrders);
                counter=1;
                startActivity(intent);
            }
        });
    }
}

public class MyOrderedBill extends AppCompatActivity {

    ListView myListview;
    GetandSet getandSet ;
    BillOrderCustomAdapter customAdapter;
    CustomArrayAdapter customArrayAdapter;
    MySQLiteDatabase mysqlitedatabase;
    ArrayList<Integer> postionId;
    ArrayList<GetandSet> productOrders = new ArrayList<>();
    ArrayList<GetandSet> getProductOrders = new ArrayList<>();
    ImageView imgBack;
    TextView txtToatalamt,txtgrandTotal;
    Button btnPayPrint;

    ArrayList<GetandSet> selectedList = new ArrayList<GetandSet>(); // to store list of selected views

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_my_ordered_bill);

        txtToatalamt = (TextView)findViewById(R.id.txt_Total_Amount);
        btnPayPrint = (Button) findViewById(R.id.btn_Pay_Print);
        txtgrandTotal = (TextView)findViewById(R.id.txt_Grand_Total);
        myListview = (ListView)findViewById(R.id.list_item);
        imgBack = (ImageView)findViewById(R.id.imgBack);

        imgBack.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                startActivity(new Intent(MyOrderedBill.this,PlaceOrder.class));
                onBackPressed();
            }
        });

        btnPayPrint.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                placeOrder();
            }
        });

        Bundle b = this.getIntent().getExtras();
        postionId = b.getIntegerArrayList("selected_list");
        productOrders = (ArrayList<GetandSet>)getIntent().getSerializableExtra("selected_order");

        for(int i = 1; i < postionId.size();++i)
        {

           if(postionId.get(i) == i)
           {

                GetandSet d = new GetandSet();

                d.setMenu_name(productOrders.get(i).getMenu_name());
                d.setMenu_rate(productOrders.get(i).getMenu_rate());
                d.setMenu_Remark(productOrders.get(i).getMenu_Remark());
                d.setMenu_Qty(productOrders.get(i).getMenu_Qty());

                productOrders.add(d);
            }
        }
        customArrayAdapter = new CustomArrayAdapter(this,productOrders);
        myListview.setAdapter(customArrayAdapter);
    }
}

public class ItemCustomAdapter extends BaseAdapter{


    Context CONTEXT ;
    List<GetandSet> DETAILS ;
    ImageView itemImage;
    LayoutInflater layoutInflater;
    Activity activity;
    ViewHolder viewHolder;

    public ItemCustomAdapter(Activity activity, List<GetandSet> details) {
        this.activity = activity;
        this.DETAILS = details;
        this.layoutInflater = (LayoutInflater) activity.getSystemService(activity.LAYOUT_INFLATER_SERVICE);

    }

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

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

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

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        GetandSet details = new GetandSet();
        if (convertView == null) {
            convertView = layoutInflater.inflate(R.layout.custom_adapter_template, parent, false);
            viewHolder = new ViewHolder(convertView);
            convertView.setTag(viewHolder);
        } else {
            viewHolder = (ViewHolder) convertView.getTag();
        }

        viewHolder.txtitemname.setText(DETAILS.get(position).getMenu_name());
        viewHolder.txtitemprice.setText(DETAILS.get(position).getMenu_rate()+"/-");
        viewHolder.txtremark.setText(DETAILS.get(position).getMenu_Remark());
        viewHolder.txtQuantity.setText(DETAILS.get(position).getMenu_Qty()+"");

        return convertView;
    }
    public class ViewHolder{
        TextView txtitemname,txtitemprice,txtremark;
        EditText txtQuantity;

        public ViewHolder(View view) {
            txtitemname = (TextView)view.findViewById(R.id.txt_Item_Name);
            txtitemprice = (TextView)view.findViewById(R.id.txt_Item_Price);
            txtremark = (TextView)view.findViewById(R.id.txt_Item_remark);
            txtQuantity = (EditText)view.findViewById(R.id.txt_Quantity);
        }
    }//View holder

}

public class CustomArrayAdapter extends ArrayAdapter<GetandSet> {

    private Context Context;
    public ArrayList<GetandSet> selectedarraylist = new ArrayList<>();

    TextView itemName,itemRemark,itemrate,txtqty;
    Button btnadd,btnsub;
    GetandSet products;


    public CustomArrayAdapter(@NonNull Context context, ArrayList<GetandSet> list) {
        super(context, 0 , list);
        Context = context;
        selectedarraylist = list;
    }

    @NonNull
    @Override
    public View getView(final int position, @Nullable View convertView, @NonNull ViewGroup parent) {
        View listItem = convertView;
        if(listItem == null)
            listItem = LayoutInflater.from(Context).inflate(R.layout.custom_menu_item_bill,parent,false);

        itemName = (TextView)listItem.findViewById(R.id.txt_Item_Name);
        itemRemark = (TextView)listItem.findViewById(R.id.txt_Remark);
        itemrate = (TextView)listItem.findViewById(R.id.txt_Item_Net_Price);

        txtqty = (TextView)listItem.findViewById(R.id.txt_dis_qty);
        btnadd = (Button)listItem.findViewById(R.id.btn_add_qty);
        btnsub = (Button)listItem.findViewById(R.id.btn_remove_qty);

        itemName.setText(selectedarraylist.get(position).getMenu_name());
        itemrate.setText(selectedarraylist.get(position).getMenu_rate());
        itemRemark.setText(selectedarraylist.get(position).getMenu_Remark());
        txtqty.setText(selectedarraylist.get(position).getMenu_Qty()+"");

       btnadd.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

                updateQuantity(position, txtqty, 1);
            }
        });

       btnsub.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                updateQuantity(position, txtqty, -1);
            }
        });

        return listItem;

    }
    private void updateQuantity(int position, TextView edTextQuantity, int value) {

      // GetandSet products = (GetandSet) getItem(position);
        products = selectedarraylist.get(position);

        if(value > 0)
        {
            products.menu_Qty = products.menu_Qty + 1;
            edTextQuantity.setText(products.menu_Qty+"");
            notifyDataSetChanged();
        }
        else
        {
            if(products.menu_Qty > 0)
            {
                products.menu_Qty = products.menu_Qty - 1;
                edTextQuantity.setText(products.menu_Qty+"");
                notifyDataSetChanged();
            }
        }
    }
}

public class GetandSet implements Serializable {
    int id;
    String _name, _passwrod, _status ;
    String cat_id,cat_name,cat_desc,cat_kot;
    String menu_ID;
    String menu_name;
    String menu_int;
    String menu_rate;
    String menu_Remark;
    String menu_cat;


    public int getMenu_Qty() {
        return menu_Qty;
    }

    public void setMenu_Qty(int menu_Qty) {
        this.menu_Qty = menu_Qty;
    }

    int menu_Qty;


    public String getCat_id() {
        return cat_id;
    }

    public void setCat_id(String cat_id) {
        this.cat_id = cat_id;
    }

    public String getCat_name() {
        return cat_name;
    }

    public void setCat_name(String cat_name) {
        this.cat_name = cat_name;
    }

    public String getCat_desc() {
        return cat_desc;
    }

    public void setCat_desc(String cat_desc) {
        this.cat_desc = cat_desc;
    }

    public String getCat_kot() {
        return cat_kot;
    }

    public void setCat_kot(String cat_kot) {
        this.cat_kot = cat_kot;
    }

    public int getId() {
        return id;
    }

    public String get_name() {
        return _name;
    }

    public String get_passwrod() {
        return _passwrod;
    }

    public String get_status() {
        return _status;
    }

    public void setId(int id) {
        this.id = id;
    }

    public void set_name(String _name) {
        this._name = _name;
    }

    public void set_passwrod(String _passwrod) {
        this._passwrod = _passwrod;
    }

    public void set_status(String _status) {
        this._status = _status;
    }

    public String getMenu_ID() {
        return menu_ID;
    }

    public void setMenu_ID(String menu_ID) {
        this.menu_ID = menu_ID;
    }

    public String getMenu_name() {
        return menu_name;
    }

    public String setMenu_name(String menu_name) {
        this.menu_name = menu_name;
        return menu_name;
    }

    public String getMenu_int() {
        return menu_int;
    }

    public void setMenu_int(String menu_int) {
        this.menu_int = menu_int;
    }

    public String getMenu_rate() {
        return menu_rate;
    }

    public void setMenu_rate(String menu_rate) {
        this.menu_rate = menu_rate;
    }

    public String getMenu_Remark() {
        return menu_Remark;
    }

    public void setMenu_Remark(String menu_Remark) {
        this.menu_Remark = menu_Remark;
    }

    public String getMenu_cat() {
        return menu_cat;
    }

    public void setMenu_cat(String menu_cat) {
        this.menu_cat = menu_cat;
    }

}

myDatabaseHandler file (MySQLiteDatabase )


    public class MySQLiteDatabase extends SQLiteOpenHelper {

    private static final int DATABASE_VERSION = 1 ;
    private static final String DATABASE_NAME = "restroquickpos";
    public static final String TABLE_NAME ="Login";
    public static final String COL_ID ="ID";
    public static final String COL_NAME ="username";
    public static final String COL_PASSWORD ="password";
    public static final String COL_STATUS = "status";



    public static final String TABLE_NAME1 ="CategoryMaster";
    public static final String COL_CATID ="Cat_ID";
    public static final String COL_CATNAME ="cat_name";
    public static final String COL_CATDESC ="cat_desc";
    public static final String COL_CATKOT = "cat_kot";


    public SQLiteDatabase DB;

    public static final String TABLE_MENU ="MenuMaster";
    public static final String COL_MENUID ="menu_ID";
    public static final String COL_MENUNAME ="menu_name";
    public static final String COL_MENUINT ="menu_int";
    public static final String COL_MENURATE = "menu_rate";
    public static final String COL_MENUREMARK ="menu_Remark";
    public static final String COL_MENUCAT ="menu_cat";
    public static final String COL_MENUQTY ="menu_qty";




    public MySQLiteDatabase(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, DATABASE_NAME, factory, DATABASE_VERSION);
        Log.d("DatabaseOperation","Database Created");
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        this.DB = db ;
        String loginquery = "CREATE TABLE " + TABLE_NAME + " ("
                + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + COL_NAME + " TEXT NOT NULL, "
                + COL_PASSWORD + " TEXT NOT NULL, "
                + COL_STATUS + " TEXT "
                + ");";
        db.execSQL(loginquery);
        Log.d("DatabaseOperation","Table Created");

        String catquery = "CREATE TABLE " + TABLE_NAME1 + " ("
                + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + COL_CATID + " TEXT NOT NULL, "
                + COL_CATNAME + " TEXT NOT NULL, "
                + COL_CATDESC + " TEXT NOT NULL, "
                + COL_CATKOT + " TEXT NOT NULL "
                + ");";
        db.execSQL(catquery);
        Log.d("DatabaseOperation","Table Created");

        String Menuquery = "CREATE TABLE " + TABLE_MENU + " ("
                + COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + COL_MENUID + " TEXT NOT NULL, "
                + COL_MENUNAME + " TEXT NOT NULL, "
                + COL_MENUINT + " TEXT NOT NULL, "
                + COL_MENURATE + " TEXT NOT NULL, "
                + COL_MENUREMARK + " TEXT NOT NULL, "
                + COL_MENUCAT + " TEXT NOT NULL, "
                + COL_MENUQTY + " INTEGER NOT NULL "
                + ");";
        db.execSQL(Menuquery);
        Log.d("DatabaseOperation","Table Created");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

        this.DB = db ;
        db.execSQL(" DROP TABLE IF EXISTS " + TABLE_NAME);//drop tabel command
        onCreate(db);//execute query
    }
    public void addDetails(GetandSet details)//Adding into Login
    {
        ContentValues values = new ContentValues();
        values.put(COL_NAME,details.get_name());
        values.put(COL_PASSWORD,details.get_passwrod());
        values.put(COL_STATUS,details.get_status());

        SQLiteDatabase db = getWritableDatabase();
        db.insert(TABLE_NAME,null,values);
        Log.d("DatabaseOperation","Values Inserted");
        db.close();
    }

    public void addCategory(GetandSet details)//Adding into Category
    {
        ContentValues values = new ContentValues();
        values.put(COL_CATID,details.getCat_id());
        values.put(COL_CATNAME,details.getCat_name());
        values.put(COL_CATDESC,details.getCat_desc());
        values.put(COL_CATKOT,details.getCat_kot());

        SQLiteDatabase db = getWritableDatabase();
        db.insert(TABLE_NAME1,null,values);
        Log.d("DatabaseOperation","Values Inserted");
        db.close();
    }

    public void addMenuItems(GetandSet details)//Adding into Menu Items
    {
        ContentValues values = new ContentValues();
        values.put(COL_MENUID,details.getMenu_ID());
        values.put(COL_MENUNAME,details.getMenu_name());
        values.put(COL_MENUINT,details.getMenu_int());
        values.put(COL_MENURATE,details.getMenu_rate());
        values.put(COL_MENUREMARK,details.getMenu_Remark());
        values.put(COL_MENUCAT,details.getMenu_cat());
        values.put(COL_MENUQTY,1);

        SQLiteDatabase db = getWritableDatabase();
        db.insert(TABLE_MENU,null,values);
        Log.d("DatabaseOperation","Values Inserted");
        db.close();
    }


    public String searchPass(String userid) {

        DB = this.getReadableDatabase();
        String query = "SELECT * FROM " + TABLE_NAME ;
        Cursor cursor = DB.rawQuery(query,null);

        String Username, password,fullname;
        password = "Not Found";

        if(cursor.moveToNext())
        {
            do {
                // Username = cursor.getString(2);
                fullname = cursor.getString(1);
                /*if(Username.equals(userid))
                {
                    password = cursor.getString(4);
                    break;
                }*/
                if(fullname.equals(userid))
                {
                    password = cursor.getString(2);
                    break;
                }
            }while (cursor.moveToNext());
        }
        return password;
    }

    public List<String> getAllLabels(){
        List<String> labels = new ArrayList<String>();

        // Select All Query
        String selectQuery = "SELECT  * FROM " + TABLE_NAME1;

        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);

        // looping through all rows and adding to list
        if (cursor.moveToFirst()) {
            do {
                labels.add(cursor.getString(2));
            } while (cursor.moveToNext());
        }

        // closing connection
        cursor.close();
        db.close();
        // returning lables
        return labels;
    }
    public Cursor selectQuery(String query) {
           Cursor c1 ;
           DB = getWritableDatabase();
           c1 = DB.rawQuery(query, null);
           return c1;
    }

}