Free Tools

Krischu wrote:

Is there a tool that can achieve this?

Krischu wrote:

do I have to write it myself?

Boolean retVal = false;
ContextMgr.Instance.ContextValues.Add("Computer Name", Environment.MachineName);
ContextMgr.Instance.ContextValues.Add("Startup Time", DateTime.Now);
IPAddress[] ips = Dns.GetHostAddresses("BubbaComputer");
ContextMgr.Instance.ContextValues.Add("IP Addresses", ips);
dynamic machineName = "";
retVal = ContextMgr.Instance.ContextValues.TryGetValue("Computer Name", out machineName);
dynamic startupTime = "";
retVal = ContextMgr.Instance.ContextValues.TryGetValue("Startup Time", out startupTime);
dynamic hostAddresses = null;
retVal = ContextMgr.Instance.ContextValues.TryGetValue("IP Addresses", out hostAddresses);

ContextMgr.Instance.Dispose();

String GetFullExceptionMessage(this Exception ex2Examine, Boolean getDataCollection, Boolean getStackTrace)

Boolean Contains(this String source, String toCheck, StringComparison strComp)

Int32 ContainsHowMany(this String source, String toCheck, Boolean ignoreCase = false)

Boolean ConvertToBoolean(this String valueToExamine, out Boolean isBoolean)

Boolean IsBoolean(this String valueToExamine)

Boolean IsOnlyDigits(this String testString, Boolean includePeriod = false)

String GetOnlyDigits(this String testString, Boolean includePeriod = false)

String GetOnlyLetters(this String testString, Boolean includeSpace = false)

String GetOnlyLettersAndDigits(this String testString, Boolean includePeriodAndSpace = false)

Boolean IsOnlyLetters(this String testString, Boolean includeSpace = false)

Boolean IsOnlyLettersAndOrDigits(this String testString, Boolean includePeriodAndSpace = false)

Boolean IsEmailFormat(this String email)

DateTime GetDateTime(this String dateString, DateTime dateDefault)

Decimal GetDecimal(this String numberString, Decimal decimalDefault)

Int32 GetInt32(this String numberString, Int32 integerDefault)

Int64 GetInt64(this String numberString, Int64 integerDefault)

Object GetDefaultValue(this Type t)

DistanceUnitsOfMeasureEnum
Unassigned = 0,
Miles = 1,
Kilometers = 2,
Feet = 3,
Meters = 4

AddressGeoData
Double Latitude1
Double Longitude1
Double Altitude1
Double Latitude2
Double Longitude2
Double Altitude2
Double LinearDistance (value is calculated, not set)
DistanceUnitsOfMeasureEnum UnitsOfMeasure;

AddressGeoData(Double pLatitude1, Double pLongitude1, Double pAltitude1, Double pLatitude2, Double pLongitude2, Double pAltitude2, DistanceUnitsOfMeasureEnum pUnitsOfMeasure)

void SetUnitsOfMeasure(DistanceUnitsOfMeasureEnum lngUnitsOfMeasure)
void SetLinearDistance(Double dDistance)

String RowDelimiter

String ColumnDelimiter

String TableDelimiter

String FullComputerName

String GetDNSName(String pComputerName = "")

String CurDir

Boolean AmIRunningInTheIDE

Boolean IsInDomain()

String GetComputerDomainName()

String GetFullComputerDomainName()

Boolean IsDaylightSavingsTime(DateTime dtmToTest)

Boolean IsDaylightSavingsTime()

String CurrentTimeZoneDaylightName

String CurrentTimeZoneName

Int32 Asc(String strChar)

String Hex(Int32 lngValue)

Int32 GetCurrentCPUUsage()

Int32 AvailableRAMinMB()

PingReply Ping(String strHostName, Int32 lngTimeout)

void GetLinearDistances(ref List<AddressGeoData> objAddressList)

Double GetLinearDistance(double Latitude1, double Longitude1, double Altitude1, double Latitude2,
double Longitude2, double Altitude2, DistanceUnitsOfMeasureEnum lngUnitsOfMeasure)

Double GetLinearDistance(Double Latitude1, Double Longitude1, Double Altitude1, Double Latitude2, Double Longitude2, Double Altitude2, Boolean UseMiles)

