Student

+(NSMutableArray *) getData : (NSString *) actionType : (NSMutableDictionary *) data
{
	NSString *sql;
	NSMutableArray *db_result=[[NSMutableArray alloc] init];
	if([actionType isEqualToString:@"students"] )
	{
		//NSLog(@"hii");
		sql=[NSString stringWithFormat:@"Select *,rowid from Student"];
		//NSLog(@"%@",sql);
		db_result=[DBOperation selectData:sql];
		//NSLog(@"%@",[db_result description]);
	}
	else if ([actionType isEqualToString:@"addstudent"]) {

		NSMutableDictionary *tmp_dict = [[NSMutableDictionary alloc] init];
		sql=[NSString stringWithFormat:@"INSERT INTO Student (Name, Rollno) VALUES ('%@','%@')",
			 [data valueForKey:@"stdname"],
			 [data valueForKey:@"stdrollno"]
			 ];
		BOOL flag;
		flag=[DBOperation executeSQL:sql];
		if (flag) {
			[tmp_dict setObject:@"1" forKey:@"success"];
			[db_result addObject:tmp_dict];
			[tmp_dict release];
		}
		else {
			[tmp_dict setObject:@"0" forKey:@"Error"];
			[db_result addObject:tmp_dict];
			[tmp_dict release];
		}

	}
	else if ([actionType isEqualToString:@"updatestudent"]) {

		NSMutableDictionary *tmp_dict = [[NSMutableDictionary alloc] init];
		sql=[NSString stringWithFormat:@"update Student set Name='%@',Rollno='%@' where rowid='%@'",
			 [data valueForKey:@"stdname"],
			 [data valueForKey:@"stdrollno"],
			 [data valueForKey:@"row_id"]
			 ];
		BOOL flag;
		flag=[DBOperation executeSQL:sql];
		if (flag) {
			[tmp_dict setObject:@"1" forKey:@"success"];
			[db_result addObject:tmp_dict];
			[tmp_dict release];
		}
		else {
			[tmp_dict setObject:@"0" forKey:@"Error"];
			[db_result addObject:tmp_dict];
			[tmp_dict release];
		}
	}
	else if ([actionType isEqualToString:@"delete_data"]) {
		NSLog(@"%@",data);
		NSMutableDictionary *tmp_dict = [[NSMutableDictionary alloc] init];
		sql=[NSString stringWithFormat:@"delete from Student  where rowid='%@'",
			 [data valueForKey:@"row_id"]
			 ];
		BOOL flag;
		flag=[DBOperation executeSQL:sql];
		if (flag) {
			[tmp_dict setObject:@"1" forKey:@"success"];
			[db_result addObject:tmp_dict];
			[tmp_dict release];
		}
		else {
			[tmp_dict setObject:@"0" forKey:@"Error"];
			[db_result addObject:tmp_dict];
			[tmp_dict release];
		}
	}
	return db_result;
}