private void btnAdd_Click(object sender, RoutedEventArgs e)
{
if (FieldValidationExtensions.GetIsValid(AddressbookUserName) && FieldValidationExtensions.GetIsValid(AddressbookEmail))
{
var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
using (var db = new SQLite.SQLiteConnection(dbPath))
{
db.CreateTable <AddressBookEntree>();
User addressbookuser = new User();
addressbookuser.UserName = AddressbookUserName.Text;
addressbookuser.EmailAddress = AddressbookEmail.Text;
db.RunInTransaction(() =>
{
db.Insert(addressbookuser);
db.Insert(new AddressBookEntree()
{
OwnerUserID = App.loggedInUser.Id, EntreeUserID = addressbookuser.Id
});
});
}
}
this.Frame.Navigate(typeof(Dashboard));
}
private void btnRegister_Click(object sender, RoutedEventArgs e)
{
if (FieldValidationExtensions.GetIsValid(RegisterUserName) && FieldValidationExtensions.GetIsValid(RegisterPassword) && FieldValidationExtensions.GetIsValid(RegisterEmail))
{
var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
using (var db = new SQLite.SQLiteConnection(dbPath))
{
db.CreateTable <User>();
db.RunInTransaction(() =>
{
db.Insert(new User()
{
UserName = RegisterUserName.Text, PassWord = RegisterPassword.Password, EmailAddress = RegisterEmail.Text
});
});
}
this.Frame.Navigate(typeof(MainPage));
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
if (FieldValidationExtensions.GetIsValid(RequestTitle) && FieldValidationExtensions.GetIsValid(RequestLocation) && FieldValidationExtensions.GetIsValid(RequestDescription))
{
var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
using (var db = new SQLite.SQLiteConnection(dbPath))
{
db.CreateTable <Appointment>();
db.CreateTable <AppointmentInvitee>();
Appointment appointment = new Appointment();
appointment.Title = RequestTitle.Text;
appointment.Location = RequestLocation.Text;
appointment.Description = RequestDescription.Text;
appointment.Date = RequestDate.SelectedDate;
appointment.OwnerUserID = App.loggedInUser.Id;
db.RunInTransaction(() =>
{
db.Insert(appointment);
foreach (UserSelected item in mUsersSelected)
{
if (item.IsSelected)
{
db.Insert(new AppointmentInvitee()
{
OwnerUserID = App.loggedInUser.Id, InviteeAppointmentID = appointment.Id, InviteeUserID = item.Id
});
}
}
});
}
this.Frame.Navigate(typeof(Dashboard));
}
}