private void fetchALertData() {
try {
DatabaseHandler handler = new DatabaseHandler(DetailedDisplayActivity.this);
handler.openDataBase();
Cursor alertCusrosr = handler.getAlert();
// Fetching ALerts
alertCusrosr.moveToFirst();
alertData = new ArrayList<>();
if (alertCusrosr != null) {
do {
AlertData2 alert = new AlertData2();
alert.alertTransId =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("alertTransId"));
alert.sender_name =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("sender_name"));
alert.sender_round_photo =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("sender_round_photo"));
alert.sender_designation =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("sender_designation"));
alert.sent_date = alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("sent_date"));
alert.alertText = alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("alertText"));
alert.attachmentCount =
alertCusrosr.getInt(alertCusrosr.getColumnIndexOrThrow("attachmentCount"));
alert.attachments =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("attachments"));
alert.isNew = alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("isNew"));
alert.staffId = alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("staffID"));
alertData.add(alert);
} while (alertCusrosr.moveToNext());
}
handler.close();
} catch (Exception e) {
Log.e("%%% Exc", e.toString());
}
dat = new ArrayList<>();
fragmentdat2 = new ArrayList<>();
if (alertData == null) {
try {
DatabaseHandler handler = new DatabaseHandler(DetailedDisplayActivity.this);
handler.openDataBase();
Cursor alertCusrosr = handler.getAlert();
// Fetching ALerts
alertCusrosr.moveToFirst();
alertData = new ArrayList<>();
if (alertCusrosr != null) {
do {
AlertData2 alert = new AlertData2();
alert.alertTransId =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("alertTransId"));
alert.sender_name =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("sender_name"));
alert.sender_round_photo =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("sender_round_photo"));
alert.isNew = alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("isNew"));
alert.sender_designation =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("sender_designation"));
alert.sent_date =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("sent_date"));
alert.alertText =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("alertText"));
alert.attachmentCount =
alertCusrosr.getInt(alertCusrosr.getColumnIndexOrThrow("attachmentCount"));
alert.attachments =
alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("attachments"));
alert.staffId = alertCusrosr.getString(alertCusrosr.getColumnIndexOrThrow("staffID"));
alertData.add(alert);
} while (alertCusrosr.moveToNext());
}
handler.close();
for (int i = 0; i < alertData.size(); i++) {
InstituteData fr1 = new InstituteData();
InstituteData2 InstituteData2 = new InstituteData2();
InstituteData2.setType(0);
InstituteData2.setData(
alertData.get(i).staffId,
"",
"",
"",
"",
"",
alertData.get(i).sender_name,
alertData.get(i).sender_round_photo,
alertData.get(i).sender_designation,
alertData.get(i).sent_date,
"",
"",
alertData.get(i).attachmentCount,
alertData.get(i).attachments,
alertData.get(i).isNew,
alertData.get(i).alertTransId,
alertData.get(i).alertText);
fragmentdat2.add(InstituteData2);
fr1.setAlerts(alertData.get(i));
fr1.setType(0);
dat.add(fr1);
handler.close();
}
} catch (Exception e) {
}
} else {
for (int i = 0; i < alertData.size(); i++) {
InstituteData fr1 = new InstituteData();
fr1.setAlerts(alertData.get(i));
fr1.setType(0);
dat.add(fr1);
InstituteData2 InstituteData2 = new InstituteData2();
InstituteData2.setType(0);
InstituteData2.setData(
alertData.get(i).staffId,
"",
"",
"",
"",
"",
alertData.get(i).sender_name,
alertData.get(i).sender_round_photo,
alertData.get(i).sender_designation,
alertData.get(i).sent_date,
"",
"",
alertData.get(i).attachmentCount,
alertData.get(i).attachments,
alertData.get(i).isNew,
alertData.get(i).alertTransId,
alertData.get(i).alertText);
fragmentdat2.add(InstituteData2);
}
}
}
