Mahmut Gundogdu mahmut-gundogdu

## bs3-login-form.html
<div class="container">
    <div class="row">
        <div class="col-sm-6 col-md-4 col-md-offset-4">
            <h1 class="text-center login-title">Sign in to continue to Bootsnipp</h1>
            <div class="account-wall">
                <img class="profile-img" src="https://lh5.googleusercontent.com/-b0-k99FZlyE/AAAAAAAAAAI/AAAAAAAAAAA/eu7opA4byxI/photo.jpg?sz=120"
                    alt="">
                <form class="form-signin">
                <input type="text" class="form-control" placeholder="Email" required autofocus>
                <input type="password" class="form-control" placeholder="Password" required>

## GolgelerinGucu
CREATE PROC sp_generate_inserts
(
	@table_name varchar(776),  		-- The table/view for which the INSERT statements will be generated using the existing data
	@target_table varchar(776) = NULL, 	-- Use this parameter to specify a different table name into which the data will be inserted
	@include_column_list bit = 1,		-- Use this parameter to include/ommit column list in the generated INSERT statement
	@from varchar(800) = NULL, 		-- Use this parameter to filter the rows based on a filter condition (using WHERE)
	@include_timestamp bit = 0, 		-- Specify 1 for this parameter, if you want to include the TIMESTAMP/ROWVERSION column's data in the INSERT statement
	@debug_mode bit = 0,			-- If @debug_mode is set to 1, the SQL statements constructed by this procedure will be printed for later examination
	@owner varchar(64) = NULL,		-- Use this parameter if you are not the owner of the table
	@ommit_images bit = 0,			-- Use this parameter to generate INSERT statements by omitting the 'image' columns

## MultiMarkerMultiInfoWindow
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
	<title></title>
	<script src="https://maps.googleapis.com/maps/api/js?v=3.exp"></script>
	<script type="text/javascript" >
var map;
var marker;
var infowindow;

## kullanici.cs
 //Bu kodlar ile txt dosyasından aldık. Böylece Taslak Değişeceği zaman template.html değiştirmek yeterli.
        TextReader txt = File.OpenText(Server.MapPath("~/App_Data/template.html"));
        var strTemplate=txt.ReadToEnd();
        txt.Close();
        txt.Dispose();

        //Adim 1. Templatei verdik.
        Template template = Template.Parse(strTemplate);

        //Veri Normalde bu database den gelir ben kendim olusturdum.

## Ayarlar.cs
using Biggy;
using Biggy.JSON;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace AYarlar
{
    public class Firma

## Çözüm 1
//Kaynak: http://stackoverflow.com/questions/18550769/sqldatareader-best-way-to-check-for-null-values-sqldatareader-isdbnull-vs-dbnul


using System;
using System.ComponentModel;
using System.Data.SqlClient;

public static class SqlReaderHelper
{
    private static bool IsNullableType(Type theValueType)

## gist:4b1696b4af5b0eef326a
    <asp:DataPager ID="DataPagerProducts" runat="server" PagedControlID="LvCategoryItems" PageSize="10" OnPreRender="PagerCategoryItems_PreRender" class="btn-group pager-buttons">
        <Fields>
            <asp:NextPreviousPagerField ShowLastPageButton="False" ShowNextPageButton="False" ButtonType="Button" ButtonCssClass="btn" RenderNonBreakingSpacesBetweenControls="false" />
            <asp:NumericPagerField ButtonType="Button" RenderNonBreakingSpacesBetweenControls="false" NumericButtonCssClass="btn" CurrentPageLabelCssClass="btn disabled" NextPreviousButtonCssClass="btn" />
            <asp:NextPreviousPagerField ShowFirstPageButton="False" ShowPreviousPageButton="False" ButtonType="Button" ButtonCssClass="btn" RenderNonBreakingSpacesBetweenControls="false" />
        </Fields>
    </asp:DataPager>

## a.sql
 CREATE PROCEDURE [dbo].[deleteAllDataFromAllTables] AS
SET NOCOUNT ON

    DECLARE @dropAndCreateConstraintsTable TABLE ( DropStmt varchar(max) , CreateStmt varchar(max) )

    insert @dropAndCreateConstraintsTable select
      DropStmt = 'ALTER TABLE [' + ForeignKeys.ForeignTableSchema +
          '].[' + ForeignKeys.ForeignTableName +
          '] DROP CONSTRAINT [' + ForeignKeys.ForeignKeyName + ']; '
    ,  CreateStmt = 'ALTER TABLE [' + ForeignKeys.ForeignTableSchema +

## gist:d9a524b8af3ae51ea5a1
DROP FUNCTION IF EXISTS slugify;
DELIMITER ;;
CREATE DEFINER='root'@'localhost'
FUNCTION slugify (temp_string VARCHAR(200) CHARSET utf8)
RETURNS VARCHAR(200)
DETERMINISTIC
BEGIN
DECLARE x, y , z Int;
DECLARE new_string VARCHAR(200);
DECLARE is_allowed Bool;

## gist.js
 var formData = {};
 $(".form-secici").serializeArray().map(function (x) { formData[x.name] = x.value; });
	<div class="container">
	<div class="row">
	<div class="col-sm-6 col-md-4 col-md-offset-4">
	<h1 class="text-center login-title">Sign in to continue to Bootsnipp</h1>
	<div class="account-wall">
	<img class="profile-img" src="https://lh5.googleusercontent.com/-b0-k99FZlyE/AAAAAAAAAAI/AAAAAAAAAAA/eu7opA4byxI/photo.jpg?sz=120"
	alt="">
	<form class="form-signin">
	<input type="text" class="form-control" placeholder="Email" required autofocus>
	<input type="password" class="form-control" placeholder="Password" required>
	CREATE PROC sp_generate_inserts
	(
	@table_name varchar(776), -- The table/view for which the INSERT statements will be generated using the existing data
	@target_table varchar(776) = NULL, -- Use this parameter to specify a different table name into which the data will be inserted
	@include_column_list bit = 1, -- Use this parameter to include/ommit column list in the generated INSERT statement
	@from varchar(800) = NULL, -- Use this parameter to filter the rows based on a filter condition (using WHERE)
	@include_timestamp bit = 0, -- Specify 1 for this parameter, if you want to include the TIMESTAMP/ROWVERSION column's data in the INSERT statement
	@debug_mode bit = 0, -- If @debug_mode is set to 1, the SQL statements constructed by this procedure will be printed for later examination
	@owner varchar(64) = NULL, -- Use this parameter if you are not the owner of the table
	@ommit_images bit = 0, -- Use this parameter to generate INSERT statements by omitting the 'image' columns
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
	<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
	<title></title>
	<script src="https://maps.googleapis.com/maps/api/js?v=3.exp"></script>
	<script type="text/javascript" >
	var map;
	var marker;
	var infowindow;
	//Bu kodlar ile txt dosyasından aldık. Böylece Taslak Değişeceği zaman template.html değiştirmek yeterli.
	TextReader txt = File.OpenText(Server.MapPath("~/App_Data/template.html"));
	var strTemplate=txt.ReadToEnd();
	txt.Close();
	txt.Dispose();

	//Adim 1. Templatei verdik.
	Template template = Template.Parse(strTemplate);

	//Veri Normalde bu database den gelir ben kendim olusturdum.
	using Biggy;
	using Biggy.JSON;
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Web;

	namespace AYarlar
	{
	public class Firma
	//Kaynak: http://stackoverflow.com/questions/18550769/sqldatareader-best-way-to-check-for-null-values-sqldatareader-isdbnull-vs-dbnul


	using System;
	using System.ComponentModel;
	using System.Data.SqlClient;

	public static class SqlReaderHelper
	{
	private static bool IsNullableType(Type theValueType)
	<asp:DataPager ID="DataPagerProducts" runat="server" PagedControlID="LvCategoryItems" PageSize="10" OnPreRender="PagerCategoryItems_PreRender" class="btn-group pager-buttons">
	<Fields>
	<asp:NextPreviousPagerField ShowLastPageButton="False" ShowNextPageButton="False" ButtonType="Button" ButtonCssClass="btn" RenderNonBreakingSpacesBetweenControls="false" />
	<asp:NumericPagerField ButtonType="Button" RenderNonBreakingSpacesBetweenControls="false" NumericButtonCssClass="btn" CurrentPageLabelCssClass="btn disabled" NextPreviousButtonCssClass="btn" />
	<asp:NextPreviousPagerField ShowFirstPageButton="False" ShowPreviousPageButton="False" ButtonType="Button" ButtonCssClass="btn" RenderNonBreakingSpacesBetweenControls="false" />
	</Fields>
	</asp:DataPager>
	CREATE PROCEDURE [dbo].[deleteAllDataFromAllTables] AS
	SET NOCOUNT ON

	DECLARE @dropAndCreateConstraintsTable TABLE ( DropStmt varchar(max) , CreateStmt varchar(max) )

	insert @dropAndCreateConstraintsTable select
	DropStmt = 'ALTER TABLE [' + ForeignKeys.ForeignTableSchema +
	'].[' + ForeignKeys.ForeignTableName +
	'] DROP CONSTRAINT [' + ForeignKeys.ForeignKeyName + ']; '
	, CreateStmt = 'ALTER TABLE [' + ForeignKeys.ForeignTableSchema +
	DROP FUNCTION IF EXISTS slugify;
	DELIMITER ;;
	CREATE DEFINER='root'@'localhost'
	FUNCTION slugify (temp_string VARCHAR(200) CHARSET utf8)
	RETURNS VARCHAR(200)
	DETERMINISTIC
	BEGIN
	DECLARE x, y , z Int;
	DECLARE new_string VARCHAR(200);
	DECLARE is_allowed Bool;
	var formData = {};
	$(".form-secici").serializeArray().map(function (x) { formData[x.name] = x.value; });