public void Delete(string Where, int TerminalId) //ikinci parametre örnek týp merkezi için eklendi
{
Hashtable hshDelete = DBProcess.DeleteData("KUYRUK", "Where " + Where);
Hashtable cl = new Hashtable();
cl["I_yf3"] = TerminalId;
//Hashtable hshDelete = DBProcess.UpdateData("KUYRUK", "Where " + Where, cl); //örnek týp merkezi
//deleteTryingCount++;
//if (hshDelete.ContainsKey("Error"))
//{
// if (deleteTryingCount <= 5)
// {
// Delete(Where, TerminalId);
// }
// else
// {
// hshDelete.Clear();
// hshDelete.Add("GRPID", 0);
// Update("BID" + BiletID, hshDelete);
// }
//}
}
private static bool CheckLeapTicket()
{
bool durum = false;
try
{
DataTable dtQueue = (DataTable)DBProcess.SimpleQuery(
"KUYRUK INNER JOIN BILETLER ON KUYRUK.BID = BILETLER.BID",
"Where BILETLER.SIS_TAR < '" + DateTime.Now.ToString("yyyy.MM.dd") + "'",
"",
"KUYRUK.BID, BILETLER.SIS_TAR")["DataTable"];
if (dtQueue != null && dtQueue.Rows.Count > 0)
{
foreach (DataRow item in dtQueue.Rows)
{
DBProcess.DeleteData("KUYRUK", "Where BID = " + item[0]);
}
durum = true;
}
}
catch (Exception hata)
{
durum = false;
Console.WriteLine("CheckLeapTicket. Hata:" + hata.Message);
OlayGunluk.Olay("CheckLeapTicket. Hata:" + hata.Message);
}
return(durum);
}
public void Delete(string Where)
{
var hshDelete = DBProcess.DeleteData("KUYRUK", "Where " + Where);
_deleteTryingCount++;
if (!hshDelete.ContainsKey("Error"))
{
return;
}
if (_deleteTryingCount <= 5)
{
Delete(Where);
}
else
{
hshDelete.Clear();
hshDelete.Add("GRPID", 0);
Update("BID" + BiletId, hshDelete);
}
}
public Hashtable Delete(string Where)
{
return(DBProcess.DeleteData("BUTONLAR", "WHERE " + Where));
}