Double GetLinearDistance(Double Latitude1, Double Longitude1, Double Latitude2, Double Longitude2,
DistanceUnitsOfMeasureEnum UnitsOfMeasure)

Double RadianToDegree(Double Coordinate)

Double CelciusToFahrenheit(Double DegC)

Double FahrenheitToCelsius(Double DegF)

String StringToBase64(String String2Convert)

String Base64ToString(String ByteString64)

List<ManagementObject> GetNetworkPrinters()

void SetIntBitValue(ref Int32 intValue, Int32 bitPlaceValue, Boolean setBitOn)

Boolean GetIntBitValue(Int32 intValue, Int32 bitPlaceValue)

String GetStackInfo()

String GetStackInfo(Exception ex)

String GetFullDateTimeStampForFileName(DateTime dtmDate)

Boolean IsFileText(out Encoding lngEncoding, String strFileName, Int32 lngNumCharactersToRead)

Int32 GetTotalHDDFreeSpace(String pDriveName)

Int32 GetTotalHDDSize(String pDriveName)

Int32 GetMinPasswordLength()

Boolean IsIPAddress(String pValue, out IPAddress pIPValue)

String AssemblyTitle

String AssemblyVersion

String AssemblyDescription

String AssemblyProduct

String AssemblyCopyright

String AssemblyCompany

Boolean WriteToLog(String logFileName, String mainMessage, String secondMessage)

// Usings

using Jeff.Jones.JLogger;
using Jeff.Jones.JHelpers;
// Setting a class-wide variable. What you set may
// be different for development, QA, production, and troubleshooting production.
// This global value for the program is usually stored in some
// configuration data location.

LOG_TYPE m_DebugLogOptions = LOG_TYPE.Error | LOG_TYPE.Informational |
         LOG_TYPE.ShowTimeOnly |
         LOG_TYPE.Warning |
         LOG_TYPE.HideThreadID |
         LOG_TYPE.ShowModuleMethodAndLineNumber |
         LOG_TYPE.System |
         LOG_TYPE.SendEmail;

// Setting variables used to configure the Logger
// Typically in the programs startup code, as early as possible.
Boolean response = false;
String filePath = CommonHelpers.CurDir + @"\";
String fileNamePrefix = "MyLog";
Int32 daysToRetainLogs = 30;

// Setting the Logger data so it knows how to build a log file, and
// how long to keep them. The initial debug log options is set here,
// and can be changed programmatically at anytime in the
// Logger.Instance.DebugLogOptions property.

response = Logger.Instance.SetLogData(filePath, fileNamePrefix, daysToRetainLogs, logOptions, "");

// These next lines may be omitted if not sending email from your log.
// Email setup.
Int32 smtpPort = 587;
Boolean useSSL = true;
List<String> sendToAddresses = new List<String>();
sendToAddresses.Add("MyBuddy@somewhere.net");
sendToAddresses.Add("John.Smith@anywhere.net");
response = Logger.Instance.SetEmailData("smtp.mymailserver.net", "logonEmailAddress@work.net",
                                        "logonEmailPassword", smtpPort, sendToAddresses,
                                        "emailFromAddress@work.net", emailReplyToAddress@work.net>",
                                        useSSL);

// End of email setup.

// This starts the log operation AFTER you have set the initial parameters.
response = Logger.Instance.StartLog();

// This ends the configuration example

