public IList<Core.Business.Web_UserMessage> GetAllWeb_UserMessage() { IList<Core.Business.Web_UserMessage> web_UserMessagelist = new List<Core.Business.Web_UserMessage>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllWeb_UserMessage); if(reader != null) { while(reader.Read()) { Core.Business.Web_UserMessage web_UserMessage = new Core.Business.Web_UserMessage(); if (!reader.IsDBNull(0)) web_UserMessage.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) web_UserMessage.User_ID = reader.GetInt32(1); if (!reader.IsDBNull(2)) web_UserMessage.Message_ID = reader.GetInt32(2); if (!reader.IsDBNull(3)) web_UserMessage.UserMessage_State = reader.GetInt32(3); web_UserMessage.MarkOld(); web_UserMessagelist.Add(web_UserMessage); } reader.Close(); } return web_UserMessagelist; }
public Core.Business.Web_UserMessage Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectWeb_UserMessage); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Web_UserMessage web_UserMessage = new Core.Business.Web_UserMessage(); if (!reader.IsDBNull(0)) web_UserMessage.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) web_UserMessage.User_ID = reader.GetInt32(1); if (!reader.IsDBNull(2)) web_UserMessage.Message_ID = reader.GetInt32(2); if (!reader.IsDBNull(3)) web_UserMessage.UserMessage_State = reader.GetInt32(3); reader.Close(); return web_UserMessage; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }