DataBase.m | searchcode

/iQuran/iQuran/DataBase.m

https://bitbucket.org/dhaval_openxcell/dhaval-quran
Objective C | 600 lines | 393 code | 154 blank | 53 comment | 79 complexity | 4511aa5311f95c84eb3e163deff46e58 MD5 | raw file

//
//  DataBase.m
//  HostMaster
//
//  Created by apple  on 10/3/11.
//  Copyright 2011 bvhkh. All rights reserved.
//

#import "DataBase.h"
#import <sqlite3.h>

@implementation DataBase

#pragma mark -
#pragma mark Get Path
// Fetch Database path
-(NSString *) getDBPath
{
	NSString *databaseName = @"QuranDatabase.sqlite";
	
	NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
	NSString *documentsDir = [documentPaths objectAtIndex:0];
	NSString *databasePath = [documentsDir stringByAppendingPathComponent:databaseName];

	return databasePath;	
}


#pragma mark -
#pragma mark Manage Event Table
// Insert Event Data
//CREATE TABLE "QuranChapter" ("cId" INTEGER PRIMARY KEY  NOT NULL ,"iChapterID" VARCHAR,"iChapterNum" VARCHAR,"vNameEn" VARCHAR,"vMeaning" VARCHAR,"vChronOrder" VARCHAR,"vOtherName" VARCHAR,"vOtherMeaning" VARCHAR,"vOrigin" VARCHAR,"versecount" VARCHAR, "vNameAr" VARCHAR, "vNameRu" VARCHAR, "vNameUr" VARCHAR, "vNameBn" VARCHAR, "vNameId" VARCHAR)
-(void)InsertIntoQuranChapterId:(NSString *)chapterId ChapteNumber:(NSString *)chapteNumber ChapterNameEng:(NSString *)chapterNameEng Meaning:(NSString *)meaning CronichalOrder:(NSString *)cronicalOrder OtherName:(NSString *)otherName OtherMeaning:(NSString *)otherMeaning Origin:(NSString *)origin VerseCount:(NSString *)verseCount ChapterNameAr:(NSString *)ChapterNameAr ChapterNameRu:(NSString *)ChapterNameRu ChapterNameBn:(NSString *)ChapterNameBn chapterNameId:(NSString *)chapterNameId ChapterNameUr:(NSString *)ChapterNameUr
{
	sqlite3 *database;
	sqlite3_stmt *stment;
	stment =nil;
	NSString *databasePath = [self getDBPath];
    NSString *sql=[NSString stringWithFormat:@"insert into QuranChapter (iChapterID,iChapterNum,vNameEn,vMeaning,vChronOrder,vOtherName,vOtherMeaning,vOrigin,versecount,vNameAr,vNameRu,vNameUr,vNameBn,vNameId)Values('%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@')",chapterId,chapteNumber,chapterNameEng,meaning,cronicalOrder,otherName,otherMeaning,origin,verseCount,ChapterNameAr,ChapterNameRu,ChapterNameUr,ChapterNameBn,chapterNameId];
	
	if (sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)
	{
		if (sqlite3_prepare_v2(database, [sql UTF8String], -1, &stment, NULL) == SQLITE_OK) 
		{
            NSLog(@"Success");
			sqlite3_step(stment);
		}
	}
	sqlite3_finalize(stment);
	sqlite3_close(database);
}


-(void)InsertIntoQuranVerseWithChapterId:(NSString *)chapterId ChapteNumber:(NSString *)chapteNumber VerseId:(NSString *)verseId VerseNumber:(NSString *)verseNumber LanguageEnglish:(NSString *)english LanguageArabic:(NSString *)arabic LanguageUrdu:(NSString *)urdu LanguageRussian:(NSString *)russian LanguageBangladeshi:(NSString *)bangladeshi LanguageIndinesian:(NSString *)indonesia OriginalUrdu:(NSString *)urduOriginal OriginalArabic:(NSString *)arabicOriginal TransEnglish:(NSString *)transEng CronichalOrder:(NSString *)cronicalOrder OtherMeaning:(NSString *)otherMeaning Origin:(NSString *)origin
{
    sqlite3 *database;
	sqlite3_stmt *stment;
	stment =nil;
	
	NSString *databasePath = [self getDBPath];
    
    NSString *sql=[NSString stringWithFormat:@"insert into QuranVerses (iChapterNum,iVerseID,vTextEn,vTextAr,vTransEn,iVerserNumber,vChronOrder,vOtherMeaning,vOrigin,Arabic_,Urdu_,vTextBn,vTextId,vTextUr,vTextRu)Values('%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@','%@')",chapteNumber,verseId,english,arabic,transEng,verseNumber,cronicalOrder,otherMeaning,origin,arabicOriginal,urduOriginal,bangladeshi,indonesia,urdu,russian];
	
	if (sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)
	{
		if (sqlite3_prepare_v2(database, [sql UTF8String], -1, &stment, NULL) == SQLITE_OK)
		{
			sqlite3_step(stment);
		}
        else
        {
        }
	}
	sqlite3_finalize(stment);
	sqlite3_close(database);
}


