This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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"}, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
devenv /AllowDuringSetup |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!--<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> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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, ',') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
=HOUR(D3-C3)+(MINUTE(D3-C3)/60) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
في مسارات كل مدينة جرب ضيفو عالداتا بيز | |
بتوقع بتشتغل فور |
OlderNewer