Skip to content

Instantly share code, notes, and snippets.

View halityurttas's full-sized avatar

Halit YURTTAŞ halityurttas

27 followers · 14 following
View GitHub Profile
@halityurttas
halityurttas / global.asax
Last active September 30, 2023 18:02
Get current controller and action name in global.asax
void Application_BeginRequest(object sender, EventArgs e)
{
HttpContextBase context = new HttpContextWrapper(HttpContext.Current);
RouteData rd = RouteTable.Routes.GetRouteData(context);
if (rd != null)
{
string controllerName = rd.GetRequiredString("controller");
string actionName = rd.GetRequiredString("action");
Response.Write("c:" + controllerName + " a:" + actionName);
@halityurttas
halityurttas / removeduplicate.sql
Created September 15, 2015 07:06
T-SQL Delete Duplicate Rows
WITH CTE AS(
SELECT [col1], [col2], [col3], [col4], [col5], [col6], [col7],
RN = ROW_NUMBER()OVER(PARTITION BY col1 ORDER BY col1)
FROM dbo.Table1
)
DELETE FROM CTE WHERE RN > 1
@halityurttas
halityurttas / updatejoin
Created September 16, 2015 13:15
Update table with join
UPDATE t1
SET t1.CalculatedColumn = t2.[Calculated Column]
FROM dbo.Table1 AS t1
INNER JOIN dbo.Table2 AS t2
ON t1.CommonField = t2.[Common Field]
WHERE t1.BatchNo = '110';
@halityurttas
halityurttas / DatetimeBinder.cs
Last active October 22, 2015 15:46
ASP.Net MVC de türkçe tarih okumak
public class DatetimeBinder: IModelBinder
{
public object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
{
string data = "";
if (controllerContext.Controller.ValidateRequest && bindingContext.ModelMetadata.RequestValidationEnabled)
{
data = controllerContext.HttpContext.Request.Params[bindingContext.ModelName];
}
else
@halityurttas
halityurttas / mysqlbackup.bat
Created April 8, 2016 12:37
Windows ortamında mysql full yedekleme
@ECHO OFF
Rem -- dizinler örnektir lütfen kendi mysql dizininizi belirtin burada wamp için örnekleme yaptım. Bu noktaya dikkat
C:\wamp\bin\mysql\mysql5.6.17\bin\mysqldump -u root --all-databases > "C:\mysqlbackups\tmp\alldb.sql"
Rem -- 7z indirip 7z.exe 7z.dll 7z-zip.dll 7z-zip32.dll yi de bu klasöre atın. ayrıca klasöre tmp adında bir klasör açmayı unutmayın
Rem -- ilk dizin adresi kaydedilecek yer ikincisi yukarıda dump sql i aktardığımız dosya adresi
7z a -tzip "C:\mysqlbackups\dest\mysql_alldatabase_%DATE:~7,2%.%DATE:~4,2%.%DATE:~-4%_backup.zip" "C:\mysqlbackups\tmp\*.*" -mx5
Rem -- forfiles ile -d 3 yaparak 3 gün öncesinde ki dosyaları bulmuş oluyoruz bununla 3 gün öncesinde ki yedekleri sileceğiz kendinize göre ayarlayabilirsiniz
forfiles -p "C:\mysqlbackups\dest" -s -m *.* -d 3 -c "cmd /c del @path"
@halityurttas
halityurttas / dynamicmap.js
Created April 10, 2016 23:47
//iframe ile eklenen map ın style özelliğine pointer-events:none eklemeyi unutmayın
$(function() {
$('.map-container').click(function(e) {
$(this).find('iframe').css('pointer-events', 'all');
}).mouseleave(function(e) {
$(this).find('iframe').css('pointer-events', 'none');
});
});
@halityurttas
halityurttas / Bitcoin.cfml
Created April 5, 2018 14:15
Coldfusion bitcoin fiyat durumu. Lütfen https://trycf.com/ adresinde deneyiniz!
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" />
</head>
@halityurttas
halityurttas / ObjectResolver.cfc
Last active July 26, 2018 08:51
Coldfusion object resolve with scoped container
<cfscript>
component {
property struct requestContainer;
property struct sessionContainer;
property struct applicationContainer;
public any function init() {
if (isDefined("request.container")) {
@halityurttas
halityurttas / XmlSerializeHelper.cs
Created July 28, 2018 07:25
.Net XML Serialization Helper
public static class XmlSerializeHelper
{
public static string XmlSerialize<T>(this T source) where T : class
{
StringBuilder stringBuilder = new StringBuilder();
using (StringWriter writer = new StringWriter(stringBuilder))
{
var serializer = new XmlSerializer(typeof(T));
serializer.Serialize(writer, source);
}
@halityurttas
halityurttas / particle.html
Created August 9, 2018 09:42
Particle star widget
<!-- particles.js container -->
<div id="particles-js"></div>
<div id="particles-image"></div>
<!-- particles.js lib - https://github.com/VincentGarreau/particles.js -->
<script src="https://cdn.jsdelivr.net/particles.js/2.0.0/particles.min.js"></script>
<style>
#particles-js {
width: 100%;
height: 300px;