public ActionResult Users(CampaignSearchVm sc) { var model = UserManager.Users .Where(x => x.UserName != "kamran.qadir") .Select(x => new UserProfileVm() { Id = x.Id, UserName = x.UserName, Email = x.Email, DateCreated = x.CreatedAt.ToString(), Status = x.Status, Type = x.UserType, FirstName = x.FirstName, LastName = x.LastName, CustomerId = x.CustomerId.ToString(), IsTestsCreatives = x.IsTestsCreatives, IsUsesApi = x.IsUsesApi }).ToList(); ViewBag.WhiteLabel = CustomersList; int pageNumber = (sc.Page ?? 1); return(View("Users", model.ToPagedList(pageNumber, PageSize))); }
public ActionResult Index(CampaignSearchVm sc) { var customer = Db.Customers .Select(x => new CustomerVm { Id = x.Id.ToString(), WhiteLabel = x.WhiteLabel, CompanyName = x.CompanyName, CompanyLogo = x.CompanyLogo, ReportTemplate = x.ReportTemplate, WebDomain = x.WebDomain, Phone = x.Phone, Email = x.Email, IsUseOpenModel = x.IsUseOpenModel, OpenInitial = x.OpenInitial, OpenEnd = x.OpenEnd, ClickInitial = x.ClickInitial, ClickEnd = x.ClickEnd, DateCreated = x.CreatedAt.ToString() }).ToList(); string view = IsNxs ? "IndexNXS" : "Index"; int pageNumber = (sc.Page ?? 1); var model = customer.ToPagedList(pageNumber, PageSize); return(View(view, model)); }
// GET: Campaigns public ActionResult Index(CampaignSearchVm sc) { if (!string.IsNullOrEmpty(sc.ClearSessionId)) { Session["id"] = null; sc.BasicString = string.Empty; } ViewBag.CurrentSort = sc.SortOrder; ViewBag.CampaignNameSortParm = sc.SortOrder == "CampaignName" ? "CampaignName_desc" : "CampaignName"; ViewBag.BroadcastDateSortParm = sc.SortOrder == "BroadcastDate" ? "BroadcastDate_desc" : "BroadcastDate"; ViewBag.CreatedBySortParm = sc.SortOrder == "CreatedBy" ? "CreatedBy_desc" : "CreatedBy"; ViewBag.StatusSortParm = sc.SortOrder == "Status" ? "Status_desc" : "Status"; ViewBag.OrderNumberSortParm = sc.SortOrder == "OrderNumber" ? "OrderNumber_desc" : "OrderNumber"; var campagins = Db.Campaigns .Include(x => x.Testing) .Include(x => x.Approved) .Include(x => x.Trackings); campagins = FilterSortCampaigns(campagins, sc); ViewBag.BasicOrderNumber = OrderNumberList; ViewBag.BasicStatus = StatusList; ViewBag.AdvancedStatus = StatusList; ViewBag.AdvancedUser = UsersList; ViewBag.AdvancedWhiteLabel = CustomersWithWLList; ViewBag.Customer = UsersList; // Paging int pageNumber = (sc.Page ?? 1); return(View(campagins.ToPagedList(pageNumber, PageSize))); }
public ActionResult Monitoring(CampaignSearchVm sc) { ViewBag.CurrentSort = sc.SortOrder; ViewBag.CampaignNameSortParm = sc.SortOrder == "CampaignName" ? "CampaignName_desc" : "CampaignName"; ViewBag.BroadcastDateSortParm = sc.SortOrder == "BroadcastDate" ? "BroadcastDate_desc" : "BroadcastDate"; ViewBag.CreatedBySortParm = sc.SortOrder == "CreatedBy" ? "CreatedBy_desc" : "CreatedBy"; ViewBag.StatusSortParm = sc.SortOrder == "Status" ? "Status_desc" : "Status"; ViewBag.OrderNumberSortParm = sc.SortOrder == "OrderNumber" ? "OrderNumber_desc" : "OrderNumber"; var campagins = Db.Campaigns .Include(x => x.Testing) .Include(x => x.Approved) .Include(x => x.ProDatas) .Include(x => x.Trackings) .Include(x => x.Segments) .Include(x => x.Notifications) .OrderByDescending(x => x.CreatedAt) .Where(x => x.Approved != null && !string.IsNullOrEmpty(x.Testing.ClickMeterRotatorLinkId) && (x.Status == (int)CampaignStatus.Monitoring || x.Segments.Any(s => s.SegmentStatus == (int)SegmentStatus.Monitoring))); campagins = FilterSortCampaigns(campagins, sc); ViewBag.BasicOrderNumber = OrderNumberList; ViewBag.BasicStatus = StatusList; ViewBag.AdvancedStatus = StatusList; ViewBag.AdvancedUser = UsersList; ViewBag.AdvancedWhiteLabel = CustomersWithWLList; var trackingVms = new List <CampaignMonitoringVm>(); foreach (var campaign in campagins) { foreach (var campaignTracking in campaign.Trackings) { var model = CampaignMonitoringVm.FromCampaignTracking(campaign, campaignTracking); trackingVms.Add(model); } } ViewBag.Status = StatusList; ViewBag.SearchStatus = StatusList; // Paging int pageNumber = (sc.Page ?? 1); return(View(trackingVms.ToPagedList(pageNumber, PageSize))); }
// GET: Campaigns public ActionResult Index(CampaignSearchVm sc) { if (LoggedInUser == null) { return(RedirectToAction("LogOff", "Account")); } ViewBag.CurrentSort = sc.SortOrder; ViewBag.OrderNumberSortParm = sc.SortOrder == "OrderNumber" ? "OrderNumber_desc" : "OrderNumber"; ViewBag.CampaignNameSortParm = sc.SortOrder == "CampaignName" ? "CampaignName_desc" : "CampaignName"; ViewBag.FromLineSortParm = sc.SortOrder == "FromLine" ? "FromLine_desc" : "FromLine"; ViewBag.SubjectLineSortParm = sc.SortOrder == "SubjectLine" ? "SubjectLine_desc" : "SubjectLine"; ViewBag.DeployDateSortParm = sc.SortOrder == "DeployDate" ? "DeployDate_desc" : "DeployDate"; ViewBag.QuantitySortParm = sc.SortOrder == "Quantity" ? "Quantity_desc" : "Quantity"; ViewBag.StatusSortParm = sc.SortOrder == "Status" ? "Status_desc" : "Status"; var campagins = Db.Campaigns .Include(x => x.Assets) .Include(x => x.Testing) .Include(x => x.Approved) .Include(x => x.Segments); campagins = FilterSortCampaigns(campagins, sc); ViewBag.BasicOrderNumber = OrderNumberList; ViewBag.BasicStatus = StatusList; ViewBag.AdvancedStatus = StatusList; ViewBag.AdvancedUser = UsersList; ViewBag.AdvancedWhiteLabel = CustomersWithWLList; string idsForPrint = string.IsNullOrEmpty(ViewBag.SearchIds) ? string.Join(",", campagins.Select(x => x.Id.ToString())) : ViewBag.SearchIds; Session["idsForPrint"] = idsForPrint; string view = IsNxs ? "IndexNXS" : "Index"; // Paging int pageNumber = (sc.Page ?? 1); return(View(view, campagins.ToPagedList(pageNumber, PageSize))); }
public ActionResult Index(CampaignSearchVm sc) { var vendors = Db.Vendors.Select(x => new VendorVm { Id = x.Id.ToString(), Name = x.Name, CompanyName = x.CompanyName, Phone = x.Phone, Email = x.Email, CcEmails = x.CcEmails, DateCreated = x.CreatedAt.ToString() }).ToList(); int pageNumber = (sc.Page ?? 1); var model = vendors.ToPagedList(pageNumber, PageSize); return(View(model)); }
public ActionResult Index(CampaignSearchVm sc) { var keywords = Db.OpenModelKeywords .OrderBy(x => x.CreatedAt) .Select(x => new KeywordVm { Id = x.Id.ToString(), Keyword = x.Keyword, RulePercentage = x.RulePercentage, DateCreated = x.CreatedAt.ToString() }).ToList(); int pageNumber = (sc.Page ?? 1); var model = keywords.ToPagedList(pageNumber, PageSize); int index = 1; foreach (var m in model) { m.Index = index++; } return(View(model)); }
protected IQueryable <Campaign> FilterSortCampaigns(IQueryable <Campaign> campagins, CampaignSearchVm sc) { return(SortCampaigns(FilterCampaigns(campagins, sc), sc)); }
private IQueryable <Campaign> SortCampaigns(IQueryable <Campaign> campagins, CampaignSearchVm sc) { switch (sc.SortOrder) { case "OrderNumber": campagins = campagins.OrderBy(s => s.OrderNumber); break; case "OrderNumber_desc": campagins = campagins.OrderByDescending(s => s.OrderNumber); break; case "CampaignName": campagins = campagins.OrderBy(s => s.CampaignName); break; case "CampaignName_desc": campagins = campagins.OrderByDescending(s => s.CampaignName); break; case "FromLine": campagins = campagins.OrderBy(s => s.FromLine); break; case "FromLine_desc": campagins = campagins.OrderByDescending(s => s.FromLine); break; case "SubjectLine": campagins = campagins.OrderBy(s => s.SubjectLine); break; case "SubjectLine_desc": campagins = campagins.OrderByDescending(s => s.SubjectLine); break; case "CreatedBy": campagins = campagins.OrderBy(s => s.CreatedBy); break; case "CreatedBy_desc": campagins = campagins.OrderByDescending(s => s.CreatedBy); break; case "CreatedAt": campagins = campagins.OrderBy(s => s.CreatedAt); break; case "CreatedAt_desc": campagins = campagins.OrderByDescending(s => s.CreatedAt); break; case "BroadcastDate": campagins = campagins.OrderBy(s => s.BroadcastDate); break; case "BroadcastDate_desc": campagins = campagins.OrderByDescending(s => s.BroadcastDate); break; case "Quantity": campagins = campagins.OrderBy(s => s.Quantity); break; case "Quantity_desc": campagins = campagins.OrderByDescending(s => s.Quantity); break; case "Status": campagins = campagins.OrderBy(s => s.Status); break; case "Status_desc": campagins = campagins.OrderByDescending(s => s.Status); break; default: campagins = campagins.OrderByDescending(s => s.CreatedAt); break; } return(campagins); }
private IQueryable <Campaign> FilterCampaigns(IQueryable <Campaign> campagins, CampaignSearchVm sc) { ViewBag.SearchType = sc.SearchType; if (LoggedInUser != null && !IsAdmin) { campagins = campagins.Where(s => s.CreatedBy == LoggedInUser.UserName); } switch (sc.SearchType) { case "basic": campagins = FilterCampaignsBasic(campagins, sc); break; case "advanced": campagins = FilterCampaignsAdvanced(campagins, sc); break; } return(campagins); }
private IQueryable <Campaign> FilterCampaignsAdvanced(IQueryable <Campaign> campagins, CampaignSearchVm sc) { if (!string.IsNullOrEmpty(sc.AdvancedStatus)) { int status = int.Parse(sc.AdvancedStatus); campagins = status == (int)CampaignStatus.Rebroadcasted ? campagins.Where(s => s.OrderNumber.EndsWith("RDP")) : campagins.Where(s => s.Status == status); ViewBag.AdvancedStatusSearched = sc.AdvancedStatus; } if (!string.IsNullOrEmpty(sc.AdvancedUser)) { campagins = campagins.Where(s => s.CreatedBy == sc.AdvancedUser); ViewBag.AdvancedUserSearched = sc.AdvancedUser; } if (!string.IsNullOrEmpty(sc.CampaignName)) { sc.CampaignName = sc.CampaignName.ToLowerInvariant(); campagins = campagins.Where(s => s.CampaignName.ToLower().Contains(sc.CampaignName.ToLower())); ViewBag.CampaignName = sc.CampaignName; } if (!string.IsNullOrEmpty(sc.AdvancedWhiteLabel)) { campagins = campagins.Where(s => s.WhiteLabel == sc.AdvancedWhiteLabel || (s.Testing != null && s.Testing.WhiteLabel == sc.AdvancedWhiteLabel) || (s.Approved != null && s.Approved.WhiteLabel == sc.AdvancedWhiteLabel)); ViewBag.AdvancedWhiteLabelSearched = sc.AdvancedWhiteLabel; } if (!string.IsNullOrEmpty(sc.OrderedFrom)) { DateTime dateFrom = DateTime.ParseExact(sc.OrderedFrom, "MM/dd/yyyy", CultureInfo.InvariantCulture); campagins = campagins.Where(s => s.CreatedAt.Date >= dateFrom.Date); ViewBag.OrderedFrom = sc.OrderedFrom; } if (!string.IsNullOrEmpty(sc.OrderedTo)) { DateTime dateTo = DateTime.ParseExact(sc.OrderedTo, "MM/dd/yyyy", CultureInfo.InvariantCulture); campagins = campagins.Where(s => s.CreatedAt.Date <= dateTo.Date); ViewBag.OrderedTo = sc.OrderedTo; } if (!string.IsNullOrEmpty(sc.BroadcastFrom)) { DateTime dateFrom = DateTime.ParseExact(sc.BroadcastFrom, "MM/dd/yyyy", CultureInfo.InvariantCulture); campagins = campagins.Where(s => s.BroadcastDate.HasValue && s.BroadcastDate.Value >= dateFrom.Date); ViewBag.BroadcastFrom = sc.BroadcastFrom; } if (!string.IsNullOrEmpty(sc.BroadcastTo)) { DateTime dateTo = DateTime.ParseExact(sc.BroadcastTo, "MM/dd/yyyy", CultureInfo.InvariantCulture); campagins = campagins.Where(s => s.BroadcastDate.HasValue && s.BroadcastDate.Value <= dateTo.Date); ViewBag.BroadcastTo = sc.BroadcastTo; } return(campagins); }
private IQueryable <Campaign> FilterCampaignsBasic(IQueryable <Campaign> campagins, CampaignSearchVm sc) { if (!string.IsNullOrEmpty(sc.BasicString)) { campagins = campagins.Where(s => s.OrderNumber.Equals(sc.BasicString) || s.ReBroadcastedOrderNumber == sc.BasicString || s.CampaignName.ToLower().Contains(sc.BasicString.ToLower())); ViewBag.BasicStringSearched = sc.BasicString; } else if (!string.IsNullOrEmpty(sc.BasicStatus)) { int status = int.Parse(sc.BasicStatus); switch (status) { case (int)CampaignStatus.Rebroadcasted: campagins = campagins.Where(s => s.ReBroadcasted); break; case (int)CampaignStatus.NotRebroadcasted: campagins = campagins.Where(s => s.ReBroadCast && !s.ReBroadcasted); break; default: campagins = campagins.Where(s => s.Status == status); break; } ViewBag.BasicStatusSearched = sc.BasicStatus; } else if (!string.IsNullOrEmpty(sc.BasicOrderNumber)) { campagins = campagins.Where(s => s.Id.ToString().Equals(sc.BasicOrderNumber)); } return(campagins); }