//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));
}
