Skip to content

Instantly share code, notes, and snippets.

View vibs2006's full-sized avatar

vibs2006

View GitHub Profile
@vibs2006
vibs2006 / OPENJSON.sql
Last active June 14, 2023 12:24
SQL Server Use Case Examples
declare @json varchar(max) = '[
{
"InvoiceNumber": 3333428,
"PaidAmount": 10.0,
"Bank": "Bank Name 1",
"PaymentReference": "PaymentReference 1"
},
{
"InvoiceNumber": 2457759,
"PaidAmount": 15.0,
@vibs2006
vibs2006 / Readme.Md
Last active June 14, 2023 12:17
C# Small Utilities
  1. Recursive Inner Exception Looping for Logging Purpose.
@vibs2006
vibs2006 / Path.Combine.Javascript.js
Last active June 14, 2023 12:38
Javascript Helper Methods
//Path.Combine Equivalent in Javascript
function pathJoin(parts, sep){
const separator = sep || '/';
parts = parts.map((part, index)=>{
if (index) {
part = part.replace(new RegExp('^' + separator), '');
}
if (index !== parts.length - 1) {
@vibs2006
vibs2006 / ASP.NET.Core.6.Startup.cs
Last active June 14, 2023 12:15
SELF HOST API with Swagger Configuration for all .NET Versions
public class Program
{
static void Main(string[] args)
{
Console.WriteLine("Starting Padauk Web API Services");
try
{
var applicationName = "Padauk.API";
var builder = WebApplication.CreateBuilder(args);
var startup = new WebHostStartup(builder.Configuration);
@vibs2006
vibs2006 / MailHelper.cs
Last active June 14, 2023 12:11
Mail Helpers
using MailKit.Net.Smtp;
using MimeKit;
using System;
using System.Collections.Generic;
using System.Linq;
namespace HelperUtilities.MailKitNew
{
public class MailHelper
@vibs2006
vibs2006 / AdminController.cs
Last active April 22, 2023 13:05
View Logs via API Controllers
[RoutePrefix("")]
public class AdminController : ApiController
{
[Route("Admin/{id}")]
[HttpGet]
public IHttpActionResult Admin(string id)
{
if (
(ConfigurationManager.AppSettings["LogsKey"] != null && ConfigurationManager.AppSettings.Get("LogsKey") == id )
||
@vibs2006
vibs2006 / VatCalculation.sql
Last active March 17, 2023 15:27
Vat CalculationSQL
declare @netprice decimal(18,2) = 120;
declare @vatrate decimal(18,2) = 20;
DECLARE @baseprice decimal(18,2)
SET @baseprice = @netprice / (1 + (@vatrate/100))
select @baseprice as BasePrice, ((@vatrate/100)*(@baseprice)) as Vat , @baseprice + ((@vatrate/100)*(@baseprice)) as NetPrice
@vibs2006
vibs2006 / Readme.md
Last active June 14, 2023 12:35
Windows Commandline Common UTILs

#Windows Command Line Batch Examples

@vibs2006
vibs2006 / CustomLogger.cs
Created June 14, 2023 12:34
Logging Utilities and Helper Methods
using System;
namespace CoreApp
{
public class CustomLogger
{
private static object lockObject = new object();
private string _baseFolderForLogs = string.Empty;
private string _baseFileNameForLogs = string.Empty;
@vibs2006
vibs2006 / GetNullableType.cs
Created August 7, 2023 07:05
C# Small codes
//Get Nullable Type
namespace TestConsoleApp
{
public class PaginationRequestParams
{
public string? page_cursor { get; set; }
public int? count { get; set; }
public string? response_fields { get; set; }