public static MethodReturn RepairDepoRaf(SERVISDEPOLAR depo, string strRaf, decimal servisId)
{
MethodReturn ret = new MethodReturn();
if (depo == null)
{
return(ret);
}
if (strRaf.isNullOrWhiteSpace())
{
strRaf = "1.Raf";
}
SERVISDEPORAFLAR foundRaf = R.Query <SERVISDEPORAFLAR>(ret).First(t => t.SERVISDEPOID == depo.ID && t.AD == strRaf).createIsNull();
if (ret.ok() && foundRaf.IsNew())
{
decimal seqId = Convert.ToDecimal(SasonBase.SasonBaseApplicationPool.Get.EbaTestConnector.ExecuteScalar("select SERVISDEPORAFLAR_SEQ.NEXTVAL from dual", ret));
if (ret.ok())
{
foundRaf.ID = seqId;
foundRaf.KOD = strRaf;
foundRaf.AD = strRaf;
foundRaf.SERVISDEPOID = depo.ID;
foundRaf.DURUMID = 1;
ret = foundRaf.Update();
}
}
return(ret);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
List <SERVISTEKNISYEN_REPORT_DATA> servisTeknisyenler = R.Query <SERVISTEKNISYEN_REPORT_DATA>(refMr).Where(t => t.SERVISID == ServisId).ToList();
//Tarih Aralığında Personelin Hareketlerini Bul
List <TEKNISYENHAREKET> hareketler = R.Query <TEKNISYENHAREKET>(refMr).Where(t => t.GIRISTARIHI.Between(StartDate.startOfDay(), FinishDate.endOfDay()) && t.SERVISTEKNISYENID.In(servisTeknisyenler.select(tks => tks.ID)) && t.DURUM == YeniTeknisyenHareketDurum.Cikis).ToList();
//Bu Hareketlerde Kullanılan İşEmirİşlemleri Çek
List <Teknisyen_ViewServisIsEmirIslemIscilikler> iscilikler = Teknisyen_ViewServisIsEmirIslemIscilikler.SelectOverloadFromISLEMID(hareketler.select(t => t.ISEMIRISLEMID).Distinct().toList());
PuantajGunlugu pg = new PuantajGunlugu();
List <ServisGunMola> servisGunMolalari = ServisGunMola.SelectServisGunMolalar(ServisId, refMr);
List <HareketNeden> hareketNedenler = HareketNeden.Select_Nedenler();
foreach (SERVISTEKNISYEN_REPORT_DATA servisTeknisyen in servisTeknisyenler)
{
var teknisyenHareketler = hareketler.where (t => t.SERVISTEKNISYENID == servisTeknisyen.ID).orderBy(t => t.GIRISTARIHI).toList();
List <decimal> teknisyenIslemIds = teknisyenHareketler.select(t => t.ISEMIRISLEMID).Distinct().toList();
var teknisyenIscilikler = iscilikler.where (t => teknisyenIslemIds.contains(t.SERVISISEMIRISLEMID)).toList();
servisTeknisyen.Faturalanan_Dakika = (int)teknisyenIscilikler.Sum(t => t.Iscilik_Dakika_Suresi);
List <DateTime> tarihler = teknisyenHareketler.select(t => t.GIRISTARIHI.Date).Distinct().toList();
foreach (var tarih in tarihler)
{
var firstIn = teknisyenHareketler.where (t => t.GIRISTARIHI.Date == tarih).first().GIRISTARIHI;
var lastOut = teknisyenHareketler.where (t => t.GIRISTARIHI.Date == tarih).last().CIKISTARIHI;
servisTeknisyen.NetMevcudiyet_Dakika += (int)(lastOut - firstIn).TotalMinutes;
}
TEKNISYENHAREKET.DAGILIM_SONUCLARI hamPntjData = Puantaj.GetPuantajSonuclari(teknisyenHareketler, pg, servisGunMolalari, hareketNedenler);
servisTeknisyen.FiiliCalisma_Dakika = hamPntjData.GetSonucSure(NedenFormati.NormalCalisma);
}
return(servisTeknisyenler);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = $" = {ServisId}";
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT distinct
a.SERVISID,
(SELECT vtsx.partnercode FROM vt_servisler vtsx where vtsx.servisid = a.SERVISID and vtsx.dilkod = 'Turkish') as partnercode,
(SELECT vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = a.SERVISID) as servisad,
count(b.servisisemirid) as servisisemiridadedi,
to_number ( to_char(KAYITTARIH,'mm')) as ay,
to_char(KAYITTARIH, 'Month') as ayadi,
to_char(sysdate,'yyyy') as yil
FROM servisisemirler a
INNER JOIN servisisemirislemler b on a.id=b.servisisemirid
WHERE
b.isemirtipid=2 AND
a.servisid {servisIdQuery} AND
to_char(sysdate,'yyyy') = to_char(KAYITTARIH,'yyyy')
GROUP BY a.servisid, to_number ( to_char(KAYITTARIH,'mm')), to_char(KAYITTARIH, 'Month')
order by 5 desc
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
List <object> reportDataSource = new List <object>();
DataTable dtb = AppPool.EbaTestConnector.CreateQuery(@"
SELECT distinct
s.id,o.ad,s.isemirno,
to_char(s.kayittarih,'dd.mm.yyyy') tarih,
S.MUSTERIAD,
S.MUSTERITELEFON,
T.ISORTAKAD,
case when S.KULLANICIID is null then s.okullaniciid else s.kullaniciid end kullanici,
t.partnercode,
S.ARACTIPAD,
s.saseno,R.PLAKA,
CASE when O.FILOBUYUKLUKID is null then 1 else 0 end filo,h.servisisortakkontaktipad,no,h.ad kontakad
from sason.vt_servisler t,sason.servisisemirler s,sason.vt_servisisortaklar o ,sason.servisvarlikruhsatlar r ,sason.vw_isortakkontakbilgiler h
where O.SERVISISORTAKID =S.SERVISISORTAKID and s.servisid=t.servisid
and t.dilkod='Turkish' and S.SASENO=R.SASENO
and s.kayittarih between {StartDate} and {FinishDate}
and t.dilkod=o.dilkod
and (s.servisid = {ServisId} or {ServisId} = 1)
and O.SERVISISORTAKID=h.servisisortakid(+)
and (h.servisisortakkontaktipid=6 or h.servisisortakkontaktipid is null)
")
.Parameter("StartDate", StartDate.Date)
.Parameter("FinishDate", FinishDate.endOfDay())
.Parameter("ServisId", ServisId)
.GetDataTable(refMr);
reportDataSource = dtb.ToModels(refMr);
CloseCustomAppPool();
return(reportDataSource);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
decimal selectedServisId = ServisIds.first().toString("0").cto <decimal>();
string servisIdQuery = $" = {selectedServisId}";
#if DEBUG
selectedServisId = ServisId;
servisIdQuery = $" = {selectedServisId}";
#endif
MethodReturn mr = new MethodReturn();
List <ReportData> reportDataSource = new List <ReportData>();
List <QueryResult> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
select * from (select * from sason.rptable_yedekparcadetay where servisid {servisIdQuery} and tarih between {{startDate}} AND {{finishDate}}) rpt
")
.Parameter("startDate", StartDate.startOfDay())
.Parameter("finishDate", FinishDate.endOfDay())
.GetDataTable(mr)
.ToModels <QueryResult>();
CloseCustomAppPool();
return(reportDataSource);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = "";
if (ServisIds.isNotEmpty())
{
servisIdQuery = $" in ({ServisIds.joinNumeric(",")}) ";
}
else
{
servisIdQuery = $" > 1 ";
}
List <object> reportDataSource = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
tarihler.tarih, tarihler.yil, tarihler.ay, servis.servisid, servis.isortakad SERVISISORTAKAD, servis.VARLIKAD SERVISVARLIKAD, ags.arac_giris, ags.isemir_acilan, ags.isemir_kapanan
FROM
(SELECT TARIH, YIL, AY FROM TARIHLER WHERE TARIH BETWEEN {{startDate}} AND {{finishDate}}) tarihler
left join vt_servisler servis on servis.servisid {servisIdQuery} and servis.dilkod = 'Turkish'
left join mobilags ags on AGS.SERVIS = servis.servisid and AGS.TARIH = tarihler.tarih
order by tarihler.tarih, servis.servisid
")
.Parameter("startDate", StartDate.startOfDay())
.Parameter("finishDate", FinishDate.endOfDay())
.GetDataTable()
.ToModels();
CloseCustomAppPool();
return(reportDataSource);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
decimal selectedServisId = ServisId;
string servisIdQuery = $" = {selectedServisId}";
// string dateQuery = "";
decimal selectedReceteId = ReceteIds.first().toString("0").cto <decimal>();
string receteIDQuery = $" = {selectedReceteId}";
if (ReceteIds.isNotEmpty())
{
receteIDQuery = $" in ({ReceteIds.joinNumeric(",")}) ";
}
else
{
selectedReceteId = 756;
receteIDQuery = $" in( {selectedReceteId} )";
}
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
(SELECT vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = b.SERVISID and vtsx.dilkod = 'Turkish') as partnercode,
(SELECT vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = b.SERVISID ) as servisad,
b.*,
stok-miktar fark,
case when stok-miktar > -1 then 0
when stok-miktar < 0 then (stok-miktar)*kurlar_pkg.malzemefiyatindgetir(malzemeid,1,2) end TUTAR
from (SELECT a.*,sason.servisstok(sason.getservisstokid(a.malzemeid,servisid)) stok from (
SELECT
l.gkod,
l.ad,
S.SERVISID,
l.malzemeid,
MAX (miktar) miktar,
b.ad birimad,
R.KOD
FROM (SELECT * from receteler where id {receteIDQuery} ) r,
servisreceteler s,
recetemalzemeler m,
mt_malzemeler l,
vw_birimler b
WHERE
r.id = m.receteid
AND S.RECETEID = r.id
AND m.birimid = b.id
and b.dilkod='Turkish'
and l.malzemeid=m.malzemeid
GROUP BY l.gkod, l.ad, l.malzemeid, s.servisid, b.ad ,R.KOD) a
where servisid {servisIdQuery} ) b
order by kod , ad
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
decimal selectedServisId = ServisIds.first().toString("0").cto <decimal>();
string servisIdQuery = $" = {selectedServisId}";
string dateQuery = "";
#if DEBUG
selectedServisId = ServisId;
servisIdQuery = $" in( {selectedServisId} )";
#endif
if (ServisIds.isNotEmpty())
{
servisIdQuery = $" in ({ServisIds.joinNumeric(",")}) ";
}
else
{
// servisIdQuery = $" > 1 ";
selectedServisId = ServisId;
servisIdQuery = $" in( {selectedServisId} )";
}
StartDate = StartDate.startOfDay();
FinishDate = FinishDate.endOfDay();
dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + "";
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
select
(select vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = a.servisid and vtsx.dilkod = 'Turkish') as partnercode,
(Select vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = a.servisid) as servisad,
a.faturaturid,
a.faturano,
a.islemtarihi,
a.cariunvan,
a.bruttoplam,
a.indirimtoplam,
a.netkdvtoplam,
a.nettutar,
a.toplam,
a.carikod,
a.vno,
a.servisid
FROM faturalar a
WHERE a.servisid {servisIdQuery}
and a.islemtarihi between '{dateQuery}'
and a.faturaturid=4
ORDER BY servisad ,a.islemtarihi desc
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = $" = {ServisId}";
string dateQuery = "";
//#if DEBUG
// selectedServisId = ServisId;
// servisIdQuery = $" in( {selectedServisId} )";
//#endif
StartDate = StartDate.startOfDay();
FinishDate = FinishDate.endOfDay();
dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + "";
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
ssip.SERVISID,
(select vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = ssip.SERVISID and vtsx.dilkod = 'Turkish') as partnercode,
(Select vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = ssip.SERVISID ) as servisad,
isortak.ad,
ssip.belgeno SIPARIS_NO,
ssip.tarih SIPARIS_TARIHI,
srvstok.kod PARCA_NO,
srvstok.ad PARCA_AD,
ssm.miktar,
tdrkneden.kod TEDARIK_NEDEN,
srvstok.kod ,
CASE WHEN orj.orjinalgkod IS NULL THEN srvstok.kod ELSE orj.orjinalgkod END orjinalkod
FROM servissiparismlzler ssm
INNER JOIN servissiparisler ssip ON ssip.id=SSM.SERVISSIPARISID AND SSIP.siparisSERVISID is null
INNER JOIN servisstoklar srvstok ON SSM.SERVISSTOKID=srvstok.id
INNER JOIN muadiltedariknedenler tdrkneden ON SSM.MUADILTEDARIKNEDENID = tdrkneden.id
INNER JOIN servisisortaklar isortak ON ssip.siparisisortakid=isortak.id
LEFT JOIN (SELECT m1.id malzemeid,
m1.kod,
m1.gkod,
m2.kod orjinalkod,
m2.gkod orjinalgkod,
m1.orjinalmalzemeid
FROM malzemeler m1, malzemeler m2
WHERE m1.orjinalmalzemeid = M2.ID) orj ON orj.malzemeid=SRVSTOK.MALZEMEID
WHERE
SSM.MUADILTEDARIKNEDENID is not null AND
ssip.SERVISID {servisIdQuery} AND
ssip.tarih between '{dateQuery}'
ORDER BY ssip.SERVISID ,ssip.tarih desc
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = "";
decimal selectedServisId = ServisIds.first().toString("0").cto <decimal>();
if (ServisIds.isNotEmpty())
{
servisIdQuery = $" in ({ServisIds.joinNumeric(",")}) ";
}
else
{
// servisIdQuery = $" > 1 ";
selectedServisId = ServisId;
servisIdQuery = $" in( {selectedServisId} )";
}
List <object> reportDataSource = AppPool.EbaTestConnector.CreateQuery($@"
select
--ie.id ISEMIR_ID,
srv.ISORTAKAD SERVIS_AD, srv.partnercode SERVIS_PARTNER_KOD,
ie.isemirno ISEMIR_NO, ie.KAYITTARIH ISEMIR_KAYITTARIHI, ie.TAMAMLANMATARIH ISEMIR_TAMAMLANMA_TARIHI, ie.saseno ISEMIR_SASENO
--,iei.ID ISEMIR_ISLEM_ID
,atip.kod GARANTI_KODU, atip.ad GARANTI_TIPI
,ay.ARIZAKODU AYR_ARIZAKODU, ay.CLAIMNO AYR_CLAIMNO, AY.ESAGARANTINO AYR_ESA_GARANTINO, AY.SERVISGARANTINO AYR_SERVIS_GARANTI_NO, AY.PDFGARANTINO AYR_PDF_GARANTI_NO
,mlz.KOD MALZEME_KODU, mlz.AD MALZEME_ADI, MLZ.MIKTAR MALZEME_MIKTAR, MLZ.BIRIM_AD MALZEME_BIRIM_AD
from (select * from servisisemirler where TAMAMLANMATARIH BETWEEN {{startDate}} AND {{finishDate}} and TEKNIKOLARAKTAMAMLA = 1 AND SERVISID {servisIdQuery}) ie
left join vt_servisler srv on srv.dilkod = 'Turkish' and srv.servisid = ie.servisid
-- AYRISTIRMA TIPLER
left join vw_ayristirmatipler atip on atip.id not in (1,2) and atip.dilkod = 'Turkish'
-- SERVIS ISEMIR ISLEMLER
left join servisisemirislemler iei on iei.servisisemirid = ie.id
-- AYRISTIRMALAR
inner join ayristirmalar ay on ay.ayristirmatipid = atip.id and AY.SERVISISEMIRISLEMID = iei.id
-- MALZEMELER
inner join (
select
a.id AYRISTIRMAID, 1 GROUPID, 'MALZEME' GROUPNAME, st.kod KOD, st.ad AD, ad.miktar MIKTAR, brm.ad BIRIM_AD, ad.gtutar TUTAR, AD.PDFMIKTAR, AD.PDFNETFIYAT, AD.PDFISLETIMUCRETI, AD.PDFONAYLANANYUZDE, AD.PDFTOPLAM, AD.PDFPARABIRIMID
from
ayristirmalar a, ayristirmadetaylar ad, servisismislemmalzemeler im, servisstoklar st, vw_birimler brm
where
AD.AYRISTIRMAID(+) = a.id
and ad.turid = 1 --malzeme
and im.id(+) = ad.referansid
and st.id(+)= im.servisstokid
and brm.id(+) = st.birimid and BRM.DILKOD(+) = 'Turkish'
) mlz on mlz.ayristirmaid = ay.ID
")
.Parameter("startDate", StartDate.startOfDay())
.Parameter("finishDate", FinishDate.endOfDay())
.GetDataTable()
.ToModels();
CloseCustomAppPool();
return(reportDataSource);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string dateQuery = "";
StartDate = StartDate.startOfDay();
FinishDate = FinishDate.endOfDay();
dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + "";
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
V.Ad,
A.Saseno,
Bgrup.Kod AS Bakim_Grubu,
Bst.Kod AS Sozlesme_Tipi,
Bksoz.Bastarih AS Baslangic_Tarihi,
Bksoz.Bittarih AS Bitis_Tarihi,
Bksoz.Bakimadedi,
Bksoz.Oncekibakimadedi,
Bksoz.Kullanilan,
Bksoz.Tutar,
Pb.Kod ,
(CASE
WHEN Bksoz.Durumid=1 THEN 'AKTIF'
ELSE 'PASIF'
END) AS Sozlesme_Durum,
Bksoz.Km,
Bksoz.Saat,
Bksoz.Litre
FROM
Bakimsozlesmeler Bksoz,
Bakimgruplar Bgrup,
Araclar A,
Bakimsozlesmetipler Bst,
Varliklar V,
Parabirimler Pb
WHERE
Bksoz.Bakimgrupid=Bgrup.Id AND
A.Id=Bksoz.Aracid AND
Bksoz.Bakimsozlesmetipid=Bst.Id AND
Bksoz.Varlikid=V.Id AND
Pb.Id=Bksoz.Parabirimid AND
(A.Saseno = NVL('{SaseNo}', A.Saseno)) AND
Bksoz.Bastarih BETWEEN '{dateQuery}'
ORDER BY Bksoz.Id DESC
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public static void ModifyDepolar(MethodReturn refMr, decimal servisId, List <string> depolar)
{
foreach (string depo in depolar)
{
CheckAndGetDefaultDepo(refMr, servisId, depo);
if (refMr.error())
{
break;
}
}
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = "";
if (ServisIds.isNotEmpty())
{
servisIdQuery = $"in ({ServisIds.joinNumeric(",")})";
}
else
{
servisIdQuery = $">1";
}
List <ReportData> reportDataSource = new List <ReportData>();
List <RowData> rowDataSource = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
tarihler.tarih, servis.PARTNERCODE, servis.servisid, servis.isortakad SERVISISORTAKAD, servis.VARLIKAD SERVISVARLIKAD, ags.arac_giris, ags.isemir_acilan, ags.isemir_kapanan
FROM
(SELECT TARIH, YIL, AY FROM TARIHLER WHERE TARIH BETWEEN {{startDate}} AND {{finishDate}}) tarihler
left join vt_servisler servis on servis.servisid {servisIdQuery} and servis.dilkod = 'Turkish'
left join mobilags ags on AGS.SERVIS = servis.servisid and AGS.TARIH = tarihler.tarih
order by tarihler.tarih, servis.servisid
")
.Parameter("startDate", StartDate.startOfDay())
.Parameter("finishDate", FinishDate.endOfDay())
.GetDataTable()
.ToModels <RowData>();
foreach (RowData data in rowDataSource)
{
int ay = data.TARIH.Month;
int yil = data.TARIH.Year;
ReportData reportData = reportDataSource.first(t => t.ServisId == data.SERVISID && t.Yil == yil);
if (reportData.isNull())
{
reportData = new ReportData()
{
PartnerCode = data.PARTNERCODE,
ServisId = data.SERVISID,
ServisAdi = data.SERVISISORTAKAD,
ServisVarlikAdi = data.SERVISVARLIKAD,
Yil = data.TARIH.Year,
};
reportDataSource.add(reportData);
}
reportData.SetPropertyValue($"AIS{ay}", reportData.GetPropertyValue <decimal>($"AIS{ay}") + data.ISEMIR_ACILAN);
reportData.SetPropertyValue($"KIS{ay}", reportData.GetPropertyValue <decimal>($"KIS{ay}") + data.ISEMIR_KAPANAN);
reportData.SetPropertyValue($"AGS{ay}", reportData.GetPropertyValue <decimal>($"AGS{ay}") + data.ARAC_GIRIS);
}
CloseCustomAppPool();
return(reportDataSource);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
decimal selectedServisId = ServisIds.first().toString("0").cto <decimal>();
string servisIdQuery = $" = {selectedServisId}";
#if DEBUG
selectedServisId = ServisId;
servisIdQuery = $" = {selectedServisId}";
#endif
if (ServisIds.isNotEmpty())
{
servisIdQuery = $" in ({ServisIds.joinNumeric(",")}) ";
}
else
{
// servisIdQuery = $" > 1 ";
selectedServisId = ServisId;
servisIdQuery = $" in( {selectedServisId} )";
}
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT vt.isortakad servis_adi,
vt.partnercode servis_kodu,
a.isemirno,
a.tamamlanmatarih,
sv.ad musteri_adi,
a.tutar
FROM servisisemirler a,
servisvarliklar sv,
vt_servisler vt
WHERE a.servisid {servisIdQuery} AND
a.teknikolaraktamamla=1
AND vt.servisid=a.servisid
AND vt.dilkod='Turkish'
AND a.tutar>0
AND a.servisvarlikid=sv.id
AND a.isemirno not in
(SELECT DISTINCT isemirno
FROM ayristirmalar)
ORDER BY vt.servisid ASC, a.tamamlanmatarih DESC
")
.GetDataTable()
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string dateQuery = "";
StartDate = StartDate.startOfDay();
FinishDate = FinishDate.endOfDay();
dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + "";
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT EXTRECALLNUM AS HARICI_NO,
INTRECALLNUM AS DAHLI_NO,
WARRANTYCLAIMTYPE AS GARANTI_TIPI,
REFDATE AS BASLANGIC_TARIHI,
RECALLVALIDTO AS BITIS_TARIHI,
WARRANTYCLAIMNUM AS GARANTI_NUMARASI,
--TXTTABLECOUNTER,
DocAppendix AS DOKUMAN_LINKI,
DamageCode AS ARIZA_KODU,
SIShortText AS KISA_ACIKLAMA,
--WarrantyClaimType,
Priority AS ONCELIK
FROM MX_VIS_SERVICEINFODETAILS a
WHERE refdate IS NOT NULL and
extrecallnum not in (SELECT refaksiyonid FROM aksiyonlar WHERE refaksiyonid is not null)
GROUP BY EXTRECALLNUM,
INTRECALLNUM,
WARRANTYCLAIMTYPE,
REFDATE,
RECALLVALIDTO,
WARRANTYCLAIMNUM,
TXTTABLECOUNTER,
DocAppendix,
DamageCode,
SIShortText,
WarrantyClaimType,
Priority
ORDER BY 1 DESC
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = $" = {ServisId}";
string dateQuery = "";
#if DEBUG
servisIdQuery = $" = {ServisId}";
#endif
StartDate = StartDate.startOfDay();
FinishDate = FinishDate.endOfDay();
dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + "";
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT SUM(AIES) AS AIES , sum(KIES) AS KIES , servisid, partnercode , servisad , KAYITTARIH
FROM (
SELECT max(acikadet) as AIES,
max(kapanan_adet) as KIES,
servisid,
(SELECT vtsx.partnercode from vt_servisler vtsx WHERE vtsx.servisid = dsf.servisid and vtsx.dilkod = 'Turkish') as partnercode,
(SELECT vtsxy.ISORTAKAD FROM vt_servisler vtsxy WHERE vtsxy.dilkod = 'Turkish' and vtsxy.servisid = dsf.servisid) as servisad,
to_char(KAYITTARIH,'dd/mm/yyyy') as KAYITTARIH
FROM
(SELECT count(id) acikadet,null kapanan_adet ,servisid,KAYITTARIH
FROM servisisemirler
WHERE
KAYITTARIH BETWEEN '{dateQuery}' AND
servisid {servisIdQuery}
group by servisid,KAYITTARIH
union all
SELECT null acikadet ,count(id)kapanan_adet,servisid,TAMAMLANMATARIH
FROM servisisemirler
WHERE
TAMAMLANMATARIH BETWEEN '{dateQuery}' AND
servisid {servisIdQuery}
group by servisid,TAMAMLANMATARIH) dsf
group by servisid,KAYITTARIH
)
GROUP BY servisid, partnercode , servisad , KAYITTARIH
order by servisid,to_date(KAYITTARIH) desc
")
.GetDataTable()
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = $" = {ServisId}";
string dateQuery = "";
StartDate = StartDate.startOfDay();
FinishDate = FinishDate.endOfDay();
dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + "";
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
(SELECT vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = d.servisid and vtsx.dilkod = 'Turkish') as partnercode,
(SELECT vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = d.servisid) as servisad,
f.netkdvtoplam,
f.nettutar,
f.netkdvtoplam+f.nettutar toplam,
D.FATURANO,
D.SERVISID,
D.SERVISISEMIRID,
D.SERVISISORTAKID,
F.ACIKLAMA,
F.ADRES,
F.BRUTTOPLAM,
F.CARIUNVAN,
F.IL,
F.ILCE,
F.VERGIDAIRESI,
F.VNO,
F.ILGILIKISI,
F.ILGILIKISITELNO,
F.IRSALIYENO,
to_char(F.IRSALIYETARIHI,'dd/mm/yyyy') as IRSALIYETARIHI,
F.ISLEMTARIHI,
(SELECT zx.ISEMIRNO FROM servisisemirler zx where zx.id = d.SERVISISEMIRID) as ISEMIRNO
FROM sason.servisdishizmetalimlar d, sason.faturalar f
WHERE
d.faturaid = f.id AND
F.ISLEMTARIHI BETWEEN '{dateQuery}' AND
d.servisid {servisIdQuery}
ORDER BY F.islemtarihi desc
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public MethodReturn DeserializeMethodReturn(byte[] input, Type returnType)
{
JToken t;
JObject obj = this.ToJsonObject(input);
MethodReturn methodReturn = new MethodReturn();
if (obj.TryGetValue("ReturnValue", out t))
methodReturn.ReturnValue = t.ToObject(returnType, jsonSerializer);
var ex = obj.TryGetValue("Exception", out t) ? t.ToObject<string>() : null;
if (!string.IsNullOrEmpty(ex))
methodReturn.Exception = new Exception(ex);
return methodReturn;
}
public override object ExecuteReport(MethodReturn refMr = null)
{
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
a.SERVISID,
MAX(a.id) maxid,
b.teknisyenid,
a.giristarihi,
a.CIKISTARIHI,
a.ISEMIRISLEMID,
a.ISEMIRID,
concat(concat(c.ad,' ') ,c.soyad) as adsoyad,
sse.ISEMIRNO,
sse.SASENO,
sse.plaka,
SSE.KAYITTARIH,
SSE.MUSTERIAD,
CASE
WHEN a.CIKISTARIHI > '01.01.2000' THEN cast(EXTRACT(MINUTE FROM (a.CIKISTARIHI - a.giristarihi) DAY TO SECOND)|| ' dk ' as NVARCHAR2(50))
ELSE cast('Devam Ediyor...'as NVARCHAR2(50)) END as Durum,
(SELECT isem.aciklama FROM servisisemirler isem WHERE isem.id = a.ISEMIRID) as emir,
(SELECT isemis.aciklama FROM servisisemirislemler isemis WHERE isemis.id = (SELECT isemx.id FROM servisisemirler isemx WHERE isemx.id = a.ISEMIRID )) as islem
FROM teknisyenhareket a
INNER JOIN servisteknisyenler b ON b.servisid = a.servisid and b.id = a.servisteknisyenid
INNER JOIN teknisyenler c ON c.id = b.teknisyenid
INNER JOIN THRKNEDEN d ON d.id = a.girisnedenid
INNER JOIN THRKNEDEN dx ON dx.id = a.cikisnedenid
INNER JOIN servisisemirler sse ON sse.id = a.ISEMIRID
WHERE
a.SERVISID = {{ServisId}} and
a.id = (SELECT MAX(xx.id) FROM teknisyenhareket xx WHERE xx.servisteknisyenid = a.servisteknisyenid)
GROUP BY a.SERVISID, a.id, b.teknisyenid, a.giristarihi, a.CIKISTARIHI, A.ISEMIRISLEMID, a.ISEMIRID, c.ad, c.soyad, sse.ISEMIRNO, sse.SASENO, sse.plaka, SSE.KAYITTARIH, SSE.MUSTERIAD
ORDER BY a.SERVISID, c.ad, c.soyad, a.id DESC
")
.Parameter("ServisId", ServisId)
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public static List <Teknisyen_ViewServisIsEmirIslemler> Select_IsEmir_Islemler_View(decimal ownerIsEmirId, decimal servisTeknisyenId)
{
MethodReturn mr = new MethodReturn();
List <Teknisyen_ViewServisIsEmirIslemler> servisIsEmirIslemler = R.Query <Teknisyen_ViewServisIsEmirIslemler>(mr).Where(t => t.SERVISISEMIRID == ownerIsEmirId).ToList();
List <HareketUstBilgi> isEmir_UstHareketBilgileri = HareketUstBilgi.Select_IsEmir_UstHareketBilgileri(ownerIsEmirId, mr);
List <TeknisyenHareket> isEmir_TeknisyenHareketleri = TeknisyenHareket.Select_IsEmir_TeknisyenHareketleri(ownerIsEmirId, mr);
List <Teknisyen_ViewServisIsEmirIslemIscilikler> isEmir_Iscilikleri = Teknisyen_ViewServisIsEmirIslemIscilikler.Select_IsEmir_Iscilikleri(ownerIsEmirId);
decimal servisId = isEmir_UstHareketBilgileri.first().SERVISID;
List <ServisGunMola> servis_gun_molalar = ServisGunMola.SelectServisGunMolalar(servisId);
List <HareketNeden> nedenler = HareketNeden.Select_Nedenler();
PuantajGunlugu pg = new PuantajGunlugu();
pg.InitNedenler(nedenler);
servisIsEmirIslemler.forEach(islem =>
{
List <HareketUstBilgi> islem_UstBilgileri = isEmir_UstHareketBilgileri.where (t => t.ISEMIRISLEMID == islem.ID).toList();
List <TeknisyenHareket> islem_TeknisyenHareketleri = null;
List <TeknisyenHareket> servisTeknisyenHareketleri = null;
islem.TeknisyenIsDurumu = LocalHelpers.GetTeknisyenDurum(servisTeknisyenId, isEmir_TeknisyenHareketleri, islem_UstBilgileri, out islem_TeknisyenHareketleri, out servisTeknisyenHareketleri);;
var iscilikler = isEmir_Iscilikleri.where (t => t.SERVISISEMIRISLEMID == islem.ID).toList();
islem.ToplamIscilikSayisi = iscilikler.count();
if (islem_TeknisyenHareketleri.isNotEmpty())
{
islem.CalisilanSure = servisTeknisyenHareketleri.Sum(t => t.CalismaDakika);
}
if (islem_UstBilgileri.isNotEmpty())
{
islem.PlanlananSure = islem_UstBilgileri.Sum(t => t.PLANLANANSURE);
}
TeknisyenHareketDagilimSonuclari puantajSonuclari = Puantaj.GetPuantajSonuclari(islem_TeknisyenHareketleri, pg, servis_gun_molalar, nedenler);
islem.CalisilanSure = puantajSonuclari.GetSonucSure(NedenFormati.NormalCalisma);
islem.TeknisyenSure = puantajSonuclari.GetSonucSure(servisTeknisyenId, NedenFormati.NormalCalisma);
});
return(servisIsEmirIslemler);
}
public override void HandleMethodCall(MethodCall method_call)
{
//object retVal = obj.GetType ().InvokeMember (method_call.Member, BindingFlags.InvokeMethod, null, obj, new object[0]);
//IDynamicMetaObjectProvider idyn = obj as IDynamicMetaObjectProvider;
object retVal = null;
Exception raisedException = null;
try {
object[] args = MessageHelper.GetDynamicValues (method_call.message);
retVal = ops.InvokeMember (obj, method_call.Member, args);
//retVal = ops.Call (ops.GetMember (obj, method_call.Member), args);
} catch (Exception e) {
raisedException = e;
}
if (!method_call.message.ReplyExpected)
return;
Message msg = method_call.message;
Message replyMsg = null;
if (raisedException == null) {
MethodReturn method_return = new MethodReturn (msg.Header.Serial);
replyMsg = method_return.message;
if (retVal != null) {
if (retVal.GetType ().FullName == "IronRuby.Builtins.MutableString")
retVal = retVal.ToString ();
// TODO: Invalid sig handling
Signature outSig = Signature.GetSig (retVal.GetType ());
MessageWriter retWriter = new MessageWriter ();
retWriter.Write (retVal.GetType (), retVal);
//retWriter.WriteValueType (retVal, retVal.GetType ());
replyMsg.Body = retWriter.ToArray ();
replyMsg.Signature = outSig;
}
} else {
Error error = method_call.CreateError (Mapper.GetInterfaceName (raisedException.GetType ()), raisedException.Message);
replyMsg = error.message;
}
if (method_call.Sender != null)
replyMsg.Header[FieldCode.Destination] = method_call.Sender;
conn.Send (replyMsg);
}
public static SERVISDEPOLAR CheckAndGetDefaultDepo(MethodReturn refMr, decimal servisId, string depoAdi = "")
{
refMr = refMr.createIsNull();
string writeDepoKodu = "001";
string writeDepoAdi = "Ana Depo";
SERVISDEPOLAR defaultDepo = null;
if (depoAdi.isNullOrWhiteSpace())
{
defaultDepo = Select.OrderBy(t => t.KOD).First(t => t.SERVISID == servisId);
}
else
{
writeDepoKodu = depoAdi;
writeDepoAdi = depoAdi;
defaultDepo = Select.First(t => t.AD == writeDepoAdi && t.SERVISID == servisId);
}
if (defaultDepo.isNull())
{
decimal seqId = Convert.ToDecimal(SasonBaseApplicationPool.Get.EbaTestConnector.ExecuteScalar("select SERVISDEPOLAR_SEQ.NEXTVAL from dual", refMr));
if (refMr.ok())
{
defaultDepo = new SERVISDEPOLAR()
{
ID = seqId,
KOD = writeDepoKodu, // "001",
AD = writeDepoAdi, // "Ana Depo",
SERVISDEPOGRUPID = null,
DEPOTIPID = 0,
RAFSIZ = 0,
DURUMID = 1,
SERVISID = servisId,
};
refMr = defaultDepo.Update();
}
if (refMr.error())
{
defaultDepo = null;
}
}
return(defaultDepo);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = $" = {ServisId}";
string dateQuery = "";
StartDate = StartDate.startOfDay();
FinishDate = FinishDate.endOfDay();
dateQuery = "" + StartDate.ToString("dd/MM/yyyy") + "' AND '" + FinishDate.ToString("dd/MM/yyyy") + "";
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
DISTINCT b.servisid,
(select vtsx.partnercode from vt_servisler vtsx where vtsx.servisid = b.servisid and vtsx.dilkod = 'Turkish') as partnercode,
(Select vtsxy.ISORTAKAD FROM vt_servisler vtsxy where vtsxy.dilkod = 'Turkish' and vtsxy.servisid = b.servisid) as servisad,
d.kod,
d.ad,
a.miktar,
br.ad BIRIM,
A.BIRIMFIYAT ALIS_FIYATI,
b.TARIH,
f.faturano,
KURLAR_PKG.CAPRAZKURTARIH (2, 1, b.TARIH) kur,
kurlar_pkg.servisstokfiyatgetir (d.id, 2, TRUNC (SYSDATE)) as EUROLISTEFIYAT,
KURLAR_PKG.STOKFIYATINDGETIR (d.id, 2, 2, 1,0) as EUROINDFIYAT
FROM servisstokhareketdetaylar a
INNER JOIN servisstokhareketler b on B.ID = A.SERVISSTOKHAREKETID and b.parabirimid=1
INNER JOIN servissiparisler c on c.id=b.servissiparisid and c.siparisservisid=1
INNER JOIN servisstoklar d on d.id = A.SERVISSTOKID
INNER JOIN faturalar f on f.id=b.faturaid
INNER JOIN vw_birimler br on br.id=a.birimid and br.dilkod='Turkish'
INNER JOIN servisdeporaflar dr ON d.servisdeporafid = dr.id
INNER JOIN servisstokturler sst ON sst.id = d.servisstokturid
WHERE
a.stokislemtipdeger=1 and
b.servisid {servisIdQuery} AND
b.TARIH between '{dateQuery}'
ORDER BY b.servisid , b.TARIH desc
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
decimal selectedBakimTuruId = BakimTuruIds.first().toString("0").cto <decimal>();
string bakimTuruIdQuery = $" = {selectedBakimTuruId}";
if (BakimTuruIds.isNotEmpty())
{
bakimTuruIdQuery = $" in ({BakimTuruIds.joinNumeric(",")}) ";
}
else
{
selectedBakimTuruId = 21;
bakimTuruIdQuery = $" in( {selectedBakimTuruId} )";
}
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
bgrup.ID,
bgrup.kod,
klm.ad KONTROL_TALIMATI,
klm.durumad DURUM,
knt.sure,
knt.periyot KONTROL_PERIYODU,
bgrup.endeks,
bgrup.kilometre,
bgrup.saat,
BGRUP.GUN
FROM bakimgrupkontroller knt, bakimgruplar bgrup, vw_BAKIMKONTROLKALEMLER klm
WHERE
KNT.BAKIMGRUPID=bgrup.id and
KNT.BAKIMKONTROLKALEMID = klm.id and
KNT.DURUMID = 1 AND
klm.dilkod='Turkish' AND
bgrup.ID {bakimTuruIdQuery}
ORDER BY bgrup.kod, klm.ad
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public static List <Teknisyen_ViewServisIsEmirler> Select_Servis_IsEmirler_View(decimal servisId, decimal servisTeknisyenId)
{
MethodReturn mr = new MethodReturn();
List <Teknisyen_ViewServisIsEmirler> servis_IsEmirleri = R.Query <Teknisyen_ViewServisIsEmirler>().Where(t => t.SERVISID == servisId && t.TEKNIKOLARAKTAMAMLA == 0).ToList();
List <decimal> isEmirIds = servis_IsEmirleri.select(t => t.ID).ToList();
List <HareketUstBilgi> servis_UstHareketBilgileri = HareketUstBilgi.Select_IsEmirler_UstHareketBilgileri(isEmirIds);
List <TeknisyenHareket> servis_TeknisyenHareketleri = TeknisyenHareket.Select_IsEmirler_TeknisyenHareketleri(isEmirIds);
List <Teknisyen_ViewServisIsEmirIslemler> servis_IsEmirIslemleri = Teknisyen_ViewServisIsEmirIslemler.Select_IsEmirler_Islemler(isEmirIds);
List <Teknisyen_ViewServisIsEmirIslemIscilikler> servis_IsEmirIslem_Iscilikleri = Teknisyen_ViewServisIsEmirIslemIscilikler.Select_IsEmirler_Iscilikleri(isEmirIds);
List <ServisGunMola> servis_Gun_Molalar = ServisGunMola.SelectServisGunMolalar(servisId);
List <HareketNeden> nedenler = HareketNeden.Select_Nedenler();
PuantajGunlugu pg = new PuantajGunlugu();
pg.InitNedenler(nedenler);
servis_IsEmirleri.forEach(isemir =>
{
List <HareketUstBilgi> isEmir_ustBilgileri = servis_UstHareketBilgileri.Where(t => t.ISEMIRID == isemir.ID).toList();
List <TeknisyenHareket> isEmir_TeknisyenHareketleri = null;
List <TeknisyenHareket> servisTeknisyenHareketleri = null;
isemir.TeknisyenIsDurumu = LocalHelpers.GetTeknisyenDurum(servisTeknisyenId, servis_TeknisyenHareketleri, isEmir_ustBilgileri, out isEmir_TeknisyenHareketleri, out servisTeknisyenHareketleri);
if (isEmir_TeknisyenHareketleri.isNotEmpty())
{
isemir.IlkHareketTarihi = isEmir_TeknisyenHareketleri.Min(t => t.GIRISTARIHI);
isemir.SonHareketTarihi = isEmir_TeknisyenHareketleri.OrderByDescending(t => t.GIRISTARIHI).first().AktifCikisTarih;
}
if (isEmir_ustBilgileri.isNotEmpty())
{
isemir.PlanlananSure = isEmir_ustBilgileri.Sum(t => t.PLANLANANSURE);
}
TeknisyenHareketDagilimSonuclari puantajSonuclari = Puantaj.GetPuantajSonuclari(isEmir_TeknisyenHareketleri, pg, servis_Gun_Molalar, nedenler);
isemir.CalisilanSure = puantajSonuclari.GetSonucSure(NedenFormati.NormalCalisma);// isEmir_TeknisyenHareketleri.Sum(t => t.CalismaDakika);
isemir.TeknisyenSure = puantajSonuclari.GetSonucSure(servisTeknisyenId, NedenFormati.NormalCalisma);
});
return(servis_IsEmirleri.orderByDesc(t => t.TeknisyenDurumResim).toList());
}
public async Task <IMethodInvocationResult> InterceptAsync(IAsyncMethodInvocation methodInvocation)
{
// BEFORE the target method execution
var methodInput = CreateMethodInput(methodInvocation);
var(msgInputLog, correlationState) = _methodLogMessageFactory.CreateInputMethodLogMessage(methodInput);
_logger.Info(msgInputLog);
try
{
// Yield to the next module in the pipeline
var result = await methodInvocation.InvokeNextAsync().ConfigureAwait(false);
// AFTER the target method execution
var methodReturn = new MethodReturn {
ReturnValue = result.ReturnValue
};
if (methodInvocation.ActualReturnType.Name == "Void")
{
methodReturn.ReturnValue = "Void";
}
var msgOutputLog = _methodLogMessageFactory.CreateOutputMethodLogMessage(methodReturn, correlationState);
_logger.Info(msgOutputLog);
return(result);
}
catch (Exception e)
{
var methodReturn = new MethodReturn {
Exception = e
};
var msgOutputLog = _methodLogMessageFactory.CreateOutputMethodLogMessage(methodReturn, correlationState);
_logger.Error(msgOutputLog);
throw;
}
}
public override object ExecuteReport(MethodReturn refMr = null)
{
// string dateQuery = "";
decimal selectedAgretaId = AgretaIds.first().toString("0").cto <decimal>();
string agretaIdQuery = $" = {selectedAgretaId}";
if (AgretaIds.isNotEmpty())
{
agretaIdQuery = $" in ({AgretaIds.joinNumeric(",")}) ";
}
else
{
selectedAgretaId = 4;
agretaIdQuery = $" in( {selectedAgretaId} )";
}
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
AGR.AD AGREGA_ADI,
Q.AD AGREGA_OZELLIK,
T.AD AGREGA_TIPI,
TIP.DEGER KULLANILACAK_DEGER
FROM VW_AGREGATIPLER T
LEFT JOIN vw_agregalar agr ON T.AGREGAID = AGR.ID
LEFT JOIN AGREGATIPOZELLIKLER tip ON TIP.AGREGATIPID= t.id
LEFT JOIN vw_AGREGAOZELLIKLER q ON Q.ID= TIP.AGREGAOZELLIKID
WHERE
agr.dilkod='Turkish' and
Q.DILKOD = 'Turkish' and
t.dilkod = 'Turkish' AND
AGR.ID {agretaIdQuery}
ORDER BY AGR.AD ,Q.AD , T.AD
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT DISTINCT vm.vin as SASE_NO,
vm.vehiclenum as KISA_SASE,
SVR.PLAKA as PLAKA,
vm.modelnum ARAC_MODEL,
vm.variant VARYANT,
vm.exworksdate FABRIKA_CIKIS_TARIHI,
vm.firstregdate TRAFIGE_CIKIS_TARIHI,
vm.vehicleregdate RUHSAT_TARIHI,
vm.lastvisitdate SON_SERVIS_ZIYARET_TARIHI,
vm.wheelstrack,
vm.overhang,
vm.doorkeynum KAPI_KILIT_NUMARASI,
vm.vehicledes ARAC_TIP_VARYANT,
vm.vehicledescavis ARAC_TIPI,
vm.vehicletype ARAC_TIPI,
vm.motbr MOTOR_TIPI,
vm.schadstkl MOTOR_NORMU,
vm.vehiclekm ARAC_KM,
vm.assetmanuf URETICI
FROM
VX_VIS_VEHICLEMASTER vm,
servisvarlikruhsatlar svr,
esaaraclar ea
WHERE
vm.vin is not null and
vm.vin=svr.saseno and
EA.ID=VM.ESAARACID and
(ea.vin = NVL ('{SaseNo}', ea.vin))
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
List <object> reportDataSource = new List <object>();
DataTable dtb = AppPool.EbaTestConnector.CreateQuery(@"
select a.*,b.kod
from sason.faturalar a,sason.faturaturler b
where a.servisid = {ServisId}
and a.islemtarihi between {StartDate} and {FinishDate}
and a.faturaturid=4
and a.faturaturid=b.id
")
.Parameter("StartDate", StartDate.Date)
.Parameter("FinishDate", FinishDate.endOfDay())
.Parameter("ServisId", ServisId)
.GetDataTable(refMr);
reportDataSource = dtb.ToModels(refMr);
CloseCustomAppPool();
return(reportDataSource);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
string servisIdQuery = $" = {ServisId}";
//#if DEBUG
// selectedServisId = ServisId;
// servisIdQuery = $" in( {selectedServisId} )";
//#endif
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT vt.isortakad servis_adi,
vt.partnercode servis_kodu,
a.isemirno,
a.tamamlanmatarih,
sv.ad musteri_adi,
a.tutar
FROM servisisemirler a,
servisvarliklar sv,
vt_servisler vt
WHERE a.servisid {servisIdQuery} AND
a.teknikolaraktamamla=1
AND vt.servisid=a.servisid
AND vt.dilkod='Turkish'
AND a.tutar>0
AND a.servisvarlikid=sv.id
AND a.isemirno not in
(SELECT DISTINCT isemirno
FROM ayristirmalar)
ORDER BY vt.servisid ASC, a.tamamlanmatarih DESC
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
decimal selectedBakimTuruId = BakimTuruIds.first().toString("0").cto <decimal>();
string bakimTuruIdQuery = $" = {selectedBakimTuruId}";
if (BakimTuruIds.isNotEmpty())
{
bakimTuruIdQuery = $" in ({BakimTuruIds.joinNumeric(",")}) ";
}
else
{
selectedBakimTuruId = 40;
bakimTuruIdQuery = $" in( {selectedBakimTuruId} )";
}
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT DISTINCT
a.saseno,
a.bakimgrupkod BAKIM_GRUBU ,
a.bakimgrupad BAKIM_GRUBU_ADI,
a.bakimturkod BAKIM_KONTROL_TURU,
a.endeks,
a.kilometre,
a.endeks LITRE,
a.saat,
a.gun
FROM mt_aracbakimgruplar a
INNER JOIN bakimgruplar b on b.kod = a.bakimgrupkod
WHERE saseno = NVL ('{SaseNo}', a.saseno) AND
b.id {bakimTuruIdQuery}
ORDER BY a.bakimgrupkod, a.bakimgrupad
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public override object ExecuteReport(MethodReturn refMr = null)
{
// string dateQuery = "";
decimal selectedAgretaId = AgretaIds.first().toString("0").cto <decimal>();
string agretaIdQuery = $" = {selectedAgretaId}";
if (AgretaIds.isNotEmpty())
{
agretaIdQuery = $" in ({AgretaIds.joinNumeric(",")}) ";
}
else
{
selectedAgretaId = 4;
agretaIdQuery = $" in( {selectedAgretaId} )";
}
MethodReturn mr = new MethodReturn();
List <object> queryResults = AppPool.EbaTestConnector.CreateQuery($@"
SELECT
AGR.ID,
AGR.AD AGREGA_ADI,
t.kod AGREGA_KODU,
T.AD AGREGA_TIPI,
t.durumad DURUM
FROM vw_agregalar agr, VW_AGREGATIPLER t
WHERE
T.AGREGAID = AGR.ID AND
AGR.ID {agretaIdQuery} AND
agr.dilkod='Turkish' AND
t.dilkod = 'Turkish'
ORDER BY 1 DESC
")
.GetDataTable(mr)
.ToModels();
CloseCustomAppPool();
return(queryResults);
}
public byte[] SerializeMethodReturn(MethodReturn methodReturn)
{
var wrapper = new MethodReturnWrapper();
wrapper.ReturnValue = methodReturn.ReturnValue;
wrapper.Exception = methodReturn.Exception != null ?
methodReturn.Exception.Message :
null;
return this.ToJsonBytes(wrapper);
}
public static Message ConstructReply(MethodCall method_call, params object[] vals)
{
MethodReturn method_return = new MethodReturn (method_call.message.Header.Serial);
Message replyMsg = method_return.message;
Signature inSig = Signature.GetSig (vals);
if (vals != null && vals.Length != 0) {
MessageWriter writer = new MessageWriter (Connection.NativeEndianness);
foreach (object arg in vals)
writer.Write (arg.GetType (), arg);
replyMsg.Body = writer.ToArray ();
}
//TODO: we should be more strict here, but this fallback was added as a quick fix for p2p
if (method_call.Sender != null)
replyMsg.Header[FieldCode.Destination] = method_call.Sender;
replyMsg.Signature = inSig;
//replyMsg.WriteHeader ();
return replyMsg;
}
public static Message ConstructDynamicReply(MethodCall method_call, MethodInfo mi, object retVal, object[] vals)
{
Type retType = mi.ReturnType;
MethodReturn method_return = new MethodReturn (method_call.message.Header.Serial);
Message replyMsg = method_return.message;
Signature outSig = Signature.GetSig (retType);
outSig += Signature.GetSig (Mapper.GetTypes (ArgDirection.Out, mi.GetParameters ()));
if (outSig != Signature.Empty) {
MessageWriter writer = new MessageWriter (Connection.NativeEndianness);
//first write the return value, if any
if (retType != null && retType != typeof (void))
writer.Write (retType, retVal);
//then write the out args
WriteDynamicValues (writer, mi.GetParameters (), vals);
replyMsg.Body = writer.ToArray ();
}
//TODO: we should be more strict here, but this fallback was added as a quick fix for p2p
if (method_call.Sender != null)
replyMsg.Header[FieldCode.Destination] = method_call.Sender;
replyMsg.Signature = outSig;
return replyMsg;
}
