//Repository public ContactRepository() { //Initialize Connection with Database _dBconnection = DependencyService.Get<ISQLite>().GetConnection(); //Create Contact Table _dBconnection.CreateTable<Contact>(); lock (Locker) { //Checks if database empty //if so, fills with default contacts if (!_dBconnection.Table<Contact>().Any()) { Contact contact; #region Populate Default Contact List contact = new Contact { FirstName = "Avery", LastName = "Jenkins", Type = "Work", DateOfBirth = "11/23/1975" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Brad", LastName = "Pitt", Type = "Friend", DateOfBirth = "3/15/1971" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Barry", LastName = "Zito", Type = "Family", DateOfBirth = "6/4/1983" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Jack", LastName = "Sparrow", Type = "Family", DateOfBirth = "1/15/1965" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Kyle", LastName = "Broflofsky", Type = "School", DateOfBirth = "8/10/1999" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Fred", LastName = "Durst", Type = "Work", DateOfBirth = "12/4/1972" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Marissa", LastName = "Lopez", Type = "Friend", DateOfBirth = "9/1/1986" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Michael", LastName = "Jackson", Type = "Work", DateOfBirth = "8/29/1958" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Stephon", LastName = "Diggs", Type = "Work", DateOfBirth = "11/23/1993" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Gary", LastName = "Buesey", Type = "School", DateOfBirth = "3/14/1953" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Kyle", LastName = "Lobb", Type = "Family", DateOfBirth = "5/6/1986" }; _dBconnection.Insert(contact); contact = new Contact { FirstName = "Jessica", LastName = "Alba", Type = "School", DateOfBirth = "4/12/1979" }; _dBconnection.Insert(contact); #endregion } } }
public int DeleteContact(Contact contact) { lock (Locker) { return _dBconnection.Delete<Contact>(contact.Id); } }
public int SaveContact(Contact contact) { lock (Locker) { if (contact.Id != 0) { _dBconnection.Update(contact); return contact.Id; } return _dBconnection.Insert(contact); } }
public void AddContact(string firstName, string lastName, string type, string date) { var newContact = new Contact { FirstName = firstName, LastName = lastName, Type = type, DateOfBirth = date }; lock (Locker) { _dBconnection.Insert(newContact); } }