public List<EventDuration> GetBlowings(int heatID)
        {
            string sql = "select h.eventtime,h.value1,h.type from heat_events h where heat_id =" + heatID.ToString() + " and type in ('BLOS','BLOE') order by eventtime";
            OracleDataReader reader = Execute(sql);

            List<EventDuration> durations = new List<EventDuration>();
            EventDuration dur = new EventDuration();
            while (reader.Read())
            {
                if (reader[2].ToString() == "BLOS")
                {
                    dur.StartDate = DateTime.Parse(CheckDateForNull(reader[0].ToString()));
                }
                else
                {
                    dur.EndDate = DateTime.Parse(CheckDateForNull(reader[0].ToString()));
                    dur.Tag = int.Parse(CheckNubmerForNull(reader[1].ToString()));
                    durations.Add(dur);
                    dur = new EventDuration();
                }

            }
            reader.Close();
            return durations;
        }
        public EventDuration GetTapsDuration(int heatID)
        {
            string sql = "select eventtime from heat_events where heat_id =" + heatID.ToString() + " and type in ('TAPS','TAPE') order by eventtime";
            OracleDataReader reader = Execute(sql);
            EventDuration duration = new EventDuration();
            if (reader.Read())
            {
                duration.StartDate = DateTime.Parse(CheckDateForNull(reader[0].ToString()));
            }

            if (reader.Read())
            {
                duration.EndDate = DateTime.Parse(CheckDateForNull(reader[0].ToString()));
            }
            reader.Close();
            return duration;
        }