-(int)GetLastImageId
{
    sqlite3 *database;
    int Count=0;
    
    NSString *dbPath = [self getDBPath];
    if(sqlite3_open([dbPath UTF8String], &database)== SQLITE_OK)
    {
        const char *sqlStatement = "SELECT MAX(ImageId) FROM  HuntersAlbums";
        sqlite3_stmt *compiledStatement;
        
        if (sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement , NULL)==SQLITE_OK) 
        {
            while (sqlite3_step(compiledStatement)==SQLITE_ROW) 
            {
                
                
                Count = sqlite3_column_int(compiledStatement, 0);
            }
            sqlite3_finalize(compiledStatement);
        }
        
        sqlite3_close(database);   
        
    }
    return Count;
}




// Fetch All Album Data

-(NSMutableArray *)SelectAllChapterOfQuran
{
    NSMutableArray *arrdata;
	arrdata=[[NSMutableArray alloc]init];
	sqlite3 *database;
	
	NSString *databasePath = [self getDBPath];
    
	if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
		
		NSString *sqlQuery=@"Select * from QuranChapter ORDER BY ABS(iChapterNum) ASC";
		
		sqlite3_stmt *compiledStatement;
		compiledStatement=nil;
		
		if(sqlite3_prepare_v2(database, [sqlQuery UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK) {
			
			while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
				
				if ((char *)sqlite3_column_text(compiledStatement,0)!=0) {
					
				    NSMutableDictionary *temData = [[NSMutableDictionary alloc] init];
					
                    int pKey = sqlite3_column_int(compiledStatement,0);
                    
                    [temData setValue:[NSString stringWithFormat:@"%d",pKey] forKey:@"cId"];
                    
					[temData setObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,1)] forKey:@"iChapterID"];
                    [temData setObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,2)] forKey:@"iChapterNum"];
                    
                    NSString* NameEng = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,3)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    
                    NSString* Meaning = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                                        
                    NSString* OtherName = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,6)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    
                    NSString* OtherMeaning = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,7)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    
                    NSString* Origin = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,8)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    
                     NSString* NameAr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,10)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                     NSString* NameRu = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,11)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                     NSString* NameUr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,12)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                     NSString* NameBn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,13)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                     NSString* NameId = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,14)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    
					[temData setObject:NameEng forKey:@"vNameEn"];
                    [temData setObject:NameAr forKey:@"vNameAr"];
                    [temData setObject:NameRu forKey:@"vNameRu"];
                    [temData setObject:NameBn forKey:@"vNameBn"];
                    [temData setObject:NameUr forKey:@"vNameUr"];
                    [temData setObject:NameId forKey:@"vNameId"];
                    
					[temData setObject:Meaning forKey:@"vMeaning"];
                    [temData setObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,5)] forKey:@"vChronOrder"];
                    [temData setObject:OtherName forKey:@"vOtherName"];
                    [temData setObject:OtherMeaning forKey:@"vOtherMeaning"];
					[temData setObject:Origin forKey:@"vOrigin"];
					[temData setObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,9)] forKey:@"versecount"];
                    
                    
                    
                    //[temData setObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,10)] forKey:@"Reciter1"];
					
                    [arrdata addObject:temData];
                    
				}
			}
		}
		sqlite3_finalize(compiledStatement);
	}
	sqlite3_close(database);
	
	return arrdata;

}

