public List <SQLModifications.DomenskeKlase.Escalation> vratiSveEskalacije()
{
OtvoriKonekciju();
List <SQLModifications.DomenskeKlase.Escalation> lista = new List <SQLModifications.DomenskeKlase.Escalation>();
string upit = "SELECT * FROM dbo.escalations";
SqlCommand komanda = new SqlCommand(upit, konekcija);
DataTable tabela = new DataTable();
SqlDataReader citac = komanda.ExecuteReader();
tabela.Load(citac);
foreach (DataRow red in tabela.Rows)
{
SQLModifications.DomenskeKlase.Escalation es = new SQLModifications.DomenskeKlase.Escalation();
es.IdJob = Convert.ToInt32(red[0]);
es.TableName = red[1].ToString();
es.EscalationType = Convert.ToInt32(red[2]);
es.Condition = red[3].ToString();
es.Action = red[4].ToString();
lista.Add(es);
}
ZatvoriKonekciju();
return(lista);
}
private void OnElapsedTime(object sender, ElapsedEventArgs e, SQLModifications.DomenskeKlase.Escalation item)
{
kki.pomocnaMetoda(item.TableName, item.Condition, item.Action);
}
