internal LoginInfo GetLoginInfo(int userId) { var param = new ParameterCollection(); param.Add("@Id", DbType.Int32, userId); var result = SqlAccessor.ExecuteQuery(DatabaseSetting.Authentication.ConnectionString, DatabaseSetting.Authentication.StoredProcedures.UsersSelectByUserName, param); return((result != null && result.Rows.Count > 0) ? ToLoginInfo(result.Rows[0]) : null); }
public User Get(string userName) { var param = new ParameterCollection(); param.Add("@UserName", DbType.AnsiString, userName); var result = SqlAccessor.ExecuteQuery(DatabaseSetting.Authentication.ConnectionString, DatabaseSetting.Authentication.StoredProcedures.UsersSelectByUserName, param); return((result != null && result.Rows.Count > 0) ? ToUser(result.Rows[0]) : null); }