-(NSMutableArray*)GetChapterInfoWithChapterNumber:(int)chapterNumber Language:(NSString *)Language
{
    NSMutableArray *aryData;
    aryData = [[NSMutableArray alloc]init];
	sqlite3 *database;
	
	NSString *databasePath = [self getDBPath];
    
	if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)
    {
		//NSString *sqlQuery=[NSString stringWithFormat:@"Select vNameEn, vMeaning, vChronOrder, vOtherName, vOtherMeaning, vOrigin, versecount, iChapterNum from QuranChapter where iChapterNum = %d ORDER BY ABS(iChapterNum) ASC",chapterNumber];
        NSString *secondaryLang = @"";
        if([Language isEqualToString:@"Arabic"])
        {
            secondaryLang = @"vNameAr";
        }
        else if([Language isEqualToString:@"Arabic"])
        {
            secondaryLang = @"vNameAr";
        }
        else if([Language isEqualToString:@"Urdu"])
        {
            secondaryLang = @"vNameUr";
        }
        else if([Language isEqualToString:@"Russian"])
        {
            secondaryLang = @"vNameRu";
        }
        else if([Language isEqualToString:@"Indonesian"])
        {
            secondaryLang = @"vNameId";
        }
        else if([Language isEqualToString:@"Bengali"])
        {
            secondaryLang = @"vNameBn";
        }
        
        if ([appDelegate.languageSelected isEqualToString:@"en"])
        {
            secondaryLang = @"vNameEn";
        }
        NSString *sqlQuery=[NSString stringWithFormat:@"Select %@, vMeaning, vChronOrder, vOtherName, vOtherMeaning, vOrigin, versecount, iChapterNum from QuranChapter where iChapterNum = %d ORDER BY ABS(iChapterNum) ASC",secondaryLang,chapterNumber];
		sqlite3_stmt *compiledStatement;
		compiledStatement=nil;
		
		if(sqlite3_prepare_v2(database, [sqlQuery UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK)
        {
			while(sqlite3_step(compiledStatement) == SQLITE_ROW)
            {
				if ((char *)sqlite3_column_text(compiledStatement,0)!=0)
                {
                     NSMutableDictionary *tempData = [[NSMutableDictionary alloc] init];
                    
                     NSString* NameEng = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,0)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [tempData setValue:NameEng forKey:secondaryLang];
                    
                     NSString* Meaning = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,1)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [tempData setValue:Meaning forKey:@"vMeaning"];
                    
                    [tempData setValue:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,2)] forKey:@"vChronOrder"];
                    
                    NSString* OtherName = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,3)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [tempData setValue:OtherName forKey:@"vOtherName"];
                    
                    NSString* OtherMean = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [tempData setValue:OtherMean forKey:@"vOtherMeaning"];
                    
                     NSString* Origin = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,5)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [tempData setValue:Origin forKey:@"vOrigin"];
                    
                    [tempData setValue:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,6)] forKey:@"versecount"];
                    
                    [tempData setValue:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,7)] forKey:@"iChapterNum"];
                    [aryData addObject:tempData];
                }
            }
		}
		sqlite3_finalize(compiledStatement);
	}
	sqlite3_close(database);
	
	return aryData;
}

