public JsonResult View(Int32? gameID = null, Boolean? global = null, Int32? offsetHours = null)
{
Entities.Filters.ChatMessage.Select filter = new Entities.Filters.ChatMessage.Select(gameID, global, offsetHours);
List<Entities.ChatMessage> messages = _select.Execute(filter);
return new JsonResult { Data = new { Messages = messages }, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue };
}
public JsonResult View(Int32?gameID = null, Boolean?global = null, Int32?offsetHours = null)
{
Entities.Filters.ChatMessage.Select filter = new Entities.Filters.ChatMessage.Select(gameID, global, offsetHours);
List <Entities.ChatMessage> messages = _select.Execute(filter);
return(new JsonResult {
Data = new { Messages = messages }, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
/// <summary>
/// Select chat messages that match the provided <paramref name="filter"/>
/// </summary>
/// <param name="filter">The filter used to chat messages</param>
/// <returns>List of chat messages</returns>
public List <Entities.ChatMessage> Execute(Entities.Filters.ChatMessage.Select filter)
{
List <Entities.ChatMessage> messages = new List <Entities.ChatMessage>();
using (DbCommand cmd = _db.GetStoredProcCommand("ChatMessage_Select"))
{
_db.AddInParameter(cmd, "@GameID", DbType.Int32, filter.GameID);
_db.AddInParameter(cmd, "@Global", DbType.Boolean, filter.Global);
using (IDataReader idr = _db.ExecuteReader(cmd))
{
while (idr.Read())
{
messages.Add(new Entities.ChatMessage(idr, filter.OffsetHours));
}
}
}
return(messages);
}
/// <summary>
/// Select chat messages that match the provided <paramref name="filter"/>
/// </summary>
/// <param name="filter">The filter used to chat messages</param>
/// <returns>List of chat messages</returns>
public List <Entities.ChatMessage> Execute(Entities.Filters.ChatMessage.Select filter)
{
return(_select.Execute(filter));
}
