Dmitry Kalinov KalinovDmitri

.NET Senior developer

KalinovDmitri / DocumentsQuery.sql

Created October 9, 2018 08:48

	DECLARE @kindId UNIQUEIDENTIFIER = '2E42CD9A-66FA-471E-BA75-5A74D36E05D3'; -- place target Kind here
	DECLARE @folderId UNIQUEIDENTIFIER = 'D0134C4C-2B33-45BC-9B3A-EEFCEF855C87'; -- place target Folder here

	SELECT
	[DocMainInfo].[InstanceID] AS [CardID],
	[InstanceDates].[CreationDateTime],
	@folderId AS [FolderID]
	FROM [dbo].[CardDocument::MainInfo] AS [DocMainInfo]
	INNER JOIN [dbo].[dvsys_instances_date] AS [InstanceDates] ON ([InstanceDates].[InstanceID] = [DocMainInfo].[InstanceID])
	INNER JOIN [dbo].[CardDocument::System] AS [DocSystemInfo] ON ([DocSystemInfo].[InstanceID] = [DocMainInfo].[InstanceID])

KalinovDmitri / QueryExample.sql

Created October 2, 2018 12:06


	DECLARE @First TABLE
	(
	[InstanceID] UNIQUEIDENTIFIER NOT NULL
	);

	DECLARE @Second TABLE
	(
	[CogProgramOptions] VARCHAR(MAX) NOT NULL,
	[SomeOtherValue] INT NOT NULL

KalinovDmitri / Request.ps1

Created August 28, 2018 20:15

	$asm = [System.Reflection.Assembly]::Load("System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a");
	$client = New-Object -TypeName System.Net.Http.HttpClient;
	$url = "https://sandbox-api.coinmarketcap.com/v1/cryprocurrency/listings/latest?start=0&limit=5000&convert=USD,EUR";
	$msg = New-Object -TypeName System.Net.Http.HttpRequestMessage -ArgumentList ([System.Net.Http.HttpMethod]::Get, $url);
	$msg.Headers.Accept.Add("application/json");
	$msg.Headers.Add("X-CMC_PRO_API_KEY", "b54bcf4d-1bca-4e8e-9a24-22ff2c3d462c");
	$response = $client.SendAsync($msg);
	$response.Result

KalinovDmitri / AccountController.cs

Created August 23, 2018 20:57

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Net;
	using System.Threading.Tasks;
	using System.Web.Mvc;

	using NetMvcExample.Models;

	namespace NetMvcExample.Controllers

KalinovDmitri / BookController.cs

Created April 23, 2018 23:29

MyBooks

	using System;
	using System.Collections.Generic;
	using System.Data;
	using System.Data.Entity;
	using System.Data.Entity.Infrastructure;
	using System.Linq;
	using System.Net;
	using System.Net.Http;
	using System.Threading;
	using System.Threading.Tasks;

KalinovDmitri / Book.cs

Created April 23, 2018 18:18

MyBooks

	using System;
	using System.Collections.Generic;
	using System.ComponentModel.DataAnnotations;
	using System.Linq;
	using System.Web;

	namespace MyBooks.Models
	{
	public class Book
	{

KalinovDmitri / AbonentPhones.sql

Created April 6, 2018 09:19


	-- declare all required tables

	CREATE TABLE [dbo].[Abonents]
	(
	[Id] BIGINT NOT NULL IDENTITY(1, 1) PRIMARY KEY NONCLUSTERED,
	[FirstName] NVARCHAR(64) NOT NULL,
	[LastName] NVARCHAR(64) NOT NULL,
	[Phone1] VARCHAR(20) NULL,
	[Phone2] VARCHAR(20) NULL,

KalinovDmitri / AsyncProcessRunner.cs

Created March 30, 2018 12:34

	using System;
	using System.Collections.Generic;
	using System.IO;
	using System.Diagnostics;
	using System.Text;
	using System.Threading;
	using System.Threading.Tasks;

	namespace CodeSamples.Common.Diagnostics
	{

KalinovDmitri / DNIWE.cs

Created March 21, 2018 13:18


	public class SomeCalcController : Controller
	{
	public ActionResult DoCalc(SomeCalc calc)
	{
	calc.DoCalc();

	calc.Save();
	}
	}

KalinovDmitri / UnderlinedOnMouseOverButtonStyle.xaml

Created March 13, 2018 19:49

	<Style x:Key="UnderlinedOnMouseOverButtonStyle" TargetType="{x:Type Button}">
	<Style.Triggers>
	<Trigger Property="IsMouseOver" Value="True">
	<Setter Property="ContentTemplate">
	<Setter.Value>
	<DataTemplate>
	<TextBlock TextDecorations="Underline" Text="{TemplateBinding Content}"/>
	</DataTemplate>
	</Setter.Value>
	</Setter>