src/YesSql.Core/Data/DapperDataHandlers.cs - main - aprogrammer/yessql

src/YesSql.Core/Data/DapperDataHandlers.cs
90 строк2 KB
Mike Alhayek
Code Cleanup (#507)
09 ноя 2023, 03:32
09 ноя 2023, 03:32dabecfb
using Dapper;
using System;
using System.Data;

namespace YesSql.Data
{
    abstract class DapperTypeHandler<T> : SqlMapper.TypeHandler<T>
    {
        public override void SetValue(IDbDataParameter parameter, T value)
            => parameter.Value = value;
    }

    class DateTimeOffsetHandler : DapperTypeHandler<DateTimeOffset>
    {
        public override DateTimeOffset Parse(object value)
        {
            if (value is null)
            {
                return DateTimeOffset.MinValue;
            }

            if (value is string s)
            {
                return DateTimeOffset.Parse(s);
            }

            if (value is DateTime dt)
            {
                return dt;
            }

            if (value is DateTimeOffset d)
            {
                return d;
            }

            return DateTimeOffset.MinValue;
        }
    }

    class GuidHandler : DapperTypeHandler<Guid>
    {
        public override Guid Parse(object value)
        {
            if (value is null)
            {
                return Guid.Empty;
            }

            if (value is string s)
            {
                return Guid.Parse(s);
            }
            else if (value is Guid g)
            {
                return g;
            }

            return Guid.Empty;
        }
    }

    class TimeSpanHandler : DapperTypeHandler<TimeSpan>
    {
        public override TimeSpan Parse(object value)
        {
            if (value is null)
            {
                return TimeSpan.Zero;
            }

            if (value is string s)
            {
                return TimeSpan.Parse(s);
            }

            if (value is long l)
            {
                return new TimeSpan(l);
            }

            if (value is TimeSpan t)
            {
                return t;
            }

            return TimeSpan.Zero;
        }
    }
}