-(NSMutableArray *)SelectVersesFromChapterNumber:(NSString *)chapterNo withLanguage:(NSString *)language
{
    NSMutableArray *arrdata;
    arrdata=[[NSMutableArray alloc]init];
    sqlite3 *database;

    NSString *databasePath = [self getDBPath];

    if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
        
        NSString *secondaryLang = @"";
        
        if([language isEqualToString:@"Arabic"])
        {
            secondaryLang = @"vTextAr";
        }
        else if([language isEqualToString:@"Urdu"])
        {
            secondaryLang = @"vTextUr";
        }
        else if([language isEqualToString:@"Russian"])
        {
            secondaryLang = @"vTextRu";
        }
        else if([language isEqualToString:@"Indonesian"])
        {
            secondaryLang = @"vTextId";
        }
        else if([language isEqualToString:@"Bengali"])
        {
            secondaryLang = @"vTextBn";
        }
        
        NSString *sqlQuery=[NSString stringWithFormat:@"Select iChapterNum,iVerseID,vTextEn,vTransEn,%@,iVerserNumber from VersesTable where iChapterNum = %@ ORDER BY ABS(iVerserNumber) ASC",secondaryLang,chapterNo];
        
        sqlite3_stmt *compiledStatement;
        compiledStatement=nil;
        
        if(sqlite3_prepare_v2(database, [sqlQuery UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK) {
            
            while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
                
                if ((char *)sqlite3_column_text(compiledStatement,0)!=0) {
                    
                    NSMutableDictionary *temData = [[NSMutableDictionary alloc] init];
                    
                    [temData setObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,0)] forKey:@"iChapterNum"];
                    
                    NSString *iVerseID = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,1)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:iVerseID forKey:@"iVerseID"];
                    
                    NSString *vTextEn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,2)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextEn forKey:@"vTextEn"];
                    
                    NSString *vTransEn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTransEn forKey:@"vTransEn"];
                    
                    
                    if([secondaryLang isEqualToString:@"vTextAr"])
                    {
                        //NSString vTextAr = [[NSString stringWithUTF8String:(char )sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                        //[temData setObject:vTextAr forKey:@"vTextAr"];
                        NSString *Arabic_ = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                        [temData setObject:Arabic_ forKey:@"Arabic_"];
                    }
                    else if([secondaryLang isEqualToString:@"vTextUr"])
                    {
                        //NSString vTextAr = [[NSString stringWithUTF8String:(char )sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                        //[temData setObject:vTextAr forKey:@"vTextUr"];
                        NSString *Urdu_ = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                        [temData setObject:Urdu_ forKey:@"Urdu_"];
                    }
                    else if([secondaryLang isEqualToString:@"vTextRu"])
                    {
                        NSString *vTextAr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                        [temData setObject:vTextAr forKey:@"Ru_"];
                    }
                    else if([secondaryLang isEqualToString:@"vTextId"])
                    {
                        NSString* vTextAr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                        [temData setObject:vTextAr forKey:@"Id_"];
                    }
                    else if([secondaryLang isEqualToString:@"vTextBn"])
                    {
                        NSString* vTextAr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                        [temData setObject:vTextAr forKey:@"Bn_"];
                    }
                    
                    NSString* iVerserNumber = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)];
                    [temData setObject:iVerserNumber forKey:@"iVerserNumber"];
                    
                    
                    [arrdata addObject:temData];
                }
            }
        }
        sqlite3_finalize(compiledStatement);
    }
    sqlite3_close(database);
    return arrdata;
}

-(NSMutableArray*)SelectVerses:(NSString *)verseNo andChapterNumber:(NSString *)chapterNo
{
    NSMutableArray *arrdata;
	arrdata=[[NSMutableArray alloc]init];
	sqlite3 *database;
	
	NSString *databasePath = [self getDBPath];
    
	if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
		
		NSString *sqlQuery=[NSString stringWithFormat:@"Select * from VersesTable where iChapterNum = %@ and iVerserNumber = %@",chapterNo,verseNo];
		
		sqlite3_stmt *compiledStatement;
		compiledStatement=nil;
		
		if(sqlite3_prepare_v2(database, [sqlQuery UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK) {
			
			while(sqlite3_step(compiledStatement) == SQLITE_ROW)
            {
				if ((char *)sqlite3_column_text(compiledStatement,0)!=0)
                {
					
				    NSMutableDictionary *temData = [[NSMutableDictionary alloc] init];
					
                    int pKey = sqlite3_column_int(compiledStatement,0);
                    
                    [temData setValue:[NSString stringWithFormat:@"%d",pKey] forKey:@"cId"];
                                    
                    
                    [temData setObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,1)] forKey:@"iChapterNum"];
                    
                    NSString* iVerseID = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,2)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    
                    [temData setObject:iVerseID forKey:@"iVerseID"];
                    
                    NSString* vTextEn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,3)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextEn forKey:@"vTextEn"];
                    
                    
                    NSString* iVerserNumber = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,6)];
                    [temData setObject:iVerserNumber forKey:@"iVerserNumber"];
                    
                    /*NSString* vTextAr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextAr forKey:@"vTextAr"];
                    
                    NSString* vTransEn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,5)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTransEn forKey:@"vTransEn"];
                    
                    NSString* iVerserNumber = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,6)];
                    [temData setObject:iVerserNumber forKey:@"iVerserNumber"];
                    
                    NSString* vChronOrder = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,7)];
                    [temData setObject:vChronOrder forKey:@"vChronOrder"];
                    
                    NSString* vOtherMeaning = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,8)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vOtherMeaning forKey:@"vOtherMeaning"];
                    
                    NSString* vOrigin = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,9)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vOrigin forKey:@"vOrigin"];
                    
                    NSString* Arabic_ = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,10)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:Arabic_ forKey:@"Arabic_"];
                    
                    NSString* Urdu_ = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,11)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:Urdu_ forKey:@"Urdu_"];
                    
                    NSString* vTextBn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,12)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextBn forKey:@"vTextBn"];
                    
                    NSString* vTextId = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,13)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextId forKey:@"vTextId"];
                    
                    NSString* vTextUr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,14)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextUr forKey:@"vTextUr"];
                    
                    NSString* vTextRu = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,15)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextRu forKey:@"vTextRu"];*/
                    
                    [arrdata addObject:temData];
                    
				}
			}
		}
		sqlite3_finalize(compiledStatement);
	}
	sqlite3_close(database);
	
	return arrdata;
}


