hendrasyp’s gists

hendrasyp / SP_Transaction.sql

Created December 23, 2022 01:58

SQL Server - Stored Procedure With Transaction


	CREATE PROCEDURE [Schema].[SP_Name] (@Param [DataType(Size)] = DEFAULT_VALUE)
	AS
	BEGIN TRY
	BEGIN TRANSACTION

	-- Business Logic Here

	-- Throw Exception Example
	-- RAISERROR (N'Please delete detail vital sign first !!' , 11, 1);

hendrasyp / ConvertImageURLtoBase64String.cs

Created August 16, 2022 04:17

	//
	// https://dummyimage.com/600x400/000/fff&text=Suhendra%20Yohana%20Putra
	// data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAAlgAAAGQBAMAAACAGwOrAAAAG1BMVEUAAAD/Dw4/AwNfBQV/BwcfAQHfDQyfCQi/Cwo0SO/tAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAIAklEQVR4nO3azVfbxh7HYSFL2MtOQoyXwsnldhnHtL1LXChkiTk3pEtE0tAl7kmBJbqlCX92NW/SzMhqghH3dPF5ziEIy/6N5stoNBKJIgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADAP9rz/f3vGi9Obr7684Onf7v7zVG1mR75u+7RSC19U1rhc504EKXNl8Gr3YU1r3dPnq3ciFNPHq84/2mFjz7YiTif7lyL4eq/9C+ElQhbOs13V26kNh/d3X3KhfhfY0/6aoVy95HmZ/Jbr8j817sLK8ovzEZ/GOxZLSw1PI8PxEW4JxmtUO4+EjOk4kcbWdHWk3BjhUZqc3MuzzbCPY8e1npLTzsMqxpQeTgWHhRWIrJgz6OHNX+2/PUOw7JTVRLOiw8LKyrC7B89rK1vlr/eYVj2IjhvvO9hYU1Ogz2PP7L+D2ENdCcWjZIPC6tx6I8e1lo46RqyH/G4Om/S8b+iJdtqsxHW8Xjs/ZwKuYqL6yWELeA3ko7H2bJGgnJ1WOEMsjQsr+oDDTbr7UtdNXkfqX58K8TQLP2Soly3yk4l78pVhhDvzcvlcucPHdbBbhT991q+/qLcL4a7biOz0/KfdXv1+k+5/1ZtuY3Er+VaUxX2GmmUc0dW/0xvHqj9VViyB+nhp12vagd6zjWl0JvJpupHIs4Pcz0nx/lo7zCXne1vpMVo/1LcmJf3D8WfKqzFhez3pr

hendrasyp / SwaggerOperationFilter.cs

Created June 20, 2022 08:47

Swagger Custom Header Parameter

	// Swagger Init..
	service.AddSwaggerGen(opts =>
	{
	// Custom header for authorization on swagger
	opts.OperationFilter<SwaggerOperationFilter>();

	opts.OrderActionsBy((apiDesc) => $"{apiDesc.ActionDescriptor.RouteValues["controller"]}_{apiDesc.RelativePath}");
	opts.ExampleFilters();

	//jangan dipake, malah bikin versioning ga jalan

hendrasyp / ki-underscore.js

Created January 22, 2022 07:37

Underscore JS By KiNET - Konsultan IT Bandung

	function clearForms($form) {
	$form.find('textarea').val(null);
	$form.find(':input').not(':button, :submit, :reset, :checkbox, :radio').val(null);
	$form.find(':checkbox, :radio').prop('checked', false);
	}

	function _isReadOnlyByClass(el) {
	return $('.' + el).prop('readonly');
	}

hendrasyp / jscore.js

Created January 22, 2022 07:35

JSCore By KiNET - Suhendra Yohana Putra

	// Please see documentation at https://docs.microsoft.com/aspnet/core/client-side/bundling-and-minification
	// for details on configuring this project to bundle and minify static web assets.

	// Write your JavaScript code.
	/* CONSTANTS, GLOBAL VARIABLES */
	let isSuperAdmin;

	let max_char_in_byte = 3915;
	let notyErr = 'error';
	let notyOK = 'success';

hendrasyp / foo.js

Last active December 2, 2021 07:00

Json To CSharp Object

	using Newtonsoft.Json;
	using System;
	using System.Collections.Generic;
	using System.ComponentModel;
	using System.Data;
	using System.Reflection;

	namespace Netester
	{
	class Program

hendrasyp / BrowserInfo.js

Created November 25, 2020 02:31

Check Client Browser Detail

	function browserClientInfo() {
	"undefined" != typeof jQuery ? console.log("jQuery Version", jQuery.fn.jquery) : console.log("jQuery library is not found!");
	navigator.appVersion;
	var n, e, r, o = navigator.userAgent, a = navigator.appName, i = "" + parseFloat(navigator.appVersion),
	s = parseInt(navigator.appVersion, 10);
	-1 != (e = o.indexOf("OPR/")) ? (a = "Opera", i = o.substring(e + 4)) : -1 != (e = o.indexOf("Opera")) ? (a = "Opera", i = o.substring(e + 6), -1 != (e = o.indexOf("Version")) && (i = o.substring(e + 8))) : -1 != (e = o.indexOf("MSIE")) ? (a = "Microsoft Internet Explorer", i = o.substring(e + 5)) : -1 != (e = o.indexOf("Chrome")) ? (a = "Chrome", i = o.substring(e + 7)) : -1 != (e = o.indexOf("Safari")) ? (a = "Safari", i = o.substring(e + 7), -1 != (e = o.indexOf("Version")) && (i = o.substring(e + 8))) : -1 != (e = o.indexOf("Firefox")) ? (a = "Firefox", i = o.substring(e + 8)) : (n = o.lastIndexOf(" ") + 1) < (e = o.lastIndexOf("/")) && (a = o.substring(n, e), i =

hendrasyp / quartz.properties

Last active July 15, 2020 02:05

Java Quartz Propertiez

	# ==================================================================================================================== #
	# QUARTZ
	# Configure JobStore
	#============================================================================
	org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreTX
	org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
	org.quartz.jobStore.useProperties=true
	org.quartz.jobStore.misfireThreshold=25000
	org.quartz.jobStore.tablePrefix=QRTZ_
	org.quartz.jobStore.isClustered=false

hendrasyp / Foo.java

Last active February 28, 2020 08:33

Formatting java.sql.Timestamp

	import lombok.AllArgsConstructor;
	import lombok.Data;
	import lombok.NoArgsConstructor;

	import java.sql.Date;
	import java.sql.Timestamp;

	@AllArgsConstructor
	@NoArgsConstructor
	@Data

hendrasyp / .htaccess

Created December 9, 2019 02:59

HotLink Protection

	RewriteCond %{HTTP_REFERER} !^http://yourdomain.com/.*$ [NC]
	RewriteCond %{HTTP_REFERER} !^http://yourdomain.com$ [NC]
	RewriteCond %{HTTP_REFERER} !^http://www.yourdomain.com/.*$ [NC]
	RewriteCond %{HTTP_REFERER} !^http://www.yourdomain.com$ [NC]
	RewriteCond %{HTTP_REFERER} !^https://yourdomain.com/.*$ [NC]
	RewriteCond %{HTTP_REFERER} !^https://yourdomain.com$ [NC]
	RewriteCond %{HTTP_REFERER} !^https://www.yourdomain.com/.*$ [NC]
	RewriteCond %{HTTP_REFERER} !^https://www.yourdomain.com$ [NC]
	RewriteRule .*\.(jpg\|jpeg\|gif\|png\|bmp)$ - [F,NC]

Suhendra Y Putra hendrasyp