Skip to content

Instantly share code, notes, and snippets.

View faridprogrammer's full-sized avatar
😃
Working

Farid Bekran faridprogrammer

😃
Working
View GitHub Profile
/etc/ipsec.conf
conn "CONNECTION_NAME"
keyexchange = ikev1
ike = aes256-sha256-modp1536!
esp = aes256-sha256-modp1536!
aggressive = yes
@faridprogrammer
faridprogrammer / Countries.SQL
Created April 10, 2020 12:38 — forked from abroadbent/Countries.SQL
SQL Server T-SQL For Countries Table
CREATE TABLE Countries (
Id int IDENTITY(1,1) NOT NULL,
Iso varchar(2) NOT NULL,
Name varchar(80) NOT NULL,
Iso3 varchar(3) NULL,
NumCode int NULL,
PhoneCode int NOT NULL,
CONSTRAINT [PK_Countries] PRIMARY KEY CLUSTERED ([Id] ASC),
CONSTRAINT [uc_Countries_Iso] UNIQUE NONCLUSTERED ([Iso] ASC)
)
@faridprogrammer
faridprogrammer / web.config
Created September 4, 2019 11:04
Force SSL without www
<rewrite>
<rules>
<rule name="Force non-WWW" enabled="true" stopProcessing="true">
<match url="(.*)" />
<conditions logicalGrouping="MatchAny">
<add input="{HTTP_HOST}" pattern="^(www\.)(.*)$" />
</conditions>
<action type="Redirect" url="https://{C:2}/{R:1}" appendQueryString="true" />
</rule>
<rule name="Force HTTPS" enabled="true" stopProcessing="true">
@faridprogrammer
faridprogrammer / Number_3_3.js
Created September 2, 2019 12:52
JS number seperator
<script type="text/javascript">
function number_3_3(num, sep) {
var number = typeof num === "number" ? num.toString() : num,
separator = typeof sep === "undefined" ? ',' : sep;
return number.replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1" + separator);
}
var nums = $(".number_3_3");
if (nums.length) {
for (var index = 0; index < nums.length; index++) {
@faridprogrammer
faridprogrammer / ReCaptcha.md
Last active August 24, 2019 08:26
Google recaptch validator and code snippets

Google Recaptcha Snippets

Reference Parts

Place this link in HEAD tag of index.html

<script src="https://www.google.com/recaptcha/api.js" async defer></script>

Angular Parts

@faridprogrammer
faridprogrammer / StopWords.sql
Created July 27, 2019 07:30
List of STOP WORDS for SQL Server Full Text Index
-- Stopwords list
CREATE FULLTEXT STOPLIST SQLStopList;
GO
-- Add a stopwords
ALTER FULLTEXT STOPLIST SQLStopList ADD N'به' LANGUAGE 'English';
ALTER FULLTEXT STOPLIST SQLStopList ADD N'با' LANGUAGE 'English';
ALTER FULLTEXT STOPLIST SQLStopList ADD N'از' LANGUAGE 'English';
ALTER FULLTEXT STOPLIST SQLStopList ADD N'تا' LANGUAGE 'English';
ALTER FULLTEXT STOPLIST SQLStopList ADD N'و' LANGUAGE 'English';
ALTER FULLTEXT STOPLIST SQLStopList ADD N'است' LANGUAGE 'English';
@faridprogrammer
faridprogrammer / DropAllObject.sql
Created July 7, 2019 06:15 — forked from dannylloyd/DropAllObject.sql
Deletes all objects in database
/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])
WHILE @name is not null
BEGIN
SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
EXEC (@SQL)
@faridprogrammer
faridprogrammer / HttpHelper.cs
Created June 17, 2019 11:30
Simple http helper
public static class HttpHelper
{
public static async Task Post<T>(string baseUrl, string url, T contentValue)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseUrl);
var content = new StringContent(JsonConvert.SerializeObject(contentValue), Encoding.UTF8, "application/json");
var result = await client.PostAsync(url, content);
@faridprogrammer
faridprogrammer / SecurityHelper.cs
Created June 17, 2019 11:30
Simple security helper
public static class SecurityHelper
{
public static string MD5Hash(string input)
{
StringBuilder hash = new StringBuilder();
MD5CryptoServiceProvider md5provider = new MD5CryptoServiceProvider();
byte[] bytes = md5provider.ComputeHash(new UTF8Encoding().GetBytes(input));
for (int i = 0; i < bytes.Length; i++)
{
@faridprogrammer
faridprogrammer / formpost.cs
Created June 17, 2019 11:29
Simple form post with HttpClient C#
HttpClient httpClient = new HttpClient();
MultipartFormDataContent form = new MultipartFormDataContent();
form.Add(new StringContent(username), "username");
form.Add(new StringContent(useremail), "email");
form.Add(new StringContent(password), "password");
form.Add(new ByteArrayContent(file_bytes, 0, file_bytes.Length), "profile_pic", "hello1.jpg");
HttpResponseMessage response = await httpClient.PostAsync("PostUrl", form);
response.EnsureSuccessStatusCode();