Archive for Gennaio 31st, 2008

try catch

CodeKeep C# Feed Gennaio 31st, 2008

Description: Try catch templete for all methods

Link: http://www.codekeep.net/snippets/ffba61e6-9a96-4a18-bbde-8e8eed0aee6f.aspx

try
{

}
catch (Exception ex)
{
	List<string> Variable_List = new List<string>();
        Variable_List.Add(": " + "");
        Exception_Log exLog = new Exception_Log(ex.GetType().ToString(), ex.Message, DateTime.Now, Variable_List);
        Exception_Log_Writer_Reader exWriter = new Exception_Log_Writer_Reader(@"..\..\XML_Exceptions.xml", exLog);
}

Arguments

CodeKeep C# Feed Gennaio 31st, 2008

Description: for command line

Link: http://www.codekeep.net/snippets/95e7dd9e-0709-4bb6-a0ac-c0e17bcfe10e.aspx

using System;
using System.Collections.Specialized;
using System.Text.RegularExpressions;

namespace CommandLine
{
    /// <summary>
    /// Arguments class
    /// </summary>
    public class Arguments
    {
        // Variables
        private StringDictionary Parameters;

        // Constructor
        public Arguments(string[] Args)
        {
            Parameters = new StringDictionary();
            Regex Spliter = new Regex(@"^-{1,2}|^/|=|:", RegexOptions.IgnoreCase | RegexOptions.Compiled);
            Regex Remover = new Regex(@"^['""]?(.*?)['""]?$", RegexOptions.IgnoreCase | RegexOptions.Compiled);
            string Parameter = null;
            string[] Parts;

            // Valid parameters forms:
            // {-,/,--}param{ ,=,:}((",')value(",'))
            // Examples: -param1 value1 --param2 /param3:"Test-:-work" /param4=happy -param5 '--=nice=--'
            foreach (string Txt in Args)
            {
                // Look for new parameters (-,/ or --) and a possible enclosed value (=,:)
                Parts = Spliter.Split(Txt, 3);
                switch (Parts.Length)
                {
                    // Found a value (for the last parameter found (space separator))
                    case 1:
                        if (Parameter != null)
                        {
                            if (!Parameters.ContainsKey(Parameter))
                            {
                                Parts[0] = Remover.Replace(Parts[0], "$1");
                                Parameters.Add(Parameter, Parts[0]);
                            }
                            Parameter = null;
                        }
                        // else Error: no parameter waiting for a value (skipped)
                        break;
                    // Found just a parameter
                    case 2:
                        // The last parameter is still waiting. With no value, set it to true.
                        if (Parameter != null)
                        {
                            if (!Parameters.ContainsKey(Parameter)) Parameters.Add(Parameter, "true");
                        }
                        Parameter = Parts[1];
                        break;
                    // Parameter with enclosed value
                    case 3:
                        // The last parameter is still waiting. With no value, set it to true.
                        if (Parameter != null)
                        {
                            if (!Parameters.ContainsKey(Parameter)) Parameters.Add(Parameter, "true");
                        }
                        Parameter = Parts[1];
                        // Remove possible enclosing characters (",')
                        if (!Parameters.ContainsKey(Parameter))
                        {
                            Parts[2] = Remover.Replace(Parts[2], "$1");
                            Parameters.Add(Parameter, Parts[2]);
                        }
                        Parameter = null;
                        break;
                }
            }
            // In case a parameter is still waiting
            if (Parameter != null)
            {
                if (!Parameters.ContainsKey(Parameter)) Parameters.Add(Parameter, "true");
            }
        }

        // Retrieve a parameter value if it exists
        public string this[string Param]
        {
            get
            {
                return (Parameters[Param]);
            }
        }

    }//end class
}//end namespace

DataSet- Reading from Integra

CodeKeep C# Feed Gennaio 31st, 2008

Description: Integra

Link: http://www.codekeep.net/snippets/5ed71765-7a84-462a-aeaf-1139473b97e8.aspx

public static DataSet GetDataset(string strSQL, string strConnection)
        {
            try
            {
                DataSet ds = new DataSet();
                OleDbDataAdapter adap = new OleDbDataAdapter();
                Integra.iData.Database.Open(strConnection);
                OleDbCommand cmd = new OleDbCommand(strSQL, Integra.iData.Database.Connection);
                adap.SelectCommand = cmd;
                adap.Fill(ds);
                Integra.iData.Database.Close();
                return ds;
            }
            catch (Exception ex)
            {
                SystemFail("Exception: iData.Operation.GetDataset() - Message: " + ex.Message.ToString());
                throw new Exception(ex.Message);
            }
        }