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