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);
}
}
