public ActionResult SubscriptionList(DataSourceRequest command, NewsLetterSubscriptionListModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageNewsletterSubscribers))
return AccessDeniedView();
bool? isActive = null;
if (model.ActiveId == 1)
isActive = true;
else if (model.ActiveId == 2)
isActive = false;
var newsletterSubscriptions = _newsLetterSubscriptionService.GetAllNewsLetterSubscriptions(model.SearchEmail,
model.StoreId, isActive, command.Page - 1, command.PageSize);
var gridModel = new DataSourceResult
{
Data = newsletterSubscriptions.Select(x =>
{
var m = x.ToModel();
var store = _storeService.GetStoreById(x.StoreId);
m.StoreName = store != null ? store.Name : "Unknown store";
m.CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc);
return m;
}),
Total = newsletterSubscriptions.TotalCount
};
return Json(gridModel);
}
public ActionResult QueuedEmailList(DataSourceRequest command, QueuedEmailListModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageMessageQueue))
return AccessDeniedView();
DateTime? startDateValue = (model.SearchStartDate == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.SearchStartDate.Value, _dateTimeHelper.CurrentTimeZone);
DateTime? endDateValue = (model.SearchEndDate == null) ? null
:(DateTime?)_dateTimeHelper.ConvertToUtcTime(model.SearchEndDate.Value, _dateTimeHelper.CurrentTimeZone).AddDays(1);
var queuedEmails = _queuedEmailService.SearchEmails(model.SearchFromEmail, model.SearchToEmail,
startDateValue, endDateValue,
model.SearchLoadNotSent, model.SearchMaxSentTries, true,
command.Page - 1, command.PageSize);
var gridModel = new DataSourceResult
{
Data = queuedEmails.Select(x => {
var m = x.ToModel();
m.CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc);
if (x.SentOnUtc.HasValue)
m.SentOn = _dateTimeHelper.ConvertToUserTime(x.SentOnUtc.Value, DateTimeKind.Utc);
return m;
}),
Total = queuedEmails.TotalCount
};
return new JsonResult
{
Data = gridModel
};
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
return Content("Access denied");
var pickupPoints = _storePickupPointService.GetAllStorePickupPoints();
var model = pickupPoints.Select(x =>
{
var store = _storeService.GetStoreById(x.StoreId);
return new StorePickupPointModel
{
Id = x.Id,
Name = x.Name,
OpeningHours = x.OpeningHours,
PickupFee = x.PickupFee,
StoreName = store != null ? store.Name
: x.StoreId == 0 ? _localizationService.GetResource("Admin.Configuration.Settings.StoreScope.AllStores") : string.Empty
};
}).ToList();
return Json(new DataSourceResult
{
Data = model,
Total = pickupPoints.TotalCount
});
}
public ActionResult AffiliatedCustomerList(int affiliateId, DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageAffiliates))
return AccessDeniedView();
var affiliate = _affiliateService.GetAffiliateById(affiliateId);
if (affiliate == null)
throw new ArgumentException("No affiliate found with the specified id");
var customers = _customerService.GetAllCustomers(
affiliateId: affiliate.Id,
pageIndex: command.Page - 1,
pageSize: command.PageSize);
var gridModel = new DataSourceResult
{
Data = customers.Select(customer =>
{
var customerModel = new AffiliateModel.AffiliatedCustomerModel();
customerModel.Id = customer.Id;
customerModel.Name = customer.Email;
return customerModel;
}),
Total = customers.TotalCount
};
return Json(gridModel);
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCustomers))
return AccessDeniedView();
var customers = _customerService.GetOnlineCustomers(DateTime.UtcNow.AddMinutes(-_customerSettings.OnlineCustomerMinutes),
null, command.Page - 1, command.PageSize);
var gridModel = new DataSourceResult
{
Data = customers.Select(x => new OnlineCustomerModel
{
Id = x.Id,
CustomerInfo = x.IsRegistered() ? x.Email : _localizationService.GetResource("Admin.Customers.Guest"),
LastIpAddress = x.LastIpAddress,
Location = _geoLookupService.LookupCountryName(x.LastIpAddress),
LastActivityDate = _dateTimeHelper.ConvertToUserTime(x.LastActivityDateUtc, DateTimeKind.Utc),
LastVisitedPage = _customerSettings.StoreLastVisitedPage ?
x.GetAttribute<string>(SystemCustomerAttributeNames.LastVisitedPage) :
_localizationService.GetResource("Admin.Customers.OnlineCustomers.Fields.LastVisitedPage.Disabled")
}),
Total = customers.TotalCount
};
return Json(gridModel);
}
public ActionResult CurrentCarts(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCurrentCarts))
return AccessDeniedView();
var customers = _customerService.GetAllCustomers(
loadOnlyWithShoppingCart: true,
sct: ShoppingCartType.ShoppingCart,
pageIndex: command.Page - 1,
pageSize: command.PageSize);
var gridModel = new DataSourceResult
{
Data = customers.Select(x =>
{
return new ShoppingCartModel()
{
CustomerId = x.Id,
CustomerEmail = x.IsRegistered() ? x.Email : _localizationService.GetResource("Admin.Customers.Guest"),
TotalItems = x.ShoppingCartItems.Where(sci => sci.ShoppingCartType == ShoppingCartType.ShoppingCart).ToList().GetTotalProducts()
};
}),
Total = customers.TotalCount
};
return Json(gridModel);
}
public ActionResult DeleteTrial(DataSourceRequest command, int TrialTrackerId)
{
var trial = _trialRepository.GetById(TrialTrackerId);
_trialRepository.Delete(trial);
return new NullJsonResult();
}
public ActionResult AdvertisementList(DataSourceRequest command, AdvertisementListModel model)
{
var ads = _advertisementService.SearchAdvertisements(
storeId: model.SearchStoreId,
vendorId: model.SearchVendorId,
keywords: model.SearchAdvertisementName,
pageIndex: command.Page - 1,
pageSize: command.PageSize);
var gridModel = new DataSourceResult();
gridModel.Data = ads.Select(x =>
{
var adModel = new ModelsMapper().CreateMap<Advertisement, AdvertisementModel>(x);
//little hack here:
//ensure that product full descriptions are not returned
//otherwise, we can get the following error if products have too long descriptions:
//"Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property. "
//also it improves performance
adModel.Description = string.Empty;
//picture
//var defaultProductPicture = _pictureService.GetPicturesByProductId(x.Id, 1).FirstOrDefault();
//adModel.PictureThumbnailUrl = _pictureService.GetPictureUrl(defaultProductPicture, 75, true);
////product type
//adModel.ProductTypeName = x.ProductType.GetLocalizedEnum(_localizationService, _workContext);
////friendly stock qantity
////if a simple product AND "manage inventory" is "Track inventory", then display
//if (x.ProductType == ProductType.SimpleProduct && x.ManageInventoryMethod == ManageInventoryMethod.ManageStock)
// adModel.StockQuantityStr = x.GetTotalStockQuantity().ToString();
return adModel;
});
gridModel.Total = ads.TotalCount;
return Json(gridModel);
}
public ActionResult BannerPicturesList(DataSourceRequest command, int? id)
{
if(!id.HasValue || id.Value == 0)
return new EmptyResult();
var bannerPictures = _promoBannerService.RetrievePicturesForBanner(id.Value);
var modelItems = bannerPictures.Select(sp => new PromoBannerPictureModel()
{
Id = sp.Id,
Comment = sp.Comment,
DisplaySequence = sp.DisplaySequence,
PictureId = sp.PictureId,
PromoReference = sp.PromoReference,
Url = sp.Url,
BannerId = id.Value
}).ToList();
if (modelItems != null && modelItems.Count() > 0)
{
modelItems.ToList().ForEach(i =>
{
i.PictureUrl = _pictureService.GetPictureUrl(i.PictureId);
});
}
var gridModel = new DataSourceResult
{
Data = modelItems,
Total = modelItems != null ? modelItems.Count() : 0
};
return Json(gridModel);
}
public ActionResult AuctionList(DataSourceRequest command, AuctionListModel model)
{
var auctions = _auctionService.GetAllAuctions().ToList();
var gridModel = new DataSourceResult();
gridModel.Data = auctions;
gridModel.Total = auctions.Count;
return Json(gridModel);
}
public ActionResult GetTrials(DataSourceRequest command)
{
var trials = _trialRepository.Table.ToList();
var gridModel = new DataSourceResult
{
Data = trials,
Total = trials.Count
};
return Json(gridModel);
}
public ActionResult GalleryList(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.AccessAdminPanel))
return AccessDeniedView();
var galleries = _productRepository.Table.Where(x => x.ProductTemplateId == 3).ToList();
var gridModel = new DataSourceResult
{
Data = galleries.Select(x => x.ToModel()),
Total = galleries.Count
};
return Json(gridModel);
}
public ActionResult CountryList(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCountries))
return AccessDeniedView();
var countries = _countryService.GetAllCountries(showHidden: true);
var gridModel = new DataSourceResult
{
Data = countries.Select(x => x.ToModel()),
Total = countries.Count
};
return Json(gridModel);
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageAttributes))
return AccessDeniedView();
var productAttributes = _productAttributeService
.GetAllProductAttributes(command.Page - 1, command.PageSize);
var gridModel = new DataSourceResult
{
Data = productAttributes.Select(x => x.ToModel()),
Total = productAttributes.TotalCount
};
return Json(gridModel);
}
public ActionResult List(PlayerListModel model, DataSourceRequest command)
{
var players = _playerService.GetAll(model.SearchLevel, model.SearchFullName);
var resultData = command.Page > 0 && command.PageSize > 0 ?
players.PagedForCommand(command).Select(x => x) :
players;
var gridModel = new DataSourceResult
{
Data = resultData,
Total = players.Count
};
return Json(gridModel);
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageScheduleTasks))
return AccessDeniedView();
var models = _scheduleTaskService.GetAllTasks(true)
.Select(PrepareScheduleTaskModel)
.ToList();
var gridModel = new DataSourceResult
{
Data = models,
Total = models.Count
};
return Json(gridModel);
}
public ActionResult CategoryTemplates(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageMaintenance))
return AccessDeniedView();
var templatesModel = _categoryTemplateService.GetAllCategoryTemplates()
.Select(x => x.ToModel())
.ToList();
var gridModel = new DataSourceResult
{
Data = templatesModel,
Total = templatesModel.Count
};
return Json(gridModel);
}
public ActionResult Categories(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageTaxSettings))
return AccessDeniedView();
var categoriesModel = _taxCategoryService.GetAllTaxCategories()
.Select(x => x.ToModel())
.ToList();
var gridModel = new DataSourceResult
{
Data = categoriesModel,
Total = categoriesModel.Count
};
return Json(gridModel);
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageStores))
return AccessDeniedView();
var storeModels = _storeService.GetAllStores()
.Select(x => x.ToModel())
.ToList();
var gridModel = new DataSourceResult
{
Data = storeModels,
Total = storeModels.Count()
};
return Json(gridModel);
}
public ActionResult LogList(DataSourceRequest command, LogListModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageSystemLog))
return AccessDeniedView();
DateTime? createdOnFromValue = (model.CreatedOnFrom == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.CreatedOnFrom.Value, _dateTimeHelper.CurrentTimeZone);
DateTime? createdToFromValue = (model.CreatedOnTo == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.CreatedOnTo.Value, _dateTimeHelper.CurrentTimeZone).AddDays(1);
LogLevel? logLevel = model.LogLevelId > 0 ? (LogLevel?)(model.LogLevelId) : null;
var logItems = _logger.GetAllLogs(createdOnFromValue, createdToFromValue, model.Message,
logLevel, command.Page - 1, command.PageSize);
var gridModel = new DataSourceResult
{
Data = logItems.Select(x =>
{
return new LogModel()
{
Id = x.Id,
LogLevel = x.LogLevel.GetLocalizedEnum(_localizationService, _workContext),
ShortMessage = x.ShortMessage,
//little hack here:
//ensure that FullMessage is not returned
//otherwise, we can get the following error if log records have too long FullMessage:
//"Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property. "
//also it improves performance
//FullMessage = x.FullMessage,
FullMessage = "",
IpAddress = x.IpAddress,
CustomerId = x.CustomerId,
CustomerEmail = x.Customer != null ? x.Customer.Email : null,
PageUrl = x.PageUrl,
ReferrerUrl = x.ReferrerUrl,
CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc)
};
}),
Total = logItems.TotalCount
};
return Json(gridModel);
}
public ActionResult Providers(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageTaxSettings))
return AccessDeniedView();
var taxProvidersModel = _taxService.LoadAllTaxProviders()
.Select(x => x.ToModel())
.ToList();
foreach (var tpm in taxProvidersModel)
tpm.IsPrimaryTaxProvider = tpm.SystemName.Equals(_taxSettings.ActiveTaxProviderSystemName, StringComparison.InvariantCultureIgnoreCase);
var gridModel = new DataSourceResult
{
Data = taxProvidersModel,
Total = taxProvidersModel.Count()
};
return Json(gridModel);
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCampaigns))
return AccessDeniedView();
var campaigns = _campaignService.GetAllCampaigns();
var gridModel = new DataSourceResult
{
Data = campaigns.Select(x =>
{
var model = x.ToModel();
model.CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc);
return model;
}),
Total = campaigns.Count
};
return Json(gridModel);
}
public ActionResult Weights(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageMeasures))
return AccessDeniedView();
var weightsModel = _measureService.GetAllMeasureWeights()
.Select(x => x.ToModel())
.ToList();
foreach (var wm in weightsModel)
wm.IsPrimaryWeight = wm.Id == _measureSettings.BaseWeightId;
var gridModel = new DataSourceResult
{
Data = weightsModel,
Total = weightsModel.Count
};
return Json(gridModel);
}
public ActionResult ContactFormList(DataSourceRequest command, ContactFormListModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageMessageContactForm))
return AccessDeniedView();
DateTime? startDateValue = (model.SearchStartDate == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.SearchStartDate.Value, _dateTimeHelper.CurrentTimeZone);
DateTime? endDateValue = (model.SearchEndDate == null) ? null
:(DateTime?)_dateTimeHelper.ConvertToUtcTime(model.SearchEndDate.Value, _dateTimeHelper.CurrentTimeZone).AddDays(1);
int vendorId = 0;
if (_workContext.CurrentVendor != null)
{
vendorId = _workContext.CurrentVendor.Id;
}
var contactform = _contactUsService.GetAllContactUs(
fromUtc:startDateValue,
toUtc: endDateValue,
email: model.SearchEmail,
storeId: model.StoreId,
vendorId: vendorId,
pageIndex: command.Page - 1,
pageSize: command.PageSize);
var gridModel = new DataSourceResult
{
Data = contactform.Select(x => {
var store = _storeService.GetStoreById(x.StoreId);
var m = x.ToModel();
m.CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc);
m.Enquiry = "";
m.Email = m.FullName + " - " + m.Email;
m.Store = store != null ? store.Name : "-empty-";
return m;
}),
Total = contactform.TotalCount
};
return new JsonResult
{
Data = gridModel
};
}
public ActionResult RatesList(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageTaxSettings))
return Content("Access denied");
var records = _taxRateService.GetAllTaxRates(command.Page - 1, command.PageSize);
var taxRatesModel = records
.Select(x =>
{
var m = new TaxRateModel()
{
Id = x.Id,
StoreId = x.StoreId,
TaxCategoryId = x.TaxCategoryId,
CountryId = x.CountryId,
StateProvinceId = x.StateProvinceId,
Zip = x.Zip,
Percentage = x.Percentage,
};
//store
var store = _storeService.GetStoreById(x.StoreId);
m.StoreName = (store != null) ? store.Name : "*";
//tax category
var tc = _taxCategoryService.GetTaxCategoryById(x.TaxCategoryId);
m.TaxCategoryName = (tc != null) ? tc.Name : "";
//country
var c = _countryService.GetCountryById(x.CountryId);
m.CountryName = (c != null) ? c.Name : "Unavailable";
//state
var s = _stateProvinceService.GetStateProvinceById(x.StateProvinceId);
m.StateProvinceName = (s != null) ? s.Name : "*";
//zip
m.Zip = (!String.IsNullOrEmpty(x.Zip)) ? x.Zip : "*";
return m;
})
.ToList();
var gridModel = new DataSourceResult
{
Data = taxRatesModel,
Total = records.TotalCount
};
return Json(gridModel);
}
public ActionResult GroupDealPictureList(DataSourceRequest command, int groupDealId)
{
//if (!_permissionService.Authorize(StandardPermissionProvider.ManageProducts))
// return AccessDeniedView();
//a vendor should have access only to his products
if (_workContext.CurrentVendor != null)
{
var groupdeal = _groupDealRepo.GetById(groupDealId);
if (groupdeal != null && groupdeal.VendorId != _workContext.CurrentVendor.Id)
{
return Content("This is not your product");
}
}
var productPictures = _productService.GetProductPicturesByProductId(groupDealId);
var groupdealPicturesModel = productPictures
.Select(x =>
{
var picture = _pictureService.GetPictureById(x.PictureId);
if (picture == null)
throw new Exception("Picture cannot be loaded");
var m = new GroupdealPictureViewModel
{
Id = x.Id,
GroupdealId = x.ProductId,
PictureId = x.PictureId,
PictureUrl = _pictureService.GetPictureUrl(picture),
OverrideAltAttribute = picture.AltAttribute,
OverrideTitleAttribute = picture.TitleAttribute,
DisplayOrder = x.DisplayOrder
};
return m;
})
.ToList();
var gridModel = new DataSourceResult
{
Data = groupdealPicturesModel,
Total = groupdealPicturesModel.Count
};
return Json(gridModel);
}
public ActionResult ForumGroupList(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageForums))
return AccessDeniedView();
var forumGroups = _forumService.GetAllForumGroups();
var gridModel = new DataSourceResult
{
Data = forumGroups.Select(fg =>
{
var model = fg.ToModel();
model.CreatedOn = _dateTimeHelper.ConvertToUserTime(fg.CreatedOnUtc, DateTimeKind.Utc);
return model;
}),
Total = forumGroups.Count
};
return Json(gridModel);
}
public ActionResult QueuedEmailList(DataSourceRequest command, QueuedEmailListModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageMessageQueue))
return AccessDeniedView();
DateTime? startDateValue = (model.SearchStartDate == null) ? null
: (DateTime?)_dateTimeHelper.ConvertToUtcTime(model.SearchStartDate.Value, _dateTimeHelper.CurrentTimeZone);
DateTime? endDateValue = (model.SearchEndDate == null) ? null
:(DateTime?)_dateTimeHelper.ConvertToUtcTime(model.SearchEndDate.Value, _dateTimeHelper.CurrentTimeZone).AddDays(1);
var queuedEmails = _queuedEmailService.SearchEmails(model.SearchFromEmail, model.SearchToEmail,
startDateValue, endDateValue,
model.SearchLoadNotSent, false, model.SearchMaxSentTries, true,
command.Page - 1, command.PageSize);
var gridModel = new DataSourceResult
{
Data = queuedEmails.Select(x => {
var m = x.ToModel();
m.PriorityName = x.Priority.GetLocalizedEnum(_localizationService, _workContext);
m.CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc);
if (x.DontSendBeforeDateUtc.HasValue)
m.DontSendBeforeDate = _dateTimeHelper.ConvertToUserTime(x.DontSendBeforeDateUtc.Value, DateTimeKind.Utc);
if (x.SentOnUtc.HasValue)
m.SentOn = _dateTimeHelper.ConvertToUserTime(x.SentOnUtc.Value, DateTimeKind.Utc);
//little hack here:
//ensure that email body is not returned
//otherwise, we can get the following error if emails have too long body:
//"Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property. "
//also it improves performance
m.Body = "";
return m;
}),
Total = queuedEmails.TotalCount
};
return new JsonResult
{
Data = gridModel
};
}
public ActionResult Configure(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageTaxSettings))
return Content("Access denied");
var taxRateModels = new List<FixedTaxRateModel>();
foreach (var taxCategory in _taxCategoryService.GetAllTaxCategories())
taxRateModels.Add(new FixedTaxRateModel()
{
TaxCategoryId = taxCategory.Id,
TaxCategoryName = taxCategory.Name,
Rate = GetTaxRate(taxCategory.Id)
});
var gridModel = new DataSourceResult
{
Data = taxRateModels,
Total = taxRateModels.Count
};
return Json(gridModel);
}
public ActionResult SubscriptionList(DataSourceRequest command, NewsLetterSubscriptionListModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageNewsletterSubscribers))
return AccessDeniedView();
var newsletterSubscriptions = _newsLetterSubscriptionService.GetAllNewsLetterSubscriptions(model.SearchEmail,
command.Page - 1, command.PageSize, true);
var gridModel = new DataSourceResult
{
Data = newsletterSubscriptions.Select(x =>
{
var m = x.ToModel();
m.CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc);
return m;
}),
Total = newsletterSubscriptions.TotalCount
};
return Json(gridModel);
}