C# Discussion Boards - CodeProject

Re: Sense of making my own Timestamp class?

BillWoodruff4-Feb-14 3:56

BillWoodruff

4-Feb-14 3:56

Marco Bertschi wrote:
Can I achieve the same with System.DateTime?

Based on the observation that all of your Properties, except milliseconds, are 'get only, I would say "yes," if you were willing to accept the limitations of inheriting from a data-structure like a Tuple<T1,T2,T3> ... given the fact that Tuple instances are immutable.

I don't claim to have thought through your use scenario here in any great depth, or to fully understand your goals here, but here's a quick sketch:

using System;

namespace Feb4_2014_InheritFromTupleT1T2T3
{
    public class DateTimeEx: Tuple<DateTime, long, Int32>
    {
        private const string msPrefix = ":Z";
        private const string tzPlus = "+";

        private string tzPre;

        public DateTime dateTime { set; get; }

        public long milliSeconds { set; get; }

        public Int32 utcOffset { set; get; }

        public DateTimeEx(DateTime datetime, long millisec, Int32 utcoff) : base(datetime, millisec, utcoff)
        {
            dateTime = datetime;
            milliSeconds = millisec;
            utcOffset = utcoff;
        }

        public override string ToString()
        {
            tzPre = (milliSeconds < 0) ? "" : tzPlus;

            return string.Format("{0}-{1}-{2}T{3}:{4}:{5}.{6}Z{7}{8}", Item1.Year, Item1.Month, Item1.Day, Item1.Hour, Item1.Minute, Item1.Second, milliSeconds, tzPre, utcOffset);
        }
    }
}

Here's the results of a simple test:

DateTime rightNow = DateTime.Now;

DateTimeEx dEx1 = new DateTimeEx(rightNow, 0, 7);
DateTimeEx dEx2 = new DateTimeEx(rightNow, 0, 7);
DateTimeEx dEx3 = new DateTimeEx(rightNow, 230, 4);

Console.WriteLine(dEx1); // => 2014-2-4T21:35:19.0Z+7
Console.WriteLine(dEx3); // => 2014-2-4T21:38:1.230Z+4

Console.WriteLine(dEx1.Equals(dEx2)); // => true
Console.WriteLine(dEx1.Equals(dEx3)); // => false

I would hope what you would get from this is being able to use Parse, and ParseExact on the DateTime component, and, hopefully, save you from writing some of the overloads. But, whether you could use in the context of whatever your doing with SysLog: I ain't got a clue.

Hope this is helpful.

“But I don't want to go among mad people,” Alice remarked.

“Oh, you can't help that,” said the Cat: “we're all mad here. I'm mad. You're mad.”

“How do you know I'm mad?” said Alice.

“You must be," said the Cat, or you wouldn't have come here.” Lewis Carroll

Re: Sense of making my own Timestamp class?

Marco Bertschi4-Feb-14 4:03

Marco Bertschi

4-Feb-14 4:03

BillWoodruff wrote:
Based on the observation that all of your Properties, except milliseconds, are 'get only, I would say "yes," if you were willing to accept the limitations of inheriting from a data-structure like a Tuple<T1,T2,T3> ... given the fact that Tuple instances are immutable.

The read-only behavior will change soon, I only have to implement the value validation first.

BillWoodruff wrote:
would hope what you would get from this is being able to use Parse, and ParseExact on the DateTime component,

I will almost certainly not be able to, since the UTC-Offset at the end (after the "Z") can't be handled by these functions. An overload may make sense, but will eventually end up in a big mess with the comparison operators.

I did some thinking myself in the meantime, and I consider an overloading of DateTime bein highly unusable, especially since DateTime has to present a Date/Time pair which may change, and a Timestamp has to represent a single Date/Time/UTC-Offset pair which is not going to change after its initialization (Apart from the problems of inheriting a struct which you already have mentioned).

Clean-up crew needed, grammar spill... - Nagy Vilmos

Re: Sense of making my own Timestamp class?

jschell4-Feb-14 13:20

jschell

4-Feb-14 13:20

Marco Bertschi wrote:
What I have done so far is that I consider System.DateTime being unuseable as timestamp,

You have effectively two 'layers' which needs a 'translation' layer in between.

That doesn't require a new timestamp class. What it requires is that you create functionality that parses (and formats if needed) and that goes in your translation layer. On the C# (application side) the input/output is a DateTime. On the syslog interface side it is a string.

Re: Sense of making my own Timestamp class?

Marco Bertschi4-Feb-14 20:07

Marco Bertschi

4-Feb-14 20:07

jschell wrote:
On the C# (application side) the input/output is a DateTime.

Yes, that's why the new class has a "FromDateTime(DateTime dateTime)"-Method.

jschell wrote:
On the syslog interface side it is a string.

I am the one who provides the classes to serialize/deserialze the Syslog message, therefore a class might be useful, especially afterwards when showing the messages in the Logviewer (Ordering them by a timestamp type has almost certainly advantages over ordering them by a string which represents a timestamp).

I might be wrong in some point here (or I may not). I'll just go ahead and see what I'll learn. It's a side project which I do in my free time, so I am allowed to spend time making errors (and learning from them).

Clean-up crew needed, grammar spill... - Nagy Vilmos

Re: Sense of making my own Timestamp class?

TnTinMn6-Feb-14 12:37

TnTinMn

6-Feb-14 12:37

Marco,

In your lounge post[^] you say that you imposing RFC5424[^] as the criteria. Based on the following format that I found online, you will not be able to properly store a RFC5424 timestamp in a DateTime structure due to the possibility of the TIME-SECFRAC being allowed to have up six digits. The DateTime structure can only accommodate milliseconds (3 digits).

Quote:
TIMESTAMP = NILVALUE / FULL-DATE "T" FULL-TIME
FULL-DATE = DATE-FULLYEAR "-" DATE-MONTH "-" DATE-MDAY
DATE-FULLYEAR = 4DIGIT
DATE-MONTH = 2DIGIT ; 01-12
DATE-MDAY = 2DIGIT ; 01-28, 01-29, 01-30, 01-31 based on
; month/year
FULL-TIME = PARTIAL-TIME TIME-OFFSET
PARTIAL-TIME = TIME-HOUR ":" TIME-MINUTE ":" TIME-SECOND
[TIME-SECFRAC]
TIME-HOUR = 2DIGIT ; 00-23
TIME-MINUTE = 2DIGIT ; 00-59
TIME-SECOND = 2DIGIT ; 00-59
TIME-SECFRAC = "." 1*6DIGIT
TIME-OFFSET = "Z" / TIME-NUMOFFSET
TIME-NUMOFFSET = ("+" / "-") TIME-HOUR ":" TIME-MINUTE

You also have shown TimeStamp examples[^] that you say are valid. However these have decimal TIME-NUMOFFSET values instead of "Hours:Minutes"; again this conflicts with the specification. Is it your intent to allow these deviations?

