public Web_UserMessage GetUserMessageByUserIdandMsgId(int userid, int messageid) { Web_UserMessage usermessage = new Web_UserMessage(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@User_ID", SqlDbType.Int, userid); sql.AddParameter("@Message_ID", SqlDbType.Int, messageid); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetUserMessageByUserIdAndMsgId); if (reader != null) { while (reader.Read()) { if (!reader.IsDBNull(0)) usermessage.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) usermessage.User_ID = reader.GetInt32(1); if (!reader.IsDBNull(2)) usermessage.Message_ID = reader.GetInt32(2); if (!reader.IsDBNull(3)) usermessage.UserMessage_State = reader.GetInt32(3); usermessage.MarkOld(); } reader.Close(); } return usermessage; }
public IList<Web_UserMessage> GetMessagesByUserID(int userid) { IList<Web_UserMessage> userlist = new List<Web_UserMessage>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@User_ID", SqlDbType.Int, userid); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetMessagesByUserId); if (reader != null) { while (reader.Read()) { Web_UserMessage usermessage = new Web_UserMessage(); if (!reader.IsDBNull(0)) usermessage.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) usermessage.User_ID = reader.GetInt32(1); if (!reader.IsDBNull(2)) usermessage.Message_ID = reader.GetInt32(2); if (!reader.IsDBNull(3)) usermessage.UserMessage_State = reader.GetInt32(3); usermessage.MarkOld(); userlist.Add(usermessage); } reader.Close(); } return userlist; }