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:"); }
private void PhoneBookCollectionTest() { bool b; Phone.PhoneBook.PhoneBookCollection clc = new Phone.PhoneBook.PhoneBookCollection(); List<int> iclc = new List<int>(); foreach (Phone.PhoneBook.PhoneBook cl in clc) { iclc.Add(cl.DBID); } foreach (int icl in iclc) { b = Phone.LocalStorage.DB.SQLCE.DeleteByID("PhoneBook", icl); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.DeleteByID PhoneBook:" + icl.ToString()); } Phone.PhoneBook.PhoneBook phoneBook = new Phone.PhoneBook.PhoneBook(); phoneBook.Name = "User1"; phoneBook.PhoneNumber = "13912345671"; phoneBook.Unit = "user Unit"; b = Phone.LocalStorage.DB.SQLCE.InsertPhoneBook(phoneBook); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.SaveClassToDB PhoneBook:" + b.ToString()); phoneBook = new Phone.PhoneBook.PhoneBook(); phoneBook.Name = "User1"; phoneBook.PhoneNumber = "13912345672"; phoneBook.Unit = "user Unit"; b = Phone.LocalStorage.DB.SQLCE.InsertPhoneBook(phoneBook); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.SaveClassToDB PhoneBook:" + b.ToString()); phoneBook = new Phone.PhoneBook.PhoneBook(); phoneBook.Name = "User1"; phoneBook.PhoneNumber = "13912345673"; phoneBook.Unit = "user Unit"; b = Phone.LocalStorage.DB.SQLCE.InsertPhoneBook(phoneBook); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.SaveClassToDB PhoneBook:" + b.ToString()); phoneBook = new Phone.PhoneBook.PhoneBook(); phoneBook.Name = "User1"; phoneBook.PhoneNumber = "13912345674"; phoneBook.Unit = "user Unit"; b = Phone.LocalStorage.DB.SQLCE.InsertPhoneBook(phoneBook); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.SaveClassToDB PhoneBook:" + b.ToString()); phoneBook.PhoneNumber = "13912345675"; phoneBook.Unit = "user Unit"; b = Phone.LocalStorage.DB.SQLCE.InsertPhoneBook(phoneBook); Debug.WriteLineIf(!b, "Phone.LocalStorage.DB.SQLCE.SaveClassToDB PhoneBook:" + b.ToString()); PhoneBook.PhoneBookCollection pbc = new PhoneBook.PhoneBookCollection(); if (!(pbc.Count==5)) { Debug.WriteLineIf(!b, "Phone.PhoneBook.PhoneBookCollection Count Error:" + b.ToString()); } phoneBook.PhoneNumber = "13912345676"; phoneBook.Unit = "user Unit"; pbc.Insert(0, phoneBook); if (!(pbc.Count == 6)) { Debug.WriteLineIf(!b, "Phone.PhoneBook.PhoneBookCollection Count Error:" + b.ToString()); } if (!pbc.Contains(phoneBook)) { Debug.WriteLineIf(!b, "Phone.PhoneBook.PhoneBookCollection Contains Error:" + b.ToString()); } pbc.Remove(phoneBook); int index=pbc.Add(phoneBook); if (pbc[index]!=phoneBook) { Debug.WriteLineIf(!b, "Phone.PhoneBook.PhoneBookCollection Add Error:" + b.ToString()); } pbc.RemoveAt(index); }