Skip to content

Instantly share code, notes, and snippets.

@rec4i

rec4i/E-Logo-Entegrasyon.aspx

Created March 1, 2022 21:39
Show Gist options
  • Save rec4i/ef4f25f4b956f77ce5a3b1d824bc2f9b to your computer and use it in GitHub Desktop.
Save rec4i/ef4f25f4b956f77ce5a3b1d824bc2f9b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
E-Logo-Entegrasyon.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Desk.Master" AutoEventWireup="true" CodeBehind="E-Logo-Entegrasyon.aspx.cs" Inherits="F5_Yazilim_Hasta_Takip.E_Logo_Entegrasyon" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
<script src="Scripts/jquery.xslt.js"></script>
<script src="Scripts/xslt.js"></script>
<link href="https://unpkg.com/bootstrap-table@1.19.1/dist/bootstrap-table.min.css" rel="stylesheet">
<script src="https://unpkg.com/bootstrap-table@1.19.1/dist/bootstrap-table.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
var TextBox1 = $('input[id*=Bas_Tar]')
var TextBox2 = $('input[id*=Bit_Tar]')
var Today = new Date();
function formatDate(date) {
var d = new Date(date),
month = '' + (d.getMonth() + 1),
day = '' + (d.getDate()),
year = d.getFullYear();
if (month.length < 2)
month = '0' + month;
if (day.length < 2)
day = '0' + day;
return [year, month, day].join('-');
}
var x = new Date(Today);
var d = new Date(x.getFullYear(), x.getMonth(), x.getDate());
TextBox1.attr('value', formatDate(d));
var d = new Date(x.getFullYear(), x.getMonth(), x.getDate() + 1);
TextBox2.attr('value', formatDate(d));
//function loadXMLDoc(filename) {
// if (window.ActiveXObject) {
// xhttp = new ActiveXObject("Msxml2.XMLHTTP");
// }
// else {
// xhttp = new XMLHttpRequest();
// }
// xhttp.open("GET", filename, false);
// try { xhttp.responseType = "msxml-document" } catch (err) { } // Helping IE11
// xhttp.send("");
// return xhttp.responseXML;
//}
//function displayResult() {
// xml = loadXMLDoc("cdcatalog.xml");
// xsl = loadXMLDoc("cdcatalog_client.xsl");
// // code for IE
// if (window.ActiveXObject || xhttp.responseType == "msxml-document") {
// ex = xml.transformNode(xsl);
// document.getElementById("example").innerHTML = ex;
// }
// // code for Chrome, Firefox, Opera, etc.
// else if (document.implementation && document.implementation.createDocument) {
// xsltProcessor = new XSLTProcessor();
// xsltProcessor.importStylesheet(xsl);
// resultDocument = xsltProcessor.transformToFragment(xml, document);
// document.getElementById("example").appendChild(resultDocument);
// }
//}
var $table_Taslaklar = $('#Taslaklar_Table')
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
function buildTable_Taslaklar($el, cells, rows, Hasta_Id) {
var i; var j; var row
var columns = [];
var data__ = [];
columns.push({
checkbox: true,
})
columns.push({
field: 'Makbuz_ID',
title: 'Makbuz_ID',
sortable: true
})
columns.push({
field: 'Oluşturulma_Tarihi',
title: 'Oluşturulma Tarihi',
sortable: true
})
columns.push({
field: 'Makbuz_No',
title: 'Makbuz No',
sortable: true
})
columns.push({
field: 'Makbuz_Tarihi',
title: 'Makbuz Tarihi',
sortable: true
})
columns.push({
field: 'Alıcı_Ünvan',
title: 'Alıcı Ünvan',
values: 'asd',
sortable: true
})
columns.push({
field: 'Durum',
title: 'Durum',
values: 'asd',
sortable: true
})
columns.push({
field: 'Makbuz_ETTN',
title: 'Makbuz ETTN',
values: 'asd',
sortable: true
})
columns.push({
field: 'Durum_Açıklaması',
title: 'Durum Açıklaması',
values: 'asd',
sortable: true
})
columns.push({
field: 'Firma_Id',
title: 'Firma_Id',
values: 'asd',
sortable: true
})
columns.push({
field: 'Görüntüle',
title: 'Görüntüle',
values: 'asd',
sortable: true
})
columns.push({
field: 'Sil',
title: 'Sil',
values: 'asd',
sortable: true
})
columns.push({
field: 'Belge_Notu',
title: 'Belge_Notu',
values: 'asd',
sortable: true
})
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Taslak_Belge_Getir ") %>',
type: 'POST',
async: false,
dataType: "json",
data: "{" +
"'Bas_Tar':'" + $('input[id=Bas_Tar]').val() + "'," +
"'Bit_Tar':'" + $('input[id=Bit_Tar]').val() + "'" +
"}",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
console.log(temp)
//$('#Biyoloji_Tetkik_Başlık_select').empty();
for (var i = 0; i < temp.length; i++) {
//$('#Biyoloji_Tetkik_Başlık_select').append('<option value="' + temp[i].Tekik_ID + '">' + temp[i].Tekik_Txt + '</option>')
}
for (i = 0; i < temp.length; i++) {
row = {}
row['Makbuz_ID'] = temp[i].ID
row['Oluşturulma_Tarihi'] = temp[i].Belge_Olusturlma_Tar
row['Makbuz_No'] = temp[i].Belge_No
row['Makbuz_Tarihi'] = temp[i].Belge_Olusturlma_Tar
row['Alıcı_Ünvan'] = temp[i].Alıcı_Adı_Soyadı
row['Durum'] = temp[i].Durum_Txt
row['Makbuz_ETTN'] = temp[i].Belge_ETTN
row['Makbuz_Tarihi'] = temp[i].Belge_Tarihi
row['Durum_Açıklaması'] = temp[i].Belge_Durum_Notu
row['Firma_Id'] = temp[i].Firma_Id
row['Belge_Notu'] = temp[i].Belge_Notu == null ? "" : temp[i].Belge_Notu
//row['Makbuz_ETTN'] = temp[i].İndirimli_Tutar
//row['Ödeme_Al'] = '<button class="btn btn-secondary btn-sm" ' + disabled + ' İşlem_Tutarı="' + temp[i].Toplam_İşlem_Tutarı + '" Cari_Borç="' + temp[i].Toplam_Cari_Ödeme + '" Hesap_Genel_Id="' + temp[i].Hesap_Genel_Id + '" id="Ödeme_AL_Button" style="word-break: keep-all;">Görüntüle</button>'
row['Görüntüle'] = '<button class="btn btn-warning btn-sm" E_SMM_ID="' + temp[i].ID + '" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i> Görüntüle</button>'
row['Sil'] = '<button class="btn btn-danger btn-sm" E_SMM_ID="' + temp[i].ID + '" id="Sil" style="word-break: keep-all;"><i class="fa fa-trash "></i> Sil</button>'
data__.push(row)
}
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
$el.bootstrapTable('destroy')
$el.bootstrapTable({
columns: columns,
data: data__,
clickToSelect: true,
detailView: cells >= 1,
onExpandRow: function (index, row, $detail) {
expandTable_Taslaklar($detail, row)
},
})
$el.bootstrapTable('hideColumn', 'Makbuz_ID')
$el.bootstrapTable('hideColumn', 'Firma_Id')
$el.bootstrapTable('hideColumn', 'Belge_Notu')
//JSON.stringify($table_Taslaklar.bootstrapTable('getSelections'))
$('button[id=Sil]').click(function () {
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Taslak_Sil") %>',
type: 'POST',
async: false,
dataType: "json",
data: "{" +
"'Belge_Id':'" + $(this).attr('E_SMM_ID') + "'" +
"}",
contentType: "application/json; charset=utf-8",
success: function (data) {
Swal.fire({
title: 'Başarılı!',
text: 'İşlem Başarı İle Kaydedildi',
icon: 'success',
confirmButtonText: 'Kapat'
})
var $table_Taslaklar = $('#Taslaklar_Table')
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Gönderime_Hazır_Table')
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Taslaklar_Table_Gönderilen')
buildTable_Taslaklar_Table_Gönderilen($table_Gönderilen_Hazır, 1, 1, 1)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
})
$('button[id=Görüntüle]').click(function () {
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Tasarım_Getir") %>',
type: 'POST',
async: false,
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
console.log(temp)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
var xmlDoc;
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Deneme_Olustur") %>',
type: 'POST',
async: false,
data: "{" +
"'E_SMM_ID':'" + $(this).attr('E_SMM_ID') + "'" +
"}",
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var xml = data.d;
xmlDoc = new DOMParser().parseFromString(xml, "application/xml");
console.log(xmlDoc)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
function loadXMLDoc(filename) {
if (window.ActiveXObject) {
xhttp = new ActiveXObject("Msxml2.XMLHTTP");
} else {
xhttp = new XMLHttpRequest();
}
xhttp.open("GET", filename, false);
xhttp.send("");
return xhttp.responseXML;
}
xsl = loadXMLDoc("e-Serbest Meslek Makbuz Öndeğer Şablon Tasarım.xslt");
if (document.implementation && document.implementation.createDocument) {
xsltProcessor = new XSLTProcessor();
xsltProcessor.importStylesheet(xsl);
resultDocument = xsltProcessor.transformToFragment(xmlDoc, document);
var $iframe = $('#deneme');
$iframe.ready(function () {
$iframe.contents().find("body").empty()
$iframe.contents().find("body").append(xmlToString(resultDocument));
});
function xmlToString(xmlData) {
var xmlString;
//IE
if (window.ActiveXObject) {
xmlString = xmlData.xml;
}
// code for Mozilla, Firefox, Opera, etc.
else {
xmlString = (new XMLSerializer()).serializeToString(xmlData);
}
return xmlString;
}
//var body = xmlToString(resultDocument);
//var newWin = document.getElementById('deneme').contentWindow;
//newWin.document.write(body);
//newWin.document.close(); //important!
//newWin.focus(); //IE fix
//newWin.print();
$('#Görüntüle_Modal').modal('show')
}
})
}
function expandTable_Taslaklar($detail, row) {
console.log(row)
//var variable = $('#expandTable_Taslaklar').html();
var Makbuz_Id = $($.parseHTML(row['Makbuz_ID']))[0].data
var Firma_Id = $($.parseHTML(row['Firma_Id']))[0].data
var Makbuz_Tarihi = $($.parseHTML(row['Makbuz_Tarihi']))[0].data
var Belge_Notu = $($.parseHTML(row['Belge_Notu']))[0]
var Belge_Firma_Html = '' +
'<div class="row">' +
' <div class="col-md-12">' +
' <div class="row">' +
' <div class="col-md-12">' +
' <div class="card card-danger">' +
' <div class="card-header">' +
' <h3 class="card-title">Firma</h3>' +
'' +
' <div class="card-tools">' +
' <button type="button" class="btn btn-tool" data-card-widget="maximize">' +
' <i class="fas fa-expand"></i>' +
' </button>' +
' <button type="button" class="btn btn-tool" data-card-widget="collapse">' +
' <i class="fas fa-minus"></i>' +
' </button>' +
' </div>' +
' </div>' +
' <div class="card-body">' +
' <div class="row">' +
' <div class="col-md-12">' +
' <div class="form-group">' +
' <label>Firma Adı :</label>' +
' <select id="Firma_Adı_' + Makbuz_Id+'" class="form-control form-control-sm">' +
' </select>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
' <div class="card-footer ">' +
' <button type="button" id="Firma_Adı_Kaydet_' + Makbuz_Id+'" Firma_Id="' + Makbuz_Id+'" class="btn btn-warning pull-right">Kaydet</button>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
'';
var Belge_Tarihi_html = '' +
' <div class="row">' +
' <div class="col-md-12">' +
' <div class="row">' +
' <div class="col-md-12">' +
' <div class="card card-danger">' +
' <div class="card-header">' +
' <h3 class="card-title">Belge Tarihi</h3>' +
' <div class="card-tools">' +
' <button type="button" class="btn btn-tool" data-card-widget="maximize">' +
' <i class="fas fa-expand"></i>' +
' </button>' +
' <button type="button" class="btn btn-tool" data-card-widget="collapse">' +
' <i class="fas fa-minus"></i>' +
' </button>' +
' </div>' +
' </div>' +
' <div class="card-body">' +
' <div class="row">' +
' <div class="col-md-12">' +
' <input type="datetime-local" class="form-control" id="Belge_Tarihi_İnput_' + Makbuz_Id+'" value="" />' +
' </div>' +
' </div>' +
' </div>' +
' <div class="card-footer">' +
' <button type="button" id="Belge_Tarihi_Kaydet_' + Makbuz_Id+'" Firma_Id="' + Makbuz_Id+'" class="btn btn-warning pull-right">Kaydet</button>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
'';
var Belge_Notu_Html = '' +
'<div class="row">' +
' <div class="col-md-12">' +
' <div class="row">' +
' <div class="col-md-12">' +
' <div class="card card-danger">' +
' <div class="card-header">' +
' <h3 class="card-title">Belge Notu</h3>' +
'' +
' <div class="card-tools">' +
' <button type="button" class="btn btn-tool" data-card-widget="maximize">' +
' <i class="fas fa-expand"></i>' +
' </button>' +
' <button type="button" class="btn btn-tool" data-card-widget="collapse">' +
' <i class="fas fa-minus"></i>' +
' </button>' +
' </div>' +
' </div>' +
' <div class="card-body">' +
' <div class="row">' +
' <div class="col-md-12">' +
' <textarea class="form-control" id="Belge_Notu_Textarea_' + Makbuz_Id+'" rows="4" value="' + Belge_Notu + '"></textarea>' +
' </div>' +
' </div>' +
' </div>' +
' <div class="card-footer ">' +
' <button type="button" id="Belge_Notu_Kaydet_' + Makbuz_Id + '" Firma_Id="' + Makbuz_Id+'" class="btn btn-warning pull-right">Kaydet</button>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
' </div>' +
'';
$detail.append(Belge_Firma_Html)
$detail.append(Belge_Tarihi_html)
$detail.append(Belge_Notu_Html)
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Firmaları_Getir") %>',
type: 'POST',
async: false,
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
$('#Firma_Adı_' + Makbuz_Id).empty();
for (var i = 0; i < temp.length; i++) {
$('#Firma_Adı_' + Makbuz_Id).append('<option value="' + temp[i].ID + '">' + temp[i].Adı_Soyadı + '</option>')
}
$('#Firma_Adı_' + Makbuz_Id).val(Firma_Id)
},
error: function () {
Swal.fire({
title: 'Hata!',
text: 'Talep esnasında sorun oluştu.Yeniden deneyin',
icon: 'error',
confirmButtonText: 'Kapat'
})
}
});
var now = new Date();
now.setMinutes(now.getMinutes() - now.getTimezoneOffset());
var Makbuz_Tarihi_Yenilenmiş = Makbuz_Tarihi.split(' ')[0].split('.')[2] + '-' + Makbuz_Tarihi.split(' ')[0].split('.')[1] + '-' + Makbuz_Tarihi.split(' ')[0].split('.')[0] + 'T' + Makbuz_Tarihi.split(' ')[1].split(':')[0] + ':' + Makbuz_Tarihi.split(' ')[1].split(':')[1]
console.log(Makbuz_Tarihi_Yenilenmiş)
$('input[id="Belge_Tarihi_İnput_' + Makbuz_Id + '"]').val(Makbuz_Tarihi_Yenilenmiş)
console.log($('#Belge_Tarihi_İnput_' + Makbuz_Id).val().replaceAll('T', ' '))
$('#Belge_Notu_Kaydet_' + Makbuz_Id).click(function () {
console.log("sdsasdasd")
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Belge_Notu_Düzenle") %>',
type: 'POST',
async: false,
dataType: "json",
data: "{" +
"'Belge_Id':'" + Makbuz_Id + "'," +
"'Belge_Notu':'" + $('#Belge_Notu_Textarea_' + Makbuz_Id).val() + "'" +
"}",
contentType: "application/json; charset=utf-8",
success: function (data) {
Swal.fire({
title: 'Başarılı!',
text: 'İşlem Başarı İle Kaydedildi',
icon: 'success',
confirmButtonText: 'Kapat'
})
var $table_Taslaklar = $('#Taslaklar_Table')
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Gönderime_Hazır_Table')
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Taslaklar_Table_Gönderilen')
buildTable_Taslaklar_Table_Gönderilen($table_Gönderilen_Hazır, 1, 1, 1)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
})
$('#Firma_Adı_Kaydet_' + Makbuz_Id).click(function () {
console.log()
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Belge_Firma_Değiştir") %>',
type: 'POST',
async: false,
dataType: "json",
data: "{" +
"'Belge_Id':'" + Makbuz_Id + "'," +
"'Firma_Id':'" + $('#Firma_Adı_' + Makbuz_Id).find('option:selected').val() + "'" +
"}",
contentType: "application/json; charset=utf-8",
success: function (data) {
Swal.fire({
title: 'Başarılı!',
text: 'İşlem Başarı İle Kaydedildi',
icon: 'success',
confirmButtonText: 'Kapat'
})
var $table_Taslaklar = $('#Taslaklar_Table')
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Gönderime_Hazır_Table')
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Taslaklar_Table_Gönderilen')
buildTable_Taslaklar_Table_Gönderilen($table_Gönderilen_Hazır, 1, 1, 1)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
})
$('#Belge_Tarihi_Kaydet_' + Makbuz_Id).click(function () {
console.log($('#Belge_Tarihi_İnput_' + Makbuz_Id).val())
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Belge_Tarihi_Değiştir") %>',
type: 'POST',
async: false,
dataType: "json",
data: "{" +
"'Belge_Id':'" + Makbuz_Id + "'," +
"'Belge_Tar':'" + $('#Belge_Tarihi_İnput_' + Makbuz_Id).val().replaceAll('T', ' ') + "'" +
"}",
contentType: "application/json; charset=utf-8",
success: function (data) {
Swal.fire({
title: 'Başarılı!',
text: 'İşlem Başarı İle Kaydedildi',
icon: 'success',
confirmButtonText: 'Kapat'
})
var $table_Taslaklar = $('#Taslaklar_Table')
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Gönderime_Hazır_Table')
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Taslaklar_Table_Gönderilen')
buildTable_Taslaklar_Table_Gönderilen($table_Gönderilen_Hazır, 1, 1, 1)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
})
}
$('#Listele').click(function () {
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
// console.log(JSON.stringify($table_Taslaklar.bootstrapTable('getSelections')))
})
$('#Taslak_Yazdır').click(function () {
let iframe = document.getElementById('deneme');
iframe.contentWindow.print();
})
$('#Gönderime_Hazır_Hale_Getir').click(function () {
var $table_Taslaklar = $('#Taslaklar_Table')
var gönderilecek_List = $table_Taslaklar.bootstrapTable('getSelections')
console.log(gönderilecek_List)
if (gönderilecek_List.length < 1) {
Swal.fire({
title: 'Hata!',
text: 'Lütfen Belge Seçiniz!',
icon: 'error',
confirmButtonText: 'Kapat'
})
}
else {
var kesin_Liste = [];
for (var i = 0; i < gönderilecek_List.length; i++) {
var x = {
Sıra_No_: i,
ID_: gönderilecek_List[i].Makbuz_ID
}
kesin_Liste.push(x)
}
console.log(kesin_Liste)
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Gönderime_Hazır_Yap") %>',
type: 'POST',
async: false,
data: "{" +
"'Idler': '{Deneme:" + JSON.stringify(kesin_Liste) + "}'" +
"}",
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
if (temp.length > 0) {
Swal.fire({
title: 'Hata!',
text: 'Lütfen Tarihleri Kontrol Ediniz!',
icon: 'error',
confirmButtonText: 'Kapat'
})
}
else {
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
Swal.fire({
title: 'Başarılı!',
text: 'İşlem Başarı İle Kaydedildi',
icon: 'success',
confirmButtonText: 'Kapat'
})
}
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
}
var $table_Taslaklar = $('#Taslaklar_Table')
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Gönderime_Hazır_Table')
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Taslaklar_Table_Gönderilen')
buildTable_Taslaklar_Table_Gönderilen($table_Gönderilen_Hazır, 1, 1, 1)
})
var $table_Gönderime_Hazır = $('#Gönderime_Hazır_Table')
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
function buildTable_Gönderime_Hazır($el, cells, rows, Hasta_Id) {
var i; var j; var row
var columns = [];
var data__ = [];
columns.push({
checkbox: true,
})
columns.push({
field: 'Makbuz_ID',
title: 'Makbuz_ID',
sortable: true
})
columns.push({
field: 'Oluşturulma_Tarihi',
title: 'Oluşturulma Tarihi',
sortable: true
})
columns.push({
field: 'Makbuz_No',
title: 'Makbuz No',
sortable: true
})
columns.push({
field: 'Makbuz_Tarihi',
title: 'Makbuz Tarihi',
sortable: true
})
columns.push({
field: 'Alıcı_Ünvan',
title: 'Alıcı Ünvan',
values: 'asd',
sortable: true
})
columns.push({
field: 'Durum',
title: 'Durum',
values: 'asd',
sortable: true
})
columns.push({
field: 'Makbuz_ETTN',
title: 'Makbuz ETTN',
values: 'asd',
sortable: true
})
columns.push({
field: 'Durum_Açıklaması',
title: 'Durum Açıklaması',
values: 'asd',
sortable: true
})
columns.push({
field: 'Görüntüle',
title: 'Görüntüle',
values: 'asd',
sortable: true
})
columns.push({
field: 'ETTN_Degistir',
title: 'ETTN Degistir',
values: 'asd',
sortable: true
})
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Gönderime_Hazır_Belge_Getir") %>',
type: 'POST',
async: false,
dataType: "json",
data: "{" +
"'Bas_Tar':'" + $('input[id=Bas_Tar_Gönderime_Hazır]').val() + "'," +
"'Bit_Tar':'" + $('input[id=Bit_Tar_Gönderime_Hazır]').val() + "'" +
"}",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
console.log(temp)
//$('#Biyoloji_Tetkik_Başlık_select').empty();
for (var i = 0; i < temp.length; i++) {
//$('#Biyoloji_Tetkik_Başlık_select').append('<option value="' + temp[i].Tekik_ID + '">' + temp[i].Tekik_Txt + '</option>')
}
for (i = 0; i < temp.length; i++) {
row = {}
row['Makbuz_ID'] = temp[i].ID
row['Oluşturulma_Tarihi'] = temp[i].Belge_Olusturlma_Tar
row['Makbuz_No'] = temp[i].Belge_No
row['Makbuz_Tarihi'] = temp[i].Belge_Olusturlma_Tar
row['Alıcı_Ünvan'] = temp[i].Alıcı_Adı_Soyadı
row['Durum'] = temp[i].Durum_Txt
row['Makbuz_ETTN'] = temp[i].Belge_ETTN
row['Makbuz_Tarihi'] = temp[i].Belge_Tarihi
row['Durum_Açıklaması'] = temp[i].Belge_Durum_Notu
//row['Makbuz_ETTN'] = temp[i].İndirimli_Tutar
//row['Ödeme_Al'] = '<button class="btn btn-secondary btn-sm" ' + disabled + ' İşlem_Tutarı="' + temp[i].Toplam_İşlem_Tutarı + '" Cari_Borç="' + temp[i].Toplam_Cari_Ödeme + '" Hesap_Genel_Id="' + temp[i].Hesap_Genel_Id + '" id="Ödeme_AL_Button" style="word-break: keep-all;">Görüntüle</button>'
row['Görüntüle'] = '<button class="btn btn-warning btn-sm" E_SMM_ID="' + temp[i].ID + '" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i> Görüntüle</button>'
row['ETTN_Degistir'] = '<button class="btn btn-secondary btn-sm" E_SMM_ID="' + temp[i].ID + '" id="ETTN_degistir" style="word-break: keep-all;"><i class="fa fa-file-text "></i> ETTN Değiştir</button>'
data__.push(row)
}
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
$el.bootstrapTable('destroy')
$el.bootstrapTable({
columns: columns,
data: data__,
clickToSelect: true,
})
$el.bootstrapTable('hideColumn', 'Makbuz_ID')
//JSON.stringify($table_Taslaklar.bootstrapTable('getSelections'))
$('button[id=ETTN_degistir]').click(function () {
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Belge_ETTN_Değiştir") %>',
type: 'POST',
async: false,
data: "{" +
"'Belge_Id':'" + $(this).attr('E_SMM_ID') + "'" +
"}",
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
Swal.fire({
title: 'Başarılı!',
text: 'İşlem Başarı İle Kaydedildi',
icon: 'success',
confirmButtonText: 'Kapat'
})
var $table_Taslaklar = $('#Taslaklar_Table')
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
})
$('button[id=Görüntüle]').click(function () {
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Tasarım_Getir") %>',
type: 'POST',
async: false,
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
console.log(temp)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
var xmlDoc;
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Deneme_Olustur") %>',
type: 'POST',
async: false,
data: "{" +
"'E_SMM_ID':'" + $(this).attr('E_SMM_ID') + "'" +
"}",
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var xml = data.d;
xmlDoc = new DOMParser().parseFromString(xml, "application/xml");
console.log(xmlDoc)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
function loadXMLDoc(filename) {
if (window.ActiveXObject) {
xhttp = new ActiveXObject("Msxml2.XMLHTTP");
} else {
xhttp = new XMLHttpRequest();
}
xhttp.open("GET", filename, false);
xhttp.send("");
return xhttp.responseXML;
}
xsl = loadXMLDoc("e-Serbest Meslek Makbuz Öndeğer Şablon Tasarım.xslt");
if (document.implementation && document.implementation.createDocument) {
xsltProcessor = new XSLTProcessor();
xsltProcessor.importStylesheet(xsl);
resultDocument = xsltProcessor.transformToFragment(xmlDoc, document);
var $iframe = $('#deneme');
$iframe.ready(function () {
$iframe.contents().find("body").empty()
$iframe.contents().find("body").append(xmlToString(resultDocument));
});
function xmlToString(xmlData) {
var xmlString;
//IE
if (window.ActiveXObject) {
xmlString = xmlData.xml;
}
// code for Mozilla, Firefox, Opera, etc.
else {
xmlString = (new XMLSerializer()).serializeToString(xmlData);
}
return xmlString;
}
//var body = xmlToString(resultDocument);
//var newWin = document.getElementById('deneme').contentWindow;
//newWin.document.write(body);
//newWin.document.close(); //important!
//newWin.focus(); //IE fix
//newWin.print();
$('#Görüntüle_Modal').modal('show')
}
})
}
$('#Listele_Gönderime_Hazır').click(function () {
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
})
function buildTable_Gönderime_Hazır_Progress_Bar($el, Items) {
var i; var j; var row
var columns = [];
var data__ = [];
columns.push({
checkbox: true,
})
columns.push({
field: 'Makbuz_ID',
title: 'Makbuz_ID',
sortable: true
})
columns.push({
field: 'Belge_No',
title: 'Belge No',
sortable: true
})
columns.push({
field: 'İşlem_Yürütülme_Durumu',
title: 'Durum',
sortable: true
})
columns.push({
field: 'İşlem_Sonucu',
title: 'İşlem Sonucu',
sortable: true
})
for (i = 0; i < Items.length; i++) {
console.log(i)
var variable = '' +
'<div class="progress">' +
' <div class="progress-bar" role="progressbar" aria-valuenow="0" aria-valuemin="0" aria-valuemax="100"></div>' +
' </div>' +
'';
row = {}
row['Makbuz_ID'] = Items[i].Makbuz_ID
row['İşlem_Yürütülme_Durumu'] = variable
row['İşlem_Sonucu'] = ""
row['Belge_No'] = Items[i].Makbuz_No
data__.push(row)
}
$el.bootstrapTable('destroy')
$el.bootstrapTable({
columns: columns,
data: data__,
clickToSelect: true,
})
$el.bootstrapTable('hideColumn', 'Makbuz_ID')
}
$('#Gönderime_Hazır_Hale_Getir_Gönderime_Hazır').click(function () {
var gönderilecek_List = $table_Gönderime_Hazır.bootstrapTable('getSelections')
$('#İşlem_Sırası_Modal').modal('show')
var $table_Gönderilecekler_List = $('#Gönderilen_Makbuzlar_Progress_Bar')
buildTable_Gönderime_Hazır_Progress_Bar($table_Gönderilecekler_List, gönderilecek_List)
var i = 0;
for (const elment of gönderilecek_List) {
var Makbuz_Idd = elment.Makbuz_ID
Gönder(Makbuz_Idd, i);
i++;
}
function Gönder(Makbuz_Idd, counter) {
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Belge_Gönder") %>',
type: 'POST',
async: true,
global: false,
data: "{" +
"'E_SMM_ID':'" + Makbuz_Idd + "'" +
"}",
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
console.log(x)
console.log(temp)
var variable = '' +
'<div class="progress">' +
' <div class="progress-bar" role="progressbar" style="width: 100%" aria-valuenow="100" aria-valuemin="0" aria-valuemax="100"></div>' +
' </div>' +
'';
$('#Gönderilen_Makbuzlar_Progress_Bar').bootstrapTable('updateCell', {
index: counter,
field: 'İşlem_Yürütülme_Durumu',
value: variable
})
$('#Gönderilen_Makbuzlar_Progress_Bar').bootstrapTable('updateCell', {
index: counter,
field: 'İşlem_Sonucu',
value: temp[0].Durum_Notu
})
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
}
var $table_Taslaklar = $('#Taslaklar_Table')
buildTable_Taslaklar($table_Taslaklar, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Gönderime_Hazır_Table')
buildTable_Gönderime_Hazır($table_Gönderime_Hazır, 1, 1, 1)
var $table_Gönderilen_Hazır = $('#Taslaklar_Table_Gönderilen')
buildTable_Taslaklar_Table_Gönderilen($table_Gönderilen_Hazır, 1, 1, 1)
})
$('#Listele_Gönderilen').click(function () {
var $table_Gönderilen_Hazır = $('#Taslaklar_Table_Gönderilen')
buildTable_Taslaklar_Table_Gönderilen($table_Gönderilen_Hazır, 1, 1, 1)
})
var $table_Gönderilen_Hazır = $('#Taslaklar_Table_Gönderilen')
buildTable_Taslaklar_Table_Gönderilen($table_Gönderilen_Hazır, 1, 1, 1)
function buildTable_Taslaklar_Table_Gönderilen($el, cells, rows, Hasta_Id) {
var i; var j; var row
var columns = [];
var data__ = [];
columns.push({
checkbox: true,
})
columns.push({
field: 'Makbuz_ID',
title: 'Makbuz_ID',
sortable: true
})
columns.push({
field: 'Oluşturulma_Tarihi',
title: 'Oluşturulma Tarihi',
sortable: true
})
columns.push({
field: 'Makbuz_No',
title: 'Makbuz No',
sortable: true
})
columns.push({
field: 'Makbuz_Tarihi',
title: 'Makbuz Tarihi',
sortable: true
})
columns.push({
field: 'Alıcı_Ünvan',
title: 'Alıcı Ünvan',
values: 'asd',
sortable: true
})
columns.push({
field: 'Durum',
title: 'Durum',
values: 'asd',
sortable: true
})
columns.push({
field: 'Makbuz_ETTN',
title: 'Makbuz ETTN',
values: 'asd',
sortable: true
})
columns.push({
field: 'Durum_Açıklaması',
title: 'Durum Açıklaması',
values: 'asd',
sortable: true
})
columns.push({
field: 'Görüntüle',
title: 'Görüntüle',
values: 'asd',
sortable: true
})
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Gönderilmiş_Belge_Getir") %>',
type: 'POST',
async: false,
dataType: "json",
data: "{" +
"'Bas_Tar':'" + $('input[id=Bas_Tar_Gönderilen]').val() + "'," +
"'Bit_Tar':'" + $('input[id=Bit_Tar_Gönderilen]').val() + "'" +
"}",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
console.log(temp)
//$('#Biyoloji_Tetkik_Başlık_select').empty();
for (var i = 0; i < temp.length; i++) {
//$('#Biyoloji_Tetkik_Başlık_select').append('<option value="' + temp[i].Tekik_ID + '">' + temp[i].Tekik_Txt + '</option>')
}
for (i = 0; i < temp.length; i++) {
row = {}
row['Makbuz_ID'] = temp[i].ID
row['Oluşturulma_Tarihi'] = temp[i].Belge_Olusturlma_Tar
row['Makbuz_No'] = temp[i].Belge_No
row['Makbuz_Tarihi'] = temp[i].Belge_Olusturlma_Tar
row['Alıcı_Ünvan'] = temp[i].Alıcı_Adı_Soyadı
row['Durum'] = temp[i].Durum_Txt
row['Makbuz_ETTN'] = temp[i].Belge_ETTN
row['Makbuz_Tarihi'] = temp[i].Belge_Tarihi
row['Durum_Açıklaması'] = temp[i].Belge_Durum_Notu
//row['Makbuz_ETTN'] = temp[i].İndirimli_Tutar
//row['Ödeme_Al'] = '<button class="btn btn-secondary btn-sm" ' + disabled + ' İşlem_Tutarı="' + temp[i].Toplam_İşlem_Tutarı + '" Cari_Borç="' + temp[i].Toplam_Cari_Ödeme + '" Hesap_Genel_Id="' + temp[i].Hesap_Genel_Id + '" id="Ödeme_AL_Button" style="word-break: keep-all;">Görüntüle</button>'
row['Görüntüle'] = '<button class="btn btn-warning btn-sm" E_SMM_ID="' + temp[i].ID + '" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i> Görüntüle</button>'
data__.push(row)
}
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
$el.bootstrapTable('destroy')
$el.bootstrapTable({
columns: columns,
data: data__,
})
$el.bootstrapTable('hideColumn', 'Makbuz_ID')
//JSON.stringify($table_Taslaklar.bootstrapTable('getSelections'))
$('button[id=Görüntüle]').click(function () {
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Tasarım_Getir") %>',
type: 'POST',
async: false,
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var temp = JSON.parse(data.d)
console.log(temp)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
var xmlDoc;
$.ajax({
url: '<%= ResolveUrl("E-Logo-Entegrasyon.aspx/Deneme_Olustur") %>',
type: 'POST',
async: false,
data: "{" +
"'E_SMM_ID':'" + $(this).attr('E_SMM_ID') + "'" +
"}",
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
var xml = data.d;
xmlDoc = new DOMParser().parseFromString(xml, "application/xml");
console.log(xmlDoc)
},
error: function () {
alert('Talep esnasında sorun oluştu.Yeniden deneyin');
}
});
function loadXMLDoc(filename) {
if (window.ActiveXObject) {
xhttp = new ActiveXObject("Msxml2.XMLHTTP");
} else {
xhttp = new XMLHttpRequest();
}
xhttp.open("GET", filename, false);
xhttp.send("");
return xhttp.responseXML;
}
xsl = loadXMLDoc("e-Serbest Meslek Makbuz Öndeğer Şablon Tasarım.xslt");
if (document.implementation && document.implementation.createDocument) {
xsltProcessor = new XSLTProcessor();
xsltProcessor.importStylesheet(xsl);
resultDocument = xsltProcessor.transformToFragment(xmlDoc, document);
var $iframe = $('#deneme');
$iframe.ready(function () {
$iframe.contents().find("body").empty()
$iframe.contents().find("body").append(xmlToString(resultDocument));
});
function xmlToString(xmlData) {
var xmlString;
//IE
if (window.ActiveXObject) {
xmlString = xmlData.xml;
}
// code for Mozilla, Firefox, Opera, etc.
else {
xmlString = (new XMLSerializer()).serializeToString(xmlData);
}
return xmlString;
}
//var body = xmlToString(resultDocument);
//var newWin = document.getElementById('deneme').contentWindow;
//newWin.document.write(body);
//newWin.document.close(); //important!
//newWin.focus(); //IE fix
//newWin.print();
$('#Görüntüle_Modal').modal('show')
}
})
}
})
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="modal fade" id="İşlem_Sırası_Modal" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
<div class="modal-dialog modal-dialog-scrollable modal-xl" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="İşlem_Sırası_Modal_Başlık">Görüntüle</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
<div class="modal-body">
<div class="row">
<div class="col-md-12">
<table id="Gönderilen_Makbuzlar_Progress_Bar">
</table>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Kapat</button>
</div>
</div>
</div>
</div>
<div id="expandTable_Taslaklar" hidden>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-12">
<div class="card card-danger">
<div class="card-header">
<h3 class="card-title">Belge Notu</h3>
<div class="card-tools">
<button type="button" class="btn btn-tool" data-card-widget="maximize">
<i class="fas fa-expand"></i>
</button>
<button type="button" class="btn btn-tool" data-card-widget="collapse">
<i class="fas fa-minus"></i>
</button>
</div>
</div>
<div class="card-body">
<div class="row">
<div class="col-md-12">
<textarea class="form-control" id="Belge_Notu_Textarea" rows="4"></textarea>
</div>
</div>
</div>
<div class="card-footer ">
<button type="button" id="Belge_Notu_Kaydet" Firma_Id="0" class="btn btn-warning pull-right">Kaydet</button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="modal fade" id="Görüntüle_Modal" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
<div class="modal-dialog modal-dialog-scrollable modal-xl" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="Görüntüle_Modal_Başlık">Görüntüle</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
<div class="modal-body">
<div class="row" style="height: 1500px">
<iframe name="ifr" id="deneme" width="100%" height="100%" src=""></iframe>
</div>
<div id="Base64"></div>
<div id="container"></div>
</div>
<div class="modal-footer">
<button type="button" id="Taslak_Yazdır" class="btn btn-warning">Yazdır</button>
<button type="button" class="btn btn-secondary" data-dismiss="modal">Kapat</button>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-header p-2">
<ul class="nav nav-pills">
<li class="nav-item"><a class="nav-link active" href="#activity" data-toggle="tab">Taslaklar</a></li>
<li class="nav-item"><a class="nav-link" href="#timeline" data-toggle="tab">Gönderime Hazır</a></li>
<li class="nav-item"><a class="nav-link" href="#settings" data-toggle="tab">Gönderilen</a></li>
</ul>
</div>
<!-- /.card-header -->
<div class="card-body">
<div class="tab-content">
<div class="tab-pane active" id="activity">
<div class="row">
<div class="col-md-5">
<input type="date" id="Bas_Tar" class="form-control" value="Getir">
</div>
<div class="col-md-5">
<div class="form-group">
<input type="date" id="Bit_Tar" class="form-control" value="Getir">
</div>
</div>
<div class="col-md-2">
<input type="button" id="Listele" value="Getir" class="btn btn-block btn-secondary ">
</div>
</div>
<div class="row">
<%--<div class="col-md-4">
<button class="btn btn-warning btn-sm" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i> Görüntüle</button>
</div>--%>
<div class="col-md-12">
<button class="btn btn-block btn-primary" id="Gönderime_Hazır_Hale_Getir" style="word-break: keep-all;"><i class="fa fa-file-text "></i>&nbsp Seçili Olanları Gönderime Hazır Hale Getir</button>
</div>
<%--<div class="col-md-6">
<button class="btn btn-block btn-primary" id="Belge_No_Olustur" style="word-break: keep-all;"><i class="fa fa-file-text "></i>&nbsp Belge No Olustur</button>
</div>--%>
<%--<div class="col-md-4">
<button class="btn btn-warning btn-sm" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i></button>
</div>--%>
</div>
<div class="row" style="padding-top: 25px">
<div class="col-md-12">
<table id="Taslaklar_Table">
</table>
</div>
</div>
</div>
<!-- /.tab-pane -->
<div class="tab-pane" id="timeline">
<div class="row">
<div class="col-md-5">
<input type="date" id="Bas_Tar_Gönderime_Hazır" class="form-control" value="Getir">
</div>
<div class="col-md-5">
<div class="form-group">
<input type="date" id="Bit_Tar_Gönderime_Hazır" class="form-control" value="Getir">
</div>
</div>
<div class="col-md-2">
<input type="button" id="Listele_Gönderime_Hazır" value="Getir" class="btn btn-block btn-secondary ">
</div>
</div>
<div class="row">
<%--<div class="col-md-4">
<button class="btn btn-warning btn-sm" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i> Görüntüle</button>
</div>--%>
<div class="col-md-12">
<button class="btn btn-block btn-primary" id="Gönderime_Hazır_Hale_Getir_Gönderime_Hazır" style="word-break: keep-all;"><i class="fa fa-file-text "></i>&nbsp Seçili Olanları Gönder</button>
</div>
<%--<div class="col-md-6">
<button class="btn btn-block btn-primary" id="Belge_No_Olustur" style="word-break: keep-all;"><i class="fa fa-file-text "></i>&nbsp Belge No Olustur</button>
</div>--%>
<%--<div class="col-md-4">
<button class="btn btn-warning btn-sm" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i></button>
</div>--%>
</div>
<div class="row" style="padding-top: 25px">
<div class="col-md-12">
<table id="Gönderime_Hazır_Table">
</table>
</div>
</div>
</div>
<!-- /.tab-pane -->
<div class="tab-pane" id="settings">
<div class="row">
<div class="col-md-5">
<input type="date" id="Bas_Tar_Gönderilen" class="form-control" value="Getir">
</div>
<div class="col-md-5">
<div class="form-group">
<input type="date" id="Bit_Tar_Gönderilen" class="form-control" value="Getir">
</div>
</div>
<div class="col-md-2">
<input type="button" id="Listele_Gönderilen" value="Getir" class="btn btn-block btn-secondary ">
</div>
</div>
<div class="row">
<%--<div class="col-md-4">
<button class="btn btn-warning btn-sm" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i> Görüntüle</button>
</div>--%>
<%--<div class="col-md-6">
<button class="btn btn-block btn-primary" id="Belge_No_Olustur" style="word-break: keep-all;"><i class="fa fa-file-text "></i>&nbsp Belge No Olustur</button>
</div>--%>
<%--<div class="col-md-4">
<button class="btn btn-warning btn-sm" id="Görüntüle" style="word-break: keep-all;"><i class="fa fa-file-text "></i></button>
</div>--%>
</div>
<div class="row" style="padding-top: 25px">
<div class="col-md-12">
<table id="Taslaklar_Table_Gönderilen">
</table>
</div>
</div>
</div>
<!-- /.tab-pane -->
</div>
<!-- /.tab-content -->
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
</div>
</asp:Content>
Raw
E-Logo-Entegrasyon.aspx.cs
using Newtonsoft.Json;
using RestSharp;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.IO.Compression;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Xml.Serialization;
using F5_Yazilim_Hasta_Takip;
namespace F5_Yazilim_Hasta_Takip
{
public partial class E_Logo_Entegrasyon : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[System.Web.Services.WebMethod]
public static string Belge_Notu_Düzenle(string Belge_Id, string Belge_Notu)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"" +
"" +
"update E_Logo_SMM_Genel set Belge_Notu=@Belge_Notu where ID=@Belge_Id" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@Belge_Id", Belge_Id);
cmd.Parameters.AddWithValue("@Belge_Notu", Belge_Notu);
conn.Open();
List<Taslak_Belge_Getir_Tablo> tablo_Doldur_Classes = new List<Taslak_Belge_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Taslak_Belge_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Belge_Olusturlma_Tar = reader.GetValue(1).ToString(),
Belge_No = reader.GetValue(2).ToString(),
Alıcı_Adı_Soyadı = reader.GetValue(3).ToString(),
Durum_Txt = reader.GetValue(4).ToString(),
Belge_int = reader.GetValue(5).ToString(),
Belge_ETTN = reader.GetValue(6).ToString(),
Belge_Durum_Notu = reader.GetValue(7).ToString(),
Belge_Tarihi = reader.GetValue(8).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
[System.Web.Services.WebMethod]
public static string Belge_Tarihi_Değiştir(string Belge_Id, string Belge_Tar)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"" +
"" +
"update E_Logo_SMM_Genel set Belge_Tarihi=@Belge_Tar where ID=@Belge_Id" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@Belge_Id", Belge_Id);
cmd.Parameters.AddWithValue("@Belge_Tar", Belge_Tar);
conn.Open();
List<Taslak_Belge_Getir_Tablo> tablo_Doldur_Classes = new List<Taslak_Belge_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Taslak_Belge_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Belge_Olusturlma_Tar = reader.GetValue(1).ToString(),
Belge_No = reader.GetValue(2).ToString(),
Alıcı_Adı_Soyadı = reader.GetValue(3).ToString(),
Durum_Txt = reader.GetValue(4).ToString(),
Belge_int = reader.GetValue(5).ToString(),
Belge_ETTN = reader.GetValue(6).ToString(),
Belge_Durum_Notu = reader.GetValue(7).ToString(),
Belge_Tarihi = reader.GetValue(8).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
[System.Web.Services.WebMethod]
public static string Belge_ETTN_Değiştir(string Belge_Id)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"DECLARE @UNI UNIQUEIDENTIFIER; " +
" SET @UNI = NEWID(); " +
"" +
"update E_Logo_SMM_Genel set Belge_ETTN =@UNI where ID=@Belge_Id" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@Belge_Id", Belge_Id);
conn.Open();
List<Taslak_Belge_Getir_Tablo> tablo_Doldur_Classes = new List<Taslak_Belge_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Taslak_Belge_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Belge_Olusturlma_Tar = reader.GetValue(1).ToString(),
Belge_No = reader.GetValue(2).ToString(),
Alıcı_Adı_Soyadı = reader.GetValue(3).ToString(),
Durum_Txt = reader.GetValue(4).ToString(),
Belge_int = reader.GetValue(5).ToString(),
Belge_ETTN = reader.GetValue(6).ToString(),
Belge_Durum_Notu = reader.GetValue(7).ToString(),
Belge_Tarihi = reader.GetValue(8).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
[System.Web.Services.WebMethod]
public static string Taslak_Sil(string Belge_Id)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"" +
"" +
"update Hesap_Genel set Taslak_Olusturuldumu=0 where ID =(select Hesap_Genel_Id from E_Logo_SMM_Genel where ID=@Belge_Id) " +
"" +
" delete from E_Logo_SMM_Genel where ID=@Belge_Id " +
" delete from E_Logo_SMM_Detay where E_Logo_SMM_Genel_ID=@Belge_Id " +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@Belge_Id", Belge_Id);
conn.Open();
List<Taslak_Belge_Getir_Tablo> tablo_Doldur_Classes = new List<Taslak_Belge_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Taslak_Belge_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Belge_Olusturlma_Tar = reader.GetValue(1).ToString(),
Belge_No = reader.GetValue(2).ToString(),
Alıcı_Adı_Soyadı = reader.GetValue(3).ToString(),
Durum_Txt = reader.GetValue(4).ToString(),
Belge_int = reader.GetValue(5).ToString(),
Belge_ETTN = reader.GetValue(6).ToString(),
Belge_Durum_Notu = reader.GetValue(7).ToString(),
Belge_Tarihi = reader.GetValue(8).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
[System.Web.Services.WebMethod]
public static string Belge_Firma_Değiştir(string Belge_Id, string Firma_Id)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"" +
"" +
"update E_Logo_SMM_Genel set Firma_Id=@Firma_Id,Ön_Ek_Id=(select ID from Ön_Ekler where Otomatik_Seçilsin=1 and Firma_Id=@Firma_Id) where ID=@Belge_Id" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@Belge_Id", Belge_Id);
cmd.Parameters.AddWithValue("@Firma_Id", Firma_Id);
conn.Open();
List<Taslak_Belge_Getir_Tablo> tablo_Doldur_Classes = new List<Taslak_Belge_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Taslak_Belge_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Belge_Olusturlma_Tar = reader.GetValue(1).ToString(),
Belge_No = reader.GetValue(2).ToString(),
Alıcı_Adı_Soyadı = reader.GetValue(3).ToString(),
Durum_Txt = reader.GetValue(4).ToString(),
Belge_int = reader.GetValue(5).ToString(),
Belge_ETTN = reader.GetValue(6).ToString(),
Belge_Durum_Notu = reader.GetValue(7).ToString(),
Belge_Tarihi = reader.GetValue(8).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
public class Firmaları_Getir_Tablo
{
public string ID { get; set; }
public string Adı_Soyadı { get; set; }
}
[System.Web.Services.WebMethod]
public static string Firmaları_Getir()
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"" +
"select ID,Adı_Soyadı from Firmalar" +
"" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
conn.Open();
List<Firmaları_Getir_Tablo> tablo_Doldur_Classes = new List<Firmaları_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Firmaları_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Adı_Soyadı = reader.GetValue(1).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
public class Taslak_Belge_Getir_Tablo
{
public string ID { get; set; }
public string Belge_Olusturlma_Tar { get; set; }
public string Belge_No { get; set; }
public string Alıcı_Adı_Soyadı { get; set; }
public string Belge_int { get; set; }
public string Belge_ETTN { get; set; }
public string Belge_Durum_Notu { get; set; }
public string Durum_Txt { get; set; }
public string Belge_Tarihi { get; set; }
public string Firma_Id { get; set; }
public string Belge_Notu { get; set; }
}
[System.Web.Services.WebMethod]
public static string Taslak_Belge_Getir(string Bas_Tar, string Bit_Tar)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"select " +
"ID, " +
"Belge_Olusturlma_Tar, " +
"Belge_No, " +
"(select Hastanın_Adı+' '+Hastanın_Soyadı from Hastalar where Hasta_Id=Alıcı_Id) as Alıcı_Adı_Soyadı, " +
"(select Durum_Txt from E_Logo_SMM_Durumlar where ID=Belge_Durumu) as Durum_Txt, " +
"Belge_Durumu as Belge_int, " +
"Belge_ETTN, " +
"Belge_Durum_Notu,Belge_Tarihi,Firma_Id ,Belge_Notu " +
"from E_Logo_SMM_Genel where cast(Belge_Olusturlma_Tar as date) between @Bas_Tar and @Bit_Tar and Belge_Durumu in (0) " +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@Bas_Tar", Bas_Tar);
cmd.Parameters.AddWithValue("@Bit_Tar", Bit_Tar);
conn.Open();
List<Taslak_Belge_Getir_Tablo> tablo_Doldur_Classes = new List<Taslak_Belge_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Taslak_Belge_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Belge_Olusturlma_Tar = reader.GetValue(1).ToString(),
Belge_No = reader.GetValue(2).ToString(),
Alıcı_Adı_Soyadı = reader.GetValue(3).ToString(),
Durum_Txt = reader.GetValue(4).ToString(),
Belge_int = reader.GetValue(5).ToString(),
Belge_ETTN = reader.GetValue(6).ToString(),
Belge_Durum_Notu = reader.GetValue(7).ToString(),
Belge_Tarihi = reader.GetValue(8).ToString(),
Firma_Id= reader.GetValue(9).ToString(),
Belge_Notu= reader.GetValue(10).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
[System.Web.Services.WebMethod]
public static string Gönderime_Hazır_Belge_Getir(string Bas_Tar, string Bit_Tar)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"select " +
"ID, " +
"Belge_Olusturlma_Tar, " +
"Belge_No, " +
"(select Hastanın_Adı+' '+Hastanın_Soyadı from Hastalar where Hasta_Id=Alıcı_Id) as Alıcı_Adı_Soyadı, " +
"(select Durum_Txt from E_Logo_SMM_Durumlar where ID=Belge_Durumu) as Durum_Txt, " +
"Belge_Durumu as Belge_int, " +
"Belge_ETTN, " +
"Belge_Durum_Notu,Belge_Tarihi " +
"from E_Logo_SMM_Genel where cast(Belge_Olusturlma_Tar as date) between @Bas_Tar and @Bit_Tar and Belge_Durumu in (1) " +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@Bas_Tar", Bas_Tar);
cmd.Parameters.AddWithValue("@Bit_Tar", Bit_Tar);
conn.Open();
List<Taslak_Belge_Getir_Tablo> tablo_Doldur_Classes = new List<Taslak_Belge_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Taslak_Belge_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Belge_Olusturlma_Tar = reader.GetValue(1).ToString(),
Belge_No = reader.GetValue(2).ToString(),
Alıcı_Adı_Soyadı = reader.GetValue(3).ToString(),
Durum_Txt = reader.GetValue(4).ToString(),
Belge_int = reader.GetValue(5).ToString(),
Belge_ETTN = reader.GetValue(6).ToString(),
Belge_Durum_Notu = reader.GetValue(7).ToString(),
Belge_Tarihi = reader.GetValue(8).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
[System.Web.Services.WebMethod]
public static string Gönderilmiş_Belge_Getir(string Bas_Tar, string Bit_Tar)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = "" +
"select " +
"ID, " +
"Belge_Olusturlma_Tar, " +
"Belge_No, " +
"(select Hastanın_Adı+' '+Hastanın_Soyadı from Hastalar where Hasta_Id=Alıcı_Id) as Alıcı_Adı_Soyadı, " +
"(select Durum_Txt from E_Logo_SMM_Durumlar where ID=Belge_Durumu) as Durum_Txt, " +
"Belge_Durumu as Belge_int, " +
"Belge_ETTN, " +
"Belge_Durum_Notu,Belge_Tarihi " +
"from E_Logo_SMM_Genel where cast(Belge_Olusturlma_Tar as date) between @Bas_Tar and @Bit_Tar and Belge_Durumu in (2) " +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@Bas_Tar", Bas_Tar);
cmd.Parameters.AddWithValue("@Bit_Tar", Bit_Tar);
conn.Open();
List<Taslak_Belge_Getir_Tablo> tablo_Doldur_Classes = new List<Taslak_Belge_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Taslak_Belge_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Belge_Olusturlma_Tar = reader.GetValue(1).ToString(),
Belge_No = reader.GetValue(2).ToString(),
Alıcı_Adı_Soyadı = reader.GetValue(3).ToString(),
Durum_Txt = reader.GetValue(4).ToString(),
Belge_int = reader.GetValue(5).ToString(),
Belge_ETTN = reader.GetValue(6).ToString(),
Belge_Durum_Notu = reader.GetValue(7).ToString(),
Belge_Tarihi = reader.GetValue(8).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
[System.Web.Services.WebMethod]
public static string Gönderime_Hazır_Yap(string Idler)
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
DataSet dataSet = JsonConvert.DeserializeObject<DataSet>(Idler);
DataTable dataTable = dataSet.Tables["Deneme"];
var queryWithForJson = "" +
" declare @Sıralı_ID_ler table(Sıra_No_ int ,ID_ int);" +
"" +
"" +
"" +
" insert into @Sıralı_ID_ler select (select Sıra_No_ from @Gelen_Taslak_Idler where ID_=ID),ID from E_Logo_SMM_Genel where ID in (select ID_ from @Gelen_Taslak_Idler ) order by Belge_Tarihi asc" +
"" +
"" +
"" +
" declare @Gelen_En_Küçük_Tarih datetime=(select min(Belge_Tarihi) from E_Logo_SMM_Genel where ID in (select ID_ from @Sıralı_ID_ler))" +
"" +
"" +
"" +
"if exists (select * from E_Logo_SMM_Genel where Belge_Tarihi > @Gelen_En_Küçük_Tarih and Belge_Durumu = 1) " +
"begin ;" +
"select 0;" +
"end;" +
"else " +
"begin; " +
"DECLARE @cnt INT = 0; " +
"WHILE @cnt < (select COUNT(*) from @Sıralı_ID_ler) " +
"BEGIN " +
" update Ön_Ekler set Son_Numara=Son_Numara+1 where ID=(select ID from Ön_Ekler where ID = (select Ön_Ek_Id from E_Logo_SMM_Genel where ID=(select ID_ from @Sıralı_ID_ler where Sıra_No_ = @cnt)))" +
" update E_Logo_SMM_Genel set Belge_Durumu=1 , Belge_No=((select Ön_Ek from Ön_Ekler where ID = (select Ön_Ek_Id from E_Logo_SMM_Genel where ID=(select ID_ from @Sıralı_ID_ler where Sıra_No_ = @cnt))))+''+CAST(((select YIL from Ön_Ekler where ID = (select Ön_Ek_Id from E_Logo_SMM_Genel where ID=(select ID_ from @Sıralı_ID_ler where Sıra_No_ = @cnt)))) as nvarchar(max))+''+FORMAT((select Son_Numara from Ön_Ekler where ID = (select Ön_Ek_Id from E_Logo_SMM_Genel where ID=(select ID_ from @Sıralı_ID_ler where Sıra_No_ = @cnt))), '000000000;-000000000') where ID=(select ID_ from @Sıralı_ID_ler where Sıra_No_ = @cnt)" +
" SET @cnt = @cnt + 1; " +
"END; " +
"end; " +
"" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
SqlParameter tvpParam = cmd.Parameters.AddWithValue("@Gelen_Taslak_Idler", dataTable);
tvpParam.SqlDbType = SqlDbType.Structured;
tvpParam.TypeName = "dbo.Gelen_Taslak_Idler";
conn.Open();
List<Tasarım_Getir_Tablo> tablo_Doldur_Classes = new List<Tasarım_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Tasarım_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
public class Tasarım_Getir_Tablo
{
public string ID { get; set; }
public string Tasarım_Base64 { get; set; }
public string Tasarım_Adı { get; set; }
}
[System.Web.Services.WebMethod]
public static string Tasarım_Getir()
{
if (FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).Name.ToString() == null)
{
return "DONT DO THİS AGAİN";
}
else
{
var queryWithForJson = " select ID,Tasarım_Base64,Tasarım_Adı from E_SERBEST_MESLEK_MAKBUZU_TASARIM_BASE64" +
"" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
conn.Open();
List<Tasarım_Getir_Tablo> tablo_Doldur_Classes = new List<Tasarım_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Tasarım_Getir_Tablo
{
ID = reader.GetValue(0).ToString(),
Tasarım_Base64 = reader.GetValue(1).ToString(),
Tasarım_Adı = reader.GetValue(2).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
}
public static List<Gönderen_Bilgileri> Gönderen_Bilgileri_Getir(string E_SMM_ID)
{
var queryWithForJson = "" +
"select " +
"" +
"[ID]" +//0
" ,[Vergi_Kimlik_No]" +//1
" ,[Unvan]" +//2
" ,[Adı_Soyadı]" +//3
" ,[Ticari_Unvan_Ad_Soyad]" +//4
" ,[Yetkili_Eposta]" +//5
" ,[Bina_Adı]" +//6
" ,[Bina_Numarası]" +//7
" ,[Kapı_Numarası]" +//8
" ,[Kasaba_Köy]" +//9
" ,[Bulvar_Cadde_Sokak]" +//10
" ,[Ülke]" +//11
" ,[Posta_Kodu]" +//12
" ,[Telefon]" +//13
" ,[Faks]" +//14
" ,[Firma_e_Posta]" +//15
" ,[İnternet_Sitesi]" +//16
" ,[Vergi_Dairesi]" +//17
" ,[Sicil_No]" +//18
" ,[Mersis_No]" +//19
" ,[İşletme_Merkezi]" +//20
" ,[Doktor_ID], [İl]" +//21 // 22
" ,[Mahalle_Semt_İlçe]" +//23
" ,[Kullanıcı_Adı]" +//24
" ,[Şifre]" +//25
"" +
"from Firmalar where ID= (select Firma_Id from E_Logo_SMM_Genel where ID=@E_SMM_ID )" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@E_SMM_ID", E_SMM_ID);
conn.Open();
List<Gönderen_Bilgileri> tablo_Doldur_Classes = new List<Gönderen_Bilgileri>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
string ad = reader.GetValue(3).ToString().Split(' ')[0];
string soyad = "";
for (int i = 1; i < reader.GetValue(3).ToString().Split(' ').Length; i++)
{
soyad = reader.GetValue(3).ToString().Split(' ')[i];
}
var Tablo_Doldur_Class_ = new Gönderen_Bilgileri
{
TCKN = reader.GetValue(1).ToString(),
TICARETSICILNO = reader.GetValue(18).ToString(),
StreetName = reader.GetValue(10).ToString(),
Room = reader.GetValue(8).ToString(),
BuildingName = reader.GetValue(6).ToString(),
BuildingNumber = reader.GetValue(7).ToString(),
CitySubdivisionName = reader.GetValue(23).ToString(),
CityName = reader.GetValue(22).ToString(),
PostalZone = reader.GetValue(12).ToString(),
Region = "",
Country = reader.GetValue(11).ToString(),
Telephone = reader.GetValue(12).ToString(),
Telefax = reader.GetValue(14).ToString(),
ElectronicMail = reader.GetValue(15).ToString(),
FirstName = ad,
FamilyName = soyad,
Kullanıcı_Adı = reader.GetValue(24).ToString(),
Şifre = reader.GetValue(25).ToString(),
Vergi_Dairesi= reader.GetValue(17).ToString()
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return tablo_Doldur_Classes;
}
public static List<Gönderen_Bilgileri> Alıcı_Bilgileri_Getir(string E_SMM_ID)
{
var queryWithForJson = "" +
"SELECT [Hasta_Id]" +//0
" ,[Hastanın_Adı]" +//1
" ,[Hastanın_Soyadı]" +//2
" ,[Doğum_Tarihi]" +//3
" ,[Cep_Tel]" +//4
" ,[Cep_Numarası_Sahibi]" +//5
" ,[Baba_Adı]" +//6
" ,[Baba_Mesleği]" +//7
" ,[Anne_Adı]" +//8
" ,[Anne_Mesleği]" +//9
" ,[Hasta_Tc_Kimlik]" +//10
" ,[Hasta_Cinsiyet]" +//11
" ,[Kan_Grubu]" +////12
" ,(select CityName from City where CityID=[İl])" +//13
" ,(select TownName from Town where TownID=[İlçe])" +//14
" ,[Adres]" +//15
" ,[Sabit_Tel]" +////16
" ,[Ödeme_Tipi]" +//17
" ,[Sms_Onayı_Alındımı]" +//18
" ,[EPosta]" +//19
" ,[Özel_Bilgi]" +//20
" ,[Baba_Telefon] " +//21
" ,[Anne_Telefon] " +//22
" ,[Info] " +//23
" FROM [Hasta_Takip].[dbo].[Hastalar] where Hasta_Id = (select Alıcı_Id from E_Logo_SMM_Genel where ID=@E_SMM_ID ) " +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@E_SMM_ID", E_SMM_ID);
conn.Open();
List<Gönderen_Bilgileri> tablo_Doldur_Classes = new List<Gönderen_Bilgileri>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
string ad = reader.GetValue(3).ToString().Split(' ')[0];
string soyad = "";
for (int i = 1; i < reader.GetValue(3).ToString().Split(' ').Length; i++)
{
soyad = reader.GetValue(3).ToString().Split(' ')[i];
}
var Tablo_Doldur_Class_ = new Gönderen_Bilgileri
{
TCKN = reader.GetValue(10).ToString(),
// TICARETSICILNO = reader.GetValue(18).ToString(),
// StreetName = reader.GetValue(10).ToString(),
// Room = reader.GetValue(8).ToString(),
//BuildingName = reader.GetValue(6).ToString(),
// BuildingNumber = reader.GetValue(7).ToString(),
CitySubdivisionName = reader.GetValue(15).ToString()+" "+ reader.GetValue(14).ToString(),
CityName = reader.GetValue(13).ToString(),
PostalZone = reader.GetValue(12).ToString(),
Region = "",
Country = "TÜRKİYE",
Telephone = reader.GetValue(4).ToString(),
//Telefax = reader.GetValue(14).ToString(),
ElectronicMail = reader.GetValue(19).ToString(),
FirstName = reader.GetValue(1).ToString(),
FamilyName = reader.GetValue(2).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return tablo_Doldur_Classes;
}
public class Tax_Total_Geitr_Genel_Tablo
{
public string Tahsil_Edilen_Kdv { get; set; }
public string Tutar { get; set; }
public string Kdv_Oranı { get; set; }
}
public static List<Tax_Total_Geitr_Genel_Tablo> Tax_Total_Geitr_Genel(string E_SMM_ID)
{
var queryWithForJson = "" +
"select SUM(Net_Tahsilat-Brüt_Ücret),SUM(Net_Tahsilat),Kdv_Oranı from E_Logo_SMM_Detay " +
"" +
"inner join E_Logo_SMM_Genel " +
"on E_Logo_SMM_Detay.E_Logo_SMM_Genel_ID=E_Logo_SMM_Genel.ID " +
"" +
"where E_Logo_SMM_Genel.ID=@E_SMM_ID group by Kdv_Oranı " +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@E_SMM_ID", E_SMM_ID);
conn.Open();
List<Tax_Total_Geitr_Genel_Tablo> tablo_Doldur_Classes = new List<Tax_Total_Geitr_Genel_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Tax_Total_Geitr_Genel_Tablo
{
Tahsil_Edilen_Kdv = String.Format("{0:0,0}", reader.GetDecimal(0)),
Tutar = String.Format("{0:0,0}", reader.GetDecimal(1)),
Kdv_Oranı = String.Format("{0:0,0}", reader.GetDecimal(2)),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return tablo_Doldur_Classes;
}
public class LegalMonetaryTotal_Getir_Tablo
{
public string Kdvli_Ttuar { get; set; }
public string Kdvsiz_Tutar { get; set; }
}
public static List<LegalMonetaryTotal_Getir_Tablo> LegalMonetaryTotal_Getir(string E_SMM_ID)
{
var queryWithForJson = "" +
"select SUM(Brüt_Ücret),SUM(Net_Tahsilat) from E_Logo_SMM_Detay " +
"" +
"inner join E_Logo_SMM_Genel " +
"on E_Logo_SMM_Detay.E_Logo_SMM_Genel_ID=E_Logo_SMM_Genel.ID " +
"" +
"where E_Logo_SMM_Genel.ID=@E_SMM_ID " +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@E_SMM_ID", E_SMM_ID);
conn.Open();
List<LegalMonetaryTotal_Getir_Tablo> tablo_Doldur_Classes = new List<LegalMonetaryTotal_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new LegalMonetaryTotal_Getir_Tablo
{
Kdvli_Ttuar = String.Format("{0:0,0}", reader.GetDecimal(1)),
Kdvsiz_Tutar = String.Format("{0:0,0}", reader.GetDecimal(0)),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return tablo_Doldur_Classes;
}
public class Belge_Bilgileri
{
public string Ettn { get; set; }
public string Belge_No { get; set; }
public string Belge_Oluşturulma_Tar { get; set; }
public string Belge_Tar { get; set; }
public string Belge_Notu { get; set; }
}
public static List<Belge_Bilgileri> Belge_Bilgileri_Getir(string E_SMM_ID)
{
var queryWithForJson =
"" +
"" +
"select Belge_ETTN,Belge_No,Belge_Olusturlma_Tar,Belge_Tarihi,Belge_Notu from E_Logo_SMM_Genel where ID=@E_SMM_ID " +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@E_SMM_ID", E_SMM_ID);
conn.Open();
List<Belge_Bilgileri> tablo_Doldur_Classes = new List<Belge_Bilgileri>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new Belge_Bilgileri
{
Ettn = reader.GetValue(0).ToString(),
Belge_No = reader.GetValue(1).ToString(),
Belge_Oluşturulma_Tar = reader.GetValue(2).ToString(),
Belge_Tar = reader.GetValue(3).ToString(),
Belge_Notu = reader.GetValue(4).ToString(),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return tablo_Doldur_Classes;
}
public class creditNoteLine_Getir_Tablo
{
public string Ücretin_Ne_İçin_Alındığı { get; set; }
public string Brüt_Ücret { get; set; }
public string G_V_Stopaj_Oranı { get; set; }
public string Net_Ücret { get; set; }
public string Kdv_Oranı { get; set; }
public string Net_Tahsilat { get; set; }
public string Kdv_Tutarı { get; set; }
}
public static List<creditNoteLine_Getir_Tablo> creditNoteLine_Getir(string E_SMM_ID)
{
var queryWithForJson = "" +
"select Ücretin_Ne_İçin_Alındığı,Brüt_Ücret,G_V_Stopaj_Oranı,Net_Ücret,Kdv_Oranı,Net_Tahsilat,-(Brüt_Ücret-Net_Tahsilat) from E_Logo_SMM_Detay " +
"" +
" where E_Logo_SMM_Genel_ID=@E_SMM_ID" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@E_SMM_ID", E_SMM_ID);
conn.Open();
List<creditNoteLine_Getir_Tablo> tablo_Doldur_Classes = new List<creditNoteLine_Getir_Tablo>();
var jsonResult = new StringBuilder();
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader.Read())
{
var Tablo_Doldur_Class_ = new creditNoteLine_Getir_Tablo
{
Ücretin_Ne_İçin_Alındığı = reader.GetValue(0).ToString(),
Brüt_Ücret = String.Format("{0:0,0}", reader.GetDecimal(1)),
G_V_Stopaj_Oranı = String.Format("{0:0,0}", reader.GetDecimal(2)),
Net_Ücret = String.Format("{0:0,0}", reader.GetDecimal(3)),
Kdv_Oranı = String.Format("{0:0,0}", reader.GetDecimal(4)),
Net_Tahsilat = String.Format("{0:0,0}", reader.GetDecimal(5)),
Kdv_Tutarı = String.Format("{0:0,0}", reader.GetDecimal(6)),
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
}
}
conn.Close();
return tablo_Doldur_Classes;
}
public class Gönderen_Bilgileri
{
public string TCKN { get; set; }
public string TICARETSICILNO { get; set; }
public string StreetName { get; set; }
public string Room { get; set; }
public string BuildingName { get; set; }
public string BuildingNumber { get; set; }
public string CitySubdivisionName { get; set; }
public string CityName { get; set; }
public string PostalZone { get; set; }
public string Region { get; set; }
public string Country { get; set; }
public string Telephone { get; set; }
public string Telefax { get; set; }
public string ElectronicMail { get; set; }
public string FirstName { get; set; }
public string FamilyName { get; set; }
public string Kullanıcı_Adı { get; set; }
public string Şifre { get; set; }
public string Vergi_Dairesi { get; set; }
}
[System.Web.Services.WebMethod]
public static string Deneme_Olustur(string E_SMM_ID)
{
var Belge_Bilgileri = Belge_Bilgileri_Getir(E_SMM_ID);
string Belge_No = Belge_Bilgileri.Count > 0 ? Belge_Bilgileri[0].Belge_No : "YAZ2022000000000";
string Belge_Tarih = Belge_Bilgileri.Count > 0 ? Convert.ToDateTime(Belge_Bilgileri[0].Belge_Tar).ToString("yyyy-MM-dd") : "1999-01-01";
string Belge_Ettn = Belge_Bilgileri[0].Ettn;
string Belge_Notu = Belge_Bilgileri[0].Belge_Notu;
var Gönderen = Gönderen_Bilgileri_Getir(E_SMM_ID)[0];
var Alıcı = Alıcı_Bilgileri_Getir(E_SMM_ID)[0];
List<AdditionalDocumentReference> additionalDocumentReferences = new List<AdditionalDocumentReference>();
AdditionalDocumentReference additionalDocumentReference = new AdditionalDocumentReference()
{
ID = "gonderimSekli",
IssueDate = Belge_Tarih,
DocumentType = "KAGIT"
};
additionalDocumentReferences.Add(additionalDocumentReference);
Tasarım tasarım = new Tasarım() { };
EmbeddedDocumentBinaryObject embeddedDocumentBinaryObject = new EmbeddedDocumentBinaryObject()
{
CharacterSetCode = "UTF-8",
EncodingCode = "Base64",
Filename = Belge_No + ".xslt",
MimeCode = "application/xml",
Text = tasarım.TasarımBase64
};
Attachment attachment = new Attachment()
{
EmbeddedDocumentBinaryObject = embeddedDocumentBinaryObject,
};
additionalDocumentReference = new AdditionalDocumentReference()
{
ID = Belge_No,
IssueDate = Belge_Tarih,
DocumentType = "XSLT",
DocumentDescription = "XSLT belgesi",
Attachment = attachment
};
additionalDocumentReferences.Add(additionalDocumentReference);
AccountingSupplierParty accountingSupplierParty = new AccountingSupplierParty()
{
Party = new Party
{
PartyName = new PartyName() { Name = "" },
WebsiteURI = null,
PartyIdentification = new List<PartyIdentification>()
{
new PartyIdentification(){ ID= new ID { Text= Gönderen.TCKN ,SchemeID= "TCKN" } },
new PartyIdentification(){ ID= new ID { Text= Gönderen.TICARETSICILNO ,SchemeID= "TICARETSICILNO" } },
},
PostalAddress = new PostalAddress()
{
Room = Gönderen.Room == "" ? null : Gönderen.Room,
StreetName = Gönderen.StreetName == "" ? null : Gönderen.StreetName,
BuildingName = Gönderen.BuildingName == "" ? null : Gönderen.BuildingName,
BuildingNumber = Gönderen.BuildingNumber == "" ? null : Gönderen.BuildingNumber,
CitySubdivisionName = Gönderen.CitySubdivisionName == "" ? null : Gönderen.CitySubdivisionName,
CityName = Gönderen.CityName == "" ? null : Gönderen.CityName,
PostalZone = Gönderen.PostalZone == "" ? null : Gönderen.PostalZone,
Region = Gönderen.Region == "" ? null : Gönderen.Region,
Country = new Country() { Name = Gönderen.Country, IdentificationCode = "TR" }
},
PartyTaxScheme = new PartyTaxScheme()
{
TaxScheme = new TaxScheme() { Name = Gönderen.Vergi_Dairesi}
},
Contact = new Contact()
{
Telephone = Gönderen.Telephone == "" ? null : Gönderen.Telephone,
Telefax = Gönderen.Telefax == "" ? null : Gönderen.Telefax,
ElectronicMail = Gönderen.ElectronicMail == "" ? null : Gönderen.ElectronicMail
},
Person = new Person()
{
FirstName = Gönderen.FirstName == "" ? null : Gönderen.FirstName,
FamilyName = Gönderen.FamilyName == "" ? null : Gönderen.FamilyName
}
}
};
AccountingCustomerParty accountingCustomerParty = new AccountingCustomerParty()
{
Party = new Party()
{
WebsiteURI = "",
PartyIdentification = new List<PartyIdentification> {
new PartyIdentification(){ ID= new ID { Text= Alıcı.TCKN ,SchemeID= "TCKN" } },
},
PartyName = new PartyName() { Name = " " },
PostalAddress = new PostalAddress()
{
//Room = "",
StreetName = Alıcı.StreetName,
//BuildingName = "",
//BuildingNumber = "",
CitySubdivisionName = Alıcı.CitySubdivisionName,
CityName = Alıcı.CityName,
//PostalZone = "",
//Region = "",
Country = new Country() { Name = "Türkiye", IdentificationCode = "TR" }
},
Person = new Person()
{
FirstName = Alıcı.FirstName,
FamilyName = Alıcı.FamilyName
}
}
};
List<TaxTotal> taxTotals = new List<TaxTotal>();
var tax_Total_Geitr_Genel = Tax_Total_Geitr_Genel(E_SMM_ID);
for (int i = 0; i < tax_Total_Geitr_Genel.Count; i++)
{
TaxTotal taxTotal = new TaxTotal()
{
TaxAmount = new TaxAmount() { CurrencyID = "TRY", Text = tax_Total_Geitr_Genel[i].Tahsil_Edilen_Kdv },
TaxSubtotal = new TaxSubtotal()
{
TaxableAmount = new TaxableAmount() { CurrencyID = "TRY", Text = tax_Total_Geitr_Genel[i].Tutar },
TaxAmount = new TaxAmount() { CurrencyID = "TRY", Text = tax_Total_Geitr_Genel[i].Tahsil_Edilen_Kdv },
Percent = tax_Total_Geitr_Genel[i].Kdv_Oranı,
TaxCategory = new TaxCategory()
{
TaxScheme = new TaxScheme()
{
Name = "KDV GERÇEK",
TaxTypeCode = "0015"
}
}
}
};
taxTotals.Add(taxTotal);
}
var legalMonetaryTotal_Getir = LegalMonetaryTotal_Getir(E_SMM_ID);
LegalMonetaryTotal legalMonetaryTotal = new LegalMonetaryTotal()
{
LineExtensionAmount = new LineExtensionAmount() { CurrencyID = "TRY", Text = legalMonetaryTotal_Getir[0].Kdvsiz_Tutar },
TaxExclusiveAmount = new TaxExclusiveAmount() { CurrencyID = "TRY", Text = legalMonetaryTotal_Getir[0].Kdvsiz_Tutar },
TaxInclusiveAmount = new TaxInclusiveAmount() { CurrencyID = "TRY", Text = legalMonetaryTotal_Getir[0].Kdvli_Ttuar },
PayableAmount = new PayableAmount() { CurrencyID = "TRY", Text = legalMonetaryTotal_Getir[0].Kdvli_Ttuar }
};
List<CreditNoteLine> satırlar = new List<CreditNoteLine>();
var CreditNoteLine_Getir = creditNoteLine_Getir(E_SMM_ID);
for (int i = 0; i < CreditNoteLine_Getir.Count; i++)
{
CreditNoteLine creditNoteLine = new CreditNoteLine()
{
ID = "1",
Note = "",
CreditedQuantity = new CreditedQuantity() { UnitCode = "C62", Text = "1" },
LineExtensionAmount = new LineExtensionAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Brüt_Ücret },
TaxTotal = new TaxTotal()
{
TaxAmount = new TaxAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Kdv_Tutarı },
TaxSubtotal = new TaxSubtotal()
{
TaxableAmount = new TaxableAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Brüt_Ücret },
TaxAmount = new TaxAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Kdv_Tutarı },
Percent = "8",
TaxCategory = new TaxCategory()
{
TaxScheme = new TaxScheme() { Name = "KDV GERCEK", TaxTypeCode = "0015" }
},
},
},
Item = new Item()
{
Description = "",
Name = CreditNoteLine_Getir[i].Ücretin_Ne_İçin_Alındığı,
SellersItemIdentification = new SellersItemIdentification()
{
ID = CreditNoteLine_Getir[i].Ücretin_Ne_İçin_Alındığı
},
},
Price = new Price()
{
PriceAmount = new PriceAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Brüt_Ücret }
}
};
satırlar.Add(creditNoteLine);
}
CreditNote creditNote = new CreditNote()
{
DocumentCurrencyCode = new DocumentCurrencyCode()
{
Text = "TRY",
ListName = "Currency",
ListVersionID = "2001",
ListAgencyName = "United Nations Economic Commission for Europe",
ListID = "ISO 4217 Alpha"
},
AdditionalDocumentReference = additionalDocumentReferences,
AccountingSupplierParty = accountingSupplierParty,
AccountingCustomerParty = accountingCustomerParty,
TaxTotal = taxTotals,
LegalMonetaryTotal = legalMonetaryTotal,
CreditNoteLine = satırlar
};
//var namespaces = new XmlSerializerNamespaces();
//namespaces.Add("cac", CreditNote.cac);
//namespaces.Add("cbc", CreditNote.cbc);
//namespaces.Add("ccts", CreditNote.ccts);
//namespaces.Add("ext", CreditNote.ext);
//namespaces.Add("cbc", CreditNote.cbc);
//namespaces.Add("qdt", CreditNote.qdt);
//namespaces.Add("ubltr", CreditNote.ubltr);
//namespaces.Add("udt", CreditNote.udt);
//namespaces.Add("xsi", CreditNote.xsi);
//namespaces.Add("schemaLocation", CreditNote.SchemaInstanceNamespace);
//var serializer = new XmlSerializer(typeof(CreditNote));
creditNote.UBLVersionID = "2.1";
creditNote.CustomizationID = "TR1.2.1";
creditNote.ProfileID = "EARSIVBELGE";
creditNote.ID = Belge_No;
creditNote.CopyIndicator = false;
creditNote.UUID = Belge_Ettn;
creditNote.IssueDate = Belge_Tarih;
creditNote.IssueTime = "22:19:13";
creditNote.Note = Belge_Notu;
creditNote.LineCountNumeric = 1;
XmlWriterSettings settings = new XmlWriterSettings();
settings.OmitXmlDeclaration = true;
MemoryStream ms = new MemoryStream();
XmlWriter writer = XmlWriter.Create(ms, settings);
XmlSerializerNamespaces names = new XmlSerializerNamespaces();
names.Add("cac", CreditNote.cac);
names.Add("cbc", CreditNote.cbc);
names.Add("ccts", CreditNote.ccts);
names.Add("ext", CreditNote.ext);
names.Add("cbc", CreditNote.cbc);
names.Add("qdt", CreditNote.qdt);
names.Add("ubltr", CreditNote.ubltr);
names.Add("udt", CreditNote.udt);
names.Add("xsi", CreditNote.xsi);
names.Add("schemaLocation", CreditNote.SchemaInstanceNamespace);
XmlSerializer cs = new XmlSerializer(typeof(CreditNote));
cs.Serialize(writer, creditNote, names);
ms.Flush();
ms.Seek(0, SeekOrigin.Begin);
StreamReader sr = new StreamReader(ms);
var xml__ = sr.ReadToEnd();
// Console.WriteLine(xml);
//string Fatura_Xml_File;
//using (StringWriter stringwriter = new System.IO.StringWriter())
//{
// serializer.Serialize(stringwriter, creditNote, namespaces);
// Fatura_Xml_File = stringwriter.ToString();
//}
// Console.WriteLine(Fatura_Xml_File);
using (var memoryStream = new MemoryStream())
{
using (var archive = new ZipArchive(memoryStream, ZipArchiveMode.Create, true))
{
var demoFile = archive.CreateEntry(Belge_No + ".xml");
using (var entryStream = demoFile.Open())
using (var streamWriter = new StreamWriter(entryStream))
{
streamWriter.Write(xml__);
//Console.WriteLine(streamWriter);
}
}
//return Convert.ToBase64String(memoryStream.ToArray()).ToString();
return xml__;
//using (var fileStream = new FileStream(@"Deneme.zip", FileMode.OpenOrCreate))
//{
// memoryStream.Seek(0, SeekOrigin.Begin);
// memoryStream.CopyTo(fileStream);
//}
}
}
public static string Gönderme_Oluştur(string E_SMM_ID)
{
var Belge_Bilgileri = Belge_Bilgileri_Getir(E_SMM_ID);
string Belge_No = Belge_Bilgileri.Count > 0 ? Belge_Bilgileri[0].Belge_No : "YAZ2022000000000";
string Belge_Tarih = Belge_Bilgileri.Count > 0 ? Convert.ToDateTime(Belge_Bilgileri[0].Belge_Tar).ToString("yyyy-MM-dd") : "1999-01-01";
string Belge_Ettn = Belge_Bilgileri[0].Ettn;
string Belge_Notu = Belge_Bilgileri[0].Belge_Notu;
var Gönderen = Gönderen_Bilgileri_Getir(E_SMM_ID)[0];
var Alıcı = Alıcı_Bilgileri_Getir(E_SMM_ID)[0];
List<AdditionalDocumentReference> additionalDocumentReferences = new List<AdditionalDocumentReference>();
AdditionalDocumentReference additionalDocumentReference = new AdditionalDocumentReference()
{
ID = "gonderimSekli",
IssueDate = Belge_Tarih,
DocumentType = "KAGIT"
};
additionalDocumentReferences.Add(additionalDocumentReference);
Tasarım tasarım = new Tasarım() { };
EmbeddedDocumentBinaryObject embeddedDocumentBinaryObject = new EmbeddedDocumentBinaryObject()
{
CharacterSetCode = "UTF-8",
EncodingCode = "Base64",
Filename = Belge_No + ".xslt",
MimeCode = "application/xml",
Text = tasarım.TasarımBase64
};
Attachment attachment = new Attachment()
{
EmbeddedDocumentBinaryObject = embeddedDocumentBinaryObject,
};
additionalDocumentReference = new AdditionalDocumentReference()
{
ID = Belge_No,
IssueDate = Belge_Tarih,
DocumentType = "XSLT",
DocumentDescription = "XSLT belgesi",
Attachment = attachment
};
additionalDocumentReferences.Add(additionalDocumentReference);
AccountingSupplierParty accountingSupplierParty = new AccountingSupplierParty()
{
Party = new Party
{
PartyName = new PartyName() { Name = "" },
WebsiteURI = null,
PartyIdentification = new List<PartyIdentification>()
{
new PartyIdentification(){ ID= new ID { Text= Gönderen.TCKN ,SchemeID= "TCKN" } },
new PartyIdentification(){ ID= new ID { Text= Gönderen.TICARETSICILNO ,SchemeID= "TICARETSICILNO" } },
},
PostalAddress = new PostalAddress()
{
Room = Gönderen.Room == "" ? null : Gönderen.Room,
StreetName = Gönderen.StreetName == "" ? null : Gönderen.StreetName,
BuildingName = Gönderen.BuildingName == "" ? null : Gönderen.BuildingName,
BuildingNumber = Gönderen.BuildingNumber == "" ? null : Gönderen.BuildingNumber,
CitySubdivisionName = Gönderen.CitySubdivisionName == "" ? null : Gönderen.CitySubdivisionName,
CityName = Gönderen.CityName == "" ? null : Gönderen.CityName,
PostalZone = Gönderen.PostalZone == "" ? null : Gönderen.PostalZone,
Region = Gönderen.Region == "" ? null : Gönderen.Region,
Country = new Country() { Name = Gönderen.Country, IdentificationCode = "TR" }
},
PartyTaxScheme = new PartyTaxScheme()
{
TaxScheme = new TaxScheme() { Name = Gönderen.Vergi_Dairesi }
},
Contact = new Contact()
{
Telephone = Gönderen.Telephone == "" ? null : Gönderen.Telephone,
Telefax = Gönderen.Telefax == "" ? null : Gönderen.Telefax,
ElectronicMail = Gönderen.ElectronicMail == "" ? null : Gönderen.ElectronicMail
},
Person = new Person()
{
FirstName = Gönderen.FirstName == "" ? null : Gönderen.FirstName,
FamilyName = Gönderen.FamilyName == "" ? null : Gönderen.FamilyName
}
}
};
AccountingCustomerParty accountingCustomerParty = new AccountingCustomerParty()
{
Party = new Party()
{
WebsiteURI = "",
PartyIdentification = new List<PartyIdentification> {
new PartyIdentification(){ ID= new ID { Text= Alıcı.TCKN ,SchemeID= "TCKN" } },
},
PartyName = new PartyName() { Name = " " },
PostalAddress = new PostalAddress()
{
//Room = "",
StreetName = Alıcı.StreetName,
//BuildingName = "",
//BuildingNumber = "",
CitySubdivisionName = Alıcı.CitySubdivisionName,
CityName = Alıcı.CityName,
//PostalZone = "",
//Region = "",
Country = new Country() { Name = "Türkiye", IdentificationCode = "TR" }
},
Person = new Person()
{
FirstName = Alıcı.FirstName,
FamilyName = Alıcı.FamilyName
}
}
};
List<TaxTotal> taxTotals = new List<TaxTotal>();
var tax_Total_Geitr_Genel = Tax_Total_Geitr_Genel(E_SMM_ID);
for (int i = 0; i < tax_Total_Geitr_Genel.Count; i++)
{
TaxTotal taxTotal = new TaxTotal()
{
TaxAmount = new TaxAmount() { CurrencyID = "TRY", Text = tax_Total_Geitr_Genel[i].Tahsil_Edilen_Kdv },
TaxSubtotal = new TaxSubtotal()
{
TaxableAmount = new TaxableAmount() { CurrencyID = "TRY", Text = tax_Total_Geitr_Genel[i].Tutar },
TaxAmount = new TaxAmount() { CurrencyID = "TRY", Text = tax_Total_Geitr_Genel[i].Tahsil_Edilen_Kdv },
Percent = tax_Total_Geitr_Genel[i].Kdv_Oranı,
TaxCategory = new TaxCategory()
{
TaxScheme = new TaxScheme()
{
Name = "KDV GERÇEK",
TaxTypeCode = "0015"
}
}
}
};
taxTotals.Add(taxTotal);
}
var legalMonetaryTotal_Getir = LegalMonetaryTotal_Getir(E_SMM_ID);
LegalMonetaryTotal legalMonetaryTotal = new LegalMonetaryTotal()
{
LineExtensionAmount = new LineExtensionAmount() { CurrencyID = "TRY", Text = legalMonetaryTotal_Getir[0].Kdvsiz_Tutar },
TaxExclusiveAmount = new TaxExclusiveAmount() { CurrencyID = "TRY", Text = legalMonetaryTotal_Getir[0].Kdvsiz_Tutar },
TaxInclusiveAmount = new TaxInclusiveAmount() { CurrencyID = "TRY", Text = legalMonetaryTotal_Getir[0].Kdvli_Ttuar },
PayableAmount = new PayableAmount() { CurrencyID = "TRY", Text = legalMonetaryTotal_Getir[0].Kdvli_Ttuar }
};
List<CreditNoteLine> satırlar = new List<CreditNoteLine>();
var CreditNoteLine_Getir = creditNoteLine_Getir(E_SMM_ID);
for (int i = 0; i < CreditNoteLine_Getir.Count; i++)
{
CreditNoteLine creditNoteLine = new CreditNoteLine()
{
ID = "1",
Note = "",
CreditedQuantity = new CreditedQuantity() { UnitCode = "C62", Text = "1" },
LineExtensionAmount = new LineExtensionAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Brüt_Ücret },
TaxTotal = new TaxTotal()
{
TaxAmount = new TaxAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Kdv_Tutarı },
TaxSubtotal = new TaxSubtotal()
{
TaxableAmount = new TaxableAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Brüt_Ücret },
TaxAmount = new TaxAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Kdv_Tutarı },
Percent = "8",
TaxCategory = new TaxCategory()
{
TaxScheme = new TaxScheme() { Name = "KDV GERCEK", TaxTypeCode = "0015" }
},
},
},
Item = new Item()
{
Description = "",
Name = CreditNoteLine_Getir[i].Ücretin_Ne_İçin_Alındığı,
SellersItemIdentification = new SellersItemIdentification()
{
ID = CreditNoteLine_Getir[i].Ücretin_Ne_İçin_Alındığı
},
},
Price = new Price()
{
PriceAmount = new PriceAmount() { CurrencyID = "TRY", Text = CreditNoteLine_Getir[i].Brüt_Ücret }
}
};
satırlar.Add(creditNoteLine);
}
CreditNote creditNote = new CreditNote()
{
DocumentCurrencyCode = new DocumentCurrencyCode()
{
Text = "TRY",
ListName = "Currency",
ListVersionID = "2001",
ListAgencyName = "United Nations Economic Commission for Europe",
ListID = "ISO 4217 Alpha"
},
AdditionalDocumentReference = additionalDocumentReferences,
AccountingSupplierParty = accountingSupplierParty,
AccountingCustomerParty = accountingCustomerParty,
TaxTotal = taxTotals,
LegalMonetaryTotal = legalMonetaryTotal,
CreditNoteLine = satırlar
};
//var namespaces = new XmlSerializerNamespaces();
//namespaces.Add("cac", CreditNote.cac);
//namespaces.Add("cbc", CreditNote.cbc);
//namespaces.Add("ccts", CreditNote.ccts);
//namespaces.Add("ext", CreditNote.ext);
//namespaces.Add("cbc", CreditNote.cbc);
//namespaces.Add("qdt", CreditNote.qdt);
//namespaces.Add("ubltr", CreditNote.ubltr);
//namespaces.Add("udt", CreditNote.udt);
//namespaces.Add("xsi", CreditNote.xsi);
//namespaces.Add("schemaLocation", CreditNote.SchemaInstanceNamespace);
//var serializer = new XmlSerializer(typeof(CreditNote));
creditNote.UBLVersionID = "2.1";
creditNote.CustomizationID = "TR1.2.1";
creditNote.ProfileID = "EARSIVBELGE";
creditNote.ID = Belge_No;
creditNote.CopyIndicator = false;
creditNote.UUID = Belge_Ettn;
creditNote.IssueDate = Belge_Tarih;
creditNote.IssueTime = "22:19:13";
creditNote.Note = Belge_Notu;
creditNote.LineCountNumeric = 1;
XmlWriterSettings settings = new XmlWriterSettings();
settings.OmitXmlDeclaration = true;
MemoryStream ms = new MemoryStream();
XmlWriter writer = XmlWriter.Create(ms, settings);
XmlSerializerNamespaces names = new XmlSerializerNamespaces();
names.Add("cac", CreditNote.cac);
names.Add("cbc", CreditNote.cbc);
names.Add("ccts", CreditNote.ccts);
names.Add("ext", CreditNote.ext);
names.Add("cbc", CreditNote.cbc);
names.Add("qdt", CreditNote.qdt);
names.Add("ubltr", CreditNote.ubltr);
names.Add("udt", CreditNote.udt);
names.Add("xsi", CreditNote.xsi);
names.Add("schemaLocation", CreditNote.SchemaInstanceNamespace);
XmlSerializer cs = new XmlSerializer(typeof(CreditNote));
cs.Serialize(writer, creditNote, names);
ms.Flush();
ms.Seek(0, SeekOrigin.Begin);
StreamReader sr = new StreamReader(ms);
var xml__ = sr.ReadToEnd();
// Console.WriteLine(xml);
//string Fatura_Xml_File;
//using (StringWriter stringwriter = new System.IO.StringWriter())
//{
// serializer.Serialize(stringwriter, creditNote, namespaces);
// Fatura_Xml_File = stringwriter.ToString();
//}
// Console.WriteLine(Fatura_Xml_File);
using (var memoryStream = new MemoryStream())
{
using (var archive = new ZipArchive(memoryStream, ZipArchiveMode.Create, true))
{
var demoFile = archive.CreateEntry(Belge_No + ".xml");
using (var entryStream = demoFile.Open())
using (var streamWriter = new StreamWriter(entryStream))
{
streamWriter.Write(xml__);
//Console.WriteLine(streamWriter);
}
}
return Convert.ToBase64String(memoryStream.ToArray()).ToString();
}
}
public static string Login_Ol(string Kullanıcı_Adı, string Şifre)
{
var client = new RestClient("https://pb.elogo.com.tr/PostBoxService.svc");
client.Timeout = -1;
client.FollowRedirects = false;
var request = new RestRequest(Method.POST);
request.AddHeader("SOAPAction", "\"http://tempuri.org/IPostBoxService/Login\"");
request.AddHeader("Content-Type", "text/xml");
var body = @"<soapenv:Envelope xmlns:soapenv=""http://schemas.xmlsoap.org/soap/envelope/""
" + "\n" +
@"xmlns:tem=""http://tempuri.org/"" xmlns:efat=""http://schemas.datacontract.org/2004/07/eFaturaWebService"">
" + "\n" +
@" <soapenv:Header/>
" + "\n" +
@" <soapenv:Body>
" + "\n" +
@" <tem:Login>
" + "\n" +
@" <tem:login>
" + "\n" +
@" <efat:appStr></efat:appStr>
" + "\n" +
@" <efat:passWord>"+Şifre+ "</efat:passWord>" + "\n" +
@" <efat:source></efat:source>
" + "\n" +
@" <efat:userName>"+ Kullanıcı_Adı + "</efat:userName>" + "\n" +
@" <efat:version></efat:version>
" + "\n" +
@" </tem:login>
" + "\n" +
@" </tem:Login>
" + "\n" +
@" </soapenv:Body>
" + "\n" +
@"</soapenv:Envelope>";
request.AddParameter("text/xml", body, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);
XmlSerializer serializer = new XmlSerializer(typeof(Login_Xml_Model.Envelope));
using (StringReader reader = new StringReader(response.Content))
{
var test = (Login_Xml_Model.Envelope)serializer.Deserialize(reader);
return test.Body.LoginResponse.SessionID;
}
}
public class Belge_Durumu
{
public string Belge_Id { get; set; }
public string Durum_Notu { get; set; }
}
[System.Web.Services.WebMethod]
public static string Belge_Gönder(string E_SMM_ID)
{
var gönderen_bilgileri = Gönderen_Bilgileri_Getir(E_SMM_ID);
var session_ıd = Login_Ol(gönderen_bilgileri[0].Kullanıcı_Adı, gönderen_bilgileri[0].Şifre);
var Belge_Bilgileri = Belge_Bilgileri_Getir(E_SMM_ID);
string Belge_Base64 = Gönderme_Oluştur(E_SMM_ID);
string session_ID = session_ıd;
string Belge_No = Belge_Bilgileri[0].Belge_No;
string Belge_Tarihi = Belge_Bilgileri[0].Belge_Tar;
var client_1 = new RestClient("https://pb.elogo.com.tr/PostBoxService.svc");
client_1.Timeout = -1;
client_1.FollowRedirects = false;
var request_1 = new RestRequest(Method.POST);
request_1.AddHeader("Content-Type", "text/xml");
request_1.AddHeader("SOAPAction", "\"http://tempuri.org/IPostBoxService/SendDocument\"");
var body_1 = @"<soapenv:Envelope xmlns:soapenv=""http://schemas.xmlsoap.org/soap/envelope/"" xmlns:tem=""http://tempuri.org/""
" + "\n" +
@"xmlns:arr=""http://schemas.microsoft.com/2003/10/Serialization/Arrays""
" + "\n" +
@"xmlns:efat=""http://schemas.datacontract.org/2004/07/eFaturaWebService"">
" + "\n" +
@" <soapenv:Header/>
" + "\n" +
@" <soapenv:Body>
" + "\n" +
@" <tem:SendDocument>
" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <tem:sessionID>" + session_ıd + "</tem:sessionID>" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <tem:paramList>
" + "\n" +
@" <!--Zero or more repetitions:-->
" + "\n" +
@" <arr:string>DOCUMENTTYPE=SELFEMPLOYMENTRECEIPT</arr:string>
" + "\n" +
@" <arr:string>ALIAS=urn:mail:defaultpk@diyalogo.com.tr</arr:string>
" + "\n" +
@"
" + "\n" +
@" </tem:paramList>
" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <tem:document>
" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <efat:binaryData>
" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <efat:Value>"+Belge_Base64+"</efat:Value>" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <efat:contentType/>
" + "\n" +
@" </efat:binaryData>
" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <efat:currentDate>"+Convert.ToDateTime(Belge_Tarihi).ToString("yyyy-MM-dd") +"</efat:currentDate>" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <efat:fileName>"+Belge_No+".zip</efat:fileName>" + "\n" +
@" <!--Optional:-->
" + "\n" +
@" <efat:hash/>
" + "\n" +
@" </tem:document>
" + "\n" +
@" </tem:SendDocument>
" + "\n" +
@" </soapenv:Body>
" + "\n" +
@"</soapenv:Envelope>";
request_1.AddParameter("text/xml", body_1, ParameterType.RequestBody);
IRestResponse response_1 = client_1.Execute(request_1);
string Belge_Durumu = "";
string Belge_Durumu_Notu = "";
try
{
XmlSerializer serializer_1 = new XmlSerializer(typeof(Belge_Gönder_response.Envelope));
using (StringReader reader = new StringReader(response_1.Content))
{
var test = (Belge_Gönder_response.Envelope)serializer_1.Deserialize(reader);
Belge_Durumu_Notu = test.Body.SendDocumentResponse.SendDocumentResult.ResultMsg;
Belge_Durumu = Convert.ToString(test.Body.SendDocumentResponse.SendDocumentResult.ResultCode);
}
}
catch (Exception)
{
}
try
{
XmlSerializer serializer_1 = new XmlSerializer(typeof(Belge_Göndel_Xml.Envelope));
using (StringReader reader = new StringReader(response_1.Content))
{
var test = (Belge_Göndel_Xml.Envelope)serializer_1.Deserialize(reader);
//Belge_Durumu = Convert.ToString(test.Body.Fault.Faultcode);
Belge_Durumu_Notu = Convert.ToString(test.Body.Fault.Faultstring);
}
}
catch (Exception)
{
}
var queryWithForJson = "" +
"" +
"if(@Belge_Durumu=(-1)) " +
"begin;" +
"update E_Logo_SMM_Genel set Belge_Durum_Notu=@Belge_Duru_Notu where ID=@E_SMM_ID " +
"end;" +
"" +
"else " +
" begin;" +
"" +
"update E_Logo_SMM_Genel set Belge_Durumu=2, Belge_Durum_Notu=@Belge_Duru_Notu where ID=@E_SMM_ID " +
" end;" +
"";
var conn = new SqlConnection(@"server=.;Database=Hasta_Takip;User ID=sa;Password=likompresto%1");
var cmd = new SqlCommand(queryWithForJson, conn);
cmd.Parameters.AddWithValue("@Kullanıcı_Id", FormsAuthentication.Decrypt(System.Web.HttpContext.Current.Request.Cookies[".ASPXAUTH"].Value).UserData.ToString());
cmd.Parameters.AddWithValue("@E_SMM_ID", E_SMM_ID);
cmd.Parameters.AddWithValue("@Belge_Durumu", Belge_Durumu);
cmd.Parameters.AddWithValue("@Belge_Duru_Notu", Belge_Durumu_Notu);
conn.Open();
List<Belge_Durumu> tablo_Doldur_Classes = new List<Belge_Durumu>();
var jsonResult = new StringBuilder();
var reader_sql = cmd.ExecuteReader();
if (!reader_sql.HasRows)
{
jsonResult.Append("[]");
}
else
{
while (reader_sql.Read())
{
}
}
conn.Close();
var Tablo_Doldur_Class_ = new Belge_Durumu
{
Belge_Id = E_SMM_ID,
Durum_Notu = Belge_Durumu_Notu
};
tablo_Doldur_Classes.Add(Tablo_Doldur_Class_);
return JsonConvert.SerializeObject(tablo_Doldur_Classes);
}
[System.Web.Services.WebMethod]
public static string Seçili_olanları_Gönder(string Idler)
{
return "";
}
}
}
@rec4i
Copy link
Author

rec4i commented Mar 1, 2022

image

*Ekranda taslak haline olan makbuzları istenilen düzenlemeleri yaptıktan sonra gönderime hazır duruma getiriliyor

image

*Yukardaki ekranda ilk ekranda ki oluşturulan taslağın önizlemesi yaptığımız ekran

image

*Gönderime hazır hale gelen makbuzların bulunduğu ekran

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment