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);
}
