public void GetMessageC1()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
MessageRepository messageRepository = new MessageRepository(con);
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Chat m = new Chat
{
Id = 0,
Mensaje = "hola",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
messageRepository.InsertMessage(m);
var result = messageRepository.GetMessages().Count;
Assert.AreEqual(1, result);
}
}
public void CheckExistFromContact()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
MessageRepository messageRepository = new MessageRepository(con);
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Chat m = new Chat
{
Mensaje = "hola",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now,
Seen = true
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
messageRepository.InsertMessage(m);
var result = messageRepository.CheckExistFromContact("34666666666");
Assert.IsFalse(result);
}
}
protected override void OnResume()
{
base.OnResume();
FakeSessionDelete = new FakeSessionDelete();
database = new SQLiteRepository();
userRepo = new UserRepository(database);
contactRepo = new ContactRepository(database);
configRepo = new ConfigRepository(database);
database.CreateDatabase();
loginService = new LoginService();
contactService = new ContactService();
errorText = new ErrorText();
if (_continue)
{
speechReco = SpeechRecognizer.CreateSpeechRecognizer(this.ApplicationContext);
speechReco.SetRecognitionListener(this);
intentReco = new Intent(RecognizerIntent.ActionRecognizeSpeech);
intentReco.PutExtra(RecognizerIntent.ExtraLanguagePreference, "es");
intentReco.PutExtra(RecognizerIntent.ExtraCallingPackage, this.PackageName);
intentReco.PutExtra(RecognizerIntent.ExtraLanguageModel, RecognizerIntent.LanguageModelWebSearch);
intentReco.PutExtra(RecognizerIntent.ExtraMaxResults, 1);
toSpeech = new TextToSpeech(this, this);
}
}
public void GetContactC2()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Contact contact1 = new Contact
{
Id = 2,
FirstName = "Aa",
LastName = "Mama",
Phone = "34692511479"
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
contactRepository.InsertContact(contact1);
var result = contactRepository.GetContacts().Count;
Assert.AreNotEqual(1, result);
}
}
public void DeleteContact()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420",
Status = "Offline",
Blocked = false
};
Contact contact1 = new Contact
{
Id = 1,
FirstName = "Pableras",
LastName = "Corral",
Phone = "34666666666",
Status = "Offline",
Blocked = true
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
contactRepository.InsertContact(contact1);
var result = contactRepository.DeleteContact(contact1);
var list = contactRepository.GetContacts();
Assert.AreEqual(1, list.Count);
}
}
public void GetMessageC3()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
MessageRepository messageRepository = new MessageRepository(con);
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Contact c = new Contact
{
Id = 2,
FirstName = "Cristina",
LastName = "Gambin",
Phone = "34666666666"
};
Chat m = new Chat
{
Mensaje = "hola",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now
};
Chat m1 = new Chat
{
Mensaje = "hola, que tal?",
FromTo = "34676681420",
Send = false,
Created = DateTime.Now.AddSeconds(10)
};
Chat m2 = new Chat
{
Mensaje = "hola, que tal?",
FromTo = "34666666666",
Send = false,
Created = DateTime.Now.AddSeconds(10)
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
contactRepository.InsertContact(c);
messageRepository.InsertMessage(m);
messageRepository.InsertMessage(m1);
messageRepository.InsertMessage(m2);
var result = messageRepository.GetMessagesByPhone("34676681420").Count;
Assert.AreEqual(2, result);
}
}
public void GetMessagesByPhoneAndDate()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
MessageRepository messageRepository = new MessageRepository(con);
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Chat m = new Chat
{
Mensaje = "hola",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now.AddDays(-4),
Seen = true
};
Chat m1 = new Chat
{
Mensaje = "que tal estas",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now.AddDays(-3),
Seen = true
};
Chat m2 = new Chat
{
Mensaje = "donde vamos",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now,
Seen = true
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
messageRepository.InsertChat(m);
messageRepository.InsertChat(m1);
messageRepository.InsertChat(m2);
var result = messageRepository.GetMessagesByPhoneAndDate("34676681420", DateTime.Now.AddDays(-1));
Assert.AreEqual(1, result.Count);
}
}
public void GetContactsByNameWithChat()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
MessageRepository messageRepository = new MessageRepository(con);
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Contact c = new Contact
{
Id = 2,
FirstName = "Cristina",
LastName = "Gambin",
Phone = "34666666666"
};
Chat m = new Chat
{
Mensaje = "hola",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now,
Seen = true
};
Chat m1 = new Chat
{
Mensaje = "hola",
FromTo = "34666666666",
Send = true,
Created = DateTime.Now,
Seen = true
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
contactRepository.InsertContact(c);
messageRepository.InsertMessage(m);
messageRepository.InsertMessage(m1);
var result = contactRepository.GetContactsByNameWithChat("Pablo");
Assert.AreEqual(1, result.Count);
}
}
public void GetUser()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
UserRepository userRepo = new UserRepository(con);
User user = new User
{
Phone = "34655095818"
};
using (var connection = con.GetConnection())
{
userRepo.InsertUser(user);
var result = userRepo.GetUser();
Assert.AreEqual("34655095818", result.Phone);
}
}
public void GetConfig()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
ConfigRepository configRepository = new ConfigRepository(con);
Config c = new Config()
{
Phone = "34676681420",
Voz = false,
Velocidad = (float)0.5
};
using (var connection = con.GetConnection())
{
configRepository.InsertConfig(c);
var result = configRepository.GetConfig();
Assert.AreEqual(false, result.Voz);
}
}
public void GetContactsStatus()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420",
Status = "Offline"
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
var result = contactRepository.GetContactsStatus();
Assert.AreEqual("Pablo Corral - Offline", result[0]);
}
}
public void GetContactsName()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Contact contact1 = new Contact
{
Id = 2,
FirstName = "Aa",
LastName = "Mama",
Phone = "34692511479"
};
Contact contact2 = new Contact
{
Id = 3,
FirstName = "Pablo",
LastName = "No existe",
Phone = "34666666666"
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
contactRepository.InsertContact(contact1);
contactRepository.InsertContact(contact2);
var result = contactRepository.GetContactsName();
Assert.AreEqual("Aa Mama", result[0]);
}
}
public void GetMessagesOrdered()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
MessageRepository messageRepository = new MessageRepository(con);
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Contact c = new Contact
{
Id = 2,
FirstName = "Cristina",
LastName = "Gambin",
Phone = "34666666666"
};
Contact c1 = new Contact
{
Id = 3,
FirstName = "Zoe",
LastName = "",
Phone = "34677777777"
};
Chat m = new Chat
{
Mensaje = "hola",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now.AddDays(-4).AddHours(-5),
Seen = false
};
Chat m1 = new Chat
{
Mensaje = "hola, que tal?",
FromTo = "34676681420",
Send = false,
Created = DateTime.Now.AddDays(-3).AddHours(-4),
Seen = false
};
Chat m2 = new Chat
{
Mensaje = "soy pablo",
FromTo = "34676681420",
Send = false,
Created = DateTime.Now.AddDays(-3).AddHours(-2),
Seen = false
};
Chat m3 = new Chat
{
Mensaje = "hola, que tal pau?",
FromTo = "34666666666",
Send = false,
Created = DateTime.Now.AddDays(-3),
Seen = false
};
Chat m4 = new Chat
{
Mensaje = "soy cristina",
FromTo = "34666666666",
Send = false,
Created = DateTime.Now.AddDays(-2),
Seen = false
};
Chat m5 = new Chat
{
Mensaje = "soy zoe",
FromTo = "34677777777",
Send = false,
Created = DateTime.Now.AddDays(-2),
Seen = false
};
Chat m6 = new Chat
{
Mensaje = "holii",
FromTo = "34677777777",
Send = false,
Created = DateTime.Now.AddDays(-1),
Seen = false
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
contactRepository.InsertContact(c);
contactRepository.InsertContact(c1);
messageRepository.InsertChat(m);
messageRepository.InsertChat(m1);
messageRepository.InsertChat(m2);
messageRepository.InsertChat(m3);
messageRepository.InsertChat(m4);
messageRepository.InsertChat(m5);
messageRepository.InsertChat(m6);
var result = messageRepository.GetMessagesOrdered();
Assert.AreEqual(result[0].Mensaje, "holii");
}
}
