void CAlmSettingsSession::ProcessDataL(void)
{
TInt func=Message().Function();
_LIT(KSQL,"select id,name,cid,value from settings where cid=%u and name='%S'");
RDbView view;
TBuf<128> sql;
TUint32 cid=CategoryL(Message().Ptr0());
HBufC8* param1=ValueLC(Message().Ptr1());
TPtrC name((const TUint16*)param1->Ptr(),param1->Length()/2);
sql.Format(KSQL,cid,&name);
User::LeaveIfError(view.Prepare(iServer.DbL(),TDbQuery(sql),(func==ESettingsServerRequestSet)?RDbView::EUpdatable:RDbView::EReadOnly));
CleanupClosePushL(view);
User::LeaveIfError(view.EvaluateAll());
TBool first=view.FirstL();
if(func==ESettingsServerRequestSet)
{
if(first) view.UpdateL();
else view.InsertL();
CleanupCancelPushL(view);
if(!first)
{
view.SetColL(2,name);
view.SetColL(3,cid);
}
HBufC8* value=ValueLC(Message().Ptr2());
view.SetColL(4,*value);
view.PutL();
CleanupStack::Pop(); //view cancel
CleanupStack::PopAndDestroy(); //value
iServer.Notify();
}
else
{
if(!first) User::Leave(KErrNotFound);
view.GetL();
TInt len=view.ColSize(4);
if(func==ESettingsServerRequestGetData)
{
HBufC8* data=HBufC8::NewLC(len);
TPtr8 ptr(data->Des());
RDbColReadStream stream;
stream.OpenLC(view,4);
stream.ReadL(ptr,len);
Message().WriteL(Message().Ptr2(),ptr);
CleanupStack::PopAndDestroy(2); //stream,data
}
else
{
TPckgC<TInt> size(len);
Message().WriteL(Message().Ptr2(),size);
}
}
CleanupStack::PopAndDestroy(2); //view,param1
}
void XQAccessPointManagerPrivate::storeWPADataL(const TInt aIapId, const TDesC& aPresharedKey, const XQWLAN& aWlan)
{
CCommsDbTableView* wLanServiceTable;
CApUtils* apUtils = CApUtils::NewLC(*ipCommsDB);
TUint32 iapId = apUtils->IapIdFromWapIdL(aIapId);
CleanupStack::PopAndDestroy(apUtils);
TUint32 serviceId;
CCommsDbTableView* iapTable = ipCommsDB->OpenViewMatchingUintLC(TPtrC(IAP),
TPtrC(COMMDB_ID),
iapId);
User::LeaveIfError(iapTable->GotoFirstRecord());
iapTable->ReadUintL(TPtrC(IAP_SERVICE), serviceId);
CleanupStack::PopAndDestroy( iapTable );
wLanServiceTable = ipCommsDB->OpenViewMatchingUintLC(TPtrC(XQ_WLAN_SERVICE),
TPtrC(XQ_WLAN_SERVICE_ID),
serviceId );
TInt errorCode = wLanServiceTable->GotoFirstRecord();
if (errorCode == KErrNone) {
User::LeaveIfError(wLanServiceTable->UpdateRecord());
} else {
TUint32 dummyUid(0);
User::LeaveIfError(wLanServiceTable->InsertRecord(dummyUid));
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_SERVICE_ID), aIapId);
}
CleanupCancelPushL(*wLanServiceTable);
TBool usesPsk(aWlan.usesPreSharedKey());
// Save WPA Mode
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_ENABLE_WPA_PSK), usesPsk);
// Save security mode
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_SECURITY_MODE),
fromQtSecurityModeToS60SecurityMode(aWlan.securityMode()));
// Save PreShared Key
TBuf8<KWpaKeyMaxLength> keyWPA;
//convert to 8 bit
keyWPA.Copy(aPresharedKey);
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_WPA_PRE_SHARED_KEY),keyWPA);
// Check and save PreShared Key Length
TInt len(keyWPA.Length());
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_WPA_KEY_LENGTH),len);
User::LeaveIfError(wLanServiceTable->PutRecordChanges());
CleanupStack::Pop(wLanServiceTable); // table rollback...
CleanupStack::PopAndDestroy(wLanServiceTable);
}
void XQAccessPointManagerPrivate::storeWEPDataL(const TInt aIapId, const TDesC& aPresharedKey)
{
CCommsDbTableView* wLanServiceTable;
CApUtils* apUtils = CApUtils::NewLC(*ipCommsDB);
TUint32 iapId = apUtils->IapIdFromWapIdL(aIapId);
CleanupStack::PopAndDestroy(apUtils);
TUint32 serviceId;
CCommsDbTableView* iapTable = ipCommsDB->OpenViewMatchingUintLC(TPtrC(IAP),
TPtrC(COMMDB_ID),
iapId);
User::LeaveIfError(iapTable->GotoFirstRecord());
iapTable->ReadUintL(TPtrC(IAP_SERVICE), serviceId);
CleanupStack::PopAndDestroy(iapTable);
wLanServiceTable = ipCommsDB->OpenViewMatchingUintLC(TPtrC(XQ_WLAN_SERVICE),
TPtrC(XQ_WLAN_SERVICE_ID),
serviceId);
TInt errorCode = wLanServiceTable->GotoFirstRecord();
if (errorCode == KErrNone) {
User::LeaveIfError(wLanServiceTable->UpdateRecord());
}
else {
TUint32 dummyUid = 0;
User::LeaveIfError(wLanServiceTable->InsertRecord(dummyUid));
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_SERVICE_ID), aIapId);
}
CleanupCancelPushL(*wLanServiceTable);
// Save index of key in use
TUint32 keyInUse(KFirstWepKey);
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_WEP_INDEX), keyInUse);
// Save authentication mode
TUint32 auth(0); // set to open...
if (isS60VersionGreaterThan3_1()) {
//TODO: wLanServiceTable->WriteUintL(TPtrC(NU_WLAN_AUTHENTICATION_MODE), auth);
} else {
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_AUTHENTICATION_MODE), auth);
}
// not we need to convert the key.... to 8bit and to hex... and again detect the required bits..
TBuf8<KMaxWepKeyLen> key;
//convert to 8 bit
key.Copy(aPresharedKey);
TBool useHex(EFalse);
TWepKeyLength keyLength;
TBool validKey = validWepKeyLength(aPresharedKey, useHex, keyLength);
if (!useHex) {
// Must be converted to hexa and stored as a hexa
// Ascii key is half the length of Hex
HBufC8* buf8Conv = HBufC8::NewLC(key.Length() * 2);
asciiToHex(key, buf8Conv);
if (isS60VersionGreaterThan3_1()) {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_HEX_WEP_KEY1), buf8Conv->Des());
} else {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_WEP_KEY1), buf8Conv->Des());
}
CleanupStack::PopAndDestroy(buf8Conv);
} else if (isHex(aPresharedKey)) {
//already in hexa format
if (isS60VersionGreaterThan3_1()) {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_HEX_WEP_KEY1), key);
} else {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_WEP_KEY1), key);
}
}
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_WEP_KEY1_FORMAT), useHex);
key.Zero();
// write default values to the rest of the columns
if (isS60VersionGreaterThan3_1()) {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_HEX_WEP_KEY2),
key);
} else {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_WEP_KEY2),
key );
}
// Save third WEP key
if (isS60VersionGreaterThan3_1()) {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_HEX_WEP_KEY3),
key);
} else {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_WEP_KEY3),
key);
}
// Save fourth WEP key
if (isS60VersionGreaterThan3_1()) {
//TODO: wLanServiceTable->WriteTextL(TPtrC(NU_WLAN_WEP_KEY4),
// key);
} else {
wLanServiceTable->WriteTextL(TPtrC(XQ_WLAN_WEP_KEY4),
key);
}
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_WEP_KEY2_FORMAT),
(TUint32&)useHex);
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_WEP_KEY3_FORMAT),
(TUint32&)useHex);
wLanServiceTable->WriteUintL(TPtrC(XQ_WLAN_WEP_KEY4_FORMAT),
(TUint32&)useHex);
wLanServiceTable->PutRecordChanges();
CleanupStack::Pop(wLanServiceTable); // table rollback...
CleanupStack::PopAndDestroy(wLanServiceTable);
}
