package com.example.dell.foodcourt;


    import android.content.ContentValues;
    import android.content.Context;
    import android.database.Cursor;
    import android.database.SQLException;
    import android.database.sqlite.SQLiteDatabase;
    import android.database.sqlite.SQLiteOpenHelper;
    import android.sax.StartElementListener;
    import android.widget.Toast;

    public class FoodCourt_UserLoginDatabase{
        Context context;
        FoodCourt_LoginData foodCourt_loginData;
        SQLiteDatabase db;

        public FoodCourt_UserLoginDatabase(Context context){
            foodCourt_loginData=new FoodCourt_LoginData(context);
        }

SQLiteDatabase db = foodCourt_loginData.getWritableDatabase();
                    ContentValues contentValues = new ContentValues();
                    contentValues.put(FoodCourt_LoginData.USERNAME, username);
                    contentValues.put(FoodCourt_LoginData.USERPWD, userpwd);
                    contentValues.put(FoodCourt_LoginData.USERMOBILE, usermble);
                    db.insertWithOnConflict(FoodCourt_LoginData.TABLENAME, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE);
        }

        public String viewData(){

            SQLiteDatabase db=foodCourt_loginData.getWritableDatabase(); //calling database to get writable data
            String[] cloumn={FoodCourt_LoginData.ID,FoodCourt_LoginData.USERNAME,FoodCourt_LoginData.USERPWD};  //stroing all the values in String array
            //Cursor is used to call the Stored data in Database and it starts data reading from row1 and moveToNext will call from upto end of data
            Cursor cursor=db.query(FoodCourt_LoginData.TABLENAME,cloumn,null,null,null,null,null);
            StringBuffer Buffer=new StringBuffer();
            while(cursor.moveToNext()){
                int cid=cursor.getInt(0);
                String Name=cursor.getString(1);
                String Password=cursor.getString(2);
                Buffer.append(cid+" "+Name+" "+Password+" "+"n");
            }
            return Buffer.toString();
        }

        public String Login(String Uname){
            SQLiteDatabase db=foodCourt_loginData.getReadableDatabase();
            String[] column={FoodCourt_LoginData.USERNAME,FoodCourt_LoginData.USERPWD};
            Cursor cursor=db.query(FoodCourt_LoginData.TABLENAME,column,null,null,null,null,null);
            String a,b;
            b="not found";
            if(cursor.moveToFirst()){
                do {
                    a=cursor.getString(0);
                    b=cursor.getString(1);
                    if(a.equals(Uname)){
                        b=cursor.getString(1);
                        break;
                    }
                }while (cursor.moveToNext());

            }
            return b;
        }

        static class FoodCourt_LoginData extends SQLiteOpenHelper {
            private static final String DATABASE_NAME = "FOODCOURT_LOGINDATABASE.sqlite";
            private static final String TABLENAME = "FOODCOURT_LOGIN";
            private static final String ID = "id";
            private static final String USERNAME = "UserNAME";
            private static final String USERPWD = "UserPwd";
            private static final String USERADDRESS = "Address";
            private static final String USERMOBILE = "Mobile";
            private static final String USEREMAIL = "Email";
            private static final int DATABASE_VERSION=4;
            SQLiteDatabase db;
            private Context context;
            private static final String CreateTable = "CREATE TABLE IF NOT EXISTS "+TABLENAME+" ("+ID+" INTEGER PRIMARY KEY,"+ USERNAME + " VARCHAR(255) NOT NULL UNIQUE," + USERPWD + " VARCHAR(255)," + USERADDRESS + " VARCHAR(300)," + USERMOBILE + " INTEGER(10)," + USEREMAIL + " VARCHAR(30))";
            private static final String DropTable="DROP TABLE IF EXISTS '"+TABLENAME+"'";
            public FoodCourt_LoginData(Context context){
                super(context,DATABASE_NAME,null,DATABASE_VERSION);
                this.context=context;
            }
            @Override
            public void onCreate(SQLiteDatabase db) {
                try{
                    db.execSQL(CreateTable);
                    this.db=db;
                }catch (SQLException e){
                    Message.message(context," "+e);
                }

            }

            @Override
            public void onUpgrade(SQLiteDatabase db, int i, int i1) {
                try {
                    db.execSQL(DropTable);
                    onCreate(db);
                }catch (SQLException e){
                    Message.message(context," "+e);
                }
            }
        }

    }