DatabaseHandlerofQuiz.smali

.class public Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;
.super Landroid/database/sqlite/SQLiteOpenHelper;
.source "DatabaseHandlerofQuiz.java"


# static fields
.field private static final DATABASE_NAME:Ljava/lang/String; = "quizIdManager"

.field private static final DATABASE_VERSION:I = 0x1

.field private static final KEY_HAS_SUB_CHAPTER:Ljava/lang/String; = "hasSubChapter"

.field private static final KEY_ID:Ljava/lang/String; = "id"

.field private static final KEY_NAME_ANSWER:Ljava/lang/String; = "answer"

.field private static final KEY_NAME_CHAPTER:Ljava/lang/String; = "chapterId"

.field private static final KEY_NAME_QUIZ_ID:Ljava/lang/String; = "quizId"

.field private static final KEY_NAME_QUIZ_QUESTION_ID:Ljava/lang/String; = "queId"

.field private static final KEY_QUIZ_PAGE_NO:Ljava/lang/String; = "quizPageNo"

.field private static final TABLE_CONTACTS:Ljava/lang/String; = "quizdetails"


# instance fields
.field contact:Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;


# direct methods
.method public constructor <init>(Landroid/content/Context;)V
    .registers 5
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "context"
        }
    .end annotation

    const-string v0, "quizIdManager"

    const/4 v1, 0x0

    const/4 v2, 0x1

    .line 32
    invoke-direct {p0, p1, v0, v1, v2}, Landroid/database/sqlite/SQLiteOpenHelper;-><init>(Landroid/content/Context;Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)V

    return-void
.end method