//update Event Data

-(void)updateAlbumImage:(NSString *)albumImg ForAlbum:(int)albumId
{
    sqlite3 *database;
	
    NSString *databasePath = [self getDBPath];
    
	if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
		
        
		NSString *sqlQuery=[NSString stringWithFormat:@"Update NewAlbum set AlbumImage = '%@' where AlbumId = %d",albumImg,albumId];	
        
        sqlite3_stmt *compiledStatement;
		compiledStatement=nil;
		
		if(sqlite3_prepare_v2(database, [sqlQuery UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK) 
        {			
            sqlite3_step(compiledStatement);
		}
		
		sqlite3_finalize(compiledStatement);
		
	}
	sqlite3_close(database);
}


-(void)removeAllImageWithAlbum:(int)albumId
{
    sqlite3 *database;
	
    NSString *databasePath = [self getDBPath];
    
	if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
		
		NSString *sqlQuery=[NSString stringWithFormat:@"Delete From HuntersAlbums where AlbumId=%d",albumId];			
		sqlite3_stmt *compiledStatement;
		compiledStatement=nil;
		
		if(sqlite3_prepare_v2(database, [sqlQuery UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK) {
			
			sqlite3_step(compiledStatement);
		}
		
		sqlite3_finalize(compiledStatement);
		
	}
	sqlite3_close(database);
}
#pragma mark - GetData To Bookmark
-(NSMutableArray *)get_VersesFromChapterNumber:(NSString *)chapterNo iVerseID:(NSString *)iVerseID
{
    NSMutableArray *arrdata;
    arrdata=[[NSMutableArray alloc]init];
    sqlite3 *database;
    
    NSString *databasePath = [self getDBPath];
    
    if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)
    {
        NSString *sqlQuery=[NSString stringWithFormat:@"Select * from VersesTable where iChapterNum = %@ AND iVerseID = '%@'",chapterNo,iVerseID];
        
        sqlite3_stmt *compiledStatement;
        compiledStatement=nil;
        
        if(sqlite3_prepare_v2(database, [sqlQuery UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK) {
            
            while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
                
                if ((char *)sqlite3_column_text(compiledStatement,0)!=0)
                {
                    
                    NSMutableDictionary *temData = [[NSMutableDictionary alloc] init];
                    
                    int pKey = sqlite3_column_int(compiledStatement,0);
                    [temData setObject:[NSString stringWithFormat:@"%d",pKey] forKey:@"primaryKey"];
                    
                    [temData setObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,1)] forKey:@"iChapterNum"];
                    
                    NSString *iVerseID = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,2)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:iVerseID forKey:@"iVerseID"];
                    
                    NSString *vTextEn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,3)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextEn forKey:@"vTextEn"];
                    
                    NSString *vTextAr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,4)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextAr forKey:@"vTextAr"];
                    
                    NSString *vTransEn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,5)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTransEn forKey:@"vTransEn"];
                    
                    NSString *iVerserNumber = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,6)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:iVerserNumber forKey:@"iVerserNumber"];
                   
                    NSString *vChronOrder = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,7)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vChronOrder forKey:@"vChronOrder"];
                    
                    NSString* vOtherMeaning = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,8)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vOtherMeaning forKey:@"vOtherMeaning"];

                    
                    NSString* vOrigin = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,9)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vOrigin forKey:@"vOrigin"];
                    
                    NSString* Arabic_ = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,10)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:Arabic_ forKey:@"Arabic_"];
                    
                    NSString* Urdu_ = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,11)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:Urdu_ forKey:@"Urdu_"];
                    
                    NSString* vTextBn = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,12)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextBn forKey:@"vTextBn"];
                    
                    NSString* vTextId = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,13)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextId forKey:@"vTextId"];
                    
                    NSString* vTextUr = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,13)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextUr forKey:@"vTextUr"];
                    
                    NSString* vTextRu = [[NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,14)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
                    [temData setObject:vTextRu forKey:@"vTextRu"];
                    
                    [arrdata addObject:temData];
                }
            }
        }
        sqlite3_finalize(compiledStatement);
    }
    sqlite3_close(database);
    return arrdata;
}


@end