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