Skip to content

Instantly share code, notes, and snippets.

View alaawahbah's full-sized avatar

Alaa Wahbah alaawahbah

View GitHub Profile
private static IDictionary<string, string> _mappings = new Dictionary<string, string>(StringComparer.InvariantCultureIgnoreCase) {
#region Big freaking list of mime types
// combination of values from Windows 7 Registry and
// from C:\Windows\System32\inetsrv\config\applicationHost.config
// some added, including .7z and .dat
{".323", "text/h323"},
{".3g2", "video/3gpp2"},
{".3gp", "video/3gpp"},
{".3gp2", "video/3gpp2"},
@alaawahbah
alaawahbah / 1
Last active March 13, 2018 09:51
Fix: Visual Studio – “Cannot run when setup is in progress”
devenv /AllowDuringSetup
declare @list varchar(MAX), @i int
select @i=0, @list ='4,7,12,22,19,'
while( @i < LEN(@list))
begin
declare @item varchar(MAX)
SELECT @item = SUBSTRING(@list, @i,CHARINDEX(',',@list,@i)-@i)
select @item
<!--<li *ngFor="let responsible of ResponsibleGroup; let i = index" formArrayName="ResponsibleGroup">-->
<li *ngFor="let responsible of employeeSettingsForm.controls.ResponsibleGroup.controls; let i = index">
<label class="form-check-label">
<input class="form-check-input" value="{{responsible.ID}}" type="checkbox" (change)="Changed($event)">
<span class="btn btn-light btn-round btn-sm">{{isArabic?responsible.NameAr:responsible.NameEn}}<i class="fas fa-plus"></i></span>
</label>
</li>
import { MatButtonModule, MatCheckboxModule, MatOptionModule, MatProgressSpinnerModule, MatChipsModule, MatAutocompleteModule } from '@angular/material';
import { MatCardModule } from '@angular/material/card';
import { MatToolbarModule } from '@angular/material/toolbar';
import { MatIconModule } from '@angular/material/icon';
import { MatSidenavModule } from '@angular/material/sidenav';
import { MatListModule } from '@angular/material/list';
import { MatDividerModule } from '@angular/material/divider';
import { MatTabsModule } from '@angular/material/tabs';
import { MatGridListModule } from '@angular/material/grid-list';
import { MatInputModule } from '@angular/material/input';
DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR
SET @Cursor = CURSOR FAST_FORWARD FOR
SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_SCHEMA + '].[' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + '];'
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME
OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql
WHILE (@@FETCH_STATUS = 0)
-- SELECT * FROM Filters WHERE JSON_VALUE(FilterParameters, '$.Name') = N'PaymentType'
SELECT * FROM Filters f CROSS APPLY OPENJSON (FilterParameters) with (
[name] VARCHAR(Max),
[value] VARCHAR(Max)) j
--where j.name = 'PaymentType'
--WHERE JSON_VALUE(FilterParameters, '$.Name') = N'PaymentType'
select * from Ads CROSS APPLY STRING_SPLIT(CategoryPath, ',')
553
Given an array you can use the Array.ConvertAll method:
int[] myInts = Array.ConvertAll(arr, s => int.Parse(s));
Thanks to Marc Gravell for pointing out that the lambda can be omitted, yielding a shorter version shown below:
int[] myInts = Array.ConvertAll(arr, int.Parse);
A LINQ solution is similar, except you would need the extra ToArray call to get an array:
=HOUR(D3-C3)+(MINUTE(D3-C3)/60)
https://simplemaps.com/custom/country#code
simplemaps.comsimplemaps.com
Customizable Country Map Tool | Simplemaps.com
A tool to easily customize an HTML5 Country map quickly using an Excel-like interface. Add locations, popups, colors, links, labels and more.
شوف هاد اللينك
في تحت Advanced
جواتا في اوبجيكت paths
في مسارات كل مدينة جرب ضيفو عالداتا بيز
بتوقع بتشتغل فور