forenheith’s gists

forenheith / gist:910b22ca833c1e3453b32e053d287f9f

Created February 3, 2021 18:58

	` using (var outStream = new MemoryStream())
	{
	var zipOutputStream = new ZipOutputStream(outStream);
	await outStream.FlushAsync(cancellationToken);
	outStream.Seek(0, SeekOrigin.Begin);
	zipOutputStream.SetLevel(CompressionMax);
	foreach (var file in files)
	{
	using (var inStream = new MemoryStream())
	{

forenheith / example2

Created April 7, 2020 16:56

	<div>
	<div class="auth0-lock-input-block auth0-lock-input-email">
	<div class="auth0-lock-input-wrap auth0-lock-input-wrap-with-icon">
	<span aria-hidden="true">
	<svg aria-hidden="true" focusable="false" width="14px" height="13px" viewBox="0 0 32 26" version="1.1"
	xmlns="http://www.w3.org/2000/svg"
	xmlns:xlink="http://www.w3.org/1999/xlink"
	xmlns:sketch="http://www.bohemiancoding.com/sketch/ns" class="auth0-lock-icon auth0-lock-icon-box">
	<g id="Page-1" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd" sketch:type="MSPage">
	<g id="32px" sketch:type="MSLayerGroup" transform="translate(-2155.000000, -2317.000000)" fill="#373A39">

forenheith / example

Created April 7, 2020 16:52


	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
	<meta http-equiv="Cache-Control" content="no-cache, no-store, must-revalidate"/>
	<meta http-equiv="Pragma" content="no-cache"/>
	<meta http-equiv="Expires" content="0"/>
	<title>Sign In with Auth0</title>

forenheith / AddTermsOfConditionsCheckboxToAuth0LoginPage

Last active March 26, 2020 16:23

	<html>
	<body>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
	<script src="https://cdn.jsdelivr.net/npm/js-cookie@rc/dist/js.cookie.min.js"></script>
	<script>
	function onCheckTermsOfConditions(checked) {
	$('.auth0-lock-submit').prop('disabled', !checked);
	document.cookie = "signin_toc_agree=" + checked;
	}

forenheith / gist:dea27366d22916a59f1751406a38933c

Created February 10, 2020 12:15

123123123

	let
	Источник = Sql.Database("192.168.2.56", "triovisttrade"),
	dbo_OrdersFRAN2 = Источник{[Schema="dbo",Item="OrdersFRAN2"]}[Data],
	#"Измененный тип" = Table.TransformColumnTypes(dbo_OrdersFRAN2,{{"Date", type date}}),
	#"Строки с примененным фильтром" = Table.SelectRows(#"Измененный тип", each [Date] >= DateTime.Date(Date.AddYears(Date.StartOfYear(DateTime.LocalNow()), -1))),
	#"Строки с примененным фильтром1" = Table.SelectRows(#"Строки с примененным фильтром", each ([Canceled] = true) and ([Posted] = true)),
	#"Условный столбец добавлен" = Table.AddColumn(#"Строки с примененным фильтром1", "AddFranREF", each if Text.Contains([AddInfo], "фран") then true else if Text.Contains([AddInfo], "реф") then true else false),
	#"Строки с примененным фильтром2" = Table.SelectRows(#"Условный столбец добавлен", each ([AddFranREF] = true)),
	#"Другие удаленные столбцы" = Table.SelectColumns(#"Строки с примененным фильтром2",{"Id", "Date", "TotalAmount", "PaymentMethod", "TypeCard", "AddInfo", "I

forenheith / gist:fd688d6eef58573672949ac8db6869ea

Created February 10, 2020 10:50

Power Bi TableTest

	Источник = Table.NestedJoin(OrdersFRAN, {"AddInfo"}, PartnerCodeAll, {"CodePromo"}, "PartnerCodeAll", JoinKind.FullOuter),
	#"Развернутый элемент PartnerCodeAll" = Table.ExpandTableColumn(Источник, "PartnerCodeAll", {"NamePartners", "CodePromo"}, {"NamePartners", "CodePromo"}),
	#"Объединенные запросы" = Table.NestedJoin(#"Развернутый элемент PartnerCodeAll", {"AddInfo"}, NoCode, {"NoAddInfo"}, "NoCode", JoinKind.FullOuter),
	#"Развернутый элемент NoCode" = Table.ExpandTableColumn(#"Объединенные запросы", "NoCode", {"NoAddInfo"}, {"NoAddInfo"}),
	#"Текст в нижнем регистре" = Table.TransformColumns(#"Развернутый элемент NoCode",{{"AddInfo", Text.Lower, type text}, {"CodePromo", Text.Lower, type text}, {"NoAddInfo", Text.Lower, type text}}),
	#"Замененное значение" = Table.ReplaceValue(#"Текст в нижнем регистре",null,"",Replacer.ReplaceValue,{"Id", "DeliveryDate", "AddInfo", "IsDeleted", "AddFranRef", "NamePartners", "CodePromo", "NoAddInfo"}),
	#"Буфер" = List.Buffer(List.Select(Table.Column(

forenheith / vctmp11808_516225.XElementExtensions.4c79df50.cs

Created January 14, 2019 09:11

	public static AtcPermission GetATCPermission(this XElement element, XName name)
	{
	var childElement = element.Attribute(name);
	if (childElement == null) return AtcPermission.Board;
	switch (childElement.Value)
	{
	case "N": return AtcPermission.NoBoard;
	default: return AtcPermission.Board;
	}
	}

forenheith / insert

Created November 9, 2017 13:34

+create
+	procedure informix.rg_ins_qry_issue(
+		sql_id int8,
+		sql_address int8,
+		sql_sid int,
+		sql_uid int,
+		sql_stmttype int,
+		sql_stmtname char(40),
+		sql_finishtime int,
+		sql_begintxtime int,

forenheith / gist:303ec6e0827f2b7f938e097a27e541b3

Created June 1, 2017 06:46

filter

	ticketsViewModelsCollection =
	ticketsRepo.GetAll()
	.Where(
	m =>
	(m.TicketStateId == null \|\| m.TicketStateId == model.StateId)
	&& model.Direction == TicketDirection.In
	? model.EmployeeId == null
	? m.RecipientId == model.DepartmentId
	: m.RecipientId == model.EmployeeId
	: model.EmployeeId == null

forenheith / gist:41dfd8dba05511ab9914b0da3cd48de1

Created June 1, 2017 06:22

ex

	public ICollection<TicketViewModel> GetTicketsCollection(TicketFilterViewModel model)
	{
	List<TicketViewModel> ticketsViewModelsCollection;
	using (var ticketsRepo = this.RepoFactory.GetTicketsRepository())
	{
	if (model.EmployeeId == null)
	{
	/* get departments tickets*/
	ticketsViewModelsCollection = ticketsRepo.GetAll(
	m => model.Direction == TicketDirection.In