public List <MessageDTO> GetAllBySender(int id)
{
List <MessageDTO> messages = new List <MessageDTO>();
try
{
string sql = "SELECT * FROM Message WHERE SenderId = @SenderId ";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("SenderId", id.ToString()),
};
DataSet Results = ExecuteSql(sql, parameters);
for (int x = 0; x < Results.Tables[0].Rows.Count; x++)
{
MessageDTO dto = DataSetParser.DataSetToMessage(Results, x);
messages.Add(dto);
}
return(messages);
}
catch (Exception e)
{
throw e;
}
}
