// Insert the new contact in the Contacts table. public void Insert(makinat newcontact) { using (var dbConn = new SQLiteConnection(App.DB_PATH)) { dbConn.RunInTransaction(() => { dbConn.Insert(newcontact); }); } }
private void listBoxobj_SelectionChanged(object sender, SelectionChangedEventArgs e) { int SelectedContactID = 0; if (listBoxobj.SelectedIndex != -1) { makinat listitem = listBoxobj.SelectedItem as makinat;//Get slected listbox item contact ID Frame.Navigate(typeof(makinaDetail), SelectedContactID = listitem.Id); } }
//Update existing conatct public void UpdateContact(makinat contact) { using (var dbConn = new SQLiteConnection(App.DB_PATH)) { var existingconact = dbConn.Query <makinat>("select * from makinat where Id =" + contact.Id).FirstOrDefault(); if (existingconact != null) { existingconact.sqMakina = contact.sqMakina; existingconact.sqTarga = contact.sqTarga; existingconact.sqShasia = contact.sqShasia; dbConn.RunInTransaction(() => { dbConn.Update(existingconact); }); } } }