forked from npgsql/npgsql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathMoneyHandler.cs
More file actions
executable file
·79 lines (74 loc) · 2.91 KB
/
MoneyHandler.cs
File metadata and controls
executable file
·79 lines (74 loc) · 2.91 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
#region License
// The PostgreSQL License
//
// Copyright (C) 2015 The Npgsql Development Team
//
// Permission to use, copy, modify, and distribute this software and its
// documentation for any purpose, without fee, and without a written
// agreement is hereby granted, provided that the above copyright notice
// and this paragraph and the following two paragraphs appear in all copies.
//
// IN NO EVENT SHALL THE NPGSQL DEVELOPMENT TEAM BE LIABLE TO ANY PARTY
// FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES,
// INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
// DOCUMENTATION, EVEN IF THE NPGSQL DEVELOPMENT TEAM HAS BEEN ADVISED OF
// THE POSSIBILITY OF SUCH DAMAGE.
//
// THE NPGSQL DEVELOPMENT TEAM SPECIFICALLY DISCLAIMS ANY WARRANTIES,
// INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
// AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS
// ON AN "AS IS" BASIS, AND THE NPGSQL DEVELOPMENT TEAM HAS NO OBLIGATIONS
// TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
#endregion
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using Npgsql.BackendMessages;
using NpgsqlTypes;
using System.Data;
namespace Npgsql.TypeHandlers
{
/// <remarks>
/// http://www.postgresql.org/docs/current/static/datatype-money.html
/// </remarks>
[TypeMapping("money", NpgsqlDbType.Money, dbType: DbType.Currency)]
internal class MoneyHandler : SimpleTypeHandler<decimal>
{
public override decimal Read(NpgsqlBuffer buf, int len, FieldDescription fieldDescription)
{
return buf.ReadInt64() / 100m;
}
public override int ValidateAndGetLength(object value, NpgsqlParameter parameter)
{
decimal decimalValue;
if (!(value is decimal))
{
var converted = Convert.ToDecimal(value);
if (parameter == null)
{
throw CreateConversionButNoParamException(value.GetType());
}
decimalValue = converted;
parameter.ConvertedValue = converted;
}
else
{
decimalValue = (decimal)value;
}
if (decimalValue < -92233720368547758.08M || decimalValue > 92233720368547758.07M)
{
throw new OverflowException("The supplied value (" + decimalValue + ") is outside the range for a PostgreSQL money value.");
}
return 8;
}
public override void Write(object value, NpgsqlBuffer buf, NpgsqlParameter parameter)
{
var v = (decimal)(parameter?.ConvertedValue ?? value);
buf.WriteInt64((long)(Math.Round(v, 2, MidpointRounding.AwayFromZero) * 100m));
}
}
}