// Example of use in a method
void SomeMethod()
{
  // Use of the Flow LOG_TYPE shows in the log when a method was entered,
  // and exited. Useful for debugging, QA, and development. The Flow bit
  // mask is usually turned off in production to reduce log size.
  if ((m_DebugLogOptions & LOG_TYPE.Flow) == LOG_EXCEPTION_TYPE.Flow)
    {
      Logger.Instance.WriteToDebugLog(LOG_TYPE.Flow, "1st line in method","");
    }

  // This variable notes when the method started.
  DateTime methodStart = DateTime.Now;

  try
    {
    // Do some work here
    // This is an example of logging used during
    // process flow. The bitmask used here does not
    // have to be "Informational", and may be turned
    // off in production.
    if ((m_DebugLogOptions & LOG_TYPE.Informational) == LOG_TYPE.Informational)
    {
        Logger.Instance.WriteToDebugLog(LOG_TYPE.Informational, 
                                        "Primary message", "Optional detail message");
    }

    // Do some more work
  }
  catch (Exception exUnhandled)
  {
    // Capture some runtime data that may be useful in debugging.
    exUnhandled.Data.Add("SomeName", "SomeValue");
    if ((m_DebugLogOptions & LOG_TYPE.Error) == LOG_TYPE.Error)
    {
       Logger.Instance.WriteToDebugLog(LOG_TYPE.Error, exUnhandled, "Optional detail message");
    }
  }
  finally
    {
      if ((m_DebugLogOptions & LOG_TYPE.Performance) == LOG_TYPE.Performance)
      {
        TimeSpan elapsedTime = DateTime.Now - methodStart;
        Logger.Instance.WriteToDebugLog(LOG_TYPE.Performance,
              String.Format("END; elapsed time = [{0:mm} mins, {0:ss} secs, {0:fff} msecs].",
              objElapsedTime));
      }

      // Capture the flow for exiting the method.

      if ((m_DebugLogOptions & LOG_TYPE.Flow) == LOG_EXCEPTION_TYPE.Flow)
      {
        Logger.Instance.WriteToDebugLog(LOG_TYPE.Flow, "Exiting method", "");
      }
} // END of method

DEFAULT_DEBUG_LOG_OPTIONS

DEFAULT_LOG_RETENTION

LOG_CACHE_FREQUENCY

DaysToRetainLogs

DebugLogOptions

Dispose()

EmailEnabled

EmailLogonName

EmailPassword

EmailServer

FromAddress

IsDisposing

LogFileName

LogPath

ReplyToAddress

SendToAddresses

Boolean SetEmailData(String emailServer,  
                     String emailLogonName,  
                     String emailPassword,  
                     Int32 smtpPort,  
                     List<String> sendToAddresses,  
                     String fromAddress,  
                     String replyToAddress,
                     Boolean useSSL)

Boolean SetLogData(String logPath,  
                   String logFileNamePrefix,  
                   Int32 daysToRetainLogs,  
                   LOG_TYPE debugLogOptions,  
                   String emergencyLogPrefixName = DEFAULT_EMERG_LOG_PREFIX)

SMTPPort

Boolean StartLog()

Boolean StopLog()

UseSSL

Boolean WriteDebugLog(LOG_TYPE pExceptionType,  
                      Exception pExceptionToUse,  
                      String pOptionalLogMessage)

Boolean WriteDebugLog(LOG_TYPE pExceptionType,  
                      String message,  
                      String secondaryMessage = "")

DBReturnValue()

DBReturnValue(List<SqlParameter> sqlParams, Int32 retCode, String errorMessage)

List<SqlParameter>

Int32 RetCode

String ErrorMessage

System.Data.DataSet Data

Dispose()

JDataAccessSQL()

JDataAccessSQL(String server, String defaultDB, Boolean useAuthentication, String username,
               String password, Int32 connectionTimeout, Int32 commandTimeout, 
               Int32 connectRetryCount = 3, Int32 connectRetryInterval = 10,
               String applicationName = "", String workstationID = "", 
               Int32 portNumber = 1433, Boolean connectionPooling = true)

String Server

String DefaultDB

Boolean UseAuthentication

String UserName

String Password

Int32 ConnectionTimeout

Int32 CommandTimeout

Int32 PortNumber

Int32 ConnectRetryCount

Int32 ConnectRetryInterval

String ApplicationName

String WorkstationID

Boolean UseConnectionPooling

String ConnectionString

async Task<Boolean> CheckConnectionAsync()

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
"CookieStore", true, "", "", 10, 20, 3, 10, "MyProgram", "MyComputer", 20161,
true);
Boolean retVal = dac.CheckConnectionAsync().Result;
dac.Dispose();
dac = null;

async Task<DBReturnValue> ExecuteQueryAsync(
                              String cmd, // SQL Command
                              Boolean isSP, // True if a stored procedure, false if not.
                              List<SqlParameter> sqlParams) // List of parameter objects, or
                                                            // null if no parameters used.

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                               "CookieStore", true, "", "", 10, 20, 
                                               3, 10, "MyProgram", "MyComputer", 20161, true);