Just courious, is there a reason that you have implemented your own GetDayMaxDaysOfMonth and Is LeapYear versus using those from the DateTimeStructure (DateTime.DaysInMonth[^], DateTime.IsLeapYear[^])?

Re: Sense of making my own Timestamp class?

Marco Bertschi6-Feb-14 21:12

Marco Bertschi

6-Feb-14 21:12

TnTinMn wrote:
In your lounge post[^] you say that you imposing RFC5424[^] as the criteria. Based on the following format that I found online, you will not be able to properly store a RFC5424 timestamp in a DateTime structure due to the possibility of the TIME-SECFRAC being allowed to have up six digits. The DateTime structure can only accommodate milliseconds (3 digits).

Thank you

TnTinMn wrote:
You also have shown TimeStamp examples[^] that you say are valid. However these have decimal TIME-NUMOFFSET values instead of "Hours:Minutes"; again this conflicts with the specification. Is it your intent to allow these deviations?

I know that these are not valid examples, brain was off while typing Blush | :O

TnTinMn wrote:
Just courious, is there a reason that you have implemented your own GetDayMaxDaysOfMonth and Is LeapYear versus using those from the DateTimeStructure (DateTime.DaysInMonth[^], DateTime.IsLeapYear[^])?

Pssst - I simply forgot about those
On the other hand side I didn't really bothered to check for something existing, since I had to learn the leap year rules anyways.

Clean-up crew needed, grammar spill... - Nagy Vilmos

Re: Sense of making my own Timestamp class?

TnTinMn9-Feb-14 10:29

TnTinMn

9-Feb-14 10:29

Marco,

My statement "The DateTime structure can only accommodate milliseconds (3 digits)" was incorrect. Unsure | :~

Sorry about that.
You can access higher resolution through the usage of the Ticks property that has a 100 nanosecond resolution[^].

You could use DateTime.TryParseExact with this format string: "yyyy-MM-dd\THH:mm:ss"
If that succeeds then, then you would need to extract the fractional second component (if it exists) as microseconds (upto 6 digits) and convert the microseconds to Ticks. Then you you can use the DateTime.AddTicks method on the DateTime value returned from the TryParseExact method.

I have put together a class to parse a TimeStamp string using this methodolgy and can make a copy of the code available if you are interested in it.

Yeah, its cold and I saw this as an interesting exercise. Smile | :)

Re: Sense of making my own Timestamp class?

Marco Bertschi9-Feb-14 19:56

Marco Bertschi

9-Feb-14 19:56

TnTinMn wrote:
You could use DateTime.TryParseExact with this format string: "yyyy-MM-dd\THH:mm:ss"

If that succeeds then, then you would need to extract the fractional second component (if it exists) as microseconds (upto 6 digits) and convert the microseconds to Ticks. Then you you can use the DateTime.AddTicks method on the DateTime value returned from the TryParseExact method.

Which is very difficult.
The biggest problem starts when you try to parse the Miliseconds directly, as in DateTime.TryParseExact(yyyy-MM-dd\THH:mm:ss.fff) where fff defines the miliseconds. DateTime can't handle any conversion if the amount of 'f' is not equal to the amount of the miliseconds, e.g.

parsing 2014-02-13\15:33:12.12 with DateTime.TryParseExact(yyyy-MM-dd\HH:mm:ss.fff) would return false, which is a crucial problem in my case since the amount of miliseconds may differ between 0 and 100000.
Of course I could populate them prior to the conversion, but then I am better of with my own class where I have full control over the conversion.

TnTinMn wrote:
I have put together a class to parse a TimeStamp string using this methodolgy and can make a copy of the code available if you are interested in it.

If you have it I'd love to see it. I have developed my own timestamp class a little further, here it is in case you are interested in it:

using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;

namespace Springlog.Com.Messaging
{
    /// <summary>
    /// Represents the Timestamp of a <see cref="SyslogMessageHeader"/>
    /// Author: Marco Bertschi, (C) 2014 Marco Bertschi
    /// </summary>
    public class SyslogTimestamp
    {
        #region Properties
        /// <summary>
        /// Returns the count of the days for a specific month in a specific year.
        /// </summary>
        /// <param name="month">month  </param>
        /// <param name="year">year</param>
        /// <returns></returns>
        static short GetDayMaxDaysOfMonth(int month, int year)
        {
            if (month != 2)
            {
                //  January       March         May           July          August        October        December
                if (month == 1 || month == 3 || month == 5 || month == 7 || month == 8 || month == 10 || month == 12)
                {
                    return 31;
                }
                else // April, June, September, November
                {
                    return 30;
                }
            }
            else //February
            {
                if (IsLeapYear(year))
                {
                    return 29;
                }
                return 28;
            }
        }
        /// <summary>
        /// Returns true if the argument is a leap year
        /// </summary>
        /// <param name="year">The year number to check</param>
        /// <returns></returns>
        private static bool IsLeapYear(int year)
        {
            if (year % 4 == 0)
            {
                if (year % 100 == 0)
                {
                    if (year % 400 == 0)
                    {
                        return true;
                    }
                    return false;
                }
                return true;
            }
            return false;
        }

        /// <summary>
        /// The part of the Timestamp which represents the year.
        /// </summary>
        int year;
        /// <summary>
        /// Gets the year part of the Timestamp.
        /// </summary>
        public int Year
        {
            get { return year; }
        }
        /// <summary>
        /// The part of the Timestamp which represents the month.
        /// </summary>
        int month;
        /// <summary>
        /// Gets the month part of the Timestamp.
        /// </summary>
        public int Month
        {
            get { return month; }
        }
        /// <summary>
        /// The part of the Timestamp which represents the day of the month.
        /// </summary>
        int dayOfMonth;
        /// <summary>
        /// Gets the days part of the Timestamp.
        /// </summary>
        public int DayOfMonth
        {
            get { return dayOfMonth; }
        }
        /// <summary>
        /// The part of the Timestamp which represents the hours.
        /// </summary>
        int hours;
        /// <summary>
        /// Gets the hours part of the Timestamp.
        /// </summary>
        public int Hours
        {
            get { return hours; }
        }
        /// <summary>
        /// The part of the Timestamp which represents the minutes.
        /// </summary>
        int minutes;
        /// <summary>
        /// Gets the minutes part of the Timestamp.
        /// </summary>
        public int Minutes
        {
            get { return minutes; }
        }
        /// <summary>
        /// The part of the Timestamp which represents the seconds.
        /// </summary>
        int seconds;
        /// <summary>
        /// Gets the seconds part of the Timestamp.
        /// </summary>
        public int Seconds
        {
            get { return seconds; }
        }
        /// <summary>
        /// The part of the Timestamp which represents the year.
        /// </summary>
        int miliseconds;
        /// <summary>
        /// Gets the milliseconds part of the Timestamp.
        /// </summary>
        public int Miliseconds
        {
            get { return miliseconds; }
        }
        /// <summary>
        /// The offset from the UTC timezone
        /// </summary>
        double utcOffset;
        /// <summary>
        /// Gets or sets the offset from the UTC timezone.
        /// </summary>
        public double UtcOffset
        {
            get { return utcOffset; }
            set { utcOffset = value; }
        }
        #endregion

