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