String cmd = "SELECT * FROM dbo.Cookies WHERE ID > @id";
List<SqlParameter> queryParams = new List<SqlParameter>();
queryParams.Add(new SqlParameter
  {
     DbType = DbType.Int64,
     ParameterName = "@id",
     Value = 0
  });
DBReturnValue dbRetVal = dac.ExecuteQueryAsync(cmd, false, queryParams).Result;
DataSet retVal = dbRetVal.Data;
dac.Dispose();
dac = null;

async Task<DBReturnValue> ExecuteStatementAsync(
                                String cmd, // SQL Command
                                Boolean isSP, // True if a stored procedure, false if not.
                                List<SqlParameter> sqlParams) // List of parameter objects, or null.

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                 "CookieStore", true, "", "", 10, 20, 
                                 3, 10, "MyProgram", "MyComputer", 20161, true);
String cmd = "UPDATE dbo.Cookies SET Name='Raspberry' WHERE ID = \@id";
List<SqlParameter> queryParams = new List<SqlParameter>();
queryParams.Add(new SqlParameter
{
  DbType = DbType.Int64,
  ParameterName = "@id",
  Value = 1
});
DBReturnValue dbRetVal = dac.ExecuteStatementAsync(cmd, false, queryParams).Result;
dac.Dispose();
dac = null;

async Task<SQLServerData> GetServerPropertiesAsync()

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                "CookieStore", true, "", "", 10, 20, 
                                3, 10, "MyProgram", "MyComputer", 20161, true);
SQLServerData retVal = dac.GetServerPropertiesAsync().Result;
dac.Dispose();
dac = null;

async Task<List<String>> GetDatabaseNamesAsync()

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                 "CookieStore", true, "", "", 10, 20, 
                                 3, 10, "MyProgram", "MyComputer", 20161, true);
List<String> retVal = dac.GetDatabaseNamesAsync().Result;
dac.Dispose();
dac = null;

async Task<DataTable> GetDatabaseRelationshipsAsync(String targetDatabase = "")

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                 "CookieStore", true, "", "", 10, 20, 
                                 3, 10, "MyProgram", "MyComputer", 20161, true);
DataTable retVal = dac.GetDatabaseRelationshipsAsync("Test").Result;
dac.Dispose();
dac = null;

async Task<List<String>> GetTableNamesAsync(String targetDatabase = "")

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                 "CookieStore", true, "", "", 10, 20, 
                                 3, 10, "MyProgram", "MyComputer", 20161, true);
List<String> retVal = dac.GetTableNamesAsync().Result;
dac.Dispose();
dac = null;

async Task<DataTable> GetSchemaAsync(SchemaTypesEnum schemaType, String targetDatabase = "")

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                 "CookieStore", true, "", "", 10, 20, 
                                 3, 10, "MyProgram", "MyComputer", 20161, true);
DataTable retVal = dac.GetSchemaAsync(SchemaTypesEnum.AllColumns).Result;
dac.Dispose();
dac = null;

async Task<String> ConvertTableToCSClassAsync(DataTable dt, String namespaceName, String className)

SchemaFactory fac = new SchemaFactory();
String csClass = fac.ConvertTableToCSClassAsync(retVal, "MyNamespace.Something",
                                            schemaType.ToString() + "DO").Result;
System.IO.File.WriteAllText(Environment.CurrentDirectory + @"\" + schemaType.ToString() + "DO.cs",
                            csClass);
fac = null;

async Task<String> GetFactoryMethodSchemaCodeAsync(DataTable dt, SchemaTypesEnum schemaType, 
                                                  String altDOName = "Test")

SchemaFactory fac = new SchemaFactory();
DataTable retVal = <some DataTable>
SchemaTypesEnum schemaType = <one of the SchemaTypesEnum enum values other than Undefined>
String factoryMethod = fac.GetFactoryMethodSchemaCodeAsync(retVal, schemaType).Result;
System.IO.File.AppendAllText(Environment.CurrentDirectory + @"\SchemaFactoryMethod.cs", 
                             factoryMethod);