        public SyslogTimestamp()
        {
            Reset();
        }

        public SyslogTimestamp(string timestamp)
        {
            Reset();
            FromString(timestamp);
        }

        public SyslogTimestamp(DateTime timestamp)
        {
            Reset();
            FromDateTime(timestamp);
        }

        /// <summary>
        /// Resets all fields to their default values;
        /// </summary>
        private void Reset()
        {
            miliseconds = 0;
            seconds = 0;
            minutes = 0;
            hours = 0;
            dayOfMonth = 0;
            month = 0;
            year = 0;
            utcOffset = 0;
        }

        /// <summary>
        /// Parses a string into a Syslog timestamp.
        /// </summary>
        /// <param name="dateTime">string which is going to be parsed</param>
        /// <returns>true = success | false = invalid string</returns>
        public bool FromString(string dateTime)
        {
            Reset();// All fields must be resetted - Otherwise the parsing will give a wrong value!
            Regex splitRegex = new Regex(@"(\d{4})-(0?[1-9]|1[0-2])-([0-2]?\d|3[0-1])T?([0-1]?\d|2[0-3]):([0-5]?\d):([0-5]?\d)\.?(\d{0,6})?Z?([+-]?\d\.?\d?|\d{2}?|[0]?1[0-2]\.?\d?|\d{2}?)?", RegexOptions.IgnoreCase);
            Match timestamp = splitRegex.Match(dateTime);

            if (timestamp.Groups.Count == 9)
            {
                AddYears(Int32.Parse(timestamp.Groups[1].Value));
                AddMonths(Int32.Parse(timestamp.Groups[2].Value));
                AddDays(Int32.Parse(timestamp.Groups[3].Value));
                AddHours(Int32.Parse(timestamp.Groups[4].Value));
                AddMinutes(Int32.Parse(timestamp.Groups[5].Value));
                AddSeconds(Int32.Parse(timestamp.Groups[6].Value));
                if (!string.IsNullOrWhiteSpace(timestamp.Groups[7].Value))
                {
                    AddMilliseconds(Int32.Parse(timestamp.Groups[7].Value));
                }
                if (!string.IsNullOrWhiteSpace(timestamp.Groups[8].Value))
                {
                    utcOffset = Double.Parse(timestamp.Groups[8].Value, CultureInfo.InvariantCulture);
                }
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// Returns a fully formatted Syslog timestamp, as string.
        /// </summary>
        /// <returns>Syslog timestamp, as string</returns>
        public string ToFormattedString()
        {
            string timezonePreSign = "Z";
            if (utcOffset < 0)
            {
                timezonePreSign = "";
            }
            return string.Format("{0}-{1}-{2}T{3}:{4}:{5}.{6}{7}{8}", year, month, dayOfMonth, hours, minutes, seconds, miliseconds, timezonePreSign, utcOffset.ToString().Replace(',','.'));
        }

        public DateTime ToDateTime()
        {
            DateTimeKind dateTimeKind;
            if(utcOffset == 0)
            {
                dateTimeKind = DateTimeKind.Utc;
            }
            else
            {
                dateTimeKind = DateTimeKind.Local;
            }
            return new DateTime(year, month, dayOfMonth, hours, minutes, seconds, miliseconds, dateTimeKind);
        }

        /// <summary>
        /// Overriden ToString() method - Displays the same as ToFormattedString().
        /// </summary>
        /// <returns></returns>
        public override string ToString()
        {
            return this.ToFormattedString();
        }
        /// <summary>
        /// Parses a <see cref="System.DateTime"/> type to a <see cref="SyslogTimestamp"/>. It is assumed that the
        /// DateTime type must be converted to UTC if the second argument is left out.
        /// </summary>
        /// <remarks>
        /// The FromDateTime method recognizes only the current daylight saving time adjustment rule for the local time zone.
        /// As a result, it is guaranteed to accurately return the UTC offset of a local time only during the period in which the
        /// latest adjustment rule is in effect. It may return inaccurate results if time is a historic date and time value
        /// that was subject to a previous adjustment rule.
        /// </remarks>
        /// <param name="timestamp">The <see cref="System.DateTime"/> type which will be parsed</param>
        public void FromDateTime(DateTime timestamp)
        {
            TimeSpan utcOffset = TimeZone.CurrentTimeZone.GetUtcOffset(timestamp);
            this.utcOffset = utcOffset.Hours + (utcOffset.Minutes / 100);

            AddMilliseconds(timestamp.Millisecond);
            AddSeconds(timestamp.Second);
            AddMinutes(timestamp.Minute);
            AddHours(timestamp.Hour);
            AddDays(timestamp.Day);
            AddMonths(timestamp.Month);
            AddYears(timestamp.Year);
        }

        /// <summary>
        /// Adds a <see cref="System.TimeSpan"/> to the timestamp
        /// </summary>
        /// <param name="timeSpan">The time span which is added to the Timestamp</param>
        public void Add(TimeSpan timeSpan)
        {
            AddMilliseconds(timeSpan.Milliseconds);
            AddSeconds(timeSpan.Seconds);
            AddMinutes(timeSpan.Minutes);
            AddHours(timeSpan.Hours);
            AddDays(timeSpan.Days);
        }
        /// <summary>
        /// Adds the passed millisecond value to the timestamp
        /// </summary>
        /// <param name="val">Added milliseconds</param>
        public void AddMilliseconds(int val)
        {
            if (val + miliseconds >= 1000)
            {
                AddSeconds( val / 1000);
                miliseconds = (val % 1000);
            }
            else
            {
                miliseconds += val;
            }
        }
        /// <summary>
        /// Adds the passed second value to the timestamp
        /// </summary>
        /// <param name="val">Added seconds</param>
        private void AddSeconds(int val)
        {
            if (seconds + val >= 60)
            {
                AddMinutes(val / 60);
                seconds = (val % 60);
            }
            else
            {
                seconds += val;
            }
        }
        /// <summary>
        /// Adds the passed minute value to the timestamp
        /// </summary>
        /// <param name="val">Added minutes</param>
        private void AddMinutes(int val)
        {
            if (minutes + val >= 60)
            {
                AddMinutes(val / 60);
                minutes = (val % 60);
            }
            else
            {
                minutes += val;
            }
        }
        /// <summary>
        /// Adds the passed hour value to the timestamp
        /// </summary>
        /// <param name="val">Added hours</param>
        private void AddHours(int val)
        {
            if (hours + val >= 24)
            {
                AddDays (val / 24);
                hours = (val % 24);
            }
            else
            {
                hours += val;
            }
        }
        /// <summary>
        /// Adds the passed days value to the timestamp
        /// </summary>
        /// <param name="val">Added days</param>
        private void AddDays(int val)
        {
            short dayCount = GetDayMaxDaysOfMonth(month, year);
            if (dayOfMonth + val > dayCount)
            {
                AddMonths(val / dayCount);
                dayOfMonth = (val % dayCount);
            }
            else
            {
                dayOfMonth += val;
            }
        }
        /// <summary>
        /// Adds the passed month value to the timestamp
        /// </summary>
        /// <param name="val">Added months</param>
        private void AddMonths(int val)
        {
            if (month + val > 12)
            {
                AddYears(val / 12);
                month = (val % 12);
            }
            else
            {
                month += val;
            }
        }
        /// <summary>
        /// Adds the passed value to the year part of the time stamp
        /// </summary>
        /// <param name="val">Years to be added</param>
        private void AddYears(int val)
        {
            year += val;
        }

        /// <summary>
        /// Returns true if the the parameter matches this instance.
        /// </summary>
        /// <remarks>
        /// See <see cref="DoMatch"/>
        /// </remarks>
        /// <param name="other">The parameter to compare</param>
        /// <returns>true|false</returns>
        public override bool Equals(object o)
        {
            if (o is SyslogTimestamp)
            {
                return DoMatch((SyslogTimestamp)o, this);
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// Returns true if a & b match, else false.
        /// </summary>
        /// <remarks>
        /// Match criteria:
        /// (a.year == b.Year)
        /// && (a.month == b.Month)
        /// && (a.dayOfMonth == b.DayOfMonth)
        /// && (a.hours == b.Hours)
        /// && (a.minutes == b.Minutes)
        /// && (a.seconds == b.Seconds)
        /// && (a.miliseconds == b.Miliseconds)
        /// && (a.utcOffset == b.UtcOffset);
        /// </remarks>
        public static bool DoMatch(SyslogTimestamp a, SyslogTimestamp b)
        {
            bool doMatch = (a.year == b.Year)
                && (a.month == b.Month)
                && (a.dayOfMonth == b.DayOfMonth)
                && (a.hours == b.Hours)
                && (a.minutes == b.Minutes)
                && (a.seconds == b.Seconds)
                && (a.miliseconds == b.Miliseconds)
                && (a.utcOffset == b.UtcOffset);

            return doMatch;
        }
        /// <summary>
        /// The overloaded == operator
        /// </summary>
        /// <remarks>
        /// see http://msdn.microsoft.com/en-us/library/ms173147(v=vs.80).aspx
        /// </remarks>
        public static bool operator ==(SyslogTimestamp a, SyslogTimestamp b)
        {
            // If both are null, or both are same instance, return true.
            if (System.Object.ReferenceEquals(a, b))
            {
                return true;
            }

            // If one is null, but not both, return false.
            if (((object)a == null) || ((object)b == null))
            {
                return false;
            }

            return DoMatch(a, b);
        }
        /// <summary>
        /// The overloaded != operator.
        /// </summary>
        /// <remarks>
        /// see http://msdn.microsoft.com/en-us/library/ms173147(v=vs.80).aspx
        /// </remarks>
        public static bool operator !=(SyslogTimestamp a, SyslogTimestamp b)
        {
            return !(a == b);
        }
        /// <summary>
        /// The smaller than Operator
        /// compares every date|time related field with
        /// the other and returns true if the left hand side of
        /// the assignement is smaller than the right hand side
        /// </summary>
        /// <param name="a"></param>
        /// <param name="b"></param>
        /// <returns></returns>
        public static bool operator <(SyslogTimestamp a, SyslogTimestamp b)
        {
            if (a.Year < b.Year) { return true; }
            if (a.Year > b.Year) { return false; }

            if (a.Month < b.Month) { return true; }
            if (a.Month > b.Month) { return false; }

            if (a.DayOfMonth < b.DayOfMonth) { return true; }
            if (a.DayOfMonth > b.DayOfMonth) { return false; }

            if ((a.Hours + a.UtcOffset) < (b.Hours + b.UtcOffset)) { return true; }
            if ((a.Hours + a.UtcOffset) > (b.Hours + b.UtcOffset)) { return false; }

            if (a.Minutes < b.Minutes) { return true; }
            if (a.Minutes > b.Minutes) { return false; }

            if (a.Seconds < b.Seconds) { return true; }
            if (a.Seconds > b.Seconds) { return false; }

            if (a.Miliseconds < b.Miliseconds) { return true; }
            if (a.Miliseconds > b.Miliseconds) { return false; }

            return false;
        }
        /// <summary>
        /// The greater than Operator
        /// compares every date|time related field with
        /// the other and returns true if the left hand side of
        /// the assignement is greater than the right hand side
        /// </summary>
        /// <param name="a"></param>
        /// <param name="b"></param>
        /// <returns></returns>
        public static bool operator >(SyslogTimestamp a, SyslogTimestamp b)
        {
            if (a.Year > b.Year) { return true; }
            if (a.Year < b.Year) { return false; }

            if (a.Month > b.Month) { return true; }
            if (a.Month < b.Month) { return false; }

            if (a.DayOfMonth > b.DayOfMonth) { return true; }
            if (a.DayOfMonth < b.DayOfMonth) { return false; }

            if ((a.Hours + a.UtcOffset) > (b.Hours + b.UtcOffset)) { return true; }
            if ((a.Hours + a.UtcOffset) < (b.Hours + b.UtcOffset)) { return false; }

            if (a.Minutes > b.Minutes) { return true; }
            if (a.Minutes < b.Minutes) { return false; }

            if (a.Seconds > b.Seconds) { return true; }
            if (a.Seconds < b.Seconds) { return false; }

            if (a.Miliseconds > b.Miliseconds) { return true; }
            if (a.Miliseconds < b.Miliseconds) { return false; }

            return false;
        }
        /// <summary>
        /// greater or equal Operator
        /// </summary>
        /// <param name="a"></param>
        /// <param name="b"></param>
        /// <returns>(a > b) || DoMatch(a, b)</returns>
        public static bool operator >=(SyslogTimestamp a, SyslogTimestamp b)
        {
            return (a > b) || DoMatch(a, b);
        }
        /// <summary>
        /// smaller or equal Operator
        /// </summary>
        /// <param name="a"></param>
        /// <param name="b"></param>
        /// <returns><code>(a { b) || DoMatch(a, b)</code></returns>
        public static bool operator <=(SyslogTimestamp a, SyslogTimestamp b)
        {
            return (a < b) || DoMatch(a, b);
        }

        /// <summary>
        /// Returns the Hash code of the object
        /// </summary>
        /// <returns>Hash code</returns>
        public override int GetHashCode()
        {
            return base.GetHashCode();
        }
    }
}

Clean-up crew needed, grammar spill... - Nagy Vilmos

Re: Sense of making my own Timestamp class?

TnTinMn10-Feb-14 13:12

TnTinMn

10-Feb-14 13:12

Your showing of the "fff" format characters prompted me to see if you can expand them out to six characters and use the TryParseExact overload that excepts an array of formats. It does. A little more playing around with the formats and it all becomes so simple after all.

This is real simple now especially after I noticed the other overload on TryParseExact that takes an array of formats to test. Smile | :)

string[] formats = { "yyyy-MM-dd\\THH:mm:ss\\Z", 
                     "yyyy-MM-dd\\THH:mm:ss.f\\Z", 
                     "yyyy-MM-dd\\THH:mm:ss.ff\\Z", 
                     "yyyy-MM-dd\\THH:mm:ss.fff\\Z", 
                     "yyyy-MM-dd\\THH:mm:ss.ffff\\Z", 
                     "yyyy-MM-dd\\THH:mm:ss.fffff\\Z", 
                     "yyyy-MM-dd\\THH:mm:ss.ffffff\\Z", 
                     "yyyy-MM-dd\\THH:mm:sszzz", 
                     "yyyy-MM-dd\\THH:mm:ss.fzzz", 
                     "yyyy-MM-dd\\THH:mm:ss.ffzzz", 
                     "yyyy-MM-dd\\THH:mm:ss.fffzzz", 
                     "yyyy-MM-dd\\THH:mm:ss.ffffzzz", 
                     "yyyy-MM-dd\\THH:mm:ss.fffffzzz", 
                     "yyyy-MM-dd\\THH:mm:ss.ffffffzzz" 
                   };

DateTime dt1 = default(DateTime);
bool res1 = System.DateTime.TryParseExact("1985-04-12T20:20:59.100000-00:15", 
                                           formats, System.Globalization.CultureInfo.InvariantCulture, 
                                           System.Globalization.DateTimeStyles.AdjustToUniversal, 
                                           out dt1);

DateTime dt2 = default(DateTime);
bool res2 = System.DateTime.TryParseExact("1985-04-12T20:20:59.100001-00:15", 
                                          formats, System.Globalization.CultureInfo.InvariantCulture, 
                                          System.Globalization.DateTimeStyles.AdjustToUniversal,
                                          out dt2);

Console.WriteLine(dt1.Kind.ToString()); // yep UTC
Console.WriteLine(dt1.ToString("u"));
Console.WriteLine((dt1 < dt2).ToString()); // 1 µsec less

This code works, but has the drawback of loosing the original offsets as everything gets adjusted to UTC.

You can maintain the original offset date by using the DateTimeOffset [^]structure (this structure has all the functionality that I so foolishly recreated by custom parsing). D'Oh! | :doh:

Oh, well it was fun to see if I could do it. Blush | :O

DateTimeOffset dto1 = new DateTimeOffset();
bool res1b = System.DateTimeOffset.TryParseExact("1985-04-12T20:20:59.100000-00:15", 
                                                 formats, 
                                                 System.Globalization.CultureInfo.InvariantCulture, 
                                                 System.Globalization.DateTimeStyles.AssumeLocal, 
                                                 out dto1);

Notice the change to AssumeLocal. The DateTime and Offset properties can then be used to recreate the original string.

SSIS for Fixed Length line

nitin_ion3-Feb-14 20:26

nitin_ion

3-Feb-14 20:26

I have a file in which each line has a fixed length 1600 char
but each line has its there are different columns

Line 1 will be like this

RA01XYZ--------------------------------------------------------------------201401231
RA is Record Type
01 is Version
XYZ------------------ is client name
201401231 is date

now 2 line
SR0123456789-------------------------011234567890-
SR is record type
0123456789------------------------- is some number

You see that each line will have its own set of defined columns and it cannot be fixed width

So my question is, is it possible/advisable to apply SSIS on this or create a simple win form application using REGEX to extract and process the data.

Re: SSIS for Fixed Length line

Bernhard Hiller3-Feb-14 20:52

Bernhard Hiller

3-Feb-14 20:52

Regex? No, Substring(start, length).
Read a whole line, determine the "line type", and then get its data into appropriate objects which you then insert into the db.

Re: SSIS for Fixed Length line

Marco Bertschi3-Feb-14 20:56

Marco Bertschi

3-Feb-14 20:56

Bernhard Hiller wrote:
get its data into appropriate objects

Which he may do by using an appropriate regex, so not a really bad start.

Clean-up crew needed, grammar spill... - Nagy Vilmos

Re: SSIS for Fixed Length line

nitin_ion3-Feb-14 21:46

nitin_ion

3-Feb-14 21:46

ok, but i want a view on processing this type of file using ssis??
is it doable and advisable

Creating barcode of type ean-13 in c# windows forms with sql server 2008 using StrokeScribe control of version 4.3.2

Member 102487683-Feb-14 19:00

Member 10248768

3-Feb-14 19:00

Hi my name is vishal.For past 10 days i have been going nuts over of how to create barcode in c# windows forms with sql server 2008 using StrokeScribe control of version 4.3.2. i have done some coding here with 5 group boxes with no success. i have four group boxes
1) group box-1-name:fmeStep1,text:Step 1,visible:true.
It has 8 labels,2 comboboxes,3 textboxes,3 datetimepickers.
2) group box-2-name:fmeBarCode,text:"",visible:true
It has i label,i textbox.
3) group box-3-name:fmeDEntry,text:Dialyzer Entry,visible:true.
It has 2 radio buttons
4) group box-4-name:fmeStep2,text:Step 3,visible=true.
It has i textbox named txtDID,visible=true,enabled=true.1 button,1 strokescribe control of version:4.3.2.,name:barCDialyzer.Given below is properties of barCDialyzer:
AccessibeRole: Default
AlowDrop: false
Alphabet: EAN13
AztecECL: 23
AztecMinLayer: 1
BitmapH: 1
BiwmapW: 115
CausesValidation: true
CheckDigit: 8
CodabarHasCheckDigit: false
Code11CheckDigits: 1
Code39HasCheckDigit: false
Code39Ratio: 2
CodePage: 3
CompactPDF417: false
ECI: 0
Enabled: true
GraphicsMode: Advanced
HBorderSize: 10
I2of5Ratio: 2
ISBN10: false
ITF14BearerBox: false
ITF14BearerWidth: 5
ProcessTilde: false
QrECL: L
QrMinVersion: 1
QuietZone2D: 1
SaCount: 0
SaID: 0
SaPos: 0
ShowText: true
TextJustify: true
TextOffset: 0
UTF8: false
VBorderPercent: 5
Visible: true.

