315H28S1

1package project.asyraf.sar;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.sqlite.SQLiteDatabase;
7import android.database.sqlite.SQLiteOpenHelper;
8
9public class DBHandler extends SQLiteOpenHelper {
10
11public static final String DATABASE_NAME = "kypsarv2.db";
12public static final int DATABASE_VERSION = 1;
13
14public DBHandler(Context context) {
15    super(context, DATABASE_NAME, null, DATABASE_VERSION);
16}
17
18@Override
19public void onCreate(SQLiteDatabase db) {
20
21    String createTableLoginInfo = "CREATE TABLE loginInfo (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT, password TEXT, accesslevel TEXT, owner TEXT);";
22    db.execSQL(createTableLoginInfo);
23    String createTableAdmin = "CREATE TABLE admin (id INTEGER PRIMARY KEY AUTOINCREMENT, adminName TEXT, adminIC);";
24    db.execSQL(createTableAdmin);
25    String createTableLect = "CREATE TABLE lecturer (id INTEGER PRIMARY KEY AUTOINCREMENT, lecturerName TEXT, lecturerIC);";
26    db.execSQL(createTableLect);
27    String createTableStud = "CREATE TABLE student (id INTEGER PRIMARY KEY AUTOINCREMENT, studentName TEXT, studentIC);";
28    db.execSQL(createTableStud);
29    String createTableReminder = "CREATE TABLE reminder (id INTEGER PRIMARY KEY AUTOINCREMENT, subject TEXT, activity TEXT, startDate DATE, endDate DATE, description TEXT, owner TEXT);";
30    db.execSQL(createTableReminder);
31}
32
33@Override
34public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
35
36    db.execSQL("DROP TABLE IF EXISTS loginInfo");
37    db.execSQL("DROP TABLE IF EXISTS admin");
38    db.execSQL("DROP TABLE IF EXISTS lecturer");
39    db.execSQL("DROP TABLE IF EXISTS student");
40    db.execSQL("DROP TABLE IF EXISTS reminder");
41
42    onCreate(db);
43}
44
45public void getLoginInfo (String username, String password)
46{
47    Cursor cursor = this.getReadableDatabase().rawQuery("SELECT * FROM loginInfo WHERE username = ? AND password = ?", new String[] {username, password});
48    cursor.moveToFirst();
49
50    accessLevel = cursor.getString(3);
51    owner = cursor.getString(4);
52
53    cursor.close();
54}
55	
56package project.asyraf.sar;
57
58import android.content.Intent;
59import android.database.Cursor;
60import android.support.v7.app.AlertDialog;
61import android.support.v7.app.AppCompatActivity;
62import android.os.Bundle;
63import android.view.View;
64import android.widget.EditText;
65import android.widget.Toast;
66
67public class LoginMenu extends AppCompatActivity {
68
69DBHandler useDB = new DBHandler(this);
70
71@Override
72protected void onCreate(Bundle savedInstanceState) {
73    super.onCreate(savedInstanceState);
74    setContentView(R.layout.activity_login_menu);
75}
76
77public void closeApps (View view){
78    finish();
79}
80
81public void loginTrial (View view) {
82
83    final EditText getUsername = (EditText) findViewById(R.id.username);
84    final EditText getPassword = (EditText) findViewById(R.id.password);
85
86    String textUsername, textPassword = "";
87
88    textUsername = getUsername.getText().toString();
89    textPassword = getPassword.getText().toString();
90
91    Intent loginSuccessLecturer = new Intent (this, LecturerDashboard.class);
92    Intent loginSuccessStudent = new Intent (this, StudentDashboard.class);
93    Intent loginSuccessAdmin = new Intent (this, AdminDashboard.class);
94
95    //Cursor getLogin = useDB.getLoginData(textUsername, textPassword);
96
97    useDB.getLoginInfo(textUsername, textPassword);
98
99    String owner = "";
100    String accessLevel = "";
101    owner = useDB.owner;
102    accessLevel = useDB.accessLevel;
103
104    StringBuffer buffer = new StringBuffer();
105
106    if (textUsername.equals("") || textPassword.equals(""))
107    {
108        Toast.makeText(getApplicationContext(), "Enter Username or Password", Toast.LENGTH_SHORT).show();
109    }
110    else if (textUsername.equals("admin") && textPassword.equals("admin"))
111    {
112        startActivity(loginSuccessAdmin);
113    }
114    else
115    {
116        if (owner.equals(""))
117        {
118            Toast.makeText(getApplicationContext(), "User do not exist", Toast.LENGTH_SHORT).show();
119        }
120        else
121        {
122            if (accessLevel.equals("student"))
123            {
124                startActivity(loginSuccessStudent);
125            }
126            else if (accessLevel.equals("lecturer"))
127            {
128                startActivity(loginSuccessLecturer);
129            }
130        }
131    }
132
133    /*
134    if (owner.equals(""))
135    {
136        Toast.makeText(getApplicationContext(), "No Data", Toast.LENGTH_SHORT).show();
137    }
138    else
139    {
140        //showMessage("Data",buffer.toString());
141        if (!owner.equals("") && accessLevel.equals("student"))
142        {
143            startActivity(loginSuccessAdmin);
144        }
145        else
146            Toast.makeText(getApplicationContext(), "Login Error, Please Login Again", Toast.LENGTH_SHORT).show();
147
148        if (textUsername.equals(usernameInfo) && textPassword.equals(passwordInfo))
149        {
150            if (accessInfo.equals("admin"))
151            {
152                //startActivity(loginSuccessAdmin);
153            }
154            else if (accessInfo.equals("student"))
155            {
156                Toast.makeText(getApplicationContext(), "Login to Student", Toast.LENGTH_SHORT).show();
157                //startActivity(loginSuccessStudent);
158            }
159            else if (accessInfo.equals("lecturer"))
160            {
161                //startActivity(loginSuccessLecturer);
162            }
163            else
164                Toast.makeText(getApplicationContext(), "Access Error, Please Login Again", Toast.LENGTH_SHORT).show();
165        }
166        else
167        {
168            Toast.makeText(getApplicationContext(), "Login Error, Please Login Again", Toast.LENGTH_SHORT).show();
169        }
170    }*/
171}
172}