Skip to content

Instantly share code, notes, and snippets.

View SalihKARAHAN's full-sized avatar
🤓
🏗️ Something is building here

Salih KARAHAN SalihKARAHAN

🤓
🏗️ Something is building here
View GitHub Profile
@SalihKARAHAN
SalihKARAHAN / install-docker.sh
Last active April 4, 2023 12:22
This scrip is useful to install docker on ubuntu 20.04 LTS.
#!/bin/sh
# It would be outdated after a while
# This file created at 2023.04.03 by Salih KARAHAN <salihkarahan@outlook.com>
# Install docker (follow steps at the link https://docs.docker.com/engine/install/ubuntu/)
sudo apt-get update && sudo apt-get -y upgrade
sudo apt-get update
sudo apt-get install \
#!/bin/bash
# Salih KARAHAN
# Klasördeki dosya isimlerini numaralandırarak değiştiren sh scripti
cd "C:\Users\skarahan\AppData\Local\Packages\Microsoft.Windows.ContentDeliveryManager_cw5n1h2txyewy\LocalState\Assets"
FILES=$(ls | grep -v sh)
COUNTER=1
for fileName in $FILES
do
@SalihKARAHAN
SalihKARAHAN / webserver.js
Created November 20, 2015 17:11 — forked from hectorcorrea/webserver.js
web server in node.js
// A very basic web server in node.js
// Stolen from: Node.js for Front-End Developers by Garann Means (p. 9-10)
var port = 8000;
var serverUrl = "127.0.0.1";
var http = require("http");
var path = require("path");
var fs = require("fs");
@SalihKARAHAN
SalihKARAHAN / fn$_GetSplitedString
Created August 9, 2015 11:07
String'i split eden fonksiyon
-- String'i split eden fonksiyon
CREATE FUNCTION fn$_GetSplitedString
(
@seperator CHAR(1)
, @stringList NVARCHAR(MAX)
)
RETURNS @returnTable TABLE
(
TagName NVARCHAR(100) NOT NULL
)
@SalihKARAHAN
SalihKARAHAN / GetAllForeignKeys
Created May 6, 2015 13:39
İlgili database üzerindeki tüm foreign keyler için hangi tablodan hangi tabloya bilgisini tablo ve kolon isimleriyle getiren script
-- http://stackoverflow.com/questions/8094156/know-relationships-between-all-the-tables-of-database-in-sql-server
SELECT
fk.name 'FK Name',
tp.name 'Parent table',
cp.name, cp.column_id,
tr.name 'Refrenced table',
cr.name, cr.column_id
FROM
sys.foreign_keys fk
This file has been truncated, but you can view the full file.
/*
** Copyright Microsoft, Inc. 1994 - 2000
** All Rights Reserved.
*/
SET NOCOUNT ON
GO
USE master
GO
public virtual TResultType ExecuteQueryEngine<TResultType>(string query, SqlParameter[] parameters, SqlCommand command, Func<TResultType> tryBlock, Action cacthBlock, Action finallyBlock)
{
try
{
if (!string.IsNullOrEmpty(query) && command == null)
{
_sqlCommand = new SqlCommand(query, _sqlConnection, _sqlTransaction);
if (parameters != null)
{
_sqlCommand.Parameters.AddRange(parameters);
@SalihKARAHAN
SalihKARAHAN / web.config
Created September 30, 2014 18:02
ASP.MVC Sayfa Bazlı CSS JS Dosyalarını Çalıştırabilme
<system.web>
<!--Partial CSS JavaScript Configuration Start-->
<httpHandlers>
<add path="*.js" verb="GET,HEAD" type="System.Web.StaticFileHandler" />
<add path="*.css" verb="GET,HEAD" type="System.Web.StaticFileHandler" />
<add path="*" verb="*" type="System.Web.HttpNotFoundHandler"/>
</httpHandlers>
<!--Partial CSS JavaScript Configuration End-->
</system.web>
<system.webServer>
@SalihKARAHAN
SalihKARAHAN / ConvertAmountToString.js
Created April 16, 2014 08:20
Parasal değerleri yazıya çeviren bir script. Fakat çok detaylı değil. Düzenlenmesi ve gelen ücrette bazı kontrollerin daha yapılması lazım.
/*
* PARÇADAN BÜTÜNE
*/
var NumberWriteValue =
[
["", "Bir", "İki", "Üç", "Dört", "Beş", "Altı", "Yedi", "Sekiz", "Dokuz"],
["", "On", "Yirmi", "Otuz", "Kırk", "Elli", "Altmış", "Yetmiş", "Seksen", "Doksan"]
];
@SalihKARAHAN
SalihKARAHAN / WindowsCaption.xaml.cs
Last active August 29, 2015 13:55
Dependency Property on WPF Custom Control Library
public static readonly DependencyProperty CaptionTextProperty = DependencyProperty.Register(
"CaptionText",
typeof(string),
typeof(WindowCaption),
new UIPropertyMetadata(CaptionTextChanged));
public static void CaptionTextChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
{
((WindowCaption)(sender)).Caption = e.NewValue.ToString();
}