Skip to content

Instantly share code, notes, and snippets.

View janosorcsik's full-sized avatar

János Orcsik janosorcsik

View GitHub Profile
@janosorcsik
janosorcsik / CheckMessageContract.cs
Last active December 11, 2017 21:05
Check MessageContractAttribute
[TestMethod]
public void CheckMessageContract()
{
var m = Assembly.Load("DataContracts").GetTypes().
Where(t => t.GetCustomAttributes(typeof(MessageContractAttribute)).Any()).ToArray();
foreach (Type t in m)
{
MessageContractAttribute a = (MessageContractAttribute) t.GetCustomAttribute(typeof(MessageContractAttribute), false);
@janosorcsik
janosorcsik / MDI_CTE.sql
Last active December 11, 2017 21:09
Annyi sor, amennyi az intervantionumber
CREATE FUNCTION [dbo].[MDI_CTE] (@ID BIGINT)
RETURNS @MID_CTE TABLE
(
ID BIGINT,
ToothCode NVARCHAR(64),
InterventionCode NVARCHAR(16),
BNOCode NVARCHAR(16),
ToBeReported BIT,
DentistryPatientDatacardID BIGINT,
InterventionNumber INT
@janosorcsik
janosorcsik / Update1000.sql
Last active December 11, 2017 21:12
Update ezresével
DECLARE @MSG NVARCHAR(MAX),
@LASTCCOUNT INT,
@PRCCOUNT INT
SET @PRCCOUNT =
(SELECT COUNT(1)
FROM [Prisoners]
WHERE [WasDentalReceiving] = 1 AND [EUAdatokFeladva] = 0)
SET @LASTCCOUNT = -1
@janosorcsik
janosorcsik / readonlyhandler.js
Last active December 11, 2017 21:15
Knockout readonly handler
ko.bindingHandlers['readonly'] = {
'update': function (element, valueAccessor) {
var value = ko.utils.unwrapObservable(valueAccessor());
if (!value && element.readOnly)
element.readOnly = false;
else if (value && !element.readOnly)
element.readOnly = true;
}
};
cask 'moeditor' do
version '0.0.1'
sha256 'db2c282cdf9854c7189dcc7e1e608f2be02c5cfb88f0bebd638db8008ecb664b'
url 'https://github.com/Moeditor/Moeditor/releases/download/v0.0.1-alpha/Moeditor-0.0.1-darwin-x64.7z'
name 'Moeditor'
license :gpl
depends_on arch: :x86_64
@janosorcsik
janosorcsik / sql_while_sample.sql
Last active December 11, 2017 21:18
SQL WHILE sample
DECLARE @Temp TABLE
(
RowID INT IDENTITY (1,1),
InstituteID INT,
WorkerID INT
)
DECLARE @iMax INT,
@i INT
INSERT INTO @Temp (InstituteID, WorkerID)
@janosorcsik
janosorcsik / PDFMerger.cs
Last active December 11, 2017 21:31
Merge PDFs
namespace CrystalPrinter.Utilities
{
using iTextSharp.text;
using iTextSharp.text.pdf;
using System;
using System.Collections.Generic;
using System.IO;
// http://www.codeproject.com/Articles/28283/Simple-NET-PDF-Merger
public static class PDFMerger
@janosorcsik
janosorcsik / TelerikReportHelper.cs
Last active September 12, 2018 09:20
Telerik Report Helper
namespace UI.Helpers
{
using System;
using System.Collections;
using System.Collections.Generic;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Text;
using Telerik.Reporting.Processing;
@janosorcsik
janosorcsik / UnitTestHelper.cs
Last active December 11, 2017 21:34
Unit test helper
namespace UnitTest.Helpers
{
using System;
using System.Collections;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
public static class UnitTestHelper
{
@janosorcsik
janosorcsik / id.js
Last active March 6, 2019 09:20
Search duplicated ids
$('[id]').each(function() {
var ids = $("[id='" + this.id + "']")
if (ids.length > 1 && ids[0] == this) console.warn('Multiple IDs# ' + this.id)
});