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 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 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 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 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 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 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 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 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 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 Configure(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
return Content("Access denied");
var rateModels = new List<FixedShippingRateModel>();
foreach (var shippingMethod in _shippingService.GetAllShippingMethods())
rateModels.Add(new FixedShippingRateModel()
{
ShippingMethodId = shippingMethod.Id,
ShippingMethodName = shippingMethod.Name,
Rate = GetShippingRate(shippingMethod.Id)
});
var gridModel = new DataSourceResult
{
Data = rateModels,
Total = rateModels.Count
};
return Json(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);
}
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);
//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 List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageWidgets))
return AccessDeniedView();
var widgetsModel = new List<WidgetModel>();
var widgets = _widgetService.LoadAllWidgets();
foreach (var widget in widgets)
{
var tmp1 = widget.ToModel();
tmp1.IsActive = widget.IsWidgetActive(_widgetSettings);
widgetsModel.Add(tmp1);
}
widgetsModel = widgetsModel.ToList();
var gridModel = new DataSourceResult
{
Data = widgetsModel,
Total = widgetsModel.Count()
};
return Json(gridModel);
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageEmailAccounts))
return AccessDeniedView();
var emailAccountModels = _emailAccountService.GetAllEmailAccounts()
.Select(x => x.ToModel())
.ToList();
foreach (var eam in emailAccountModels)
eam.IsDefaultEmailAccount = eam.Id == _emailAccountSettings.DefaultEmailAccountId;
var gridModel = new DataSourceResult
{
Data = emailAccountModels,
Total = emailAccountModels.Count()
};
return new JsonResult
{
Data = gridModel
};
}
public ActionResult Methods(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageExternalAuthenticationMethods))
return AccessDeniedView();
var methodsModel = new List<AuthenticationMethodModel>();
var methods = _openAuthenticationService.LoadAllExternalAuthenticationMethods();
foreach (var method in methods)
{
var tmp1 = method.ToModel();
tmp1.IsActive = method.IsMethodActive(_externalAuthenticationSettings);
methodsModel.Add(tmp1);
}
methodsModel = methodsModel.ToList();
var gridModel = new DataSourceResult
{
Data = methodsModel,
Total = methodsModel.Count
};
return Json(gridModel);
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManagePolls))
return AccessDeniedView();
var polls = _pollService.GetPolls(0, false, command.Page - 1, command.PageSize, true);
var gridModel = new DataSourceResult
{
Data = polls.Select(x =>
{
var m = x.ToModel();
if (x.StartDateUtc.HasValue)
m.StartDate = _dateTimeHelper.ConvertToUserTime(x.StartDateUtc.Value, DateTimeKind.Utc);
if (x.EndDateUtc.HasValue)
m.EndDate = _dateTimeHelper.ConvertToUserTime(x.EndDateUtc.Value, DateTimeKind.Utc);
m.LanguageName = x.Language.Name;
return m;
}),
Total = polls.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 => 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 ValueList(int checkoutAttributeId, DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageAttributes))
return AccessDeniedView();
var values = _checkoutAttributeService.GetCheckoutAttributeValues(checkoutAttributeId);
var gridModel = new DataSourceResult
{
Data = values.Select(x => new CheckoutAttributeValueModel
{
Id = x.ID,
CheckoutAttributeId = x.CheckoutAttributeId,
Name = x.CheckoutAttribute.AttributeControlType != AttributeControlType.ColorSquares ? x.Name : string.Format("{0} - {1}", x.Name, x.ColorSquaresRgb),
ColorSquaresRgb = x.ColorSquaresRgb,
PriceAdjustment = x.PriceAdjustment,
WeightAdjustment = x.WeightAdjustment,
IsPreSelected = x.IsPreSelected,
DisplayOrder = x.DisplayOrder,
}),
Total = values.Count()
};
return Json(gridModel);
}
public ActionResult List(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageAttributes))
return AccessDeniedView();
var checkoutAttributes = _checkoutAttributeService.GetAllCheckoutAttributes();
var gridModel = new DataSourceResult
{
Data = checkoutAttributes.Select(x =>
{
var attributeModel = x.ToModel();
attributeModel.AttributeControlTypeName = x.AttributeControlType.GetLocalizedEnum(_localizationService, _workContext);
return attributeModel;
}),
Total = checkoutAttributes.Count()
};
return Json(gridModel);
}
public ActionResult StatesAndProvinces(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
return AccessDeniedView();
var states = _shippingService.GetStatesAndProvinces();
var model = new DataSourceResult
{
Data = states
};
return Json(states, JsonRequestBehavior.AllowGet);
}
public ActionResult Providers(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
return AccessDeniedView();
var shippingProvidersModel = new List<ShippingRateComputationMethodModel>();
var shippingProviders = _shippingService.LoadAllShippingRateComputationMethods();
foreach (var shippingProvider in shippingProviders)
{
var tmp1 = shippingProvider.ToModel();
tmp1.IsActive = shippingProvider.IsShippingRateComputationMethodActive(_shippingSettings);
tmp1.LogoUrl = shippingProvider.PluginDescriptor.GetLogoUrl(_webHelper);
shippingProvidersModel.Add(tmp1);
}
shippingProvidersModel = shippingProvidersModel.ToList();
var gridModel = new DataSourceResult
{
Data = shippingProvidersModel,
Total = shippingProvidersModel.Count()
};
return Json(gridModel);
}
public ActionResult PickupAreas(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
return AccessDeniedView();
var pickupAreasModel = _shippingService.GetPickupAreas();
var gridModel = new DataSourceResult
{
Data = pickupAreasModel,
Total = pickupAreasModel.Count
};
return Json(gridModel);
}
public ActionResult Methods(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
return AccessDeniedView();
var shippingMethodsModel = _shippingService.GetAllShippingMethods()
.Select(x => x.ToModel())
.ToList();
var gridModel = new DataSourceResult
{
Data = shippingMethodsModel,
Total = shippingMethodsModel.Count
};
return Json(gridModel);
}
