public List <ServicioResumen> getIntervals() { List <ServicioResumen> Services = new List <ServicioResumen>(); try { using (SqlConnection con = new SqlConnection(BDCon)) { using (SqlCommand cmd = new SqlCommand("[Conf].[Usp_ObtieneIntervaloServicio]", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CodeService", "ADE.Services.SummaryDelivery"); con.Open(); SqlDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { ServicioResumen line = new ServicioResumen(); line.Id = dr[0].ToString().Trim(); line.CodeService = dr[1].ToString().Trim(); line.NameService = dr[2].ToString().Trim(); line.ValueTime = dr[3].ToString().Trim(); line.IntervalValue = dr[4].ToString().Trim(); line.MaxNumAttempts = dr[5].ToString().Trim(); line.RucEntity = dr[6].ToString().Trim(); line.IdEstado = dr[7].ToString().Trim(); line.SubType = dr[8].ToString().Trim(); Services.Add(line); } con.Close(); } } } catch (SqlException ex) { } return(Services); }
public SummaryTask() { Timer = new Timer(); SR = new ServicioResumen(); }