public int ActivateRegisteredUser(string mobile, string password, string email, string otp) { using (SqlConnection con = Connection.SqlConnectionObject) { SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spActivateRegisteredUser, new SqlParameter() { ParameterName = "@Mobile", Value = mobile }, new SqlParameter() { ParameterName = "@Password", Value = password }, new SqlParameter() { ParameterName = "@Email", Value = email }, new SqlParameter() { ParameterName = "@Otp", Value = otp }); if (reader.HasRows) { while (reader.Read()) { return((int)reader[0]); } } } return(-1); }
public int ChangePasswordOnFirstLogin(string userName, string currentPassword, string newPassword) { using (SqlConnection con = Connection.SqlConnectionObject) { SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spChangePasswordOnFirstLogin, new SqlParameter() { ParameterName = "@Username", Value = userName }, new SqlParameter() { ParameterName = "@CurrentPassword", Value = currentPassword }, new SqlParameter() { ParameterName = "@NewPassword", Value = newPassword }); if (reader.HasRows) { while (reader.Read()) { return((int)reader[0]); } } } return(-1); }
public User Authenticate(string username, string password) { User user = new User(); using (SqlConnection con = Connection.SqlConnectionObject) { SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spAuthenticateUser, new SqlParameter() { ParameterName = "@UserName", Value = username }, new SqlParameter() { ParameterName = "@Password", Value = password }); if (reader.HasRows) { while (reader.Read()) { user.AccountLocked = (int)reader["AccountLocked"]; user.IsAuthenticated = (int)reader["Authenticated"]; user.RetryAttempts = (int)reader["RetryAttempts"]; } } } return(user); }
public void SaveOtpInDatabase(string mobile, string email, string otp) { using (SqlConnection con = Connection.SqlConnectionObject) { SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spSaveOtpInDatabase, new SqlParameter() { ParameterName = "@Mobile", Value = mobile }, new SqlParameter() { ParameterName = "@Email", Value = email }, new SqlParameter() { ParameterName = "@Otp", Value = otp }); } }
public string GetOtpFromDatabase(string mobile, string email) { using (SqlConnection con = Connection.SqlConnectionObject) { SqlParameter otp = new SqlParameter() { ParameterName = "@Otp", DbType = DbType.String, Size = 6, Direction = ParameterDirection.Output }; SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spGetOtpFromDatabase, new SqlParameter() { ParameterName = "@Mobile", Value = mobile }, new SqlParameter() { ParameterName = "@Email", Value = email }, otp); return(otp.Value.ToString()); } return(string.Empty); }
public int RegisterUser(string firstName, string lastName, string mobile, string email, string otp) { using (SqlConnection con = Connection.SqlConnectionObject) { SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spRegisterUser, new SqlParameter() { ParameterName = "@FirstName", Value = firstName }, new SqlParameter() { ParameterName = "@LastName", Value = lastName }, new SqlParameter() { ParameterName = "@Mobile", Value = mobile }, new SqlParameter() { ParameterName = "@Email", Value = email }, new SqlParameter() { ParameterName = "@Otp", Value = otp }); if (reader.HasRows) { while (reader.Read()) { return((int)reader[0]); } } } return(-1); }