sunamo, Author at We are just star dust

Use Int16 (short) as Date in C#

sunamo May 8, 2021May 8, 2021 0

It have range only 10/1/1 to 32/12/31 but occupate just 2 bytes, whereas Date 3 bytes in SQL Server. Types like SmallDateTime or DateTime2 I won’t comparing because stored also time.

using System;
using System.Text;

public class NormalizeDate
{
    public static DateTime From(short sh)
    {
        var s = sh.ToString();
        s = s.Trim();

        if (s.StartsWith(AllStrings.dash))
        {
            s = s.TrimStart(AllChars.dash);
        }

        var y = s.Substring(0, 2);
        var m = s.Substring(2, 1);
        var d = s.Substring(3, 2);

        var firstLetter = int.Parse( d[0].ToString());
        if (firstLetter > 3)
        {
            m = "1" + m;
            var f = (firstLetter - 4).ToString()[0];
            var s2 = d[1].ToString();
            d = f + s2;
        }
        else if (m == "0")
        {
            m = "10";
        }

        var longYear = DTHelperGeneral.LongYear(y);

        DateTime dt = new DateTime(int.Parse(longYear), int.Parse(m), int.Parse(d));
        return dt;
    }

    public static short To(DateTime dt)
    {
        bool timesMinus1 = false;
        bool addFour = false;

        var y = DTHelperGeneral.ShortYear(dt.Year);
        // months never start with zero
        var m = dt.Month;
        var ms2 = m.ToString();

        if (m > 10)
        {
            var ms = NH.MakeUpTo2NumbersToZero(m);

            if (ms[0] == '1')
            {
                if (ms[0] == '2')
                {
                    timesMinus1 = true;
                }
                addFour = true;
                ms2 = ms[1].ToString();
            }
        }
        else if (m == 10)
        {
            ms2 = "0";
        }

        /*
        In first place can be 0,1,2,3
        november = 4,5,6,7
        december = -4,5,6,7
         */
        var d = NH.MakeUpTo2NumbersToZero(dt.Day);
        var firstChar = d[0];

        StringBuilder sb = new StringBuilder();
        if (timesMinus1)
        {
            sb.Append(AllChars.dash);
        }

        int firstChar2 = int.Parse(firstChar.ToString());
        if (addFour)
        {
            firstChar2 += 4;
        }

        sb.Append(y);
        sb.Append(ms2);
        sb.Append(firstChar2);
        sb.Append(d[1].ToString());

        var result = sb.ToString();
        return short.Parse( result);
    }
}

using System;

using System.Text;

public class NormalizeDate

