public List <Message> GetMessage()
{
List <Message> messageList = new List <Message>();
DataTable dt = sql.GetAllMessage("Select * From Messages");
foreach (DataRow item in dt.Rows)
{
Message message = new Message();
message.User = new User();
if (message.User.IsBlocked == false)
{
message.Content = item["Message"].ToString();
message.User.UserName = item["SenderUser"].ToString();
message.SendDate = (DateTime)item["Date"];
message.MessageId = (int)item["MessageID"];
messageList.Add(message);
}
}
return(messageList);
}
public List <User> ActiveUsers()
{
List <User> list = new List <User>();
DataTable dt = sqlHelper.GetAllMessage("SELECT * FROM Users WHERE IsActive = 1");
foreach (DataRow item in dt.Rows)
{
User user = new User();
user.UserName = item["UserName"].ToString();
user.Name = item["Name"].ToString();
user.Activity = (bool)item["IsActive"];
list.Add(user);
}
return(list);
}
