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