private void createDataForDataBase() { double enrollmentId = 1217000; for (int i = 0; i < 1000; i++) { var uabcUser = new UABC { EnrollmentID = enrollmentId++.ToString() }; using (var data = new DataAccess()) { data.InsertEnrollmentID(uabcUser); } } }
public void InsertEnrollmentID(UABC uabc) { connection.Insert(uabc); }
private async void registerButton_Clicked(object sender, EventArgs e) { if (string.IsNullOrEmpty(nameEntry.Text)) { await DisplayAlert("ERROR", "DEBE INGRESAR UN NOMBRE", "ACEPTAR"); nameEntry.Focus(); return; } else if (string.IsNullOrEmpty(lastNameEntry.Text)) { await DisplayAlert("ERROR", "DEBE INGRESAR UN APELLIDO", "ACEPTAR"); lastNameEntry.Focus(); return; } else if (string.IsNullOrEmpty(cityEntry.Text)) { await DisplayAlert("ERROR", "DEBE INGRESAR UNA CIUDAD", "ACEPTAR"); cityEntry.Focus(); return; } else if (string.IsNullOrEmpty(emailEntry.Text)) { await DisplayAlert("ERROR", "DEBE INGRESAR UN CORREO ELECTRÓNICO", "ACEPTAR"); emailEntry.Focus(); return; } else if (string.IsNullOrEmpty(enrollmentIDEntry.Text)) { await DisplayAlert("ERROR", "DEBE INGRESAR UNA MATRICULA", "ACEPTAR"); enrollmentIDEntry.Focus(); return; } else if (string.IsNullOrEmpty(passwordEntry.Text)) { await DisplayAlert("ERROR", "DEBE INGRESAR UNA CONTRASEÑA", "ACEPTAR"); passwordEntry.Focus(); return; } else if (string.IsNullOrEmpty(phoneNumberEntry.Text)) { await DisplayAlert("ERROR", "DEBE INGRESAR UN TELEFONO", "ACEPTAR"); phoneNumberEntry.Focus(); return; } else if (!emailEntry.Text.ToUpper().Contains("@UABC.EDU.MX")) { await DisplayAlert("ERROR", "DEBE INGRESAR UN CORREO ASOCIADO A UABC", "ACEPTAR"); emailEntry.Focus(); return; } else { var uabcEnrollmentID = new UABC(); using (var data = new DataAccess()) { uabcEnrollmentID = data.GetUABCEnrollmentID(enrollmentIDEntry.Text); } if (uabcEnrollmentID == null) { await DisplayAlert("Error", "Matricula no existente en UABC", "Aceptar"); enrollmentIDEntry.Focus(); return; } else { var user = new Users { Name = nameEntry.Text, LastName = lastNameEntry.Text, AccountType = "pasajero".ToUpper(), City = cityEntry.Text, Email = emailEntry.Text, EnrollmentID = enrollmentIDEntry.Text, Password = passwordEntry.Text, PhoneNumber = phoneNumberEntry.Text, driverRegister = false }; using (var datos = new DataAccess()) { datos.InsertUser(user); } nameEntry.Text = string.Empty; lastNameEntry.Text = string.Empty; cityEntry.Text = string.Empty; emailEntry.Text = string.Empty; enrollmentIDEntry.Text = string.Empty; passwordEntry.Text = string.Empty; phoneNumberEntry.Text = string.Empty; await DisplayAlert("Éxito!", "Bienvenido a la aplicación", "Aceptar"); Application.Current.MainPage = new NavigationPage(new MainPage(user)); } } }