Ejemplo n.º 1
0
        public Publisher GetPublisherByCountryAndStatus(string countryCode, PublisherStatus status, Direction direction, int publisherId)
        {
            Publisher result = new Publisher();

            using (MailPusherDBContext context = new MailPusherDBContext())
            {
                var query = context.Publishers.Include(x => x.NACE);
                if (direction == Direction.Next)
                {
                    query = query.Where(x => x.ID > publisherId);
                }

                if (direction == Direction.Previous)
                {
                    query = query.Where(x => x.ID < publisherId);
                }

                if (!string.IsNullOrEmpty(countryCode))
                {
                    query = query.Where(x => x.Language == countryCode);
                }

                result = query.FirstOrDefault(x => x.Status == status);
            }
            return(result);
        }
Ejemplo n.º 2
0
        public ActionResult GetPrevPublisher(string countryCode, int publisherId, PublisherStatus status)
        {
            PublisherHelper helper    = new PublisherHelper();
            Publisher       publisher = helper.GetPublisherByCountryAndStatus(countryCode, status, Direction.Previous, publisherId);

            return(Json(GetPublisherEmail(publisher), JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 3
0
        public ActionResult ChangePublisherStatus(PublisherStatus status, int id)
        {
            string          currentUserId = User.Identity.GetUserId();
            PublisherHelper helper        = new PublisherHelper();

            return(Json(helper.ChangePublisherStatus(status, id, currentUserId)));
        }
Ejemplo n.º 4
0
        public Email GetEmailByPublisherCountryAndStatus(string countryCode, PublisherStatus status)
        {
            Email result = new Email();

            using (var context = new MailPusherDBContext())
            {
                result = GenerateQueryForEmailByPublisherCountryAndStatus(context, countryCode, status, null, 0).FirstOrDefault();
            }
            return(result);
        }
Ejemplo n.º 5
0
        public Email GetPrevEmailByPublisherCountryAndStatus(string countryCode, PublisherStatus status, int publisherId)
        {
            Email result = new Email();

            using (var context = new MailPusherDBContext())
            {
                result = GenerateQueryForEmailByPublisherCountryAndStatus(context, countryCode, status, publisherId, Direction.Previous).FirstOrDefault();
            }
            return(result);
        }
Ejemplo n.º 6
0
        public Email GetFirstPublisherEmail(PublisherStatus status, int publisherID)
        {
            Email result = new Email();

            using (var context = new MailPusherDBContext())
            {
                result = context.Emails.OrderBy(x => x.ID).FirstOrDefault(x => x.PublisherID == publisherID);
            }
            return(result);
        }
Ejemplo n.º 7
0
        public static string GetFormtedStatus(PublisherStatus status, DateTime?changed)
        {
            string datePart = string.Empty;

            if (changed.HasValue)
            {
                datePart = string.Format("({0:yyyy-MM-dd})", changed.Value.ToUniversalTime());
            }
            return(string.Format("{0} {1}", status.ToString(), datePart));
        }
Ejemplo n.º 8
0
        public Publisher GetFirstPublisherByStatus(PublisherStatus status)
        {
            Publisher result = new Publisher();

            using (MailPusherDBContext context = new MailPusherDBContext())
            {
                result = context.Publishers.Include(x => x.NACE).FirstOrDefault(x => x.Status == status);
            }
            return(result);
        }
Ejemplo n.º 9
0
        public int GetTotalFilteredRecords(string searchCriteria, PublisherStatus publisherStatuses, bool isPotentiallyCancelled, List <string> countries, List <int> categories, int minEmailAmount)
        {
            int result = 0;

            using (MailPusherDBContext context = new MailPusherDBContext())
            {
                result = AddFilters(context, searchCriteria, publisherStatuses, isPotentiallyCancelled, countries, categories, minEmailAmount).Count();
            }
            return(result);
        }
Ejemplo n.º 10
0
        public ActionResult GetFirstPublisherEmail(string countryCode, PublisherStatus status)
        {
            //TODO move this to user settings, don't make during search!!
            UserSettingsHelper usHelper = new UserSettingsHelper();

            usHelper.Update(User.Identity.GetUserId(), countryCode);
            //TODO move this to user settings, don't make during search!!
            EmailHelper helper = new EmailHelper();

            return(Json(helper.GetEmailByPublisherCountryAndStatus(countryCode, status), JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 11
0
        public ActionResult Get(IDataTablesRequest request, PublisherStatus publisherStatuses, bool isPotentiallyCancelled, List <string> countries, List <int> categories, int minEmailAmount)
        {
            PublisherHelper helper = new PublisherHelper();

            var filteredData = helper.GetPublishersWithStats(request.Start, request.Length, request.Search.Value, publisherStatuses, isPotentiallyCancelled, countries, categories, minEmailAmount);

            var response = DataTablesResponse.Create(request, helper.GetTotalRecords(),
                                                     helper.GetTotalFilteredRecords(request.Search.Value, publisherStatuses, isPotentiallyCancelled, countries, categories, minEmailAmount),
                                                     filteredData);

            // Easier way is to return a new 'DataTablesJsonResult', which will automatically convert your
            // response to a json-compatible content, so DataTables can read it when received.
            return(new DataTablesJsonResult(response, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 12
0
        public Email GetFirstPublisherEmail(PublisherStatus status)
        {
            Email result = new Email();

            using (var context = new MailPusherDBContext())
            {
                var publisher = context.Publishers.FirstOrDefault(x => x.Status == status);
                if (publisher != null)
                {
                    result = context.Emails.OrderBy(x => x.ID).FirstOrDefault(x => x.PublisherID == publisher.ID);
                }
            }
            return(result);
        }
Ejemplo n.º 13
0
        public Publisher GetFirstPublisherByCountryAndStatus(string countryCode, PublisherStatus status)
        {
            Publisher result = new Publisher();

            using (MailPusherDBContext context = new MailPusherDBContext())
            {
                var query = context.Publishers.Include(x => x.NACE);
                if (!string.IsNullOrEmpty(countryCode))
                {
                    query = query.Where(x => x.Language == countryCode);
                }
                result = query.FirstOrDefault(x => x.Status == status);
            }
            return(result);
        }
Ejemplo n.º 14
0
 public bool ChangePublisherStatus(PublisherStatus status, int id, string userId)
 {
     using (MailPusherDBContext context = new MailPusherDBContext())
     {
         Publisher result = context.Publishers.FirstOrDefault(x => x.ID == id);
         if (status != result.Status)
         {
             result.StatusChanged = DateTime.UtcNow;
         }
         result.Status               = status;
         result.UpdaterId            = userId;
         result.Updated              = DateTime.UtcNow;
         context.Entry(result).State = EntityState.Modified;
         context.SaveChanges();
     }
     return(true);
 }
Ejemplo n.º 15
0
        public Email GetPrevEmailByPublisherCountryAndStatus(string countryCode, PublisherStatus status, int publisherId)
        {
            EmailRepo repo = new EmailRepo();

            return(Map(repo.GetPrevEmailByPublisherCountryAndStatus(countryCode, status, publisherId), countryCode));
        }
Ejemplo n.º 16
0
        public Email GetEmailByPublisherCountryAndStatus(string countryCode, PublisherStatus status)
        {
            EmailRepo repo = new EmailRepo();

            return(Map(repo.GetEmailByPublisherCountryAndStatus(countryCode, status), countryCode));;
        }
Ejemplo n.º 17
0
        public List <Publisher> GetPublishers(int start, int length, string searchCriteria, PublisherStatus publisherStatuses, bool isPotentiallyCancelled)
        {
            PublisherRepo repo = new PublisherRepo();

            return(Map(repo.GetPuglishers(start, length, searchCriteria, publisherStatuses, isPotentiallyCancelled, null, null, 0)));
        }
Ejemplo n.º 18
0
        public List <Publisher> GetPublishersWithStats(int start, int length, string searchCriteria, PublisherStatus publisherStatuses, bool isPotentiallyCancelled, List <string> countries, List <int> categories, int minEmailAmount)
        {
            PublisherRepo    repo       = new PublisherRepo();
            List <Publisher> publishers = Map(repo.GetPuglishers(start, length, searchCriteria, publisherStatuses, isPotentiallyCancelled, countries, categories, minEmailAmount));
            var publishersStats         = repo.GetStats(publishers.Select(x => x.ID).ToList());

            foreach (var publisher in publishers)
            {
                var currentPublisherStats = publishersStats.FirstOrDefault(x => x.PublisherId == publisher.ID);
                publisher.ReceivedEmails = currentPublisherStats == null ? 0 : currentPublisherStats.ReceivedEmails;
            }
            return(publishers);
        }
Ejemplo n.º 19
0
        public Publisher GetFirstPublisherByStatus(PublisherStatus publisherStatus)
        {
            PublisherRepo repo = new PublisherRepo();

            return(Map(repo.GetFirstPublisherByStatus(publisherStatus)));
        }
Ejemplo n.º 20
0
        private IQueryable <Email> GenerateQueryForEmailByPublisherCountryAndStatus(MailPusherDBContext context, string countryCode, PublisherStatus status, int?publisherId, Direction direction)
        {
            var query = context.Publishers.Where(x => x.Status == status);

            if (!string.IsNullOrEmpty(countryCode))
            {
                query = query.Where(x => x.Language == countryCode);
            }
            if (publisherId.HasValue)
            {
                if (direction == Direction.Next)
                {
                    query = query.Where(x => x.ID > publisherId.Value);
                }
                if (direction == Direction.Previous)
                {
                    query = query.Where(x => x.ID < publisherId.Value);
                }
            }
            return(query.Join(context.Emails, pub => pub.ID, em => em.PublisherID, (pub, em) => em));
        }
Ejemplo n.º 21
0
        public ActionResult GetPrevPublisherEmail(string countryCode, PublisherStatus status, int publisherId)
        {
            EmailHelper helper = new EmailHelper();

            return(Json(helper.GetPrevEmailByPublisherCountryAndStatus(countryCode, status, publisherId), JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 22
0
        public List <Publisher> GetPuglishers(int start, int length, string searchCriteria, PublisherStatus publisherStatuses, bool isPotentiallyCancelled, List <string> countries, List <int> categories, int minEmailAmount)
        {
            List <Publisher> result = new List <Publisher>();

            using (MailPusherDBContext context = new MailPusherDBContext())
            {
                var query = AddFilters(context, searchCriteria, publisherStatuses, isPotentiallyCancelled, countries, categories, minEmailAmount);

                var tmpResult = query.Include(x => x.NACE).OrderBy(x => x.ID).Skip(start).Take(length);
                result = tmpResult.ToList();
            }
            return(result);
        }
Ejemplo n.º 23
0
        protected IQueryable <Publisher> AddFilters(MailPusherDBContext context, string searchCriteria, PublisherStatus publisherStatuses, bool isPotentiallyCancelled, List <string> countries, List <int> categories, int minEmailAmount)
        {
            var query = context.Publishers.Select(x => x);

            if (publisherStatuses != 0)
            {
                query = query.Where(x => (x.Status & publisherStatuses) > 0);
            }
            if (!string.IsNullOrEmpty(searchCriteria))
            {
                query = query.Where(x => x.Name.Contains(searchCriteria));
            }
            if (isPotentiallyCancelled)
            {
                var date = DateTime.UtcNow.AddDays(-30);
                query = query.Where(x => x.LastReceivedEmail < date);
            }
            if (countries != null && countries.Count > 0)
            {
                query = query.Where(x => countries.Contains(x.Language));
            }
            if (categories != null && categories.Count > 0)
            {
                query = query.Where(x => categories.Contains(x.NACEID));
            }
            if (minEmailAmount > 0)
            {
                query = query.Where(x => context.Emails.Where(y => y.PublisherID == x.ID).Count() >= minEmailAmount);
            }
            return(query);
        }
Ejemplo n.º 24
0
        public int GetTotalFilteredRecords(string searchCriteria, PublisherStatus statuses, bool isPotentiallyCancelled, List <string> countries, List <int> categories, int minEmailAmount)
        {
            PublisherRepo repo = new PublisherRepo();

            return(repo.GetTotalFilteredRecords(searchCriteria, statuses, isPotentiallyCancelled, countries, categories, minEmailAmount));
        }
Ejemplo n.º 25
0
        public Publisher GetPublisherByCountryAndStatus(string countryCode, PublisherStatus status, Direction direction, int publisherId)
        {
            PublisherRepo repo = new PublisherRepo();

            return(Map(repo.GetPublisherByCountryAndStatus(countryCode, status, direction, publisherId), countryCode));
        }
Ejemplo n.º 26
0
        public Email GetFirstPublisherEmail(PublisherStatus status, int publisherId)
        {
            EmailRepo repo = new EmailRepo();

            return(Map(repo.GetFirstPublisherEmail(status, publisherId)));
        }
Ejemplo n.º 27
0
        public bool ChangePublisherStatus(PublisherStatus status, int id, string userId)
        {
            PublisherRepo repo = new PublisherRepo();

            return(repo.ChangePublisherStatus(status, id, userId));
        }
Ejemplo n.º 28
0
        public Publisher GetFirstPublisherByCountryAndStatus(string countryCode, PublisherStatus publisherStatus)
        {
            PublisherRepo repo = new PublisherRepo();

            return(Map(repo.GetFirstPublisherByCountryAndStatus(countryCode, publisherStatus), countryCode));;
        }