Y4GbBUR0

1//Cjpдание нового студента
2
3protected void onCreate(Bundle savedInstanceState) {
4        super.onCreate(savedInstanceState);
5        setContentView(R.layout.activity_student__registartion);
6
7        spinner = (Spinner) findViewById(R.id.spinner);
8        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_spinner_dropdown_item, AppBase.divisions);
9        spinner.setAdapter(adapter);
10
11        Button btn = (Button) findViewById(R.id.buttonSAVE);
12        assert btn != null;
13        btn.setOnClickListener(new View.OnClickListener() {
14            @Override
15            public void onClick(View v) {
16                saveToDatabase(v);
17            }
18        });
19    }
20
21//===============================================
22//работа с расписанием
23    public boolean onItemLongClick(AdapterView<?> parent, View view, final int position, long id) {
24        AlertDialog.Builder alert = new AlertDialog.Builder(activity);
25        alert.setTitle("Delete Schedule?");
26        alert.setMessage("Do you want to delete this schedule ?");
27
28        alert.setPositiveButton("YES", new DialogInterface.OnClickListener() {
29            @Override
30            public void onClick(DialogInterface dialog, int which) {
31                String qu = "DELETE FROM SCHEDULE WHERE subject = '" + subx.get(position) + "' AND timex = '" + times.get(position) + "'";
32                if (AppBase.handler.execAction(qu)) {
33                    Toast.makeText(getBaseContext(), "Deleted", Toast.LENGTH_LONG).show();
34                    loadSchedules();
35                } else {
36                    Toast.makeText(getBaseContext(), "Failed", Toast.LENGTH_LONG).show();
37                    loadSchedules();
38                }
39                dialog.dismiss();
40            }
41        });
42        alert.setNegativeButton("NO", new DialogInterface.OnClickListener() {
43            @Override
44            public void onClick(DialogInterface dialog, int which) {
45                dialog.dismiss();
46            }
47        });
48        alert.show();
49        return true;
50    }
51
52
53//==========================================================
54//загрузка заметок
55 private void loadNotes() {
56        titles.clear();
57        contents.clear();
58        String qu = "SELECT * FROM NOTES";
59        Cursor cursor = AppBase.handler.execQuery(qu);
60        if (cursor == null || cursor.getCount() == 0) {
61            Toast.makeText(getBaseContext(), "No Notes Found", Toast.LENGTH_LONG).show();
62        } else {
63            cursor.moveToFirst();
64            while (!cursor.isAfterLast()) {
65                titles.add(cursor.getString(0));
66                contents.add(cursor.getString(1));
67                cursor.moveToNext();
68            }
69            adapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, titles);
70            listView.setAdapter(adapter);
71        }
72    }
73
74//=========================================
75// создание БД и пример создания табли
76
77    private SQLiteDatabase database;
78
79    public DatabaseHandler(Activity activity) {
80        this.activity = activity;
81        database = activity.openOrCreateDatabase("ASSIST", activity.MODE_PRIVATE, null);
82        createTable();
83    }
84
85    public void createTable() {
86        try {
87            String qu = "CREATE TABLE IF NOT EXISTS STUDENT(name varchar(1000)," +
88                    "cl varchar(100), " +
89                    "regno varchar(100) primary key, contact varchar(100),roll integer);";
90            database.execSQL(qu);
91        } catch (Exception e) {
92            Toast.makeText(activity, "Error Occured for create table", Toast.LENGTH_LONG).show();
93        }
94//==============
95// подсчет среднего бала
96                cg = ((sg1 * g1) + (sg2 * g2) + (sg3 * g3) + (sg4 * g4) + (sg5 * g5) + (sg6 * g6) + (sg7 * g7)) / (g1 + g2 + g3 + g4 + g5 + g6 + g7);
97                if (sg1 == 0 && sg2 == 0 && sg3 == 0 && sg4 == 0 && sg5 == 0 && sg6 == 0 && sg7 == 0)
98                    Toast.makeText(getApplicationContext(), "Insufficient Data ", Toast.LENGTH_LONG).show();
99
100
101//изменение профиля
102protected void onCreate(Bundle savedInstanceState) {
103        super.onCreate(savedInstanceState);
104        setContentView(R.layout.activity_edit__student);
105
106        Button loadButton = (Button) findViewById(R.id.loadForEdit);
107        assert loadButton != null;
108        loadButton.setOnClickListener(new View.OnClickListener() {
109            @Override
110            public void onClick(View v) {
111                EditText adm = (EditText) findViewById(R.id.register_);
112                String qu = "SELECT * FROM STUDENT WHERE regno = '" + adm.getText().toString().toUpperCase() + "'";
113                Cursor cr = AppBase.handler.execQuery(qu);
114                if (cr == null || cr.getCount() == 0) {
115                    Toast.makeText(getBaseContext(), "No Such Student", Toast.LENGTH_LONG).show();
116                } else {
117                    cr.moveToFirst();
118                    try {
119                        EditText name = (EditText) findViewById(R.id.edit_name_);
120                        EditText roll = (EditText) findViewById(R.id.roll_);
121                        EditText contact = (EditText) findViewById(R.id.contact_);
122                        assert name != null;
123                        name.setText(cr.getString(0));
124                        assert roll != null;
125                        roll.setText(cr.getString(4));
126                        assert contact != null;
127                        contact.setText(cr.getString(3));
128                    } catch (Exception e) {
129                    }
130                }
131            }
132        });
133
134
135        Button saveEdit = (Button) findViewById(R.id.buttonSAVEEDITS);
136        assert saveEdit != null;
137        saveEdit.setOnClickListener(new View.OnClickListener() {
138            @Override
139            public void onClick(View v) {
140                EditText name = (EditText) findViewById(R.id.edit_name_);
141                EditText roll = (EditText) findViewById(R.id.roll_);
142                EditText contact = (EditText) findViewById(R.id.contact_);
143                EditText adm = (EditText) findViewById(R.id.register_);
144
145                String qu = "UPDATE STUDENT SET name = '" + name.getText().toString() + "' , " +
146                        " roll = " + roll.getText().toString() + " , contact = '" + contact.getText().toString() + "' " +
147                        "WHERE regno = '" + adm.getText().toString().toUpperCase() + "'";
148                Log.d("EditStudentActivity", qu);
149                if (AppBase.handler.execAction(qu)) {
150                    Toast.makeText(getBaseContext(), "Edit Saved", Toast.LENGTH_LONG).show();
151                    activity.finish();
152
153                } else
154                    Toast.makeText(getBaseContext(), "Error Occured", Toast.LENGTH_LONG).show();
155
156            }
157        });
158    }