package com.pas.abtahibo.parvaz;


import anywheresoftware.b4a.BA;
import anywheresoftware.b4a.B4AClass;
import anywheresoftware.b4a.BALayout;
import anywheresoftware.b4a.debug.*;

public class adddb extends B4AClass.ImplB4AClass implements BA.SubDelegator{
    private static java.util.HashMap<String, java.lang.reflect.Method> htSubs;
    private void innerInitialize(BA _ba) throws Exception {
        if (ba == null) {
            ba = new BA(_ba, this, htSubs, "com.pas.abtahibo.parvaz.adddb");
            if (htSubs == null) {
                ba.loadHtSubs(this.getClass());
                htSubs = ba.htSubs;
            }
            
        }
        if (BA.isShellModeRuntimeCheck(ba)) 
			   this.getClass().getMethod("_class_globals", com.pas.abtahibo.parvaz.adddb.class).invoke(this, new Object[] {null});
        else
            ba.raiseEvent2(null, true, "class_globals", false);
    }

 public anywheresoftware.b4a.keywords.Common __c = null;
public anywheresoftware.b4a.sql.SQL _vvvvvvvvvvvvvvvvvvv6 = null;
public anywheresoftware.b4a.sql.SQL _vvvvvvvvvvvvvvvvvvv7 = null;
public anywheresoftware.b4a.sql.SQL _vvvvvvvvvvvvvvvvvvv0 = null;
public anywheresoftware.b4a.sql.SQL.ResultSetWrapper _vvvvvvvvvvvvvvvvvvvv1 = null;
public b4a.example.dateutils _vvvvvvvvvvvvvvvv1 = null;
public com.pas.abtahibo.parvaz.main _vvvvvvvvvvvvvvvv2 = null;
public com.pas.abtahibo.parvaz.actbook _vvvvvvvvvvvvvvvv3 = null;
public com.pas.abtahibo.parvaz.actapps _vvvvvvvvvvvvvvvv4 = null;
public com.pas.abtahibo.parvaz.actguide _vvvvvvvvvvvvvvvv5 = null;
public com.pas.abtahibo.parvaz.actnotific _vvvvvvvvvvvvvvvv6 = null;
public com.pas.abtahibo.parvaz.func _vvvvvvvvvvvvvvvv7 = null;
public com.pas.abtahibo.parvaz.myservice _vvvvvvvvvvvvvvvv0 = null;
public com.pas.abtahibo.parvaz.playservicebook _vvvvvvvvvvvvvvvvv1 = null;
public com.pas.abtahibo.parvaz.playsrds _vvvvvvvvvvvvvvvvv2 = null;
public com.pas.abtahibo.parvaz.starter _vvvvvvvvvvvvvvvvv3 = null;
public com.pas.abtahibo.parvaz.support _vvvvvvvvvvvvvvvvv4 = null;
public com.pas.abtahibo.parvaz.urls _vvvvvvvvvvvvvvvvv5 = null;
public com.pas.abtahibo.parvaz.xuiviewsutils _vvvvvvvvvvvvvvvvv6 = null;
public String  _vvvvvvvvvvvvvvvvvvv3() throws Exception{
 //BA.debugLineNum = 29;BA.debugLine="Public Sub addDBs";
 //BA.debugLineNum = 30;BA.debugLine="addDefaultIphone";
_vvvvvvvvvvvvvvvvvvv4();
 //BA.debugLineNum = 31;BA.debugLine="deletePDFBook";
_vvvvvvvvvvvvvvvvvvv5();
 //BA.debugLineNum = 32;BA.debugLine="End Sub";
return "";
}
public String  _vvvvvvvvvvvvvvvvvvv4() throws Exception{
String _qry = "";
String _ennamebook = "";
 //BA.debugLineNum = 49;BA.debugLine="Private Sub addDefaultIphone";
 //BA.debugLineNum = 51;BA.debugLine="Dim qry As String";
_qry = "";
 //BA.debugLineNum = 53;BA.debugLine="Try";
try { //BA.debugLineNum = 54;BA.debugLine="qry=\"select id from fav_matn\"";
_qry = "select id from fav_matn";
 //BA.debugLineNum = 55;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e6) {
			ba.setLastException(e6); //BA.debugLineNum = 57;BA.debugLine="qry=\"CREATE TABLE fav_matn(id	INTEGER PRIMARY KE";
_qry = "CREATE TABLE fav_matn(id	INTEGER PRIMARY KEY AUTOINCREMENT,onvan  TEXT,date_ghamari  TEXT,date_shamsi  TEXT,id_matn  INTEGER)";
 //BA.debugLineNum = 58;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 62;BA.debugLine="Try";
try { //BA.debugLineNum = 63;BA.debugLine="qry=\"select type3 from fav_matn LIMIT 1\"";
_qry = "select type3 from fav_matn LIMIT 1";
 //BA.debugLineNum = 64;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e13) {
			ba.setLastException(e13); //BA.debugLineNum = 66;BA.debugLine="qry=\"ALTER TABLE fav_matn ADD COLUMN type3 TEXT";
_qry = "ALTER TABLE fav_matn ADD COLUMN type3 TEXT DEFAULT '1' ";
 //BA.debugLineNum = 67;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 71;BA.debugLine="Try";
try { //BA.debugLineNum = 72;BA.debugLine="qry=\"select id_year from fav_matn LIMIT 1\"";
_qry = "select id_year from fav_matn LIMIT 1";
 //BA.debugLineNum = 73;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e20) {
			ba.setLastException(e20); //BA.debugLineNum = 75;BA.debugLine="qry=\"ALTER TABLE fav_matn ADD COLUMN id_year TEX";
_qry = "ALTER TABLE fav_matn ADD COLUMN id_year TEXT DEFAULT '1' ";
 //BA.debugLineNum = 76;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 80;BA.debugLine="Try";
try { //BA.debugLineNum = 81;BA.debugLine="qry=\"select type4 from fav_matn LIMIT 1\"";
_qry = "select type4 from fav_matn LIMIT 1";
 //BA.debugLineNum = 82;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e27) {
			ba.setLastException(e27); //BA.debugLineNum = 84;BA.debugLine="qry=\"ALTER TABLE fav_matn ADD COLUMN type4 TEXT";
_qry = "ALTER TABLE fav_matn ADD COLUMN type4 TEXT DEFAULT '1' ";
 //BA.debugLineNum = 85;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 88;BA.debugLine="Try";
try { //BA.debugLineNum = 89;BA.debugLine="qry=\"select lang from favebook LIMIT 1\"";
_qry = "select lang from favebook LIMIT 1";
 //BA.debugLineNum = 90;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e34) {
			ba.setLastException(e34); //BA.debugLineNum = 92;BA.debugLine="qry=\"ALTER TABLE favebook ADD COLUMN lang TEXT D";
_qry = "ALTER TABLE favebook ADD COLUMN lang TEXT DEFAULT '1' ";
 //BA.debugLineNum = 93;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 96;BA.debugLine="Try";
try { //BA.debugLineNum = 97;BA.debugLine="qry=\"select lang from favebook LIMIT 1\"";
_qry = "select lang from favebook LIMIT 1";
 //BA.debugLineNum = 98;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e41) {
			ba.setLastException(e41); //BA.debugLineNum = 100;BA.debugLine="qry=\"ALTER TABLE favebook ADD COLUMN lang TEXT D";
_qry = "ALTER TABLE favebook ADD COLUMN lang TEXT DEFAULT '1' ";
 //BA.debugLineNum = 101;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 104;BA.debugLine="Dim ennameBook As String";
_ennamebook = "";
 //BA.debugLineNum = 106;BA.debugLine="rs = sqlSB.ExecQuery(\"SELECT idindex from book\")";
_vvvvvvvvvvvvvvvvvvvv1 = (anywheresoftware.b4a.sql.SQL.ResultSetWrapper) anywheresoftware.b4a.AbsObjectWrapper.ConvertToWrapper(new anywheresoftware.b4a.sql.SQL.ResultSetWrapper(), (android.database.Cursor)(_vvvvvvvvvvvvvvvvvvv7.ExecQuery("SELECT idindex from book")));
 //BA.debugLineNum = 107;BA.debugLine="Do While rs.NextRow";
while (_vvvvvvvvvvvvvvvvvvvv1.NextRow()) {
 //BA.debugLineNum = 109;BA.debugLine="ennameBook = \"bardasht_\"&rs.GetString(\"idindex\")";
_ennamebook = "bardasht_"+_vvvvvvvvvvvvvvvvvvvv1.GetString("idindex");
 //BA.debugLineNum = 111;BA.debugLine="Try";
try { //BA.debugLineNum = 112;BA.debugLine="qry=\"select id from '\"&ennameBook&\"'\"";
_qry = "select id from '"+_ennamebook+"'";
 //BA.debugLineNum = 113;BA.debugLine="sqlSB2.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv0.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e52) {
			ba.setLastException(e52); //BA.debugLineNum = 115;BA.debugLine="qry=\"CREATE TABLE '\"&ennameBook&\"'(id	INTEGER P";
_qry = "CREATE TABLE '"+_ennamebook+"'(id	INTEGER PRIMARY KEY AUTOINCREMENT,bar  TEXT,ayeh  INTEGER)";
 //BA.debugLineNum = 116;BA.debugLine="sqlSB2.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv0.ExecNonQuery(_qry);
 };
 }
;
 //BA.debugLineNum = 119;BA.debugLine="Loop : rs.Close";
_vvvvvvvvvvvvvvvvvvvv1.Close();
 //BA.debugLineNum = 124;BA.debugLine="Try";
try { //BA.debugLineNum = 125;BA.debugLine="qry=\"select id from fav_qais\"";
_qry = "select id from fav_qais";
 //BA.debugLineNum = 126;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e61) {
			ba.setLastException(e61); //BA.debugLineNum = 128;BA.debugLine="qry=\"CREATE TABLE fav_qais(id	INTEGER PRIMARY KE";
_qry = "CREATE TABLE fav_qais(id	INTEGER PRIMARY KEY AUTOINCREMENT,id_zirmagmoeh  INTEGER,matn  TEXT,types  INTEGER,pos  INTEGER,id_magmoeh  INTEGER,name_magmoeh  TEXT)";
 //BA.debugLineNum = 129;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 133;BA.debugLine="Try";
try { //BA.debugLineNum = 134;BA.debugLine="qry=\"select id from fav_bio\"";
_qry = "select id from fav_bio";
 //BA.debugLineNum = 135;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e68) {
			ba.setLastException(e68); //BA.debugLineNum = 137;BA.debugLine="qry=\"CREATE TABLE fav_bio(id	INTEGER PRIMARY KEY";
_qry = "CREATE TABLE fav_bio(id	INTEGER PRIMARY KEY AUTOINCREMENT,nameBialogy  TEXT,type3  INTEGER,idBialogy  INTEGER)";
 //BA.debugLineNum = 138;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 142;BA.debugLine="Try";
try { //BA.debugLineNum = 143;BA.debugLine="qry=\"select id from fav_mot2\"";
_qry = "select id from fav_mot2";
 //BA.debugLineNum = 144;BA.debugLine="sqlFav.ExecQuerySingleResult(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecQuerySingleResult(_qry);
 } 
       catch (Exception e75) {
			ba.setLastException(e75); //BA.debugLineNum = 146;BA.debugLine="qry=\"CREATE TABLE fav_mot2(id	INTEGER PRIMARY KE";
_qry = "CREATE TABLE fav_mot2(id	INTEGER PRIMARY KEY AUTOINCREMENT,name  TEXT,whichType  INTEGER,picType  TEXT,idMt  INTEGER,idMt2  INTEGER)";
 //BA.debugLineNum = 147;BA.debugLine="sqlFav.ExecNonQuery(qry)";
_vvvvvvvvvvvvvvvvvvv6.ExecNonQuery(_qry);
 };
 //BA.debugLineNum = 150;BA.debugLine="End Sub";
return "";
}
public String  _class_globals() throws Exception{
 //BA.debugLineNum = 2;BA.debugLine="private Sub Class_Globals";
 //BA.debugLineNum = 4;BA.debugLine="Private sqlFav As SQL";
_vvvvvvvvvvvvvvvvvvv6 = new anywheresoftware.b4a.sql.SQL();
 //BA.debugLineNum = 5;BA.debugLine="Private sqlSB As SQL";
_vvvvvvvvvvvvvvvvvvv7 = new anywheresoftware.b4a.sql.SQL();
 //BA.debugLineNum = 6;BA.debugLine="Private sqlSB2 As SQL";
_vvvvvvvvvvvvvvvvvvv0 = new anywheresoftware.b4a.sql.SQL();
 //BA.debugLineNum = 8;BA.debugLine="Private rs As ResultSet";
_vvvvvvvvvvvvvvvvvvvv1 = new anywheresoftware.b4a.sql.SQL.ResultSetWrapper();
 //BA.debugLineNum = 10;BA.debugLine="End Sub";
return "";
}
public String  _vvvvvvvvvvvvvvvvvvv5() throws Exception{
anywheresoftware.b4a.objects.collections.List _list = null;
int _i = 0;
 //BA.debugLineNum = 35;BA.debugLine="Private Sub deletePDFBook";
 //BA.debugLineNum = 37;BA.debugLine="Dim list As List";
_list = new anywheresoftware.b4a.objects.collections.List();
 //BA.debugLineNum = 38;BA.debugLine="list.Initialize";
_list.Initialize();
 //BA.debugLineNum = 40;BA.debugLine="list.Add(1)";
_list.Add((Object)(1));
 //BA.debugLineNum = 41;BA.debugLine="list.Add(5)";
_list.Add((Object)(5));
 //BA.debugLineNum = 43;BA.debugLine="For i = 0 To list.Size-1";
{
final int step5 = 1;
final int limit5 = (int) (_list.getSize()-1);
_i = (int) (0) ;
for (;_i <= limit5 ;_i = _i + step5 ) {
 //BA.debugLineNum = 44;BA.debugLine="File.Delete(File.DirInternal,\"abtahi/Book/\"&list";
__c.File.Delete(__c.File.getDirInternal(),"abtahi/Book/"+BA.ObjectToString(_list.Get(_i))+".pdf");
 }
};
 //BA.debugLineNum = 47;BA.debugLine="End Sub";
return "";
}
public String  _initialize(anywheresoftware.b4a.BA _ba) throws Exception{
innerInitialize(_ba);
 //BA.debugLineNum = 12;BA.debugLine="Public Sub Initialize";
 //BA.debugLineNum = 14;BA.debugLine="If sqlFav.IsInitialized=False Then";
if (_vvvvvvvvvvvvvvvvvvv6.IsInitialized()==__c.False) { 
 //BA.debugLineNum = 15;BA.debugLine="sqlFav.Initialize(File.DirInternal ,\"fav.db\",Tru";
_vvvvvvvvvvvvvvvvvvv6.Initialize(__c.File.getDirInternal(),"fav.db",__c.True);
 };
 //BA.debugLineNum = 18;BA.debugLine="If sqlSB.IsInitialized=False Then";
if (_vvvvvvvvvvvvvvvvvvv7.IsInitialized()==__c.False) { 
 //BA.debugLineNum = 19;BA.debugLine="sqlSB.Initialize(File.DirInternal ,\"quransooreh.";
_vvvvvvvvvvvvvvvvvvv7.Initialize(__c.File.getDirInternal(),"quransooreh.db",__c.True);
 };
 //BA.debugLineNum = 22;BA.debugLine="If sqlSB2.IsInitialized=False Then";
if (_vvvvvvvvvvvvvvvvvvv0.IsInitialized()==__c.False) { 
 //BA.debugLineNum = 23;BA.debugLine="sqlSB2.Initialize(File.DirInternal ,\"prv_note_bo";
_vvvvvvvvvvvvvvvvvvv0.Initialize(__c.File.getDirInternal(),"prv_note_book.db",__c.True);
 };
 //BA.debugLineNum = 27;BA.debugLine="End Sub";
return "";
}
public Object callSub(String sub, Object sender, Object[] args) throws Exception {
BA.senderHolder.set(sender);
return BA.SubDelegator.SubNotFound;
}
}