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
}