5) group box-5-name:fmeStep3,text:Step 4,visible:true.
it has 1 combobox,2 buttons,2 picturebox.
1-picturebox:pictureBox1,enabled=true,visible=true. in which i have another strokescribe named:barCOrg an a label named lblPID. given below are it's properties:

AlowDrop: false
Alphabet: EAN13
AztecECL: 23
AztecMinLayer: 1
BitmapH: 1
BiwmapW: 115
CausesValidation: true
CheckDigit: 8
CodabarHasCheckDigit: false
Code11CheckDigits: 1
Code39HasCheckDigit: false
Code39Ratio: 2
CodePage: 3
CompactPDF417: false
ECI: 0
Enabled: true
GraphicsMode: Advanced
HBorderSize: 10
I2of5Ratio: 2
ISBN10: false
ITF14BearerBox: false
ITF14BearerWidth: 5
ProcessTilde: false
QrECL: L
QrMinVersion: 1
QuietZone2D: 1
SaCount: 0
SaID: 0
SaPos: 0
ShowText: true
TextJustify: true
TextOffset: 0
UTF8: false
VBorderPercent: 5
Visible: true.

2-picturebox:pictureBox2,enabled=true,visible=false.I have embedded this pictureBox2 on pictureBox1.Given below is code of my form named:Dialyzer in which i have 2 buttons..

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using STROKESCRIBECLSLib;
using System.Data.SqlClient;
namespace DRRS_in_Csharp
{
    public partial class Dialyzer : Form
    {
        Int32 dStepIndex;
         long pUserID = 1;
         SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
         SqlCommand cmd;
         SqlDataAdapter drp;
         DataSet ds;
         string str;
         DataTable dt;
        public Dialyzer()
        {
            InitializeComponent();
             SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            string SqlDataPull=("Select p.patient_id as patient_id,n.patient_first_name as patient_fname,n.patient_last_name as patient_lname from PATIENT_NAME6 n,PATIENT_ID6 p where n.patient_id=p.patient_id");
            SqlCommand cmd=new SqlCommand(SqlDataPull);
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                SqlDataPull=dr[0].ToString()+dr[1].ToString()+dr[2].ToString();
                cboPatientID.Items.Add(SqlDataPull);
            }
            
