public static void AddAppointment(SimpleAppointment appointment) { var dbPath = System.IO.Path.Combine( Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite"); try { using (var db = new SQLiteConnection(dbPath)) { db.RunInTransaction(() => { db.Insert(new SimpleAppointment() { Id = appointment.Id, Subject = appointment.Subject, Location = appointment.Location, StartDate = appointment.StartDate, EndDate = appointment.EndDate }); } ); } } catch (Exception ex) { throw ex; } }
private async void LoadButton_Click(object sender, RoutedEventArgs e) { SimpleAppointment appointment = (await AzureMobileServicesHelper.GetDataFromAzureMobileSvc()).FirstOrDefault(); SubjectTextBox.Text = appointment.Subject; LocationTextBox.Text = appointment.Location; StartDatePicker.Date = appointment.StartDate; EndDatePicker.Date = appointment.EndDate; }
private void LoadButton_Click(object sender, RoutedEventArgs e) { SimpleAppointment appointment = SQLiteHelper.GetAppointment(1); SubjectTextBox.Text = appointment.Subject; LocationTextBox.Text = appointment.Location; StartDatePicker.Date = appointment.StartDate; EndDatePicker.Date = appointment.EndDate; }
public static void UpdateDataFromAzureMobileSvc(SimpleAppointment item) { try { IMobileServiceTable <SimpleAppointment> table = App.bw8agu_mobileserviceClient.GetTable <SimpleAppointment>(); table.UpdateAsync(item); } catch (Exception ex) { throw ex; } }
public async static void InsertDataFromAzureMobileSvc(SimpleAppointment item) { await App.bw8agu_mobileserviceClient.GetTable <SimpleAppointment>() .InsertAsync(item); }