// 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);
});
}
}
}
