public SecQuestion getSecQuestion(int userId) { SecQuestion secQuestion = null; string connectionString = config.GetConnectionString("DefaultConnection"); MySqlConnection conn = new MySqlConnection(connectionString); MySqlCommand mySqlCommand = new MySqlCommand(); try { conn.Open(); mySqlCommand.Connection = conn; mySqlCommand.CommandText = "get_sec_question"; mySqlCommand.CommandType = CommandType.StoredProcedure; mySqlCommand.Parameters.Add(new MySqlParameter("_user_id", userId)); MySqlDataReader reader = mySqlCommand.ExecuteReader(); while (reader.Read()) { secQuestion = getSecQuestionFromReader(reader); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } return(secQuestion); }
private async void checkExistingUsername() //sees if username exists in database already { try { User completeUser = await getUserFromUsername(entryUsername.Text); if (completeUser.userId != 0) { secQuestion = await getSecurityQuestion(completeUser.userId); lblSecQuestion.Text = secQuestion.question; isActivitySpinnerShowing(false); isEnterSecQuestionLayoutShowing(true); user = completeUser; } else { isActivitySpinnerShowing(false); isEnterUsernameLayoutShowing(true); entryUsername.Text = ""; await DisplayAlert("Invalid Username", "There is no account associated with this username.", "Okay"); } } catch (Exception ex) { isActivitySpinnerShowing(false); isEnterUsernameLayoutShowing(true); entryUsername.Text = ""; await DisplayAlert("Error", "Error occurred.", "Okay"); Debug.WriteLine(ex.Message); } }
private async void createSecurityQuestion() //creates security question object, sends to web api to be created in database { SecQuestion secQuestion = new SecQuestion(user.userId, entrySecQuestion.Text, entrySecQuestionAnswer.Text); try { bool flag = await secQuestionController.createModel(secQuestion); if (flag) { isActivitySpinnerShowing(false); await DisplayAlert("Message", "Security Question Created Successfully!", "Okay"); App.Current.MainPage = new LoginPage(); } else { isActivitySpinnerShowing(false); await DisplayAlert("Message", "Error Occurred.", "Okay"); } }catch (Exception ex) { isActivitySpinnerShowing(false); isSecQuestionLayoutShowing(true); await DisplayAlert("Message", "Error Occured!", "Okay"); Debug.WriteLine(ex.Message); } }
public void Init() { BackgroundColor = Constants.backgroundColor; btnBackToLogin.TextColor = Constants.logoColor; userController = new UserController(); secQuestionController = new SecQuestionController(); user = new User(); secQuestion = new SecQuestion(); }
private SecQuestion getSecQuestionFromReader(MySqlDataReader reader) { SecQuestion secQuestion = new SecQuestion(); secQuestion.queId = Int32.Parse(reader["que_id"].ToString()); secQuestion.userId = Int32.Parse(reader["user_id"].ToString()); secQuestion.question = reader["question"].ToString(); secQuestion.answer = reader["answer"].ToString(); return(secQuestion); }
private JsonResult saveSecQuestion(SecQuestion secQuestion, string command) { Response response = new Response(); SecQuestionDataHandler secQuestionDataHandler = new SecQuestionDataHandler(config); secQuestionDataHandler.queId = secQuestion.queId; secQuestionDataHandler.userId = secQuestion.userId; secQuestionDataHandler.question = secQuestion.question; secQuestionDataHandler.answer = secQuestion.answer; if (command.Equals("create")) { response.status = secQuestionDataHandler.createSecQuestion(); } return(Json(response)); }
public JsonResult getSecQuestion(int userId) { Response response = new Response(); SecQuestionDataHandler secQuestionDataHandler = new SecQuestionDataHandler(config); try { SecQuestion secQuestion = secQuestionDataHandler.getSecQuestion(userId); response.data = JsonConvert.SerializeObject(secQuestion); response.status = true; } catch (Exception ex) { response.status = false; response.message = ex.Message; } return(Json(response)); }
public JsonResult createSecQuestion(SecQuestion secQuestion) { throw new NotImplementedException(); }
public JsonResult createSecQuestion([FromBody] SecQuestion secQuestion) { return(saveSecQuestion(secQuestion, "create")); }