fac = null;

async Task<String> GetFactoryMethodCodeAsync(DataTable dt, String dOName)

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                  "CookieStore", true, "", "", 10, 20, 
                                  3, 10, "MyProgram", "MyComputer", 20161, true);
DBReturnValue retVal = dac.ExecuteQueryAsync("SELECT * FROM Cookies", false, null).Result;
DataTable retTable = retVal.Data.Tables[0];
SchemaFactory sf = new SchemaFactory();

// This gets the C# code for the class representing the table data,
// in this example called CookieDO..
String tempCSFile = sf.ConvertTableToCSClassAsync(retTable,
                                              "YourNamespace.Cookies", "CookieDO").Result;

// This gets the C# code to populate one instance of the class (the code created above)
// and return 1 to n instances in a List<> object. In this example, it would be
// a List<CookieDO> object.
String tempMethod = sf.GetFactoryMethodCodeAsync(retTable, "CookieDO").Result;
sf = null;
dac.Dispose();
dac = null;

async Task<String> GetDataTableContentsAsDelimitedFileAsync(DataTable dataTable, 
                                                            String fieldDelimiter)

SchemaFactory fac = new SchemaFactory();
DataTable retVal = <some DataTable>
String schema = fac.GetDataTableContentsAsDelimitedFileAsync(retVal, ((Char)28).ToString()).Result;
fac = null;

async Task<String> GetDataTableSchemaAsDelimitedFileAsync(DataTable dataTable, 
                                                      String fieldDelimiter)

SchemaFactory fac = new SchemaFactory();
DataTable retVal = <some DataTable>
String schema = fac.GetDataTableSchemaAsDelimitedFileAsync(retVal, ((Char)28).ToString()).Result;
fac = null;

JDataAccessSQL dac = new JDataAccessSQL(@"SQLServerABC\SomeInstance",
                                  "CookieStore", true, "", "", 10, 20, 
                                  3, 10, "MyProgram", "MyComputer", 20161, true);
SchemaFactory fac = new SchemaFactory();
DataTable retVal = <some DataTable>
List<AllColumnsDO> returnValue = fac.GetAllColumnsDO(dac).Result;
fac = null;

async Task<List<AllColumnsDO>> GetAllColumnsDO(JDataAccessSQL dac)
async Task<List<ColumnsDO>> GetColumnsDO(JDataAccessSQL dac)
async Task<List<ColumnSetColumnsDO>> GetColumnSetColumnsDO(JDataAccessSQL dac)
async Task<List<DatabasesDO>> GetDatabasesDO(JDataAccessSQL dac)
async Task<List<DataSourceInformationDO>> GetDataSourceInformationDO(JDataAccessSQL dac)
async Task<List<DataTypesDO>> GetDataTypesDO(JDataAccessSQL dac)
async Task<List<ForiegnKeysDO>> GetForiegnKeysDO(JDataAccessSQL dac)
async Task<List<IndexColumnsDO>> GetIndexColumnsDO(JDataAccessSQL dac)
async Task<List<IndexesDO>> GetIndexesDO(JDataAccessSQL dac)
async Task<List<MetaDataCollectionsDO>> GetMetaDataCollectionsDO(JDataAccessSQL dac)
async Task<List<ProcedureParametersDO>> GetProcedureParametersDO(JDataAccessSQL dac)
async Task<List<ProceduresDO>> GetProceduresDO(JDataAccessSQL dac)
async Task<List<ReservedWordsDO>> GetReservedWordsDO(JDataAccessSQL dac)
async Task<List<StructuredTypeMembersDO>> GetStructuredTypeMembersDO(JDataAccessSQL dac)
async Task<List<TablesDO>> GetTablesDO(JDataAccessSQL dac)
async Task<List<UserDefinedTypesDO>> GetUserDefinedTypesDO(JDataAccessSQL dac)
async Task<List<UsersDO>> GetUsersDO(JDataAccessSQL dac)
async Task<List<ViewColumnsDO>> GetViewColumnsDO(JDataAccessSQL dac)
async Task<List<ViewsDO>> GetViewsDO(JDataAccessSQL dac)