private void SaveClassToDBTest() { bool b; Phone.CallLog.CallLog callLog = new Phone.CallLog.CallLog(); callLog.CallIDType = CallLog.CallerIDType.Available; callLog.CallType = CallLog.CallType.Incoming; callLog.Connected = true; callLog.Ended = true; callLog.EndTime = DateTime.Now; callLog.Name = "Test Name"; callLog.NameType = "Home"; callLog.Note = "Note null"; callLog.Number = "13912345678"; callLog.OutGoing = false; callLog.Roaming = true; callLog.StartTime = DateTime.Now.AddMinutes(-5); b=Phone.LocalStorage.DB.SQLCE.InsertCallLog(callLog); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.SaveClassToDB CallLog:" + b.ToString()); Phone.PhoneBook.PhoneBook phoneBook = new Phone.PhoneBook.PhoneBook(); phoneBook.Name = "User1"; phoneBook.PhoneNumber = "13912345678"; phoneBook.Unit = "user Unit"; b = Phone.LocalStorage.DB.SQLCE.InsertPhoneBook(phoneBook); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.SaveClassToDB PhoneBook:" + b.ToString()); Phone.SMS.SMSMessage smsMessage = new Phone.SMS.SMSMessage(); smsMessage.Address = "Address 1"; smsMessage.MessageStatus = SMS.MessageStatus.UnRead; smsMessage.MessageText = @"message test asdfasdfasdfasfdasdfasdfasdfasdfasdfasdfasdfasdfasdf"; smsMessage.ReceiveTime = DateTime.Now; b = Phone.LocalStorage.DB.SQLCE.InsertSMSMessage(smsMessage); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.SaveClassToDB SMSMessage:" + b.ToString()); }
private void GetObjectByIDTest() { object obj; Phone.CallLog.CallLog callLog = new Phone.CallLog.CallLog(); callLog.DBID = 3; callLog.CallIDType = CallLog.CallerIDType.Available; callLog.CallType = CallLog.CallType.Incoming; callLog.Connected = true; callLog.Ended = true; callLog.EndTime = DateTime.Now; callLog.Name = "Test Name"; callLog.NameType = "Home"; callLog.Note = "Note null"; callLog.Number = "13912345678"; callLog.OutGoing = false; callLog.Roaming = true; callLog.StartTime = DateTime.Now.AddMinutes(-5); obj = Phone.LocalStorage.DB.SQLCE.GetObjectByID("CallLog", 3); Debug.WriteLineIf(obj != (object)callLog, "Phone.LocalStorage.DB.SQLCE.GetObjectByID CallLog:"); Phone.PhoneBook.PhoneBook phoneBook = new Phone.PhoneBook.PhoneBook(); phoneBook.DBID = 3; phoneBook.Name = "User1"; phoneBook.PhoneNumber = "13912345678"; phoneBook.Unit = "user Unit"; obj = Phone.LocalStorage.DB.SQLCE.GetObjectByID("PhoneBook", 3); Debug.WriteLineIf(obj != (object)phoneBook, "Phone.LocalStorage.DB.SQLCE.GetObjectByID PhoneBook:"); Phone.SMS.SMSMessage smsMessage = new Phone.SMS.SMSMessage(); smsMessage.DBID = 3; smsMessage.Address = "Address 1"; smsMessage.MessageStatus = SMS.MessageStatus.UnRead; smsMessage.MessageText = @"message test asdfasdfasdfasfdasdfasdfasdfasdfasdfasdfasdfasdfasdf"; smsMessage.ReceiveTime = DateTime.Now; obj = Phone.LocalStorage.DB.SQLCE.GetObjectByID("SMSMessage", 3); Debug.WriteLineIf(obj != (object)smsMessage, "Phone.LocalStorage.DB.SQLCE.GetObjectByID SMSMessage:"); }