public static LdapUser[] SearchLdapByFirstName(string firstName) { List <LdapUser> users = new List <LdapUser>(); DirectoryEntry entry = new DirectoryEntry(LdapPath); LoggingHelper.Debug(entry.Path); DirectorySearcher searcher = new DirectorySearcher(entry); searcher.Filter = "(&(objectClass=user)(objectCategory=person)(givenName=" + firstName + "*))"; SearchResult result; SearchResultCollection resultCol = searcher.FindAll(); if (resultCol != null) { for (int counter = 0; counter < resultCol.Count; counter++) { result = resultCol[counter]; if (result.Properties.Contains("samaccountname")) { users.Add(new LdapUser() { WindowsLogin = (String)result.Properties["samaccountname"][0], FirstName = (result.Properties["givenName"].Count > 0 ? (String)result.Properties["givenName"][0] : null), LastName = (result.Properties["sn"].Count > 0 ? (String)result.Properties["sn"][0] : null), Email = (result.Properties["mail"].Count > 0 ? (String)result.Properties["mail"][0] : null) }); } } } return(users.ToArray <LdapUser>()); }
public override IDbConnection CreateOpenConnection() { OracleConnection connection = (OracleConnection)CreateConnection(); connection.Open(); LoggingHelper.Debug("Oracle: Connection is open!"); return(connection); }
public override void CreateCommand(string Sql, CommandType Type) { try { base.Command = new OracleCommand(Sql, (OracleConnection)base.Connection); base.Command.CommandType = Type; } catch (Exception ex) { LoggingHelper.Debug("-----Oracle Create Command Error----"); LoggingHelper.Debug(ex.Message); } }
private OracleHelper(string ConnectionString) { try { LoggingHelper.Debug("OracleHelper: Start Connection"); base.Connection = new OracleConnection(ConnectionString); base.Command = new OracleCommand(); base.ConnectionString = ConnectionString; } catch (Exception ex) { LoggingHelper.Debug("OracleHelper: " + ex.Message); } }
public void CreateTransaction(string Sql, CommandType Type) { try { base.Command = new OracleCommand(); base.Command.CommandText = Sql; base.Command.Transaction = base.Transaction; base.Command.Connection = base.Connection; base.Command.CommandType = Type; } catch (Exception ex) { LoggingHelper.Debug("-----Oracle Create Transaction Error----"); LoggingHelper.Debug(ex.Message); } }
public override bool CloseConnection() { bool flag = false; try { base.Connection.Close(); flag = true; } catch (Exception ex) { LoggingHelper.Debug("-----Oracle CloseConnection Error----"); LoggingHelper.Debug(ex.Message); flag = false; } return(flag); }
public DataTable ExecuteReaderToDataTable(string TableName) { try { DataTable dt = new DataTable(TableName); OracleDataAdapter da = new OracleDataAdapter((OracleCommand)this.Command); da.Fill(dt); da.Dispose(); return(dt); } catch (Exception ex) { LoggingHelper.Debug("-----Oracle ExecuteReaderToDataTable Error----"); LoggingHelper.Debug(ex.Message); return(null); } }
public static OracleHelper GetOracleInstance(string ConnectionString) { LoggingHelper.Debug("-----Start get instance-----"); try { if (OracleHelper.instance == null) { OracleHelper.instance = new OracleHelper(ConnectionString); } } catch (Exception ex) { LoggingHelper.Debug("-----Oracle getInstance Error----"); LoggingHelper.Debug(ex.Message); } return(OracleHelper.instance); }
public override DataSet ExecuteReader(string ParamOut, string TableSpaceName) { OracleDataReader reader = null; DataSet ds = new DataSet(); try { OracleParameter paramReturn = new OracleParameter(ParamOut, OracleDbType.RefCursor, ParameterDirection.Output); ((OracleCommand)base.Command).Parameters.Add(paramReturn); int result = ((OracleCommand)base.Command).ExecuteNonQuery(); OracleRefCursor refCur = (OracleRefCursor)paramReturn.Value; reader = refCur.GetDataReader(); do { DataTable schema = reader.GetSchemaTable(); DataTable dt = new DataTable(TableSpaceName); foreach (DataRow dr in schema.Rows) { dt.Columns.Add(new DataColumn(dr["ColumnName"].ToString(), Type.GetType(dr["DataType"].ToString()))); } while (reader.Read()) { DataRow dr = dt.NewRow(); for (int i = 0; i < reader.FieldCount; i++) { dr[i] = (Object)reader.GetValue(i); } dt.Rows.Add(dr); } ds.Tables.Add(dt); } while (reader.NextResult()); } catch (Exception ex) { LoggingHelper.Debug("-----Oracle ExecuteReader with ParamOut Error----"); LoggingHelper.Debug(ex.Message); return(null); } return(ds); }
public override object ExecuteReader(string ParamOut) { OracleDataReader reader = null; try { OracleParameter paramReturn = new OracleParameter(ParamOut, OracleDbType.RefCursor, ParameterDirection.Output); ((OracleCommand)base.Command).Parameters.Add(paramReturn); int result = ((OracleCommand)base.Command).ExecuteNonQuery(); OracleRefCursor refCur = (OracleRefCursor)paramReturn.Value; reader = refCur.GetDataReader(); } catch (Exception ex) { LoggingHelper.Debug("-----Oracle ExecuteReader with ParamOut Error----"); LoggingHelper.Debug(ex.Message); return(null); } return(reader); }
public override bool OpenConnection() { bool flag = false; try { if (base.Connection.State != ConnectionState.Closed) { base.Connection.Close(); } base.Connection.Open(); base.Command.Connection = base.Connection; flag = true; } catch (Exception ex) { LoggingHelper.Debug("-----Oracle OpenConnection Error----"); LoggingHelper.Debug(ex.Message); flag = false; } return(flag); }
public static bool ValidateUser(string windowsUserName, string password) { try { DirectoryEntry entry = new DirectoryEntry(@"LDAP://" + LdapServer, windowsUserName, password); DirectorySearcher searcher = new DirectorySearcher(entry); searcher.Filter = "(&(objectCategory=person)(samAccountName=" + windowsUserName + "))"; SearchResult result = searcher.FindOne(); if (result != null) { LoggingHelper.Debug(windowsUserName + " can access!!"); return(true); } LoggingHelper.Debug(windowsUserName + " is not authorized!!"); return(false); } catch (Exception ex) { LoggingHelper.Debug(windowsUserName + " is not authorized!! (" + ex.Message + ")"); return(false); } }
public static bool UserExists(string windowsUserName) { try { using (var ctx = new PrincipalContext(ContextType.Domain, LdapServer, LdapComponent)) { var user = UserPrincipal.FindByIdentity(ctx, windowsUserName); if (user != null) { return(true); } else { return(false); } } } catch (Exception ex) { LoggingHelper.Debug(windowsUserName + " is not authorized!! (" + ex.Message + ")"); return(false); } }