public bool checkPassword()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["parkDB"].ConnectionString);
conn.Open();
string checkUser = "******";
SqlCommand comd = new SqlCommand(checkUser, conn);
comd.Parameters.AddWithValue("@userName", userName);
SqlDataReader dr = comd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
if (dr["Password"].ToString().Equals(EncryptPassword.encryptString(password)))
{
dr.Close();
conn.Close();
return(true);
}
}
dr.Close();
conn.Close();
return(false);
}
public void resetPassword(string newpwd)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["parkDB"].ConnectionString);
conn.Open();
string checkUser = "******";
SqlCommand comd = new SqlCommand(checkUser, conn);
comd.Parameters.AddWithValue("@userName", userName);
comd.Parameters.AddWithValue("@password", EncryptPassword.encryptString(newpwd));
comd.ExecuteNonQuery();
conn.Close();
}
public void insertData()
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["parkDB"].ConnectionString);
conn.Open();
string insertString = "INSERT INTO ParkCustomer (UserName, FName, LName, Email, Password, Age, Gender) values (@UserName, @FName, @LName, @Email, @Password, @Age, @Gender)";
SqlCommand comd = new SqlCommand(insertString, conn);
comd.Parameters.AddWithValue("@UserName", userName);
comd.Parameters.AddWithValue("@FName", fName);
comd.Parameters.AddWithValue("@LName", lName);
comd.Parameters.AddWithValue("@Email", email);
comd.Parameters.AddWithValue("@Password", EncryptPassword.encryptString(password));
comd.Parameters.AddWithValue("@Age", Convert.ToInt32(age));
comd.Parameters.AddWithValue("@Gender", gender);
comd.ExecuteNonQuery();
conn.Close();
}