//retrieve sq public SecurityQuestions GetSQById(String user_Id) { SecurityQuestions result = null; result = objRegister.getSecurityQuestion(user_Id); return(result); }
private bool IsDuplicateQuestion(string question, Guid?questionId = null) { var existing = SecurityQuestions.FirstOrDefault(q => q.Question.Equals(question, StringComparison.InvariantCultureIgnoreCase) && (questionId == null || q.Id != questionId)); return(existing != null); }
public SecurityQuestion GetRandomSecurityQuestion() { if (!SecurityQuestions.Any()) { throw new InvalidOperationException("No security questions exist."); } return(SecurityQuestions.ElementAt(random.Next(SecurityQuestions.Count))); }
//for loading the security questions for authentication //public List<SecurityQuestions> getSecurityQuestion(String user_Id) //{ // SqlDataAdapter da; // DataSet ds = new DataSet(); // //declare list to hold collection of events objs // List<SecurityQuestions> securityList = new List<SecurityQuestions>(); // //sql commant to select data from table // StringBuilder sqlCommand = new StringBuilder(); // sqlCommand.AppendLine("Select *"); // sqlCommand.AppendLine("from SecurityQuestions where User_ID = @parauser_Id "); // //Instantiate sqlcommnd instance // SqlConnection objsqlconn = new SqlConnection(DBConnect); // //RETRIEVE RECORD USING DATAADAPTER // da = new SqlDataAdapter(sqlCommand.ToString(), objsqlconn); // da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; // da.SelectCommand.CommandType = CommandType.Text; // da.SelectCommand.Parameters.AddWithValue("@parauser_Id", user_Id); // //fill dataset to table // da.Fill(ds, "table"); // //if no record, set list to null // int count = ds.Tables["table"].Rows.Count; // if (count == 0) // { // securityList = null; // } // else // { // // Step 7 : Iterate DataRow to extract table column tdTerm and tdRate and // // create interestRte instance and add the instance to a List collection // foreach (DataRow row in ds.Tables["table"].Rows) // { // SecurityQuestions objSQ = new SecurityQuestions(); // objSQ.User_ID = Convert.ToString(row["user_Id"]); // objSQ.firstSecurityQ = (byte[])row["FirstSecurityQuestion"]; // objSQ.firstSecurityQA = Convert.ToString(row["FirstSecurityQA"]); // objSQ.secondSecurityQ = (byte[])row["SecondSecurityQ"]; // // objSQ.secondSecurityQ = Convert.ToByte(row["SecondSecurityQ"]); // objSQ.secondSecurityQA = Convert.ToString(row["SecondSecurityQA"]); // //objSQ.thirdSecurityQ = Convert.ToByte(row["thirdSecurityQ"]); // objSQ.thirdSecurityQ = (byte[])row["thirdSecurityQA"]; // objSQ.thirdSecurityQA = Convert.ToString(row["thirdSecurityQA"]); // // securityList.Add(objSQ); // } // } // return securityList; //} public SecurityQuestions getSecurityQuestion(String user_Id) { SqlDataAdapter da; DataSet ds = new DataSet(); //declare list to hold collection of events objs SecurityQuestions securityList = new SecurityQuestions(); //sql commant to select data from table StringBuilder sqlCommand = new StringBuilder(); sqlCommand.AppendLine("Select *"); sqlCommand.AppendLine("from SecurityQuestions where User_ID = @parauser_Id "); //Instantiate sqlcommnd instance SqlConnection objsqlconn = new SqlConnection(DBConnect); //RETRIEVE RECORD USING DATAADAPTER da = new SqlDataAdapter(sqlCommand.ToString(), objsqlconn); da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; da.SelectCommand.CommandType = CommandType.Text; da.SelectCommand.Parameters.AddWithValue("@parauser_Id", user_Id); //fill dataset to table da.Fill(ds, "SQTable"); //if no record, set list to null int count = ds.Tables["SQTable"].Rows.Count; if (count == 0) { securityList = null; } else { // Step 7 : Iterate DataRow to extract table column tdTerm and tdRate and // create interestRte instance and add the instance to a List collection foreach (DataRow row in ds.Tables["SQTable"].Rows) { //SecurityQuestions objSQ = new SecurityQuestions(); securityList.User_ID = Convert.ToString(row["user_Id"]); securityList.firstSecurityQ = (byte[])row["FirstSecurityQuestion"]; securityList.firstSecurityQA = Convert.ToString(row["FirstSecurityQuestionAns"]); securityList.secondSecurityQ = (byte[])row["SecondSecurityQuestion"]; // objSQ.secondSecurityQ = Convert.ToByte(row["SecondSecurityQ"]); securityList.secondSecurityQA = Convert.ToString(row["SecondSecurityQuestionAns"]); //objSQ.thirdSecurityQ = Convert.ToByte(row["thirdSecurityQ"]); securityList.thirdSecurityQ = (byte[])row["ThirdSecurityQuestion"]; securityList.thirdSecurityQA = Convert.ToString(row["ThirdSecurityQuestionAns"]); } } return(securityList); }
public void AddSecurityQuestion(string question, string answer) { Ensure.Argument.NotNullOrEmpty(question, "question"); Ensure.Argument.NotNullOrEmpty(answer, "answer"); if (IsDuplicateQuestion(question)) { throw new ArgumentException("The question '{0}' already exists.".FormatWith(question)); } SecurityQuestions.Add(new SecurityQuestion(question, answer)); }
static void Main(string[] args) { var questions = new SecurityQuestions(); questions.Answer1 = "Test"; questions.Answer2 = "Test"; questions.Answer3 = "Test3"; questions.Answer4 = "Test4"; questions.Answer5 = "Test5"; questions.Answer6 = "Test6"; var vc = new ValidationContext(questions, null, null); var results = new List <ValidationResult>(); var validationResult = Validator.TryValidateObject(questions, vc, results, true); }
public void UpdateQuestion(Guid questionId, string question, string answer) { Ensure.Argument.NotNull(questionId, "questionId"); Ensure.Argument.NotNullOrEmpty(question, "question"); Ensure.Argument.NotNullOrEmpty(answer, "answer"); var securityQuestion = SecurityQuestions.FirstOrDefault(q => q.Id == questionId); if (securityQuestion == null) { throw new ArgumentException("A security question with Id '{0}' does not exist."); } //if (IsDuplicateQuestion(question, securityQuestion.Id)) //{ // throw new ArgumentException("The question '{0}' already exists.".FormatWith(question)); //} securityQuestion.Update(question, answer); }
internal List <SecurityQuestions> FetchSecurityQuestions() { sql = "SELECT qid,qname from securityquestion"; var s = new List <SecurityQuestions>(); using (conn = new SqlConnection(connectionString)) { cmd = new SqlCommand(sql, conn); conn.Open(); rdr = cmd.ExecuteReader(); while (rdr.Read()) { var a = new SecurityQuestions(); a.qid = int.Parse(rdr["qid"].ToString()); a.qname = rdr["qname"].ToString(); s.Add(a); } conn.Close(); return(s); } }
protected void submitPasswordBtn_Click(object sender, EventArgs e) { //move to reset sec q answerSecurityQ.Visible = true; passwordPanel.Visible = false; emailPanel.Visible = false; string userId = inputIdTB.Text; RegistrationBO getQuestions = new RegistrationBO(); // SecurityQuestions sqObj = new SecurityQuestions(); SecurityQuestions sqObj = getQuestions.GetSQById(userId); List <String> templist = new List <String>(); List <Byte[]> getlist = new List <Byte[]>(); var tupleList = new List <Tuple <Byte[], String> >(); tupleList.Add(new Tuple <Byte[], String>(sqObj.firstSecurityQ, sqObj.firstSecurityQA.ToString())); tupleList.Add(new Tuple <Byte[], String>(sqObj.secondSecurityQ, sqObj.secondSecurityQA.ToString())); tupleList.Add(new Tuple <Byte[], String>(sqObj.thirdSecurityQ, sqObj.thirdSecurityQA.ToString())); Shuffle(tupleList); for (int i = 0; i < 2; i++) { byte[] questionOne = tupleList[0].Item1; string questionOneAns = tupleList[0].Item2; byte[] questionTwo = tupleList[1].Item1; string questionTwoAns = tupleList[1].Item2; // byte[] secBytes = (byte[])sqObj.secondSecurityQ; Image1.ImageUrl = "data:Image/;base64," + Convert.ToBase64String(questionOne); Image2.ImageUrl = "data:Image/;base64," + Convert.ToBase64String(questionTwo); } }
public SecurityQuestion GetSecurityQuestion(Guid questionId) { Ensure.Argument.NotNull(questionId, "questionId"); return(SecurityQuestions.FirstOrDefault(q => q.Id == questionId)); }