            dr.Close();

            string SqlDataPull1=("Select ManufacturerName from EQUIPMENTDATA");
            cmd=new SqlCommand(SqlDataPull1);
            cmd.Connection=conn;
            cmd.CommandType=CommandType.Text;
            dr=cmd.ExecuteReader();
            while(dr.Read())
            {
                SqlDataPull1 = dr[0].ToString(); 
                cboManufacturer.Items.Add(SqlDataPull1);
            }            
        }
        private void cboequipment_Type_Click(object sender,EventArgs e)
        {
            if(cboManufacturer.SelectedIndex==-1)
            {
                return;
            }
             SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
                    if (conn.State != ConnectionState.Open)
                    {
                        conn.Open();
                    }
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;
                    cmd.CommandType = CommandType.Text;
            DataTable dt=new DataTable();
            cmd=new SqlCommand("Select * from EQUIPMENTDATA where ManufacturerName='"+cboManufacturer.Text+"' and volume='"+cboequipmentType.Text+"'",conn);
            
               // cmd=new SqlCommand("Select * from APPPREFER",conn);
                //if(dt.Rows.Count==-1)
                //{
                //    txtPVol.Text=cmd.Parameters.AddWithValue("@bundle_volume",SqlDbType.NText).Value.ToString();
                //}
        }
        private void cboManufacturer_Click(object sender,EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
              DataTable dt = new DataTable();
            dt.Clear();
            
            SqlDataAdapter adp = new SqlDataAdapter();

            cmd=new SqlCommand("Select volume from EQUIPMENTDATA where ManufacturerName='" + cboManufacturer.Text + "'",conn);
             adp = new SqlDataAdapter(cmd);
             adp.Fill(dt);  
        }
        private void cboPatientID_Click(object sender,EventArgs e)
        {
            if(cboPatientID.SelectedIndex!=-1)
            {
                btnSearch.Enabled=true;
                button3.Enabled=true;
                 SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
                    if (conn.State != ConnectionState.Open)
                    {
                        conn.Open();
                    }
                SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;
                    cmd.CommandType = CommandType.Text;
                cmd=new SqlCommand("Select * from PATIENT_NAME where patient_id="+cboPatientID.GetItemText(cboPatientID.SelectedIndex)+"'",conn);
                if(txtDID.Text.Length>5)
                {
                    txtDID.Text=txtDID.Text.Substring(0,5);
                }
                DataTable dt=new DataTable();
                if(dt.Rows.Count==-1)
                {
                    if((cmd.Parameters.AddWithValue("@virology",SqlDbType.Int).Value.GetHashCode()==0))
                    {
                        txtDID.Text=txtDID.Text+1;
                    }
                        else
                        {
                        txtDID.Text=txtDID.Text+0;
                    }
                }
                    else
                    {
                        txtDID.Text=txtDID.Text+0;
                    }
                lblPID.Text=cboPatientID.Text.Substring(cboPatientID.Text.IndexOf(cboPatientID.Text,1));
                barCDialyzer.Alphabet=STROKESCRIBELib.enumAlphabet.AZTEC;
                barCDialyzer.CtlText=txtDID.Text+(char)9;
                barCOrg.Alphabet=STROKESCRIBELib.enumAlphabet.AZTEC;
                barCOrg.CtlText=txtDID.Text+(char)9;
               
              
                int rc=0;
                 rc =barCOrg.SavePicture("D:\\Workarea\vishal\vishal c#\\DRRS in Csharp\\DRRS in Csharp\bar1.bmp", STROKESCRIBELib.enumFormats.BMP,barCOrg.BitmapW,barCOrg.BitmapH);
                if(rc>0)
                {
                    MessageBox.Show(barCOrg.ErrorDescription);
                }
                else
                {
                    btnSearch.Enabled=false;
                    button3.Enabled=false;
                }
        }
        }
        
