Ragom.Toolkit 1.0.1

Ragom.Toolkit

A lightweight, production-ready .NET utility toolkit providing reusable extensions, helpers, security utilities, HTTP services, OTP generation, and numeric/text processing tools.

Designed for clean architecture, high reusability, and zero external dependencies.

---

🚀 Features

• 📅 Date & Time utilities (IST support, parsing, formatting, conversions)
• 🔄 Safe type conversion extensions (int, long, decimal, double, float, bool, Guid, enum, DateTime, TimeSpan)
• 🧾 Enum helpers with caching and description support
• 📁 File system utilities and file handling helpers
• 🎨 String & formatting utilities (phone, currency, masking, title case, cleanup)
• 🌐 URL normalization and query utilities
• ✅ Validation helpers (email, numeric, null-safe checks)
• 🧩 Dynamic SQL models and query condition builders
• 🗄️ Advanced DbHelper utilities for SQL Server
• ⚡ INSERT, UPDATE, UPSERT database operations
• 🔍 Generic object mapping from SQL queries
• 🔐 SQL injection-safe parameter handling
• 🌍 HTTP client and web request helpers
• 🔒 AES and symmetric encryption utilities
• 🔑 Secure OTP generation using cryptographic RNG
• 🧮 Number-to-word conversion (INR/USD/EUR support)
• 🏗️ Lightweight, reusable, production-ready architecture
• 🎯 Multi-target support for .NET Standard 2.0, .NET 8, and .NET 10

---

📦 Installation

dotnet add package Ragom.Toolkit

or via Package Manager:

Install-Package Ragom.Toolkit

---

🧩 Namespaces

Ragom.Toolkit.Extensions
Ragom.Toolkit.Models
Ragom.Toolkit.Security
Ragom.Toolkit.Services
Ragom.Toolkit.Utilities
Ragom.Toolkit.Database

---

🔧 Extensions

---

📅 DateTimeExtensions

DateTime now = DateTimeExtensions.GetIndianDateTime();

var start = DateTimeExtensions.GetDateFromCollection("01/01/2025 - 10/01/2025");

DateTime? dt = "26052026".ToDateTimeFromDdMMyyyy();

---

🧾 EnumExtensions

string description = Status.Active.ToDescription();

---

📁 FileExtensions

bool exists = FileExtensions.IsFileExist(@"C:\temp\file.txt");
bool deleted = FileExtensions.DeleteFile(@"C:\temp\file.txt");

---

🎨 FormatExtensions

"9876543210".ToPhoneFormat();
"hello world".ToTitleCase();
"12345".ToCurrencyStyle();
"1000000".ToNumberFormat();
"1234567812345678".CardNumberMaskedWithStar(4, 4);

---

🔤 StringExtensions

"abc@123#".RemoveSpecialCharacters();
"abc@123#".RemoveSpecialCharacters(new char[] { '@' });

---

🌐 UrlExtensions

string url = "https://example.com/path".ToUrlFormat();

---

✅ ValidationExtensions

"123.45".IsNumeric();
"test@example.com".IsValidEmail();

---

🔄 ConversionExtensions

Safe conversion helpers for:

• int / long / float / double / decimal
• bool
• DateTime
• TimeSpan
• Guid
• Enum
• Nullable conversions
• Object-to-type conversions

Supports:

• DBNull handling
• Invariant culture parsing
• Safe fallback defaults
• Nullable return types

---

🔢 Integer Conversion

"100".ToInt();
"100".ToIntNull();

object value = "200";
value.ToInt();

---

🔢 Long Conversion

"999999".ToLong();
"999999".ToLongNull();

---

🔢 Decimal / Double / Float

"12.50".ToDouble();
"99.95".ToDecimal();
"45.7".ToFloat();

Nullable:

"".ToDoubleNull();
"".ToDecimalNull();
"".ToFloatNull();

---

✅ Boolean Conversion

Supports:

true/false
1/0
yes/no
y/n
on/off

Example:

"yes".ToBool();
"1".ToBool();

object value = "off";
value.ToBool();

Nullable:

"maybe".ToBoolNull();

---

📅 DateTime Conversion

Supported formats:

dd/MM/yyyy
dd-MM-yyyy
yyyy-MM-dd
yyyy-MM-dd HH:mm:ss
yyyy-MM-ddTHH:mm:ss

Example:

"26/05/2026".ToDateTime();

object value = "2026-05-26";
value.ToDateTime();

Nullable:

"invalid".ToDateTimeNull();

---

⏱️ TimeSpan Conversion

"02:30".ToNullTimeSpan();

object value = "01:15:00";
value.ToNullTimeSpan();

---

🔤 String Conversion

object data = "Hello World";
data.ToStr();

object nullData = null;
nullData.ToStr("N/A");

object spacedData = "  Clean Me  ";
spacedData.ToTrimmedStr();

