public JsonResult ReturnSimForPeriod(DtoSim dto)
        {
            var user  = Helpers.AuthHelper.GetUser(HttpContext);
            var query = _service.Get <SimCard>().Where(x => x.Date.Month >= dto.StartMonth && x.Date.Month <= dto.EndMonth && x.UserId == user.Id);
            var sim   = CastBestsellerToDto.SimListDto(query);

            return(Json(sim));
        }
        public JsonResult ReturnSimForMonthForOperator(DtoSim dto)
        {
            var user  = Helpers.AuthHelper.GetUser(HttpContext);
            var query = _service.Get <SimCard>().Where(x => (x.Date.Month == dto.Month && x.Operator.ToString() == dto.Operator && x.UserId == user.Id));
            var sim   = CastBestsellerToDto.SimListDto(query);

            return(Json(sim));
        }
        public JsonResult ReturnBestsellersForPeriod(DtoBestseller dto)
        {
            var user  = Helpers.AuthHelper.GetUser(HttpContext);
            var query = _service.Get <Bestseller>().Where(x => (x.Date.Month >= dto.StartMonth && x.Date.Month <= dto.EndMonth && x.UserId == user.Id));
            var hits  = CastBestsellerToDto.BestsellersListDto(query);

            return(Json(hits));
        }
        public JsonResult ReturnAppliancesesForPeriod(DtoAppliances dto)
        {
            var user  = Helpers.AuthHelper.GetUser(HttpContext);
            var query = _service.Get <Appliances>().Where(x => (x.Date.Month >= dto.StartMonth && x.Date.Month <= dto.EndMonth && x.UserId == user.Id));
            var appli = CastBestsellerToDto.AppliancesesListDto(query);

            return(Json(appli));
        }
        public JsonResult ReturnPerMonth(DtoBestseller dto)
        {
            var user  = Helpers.AuthHelper.GetUser(HttpContext);
            var query = _service.Get <Bestseller>().Where(x => x.Date.Month == dto.Month && x.UserId == user.Id);
            var hits  = CastBestsellerToDto.BestsellersListDto(query);

            return(Json(hits));
        }