public List<DataObjectSessionAttendee> GetAll() { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); List<DataObjectSessionAttendee> DataTemplateODSList = new List<DataObjectSessionAttendee>(); SqlDataReader reader = null; string sqlSelectString = "SELECT sessions_id,attendees_username,interestlevel,id FROM SessionAttendee"; SqlCommand cmd = new SqlCommand(sqlSelectString, conn); reader = cmd.ExecuteReader(); try { while (reader.Read()) { int sessions_id = reader.IsDBNull(0) ? 0 : reader.GetInt32(0); Guid attendees_username = reader.IsDBNull(1) ? Guid.NewGuid() : reader.GetGuid(1); int interestlevel = reader.IsDBNull(2) ? 0 : reader.GetInt32(2); int id = reader.IsDBNull(3) ? 0 : reader.GetInt32(3); DataObjectSessionAttendee td = new DataObjectSessionAttendee(sessions_id, attendees_username, interestlevel, id); DataTemplateODSList.Add(td); } } finally { if (reader != null) reader.Close(); } conn.Close(); return DataTemplateODSList; }
public List<DataObjectSessionAttendee> GetBySessionId(int searchsessions_id) { List<DataObjectSessionAttendee> DataTemplateODSList = null; string cacheName = CodeCampSV.Utils.CacheSessionAttendeeBySessionId + "_" + searchsessions_id.ToString(); //$$$ PROBLEM, MOVE THIS OUT OF IF STATMENT if (HttpContext.Current.Cache[cacheName] == null) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); DataTemplateODSList = new List<DataObjectSessionAttendee>(); SqlDataReader reader = null; string sqlSelectString = "SELECT sessions_id,attendees_username,interestlevel,id FROM [dbo].[SessionAttendee] WHERE sessions_id = @searchsessions_id"; SqlCommand cmd = new SqlCommand(sqlSelectString, conn); cmd.Parameters.Add("@searchsessions_id", SqlDbType.Int, 4).Value = searchsessions_id; ; reader = cmd.ExecuteReader(); try { while (reader.Read()) { int sessions_id = reader.IsDBNull(0) ? 0 : reader.GetInt32(0); Guid attendees_username = reader.IsDBNull(1) ? Guid.NewGuid() : reader.GetGuid(1); int interestlevel = reader.IsDBNull(2) ? 0 : reader.GetInt32(2); int id = reader.IsDBNull(3) ? 0 : reader.GetInt32(3); DataObjectSessionAttendee td = new DataObjectSessionAttendee(sessions_id, attendees_username, interestlevel, id); DataTemplateODSList.Add(td); } } finally { if (reader != null) reader.Close(); } conn.Close(); HttpContext.Current.Cache.Insert(cacheName, DataTemplateODSList, null, DateTime.Now.Add(new TimeSpan(0, 0, Utils.RetrieveSecondsForSessionCacheTimeout())), TimeSpan.Zero); } else { DataTemplateODSList = (List<DataObjectSessionAttendee>)HttpContext.Current.Cache[cacheName]; } return DataTemplateODSList; }
public List<DataObjectSessionAttendee> GetByUsername(string username) { List<DataObjectSessionAttendee> DataTemplateODSList = new List<DataObjectSessionAttendee>(); string cacheName = CodeCampSV.Utils.CacheSessionAttendeeByUsername + "_" + username ; if (HttpContext.Current.Cache[cacheName] == null) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); DataTemplateODSList = new List<DataObjectSessionAttendee>(); SqlDataReader reader = null; string sqlSelectString = @" SELECT sessions_id, attendees_username, interestlevel, id FROM SessionAttendee WHERE attendees_username = (select PKID from Attendees WHERE Username = @Username) "; SqlCommand cmd = new SqlCommand(sqlSelectString, conn); cmd.Parameters.Add("@Username", SqlDbType.VarChar).Value = username; reader = cmd.ExecuteReader(); try { while (reader.Read()) { int sessions_id = reader.IsDBNull(0) ? 0 : reader.GetInt32(0); Guid attendees_username = reader.IsDBNull(1) ? Guid.NewGuid() : reader.GetGuid(1); int interestlevel = reader.IsDBNull(2) ? 0 : reader.GetInt32(2); int id = reader.IsDBNull(3) ? 0 : reader.GetInt32(3); var td = new DataObjectSessionAttendee(sessions_id, attendees_username, interestlevel, id); DataTemplateODSList.Add(td); //// interested = 2; plan to attend = 3 //if (radioButtonInterestLevel.Equals("All")) //{ // DataTemplateODSList.Add(td); //} //else if (radioButtonInterestLevel.Equals("Interested")) //{ // if (interestlevel == 2) // { // DataTemplateODSList.Add(td); // } //} //else if (radioButtonInterestLevel.Equals("Plan To Attend")) //{ // if (interestlevel == 3) // { // DataTemplateODSList.Add(td); // } //} //else if (radioButtonInterestLevel.Equals("I & P2A")) //{ // if (interestlevel == 3 || interestlevel == 2) // { // DataTemplateODSList.Add(td); // } //} } } finally { if (reader != null) reader.Close(); } conn.Close(); // DON'T CACHE THIS BECAUSE PERSON MAY BE CHANGING SELECTIONS, PROBABLY SHOULD NOT EVEN HAVE I LOOP int cacheTime = Utils.RetrieveSecondsForSessionCacheTimeout(); cacheTime = 3; // make small just in case site hammered HttpContext.Current.Cache.Insert(cacheName, DataTemplateODSList, null, DateTime.Now.Add(new TimeSpan(0, 0,cacheTime)), TimeSpan.Zero); } else { DataTemplateODSList = (List<DataObjectSessionAttendee>)HttpContext.Current.Cache[cacheName]; } return DataTemplateODSList; }