string emptyStr = "   ";
emptyStr.ToNullIfEmpty();

---

🆔 Guid Conversion

"d85b1407-351d-4694-9392-03acc5870eb1".ToGuid();

object value = Guid.NewGuid();
value.ToGuid();

Nullable:

"invalid".ToGuidNull();

---

🧩 Enum Conversion

"Admin".ToEnum<UserRole>();

"Active".ToEnum(Status.Pending);

object dbValue = "2";
dbValue.ToEnum(Status.Active);

Nullable:

object value = "Pending";
value.ToEnumNull<Status>();

---

⚡ Features

• Safe parsing without exceptions
• Handles null and DBNull values
• Culture-invariant parsing
• Nullable conversion support
• Enum parsing support
• Production-ready extension methods

---

🧩 Models

DbCondition

Used for dynamic SQL query building.

var condition = new DbCondition("Age", 25, ">");

Supported operators:

=, !=, <>, >, <, >=, <=, LIKE

---

DbData

Used for INSERT/UPDATE parameter mapping.

var data = new DbData("Name", "John");

---

🔐 Security

CryptoUtility

Supports multiple symmetric encryption algorithms:

• DES
• RC2
• Rijndael (Recommended)
• TripleDES

string enc = CryptoUtility.Encrypt("HelloWorld", "MyPass");
string dec = CryptoUtility.Decrypt(enc, "MyPass");

---

EncryptionService (AES)

string enc = EncryptionService.Encrypt("Hello");
string dec = EncryptionService.Decrypt(enc);

---

🌍 HTTP Services

HttpServices

string result = await HttpServices.FetchFromWebAsync("https://api.example.com");

Add query parameters:

var url = HttpServices.AppendToQueryString(
    "https://example.com/search",
    new NameValueCollection { { "q", "dotnet" } }
);

---

🗄️ Database Utilities

DbHelper

A lightweight ADO.NET helper for SQL Server with support for:

• Generic object mapping
• INSERT / UPDATE / UPSERT
• ExecuteScalar
• ExecuteDataTable
• ExecuteDataSet
• Parameterized queries
• SQL transaction support
• Safe SQL validation

---

✔ Execute Generic List

var users = DbHelper.ExecuteGenericList<User>(
    connectionString,
    "SELECT * FROM Users",
    CommandType.Text
);

---

✔ Insert Data

var data = new List<DbData>
{
    new DbData("Name", "John"),
    new DbData("Age", 25)
};

long id = DbHelper.Insert(
    connectionString,
    "Users",
    data
);

---

✔ Update Data

var data = new List<DbData>
{
    new DbData("Name", "Updated User")
};

var conditions = new List<DbCondition>
{
    new DbCondition("Id", 1, "=")
};

DbHelper.Update(
    connectionString,
    "Users",
    data,
    conditions
);

---

✔ Insert or Update (Upsert)

DbHelper.InsertUpdate(
    connectionString,
    "Users",
    data,
    conditions
);

---

✔ Execute Raw Query

DbHelper.ExecuteQuery(
    connectionString,
    "DELETE FROM Logs",
    CommandType.Text
);

---

✔ Execute DataTable

DataTable dt = DbHelper.ExecuteDataTable(
    connectionString,
    "SELECT * FROM Users",
    CommandType.Text
);

---

✔ Execute DataSet

DataSet ds = DbHelper.ExecuteDataSet(
    connectionString,
    "sp_GetDashboard",
    CommandType.StoredProcedure
);

---

✔ Execute Scalar

string count = DbHelper.ExecuteScalarData(
    connectionString,
    "SELECT COUNT(*) FROM Users",
    CommandType.Text
);

---

✔ Unique Validation

bool exists = DbHelper.IsUnique(
    connectionString,
    "Users",
    "Email",
    "test@example.com"
);

---

🔐 Database Security Features

• SQL Injection Protection
• Parameterized Queries
• Table & Column Validation
• Safe SQL Operators
• Transaction Support
• Reflection-based Mapping Cache
• DBNull Handling
• Nullable Type Support

---

🧮 Utilities

NumericToWord

Convert numbers into words (supports INR, USD, EUR).

string r1 = NumericToWord.ConvertNumericToWord("123.50");
string r2 = NumericToWord.ConvertNumericToWord("1000", CurrencyType.USD);

---

Currency Types

INR → Rupees Only
USD → Dollars Only
EUR → Euros Only

---

OtpGenerator

Secure OTP generation using cryptographic RNG.

string otp = OtpGenerator.GetOTP(6);

---

⚡ Why Ragom.Toolkit?

• Lightweight and dependency-free
• Production-ready utilities
• Clean extension-based design
• Secure encryption & OTP generation
• Reusable across enterprise applications

---

📌 License

Internal / Project use (update as required)

---

📦 NuGet Tags (Recommended)

dotnet, utilities, extensions, encryption, otp, helper, toolkit, ragom, validation, format, http

---