public async void log(object sender, EventArgs e) { string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "agripital.db3"); var db = new SQLiteConnection(dpPath); accounts acnt = new accounts(); var dat = db.Table <accounts>(); var da = dat.Where(x => x.username == username.Text && x.password == password.Text).FirstOrDefault(); if (da != null) { await DisplayAlert("Success", "Login Successful", "Ok"); var da1 = dat.Where(x => x.type == "Seller" && x.username == username.Text).FirstOrDefault(); if (da1 != null) { await Navigation.PushAsync(new vieworadd()); } else { await Navigation.PushAsync(new MainPage(username.Text)); } } else { await DisplayAlert("Error", "Login Failed", "Ok"); } }
public async void register(object sender, EventArgs e) { string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "agripital.db3"); var db = new SQLiteConnection(dpPath); accounts acnt = new accounts(); var dat = db.Table <accounts>(); var da = dat.Where(x => x.username == username.Text).FirstOrDefault(); if (da != null) { await DisplayAlert("Error", "Username is already taken", "Ok"); } else { var ty = typepicker.Items[typepicker.SelectedIndex]; int con = Convert.ToInt32(contact.Text); acnt.username = username.Text; acnt.password = password.Text; acnt.name = name.Text; acnt.address = address.Text; acnt.contact = con; acnt.type = ty; db.Insert(acnt); await DisplayAlert("Success", "Account successfully created", "Ok"); } }