Multiple Operation of Database
For Multiple Operation of Database First Create database and Then Implement Following Methods :-
:- Create NSObject :-
CustomData.h :-
#import <Foundation/Foundation.h>
@interface CustomData : NSObject
@property (nonatomic,retain) NSString *strLT_VERSION_NUMBER;
//Import
@property (nonatomic,retain) NSString *strSLC_ID;
@property (nonatomic,retain) NSString *strMAC_ID;
@property (nonatomic,retain) NSString *strSLC_NAME;
@property (nonatomic,retain) NSString *strSLC_GROUP_NAME;
//Import data For Motion Group
@property (nonatomic,retain) NSString *strSLC_IDForMotion;
@property (nonatomic,retain) NSString *strMAC_IDForMotion;
@property (nonatomic,retain) NSString *strSLC_NAMEForMotion;
@property (nonatomic,retain) NSString *strSLC_GROUP_NAMEForMotion;
@property (nonatomic,retain) NSString *strSLC_GROUP_IDForMotion;
@end
CustomData.m :-
#import "CustomData.h"
@implementation CustomData
@synthesize strMAC_ID, strSLC_ID, strSLC_NAME, strSLC_GROUP_NAME;
@synthesize strSLC_GROUP_IDForMotion,strSLC_GROUP_NAMEForMotion,strMAC_IDForMotion,strSLC_IDForMotion,strSLC_NAMEForMotion ;
@end
Note :- Here DataBase File Implement For Declare Methods in Database
Database.h :-
#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "CustomData.h"
@interface Database : NSObject
{
NSString *querySQL;
}
@property (strong , nonatomic) CustomData *objCustomDetail ;
//GET DATABASE PATH
-(NSString *)getDBPath;
-(void)openDB;
//Import slc data.
-(void)AddSLCData : (CustomData *)objDetail;
-(void)UpdateSLCData : (NSString *)SLC_Name : (NSString *)MAC_ID;
-(void)DeleteSLCData;
-(NSMutableArray *)GetSLCDetails;
-(NSString *)Get_SLC_ID : (NSString *)SLC_Name;
// ADD & DELETE Motion SLC_GROUP DATA.
-(void)Add_SLC_Motion_Group_Data : (CustomData *)objDetail;
-(void)UpdateSLC_Motion_Data : (CustomData *)objDetail : (NSString *)GRP_ID;
-(void)Delete_SLC_Motion_Group_Data : (NSString *)Group_Name;
-(NSMutableArray *)Get_SLC_Motion_Group_Name;
-(NSMutableArray *)Get_SLC_Group_ID;
-(NSString *)Get_GROUP_SLC_Motion_NAME : (NSString *)Group_Name;
-(CustomData *)Get_SLC_Motion_Group_Details : (NSString *)Group_Name;
-(NSString *)Get_SLC_From_GroupID : (NSString *)Group_ID;
// For image Save And Get
- (void) SaveImagesToSql: (NSData*) imgData :(NSString*) mainUrl ;
- (NSData*) LoadImagesFromSql: (NSString*) imageLink ;
@end
Database.m :-
#import "Database.h"
#import "AppDelegate.h"
@implementation Database
static sqlite3 *database = nil;
-(AppDelegate *)appDelegate
{
return (AppDelegate *)[[UIApplication sharedApplication] delegate];
}
-(NSString *)getDBPath
{
NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory , NSUserDomainMask, YES);
NSString *documentsDir = [paths objectAtIndex : 0];
return [documentsDir stringByAppendingPathComponent : @"Database.sqlite3"];
}
-(void)openDB
{
if (sqlite3_open([[self getDBPath]UTF8String],&database) == SQLITE_OK)
{
NSLog(@"database opened");
}
else
{
sqlite3_close(database);
NSAssert(0, @"database failed to open");
}
}
#pragma mark - ADD UPDATE DELETE SLC DATA.
-(void)AddSLCData : (CustomData *)objDetail
{
sqlite3_stmt *addStmt = nil;
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
if (addStmt == nil) {
const char *sql = "INSERT INTO ImportSLC (slc_id, mac_id, slc_name) values (?, ?, ?)";
if (sqlite3_prepare_v2(database, sql, -1, &addStmt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating add statement. '%s'",sqlite3_errmsg(database));
}
sqlite3_bind_text(addStmt, 1, [objDetail.strSLC_ID UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 2, [objDetail.strMAC_ID UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 3, [objDetail.strSLC_NAME UTF8String], -1, SQLITE_TRANSIENT);
if (SQLITE_DONE != sqlite3_step(addStmt))
NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(database));
else{
sqlite3_finalize(addStmt);
sqlite3_close(database);
}
}
else{
sqlite3_finalize(addStmt);
sqlite3_close(database);
}
}
-(void)UpdateSLCData : (NSString *)SLC_Name : (NSString *)MAC_ID
{
sqlite3_stmt *updateStmt = nil;
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
if (updateStmt == nil) {
const char *sql = "UPDATE ImportSLC SET slc_name =? where mac_id = ?";
if (sqlite3_prepare_v2(database, sql, -1, &updateStmt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating add statement. '%s'",sqlite3_errmsg(database));
}
sqlite3_bind_text(updateStmt, 2, [MAC_ID UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 1, [SLC_Name UTF8String], -1, SQLITE_TRANSIENT);
if (SQLITE_DONE != sqlite3_step(updateStmt))
NSAssert1(0, @"Error while updating data. '%s'", sqlite3_errmsg(database));
else
{
sqlite3_finalize(updateStmt);
sqlite3_close(database);
}
}
else{
sqlite3_finalize(updateStmt);
sqlite3_close(database);
}
}
-(void)DeleteSLCData
{
sqlite3_stmt *deleteStmnt = nil;
if(sqlite3_open([[self getDBPath] UTF8String],&database) == SQLITE_OK)
{
if(deleteStmnt == nil)
{
const char *sql = "delete from ImportSLC";
if(sqlite3_prepare_v2(database, sql, -1, &deleteStmnt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating delete statement. '%s'", sqlite3_errmsg(database));
}
if (SQLITE_DONE != sqlite3_step(deleteStmnt))
NSAssert1(0, @"Error while deleting. '%s'", sqlite3_errmsg(database));
else{
sqlite3_finalize(deleteStmnt);
sqlite3_close(database);
}
}
else{
sqlite3_finalize(deleteStmnt);
sqlite3_close(database);
}
}
-(NSMutableArray *)GetSLCDetails
{
sqlite3_stmt *selectStmt = nil;
NSMutableArray *slcArray = [[NSMutableArray alloc] init];
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
const char *sql = "SELECT * FROM ImportSLC";
//NSLog(@"QUERY : %s",sql);
if (sqlite3_prepare_v2(database, sql, -1, &selectStmt, NULL) == SQLITE_OK)
{
while (sqlite3_step(selectStmt) == SQLITE_ROW)
{
CustomData *objDetail=[[CustomData alloc] init];
objDetail.strSLC_ID=((char *)sqlite3_column_text(selectStmt,0) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 0)];
objDetail.strMAC_ID=((char *)sqlite3_column_text(selectStmt,1) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 1)];
objDetail.strSLC_NAME=((char *)sqlite3_column_text(selectStmt,2) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 2)];
[slcArray addObject:objDetail];
}
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
else{
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
}
return slcArray;
}
//-----------------------------------------------------------------------------------
-(NSString *)Get_SLC_ID : (NSString *)SLC_Name
{
sqlite3_stmt *selectStmt = nil;
NSString *strSLC_ID;
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
const char *sql = "SELECT slc_id FROM ImportSLC WHERE slc_name=?";
//NSLog(@"QUERY : %s",sql);
if (sqlite3_prepare_v2(database, sql, -1, &selectStmt, NULL) == SQLITE_OK)
{
sqlite3_bind_text(selectStmt, 1, [SLC_Name UTF8String], -1, SQLITE_TRANSIENT);
while (sqlite3_step(selectStmt) == SQLITE_ROW)
{
strSLC_ID=((char *)sqlite3_column_text(selectStmt,0) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 0)];
}
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
else{
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
}
return strSLC_ID;
}
//--------------------------------------------------------------------------------------------------------------
//--------------------------------- Motion Group Method --------------------------------------------------------
//--------------------------------------------------------------------------------------------------------------
#pragma mark - ADD & DELETE SLC_Mtion_GROUP DATA.
-(void)Add_SLC_Motion_Group_Data : (CustomData *)objDetail
{
sqlite3_stmt *addStmt = nil;
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
if (addStmt == nil) {
const char *sql = "INSERT INTO SLC_MotionGrp (motion_group_name, motion_slc_id, motion_mac_id, motion_slc_name, motion_group_id) values (?, ?, ?, ?, ?)";
if (sqlite3_prepare_v2(database, sql, -1, &addStmt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating add statement. '%s'",sqlite3_errmsg(database));
}
sqlite3_bind_text(addStmt, 1, [objDetail.strSLC_GROUP_NAMEForMotion UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 2, [objDetail.strSLC_IDForMotion UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 3, [objDetail.strMAC_IDForMotion UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 4, [objDetail.strSLC_NAMEForMotion UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 5, [objDetail.strSLC_GROUP_IDForMotion UTF8String], -1, SQLITE_TRANSIENT);
if (SQLITE_DONE != sqlite3_step(addStmt))
NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(database));
else
{
sqlite3_finalize(addStmt);
sqlite3_close(database);
}
}
else{
sqlite3_finalize(addStmt);
sqlite3_close(database);
}
}
-(void)UpdateSLC_Motion_Data : (CustomData *)objDetail : (NSString *)GRP_ID
{
sqlite3_stmt *updateStmt = nil;
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
if (updateStmt == nil) {
const char *sql = "UPDATE SLC_MotionGrp SET motion_group_name =?, motion_slc_id =?, motion_mac_id =?, motion_slc_name =? where motion_group_id = ?";
if (sqlite3_prepare_v2(database, sql, -1, &updateStmt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating add statement. '%s'",sqlite3_errmsg(database));
}
sqlite3_bind_text(updateStmt, 1, [objDetail.strSLC_GROUP_NAMEForMotion UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 2, [objDetail.strSLC_IDForMotion UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 3, [objDetail.strMAC_IDForMotion UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 4, [objDetail.strSLC_NAMEForMotion UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 5, [GRP_ID UTF8String], -1, SQLITE_TRANSIENT);
if (SQLITE_DONE != sqlite3_step(updateStmt))
NSAssert1(0, @"Error while updating data. '%s'", sqlite3_errmsg(database));
else
{
sqlite3_finalize(updateStmt);
sqlite3_close(database);
}
}
else{
sqlite3_finalize(updateStmt);
sqlite3_close(database);
}
}
-(void)Delete_SLC_Motion_Group_Data : (NSString *)Group_Name
{
sqlite3_stmt *deleteStmnt = nil;
if(sqlite3_open([[self getDBPath] UTF8String],&database) == SQLITE_OK)
{
if(deleteStmnt == nil)
{
const char *sql = "delete from SLC_MotionGrp where motion_group_name = ?";
if(sqlite3_prepare_v2(database, sql, -1, &deleteStmnt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating delete statement. '%s'", sqlite3_errmsg(database));
}
sqlite3_bind_text(deleteStmnt, 1, [Group_Name UTF8String], -1, SQLITE_TRANSIENT);
if (SQLITE_DONE != sqlite3_step(deleteStmnt))
NSAssert1(0, @"Error while deleting. '%s'", sqlite3_errmsg(database));
else{
sqlite3_finalize(deleteStmnt);
sqlite3_close(database);
}
}
else{
sqlite3_finalize(deleteStmnt);
sqlite3_close(database);
}
}
-(NSMutableArray *)Get_SLC_Motion_Group_Name
{
sqlite3_stmt *selectStmt = nil;
NSMutableArray *slcArray = [[NSMutableArray alloc] init];
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
const char *sql = "SELECT * FROM SLC_MotionGrp";
//NSLog(@"QUERY : %s",sql);
if (sqlite3_prepare_v2(database, sql, -1, &selectStmt, NULL) == SQLITE_OK)
{
while (sqlite3_step(selectStmt) == SQLITE_ROW)
{
NSString *strSLC_GROUP_NAME=((char *)sqlite3_column_text(selectStmt,0) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 0)];
[slcArray addObject:strSLC_GROUP_NAME];
}
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
else{
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
}
return slcArray;
}
// Get Detail Of Group Id
-(NSMutableArray *)Get_SLC_Group_ID
{
sqlite3_stmt *selectStmt = nil;
NSMutableArray *slcIDArray = [[NSMutableArray alloc] init];
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
const char *sql = "SELECT * FROM SLC_MotionGrp";
//NSLog(@"QUERY : %s",sql);
if (sqlite3_prepare_v2(database, sql, -1, &selectStmt, NULL) == SQLITE_OK)
{
while (sqlite3_step(selectStmt) == SQLITE_ROW)
{
NSString *strSLC_GROUP_ID=((char *)sqlite3_column_text(selectStmt,4) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 4)];
[slcIDArray addObject:strSLC_GROUP_ID];
}
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
else{
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
}
return slcIDArray;
}
-(NSString *)Get_GROUP_SLC_Motion_NAME : (NSString *)Group_Name
{
sqlite3_stmt *selectStmt = nil;
NSString *strSLC_NAME;
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
const char *sql = "SELECT motion_slc_name FROM SLC_MotionGrp WHERE motion_group_name=?";
//NSLog(@"QUERY : %s",sql);
if (sqlite3_prepare_v2(database, sql, -1, &selectStmt, NULL) == SQLITE_OK)
{
sqlite3_bind_text(selectStmt, 1, [Group_Name UTF8String], -1, SQLITE_TRANSIENT);
while (sqlite3_step(selectStmt) == SQLITE_ROW)
{
strSLC_NAME=((char *)sqlite3_column_text(selectStmt,0) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 0)];
}
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
else{
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
}
return strSLC_NAME;
}
-(CustomData *)Get_SLC_Motion_Group_Details : (NSString *)Group_Name
{
sqlite3_stmt *selectStmt = nil;
objDetail = [[CustomData alloc] init];
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
const char *sql = "SELECT * FROM SLC_MotionGrp where motion_group_name = ?";
//NSLog(@"QUERY : %s",sql);
if (sqlite3_prepare_v2(database, sql, -1, &selectStmt, NULL) == SQLITE_OK)
{
sqlite3_bind_text(selectStmt, 1, [Group_Name UTF8String], -1, SQLITE_TRANSIENT);
while (sqlite3_step(selectStmt) == SQLITE_ROW)
{
objDetail.strSLC_GROUP_NAMEForMotion=((char *)sqlite3_column_text(selectStmt,0) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 0)];
objDetail.strSLC_IDForMotion=((char *)sqlite3_column_text(selectStmt,1) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 1)];
objDetail.strMAC_IDForMotion=((char *)sqlite3_column_text(selectStmt,2) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 2)];
objDetail.strSLC_NAMEForMotion=((char *)sqlite3_column_text(selectStmt,3) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 3)];
objDetail.strSLC_GROUP_IDForMotion=((char *)sqlite3_column_text(selectStmt,4) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 4)];
}
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
else{
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
}
return objDetail;
}
-(NSString *)Get_SLC_From_GroupID : (NSString *)Group_ID
{
sqlite3_stmt *selectStmt = nil;
NSString *strSLC_NAME;
if (sqlite3_open([[self getDBPath] UTF8String], &database) == SQLITE_OK)
{
const char *sql = "SELECT motion_slc_id FROM SLC_MotionGrp WHERE motion_group_id=?";
//NSLog(@"QUERY : %s",sql);
if (sqlite3_prepare_v2(database, sql, -1, &selectStmt, NULL) == SQLITE_OK)
{
sqlite3_bind_text(selectStmt, 1, [Group_ID UTF8String], -1, SQLITE_TRANSIENT);
while (sqlite3_step(selectStmt) == SQLITE_ROW)
{
strSLC_NAME=((char *)sqlite3_column_text(selectStmt,0) == NULL) ? @"" : [NSString stringWithUTF8String : (char *)sqlite3_column_text(selectStmt, 0)];
}
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
else{
sqlite3_finalize(selectStmt);
sqlite3_close(database);
}
}
return strSLC_NAME;
}
//---------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------
- (void) SaveImagesToSql: (NSData*) imgData :(NSString*) mainUrl
{
NSLog( @"\n*****Save image to SQLite*****\n" );
const char* sqliteQuery = "INSERT INTO IMAGES (name, IMAGE) VALUES (?, ?)";
sqlite3_stmt* statement;
if( sqlite3_prepare_v2(database, sqliteQuery, -1, &statement, NULL) == SQLITE_OK )
{
sqlite3_bind_text(statement, 1, [mainUrl UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_blob(statement, 2, [imgData bytes], [imgData length], SQLITE_TRANSIENT);
sqlite3_step(statement);
}
else NSLog( @"SaveBody: Failed from sqlite3_prepare_v2. Error is: %s", sqlite3_errmsg(database) );
// Finalize and close database.
sqlite3_finalize(statement);
}
- (NSData*) LoadImagesFromSql: (NSString*) imageLink
{
NSLog( @"\n*****Load image From SQLite*****\n" );
NSData* data = nil;
NSString* sqliteQuery = [NSString stringWithFormat:@"SELECT IMAGE FROM IMAGES WHERE name = '%@'", imageLink];
sqlite3_stmt* statement;
if( sqlite3_prepare_v2(database, [sqliteQuery UTF8String], -1, &statement, NULL) == SQLITE_OK )
{
if( sqlite3_step(statement) == SQLITE_ROW )
{
int length = sqlite3_column_bytes(statement, 0);
data = [NSData dataWithBytes:sqlite3_column_blob(statement, 0) length:length];
}
}
// Finalize and close database.
sqlite3_finalize(statement);
return data;
}
//---------------------------------------------------------------------------------------------------
@end
Note :- Here ViewControllers File Implement For Use Methods in Database
ViewController.h :-
{
Database *objDB;
CustomData *objCustomData;
}
ViewController.m :-
//---------------------------------------- Import slc data.
For Add & Delete SLC Data :-
NSMutableArray *OldSLCAry = [[NSMutableArray alloc] init];
objDB = [[Database alloc] init];
OldSLCAry = [objDB GetSLCDetails];
// Get Data From Array - OldSLCAry
for (int i = 0; i < OldSLCAry.count; i++)
{
NSString * strSLC_ID = [OldSLCAry objectAtIndex:i] strSLC_ID] ;
NSString * strMAC_ID = [OldSLCAry objectAtIndex:i] strMAC_ID] ;
NSString * strSLC_NAME = [OldSLCAry objectAtIndex:i] strSLC_NAME] ;
}
//Delete Main SLC data.
[objDB DeleteSLCData];
CustomData *objCustomData = [[CustomData alloc] init];
objCustomData.strSLC_ID = [NSString stringWithFormat:@"1"];
objCustomData.strMAC_ID = [NSString stringWithFormat:@"2"];
objCustomData.strSLC_NAME = [NSString stringWithFormat:@"3"];
[objDB AddSLCData:objCustomData];
For Update SLC Data :-
//Update slc_name.
Database *objData = [[Database alloc] init];
[objData UpdateSLCData:currentTextField.text:self.strMac_ID];
For Get SLCID Data :-
NSString *strID = [objDB Get_SLC_ID:[Group_SLC_Name_Motion_Ary objectAtIndex:indexPath.row]];
//--------------------- ADD & DELETE SLC_Mtion_GROUP DATA.
For Add Data :-
objDB = [[Database alloc] init];
objCustomData = [[CustomData alloc] init];
objCustomData.strSLC_GROUP_NAMEForMotion = groupNameTextField.text;
objCustomData.strSLC_IDForMotion = strMult_SLC_ID;
objCustomData.strSLC_NAMEForMotion = strMult_SLC_Name;
objCustomData.strMAC_IDForMotion = strMult_MAC_ID;
objCustomData.strSLC_GROUP_IDForMotion = strGroupIdData ;
[objDB Add_SLC_Motion_Group_Data:objCustomData];
For Update Data :-
objDB = [[Database alloc] init];
objCustomData = [[CustomData alloc] init];
objCustomData.strSLC_GROUP_NAMEForMotion = groupNameTextField.text;
objCustomData.strSLC_IDForMotion = strMult_SLC_ID;
objCustomData.strSLC_NAMEForMotion = strMult_SLC_Name;
objCustomData.strMAC_IDForMotion = strMult_MAC_ID;
[objDB UpdateSLC_Motion_Data:objCustomData :strGroupIdData];
For Delete & Get Detail of Data :-
objDB = [[Database alloc] init];
[objDB Delete_SLC_Motion_Group_Data:self.strGROUP_NAMEForMotion];
NSMutableArray *Group_Name_Motion_Ary = [[NSMutableArray alloc] init];
Group_Name_Motion_Ary = [objDB Get_SLC_Motion_Group_Name];
NSLog(@"%@",Group_Name_Motion_Ary);
For Get Data By Specific Name :-
objDB = [[Database alloc] init];
objCustomData = [[CustomData alloc] init];
objCustomData = [objDB Get_SLC_Motion_Group_Details:GrpNameForPushData];
NSString *strGroupIdData = objCustomData.strSLC_GROUP_IDForMotion ;
No comments:
Post a Comment