public JsonResult GetPlayerSearch(string playerId, string end) { try { if (playerId == null) { return(Json(null, JsonRequestBehavior.AllowGet)); } else { PlayerDetailParameters param = new PlayerDetailParameters(); param.PlayerID = playerId; param.End = end; //base.SaveReportParameters(param); //Save parameter to cookie using (PlayerSearchService _service = new PlayerSearchService()) { PlayerSearchModel model = _service.GetPlayerSearchModel(param); return(Json(model, JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult PlayerSearchDataTableHandler(DataTableParameters param, PlayerDetailParameters queryParamters) { try { using (PlayerSearchService _service = new PlayerSearchService()) { List <MarketingPlayerST> mkList = _service.GetMKPlayerList(queryParamters.PlayerID).ToList(); return(Json(new DataTableResult <MarketingPlayerST> ( param.Draw, _service.GetSearchResultCount(param, mkList), _service.GetDataTableResultByPage(param, mkList) ), JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { error = ex.Message })); } }
public PlayerSearchModel GetPlayerSearchModel(PlayerDetailParameters param) { PlayerSearchModel model = new PlayerSearchModel(); DateTime end = new DateTime(); if (param.End == null) { end = DateTime.Now; } else { end = DateTime.ParseExact(param.End, Config.CasinoDateTimeFormat, null); } model.MKPlayer = this.GetMKPlayerList(param.PlayerID).FirstOrDefault(); DateTime start = end.AddDays(-1); model.MKPlayerReferenceTodayList = this.GetMKPlayerReferenceList(param.PlayerID, start, end).ToList(); model.MKPlayerActivityTodayList = this.GetMKPlayerActivityList(param.PlayerID, start, end).ToList(); start = end.AddMonths(-1); model.MKPlayerReferenceMonthList = this.GetMKPlayerReferenceList(param.PlayerID, start, end).ToList(); model.MKPlayerActivityMonthList = this.GetMKPlayerActivityList(param.PlayerID, start, end).ToList(); start = end.AddMonths(-3); model.MKPlayerTrendList = this.GetMKPlayerTrendList(param.PlayerID, start, end).ToList(); model.MKPlayerReferenceQuarterList = this.GetMKPlayerReferenceList(param.PlayerID, start, end).ToList(); model.MKPlayerActivityQuarterList = this.GetMKPlayerActivityList(param.PlayerID, start, end).ToList(); start = (DateTime)SqlDateTime.MinValue; //must use SqlDateTime to get valid Datetime end = (DateTime)SqlDateTime.MaxValue; model.MKPlayerReferenceAllList = this.GetMKPlayerReferenceList(param.PlayerID, start, end).ToList(); model.MKPlayerCardList = this.GetMKPlayerCardList(param.PlayerID).ToList(); model.MKPlayerGameHistoryList = this.GetMKPlayerGameHistoryList(param.PlayerID).ToList(); model.MKPlayerPromotionList = this.GetMKPlayerPromotionList(param.PlayerID).ToList(); model.MKPlayerCashDeskList = this.GetMKPlayerCashDeskList(param.PlayerID).ToList(); return(model); }