//Changes made to stored procedure in database
public static List <LockedUser> GetLockedUsers()
{
List <LockedUser> lockedList = new List <LockedUser>();
LockedUser lockedUser = new LockedUser();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["BlueJaysConnection"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("spGetLockedUsers", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lockedUser.FirstName = reader["FirstName"].ToString();
lockedUser.LastName = reader["LastName"].ToString();
lockedUser.Role = reader["Role"].ToString();
lockedUser.IsLocked = Convert.ToBoolean(reader["IsLocked"]);
lockedUser.UserName = reader["UserName"].ToString();
lockedUser.Email = reader["Email"].ToString();
lockedList.Add(lockedUser);
}
}
return(lockedList);
}
//Changes made to stored procedure in database
public static List <LockedUser> GetLockedUsers()
{
List <LockedUser> lockedList = new List <LockedUser>();
LockedUser lockedUser = new LockedUser();
using (OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings["BlueJaysConnection"].ConnectionString))
{
OracleCommand cmd = new OracleCommand("getLockedUserss_sp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter("ref_cur", OracleDbType.RefCursor));
cmd.Parameters["ref_cur"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
OracleDataReader reader = ((OracleRefCursor)cmd.Parameters["ref_cur"].Value).GetDataReader();
while (reader.Read())
{
lockedUser.FirstName = reader["FirstName"].ToString();
lockedUser.LastName = reader["LastName"].ToString();
lockedUser.Role = reader["Role"].ToString();
lockedUser.IsLocked = Convert.ToBoolean(reader["IsLocked"]);
lockedUser.UserName = reader["UserName"].ToString();
lockedUser.Email = reader["Email"].ToString();
lockedList.Add(lockedUser);
}
}
return(lockedList);
}
// PUT: api/User/5
public async Task <HandleResult> Put(string id)
{
var command = new LockedUser(id);
var result = await ExecuteCommandAsync(command);
if (result.IsSuccess())
{
return(HandleResult.FromSuccess("锁定成功"));
}
return(HandleResult.FromFail(result.GetErrorMessage()));
}
public bool UserIsLockedOut(string username)
{
LockedUser lockedUser = this.dbService.IsUserLockedOut(username);
if (lockedUser == null)
{
return(false);
}
return(true);
}
public void LockOutUser(string username)
{
LockedUser lockUser = new LockedUser();
lockUser.UserName = username;
using (var conn = new SqlConnection(ConnectionStringHelper.GetDBConnectionString()))
{
conn.Open();
var identity = conn.Insert <LockedUser>(lockUser);
conn.Close();
}
}
/// <summary>锁定用户
/// </summary>
public void Handle(ICommandContext context, LockedUser command)
{
context.Get <User>(command.AggregateRootId).Locked();
}
