public Reporter()
{
SasonBaseApplicationPool sasonBaseApplicationPool = AppPool;
}
public static MethodReturn RepairTRCeviri(string tableName, string columnName, decimal ownerId, string dilKarsiligiDeger)
{
//exec ceviri_pkg.ekle2 (0, 'BAKIMDEGISIMKALEMLER', 'AD', 676, 'Alçak basýnç Gaz Tahliye Hortumu', 'Turkish');
MethodReturn mr = new MethodReturn();
SasonBaseApplicationPool appPool = SasonBaseApplicationPool.Get;
DataTable dtb = appPool.EbaTestConnector.GetDataTable($@"SELECT CEV.ID AS CEVIRILER_ID, LID.ID AS LISTELER_ID, LAID.ID AS LISTEALAN_ID FROM
(SELECT ID FROM LISTELER WHERE KOD = '{tableName}') LID
LEFT JOIN LISTEALANLAR LAID ON LAID.LISTEID = LID.ID AND LAID.KOD = '{columnName}'
LEFT JOIN CEVIRILER CEV ON CEV.LISTEALANID = LAID.ID AND CEV.DILID = 0 AND CEV.ALANID = {ownerId}", mr);
decimal ceviriId = 0;
decimal listeAlanId = 0;
if (dtb.IsNotEmpty())
{
ceviriId = dtb.FirstRow()["CEVIRILER_ID"].cto <decimal>();
listeAlanId = dtb.FirstRow()["LISTEALAN_ID"].cto <decimal>();
}
else
{
return(mr);
}
if (mr.ok())
{
CEVIRILER ceviri = Select.First(t => t.ID == ceviriId);
if (ceviri.isNull())
{
decimal seqId = Convert.ToDecimal(appPool.EbaTestConnector.ExecuteScalar("select CEVIRILER_SEQ.NEXTVAL from dual", mr));
if (mr.ok())
{
ceviri = new CEVIRILER()
{
ID = seqId,
LISTEALANID = listeAlanId,
DILID = 0,
ALANID = ownerId,
};
}
}
ceviri.DEGER = dilKarsiligiDeger;
if (mr.ok())
{
mr = ceviri.Update();
}
}
return(mr);
/*
* SELECT
* CEV.ID
* FROM
* (SELECT ID FROM LISTELER WHERE KOD = 'BAKIMDEGISIMKALEMLER') LID
* LEFT JOIN LISTEALANLAR LAID ON LAID.LISTEID = LID.ID AND LAID.KOD = 'AD'
* LEFT JOIN CEVIRILER CEV ON CEV.LISTEALANID = LAID.ID AND CEV.DILID = 0 AND CEV.ALANID = 676
*/
}