public JsonResult GetSlotOccupation(string start)
{
try
{
if (start == null)
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
else
{
SlotOccupationParameters param = new SlotOccupationParameters();
param.Start = start;
//base.SaveReportParameters(param); //Save parameter to cookie
using (SlotOccupationService _service = new SlotOccupationService())
{
SlotOccupationModel model = _service.GetSlotOccupationModel(param);
return(Json(model, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public SlotOccupationModel GetSlotOccupationModel(SlotOccupationParameters param)
{
SlotOccupationModel model = new SlotOccupationModel();
model.SlotOccupationList = GetSlotOccupationList(param).ToList();
DateTime?date = getDateRangeStartTime();
if (date == null)
{
model.StartTime = "";
}
else
{
model.StartTime = date.Value.ToString(Config.CasinoDateTimeFormat);
}
date = getDateRangeEndTime();
if (date == null)
{
model.EndTime = "";
}
else
{
model.EndTime = date.Value.ToString(Config.CasinoDateTimeFormat);
}
model.TotalSlots = GetTotalSlots();
model.TotalWin = GetTotalWin();
model.TotalHandle = GetTotalHandle();
model.TotalPlayers = GetTotalPlayers();
model.TotalSlotsOccupied = GetTotalSlotsOccupied();
return(model);
}
public ActionResult SlotOccupation()
{
using (UIChartService _service = new UIChartService())
{
//IQueryParamaters parameter = base.GetReportParameters(Constants.Cookies.SlotOccupationParameters); //get parameter from cookie
IQueryParamaters parameter = new SlotOccupationParameters();
return(View(
_service.GetUIChartModel(Constants.Pages.SlotOccupation, base.GetCurrentUserId(), base.GetCurrentCulture(), parameter)
));
}
}
public IEnumerable <SlotOccupationST> GetSlotOccupationList(SlotOccupationParameters param)
{
this._occupationList = new List <SlotOccupationST>();
var date = DateTime.ParseExact(param.Start, Config.CasinoDateFormat, null).ToString("yyyyMMdd"); //required by the store procedure
foreach (SlotOccupationST st in ((GenuinaDBEntities)base.GetContext()).GetSlotOccupationList(date).ToList())
{
this._occupationList.Add(st);
}
return(_occupationList);
}
public JsonResult SlotOccupationDataTableHandler(DataTableParameters param, SlotOccupationParameters queryParam)
{
try
{
using (SlotOccupationService _service = new SlotOccupationService())
{
List <SlotOccupationST> slotList = _service.GetSlotOccupationList(queryParam).ToList();
return(Json(new DataTableResult <SlotOccupationST>
(
param.Draw,
_service.GetSearchResultCount(param, slotList),
_service.GetDataTableResultByPage(param, slotList)
), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { error = ex.Message }));
}
}