 private void barCDialyzer_Enter(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            if(txtDID.Tag.ToString()=="0")
            {
                btnNext.Enabled=true;
                button1.Enabled=false;
                txtDID.Enabled=false;
                barCDialyzer.Alphabet=STROKESCRIBELib.enumAlphabet.AZTEC;
                barCDialyzer.CtlText=txtDID.Text+(char)9;
                 barCOrg.Alphabet=STROKESCRIBELib.enumAlphabet.AZTEC;
                barCOrg.CtlText=txtDID.Text+(char)9;
                int rc = 0;
                rc = barCOrg.SavePicture("D:\\Workarea\vishal\vishal c#\\DRRS in Csharp\\DRRS in Csharp\bar1.bmp", STROKESCRIBELib.enumFormats.BMP, barCOrg.BitmapW, barCOrg.BitmapH);
                if (rc > 0)
                {
                    MessageBox.Show(barCOrg.ErrorDescription);
                }
        }
        }

        private void btnNext_Click(object sender, EventArgs e)
        {
            if (fmeDEntry.Visible == true)
            {
                fmeDEntry.Visible = false;
            }
            if (optDEntry1.Checked == false)
            {
                fmeBarCode.Visible = false;
                fmeStep1.Visible = true;
                
            }
            
            {
                if (dStepIndex == 0)
                {
                    string dFieldName = "";
                    Boolean vEmptyB = false;
                    if (cboManufacturer.SelectedIndex == -1)
                    {
                        vEmptyB = true;
                        dFieldName = "Please select a manufacturer";
                    }
                    else if (cboequipmentType.SelectedIndex == -1)
                    {
                        vEmptyB = true;
                        dFieldName = "Please select size of dialyzer";
                    }
                    else if (txtMFRRefNo.Text.ToString().Trim() == "")
                    {
                        vEmptyB = true;
                        dFieldName = "Please enter equipment reference number";
                    }
                    else if (txtMFRLotNo.Text.ToString().Trim() == "")
                    {
                        vEmptyB = true;
                        dFieldName = "Please enter equipment lot number";
                    }
                    else if (txtPVol.Text.ToString().Trim() == "")
                    {
                        vEmptyB = true;
                        dFieldName = "Please enter packed_volume of equipment";
                    }
                    if (vEmptyB == true)
                    {
                        MessageBox.Show(dFieldName + "should not be empty");
                        return;
                    }
                    SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
                    if (conn.State != ConnectionState.Open)
                    {
                        conn.Open();
                    }
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;
                    cmd.CommandType = CommandType.Text;
                    string dDID = "";
                    cmd = new SqlCommand("select max(agn) from DIALYSER", conn);
                    cmd = new SqlCommand("Insert into DIALYSER(agn)" + "Values(@agn)", conn);
                    DataTable dt = new DataTable();
                    if (dt.Rows.Count != -1)
                    {

                        if (cmd.Parameters.AddWithValue("@agn", SqlDbType.Int).Value is DBNull)
                        {
                            dDID = "1";
                        }
                        else
                        {
                            dDID = cmd.Parameters.AddWithValue("@agn", SqlDbType.Int).Value.ToString() + 1;
                            txtDID.Text = txtDID.Text.Replace(dDID.PadLeft(5), dDID.Length.ToString()) + dDID;
                        }
                    }
                    else
                    {
                        txtDID.Text = txtDID.Text.Replace(dDID.PadLeft(5), dDID.Length.ToString()) + dDID;
                    }
                }
                    fmeStep1.Visible = false;
                    fmeStep2.Visible = true;
                   
                    fmeStep3.Visible = false;
                   
                    btnNext.Enabled = false;
                    button1.Enabled = false;
                    txtDID.Focus();
                    
                    }
                }
        private void fmeStep3_Enter(object sender, EventArgs e)
        {
        
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            string dPatientID;
            dPatientID=cboPatientID.GetItemText(cboPatientID.SelectedIndex);
            Patient p=new Patient();
            p.loadPatient(dPatientID);

        }

