async void intentoRegistro(object sender, System.EventArgs e) { if (await validarFormulario()) { var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db"); var db = new SQLiteConnection(dbpath); db.CreateTable <RegUserTable>(); var item = new RegUserTable() { Nombre = EntryUserName.Text, Pin = int.Parse(EntryUserPassword.Text), Email = EntryUserEmail.Text, Numero = EntryUserNumber.Text, is_premium = false }; db.Insert(item); Device.BeginInvokeOnMainThread(async() => { var result = await this.DisplayAlert("Registrado!", "Registro exitoso", "OK", "Cancelar"); App.Current.MainPage = new NavigationPage(new LoginPage()); }); } }
async private void RegisterButton_Clicked(object sender, EventArgs e) { var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDataBase.db"); var db = new SQLiteConnection(dbpath); db.CreateTable <RegUserTable>(); var item = new RegUserTable() { Username = Entryusername.Text, Password = Entrypassword.Text, Email = Entryemail.Text, Matricno = Entrymatricno.Text }; db.Insert(item); Device.BeginInvokeOnMainThread(async() => { var results = await this.DisplayAlert("Congratulations", "User Registration Successful", "Yes", "Cancel"); }); //This Code retrives Username and Mat Number and sends to Confirmation Page string confirmUsername = Entryusername.Text; string confirmMatno = Entrymatricno.Text; Entryusername.Text = confirmUsername; Entrymatricno.Text = confirmMatno; await Navigation.PushAsync(new UserConfirmationPage(Entryusername.Text, Entrymatricno.Text)); }
private void Button_Clicked(object sender, EventArgs e) { var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db"); var db = new SQLiteConnection(dbpath); db.CreateTable <RegUserTable>(); var item = new RegUserTable() { UserName = EntryUserName.Text, Password = EntryUserPassword.Text, Email = EntryUseremail.Text, PhoneNumber = EntryUserPhoneNumber.Text }; db.Insert(item); Device.BeginInvokeOnMainThread(async() => { var result = await this.DisplayAlert("Congratulation", "User Registeration Sucessfull", "Yes", "Cancel"); if (result) { await Navigation.PushAsync(new LoginPage()); } }); }
void Button_Clicked(object sender, System.EventArgs e) { var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db"); var db = new SQLiteConnection(dbpath); db.CreateTable <RegUserTable>(); var item = new RegUserTable() { UserName = EUN.Text, Password = EUP.Text, Email = EUE.Text }; db.Insert(item); Device.BeginInvokeOnMainThread(async() => { var result = await this.DisplayAlert("Registeration Sucessfull", "", "OK", "Cancel"); if (result) { await Navigation.PushModalAsync(new Login()); } }); }
void Handle_Clicked(object sender, System.EventArgs e) { var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db"); var db = new SQLiteConnection(dbpath); db.CreateTable <RegUserTable>(); var item = new RegUserTable() { UserName = EntryUserName.Text, Password = EntryUserPassword.Text, Email = EntryUserEmail.Text, Telefon = EntryUserTelefon.Text }; db.Insert(item); Device.BeginInvokeOnMainThread(async() => { var result = await this.DisplayAlert("Felicitari", "Inregistrare cu succes", "Da", "Anuleaza"); if (result) { await Navigation.PushAsync(new LoginPage()); } }); }
void Handle_Clicked(object sender, System.EventArgs e) { var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDataBase.db"); var db = new SQLiteConnection(dbpath); db.CreateTable <RegUserTable>(); var item = new RegUserTable() { UserName = EntryUserName.Text, Password = EntryUserPassword.Text, Email = EntryUserEmail.Text, PhoneNumber = EntryUserPhoneNumber.Text }; db.Insert(item); Device.BeginInvokeOnMainThread(async() => { var result = await this.DisplayAlert("Congrats", "User registration Successful", "Okay", "Cancel"); // After registration it will send you too login page if (result) { await Navigation.PushAsync(new LoginPage()); } }); }
private void Button_Clicked(object sender, EventArgs e) { //var emailPattern ="Regular_expression"; var userName = EntryUserName.Text; var password = EntryUserPassword.Text; var email = EntryUserEmail.Text; var PhNo = EntryUserPhoneNumber.Text; //if(Regex.IsMatch(email,emailPattern)) //{ //} if (!string.IsNullOrWhiteSpace(userName) && userName.Length < 16 && !string.IsNullOrWhiteSpace(password) && !string.IsNullOrWhiteSpace(email) && !string.IsNullOrWhiteSpace(PhNo) && PhNo.Length < 11) { regUserTable = new RegUserTable() { UserName = EntryUserName.Text, Password = EntryUserPassword.Text, Email = EntryUserEmail.Text, PhoneNumber = EntryUserPhoneNumber.Text }; conn.Insert(regUserTable); Device.BeginInvokeOnMainThread(async() => { var result = await this.DisplayAlert("Congrats", "User registration successful.", "Yes", "Cancel"); if (result) { await Navigation.PushAsync(new LoginPage()); } }); } else { DisplayAlert("Alert", "Fields should not be blank. User should be less than 16 chars.", "OK"); } }
public async Task RegisterNewUser() { var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db"); var db = new SQLiteConnection(dbpath); db.CreateTable <RegUserTable>(); var userName = TakeUserName; var userPassword = TakeUserPassword; var userEmail = TakeEmail; var userPhoneNumber = TakePhoneNumber; var item = new RegUserTable() { UserName = userName, Password = userPassword, Email = userEmail, PhoneNumber = userPhoneNumber, }; db.Insert(item); db.Close(); double num1 = 0; bool IsStringNumber = double.TryParse(item.PhoneNumber, out num1); if (item.UserName == null || item.Password == null || item.Email == null || item.PhoneNumber == null) { await App.Current.MainPage.DisplayAlert("Error", "Something wrong", "Ok"); await Navigation.PushAsync(new RegistrationPage()); } else if (IsStringNumber == false) { await App.Current.MainPage.DisplayAlert("Error", "Format of number is incorrect ", "ok"); await Navigation.PushAsync(new RegistrationPage()); } else if (!(TakeEmail.Contains("@gmail.com") || TakeEmail.Contains("@azet.sk") || TakeEmail.Contains("@astlas.cz"))) { await App.Current.MainPage.DisplayAlert("Error", "Email is probably incorrect", "ok"); await Navigation.PushAsync(new RegistrationPage()); } else { Device.BeginInvokeOnMainThread(async() => { var result = await App.Current.MainPage.DisplayAlert("Congratulation", "User Registration Succesfull", "Yes", "Cancel"); if (result) { await Navigation.PushAsync(new LoginPage()); } }); } }
async void Button_Clicked(System.Object sender, System.EventArgs e) { var db = new SQLiteConnection(_dbPath); db.CreateTable <RegUserTable>(); var maxPk = db.Table <RegUserTable>().OrderByDescending(c => c.ID).FirstOrDefault(); RegUserTable regusertable = new RegUserTable() { ID = (maxPk == null ? 1 : maxPk.ID + 1), Name = smoke.Text, Age = AG.Text, gender = alcohol.Text, }; db.Insert(regusertable); await DisplayAlert(null, "Saved", "Ok"); await Navigation.PopAsync(); }
private void RegBtn_Clicked(object sender, EventArgs e) { var databasePath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "MyData.db"); con = new SQLiteConnection(databasePath); con.CreateTable <RegUserTable>(); var item = new RegUserTable { UserName = unEntry.Text, password = pwEntry.Text, confirmPw = rePwEntry.Text, phoneNumber = phoneEntry.Text }; con.Insert(item); Device.BeginInvokeOnMainThread(async() => { var res = await DisplayAlert("Gongrats !", unEntry.Text + " you have successfully completed the registration process", "ok", "cancel"); if (res) { await Navigation.PushAsync(new Login()); } }); }
private async void Button_Clicked(object sender, EventArgs e) { if (EntryUserName.Text == null) { //await this.DisplayAlert(null, "กรุณาระบุชื่อผู้ใช้งาน", null, "ตกลง"); EntryUserName.PlaceholderColor = Color.FromHex("#ffb3ba"); EntryUserName.Placeholder = "กรุณาระบุชื่อผู้ใช้งาน"; EntryUserName.Focus(); return; } if (EntryUserPassword.Text == null) { //await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง"); EntryUserPassword.PlaceholderColor = Color.FromHex("#ffb3ba"); EntryUserPassword.Placeholder = "กรุณาระบุรหัสผ่าน"; EntryUserPassword.Focus(); return; } if (EntryUserEmail.Text == null) { //await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง"); EntryUserEmail.PlaceholderColor = Color.FromHex("#ffb3ba"); EntryUserEmail.Placeholder = "กรุณาระบุอีเมล์"; EntryUserEmail.Focus(); return; } if (EntryUserPhoneNumber.Text == null) { //await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง"); EntryUserPhoneNumber.PlaceholderColor = Color.FromHex("#ffb3ba"); EntryUserPhoneNumber.Placeholder = "กรุณาระบุเบอร์โทรศัพท์"; EntryUserPhoneNumber.Focus(); return; } Device.BeginInvokeOnMainThread(async() => { //Register data to firebase also var isExist = await apiRequestHelper.RequestCheckUserExistAsync(EntryUserName.Text); if (isExist == "true") { Toast.MakeText(this.context, "ชื่อผู้ใช้งานซ้ำ", ToastLength.Short).Show(); EntryUserName.PlaceholderColor = Color.FromHex("#ffb3ba"); EntryUserName.Placeholder = "กรุณาระบุชื่อผู้ใช้งานใหม่"; EntryUserName.Focus(); return; } var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db"); var db = new SQLiteConnection(dbpath); db.CreateTable <RegUserTable>(); var item = new RegUserTable() { UserName = EntryUserName.Text, Password = EntryUserPassword.Text, Email = EntryUserEmail.Text, PhoneNumber = EntryUserPhoneNumber.Text, }; db.Insert(item); var profile = new ProfileTable() { UserName = EntryUserName.Text, Email = EntryUserEmail.Text, PhoneNumber = EntryUserPhoneNumber.Text, }; db.CreateTable <ProfileTable>(); db.Insert(profile); //Register data to firebase also await apiRequestHelper.RequestRegisterUserAsync(EntryUserName.Text, EntryUserPassword.Text, EntryUserEmail.Text, EntryUserPhoneNumber.Text); ProfileJson json = new ProfileJson(); json.UserName = EntryUserName.Text; json.Email = EntryUserEmail.Text; json.PhoneNumber = EntryUserPhoneNumber.Text; json.CreateDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt"); await apiRequestHelper.RequestAddProfileAsync(json); var result = await this.DisplayAlert(null, "สมัครสมาชิกสำเร็จ!", null, "ตกลง"); if (!result) { await Navigation.PushAsync(new LoginPage()); } }); }
async void Login_Clicked(object sender, EventArgs e) { if (EntryUser.Text == null) { //await this.DisplayAlert(null, "กรุณาระบุชื่อผู้ใช้งาน", null, "ตกลง"); EntryUser.PlaceholderColor = Color.FromHex("#ffb3ba"); EntryUser.Placeholder = "กรุณาระบุชื่อผู้ใช้งาน"; EntryUser.Focus(); return; } if (EntryPassword.Text == null) { //await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง"); EntryPassword.PlaceholderColor = Color.FromHex("#ffb3ba"); EntryPassword.Placeholder = "กรุณาระบุรหัสผ่าน"; EntryPassword.Focus(); return; } btnLogin.IsEnabled = false; //Cloud database //Register data to firebase also RegUserJson user = await apiRequestHelper.RequestLoginUserAsync(EntryUser.Text, EntryPassword.Text); if (user != null & user.UserName == EntryUser.Text) { var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db"); var db = new SQLiteConnection(dbpath); var reguser = db.GetTableInfo("RegUserTable"); if (reguser.Count == 0) { db.CreateTable <RegUserTable>(); var item = new RegUserTable() { UserName = user.UserName, Password = user.Password, Email = user.Email, PhoneNumber = user.PhoneNumber, }; db.Insert(item); } else { var item = db.Table <RegUserTable>().Where(u => u.UserName.Equals(user.UserName)).FirstOrDefault(); if (item == null) { var data = new RegUserTable() { UserName = user.UserName, Password = user.Password, Email = user.Email, PhoneNumber = user.PhoneNumber, }; db.Insert(data); } } RootProfileObject profileData = await apiRequestHelper.RequestProfileAsync(user.UserName); if (profileData != null && profileData.Data != null && profileData.Data.Count > 0) { List <ProfileJson> Data = profileData.Data; if (Data.Count > 0) { ProfileJson json = Data.First <ProfileJson>(); var userprofile = db.GetTableInfo("ProfileTable"); if (userprofile.Count == 0) { db.CreateTable <ProfileTable>(); var profile = new ProfileTable() { UserName = json.UserName, FirstName = json.FirstName, LastName = json.LastName, Gender = (json.Gender == null ? "" : json.Gender), DateOfBirth = (json.DateOfBirth == null ? "" : json.DateOfBirth), Address1 = json.Address1 == null? "" : json.Address1, Address2 = json.Address2 == null ? "" : json.Address2, Address3 = json.Address3 == null ? "" : json.Address3, Email = json.Email, PhoneNumber = json.PhoneNumber, CreateDate = DateTime.Now, UpdateDate = DateTime.Now, }; db.Insert(profile); } else { var item = db.Table <ProfileTable>().Where(u => u.UserName.Equals(user.UserName)).FirstOrDefault(); if (item == null) { var profile = new ProfileTable() { UserName = json.UserName, FirstName = json.FirstName, LastName = json.LastName, Gender = (json.Gender == null ? "" : json.Gender), DateOfBirth = (json.DateOfBirth == null ? "" : json.DateOfBirth), Address1 = json.Address1 == null ? "" : json.Address1, Address2 = json.Address2 == null ? "" : json.Address2, Address3 = json.Address3 == null ? "" : json.Address3, Email = json.Email, PhoneNumber = json.PhoneNumber, CreateDate = DateTime.Now, UpdateDate = DateTime.Now, }; db.Insert(profile); } } } } /////////////////// Device.StartTimer(TimeSpan.FromSeconds(0.1), () => { btnLogin.IsEnabled = true; Toast.MakeText(context, "Login Successfull", ToastLength.Short).Show(); Application.Current.Properties.Add("USER_NAME", EntryUser.Text); App.Current.MainPage = new MainPage(); return(false); }); } else { Device.BeginInvokeOnMainThread(async() => { var result2 = await this.DisplayAlert(null, "ข้อผิดพลาด! ไม่พบข้อมูลผู้ใช้งาน\nกรุณาตรวจสอบชื่อผู้ใช้งานและรหัสผ่าน", null, "ตกลง"); if (!result2) { btnLogin.IsEnabled = true; EntryUser.Focus(); } }); } //End of Cloud database //Local database /* * var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db"); * var db = new SQLiteConnection(dbpath); * db.CreateTable<RegUserTable>(); * var myquery = db.Table<RegUserTable>().Where(u => u.UserName.Equals(EntryUser.Text) && u.Password.Equals(EntryPassword.Text)).FirstOrDefault(); * * if (myquery != null) * { * Application.Current.Properties.Add("USER_NAME", myquery.UserName); * App.Current.MainPage = new MainPage(); * } * else * { * Device.BeginInvokeOnMainThread(async () => { * if(EntryUser.Text == null) * { * //await this.DisplayAlert(null, "กรุณาระบุชื่อผู้ใช้งาน", null, "ตกลง"); * EntryUser.PlaceholderColor = Color.FromHex("#ffb3ba"); * EntryUser.Placeholder = "กรุณาระบุชื่อผู้ใช้งาน"; * EntryUser.Focus(); * return; * } * * if (EntryPassword.Text == null) * { * //await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง"); * EntryPassword.PlaceholderColor = Color.FromHex("#ffb3ba"); * EntryPassword.Placeholder = "กรุณาระบุรหัสผ่าน"; * EntryPassword.Focus(); * return; * } * * var result = await this.DisplayAlert(null, "ข้อผิดพลาด! ไม่พบข้อมูลผู้ใช้งาน\nกรุณาตรวจสอบชื่อผู้ใช้งานและรหัสผ่าน", null, "ตกลง"); * * if (!result) * { * EntryUser.Focus(); * } * }); * * } */ //End of Local database }