public IHttpActionResult checkDstvSubscriberExists([FromBody] DstvSubscriberEmailInputDTO dstvEmailDto)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest("Invalid code"));
            }

            var dtsvSubscriber = _context.DstvSubscribers.FirstOrDefault(s => s.EmailAddress == dstvEmailDto.Email && s.deleted_at == null);

            var dstvResponseDTO = new DstvResponseDTO();

            if (dtsvSubscriber == null)
            {
                dstvResponseDTO = new DstvResponseDTO
                {
                    exists = false
                };

                return(Ok(dstvResponseDTO));
            }

            dtsvSubscriber.updated_at = DateTime.UtcNow;
            dtsvSubscriber.DstvCode   = dstvEmailDto.Code;
            _context.SaveChanges();

            dstvResponseDTO = new DstvResponseDTO
            {
                exists       = true,
                SubscriberId = dtsvSubscriber.Id
            };

            return(Ok(dstvResponseDTO));
        }
        public IHttpActionResult ConfirmDstvCode([FromBody] DstvCodeInputDTO dstvDto)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest("Invalid code"));
            }

            // remove outdated files
            var month = DateTime.Now.Month.ToString();

            var dtsvpromo = _context.Promos.FirstOrDefault(p =>
                                                           p.PromoName == month && p.Code == dstvDto.code && p.deletedAt == null);


            if (dtsvpromo == null)
            {
                return(NotFound());
            }

            //update time on promo table
            dtsvpromo.updatedAt = DateTime.UtcNow;
            //dtsvpromo.deletedAt = DateTime.UtcNow;
            _context.SaveChanges();

            var dstvResponseDTO = new DstvResponseDTO
            {
                exists = true
            };

            return(Ok(dstvResponseDTO));
        }