private static void CreateNewContact(SQLiteCrud sql)
{
FullContactModel nc = new FullContactModel
{
BasicInfo = new BasicContactModel
{
FirstName = "ncFname",
LastName = "ncLname"
}
};
nc.EmailAddresses.Add(new EmailAddressModel {
EmailAddress = "*****@*****.**"
});
nc.EmailAddresses.Add(new EmailAddressModel {
Id = 2, EmailAddress = "*****@*****.**"
});
nc.PhoneNumbers.Add(new PhoneNumberModel {
PhoneNumber = "555-213-3333"
});
nc.PhoneNumbers.Add(new PhoneNumberModel {
Id = 1, PhoneNumber = "555-123-1111"
});
sql.CreateContact(nc);
}
private static void ReadAllPeople(SQLiteCrud sqlite)
{
var people = sqlite.LoadAllPeople();
foreach (var person in people)
{
Console.WriteLine($"{person.Id}: {person.FirstName} {person.LastName}");
}
}
private static void ReadAllContacts(SQLiteCrud sql)
{
//calls sqlcrud to get all contacts
var rows = sql.GetAllContacts();
foreach (var i in rows)
{
Console.WriteLine($"Id: {i.Id}, FirstName: {i.FirstName}, LastName: {i.LastName}");
}
}
private static void ReadFullPerson(SQLiteCrud sqlite, int id)
{
FullPersonModel person = sqlite.LoadFullPersonInfo(id);
Console.WriteLine($"{person.Id}: {person.FirstName} {person.LastName}");
foreach (var address in person.Addresses)
{
Console.WriteLine($"\t{address.Street} {address.City}");
}
}
private static void UpdateContact(SQLiteCrud sql)
{
BasicContactModel contact = new BasicContactModel
{
Id = 1,
FirstName = "fName1z",
LastName = "lName1"
};
sql.UpdateContactName(contact);
}
static void Main(string[] args)
{
var sqlite = new SQLiteCrud(new SQLiteDataAccess(), GetConnectionString());
// ReadAllPeople(sqlite);
// ReadPerson(sqlite, 1);
SaveFullPerson(sqlite);
ReadFullPerson(sqlite, 4);
Console.WriteLine("Sqlite demo");
Console.ReadLine();
}
static void Main(string[] args)
{
//test connstring
//Console.WriteLine(GetConnectionString());
//instance of sqlcrud class, and pass in connstring
SQLiteCrud sql = new SQLiteCrud(GetConnectionString());
//ReadAllContacts(sql);
//CreateNewContact(sql);
//ReadContact(sql, 2);
//UpdateContact(sql);
//RemovePhoneNumberFromContact(sql, 1, 1);
Console.WriteLine("done sqlite");
Console.ReadLine();
}
private static void SaveFullPerson(SQLiteCrud sqlite)
{
var addresses = new List <AddressModel>();
addresses.Add(new AddressModel {
Street = "Street1", City = "City1"
});
addresses.Add(new AddressModel {
Street = "Street2", City = "City2"
});
var person = new FullPersonModel
{
FirstName = "Tim",
LastName = "Corey",
Addresses = addresses
};
sqlite.SaveFullPerson(person);
}
private static void ReadContact(SQLiteCrud sql, int id)
{
var contact = sql.GetFullContactById(id);
Console.WriteLine($"Id: {contact.BasicInfo.Id}, FirstName: {contact.BasicInfo.FirstName}, LastName: {contact.BasicInfo.LastName}");
}
private static void RemovePhoneNumberFromContact(SQLiteCrud sql, int contactId, int phoneNumberId)
{
sql.RemovePhoneNumber(contactId, phoneNumberId);
}
private static void ReadPerson(SQLiteCrud sqlite, int id)
{
var person = sqlite.LoadPerson(id);
Console.WriteLine($"{person.Id}: {person.FirstName} {person.LastName}");
}
