public JsonResult StoreDashboardReport()
{
var allOrders = _orderService.GetOrders(0, 0, null, null, null, null, null, null, null);
var registeredRoleId = _customerService.GetCustomerRoleBySystemName("Registered").Id;
var model = new StoreDashboardReportModel
{
ProductsCount = _catalogSearchService.PrepareQuery(new CatalogSearchQuery()).Count().ToString("N0"),
CategoriesCount = _categoryService.BuildCategoriesQuery(showHidden: true).Count().ToString("N0"),
ManufacturersCount = _manufacturerService.GetManufacturers().Count().ToString("N0"),
AttributesCount = _productAttributeService.GetAllProductAttributes(0, int.MaxValue).TotalCount.ToString("N0"),
AttributeCombinationsCount = _productService.CountAllProductVariants().ToString("N0"),
MediaCount = _mediaService.CountFiles(new MediaSearchQuery {
Deleted = false
}).ToString("N0"),
CustomersCount = _customerService.SearchCustomers(
new CustomerSearchQuery
{
Deleted = false,
CustomerRoleIds = new int[] { registeredRoleId }
}
).TotalCount.ToString("N0"),
OrdersCount = allOrders.Count().ToString("N0"),
Sales = (allOrders.Sum(x => (decimal?)x.OrderTotal) ?? 0).ToString("C0"),
OnlineCustomersCount = _customerService.GetOnlineCustomers(DateTime.UtcNow.AddMinutes(-15), null, 0, int.MaxValue).TotalCount.ToString("N0"),
CartsValue = _shoppingCartService.GetAllOpenCartSubTotal().ToString("C0"),
WishlistsValue = _shoppingCartService.GetAllOpenWishlistSubTotal().ToString("C0")
};
return(new JsonResult
{
Data = new { model },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult List()
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCatalog))
{
return(AccessDeniedView());
}
var productAttributes = _productAttributeService.GetAllProductAttributes();
var gridModel = new GridModel <ProductAttributeModel>
{
Data = productAttributes.Select(x => x.ToModel()),
Total = productAttributes.Count()
};
return(View(gridModel));
}
public ActionResult List(GridCommand command)
{
var gridModel = new GridModel <ProductAttributeModel>();
if (_permissionService.Authorize(StandardPermissionProvider.ManageCatalog))
{
var productAttributes = _productAttributeService.GetAllProductAttributes();
var data = productAttributes
.ForCommand(command)
.Select(x =>
{
var model = x.ToModel();
return(model);
})
.ToList();
gridModel.Data = data.PagedForCommand(command);
gridModel.Total = data.Count;
}
else
{
gridModel.Data = Enumerable.Empty <ProductAttributeModel>();
NotifyAccessDenied();
}
return(new JsonResult
{
Data = gridModel
});
}
public ActionResult List()
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCatalog))
{
return(AccessDeniedView());
}
var productAttributes = _productAttributeService.GetAllProductAttributes();
var data = productAttributes.Select(x => { x.Name = x.GetLocalized(z => z.Name, _workContext.WorkingLanguage.Id); return(x); }).ToList();
var gridModel = new GridModel <ProductAttributeModel>
{
Data = data.Select(x => x.ToModel()),
Total = productAttributes.Count()
};
return(View(gridModel));
}
// AJAX.
public ActionResult AllProductAttributes(string label, int selectedId)
{
var query = _productAttributeService.GetAllProductAttributes(0, int.MaxValue).SourceQuery;
var pager = new FastPager <ProductAttribute>(query, 500);
var allAttributes = new List <dynamic>();
while (pager.ReadNextPage(out var attributes))
{
foreach (var attribute in attributes)
{
dynamic obj = new
{
attribute.Id,
attribute.DisplayOrder,
Name = attribute.GetLocalized(x => x.Name).Value
};
allAttributes.Add(obj);
}
}
var data = allAttributes
.OrderBy(x => x.DisplayOrder)
.Select(x => new ChoiceListItem
{
Id = x.Id.ToString(),
Text = x.Name,
Selected = x.Id == selectedId
})
.ToList();
if (label.HasValue())
{
data.Insert(0, new ChoiceListItem
{
Id = "0",
Text = label,
Selected = false
});
}
return(new JsonResult {
Data = data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public IActionResult List(DataSourceRequest command)
{
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));
}
// Ajax.
public ActionResult AllProductAttributes(string label, int selectedId)
{
var allAttributes = new Dictionary <int, string>();
for (var pageIndex = 0; pageIndex < 9999999; ++pageIndex)
{
var attributes = _productAttributeService.GetAllProductAttributes(pageIndex, 500);
foreach (var attribute in attributes)
{
allAttributes[attribute.Id] = attribute.GetLocalized(x => x.Name).Value;
}
if (!attributes.HasNextPage)
{
break;
}
}
var data = allAttributes
.Where(x => x.Value.HasValue())
.Select(x => new
{
id = x.Key,
text = x.Value,
selected = x.Key == selectedId
})
.ToList();
if (label.HasValue())
{
data.Insert(0, new { id = 0, text = label, selected = false });
}
return(new JsonResult {
Data = data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
private void GetColorAndSizeId(ref int colorAttributeId, ref int sizeAttributeId)
{
foreach (var att in _productAttributeService.GetAllProductAttributes())
{
if (att.Name.ToUpper() == "COLOR")
{
colorAttributeId = att.Id;
}
else if (att.Name.ToUpper() == "SIZE")
{
sizeAttributeId = att.Id;
}
}
}
// Ajax.
public ActionResult AllProductAttributes(string label, int selectedId)
{
var attributes = _productAttributeService.GetAllProductAttributes();
if (label.HasValue())
{
attributes.Insert(0, new ProductAttribute {
Name = label, Id = 0
});
}
var query =
from attr in attributes
select new
{
id = attr.Id.ToString(),
text = attr.Name,
selected = attr.Id == selectedId
};
return(new JsonResult {
Data = query.ToList(), JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Configure()
{
var model = new ConfigurationModel();
model.UrlAttributeId = _licenseSettings.UrlAttributeId;
model.DomainAttributeId = _licenseSettings.DomainAttributeId;
model.ProductAttributes = _productAttributeService.GetAllProductAttributes().Select(a => new SelectListItem {
Value = a.Id.ToString(), Text = a.Name
}).ToList();
model.ProductAttributes.Insert(0, new SelectListItem {
Value = "0", Text = "None"
});
model.LicenseTypes = LicenseType.Url.ToSelectList();
return(View("~/Plugins/Misc.Licenses/Views/Configure.cshtml", model));
}
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 HttpResponseMessage Get(HttpRequestMessage request, int pageIndex = 0, int pageSize = int.MaxValue)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No items found");
var prodAttributes = _productAttributeService.GetAllProductAttributes(pageIndex, pageSize);
if (prodAttributes != null)
{
var gridModel = new DataSourceResult
{
Data = prodAttributes.Select(x => x.ToModel()),
Total = prodAttributes.TotalCount
};
response = request.CreateResponse <DataSourceResult>(HttpStatusCode.OK, gridModel);
}
return response;
}));
}
/// <summary>
/// Prepare paged product attribute list model
/// </summary>
/// <param name="searchModel">Product attribute search model</param>
/// <returns>Product attribute list model</returns>
public virtual ProductAttributeListModel PrepareProductAttributeListModel(ProductAttributeSearchModel searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException(nameof(searchModel));
}
//get product attributes
var productAttributes = _productAttributeService
.GetAllProductAttributes(pageIndex: searchModel.Page - 1, pageSize: searchModel.PageSize);
//prepare list model
var model = new ProductAttributeListModel().PrepareToGrid(searchModel, productAttributes, () =>
{
//fill in model values from the entity
return(productAttributes.Select(attribute => attribute.ToModel <ProductAttributeModel>()));
});
return(model);
}
/// <summary>
/// Prepare paged product attribute list model
/// </summary>
/// <param name="searchModel">Product attribute search model</param>
/// <returns>Product attribute list model</returns>
public virtual ProductAttributeListModel PrepareProductAttributeListModel(ProductAttributeSearchModel searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException(nameof(searchModel));
}
//get product attributes
var productAttributes = _productAttributeService
.GetAllProductAttributes(pageIndex: searchModel.Page - 1, pageSize: searchModel.PageSize);
//prepare list model
var model = new ProductAttributeListModel
{
//fill in model values from the entity
Data = productAttributes.Select(attribute => attribute.ToModel()),
Total = productAttributes.TotalCount
};
return(model);
}
private void InstallAttributes(CcSettings settings)
{
var attributes = _productAttributeService.GetAllProductAttributes();
var specificationAttributes = _specificationAttributeService.GetSpecificationAttributes();
var ccIdAttribute = attributes.FirstOrDefault(x => x.Name == "CcId");
if (ccIdAttribute == null)
{
ccIdAttribute = new ProductAttribute()
{
Name = "CcId"
};
_productAttributeService.InsertProductAttribute(ccIdAttribute);
}
var editorDefinitionSpecificationAttribute = specificationAttributes.FirstOrDefault(x => x.Name == "CC Editor");
if (editorDefinitionSpecificationAttribute == null)
{
editorDefinitionSpecificationAttribute = new SpecificationAttribute
{
Name = "CC Editor",
DisplayOrder = 100
};
_specificationAttributeService.InsertSpecificationAttribute(editorDefinitionSpecificationAttribute);
}
var editorDefinitionSpecificationOption = editorDefinitionSpecificationAttribute.SpecificationAttributeOptions.FirstOrDefault(x => x.Name == "CC Editor");
if (editorDefinitionSpecificationOption == null)
{
editorDefinitionSpecificationOption = new SpecificationAttributeOption
{
DisplayOrder = 0,
Name = "CC Editor",
SpecificationAttributeId = editorDefinitionSpecificationAttribute.Id
};
_specificationAttributeService.InsertSpecificationAttributeOption(editorDefinitionSpecificationOption);
}
var editorConfigurationSpecificationAttribute = specificationAttributes.FirstOrDefault(x => x.Name == "CC EditorConfig");
if (editorConfigurationSpecificationAttribute == null)
{
editorConfigurationSpecificationAttribute = new SpecificationAttribute
{
Name = "CC EditorConfig",
DisplayOrder = 100
};
_specificationAttributeService.InsertSpecificationAttribute(editorConfigurationSpecificationAttribute);
}
var editorConfigurationSpecificationOption = editorDefinitionSpecificationAttribute.SpecificationAttributeOptions.FirstOrDefault(x => x.Name == "CC EditorConfig");
if (editorConfigurationSpecificationOption == null)
{
editorConfigurationSpecificationOption = new SpecificationAttributeOption
{
DisplayOrder = 0,
Name = "CC EditorConfig",
SpecificationAttributeId = editorConfigurationSpecificationAttribute.Id
};
_specificationAttributeService.InsertSpecificationAttributeOption(editorConfigurationSpecificationOption);
}
// add to settings
settings.CcIdAttributeId = ccIdAttribute.Id;
settings.EditorDefinitionSpecificationAttributeId = editorDefinitionSpecificationAttribute.Id;
settings.EditorDefinitionSpecificationOptionId = editorDefinitionSpecificationOption.Id;
settings.EditorConfigurationSpecificationAttributeId = editorConfigurationSpecificationAttribute.Id;
settings.EditorConfigurationSpecificationOptionId = editorConfigurationSpecificationOption.Id;
}
public IActionResult ProductAttributes()
{
var customerAttr = _productAttributeService.GetAllProductAttributes().Select(x => new { Id = x.Id, Name = x.Name });
return(Json(customerAttr));
}
public IActionResult CreateProductAttrs([ModelBinder(typeof(JsonModelBinder <CustomeProductAttributesDto>))] Delta <CustomeProductAttributesDto> customeProductAttributesDtoDelta)
{
// Here we display the errors if the validation has failed at some point.
if (!ModelState.IsValid)
{
return(Error());
}
var list = _productAttributeService.GetAllProductAttributes().Select(l => l.Name.ToLower().Trim()).ToList();
if (!list.Contains(customeProductAttributesDtoDelta.Dto.AttributeName.ToLower().Trim()))
{
var productAttribute = new ProductAttribute()
{
Description = customeProductAttributesDtoDelta.Dto.Description,
Id = 0,
Name = customeProductAttributesDtoDelta.Dto.AttributeName
};
_productAttributeService.InsertProductAttribute(productAttribute);
CustomerActivityService.InsertActivity("AddNewProductAttribute", LocalizationService.GetResource("ActivityLog.AddNewProductAttribute"), productAttribute);
}
//get Product By SKU
var product = _productService.GetProductBySku(customeProductAttributesDtoDelta.Dto.Sku);
if (product == null)
{
return(Error(HttpStatusCode.NotFound, "product", "not found"));
}
var attr = _productAttributeService.GetProductAttributeByAXId(customeProductAttributesDtoDelta.Dto.AttributeId);
if (attr == null)
{
if (customeProductAttributesDtoDelta.Dto.Values.Count > 0)
{
var prodAttr = _productAttributeService.GetProductAttributeByName(customeProductAttributesDtoDelta.Dto.AttributeName);
//create
var tempAttr = new ProductAttributeMapping()
{
AttrIdAX = customeProductAttributesDtoDelta.Dto.AttributeId,
AttributeControlType = AttributeControlType.DropdownList,
ProductId = product.Id,
ProductAttributeId = prodAttr.Id,
IsRequired = true,
};
_productAttributeService.InsertProductAttributeMapping(tempAttr);
//
foreach (var item in customeProductAttributesDtoDelta.Dto.Values)
{
_productAttributeService.InsertProductAttributeValue(new ProductAttributeValue()
{
Id = 0,
ProductAttributeMappingId = tempAttr.Id,
Name = item.Text,
PriceAdjustment = item.Price,
DisplayOrder = item.DisplayOrder,
});
}
}
}
else
{
var prodAttr = _productAttributeService.GetProductAttributeByName(customeProductAttributesDtoDelta.Dto.AttributeName);
if (customeProductAttributesDtoDelta.Dto.Values.Count == 0)
{
_productAttributeService.DeleteProductAttributeMapping(attr);
}
else
{
//edit
attr.ProductAttributeId = prodAttr.Id;
_productAttributeService.UpdateProductAttributeMapping(attr);
//
var listofValues = _productAttributeService.GetProductAttributeValues(attr.Id);
//delete
foreach (var item in listofValues)
{
_productAttributeService.DeleteProductAttributeValue(item);
}
foreach (var item in customeProductAttributesDtoDelta.Dto.Values)
{
_productAttributeService.InsertProductAttributeValue(new ProductAttributeValue()
{
Id = 0,
ProductAttributeMappingId = attr.Id,
Name = item.Text,
PriceAdjustment = item.Price,
DisplayOrder = item.DisplayOrder,
});
}
}
}
var customeProductAttributesRootObjectDto = new CustomeProductAttributesRootObjectDto();
customeProductAttributesRootObjectDto.ProductAttributes.Add(new CustomeProductAttributesDto()
{
AttributeId = 123456,
AttributeName = "Test",
Description = "Test",
Sku = "1200",
Values = new List <ValueDto>()
{
new ValueDto()
{
DisplayOrder = 0,
Price = 1222,
Text = "Test"
}
,
new ValueDto()
{
DisplayOrder = 0,
Price = 1222,
Text = "Test"
}
}
});
var json = JsonFieldsSerializer.Serialize(customeProductAttributesRootObjectDto, string.Empty);
return(new RawJsonActionResult("Done"));
}
public async Task<IActionResult> ProductAttributes()
{
var customerAttr = (await _productAttributeService.GetAllProductAttributes()).Select(x => new { Id = x.Id, Name = x.Name });
return Json(customerAttr);
}
