diff options
| author | Lucas Faria Mendes <lucas.fariamo08@gmail.com> | 2026-03-30 13:38:18 +0000 |
|---|---|---|
| committer | Lucas Faria Mendes <lucas.fariamo08@gmail.com> | 2026-03-30 13:38:18 +0000 |
| commit | 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 (patch) | |
| tree | e1c3b20ea08f0cf71122a1e73f0d395f8fd83874 /Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/SqlDataReaderHelper.cs | |
| parent | 674ca83ba9243a9e95a7568c797668dab6aee26a (diff) | |
| download | gestor-1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1.tar.gz gestor-1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1.zip | |
chore: location
Diffstat (limited to 'Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/SqlDataReaderHelper.cs')
| -rw-r--r-- | Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/SqlDataReaderHelper.cs | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/SqlDataReaderHelper.cs b/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/SqlDataReaderHelper.cs new file mode 100644 index 0000000..c4087f8 --- /dev/null +++ b/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/SqlDataReaderHelper.cs @@ -0,0 +1,66 @@ +using System;
+using System.Data.Common;
+using System.Data.SqlClient;
+using System.Diagnostics;
+using System.Runtime.CompilerServices;
+using System.Threading.Tasks;
+
+namespace Gestor.Infrastructure.Helpers
+{
+ internal static class SqlDataReaderHelper
+ {
+ public static bool FieldIsNull(this SqlDataReader rd, string fieldName)
+ {
+ return rd.IsDBNull(rd.GetOrdinal(fieldName));
+ }
+
+ public static async Task<bool> FieldIsNullAsync(SqlDataReader rd, string fieldName)
+ {
+ return await rd.IsDBNullAsync(rd.GetOrdinal(fieldName));
+ }
+
+ public static T GetFieldValue<T>(this SqlDataReader rd, string fieldName, bool normalizeNull = true, bool transformField = true)
+ {
+ Type type = rd[fieldName].GetType();
+ Type type1 = typeof(T);
+ if (type == typeof(DBNull))
+ {
+ if (normalizeNull && (!type1.IsGenericType || !(type1.GetGenericTypeDefinition() == typeof(Nullable<>))))
+ {
+ if (type1 == typeof(int) || type1 == typeof(double) || type1 == typeof(decimal) || type1 == typeof(long))
+ {
+ return (T)Convert.ChangeType(0, type1);
+ }
+ if (type1 == typeof(DateTime))
+ {
+ return (T)Convert.ChangeType(DateTime.MinValue, type1);
+ }
+ if (type1 == typeof(bool))
+ {
+ return (T)Convert.ChangeType(false, type1);
+ }
+ }
+ return default(T);
+ }
+ Type underlyingType = Nullable.GetUnderlyingType(type1) ?? type1;
+ if (type == underlyingType)
+ {
+ return (T)rd[fieldName];
+ }
+ if (!transformField)
+ {
+ return (T)rd[fieldName];
+ }
+ object item = rd[fieldName];
+ if (underlyingType.IsEnum)
+ {
+ item = Enum.Parse(underlyingType, item.ToString());
+ }
+ if (type == typeof(string) && underlyingType == typeof(bool))
+ {
+ item = (string)item == "1";
+ }
+ return (T)Convert.ChangeType(item, underlyingType);
+ }
+ }
+}
\ No newline at end of file |