public override IList <OpenIdSettingsInfo> GetConfigedItems() { IList <OpenIdSettingsInfo> list = new List <OpenIdSettingsInfo>(); DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM aspnet_OpenIdSettings"); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { while (reader.Read()) { OpenIdSettingsInfo item = MemberProvider.PopulateOpenIdSettings(reader); list.Add(item); } } return(list); }
public override OpenIdSettingsInfo GetOpenIdSettings(string openIdType) { OpenIdSettingsInfo info = null; DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM aspnet_OpenIdSettings WHERE LOWER(OpenIdType)=LOWER(@OpenIdType)"); this.database.AddInParameter(sqlStringCommand, "OpenIdType", DbType.String, openIdType.ToLower()); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { info = MemberProvider.PopulateOpenIdSettings(reader); } } return(info); }
public override OpenIdSettingsInfo GetOpenIdSettings(string openIdType) { OpenIdSettingsInfo result = null; System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM aspnet_OpenIdSettings WHERE LOWER(OpenIdType)=LOWER(@OpenIdType)"); this.database.AddInParameter(sqlStringCommand, "OpenIdType", System.Data.DbType.String, openIdType.ToLower()); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { if (dataReader.Read()) { result = MemberProvider.PopulateOpenIdSettings(dataReader); } } return(result); }
public override IList <OpenIdSettingsInfo> GetConfigedItems() { IList <OpenIdSettingsInfo> list = new List <OpenIdSettingsInfo>(); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_OpenIdSettings WHERE UserId=@UserId"); this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, HiContext.Current.SiteSettings.UserId.Value); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { while (dataReader.Read()) { OpenIdSettingsInfo item = MemberProvider.PopulateOpenIdSettings(dataReader); list.Add(item); } } return(list); }
public override OpenIdSettingsInfo GetOpenIdSettings(string openIdType) { OpenIdSettingsInfo result = null; System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_OpenIdSettings WHERE UserId=@UserId AND LOWER(OpenIdType)=LOWER(@OpenIdType)"); this.database.AddInParameter(sqlStringCommand, "OpenIdType", System.Data.DbType.String, openIdType.ToLower()); this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, HiContext.Current.SiteSettings.UserId.Value); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { if (dataReader.Read()) { result = MemberProvider.PopulateOpenIdSettings(dataReader); } } return(result); }