# virtual methods
.method public addQuizQues(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
    .registers 10
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0,
            0x0,
            0x0,
            0x0,
            0x0,
            0x0
        }
        names = {
            "quizId",
            "chapterID",
            "quesID",
            "quesPageNo",
            "answer",
            "subChapterId"
        }
    .end annotation

    .line 57
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getWritableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    .line 59
    new-instance v1, Landroid/content/ContentValues;

    invoke-direct {v1}, Landroid/content/ContentValues;-><init>()V

    const-string v2, "quizId"

    .line 60
    invoke-virtual {v1, v2, p1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    const-string p1, "queId"

    .line 61
    invoke-virtual {v1, p1, p3}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    const-string p1, "chapterId"

    .line 62
    invoke-virtual {v1, p1, p2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    const-string p1, "quizPageNo"

    .line 63
    invoke-virtual {v1, p1, p4}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    const-string p1, "answer"

    .line 64
    invoke-virtual {v1, p1, p5}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    const-string p1, "hasSubChapter"

    .line 65
    invoke-virtual {v1, p1, p6}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    const-string p1, "quizdetails"

    const/4 p2, 0x0

    .line 67
    invoke-virtual {v0, p1, p2, v1}, Landroid/database/sqlite/SQLiteDatabase;->insert(Ljava/lang/String;Ljava/lang/String;Landroid/content/ContentValues;)J

    .line 70
    invoke-virtual {v0}, Landroid/database/sqlite/SQLiteDatabase;->close()V

    return-void
.end method

.method public deleteContact(Lcom/yctpublication/mastes/common/storevalue/BookIdModel;)V
    .registers 5
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "contact"
        }
    .end annotation

    .line 227
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getWritableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const/4 v1, 0x1

    new-array v1, v1, [Ljava/lang/String;

    .line 229
    invoke-virtual {p1}, Lcom/yctpublication/mastes/common/storevalue/BookIdModel;->getId()I

    move-result p1

    invoke-static {p1}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p1

    const/4 v2, 0x0

    aput-object p1, v1, v2

    const-string p1, "quizdetails"

    const-string v2, "id = ?"

    .line 228
    invoke-virtual {v0, p1, v2, v1}, Landroid/database/sqlite/SQLiteDatabase;->delete(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)I

    .line 230
    invoke-virtual {v0}, Landroid/database/sqlite/SQLiteDatabase;->close()V

    return-void
.end method

.method public deleteCourse(Ljava/lang/String;)Z
    .registers 10
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "courseName"
        }
    .end annotation

    .line 258
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getWritableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const/4 v1, 0x1

    new-array v2, v1, [Ljava/lang/String;

    const/4 v3, 0x0

    aput-object p1, v2, v3

    const-string v4, "Select * FROM quizdetails WHERE chapterId = ?"

    .line 259
    invoke-virtual {v0, v4, v2}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v2

    .line 261
    invoke-interface {v2}, Landroid/database/Cursor;->getCount()I

    move-result v2

    if-lez v2, :cond_2b

    new-array v2, v1, [Ljava/lang/String;

    aput-object p1, v2, v3

    const-string p1, "quizdetails"

    const-string v4, "chapterId=?"

    .line 262
    invoke-virtual {v0, p1, v4, v2}, Landroid/database/sqlite/SQLiteDatabase;->delete(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)I

    move-result p1

    int-to-long v4, p1

    const-wide/16 v6, -0x1

    cmp-long p1, v4, v6

    if-nez p1, :cond_2a

    return v3

    :cond_2a
    return v1

    :cond_2b
    return v3
.end method

.method public deleteSubChapterId(Ljava/lang/String;)Z
    .registers 10
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "subChapterId"
        }
    .end annotation

    .line 277
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getWritableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const/4 v1, 0x1

    new-array v2, v1, [Ljava/lang/String;

    const/4 v3, 0x0

    aput-object p1, v2, v3

    const-string v4, "Select * FROM quizdetails WHERE hasSubChapter = ?"

    .line 278
    invoke-virtual {v0, v4, v2}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v2

    .line 280
    invoke-interface {v2}, Landroid/database/Cursor;->getCount()I

    move-result v2

    if-lez v2, :cond_2b

    new-array v2, v1, [Ljava/lang/String;

    aput-object p1, v2, v3

    const-string p1, "quizdetails"

    const-string v4, "hasSubChapter=?"

    .line 281
    invoke-virtual {v0, p1, v4, v2}, Landroid/database/sqlite/SQLiteDatabase;->delete(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)I

    move-result p1

    int-to-long v4, p1

    const-wide/16 v6, -0x1

    cmp-long p1, v4, v6

    if-nez p1, :cond_2a

    return v3

    :cond_2a
    return v1

    :cond_2b
    return v3
.end method

.method public findTask(Ljava/lang/String;)Landroid/database/Cursor;
    .registers 5
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "taskName"
        }
    .end annotation

    .line 246
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getWritableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    .line 247
    new-instance v1, Ljava/lang/StringBuilder;

    invoke-direct {v1}, Ljava/lang/StringBuilder;-><init>()V

    const-string v2, "SELECT id FROM quizdetails WHERE quizId = \'"

    invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v1

    invoke-virtual {v1, p1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object p1

    const-string v1, "\'"

    invoke-virtual {p1, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object p1

    invoke-virtual {p1}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object p1

    const/4 v1, 0x0

    .line 249
    invoke-virtual {v0, p1, v1}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1

    return-object p1
.end method

.method public getAllBooks()Ljava/util/List;
    .registers 6
    .annotation system Ldalvik/annotation/Signature;
        value = {
            "()",
            "Ljava/util/List<",
            "Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;",
            ">;"
        }
    .end annotation

    .line 186
    new-instance v0, Ljava/util/ArrayList;

    invoke-direct {v0}, Ljava/util/ArrayList;-><init>()V

    .line 190
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getWritableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v1

    const-string v2, "SELECT  * FROM quizdetails"

    const/4 v3, 0x0

    .line 191
    invoke-virtual {v1, v2, v3}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v1

    .line 194
    invoke-interface {v1}, Landroid/database/Cursor;->moveToFirst()Z

    move-result v2

    if-eqz v2, :cond_4f

    .line 196
    :cond_16
    new-instance v2, Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;

    invoke-direct {v2}, Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;-><init>()V

    const/4 v3, 0x0

    .line 197
    invoke-interface {v1, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v3

    invoke-static {v3}, Ljava/lang/Integer;->parseInt(Ljava/lang/String;)I

    move-result v3

    invoke-virtual {v2, v3}, Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;->setId(I)V

    const/4 v3, 0x1

    .line 198
    invoke-interface {v1, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v3

    invoke-virtual {v2, v3}, Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;->setQuizId(Ljava/lang/String;)V

    const/4 v3, 0x2

    .line 199
    invoke-interface {v1, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v3

    invoke-virtual {v2, v3}, Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;->setChapterId(Ljava/lang/String;)V

    const/4 v3, 0x3

    .line 200
    invoke-interface {v1, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v4

    invoke-virtual {v2, v4}, Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;->setQuizPageNo(Ljava/lang/String;)V

    .line 201
    invoke-interface {v1, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v3

    invoke-virtual {v2, v3}, Lcom/yctpublication/mastes/common/storevalue/QuizIdModel;->setHasSubChapter(Ljava/lang/String;)V

    .line 203
    invoke-interface {v0, v2}, Ljava/util/List;->add(Ljava/lang/Object;)Z

    .line 204
    invoke-interface {v1}, Landroid/database/Cursor;->moveToNext()Z

    move-result v2

    if-nez v2, :cond_16

    :cond_4f
    return-object v0
.end method

.method public getContactsCount()I
    .registers 4

    .line 236
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getReadableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const-string v1, "SELECT  * FROM quizdetails"

    const/4 v2, 0x0

    .line 237
    invoke-virtual {v0, v1, v2}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v0

    .line 238
    invoke-interface {v0}, Landroid/database/Cursor;->close()V

    .line 241
    invoke-interface {v0}, Landroid/database/Cursor;->getCount()I

    move-result v0

    return v0
.end method

.method public getLastChapter(Ljava/lang/String;)Ljava/lang/String;
    .registers 11
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "quizID"
        }
    .end annotation

    .line 112
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getReadableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const-string v1, "id"

    const-string v2, "quizId"

    const-string v3, "chapterId"

    const-string v4, "quizPageNo"

    const-string v5, "queId"

    const-string v6, "answer"

    const-string v7, "hasSubChapter"

    .line 114
    filled-new-array/range {v1 .. v7}, [Ljava/lang/String;

    move-result-object v2

    const/4 v1, 0x1

    new-array v4, v1, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p1, v4, v1

    const-string v1, "quizdetails"

    const-string v3, "quizId=?"

    const/4 v5, 0x0

    const/4 v6, 0x0

    const/4 v7, 0x0

    const/4 v8, 0x0

    invoke-virtual/range {v0 .. v8}, Landroid/database/sqlite/SQLiteDatabase;->query(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1

    .line 119
    invoke-interface {p1}, Landroid/database/Cursor;->getCount()I

    move-result v0

    if-lez v0, :cond_37

    .line 120
    invoke-interface {p1}, Landroid/database/Cursor;->moveToLast()Z

    const/4 v0, 0x2

    .line 121
    invoke-interface {p1, v0}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object p1

    return-object p1

    .line 123
    :cond_37
    invoke-interface {p1}, Landroid/database/Cursor;->close()V

    const/4 p1, 0x0

    return-object p1
.end method

.method public getLastPageSave(Ljava/lang/String;)Ljava/lang/String;
    .registers 11
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "chapterID"
        }
    .end annotation

    .line 148
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getReadableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const-string v1, "id"

    const-string v2, "quizId"

    const-string v3, "chapterId"

    const-string v4, "quizPageNo"

    const-string v5, "queId"

    const-string v6, "answer"

    const-string v7, "hasSubChapter"

    .line 150
    filled-new-array/range {v1 .. v7}, [Ljava/lang/String;

    move-result-object v2

    const/4 v1, 0x1

    new-array v4, v1, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p1, v4, v1

    const-string v1, "quizdetails"

    const-string v3, "chapterId=?"

    const/4 v5, 0x0

    const/4 v6, 0x0

    const/4 v7, 0x0

    const/4 v8, 0x0

    invoke-virtual/range {v0 .. v8}, Landroid/database/sqlite/SQLiteDatabase;->query(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1

    .line 155
    invoke-interface {p1}, Landroid/database/Cursor;->getCount()I

    move-result v0

    if-lez v0, :cond_37

    .line 156
    invoke-interface {p1}, Landroid/database/Cursor;->moveToLast()Z

    const/4 v0, 0x3

    .line 157
    invoke-interface {p1, v0}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object p1

    return-object p1

    .line 159
    :cond_37
    invoke-interface {p1}, Landroid/database/Cursor;->close()V

    const/4 p1, 0x0

    return-object p1
.end method

.method public getLastPageSaveSubChapter(Ljava/lang/String;)Ljava/lang/String;
    .registers 11
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "subChapterID"
        }
    .end annotation

    .line 166
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getReadableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const-string v1, "id"

    const-string v2, "quizId"

    const-string v3, "chapterId"

    const-string v4, "quizPageNo"

    const-string v5, "queId"

    const-string v6, "answer"

    const-string v7, "hasSubChapter"

    .line 168
    filled-new-array/range {v1 .. v7}, [Ljava/lang/String;

    move-result-object v2

    const/4 v1, 0x1

    new-array v4, v1, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p1, v4, v1

    const-string v1, "quizdetails"

    const-string v3, "hasSubChapter=?"

    const/4 v5, 0x0

    const/4 v6, 0x0

    const/4 v7, 0x0

    const/4 v8, 0x0

    invoke-virtual/range {v0 .. v8}, Landroid/database/sqlite/SQLiteDatabase;->query(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1

    .line 173
    invoke-interface {p1}, Landroid/database/Cursor;->getCount()I

    move-result v0

    if-lez v0, :cond_37

    .line 174
    invoke-interface {p1}, Landroid/database/Cursor;->moveToLast()Z

    const/4 v0, 0x3

    .line 175
    invoke-interface {p1, v0}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object p1

    return-object p1

    .line 177
    :cond_37
    invoke-interface {p1}, Landroid/database/Cursor;->close()V

    const/4 p1, 0x0

    return-object p1
.end method

.method public getLastSubChapter(Ljava/lang/String;)Ljava/lang/String;
    .registers 11
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "quizID"
        }
    .end annotation

    .line 130
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getReadableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const-string v1, "id"

    const-string v2, "quizId"

    const-string v3, "chapterId"

    const-string v4, "quizPageNo"

    const-string v5, "queId"

    const-string v6, "answer"

    const-string v7, "hasSubChapter"

    .line 132
    filled-new-array/range {v1 .. v7}, [Ljava/lang/String;

    move-result-object v2

    const/4 v1, 0x1

    new-array v4, v1, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p1, v4, v1

    const-string v1, "quizdetails"

    const-string v3, "quizId=?"

    const/4 v5, 0x0

    const/4 v6, 0x0

    const/4 v7, 0x0

    const/4 v8, 0x0

    invoke-virtual/range {v0 .. v8}, Landroid/database/sqlite/SQLiteDatabase;->query(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1

    .line 137
    invoke-interface {p1}, Landroid/database/Cursor;->getCount()I

    move-result v0

    if-lez v0, :cond_37

    .line 138
    invoke-interface {p1}, Landroid/database/Cursor;->moveToLast()Z

    const/4 v0, 0x6

    .line 139
    invoke-interface {p1, v0}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object p1

    return-object p1

    .line 141
    :cond_37
    invoke-interface {p1}, Landroid/database/Cursor;->close()V

    const/4 p1, 0x0

    return-object p1
.end method

.method public getQuizQues(Ljava/lang/String;)Lcom/yctpublication/mastes/models/QuizQuestionModel;
    .registers 36
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "id"
        }
    .end annotation

    .line 78
    invoke-virtual/range {p0 .. p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getReadableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    const-string v1, "id"

    const-string v2, "quizId"

    const-string v3, "chapterId"

    const-string v4, "quizPageNo"

    const-string v5, "queId"

    const-string v6, "answer"

    const-string v7, "hasSubChapter"

    .line 80
    filled-new-array/range {v1 .. v7}, [Ljava/lang/String;

    move-result-object v2

    const/4 v9, 0x1

    new-array v4, v9, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p1, v4, v1

    const-string v1, "quizdetails"

    const-string v3, "queId=?"

    const/4 v5, 0x0

    const/4 v6, 0x0

    const/4 v7, 0x0

    const/4 v8, 0x0

    invoke-virtual/range {v0 .. v8}, Landroid/database/sqlite/SQLiteDatabase;->query(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v0

    .line 85
    invoke-interface {v0}, Landroid/database/Cursor;->getCount()I

    move-result v1

    const-string v2, ""

    if-lez v1, :cond_83

    .line 86
    invoke-interface {v0}, Landroid/database/Cursor;->moveToLast()Z

    .line 87
    new-instance v1, Lcom/yctpublication/mastes/models/QuizQuestionModel;

    move-object v10, v1

    const/4 v11, 0x0

    .line 89
    invoke-interface {v0, v9}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v12

    const/4 v13, 0x0

    const/4 v14, 0x0

    const/4 v15, 0x0

    const/16 v16, 0x0

    const/16 v17, 0x0

    const/16 v18, 0x0

    const/16 v19, 0x0

    const/16 v20, 0x0

    const/16 v21, 0x0

    const/16 v22, 0x0

    const/16 v23, 0x0

    const/16 v24, 0x0

    const/16 v25, 0x0

    const/16 v26, 0x0

    const/16 v27, 0x0

    const/16 v28, 0x0

    const/16 v29, 0x0

    const/16 v30, 0x0

    const/16 v31, 0x0

    const/16 v32, 0x0

    const/4 v3, 0x5

    .line 92
    invoke-interface {v0, v3}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v33

    invoke-direct/range {v10 .. v33}, Lcom/yctpublication/mastes/models/QuizQuestionModel;-><init>(ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V

    .line 97
    new-instance v3, Ljava/lang/StringBuilder;

    invoke-direct {v3}, Ljava/lang/StringBuilder;-><init>()V

    invoke-interface {v0}, Landroid/database/Cursor;->getCount()I

    move-result v0

    invoke-virtual {v3, v0}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v0

    const-string v2, "cursor"

    invoke-static {v2, v0}, Landroid/util/Log;->e(Ljava/lang/String;Ljava/lang/String;)I

    return-object v1

    .line 101
    :cond_83
    invoke-interface {v0}, Landroid/database/Cursor;->close()V

    .line 102
    new-instance v1, Ljava/lang/StringBuilder;

    invoke-direct {v1}, Ljava/lang/StringBuilder;-><init>()V

    invoke-interface {v0}, Landroid/database/Cursor;->getCount()I

    move-result v0

    invoke-virtual {v1, v0}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v0

    invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v0

    const-string v1, "cursor_null"

    invoke-static {v1, v0}, Landroid/util/Log;->e(Ljava/lang/String;Ljava/lang/String;)I

    const/4 v0, 0x0

    return-object v0
.end method

.method public onCreate(Landroid/database/sqlite/SQLiteDatabase;)V
    .registers 3
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "db"
        }
    .end annotation

    const-string v0, "CREATE TABLE quizdetails(id INTEGER PRIMARY KEY,quizId TEXT,chapterId TEXT,quizPageNo TEXT,queId TEXT,answer TEXT,hasSubChapter TEXT)"

    .line 42
    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    return-void
.end method

.method public onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V
    .registers 4
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0,
            0x0,
            0x0
        }
        names = {
            "db",
            "oldVersion",
            "newVersion"
        }
    .end annotation

    const-string p2, "DROP TABLE IF EXISTS quizdetails"

    .line 49
    invoke-virtual {p1, p2}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 52
    invoke-virtual {p0, p1}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V

    return-void
.end method

.method public updateContact(Lcom/yctpublication/mastes/common/storevalue/BookIdModel;)I
    .registers 6
    .annotation system Ldalvik/annotation/MethodParameters;
        accessFlags = {
            0x0
        }
        names = {
            "contact"
        }
    .end annotation

    .line 213
    invoke-virtual {p0}, Lcom/yctpublication/mastes/common/storevalue/databasebook/DatabaseHandlerofQuiz;->getWritableDatabase()Landroid/database/sqlite/SQLiteDatabase;

    move-result-object v0

    .line 215
    new-instance v1, Landroid/content/ContentValues;

    invoke-direct {v1}, Landroid/content/ContentValues;-><init>()V

    .line 216
    invoke-virtual {p1}, Lcom/yctpublication/mastes/common/storevalue/BookIdModel;->getBookId()Ljava/lang/String;

    move-result-object v2

    const-string v3, "quizId"

    invoke-virtual {v1, v3, v2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 217
    invoke-virtual {p1}, Lcom/yctpublication/mastes/common/storevalue/BookIdModel;->getChapterId()Ljava/lang/String;

    move-result-object v2

    const-string v3, "chapterId"

    invoke-virtual {v1, v3, v2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 218
    invoke-virtual {p1}, Lcom/yctpublication/mastes/common/storevalue/BookIdModel;->getBookPageNo()Ljava/lang/String;

    move-result-object v2

    const-string v3, "quizPageNo"

    invoke-virtual {v1, v3, v2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    const/4 v2, 0x1

    new-array v2, v2, [Ljava/lang/String;

    .line 222
    invoke-virtual {p1}, Lcom/yctpublication/mastes/common/storevalue/BookIdModel;->getId()I

    move-result p1

    invoke-static {p1}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p1

    const/4 v3, 0x0

    aput-object p1, v2, v3

    const-string p1, "quizdetails"

    const-string v3, "id = ?"

    .line 221
    invoke-virtual {v0, p1, v1, v3, v2}, Landroid/database/sqlite/SQLiteDatabase;->update(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;)I

    move-result p1

    return p1
.end method