public async Task <PersistedGrant> GetAsync(string key)
{
DbDataReader dr = null;
try
{
string strSql = "select * from identityserver where `key`=@Key";
MySqlParameter[] parameters =
{
new MySqlParameter("@Key", MySqlDbType.VarChar, 1000)
};
parameters[0].Value = key;
PersistedGrant entity = new PersistedGrant();
using (dr = await DbHelperMySQL.ExecuteReaderAsync(DBConnection.UsersSystem, strSql, parameters))
{
while (await dr.ReadAsync())
{
entity = DataRowToModel(dr);
}
}
return(entity);
}
catch (Exception err)
{
throw err;
}
finally
{
if (dr != null || dr.IsClosed)
{
dr.Dispose();
}
}
}
public async Task <long> GetUserIdRandom()
{
DbDataReader dr = null;
try
{
long userID = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from UsersRandom where IsActive=0 order by rand() limit 0,1");
using (dr = await DbHelperMySQL.ExecuteReaderAsync(DBConnection.UsersSystem, strSql.ToString(), null))
{
if (await dr.ReadAsync())
{
userID = dr.GetInt64(0);
}
}
return(userID);
}
catch (Exception err)
{
throw err;
}
finally
{
if (dr != null)
{
dr.Dispose();
}
}
}
public async Task <IEnumerable <PersistedGrant> > GetAllAsync(string subjectId)
{
DbDataReader dr = null;
try
{
List <PersistedGrant> lst = new List <PersistedGrant>();
string strSql = "select * from identityserver where subjectId=@subjectId";
MySqlParameter[] parameters =
{
new MySqlParameter("@subjectId", MySqlDbType.VarChar, 1000)
};
parameters[0].Value = subjectId;
using (dr = await DbHelperMySQL.ExecuteReaderAsync(DBConnection.UsersSystem, strSql, parameters))
{
while (await dr.ReadAsync())
{
lst.Add(DataRowToModel(dr));
}
}
return(lst);
}
catch (Exception err)
{
throw err;
}
finally
{
if (dr != null || dr.IsClosed)
{
dr.Dispose();
}
}
}
public async Task <UserShowModel> GetUserModel(long userid)
{
DbDataReader dr = null;
UserShowModel entity = null;
try
{
string strSql = "select nickname,headerpic from users where usersid=@userid";
MySqlParameter[] para =
{
new MySqlParameter("@userid", MySqlDbType.Int64)
};
para[0].Value = userid;
using (dr = await DbHelperMySQL.ExecuteReaderAsync(DBConnection.UsersSystem, strSql, para))
{
while (await dr.ReadAsync())
{
entity = new UserShowModel();
entity.nickname = dr[0].ToString();
entity.headportrait = dr[1].ToString();
}
}
return(entity);
}
catch (Exception err)
{
throw err;
}
finally
{
if (dr != null || dr.IsClosed)
{
dr.Dispose();
}
}
}
