protected override void OnNavigatedTo(NavigationEventArgs e) { try { base.OnNavigatedTo(e); parentId = (int)e.Parameter; objParentViewModel = new ParentViewModel(); objRegister = new Register(); objRegister = objParentViewModel.getParentDetails(parentId); lblParentID.Text = "" + objRegister.Id; txtEnterNewName.Text = "" + objRegister.Name; txtEnterNewSurname.Text = "" + objRegister.Surname; txtEnterNewEmail.Text = "" + objRegister.Email; txtEnterNewPhoneNo.Text = "" + objRegister.PhoneNo; txtEnterNewPassword.Text = "" + objRegister.Password; base.OnNavigatedTo(e); } catch (Exception) { } }
//Get object containing user details protected override void OnNavigatedTo(NavigationEventArgs e) { try { base.OnNavigatedTo(e); objReg = (Register)e.Parameter; lblGetId.Text = "" + objReg.Id; lblGetName_Surname.Text = "" + objReg.Name + " " + objReg.Surname; } catch (Exception) { } }
//Display the ID of the parent currently logged in protected override void OnNavigatedTo(NavigationEventArgs e) { try { base.OnNavigatedTo(e); getTheId = (int)e.Parameter; objRegister = new Register(); objParentViewModel = new ParentViewModel(); objRegister = objParentViewModel.getParentDetails(getTheId); lblParentIdenNum.Text = "" + objRegister.Name + " " +objRegister.Surname; } catch(Exception) { } }
//This buttons controls the Login fuctionalities private void btnLogin1_Click(object sender, RoutedEventArgs e) { //Ojbjects for ParentViewModel and Register classes objParent = new ParentViewModel(); objReg = new Register(); objMenu = new MenuPage(); //this.Frame.Navigate(typeof(MenuPage)); string username = txtUsername.Text; string password = pwbEnterPassword.Password; //String ErrorMessage string messageToDisplay = ""; if ((!username.Equals("")) && (!password.Equals(""))) { try { string findTheAtSign = "@"; string findThePeriod = "."; bool isFoundAtSign = false; bool isFoundPeriod = false; for (int x = 0; x < username.Length; x++) { isFoundAtSign = username.Contains(findTheAtSign); isFoundPeriod = username.Contains(findThePeriod); } if((isFoundAtSign == true) && (isFoundPeriod == true)) { //Get all parent details matching user supplied information var confirm = objParent.getParent(username, password); if(confirm != null) { this.Frame.Navigate(typeof(MenuPage), confirm.Id); int iden = Convert.ToInt32(confirm.Id);//confirm.Id; objMenu.getID(iden); messageToDisplay = "Welcome " + confirm.Name + " " + confirm.Surname + "\nYour user ID is: " + confirm.Id; messageBox(messageToDisplay); } else { messageToDisplay = "Invalid user details entered!" + "\nPlease ensure that the username and password entered are correct..."; messageBox(messageToDisplay); } } else { messageToDisplay = "Invalid email address entered!"; messageBox(messageToDisplay); } } catch(Exception ex) { string ErrorMessage = "Error: " + ex.Message; messageBox(ErrorMessage); } } else { //Enter error message box here! string ErrorMessage = "Please ensure that all text fields are entered!"; messageBox(ErrorMessage); //this.Frame.Navigate(typeof(MainPage)); } //Verify that user inputs are not empty first }
private void btnVerifyUserDetails_Click(object sender, RoutedEventArgs e) { bool isFoundAtSign = false; bool isFoundPeriod = false; objReg = new Register(); objParentViewModel = new ParentViewModel(); getEmail = txtConfirmEmail.Text; getPhoneNum = txtConfirmPhoneNo.Text; if((!getEmail.Equals("")) && (!getPhoneNum.Equals(""))) { //Check whether email address is correct string findTheAtSign = "@"; string findThePeriod = "."; for (int x = 0; x < getEmail.Length; x++) { isFoundAtSign = getEmail.Contains(findTheAtSign); isFoundPeriod = getEmail.Contains(findThePeriod); } //check the phone number for validity int count = 0; for (int z = 0; z < getPhoneNum.Length; z++) { count = count + 1; } int verifyNum; bool isNumerical = int.TryParse(getPhoneNum, out verifyNum); if ((isFoundAtSign == true) && (isFoundPeriod == true)) { if (count == 10) { if(isNumerical == true) { try { objReg = objParentViewModel.checkUserExistence(getEmail, getPhoneNum); } catch (Exception) { } if (objReg != null) { this.Frame.Navigate(typeof(ResetPasswordPage), objReg); msg = "User account details found in the database!" + "\nProceed to reset your password."; messageBox(msg); } else { this.Frame.Navigate(typeof(VerifyUserPage)); msg = "Information entered did not match anything in the database!" + "\nEnsure that the information is correct!"; messageBox(msg); } } else { msg = "Please enter numeric characters only for the phone number!"; messageBox(msg); } } else { msg = "Phone number must be ten (10) characters long!" + "\nThe number you entered is: (" + count + ") characters long!"; messageBox(msg); } } else { msg = "Invalid email address entered!" + "\nPlease ensure that the email address contains these characters: (@) and (.)"; messageBox(msg); } } else { msg = "Please ensure that all text fields are filled in before proceeding!"; messageBox(msg); } }
private void Button_Click(object sender, RoutedEventArgs e) { string getId = lblParentID.Text; int convID = Convert.ToInt32(getId); string updateName = txtEnterNewName.Text; string updateSurname = txtEnterNewSurname.Text; string updateEmail = txtEnterNewEmail.Text; string updatePhone = txtEnterNewPhoneNo.Text; string updatePassword = txtEnterNewPassword.Text; bool isFoundAtSign = false; bool isFoundPeriod = false; if ((!updateName.Equals("")) && (!updateSurname.Equals("")) && (!updateEmail.Equals("")) && (!updatePhone.Equals("")) && (!updatePassword.Equals(""))) { objRegister = new Register(); int updateResult = 0; objParentViewModel = new ParentViewModel(); //Check whether email address is correct string findTheAtSign = "@"; string findThePeriod = "."; for (int x = 0; x < updateEmail.Length; x++) { isFoundAtSign = updateEmail.Contains(findTheAtSign); isFoundPeriod = updateEmail.Contains(findThePeriod); } //check the phone number for validity int count = 0; for (int z = 0; z < updatePhone.Length; z++) { count = count + 1; } int verifyNum; bool isNumerical = int.TryParse(updatePhone, out verifyNum); if ((isFoundAtSign == true) && (isFoundPeriod == true)) { if (count == 10) { if (isNumerical == true) { try { updateResult = objParentViewModel.updateParentDetails(convID, updateName, updateSurname, updateEmail, updatePhone, updatePassword); } catch (Exception) { } if (updateResult > 0) { this.Frame.Navigate(typeof(MenuPage), parentId); msg = "Update was successful!"; messageBox(msg); } else { msg = "Update was unsuccessful!"; messageBox(msg); } } else { msg = "Please enter numeric characters only for the phone number! "; messageBox(msg); } } else { msg = "Phone number must be ten (10) characters long!" + "\nThe number you entered is: (" + count + ") characters long!"; messageBox(msg); } } else { msg = "Invalid email address entered!" + "\nPlease ensure that the email address contains these characters: (@) and (.)"; messageBox(msg); } } else { msg = "Please ensure that all text fields are filled in!"; messageBox(msg); } }
//Check whether the user exixts in the database public Register checkUserExistence(string email, string phoneNo) { reg = new Register(); using (var db = new SQLite.SQLiteConnection(app.dbPath)) { reg = db.Query<Register>("Select * from Parents where Email='" + email + "' and PhoneNo='" + phoneNo + "'").FirstOrDefault(); } return reg; }
//Retrive all Parent details from the database where email and password match user inputs public Register getParent(string email, string password) { reg = new Register(); using(var db = new SQLite.SQLiteConnection(app.dbPath)) { reg = db.Query<Register>("Select * from Parents where Email ='" +email+ "' and Password ='******'").FirstOrDefault(); /* var _register = db.Query<Register>("Select * from Parents where Email ='" + email + "' and Password ='******'").FirstOrDefault; return reg; */ } return reg; }
//Retrive all Parent details from the database to check whether email address exists public Register checkUserExistence() { reg = new Register(); using (var db = new SQLite.SQLiteConnection(app.dbPath)) { reg = db.Query<Register>("Select * from Parents").FirstOrDefault(); } return reg; }