public Int32 ManageEntity(string EntityID, string EntityName, string IsActive)
{
UserMaster objUserMaster = new UserMaster();
objUserMaster = (UserMaster)Session["LoggedInUser"];
Int32 intResult = 0;
try
{
if (ValidateSession())
{
ProductParameter objProductParameter = new ProductParameter();
var Result = objSP_PRICINGEntities.SP_MANAGE_ENTITY_MASTER_LIST(Convert.ToInt32(EntityID), EntityName, Convert.ToBoolean(IsActive), objUserMaster.UserID);
intResult = Convert.ToInt32(Result.SingleOrDefault());
}
return(intResult);
}
catch (Exception ex)
{
LogError(ex.Message, ex.StackTrace, "BlackscholesPricersController", "FetchFixedCouponMLDList", objUserMaster.UserID);
return(0);
}
}
public async Task <IActionResult> PutProductParameter([FromRoute] int id, [FromBody] ProductParameter productParameter)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != productParameter.Id)
{
return(BadRequest());
}
_context.Entry(productParameter).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductParameterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public HorizontalShopsCollectionPciVm(string groupId, string productId, ProductParameter parameter)
: base(parameter)
{
GroupId = groupId;
ProductId = productId;
Items = new ObservableCollection <IShopAvailabilityItemVM>();
}
public HorizontalProductsCollectionPciVm(string groupId, string productId, ProductParameter parameter)
: base(parameter)
{
GroupId = groupId;
ProductId = productId;
Items = new ObservableCollection <ICatalogItemVM>();
}
public Int32 ManageProductParameter(string ID, string UnderlyingID, string IV, string RFR, string BuiltInAdjustment)
{
UserMaster objUserMaster = new UserMaster();
objUserMaster = (UserMaster)Session["LoggedInUser"];
Int32 intResult = 0;
try
{
if (ValidateSession())
{
ProductParameter objProductParameter = new ProductParameter();
var Result = objSP_PRICINGEntities.SP_MANAGE_PRODUCT_PARAMETERS(Convert.ToInt32(ID), Convert.ToInt32(UnderlyingID), Convert.ToDouble(IV), Convert.ToDouble(RFR), Convert.ToDouble(BuiltInAdjustment), objUserMaster.UserID);
intResult = Convert.ToInt32(Result.SingleOrDefault());
}
return(intResult);
}
catch (Exception ex)
{
LogError(ex.Message, ex.StackTrace, "BlackscholesPricersController", "FetchFixedCouponMLDList", objUserMaster.UserID);
return(0);
}
}
public void TestGetByPage()
{
ProductParameter parameter = new ProductParameter();
parameter.ProductName = "笔";
var res = ProductBiz.GetListByPage(parameter);
}
private void RemoveTreeNode(ProductParameter model)
{
if (ModelTrees.Any(x => x.id == model.id))
{
var node = ModelTrees.FirstOrDefault(x => x.id == model.id);
ModelTrees.Remove(node);//删除左侧树形
}
}
public TransitionPciVm(string groupId, string productId, ProductParameter parameter)
: base(parameter)
{
ProductGroupId = groupId;
ProductId = productId;
Value = parameter.DataType == ProductDataType.Custom ? parameter.Content : string.Empty;
}
/// <summary>
/// 保存商品
/// </summary>
/// <param name="productParameter"></param>
/// <returns></returns>
public async Task <ReturnResult> SaveAsync(ProductParameter productParameter)
{
ReturnResult result = new ReturnResult();
//新建商品
if (productParameter.Id <= 0)
{
//创建商品
var product = Mapper.Map <Product>(productParameter);
if (product.CreateTime == DateTime.MinValue)
{
product.CreateTime = DateTime.Now;
}
product.Quantity = productParameter.Skus.Sum(c => c.Quantity);
//设置商品状态
if (!Enum.IsDefined(typeof(EProductStatus), productParameter.Status))
{
product.Status = EProductStatus.New;
}
await context.Products.AddAsync(product);
await context.SaveChangesAsync();
//创建商品图片
var imgs = Mapper.Map <List <ProductImg> >(productParameter.Imgs);
imgs.ForEach(c => c.ProductId = product.Id);
await context.ProductImgs.AddRangeAsync(imgs);
await context.SaveChangesAsync();
//创建商品标签
if (productParameter.Tags != null && productParameter.Tags.Count > 0)
{
var tags = Mapper.Map <List <ProductTag> >(productParameter.Tags);
tags.ForEach(c => c.ProductId = product.Id);
await context.ProductTags.AddRangeAsync(tags);
await context.SaveChangesAsync();
}
//创建商品sku
productParameter.Skus.ForEach(c => c.ProductId = product.Id);
foreach (var item in productParameter.Skus)
{
var sku = Mapper.Map <Sku>(item);
await context.Skus.AddAsync(sku);
await context.SaveChangesAsync();
//创建商品规格
var specifications = Mapper.Map <List <SkuSpecification> >(item.SkuSpecifications);
specifications.ForEach(c => c.SkuId = sku.Id);
await context.SkuSpecifications.AddRangeAsync(specifications);
await context.SaveChangesAsync();
}
}
return(result);
}
private void UpdateTreeNode(ProductParameter model)
{
if (ModelTrees.Any(x => x.id == model.id))
{
var node = ModelTrees.FirstOrDefault(x => x.id == model.id);
node.Name = model.product_name;
node.DisplayName = model.product_name;
}
}
private void AddTreeNode(ProductParameter model)
{
TreeNodeData n = new TreeNodeData()
{
id = model.id, Name = model.product_name, DisplayName = model.product_name
};
ModelTrees.Add(n);
}
public ActionResult SyncProduct(int id)
{
var model = new ProductParameter
{
Id = id,
SyncProperties = SyncProperties.Price
};
return(PartialView("~/Plugins/Affiliate.Amazon/Views/SyncProduct.cshtml", model));
}
public async Task <ActionResult <ProductPresenter> > Put([FromBody] ProductParameter product, long productCode)
{
var result = await _productService.Update(productCode, product.ToModel());
if (result is null)
{
return(NotFound());
}
return(new ProductPresenter(result));
}
public Pager <Product> GetList([FromBody] ProductParameter parameter)
{
var res = ProductBiz.GetListByPage(parameter);
// 测试获取用户身份信息
var claims = _httpContextAccessor.HttpContext.User.Claims;
// 测试写入日志信息
Log4Helper.Debug("控制器中调用GetList方法，调用者：" + MyHttpContext.UserName);
return(res);
}
public async Task <IActionResult> PostProductParameter([FromBody] ProductParameter productParameter)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.ProductParameters.Add(productParameter);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetProductParameter", new { id = productParameter.Id }, productParameter));
}
public void TestGetListByPage()
{
// 查询第2页数据
ProductParameter parameter = new ProductParameter();
parameter.PageIndex = 2;
parameter.PageSize = 10;
var res = BLL.ProductMgr.GetListByPage(parameter);
Assert.IsTrue(res.Total > 0 && res.Rows != null);
}
public ActionResult SyncProduct(ProductParameter model)
{
SyncProperties syncProperties = model.SyncProperties;
var storeScope = this.GetActiveStoreScopeConfiguration(_storeService, _workContext);
var amazonSettings = _settingService.LoadSetting <AffiliateAmazonSettings>(storeScope);
if (AffAmazonContext.Instance.Count > 0)
{
_amazonService.SyncProduct(_productRepo, _productMappingRepo, storeScope, model.Id, syncProperties);
}
return(Json(new { }));
}
public ActionResult SyncProducts(ProductParameter model)
{
var storeScope = this.GetActiveStoreScopeConfiguration(_storeService, _workContext);
var amazonSettings = _settingService.LoadSetting <AffiliateAmazonSettings>(storeScope);
if (AffAmazonContext.Instance.Count > 0)
{
_amazonService.SyncProducts(_categoryService, _categoryMappingService, _categoryAmazonRepo, storeScope, model.CategoryID, model.Keywords, SyncProperties.All);
}
return(Json(new { Status = true, Message = "Processing" }));
}
public ActionResult ReadProduct(DataSourceRequest command, ProductParameter model)
{
var result = _productAmazonService.GetAllByCategoryId(model, command.Page, command.PageSize);
var gridData = new
{
data = result,
totalCount = result.TotalCount
};
var json = Json(gridData);
return(json);
}
public bool Insert(ProductParameter model)
{
long id = _productParameterService.InsertBigIdentity(model);
if (id > 0)
{
model.id = (int)id;
ModelList.Add(model);
AddTreeNode(model);
return(true);
}
return(false);
}
public void GetListByPage(HttpContext context)
{
int pageIndex = int.Parse(context.Request["pageIndex"]);
int pageSize = int.Parse(context.Request["pageSize"]);
ProductParameter parameter = new ProductParameter();
parameter.PageIndex = pageIndex;
parameter.PageSize = pageSize;
Pager <Product> result = ProductMgr.GetListByPage(parameter);
string json = JsonConvert.SerializeObject(result);
context.Response.Write(json);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="IsUpdateDetails">更新明细</param>
/// <returns></returns>
public bool Update(ProductParameter model, bool IsUpdateDetails = true)
{
if (model.id > 0)
{
if (_productParameterService.UpdateEntity(model))
{
UpdateTreeNode(model);//更新树形菜单
return(true);
}
}
else
{
return(Insert(model));
}
return(false);
}
public bool Add(ProductParameter _ProductParameter)
{
try
{
_ProductParameter.CreatedDate = DateTime.Now;
_ProductParameter.CreatedByUserId = DatabaseTools.GetUserID;
contaxt.ProductParameters
.Add(_ProductParameter);
contaxt.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public async Task <ProductDTO> UpdateProducts(ProductDTO productDTO, int id)
{
var product = _context.Products.Include(t => t.ProductParameters)
.Where(t => t.Id == id)
.FirstOrDefault();
product.PrimeCostEUR = productDTO.PrimeCostEUR;
product.ProductTypeId = productDTO.ProductTypeId;
product.Number = productDTO.Number;
product.Amount = productDTO.Amount;
product.PrimeCostEUR = productDTO.PrimeCostEUR;
product.Manufacturer = productDTO.Manufacturer;
foreach (var paramDTO in productDTO.Parameters)
{
if (string.IsNullOrEmpty(paramDTO.Value))
{
continue;
}
if (paramDTO.Id == 0)
{
var param = new ProductParameter()
{
ProductId = product.Id,
ParameterId = paramDTO.ParameterId,
Value = paramDTO.Value
};
_context.ProductParameters.Add(param);
}
else
{
var existingParam = product.ProductParameters.Where(p => p.Id == paramDTO.Id).FirstOrDefault();
if (existingParam != null)
{
existingParam.Value = paramDTO.Value;
}
}
}
await _context.SaveChangesAsync();
return(productDTO);
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Configurations.Add(User.Map());
modelBuilder.Configurations.Add(Role.Map());
modelBuilder.Configurations.Add(Corporation.Map());
modelBuilder.Configurations.Add(Product.Map());
modelBuilder.Configurations.Add(Entities.ProductUnit.Map());
modelBuilder.Configurations.Add(ProductCategory.Map());
modelBuilder.Configurations.Add(InventoryInsType.Map());
modelBuilder.Configurations.Add(InventoryInsHeader.Map());
modelBuilder.Configurations.Add(InventoryInsDeatil.Map());
modelBuilder.Configurations.Add(InventoryOutsType.Map());
modelBuilder.Configurations.Add(InventoryOutsHeader.Map());
modelBuilder.Configurations.Add(InventoryOutsDeatil.Map());
modelBuilder.Configurations.Add(ProductParameterValue.Map());
modelBuilder.Configurations.Add(ProductParameter.Map());
base.OnModelCreating(modelBuilder);
}
public IPagedList <ProductAmazonModel> GetAllByCategoryId(ProductParameter model, int pageIndex = 1, int pageSize = 25)
{
var _amazonProvider = EngineContext.Current.Resolve <IAmazonProvider>();
var result = _amazonProvider.GetAllProduct(model);
int count = result.Count();
var ids = result.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToArray();
//var data = result.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
if (ids != null)
{
//var ids = data.Select(x => x.ProductId).ToArray();
var maps = _productMappingRepository.TableNoTracking.Where(m => ids.Contains(m.ProductId)).ToList();
var data = new List <ProductAmazonModel>();
var _currencyService = EngineContext.Current.Resolve <ICurrencyService>();
ids.ToList().ForEach(x =>
{
var product = _productService.GetProductById(x);
var map = maps.FirstOrDefault(m => m.ProductId == x);
if (map != null && product != null)
{
var item = new ProductAmazonModel
{
ASIN = map.ProductSourceId,
DetailUrl = map.ProductSourceLink,
Id = map.Id,
Name = product.Name,
Price = _currencyService.ConvertFromPrimaryStoreCurrency(product.Price, _currencyService.GetCurrencyByCode("USD")).ToString(),
PriceSource = map.Price.ToString(),
ProductId = product.Id
};
var productPicture = _productPictureRepository.TableNoTracking.OrderBy(pp => pp.DisplayOrder).FirstOrDefault(pp => pp.ProductId == x);
if (productPicture != null)
{
item.Image = _pictureService.GetPictureUrl(productPicture.PictureId, 0);
}
data.Add(item);
}
});
return(new PagedList <ProductAmazonModel>(data, pageIndex, pageSize, count));
}
return(null);
}
public ActionResult Product()
{
var categories = _categoryService.GetAllCategories("", 1);
var model = new ProductParameter
{
Keywords = "",
CategoryID = 0,
SyncProperties = SyncProperties.Attributes | SyncProperties.Images | SyncProperties.Price | SyncProperties.Variations,
Categories = categories.Select(x => new SelectListItem
{
Value = x.Id.ToString(),
Text = x.GetFormattedBreadCrumb(_categoryService)
}).ToList(),
};
model.Categories.Insert(0, new SelectListItem {
Text = "Select Category", Value = "0"
});
return(View("~/Plugins/Affiliate.Amazon/Views/Product.cshtml", model));
}
public static Pager <Product> GetListByPage(ProductParameter parameter)
{
Pager <Product> result = new Pager <Product>();
using (SaleContext db = new SaleContext())
{
var query = db.Product.AsQueryable();
if (!string.IsNullOrEmpty(parameter.ProductName))
{
query = query.Where(t => t.ProductName.Contains(parameter.ProductName));
}
result.Total = query.Count();
result.Rows = query.OrderBy(t => t.ProductID)
.Skip(parameter.Skip)
.Take(parameter.PageSize)
.ToList();
return(result);
}
}
public void LoadAllInfos()
{
ModelTrees.Clear();
ModelList.Clear();
var list = _productParameterService.QueryableToList(x => x.id > 0).OrderBy(x => x.product_name).ToList();
if (list != null && list.Count > 0)
{
foreach (var item in list)
{
ModelList.Add(item);
AddTreeNode(item);
}
EditModel = list[0];
}
else
{
EditModel = new ProductParameter();
}
}
public async Task <ProductDTO> AddProducts(ProductDTO productDTO)
{
var EntryProduct = _context.Products.Find(productDTO.ProductId);
if (EntryProduct != null)
{
return(productDTO);
}
var product = new Product
{
ProductTypeId = productDTO.ProductTypeId,
Number = productDTO.Number,
Amount = productDTO.Amount,
PrimeCostEUR = productDTO.PrimeCostEUR,
Manufacturer = productDTO.Manufacturer
};
_context.Products.Add(product);
foreach (var paramDTO in productDTO.Parameters)
{
if (string.IsNullOrEmpty(paramDTO.Value))
{
continue;
}
var param = new ProductParameter()
{
ProductId = product.Id,
ParameterId = paramDTO.ParameterId,
Value = paramDTO.Value
};
_context.ProductParameters.Add(param);
}
await _context.SaveChangesAsync();
return(productDTO);
}
