/iQuran/iQuran/DataBase.m
Objective C | 508 lines | 301 code | 135 blank | 72 comment | 57 complexity | df27bdcbe30ea28f28504d91f4b68284 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
- {
- 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];
- 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:@"vNameEn"];
-
- 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:@"Indonesia"])
- {
- secondaryLang = @"vTextId";
- }
- else if([language isEqualToString:@"Bangladesh"])
- {
- 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];
-
- //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,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* 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,3)] stringByReplacingOccurrencesOfString:@"åπ¬çø∂" withString:@"'"];
- [temData setObject:vTransEn forKey:@"vTransEn"];
-
- NSString* iVerserNumber = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement,5)];
- [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"];*/
-
- 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_"];
- }
-
-
-
- /* 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;
- }
- -(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);
- }
- @end