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); }