        private void button3_Click(object sender, EventArgs e)
        {
            string dFieldName = "";
            Boolean vEmptyB=false;
            if(cboManufacturer.SelectedIndex==-1)
            {
                vEmptyB = true;
                dFieldName = "Please select a manufacturer";
            }
            else if(cboequipmentType.SelectedIndex==-1)
            {
                vEmptyB = true;
                dFieldName = "Please select size of equipment";
            }
            else if(txtMFRRefNo.Text.ToString().Trim()=="")
            {
                vEmptyB = true;
                dFieldName = "Equipment reference number should not be empty";
            }
            else if(txtMFRLotNo.Text.ToString().Trim()=="")
            {
                vEmptyB = true;
                dFieldName = "Equipment lot number should not be empty";
            }
           else if(txtPVol.Text.ToString().Trim()=="")
            {
                vEmptyB = true;
                dFieldName = "Packed volume of the equipment should not be empty";
           }
            else if(cboPatientID.SelectedIndex==-1)
            {
                vEmptyB = true;
                dFieldName = "Please select a patient";
            }
               if (vEmptyB==true)
            {
                MessageBox.Show(dFieldName+"should not be empty");
                return;
            }
              SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd=new SqlCommand("Insert into DIALYSER(dialyserID,manufacturer,mfr_ref_number,mfr_lot_number,mfr_date,exp_date,start_date,packed_volume,dialyzer_size,patient_id,row_upd_date,user_id)"+"Values(@dialyserID,@manufacturer,@mfr_ref_number,@mfr_lot_number,@mfr_date,@exp_date,@start_date,@packed_volume,@dialyzer_size,@patient_id,GetDate(),@user_id)",conn);
            cmd.Parameters.AddWithValue("@dialyserID",txtDID.Text);
            cmd.Parameters.AddWithValue("@manufacturer",cboManufacturer.SelectedIndex);
            cmd.Parameters.AddWithValue("@mfr_ref_number",txtMFRRefNo.Text);
            cmd.Parameters.AddWithValue("@mfr_lot_number",txtMFRLotNo.Text);
            cmd.Parameters.AddWithValue("@mfr_date",dtMFRDate.Value);
            cmd.Parameters.AddWithValue("@exp_date",dtMFRexpDate.Value);
            cmd.Parameters.AddWithValue("@start_date",dtMFRstartDate.Value);
            cmd.Parameters.AddWithValue("@packed_volume",txtPVol.Text);
            cmd.Parameters.AddWithValue("@dialyzer_size",cboequipmentType.SelectedIndex);
            cmd.Parameters.AddWithValue("@patient_id",cboPatientID.GetItemText(cboPatientID.SelectedIndex));
            cmd.Parameters.AddWithValue("@user_id",pUserID);
            cmd.ExecuteNonQuery();
            ((MDIParent5)this.MdiParent).updateUserActivities(pUserID, 4,txtDID.Text + "Dialyzer detail was successfully assigned to patient="+cboPatientID.SelectedIndex+"");
            conn.Close();
            this.Close();

        }
 private void GetData(string ID)
        {
            DataTable dt = new DataTable();
            SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
            conn.Open();
            SqlCommand cmd = new SqlCommand("Select * from EQUIPMENTDATA where ManufacturerName='" + cboManufacturer.Text + "' and volume='" + cboequipmentType.Text + "' and packed_volume='" + txtPVol.Text + "'", conn);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            sda.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                cboequipmentType.Text = dt.Rows[3]["volume"].ToString();
                txtPVol.Text = dt.Rows[5]["packed_volume"].ToString();
            }
            conn.Close();
        }
        private void Dialyzer_Load(object sender, EventArgs e)
        {
            dtMFRDate.MinDate = dtMFRDate.Value;
            
            dStepIndex=0;
            fmeStep1.Visible=true;
            fmeStep2.Visible=false;
            fmeStep3.Visible=false;
        }
  private void txtDID_LostFocus(object sender, EventArgs e)
        {
            if (txtDID.Text.ToString().Trim() == "")
            {
                MessageBox.Show("Please enter Dialyzer ID to create", "DRRS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                txtDID.Focus();
            }
            else
            {
                checkDialyzerID();
            }
        }
        private void checkDialyzerID()
        {
            SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            DataTable dt = new DataTable();
            cmd=new SqlCommand("Select * from DIALYSER where dialyserID="+txtDID.Text+"",conn);
            if (dt.Rows.Count != -1)
            {
                MessageBox.Show("The DialyzerID already exists.Please try with another", "DRRS", MessageBoxButtons.OK, MessageBoxIcon.Information);
                txtDID.Text = "";
                txtDID.Focus();
                txtDID.Tag = 1;
            }
            else
            {
                txtDID.Tag = 0;
                button1.Enabled = true;
                button1.Focus();
            }
            conn.Close();

        }
        private void dtMFRDate_ValueChanged(object sender, EventArgs e)
        {
            dtMFRstartDate.MinDate = Convert.ToDateTime("21/10/2013");
        }
        private void txtPVol_KeyPress(object sender, KeyPressEventArgs e)
        {

            // allows only numbers

            if (!char.IsNumber(e.KeyChar))
            {

                e.Handled = true;

            }

        }
 private void cboManufacturer_SelectedIndexChanged(object sender, EventArgs e)
        {
            GetData(cboManufacturer.SelectedItem.ToString());
             
        }
        private void cboequipmentType_SelectedIndexChanged(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Tuscan46;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            str = "Select distinct(volume) from EQUIPMENTDATA where Manufacturername='" + cboManufacturer.Text + "'";
            cmd = new SqlCommand(str, conn);
            SqlDataReader reader = cmd.ExecuteReader();
            if (reader.Read())
            {
                txtPVol.Text = reader["packed_volume"].ToString();
            }
            conn.Close();
            reader.Close();

        }
 private void button5_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

Now here is the problem i am facing upon testing though entries process goes correctly till group box name:fmeStep1 afterwards i am not able get even controls of group box named:fmeStep2 and i dont know why? I want to see controls in fmeStep2 since in textbox named txtDID it shows me ID of Dialyzer that i am going to create and then in group box named:fmeStep3 i get to search for patient that i have to assign ID of Dialyzer to patient. I have tried fixing this problem many times but with no success. i am supposed to use StrokeScribe of version 4.3.2 only since it's my Boss orders and that i have to create barcode of type ean-13 in c# windows forms using StrokeScribe control with sql server 2008. Can anyone help me please where have i gone wrong in the coding. Can anyone guide me please. i was referred by Microsoft Developer Network community to ask my doubts regarding creation of barcode of type ean-13 in c# windows forms with sql server 2008. Can anyone help me please.?Any help or guidance would be greatly appreciated.

Re: Creating barcode of type ean-13 in c# windows forms with sql server 2008 using StrokeScribe control of version 4.3.2

Richard MacCutchan3-Feb-14 21:53

Richard MacCutchan

3-Feb-14 21:53

You should edit your message, it is almost unreadable as it stands. And try to identify exactly where the problem lies, rather than expecting others to work through code which they have never seen before.

Veni, vidi, abiit domum

North wind Database

Sandhya Bandar3-Feb-14 9:46

Sandhya Bandar

3-Feb-14 9:46

what is northwind database and how to use it?

Re: North wind Database

Kornfeld Eliyahu Peter3-Feb-14 9:54

Kornfeld Eliyahu Peter

3-Feb-14 9:54

It's a sample database used in a lot of example code by Microsoft and others. You may use it as you wish to build code...
http://northwinddatabase.codeplex.com/[^]

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Re: North wind Database

Dave Kreskowiak3-Feb-14 12:49

Dave Kreskowiak

3-Feb-14 12:49

Come on! This is ultimate in lazy. You could have typed "What is the Northwind database" into any search engine and found the answer to that in under 30 seconds.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: North wind Database

Kornfeld Eliyahu Peter3-Feb-14 20:19

Kornfeld Eliyahu Peter

3-Feb-14 20:19

Shhhhhh... don't reveal our trade secret!!!

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Re: North wind Database

Marco Bertschi3-Feb-14 21:04

Marco Bertschi

3-Feb-14 21:04

Source[^]
Northwind Database is a sample database that is shipped along with Microsoft Access application. Basically, the database is about a company named "Northwind Traders". The database captures all the sales transactions that occurs between the company i.e. Northwind traders and its customers as well as the purchase transactions between Northwind and its suppliers.

It's true, you could just have googled for "what is northwind database[^]"

Clean-up crew needed, grammar spill... - Nagy Vilmos

Working with Bitmaps

BBatts3-Feb-14 7:45

BBatts

3-Feb-14 7:45

Hello,

I'm collecting bitmaps from a camera like below:

private void LPRCamera2_OnNewFrame(object sender, ref Bitmap NewFrame)
       {
           while (LPR2List.Count >= LowCamSettings.LPR2FrameCount)
           {
               LPR2List[0].Dispose();
               LPR2List.RemoveAt(0);
           }

           if (lpr2FrameIndex >= LowCamSettings.LPR2SkipCount)
           {
               LPR2List.Add(new Bitmap(NewFrame));   //List<Bitmap> object
               lpr2FrameIndex = 0;
           }
           else if (LowCamSettings.LPR2SkipCount > 0)
               lpr2FrameIndex++;
       }

I then take the list (LPR2List) and pass it to a new object that copies the list to a local variable. Like so:

for (int i = 0; i < LPR2List.Count; i++)
{
    if (LPR2List[i] != null)
        this.Plate2List.Add((Bitmap)LPR2List[i].Clone());  //Error Line
}

Every now and then i'm getting an error when copying telling me that the object is in use.

I haven't the slightest clue what I could be doing wrong. Any help would be greatly appreciated.

modified 3-Feb-14 13:54pm.

Re: Working with Bitmaps

TnTinMn4-Feb-14 6:56

TnTinMn

4-Feb-14 6:56

I suspect that this is a threading issue.

LPRCamera2_OnNewFrame appears to be an event handler and it may be raised on its own thread.

See this SO answer[^] for a good explanation.

Project Question

reaper21913-Feb-14 5:15

reaper2191

3-Feb-14 5:15

I am new to programming and found a project online for designing a program that will randomly pull 4 cards from a 52 card deck. I want to prevent the same cards being repeated. I know there is a way to store it in an array to prevent repeating, just don't know how to do it. Any suggestions would be great.

Re: Project Question

Alan Balkany3-Feb-14 5:20

Alan Balkany

3-Feb-14 5:20

The List type (List<PlayingCard>) will give you more flexibility. Use two lists:

List <PlayingCard> deck, drawn;

Where PlayingCard is the type for your cards.

When you draw a card, just delete that card from the deck list, and add it to the drawn list. It's as simple as that.

Re: Project Question

Pete O'Hanlon3-Feb-14 5:48

Pete O'Hanlon

3-Feb-14 5:48

There are a few ways you could do this, but the simplest way is to store the cards in a list and then remove them when they have been selected. This isn't the best method to do this, but it is simple and easy to understand if you are new to coding. It's always best to start with the simplest solution that solves your problem.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.