public static Response Execute(string request)
{
var req = JsonConvert.DeserializeObject <Request <GetGameGroupListFilter> >(request);
var cmd = CommandHelper.CreateProcedure <GameGroup>(FetchType.Fetch, "sp_GetGameGroupList");
cmd.Params.Add(CommandHelper.CreateParam("@gameId", req.Filter.GameId));
cmd.Params.Add(CommandHelper.CreateParam("@groupId", req.Filter.GroupId));
var result = DbContext.GetInstance().Execute(cmd);
var group = result.FirstEntity <GameGroup>();
if (req.Filter.IsContainMember)
{
GameHelper.SetGroupMemberList(group);
}
if (req.Filter.IsContainLoop)
{
group.LoopList = GameHelper.GetGroupLoopList(group.Id);
}
return(result);
}