public FacilityCollection(Facility[] facilities) { this.facilities = facilities; }
public Enumerator(Facility[] facilities) { this.facilities = facilities; }
public static FacilityCollection GetFacilities() { FacilityCollection facilities = (FacilityCollection)HttpContext.Current.Cache[facilitiesCacheKey]; if (facilities == null) { string query = @"select distinct d.facil_no,d.description as facil_desc from tx_sli_ticket a join T_SUB_LINEITEM b on a.sli_no = b.sli_no join T_PERF c on b.perf_no = c.perf_no join T_FACILITY d on c.facility_no = d.facil_no where c.perf_dt between CONVERT(date,getdate()) and dateadd(day,1,CONVERT(date,getdate()))"; string connString = ConfigSection.Settings.ConnectionString; SqlConnection conn = new SqlConnection(connString); SqlCommand cmd = new SqlCommand(query, conn); List<Facility> facilityList = new List<Facility>(); try { conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Facility newFacility = new Facility { Id = reader.GetInt32(0), Name = reader.GetString(1) }; facilityList.Add(newFacility); } } finally { conn.Close(); } if (facilityList.Count > 0) facilities = new FacilityCollection(facilityList.ToArray()); else facilities = new FacilityCollection(); int cacheMins = ConfigSection.Settings.CacheMins; HttpContext.Current.Cache.Insert(facilitiesCacheKey, facilities, null, DateTime.Now.AddMinutes(cacheMins), TimeSpan.Zero); } return facilities; }