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