{

public static DateTime From(short sh)

{

var s = sh.ToString();

s = s.Trim();

if (s.StartsWith(AllStrings.dash))

{

s = s.TrimStart(AllChars.dash);

}

var y = s.Substring(0, 2);

var m = s.Substring(2, 1);

var d = s.Substring(3, 2);

var firstLetter = int.Parse( d[0].ToString());

if (firstLetter > 3)

{

m = "1" + m;

var f = (firstLetter - 4).ToString()[0];

var s2 = d[1].ToString();

d = f + s2;

}

else if (m == "0")

{

m = "10";

}

var longYear = DTHelperGeneral.LongYear(y);

DateTime dt = new DateTime(int.Parse(longYear), int.Parse(m), int.Parse(d));

return dt;

}

public static short To(DateTime dt)

{

bool timesMinus1 = false;

bool addFour = false;

var y = DTHelperGeneral.ShortYear(dt.Year);

// months never start with zero

var m = dt.Month;

var ms2 = m.ToString();

if (m > 10)

{

var ms = NH.MakeUpTo2NumbersToZero(m);

if (ms[0] == '1')

{

if (ms[0] == '2')

{

timesMinus1 = true;

}

addFour = true;

ms2 = ms[1].ToString();

}

else if (m == 10)

{

ms2 = "0";

}

In first place can be 0,1,2,3

november = 4,5,6,7

december = -4,5,6,7

var d = NH.MakeUpTo2NumbersToZero(dt.Day);

var firstChar = d[0];

StringBuilder sb = new StringBuilder();

if (timesMinus1)

{

sb.Append(AllChars.dash);

}

int firstChar2 = int.Parse(firstChar.ToString());

if (addFour)

{

firstChar2 += 4;

}

sb.Append(y);

sb.Append(ms2);

sb.Append(firstChar2);

sb.Append(d[1].ToString());

var result = sb.ToString();

return short.Parse( result);

}

Unit tests:

using System;
using Xunit;

public class NormalizeDateTests
{
    [Fact]
    public void NormalizeDateTest()
    {
        var dt = new DateTime(2021, 1, 1);

        short d = 0;
        DateTime s;

        for (int i = 0; i < 12; i++)
        {
            d = NormalizeDate.To(dt);
            s = NormalizeDate.From(d);

            Assert.Equal<DateTime>(dt, s);

            dt = dt.AddMonths(1);
        }

        s = NormalizeDate.From(Consts.nDtMinVal);
        d = NormalizeDate.To(s);

        Assert.Equal<short>(Consts.nDtMinVal, d);

        s = NormalizeDate.From(Consts.nDtMaxVal);
        d = NormalizeDate.To(s);

        Assert.Equal<short>(Consts.nDtMaxVal, d);
    }
}

using System;

using Xunit;

public class NormalizeDateTests

{

[Fact]

public void NormalizeDateTest()

{

var dt = new DateTime(2021, 1, 1);

short d = 0;

DateTime s;

for (int i = 0; i < 12; i++)

{

d = NormalizeDate.To(dt);

s = NormalizeDate.From(d);

Assert.Equal<DateTime>(dt, s);

dt = dt.AddMonths(1);

}

s = NormalizeDate.From(Consts.nDtMinVal);

d = NormalizeDate.To(s);

Assert.Equal<short>(Consts.nDtMinVal, d);

s = NormalizeDate.From(Consts.nDtMaxVal);

d = NormalizeDate.To(s);

Assert.Equal<short>(Consts.nDtMaxVal, d);

}

Constansts:

public static partial class Consts
{
    public static DateTime nDateTimeMinVal = new DateTime(2010, 1, 1, 0, 0, 0);
    public static DateTime nDateTimeMaxVal = new DateTime(2032, 12, 31, 23, 59, 59);
    public static short nDtMinVal = 10101;
    public static short nDtMaxVal = 32271;
}

public static partial class Consts

{

public static DateTime nDateTimeMinVal = new DateTime(2010, 1, 1, 0, 0, 0);

public static DateTime nDateTimeMaxVal = new DateTime(2032, 12, 31, 23, 59, 59);

public static short nDtMinVal = 10101;

public static short nDtMaxVal = 32271;

}

Class hiearchy in image sources (WPF)

sunamo August 21, 2020August 21, 2020 0

Structure of flow text in WPF

sunamo June 24, 2020June 24, 2020 0

Starting point for this blogpost. Principle: Create something which have Blocks/Child/ListItems/RowGroups property Create something which have Inlines property Create elements which are derived from Inline Inline -> Inlines -> Blocks/Child/ListItems/RowGroups Block derived classes are these : Paragraph – Blocks Section – Blocks BlockUIContainer – Child List – ListItems Table – RowGroups

Datetime formats in sunamo framework

sunamo February 22, 2020February 22, 2020 0

In columns Create and Parse are names of methods in DT*.cs, located in sunamo projects. This analyze was did to easy find what formats it’s available and which methods is needed write up. Date and time (with seconds) Date and time (without seconds) Date Time (without seconds) Time (with seconds) Time (with ms&s) …

Grid controls in Wpf

sunamo November 6, 2019November 6, 2019 0

This blogpost is to see difference in use and apperance of Grid controls in WPF. Main use case is grid with checkbox in the first column and control buttons in the last. DataGrid: ListView with Grid View: Source code is to find on //github.com/sunamo/GridControlsInWpf_Blog Due to no time to complete it (like ListBox or external …

Basic terms in .NET Compiler Platform (Roslyn)

sunamo March 30, 2019March 30, 2019 0

I have spent many hours with Roslyn – this blogpost is result of my exploring of its infrastructure: Concepts Syntactic model – Working just with actual file Semantic model – Connection to another source files. Usually trigger compilation, so it’s expensive to hardware resources. SemanticModel.GetDeclaredSymbol() accepts declaration syntax and provides the corresponding symbol. SemanticModel.GetSymbolInfo() accepts …

HexCodeForAwesomeFontChar Guidelines

sunamo January 4, 2019March 30, 2019 0

Welcome the dearest! On my web you can search for awesome font icons ans get values, which then simply insert to property Text, Content eg. of WPF Controls. This was done specifically for windows store/universal apps, because I did not find the library or custom solutions how to simply insert in xaml awesome icons to …