muratsaygili

DECLARE @Id UNIQUEIDENTIFIER = '2d586358-5f12-4a4f-8909-c4db933fd748';
DECLARE @Provider NVARCHAR(50) = 'TourVisio';
DECLARE @ParentId UNIQUEIDENTIFIER = '1a79d357-83fe-4c4d-97d7-99ee9927862a';
DECLARE @Market NVARCHAR(50) = 'BIH';
DECLARE @Agency NVARCHAR(50) = 'AVIO';
DECLARE @AgencyUser NVARCHAR(50) = 'AIDA';
DECLARE @ProductType NVARCHAR(50) = '3';
DECLARE @ExpireDate DATETIME = GETDATE();
DECLARE @CreateDate DATETIME = GETDATE();
DECLARE @Data NVARCHAR(MAX) = '{"ResMain":{"RefNo":1,"ResNo":"be253347-3","Market":"BIH","Operator":"AVIOEXPRES","Office":"AVIO","PLOperator":"AVIOEXPRES","PLMarket":"BIH","Agency":"AVIO","AgencyUser":"AIDA","ResDate":"2024-08-15T00:00:00","ResTime":"2024-08-15T14:26:19","ResLock":0,"SaleResource":1,"DepCity":6,"ArrCity":2,"BegDate":"2024-09-27T00:00:00","EndDate":"2024-09-27T00:00:00","Days":0,"PriceSource":0,"Adult":1,"Child":0,"ResNote":"","ResStat":0,"ConfStat":1,"PaymentStat":"U","EBPasChk":0,"EBAgencyChk":0,"PLSpoChk":0,"AllowDocPrint":"N","InvoiceTo":0,"ConfToAgency":"N",

muratsaygili

public static class StringExtensions
    {
        private static readonly Regex HtmlRegex = new Regex("<.*?>", RegexOptions.Compiled);

        public static string TinyHtmlContent(this string value, int charCount)
        {
            if (string.IsNullOrEmpty(value)) return "";

            var clean = HtmlRegex.Replace(value, string.Empty);//removes html tags from string

muratsaygili

[
  {
    "Kod": "101",
    "Aciklama": "İhracat İstisnası",
    "VergiTipi": "OTV",
    "IstisnaTipi": "null"
  },
  {
    "Kod": "102",
    "Aciklama": "Diplomatik İstisna",

muratsaygili

[
  {
    "Kod": "601",
    "Aciklama": "YAPIM İŞLERİ İLE BU İŞLERLE BİRLİKTE İFA EDİLEN MÜHENDİSLİKMİMARLIK VE ETÜT-PROJE HİZMETLERİ [GT 117-Bölüm (3.2.1)]",
    "Kisaltma": "4/10",
    "Tip": "Tevkifat",
    "Oran": 40
  },
  {
    "Kod": "602",

muratsaygili

SET NAMES utf8;

DROP TABLE IF EXISTS `cc_bins`;
CREATE TABLE `cc_bins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bank_code` int(11) NOT NULL,
  `bank_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bin_number` int(11) NOT NULL,
  `card_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,