public JsonResult AddProduct(SearchProductModel model)
{
var result = new JsonResultObject();
var count = 0;
if (model.ValidateProductIDs)
{
count = ActivityBLL.Instance.Activity_AddProduct(model.ActID, model.ProductIDs);
}
else
{
if (model.ValidateBatUpdate)
{
count = ActivityBLL.Instance.Activity_AddProduct(model.ActID, model.GetCFPath, model.BrandID, model.ProductID, model.ProductCode);
}
else
{
result.msg = "批量添加的时候,最少要一个条件";
}
}
if (count > 0)
{
result.status = true;
result.msg = "共操作" + count.ToString() + "条记录";
}
return(Json(result));
}
private void DoneButton_Click(object sender, EventArgs e)
{
var searchModel = new SearchProductModel()
{
Brand = this.BrandAutoCompleteTextView.Text,
Price = (this.PriceMinEditText.Text != "") ? (decimal?)decimal.Parse(this.PriceMinEditText.Text) : null,
PriceTo = (this.PriceMaxEditText.Text != "") ? (decimal?)decimal.Parse(this.PriceMaxEditText.Text) : null,
RAM = (this.RAMMinEditText.Text != "") ? (int?)int.Parse(this.RAMMinEditText.Text) : null,
RAMTo = (this.RAMMaxEditText.Text != "") ? (int?)int.Parse(this.RAMMaxEditText.Text) : null,
Year = (this.YearMinEditText.Text != "") ? (int?)int.Parse(this.YearMinEditText.Text) : null,
YearTo = (this.YearMaxEditText.Text != "") ? (int?)int.Parse(this.YearMaxEditText.Text) : null,
Battery = (this.BatteryMinEditText.Text != "") ? (int?)int.Parse(this.BatteryMinEditText.Text) : null,
BatteryTo = (this.BatteryMaxEditText.Text != "") ? (int?)int.Parse(this.BatteryMaxEditText.Text) : null,
Camera = (this.CameraMinEditText.Text != "") ? (int?)int.Parse(this.CameraMinEditText.Text) : null,
CameraTo = (this.CameraMaxEditText.Text != "") ? (int?)int.Parse(this.CameraMaxEditText.Text) : null,
Memory = (this.MemoryMinEditText.Text != "") ? (int?)int.Parse(this.MemoryMinEditText.Text) : null,
MemoryTo = (this.MemoryMaxEditText.Text != "") ? (int?)int.Parse(this.MemoryMaxEditText.Text) : null,
};
try
{
var resource = ProductAPIController.SearchProduct(searchModel).Result;
this.GridView.Adapter = new ProductsAdapter(this.context, resource, Resource.Layout.ProductAdapterItem);
}
catch (Exception)
{
throw;
}
this.Dismiss();
}
public DBResult InsertRecurringSearches(SearchProductModel entity)
{
DBResult result = new DBResult();
using (var db = new LiteDatabase(AppRuntime.LiteDbConnectionString))
{
try
{
var data = db.GetCollection <Schemas.Search.SearchProductModel>("RecurringSearches");
SearchProductModel searchItem = data.Find(Query.EQ("IdProduct", entity.IdProduct)).FirstOrDefault();
if (searchItem == null)
{
data.Insert(entity);
}
result.IsSucess = true;
}
catch (Exception ex)
{
result.IsSucess = false;
result.Message = ex.Message;
}
}
return(result);
}
/// <summary>
/// 根据条件查询产品
/// </summary>
/// <param name="model">查询条件Model</param>
/// <returns>Json数据</returns>
public ActionResult Search(SearchProductModel model)
{
model.LanguageId = ACultureHelper.GetLanguageID;
var result = this._productService.Search(model);
return(this.Json(new { rows = result.Data, total = result.Data.TotalCount }, JsonRequestBehavior.AllowGet));
}
public ApiResponse <ProductDetailsSummaryModel> GetAllProducts(SearchProductModel search)
{
var deviceNo = GetDeviceNo();
var products = _productServices.GetAllProducts(search, deviceNo);
return(ApiUtility.ApiSuccess <ProductDetailsSummaryModel>(products, "Search products using filter successfully"));
}
protected void Page_Load(object sender, EventArgs e)
{
SearchProduct su = new SearchProduct(CurrentAdmin, CurrentLanguage.Code);
model = su.Model;
callback = RequestTool.RequestString("callback");
}
public ActionResult GetStoreProducts(SearchProductModel model)
{
PackageProductsViewModel returnModel = new PackageProductsViewModel();
JObject response;
if (model.PackageId.HasValue == false || (model.PackageId.HasValue == true && model.PackageId.Value == 0))
{
response = AsyncHelpers.RunSync <JObject>(() => ApiCall.CallApi("api/Admin/SearchProducts", User, null, true, false, null, "ProductName=" + model.ProductName + "", "ProductPrice=" + model.ProductPrice, "CategoryName=" + model.CategoryName + "", "StoreId=" + model.StoreId));
if (response is Error)
{
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, (response as Error).ErrorMessage));
}
else
{
returnModel.Products = response.GetValue("Result").SelectToken("Products").ToObject <List <PackageProductViewModel> >();
}
}
else
{
response = AsyncHelpers.RunSync <JObject>(() => ApiCall.CallApi("api/Packages/GetPackageProducts", User, null, true, false, null, "PackageId=" + model.PackageId, "StoreId=" + model.StoreId));
if (response is Error)
{
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, (response as Error).ErrorMessage));
}
else
{
returnModel.Products = response.GetValue("Result").SelectToken("Products").ToObject <List <PackageProductViewModel> >();
}
}
return(PartialView("_PackageProducts", returnModel));
}
public IList <Product> GetProducts(SearchProductModel searchProduct)
{
if (!searchProduct.Validate())
{
throw new ArgumentException("SearchProductModel didn't pass validation");
}
return(_context.Query <Product>($@"
SELECT
ProductId
,ProductName
,ProductDescription
,ProductPrice
,ImageId
,AddedDate
FROM
Products
{CreateQuery(searchProduct)}
ORDER BY {searchProduct.OrderBy}{(searchProduct.IsDesc ? " DESC" : string.Empty)}
OFFSET @skip ROWS
FETCH NEXT @take ROWS ONLY
", new
{
skip = searchProduct.Skip,
take = searchProduct.Take
}
).ToList());
}
public async Task <IActionResult> Search(SearchProductModel instance)
{
var siteUri = new Uri("http://localhost:5002/api/Products/Search");
// ... Use HttpClient.
using (HttpClient client = new HttpClient())
{
var content = JsonConvert.SerializeObject(instance);
var buffer = System.Text.Encoding.UTF8.GetBytes(content);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
using (HttpResponseMessage response = await client.PostAsync(
siteUri, byteContent))
{
using (HttpContent cont = response.Content)
{
// ... Read the string.
string result = await cont.ReadAsStringAsync();
var products = JsonConvert.DeserializeObject <List <ProductModel> >(result);
return(RedirectToAction("IndexAsync", new { matchedProducts = result }));
}
}
}
}
public ProductDetailsSummaryModel GetAllProducts(SearchProductModel search, string deviceNo)
{
try
{
ProductDetailsSummaryModel objProduct = new ProductDetailsSummaryModel();
System.Configuration.AppSettingsReader settingsReader = new AppSettingsReader();
string host = (string)settingsReader.GetValue("WebHostName", typeof(String));
using (var productContract = new ProductContract())
{
var products = productContract.GetProducts(search, deviceNo, false);
objProduct.ProductList = products;
objProduct.FilterCategories = productContract.GetFilterCategory(products);
objProduct.FilterBrands = productContract.GetFilterBrand(products);
objProduct.FilterArtists = productContract.GetFilterArtists(products);
objProduct.FilterVendors = productContract.GetFilterVendors(products);
objProduct.ProductList.ForEach(x =>
{
x.ProductImages.ForEach(y =>
{
y.GalleryImageURL = y.GalleryImageURL.Replace("..", host);
y.ImageURL = y.ImageURL.Replace("..", host);
y.ThumbImageURL = y.ThumbImageURL.Replace("..", host);
});
});
if (objProduct.FilterCategories != null)
{
objProduct.FilterCategories.ForEach(x =>
{
x.PictureUrl = x.PictureUrl.Replace("..", host);
});
}
if (objProduct.FilterBrands != null)
{
objProduct.FilterBrands.ForEach(x =>
{
x.PictureURL = x.PictureURL.Replace("..", host);
});
}
if (objProduct.FilterArtists != null)
{
objProduct.FilterArtists.ForEach(x =>
{
x.PictureURL = x.PictureURL.Replace("..", host);
});
}
if (objProduct.FilterVendors != null)
{
objProduct.FilterVendors.ForEach(x =>
{
x.PictureURL = x.PictureURL.Replace("..", host);
});
}
return(objProduct);
}
}
catch
{
throw;
}
}
public List <ProductSummaryModel> GetFeaturedProducts(CurrencyTypeName currencyTypeName, string deviceNo)
{
try
{
System.Configuration.AppSettingsReader settingsReader = new AppSettingsReader();
string host = (string)settingsReader.GetValue("WebHostName", typeof(String));
var search = new SearchProductModel
{
CurrencyName = currencyTypeName,
};
using (var productContract = new ProductContract())
{
var products = productContract.GetProducts(search, deviceNo, true);
products.ForEach(x =>
{
x.ProductImages.ForEach(y =>
{
y.GalleryImageURL = y.GalleryImageURL.Replace("..", host);
y.ImageURL = y.ImageURL.Replace("..", host);
y.ThumbImageURL = y.ThumbImageURL.Replace("..", host);
});
});
return(products);
}
}
catch
{
throw;
}
}
public JsonResult GetAllProductsFromSupplier(string supplierID)
{
SearchProductModel productPerSupplier = new SearchProductModel();
//productPerSupplier.m_add_new_product = false;
//productPerSupplier.m_add_new_shipment = true;
long suppliershipid = Convert.ToInt32(supplierID);
string SQL = "SELECT * FROM PRODUCT INNER JOIN ";
SQL += " SHIPMENT_PRODUCT_DETAIL ON PRODUCT.productID = SHIPMENT_PRODUCT_DETAIL.productID INNER JOIN ";
SQL += " SHIPMENT_DETAIL ON SHIPMENT_PRODUCT_DETAIL.shipmentDetailsID = SHIPMENT_DETAIL.shipmentDetailsID INNER JOIN ";
SQL += " SHIPMENT ON SHIPMENT_DETAIL.shipmentID = SHIPMENT.shipmentID ";
SQL += " WHERE SHIPMENT.shipmentID = " + suppliershipid + "";
using (var dbContext = new WH01Entities())
{
var products = dbContext.PRODUCT.SqlQuery(SQL).ToList();
}
//if (supplierShipmentID != null)
//{
// using (var getProductPerSupplier = new WH01Entities())
// {
// var cptoadd = (from j in getProductPerSupplier.SHIPMENT_PRODUCT_DETAIL
// where j.SHIPMENT_DETAIL.SHIPMENT.shipmentID ==
// select new SearchProductModel()
// {
// m_productName = j.SUPPLIER2.
// m_productDescriptionLong = j.PRODUCT_DESCRIPTION.productDescLong,
// m_productColor = j.productColor,
// m_productPrice = j.productPrice,
// m_productSize = j.productSize,
// m_productWeight = j.productWeight,
// m_productSerialNumber = j.PRODUCT_DESCRIPTION.PRODUCT.productSerialNumber
// }).SingleOrDefault();
// addProduct.m_productName = cptoadd.m_productName;
// addProduct.m_productDescriptionLong = cptoadd.m_productDescriptionLong;
// addProduct.m_productColor = cptoadd.m_productColor;
// addProduct.m_productPrice = cptoadd.m_productPrice;
// addProduct.m_productSize = cptoadd.m_productSize;
// addProduct.m_productWeight = cptoadd.m_productWeight;
// addProduct.m_productSerialNumber = cptoadd.m_productSerialNumber;
// }
//}
return(Json(productPerSupplier, JsonRequestBehavior.AllowGet));
}
public SearchProductModel GetProd([FromBody] SearchRQModel list_rq)
{
Website.Instance.logger.Info($"WMS GetProd Start! B2D Xid:{list_rq.company_xid}");
var prods = new SearchProductModel();
prods = SearchRepository.GetProdList(list_rq);
return(prods);
}
public IHttpActionResult SearchProducts(SearchProductModel model)
{
return(RunInSafe(() =>
{
var data = _productService.SearchProducts(model);
tebResponse.Data = data.Result;
tebResponse.IsSuccess = true;
return Ok(tebResponse);
}));
}
public ActionResult GetProductList(Int64 Id)
{
ViewBag.SubCategory = Convert.ToString(_productSubCategoryRepository.FindBy(x => x.ProductSubCategoryId == Id).Select(x => x.ProductSubCategoryName).FirstOrDefault()).ToUpper();
SearchProductModel model = new SearchProductModel();
model.SubCategoryId = Id;
model.getProductModel = _productRepository.GetProductList().Where(x => x.ProductSubCategoryId == Id && x.Status == (int)Status.Active && x.IsDeleted == false).ToList();
return(View(model));
}
public List <ProductSummaryModel> GetProducts(SearchProductModel search, string deviceNo, bool isFeaturedProducts)
{
try
{
CurrencyTypeName currencyTypeName = search.CurrencyName;
using (var dataContext = new BrownBagDataEntities())
{
var isExclusiveUser = CheckExclusiveUser(dataContext, deviceNo.Trim());
var ratings = dataContext.Ratings.GroupBy(g => g.ProductID).Select(s2 => new { ProductId = s2.Key, Average = s2.Average(p => p.Rating1 ?? 0), ReviewCount = s2.Where(w => string.IsNullOrEmpty(w.Review)).Count() }).ToList();
var products = dataContext.Products
.Where(w => (isFeaturedProducts == false || w.IsRental == (isFeaturedProducts == true ? 1 : 0)) &&
w.Published == 1 &&
(isExclusiveUser == true || w.IsExclusive == (isExclusiveUser == true ? 1 : 0)) &&
(search.CategoryIds.Count == 0 || (search.CategoryIds.Any(k => k == (w.CategoryID ?? 0)))) &&
(search.BrandIds.Count == 0 || (search.BrandIds.Any(k => k == (w.ManufacturerID ?? 0)))) &&
(search.ArtistIds.Count == 0 || (search.ArtistIds.Any(k => k == (w.ArtistID ?? 0)))) &&
(search.VendorIds.Count == 0 || (search.VendorIds.Any(k => k == (w.VendorID ?? 0)))) &&
(search.ProductSearchText == null || search.ProductSearchText == "" || w.FullDescription.Contains(search.ProductSearchText) || w.ShortDescription.Contains(search.ProductSearchText) || w.ProductName.Contains(search.ProductSearchText))
).AsEnumerable()
.Select(s => new ProductSummaryModel
{
Id = s.Id,
CategoryId = s.CategoryID ?? 0,
ManufacturerId = s.ManufacturerID ?? 0,
ArtistId = s.ArtistID ?? 0,
VendorId = s.VendorID ?? 0,
CurrencyType = currencyTypeName.ToString(),
FullDescription = s.FullDescription ?? "",
ProductName = s.ProductName ?? "",
ShortDescription = s.ShortDescription ?? "",
Discount = s.Discount ?? 0,
Stock = s.Stock ?? 0,
IsExclusive = (s.IsExclusive ?? 0) == 1 ? true : false,
Price = (currencyTypeName == CurrencyTypeName.INR) ? s.CP_INR ?? 0 : (currencyTypeName == CurrencyTypeName.USD) ? s.CP_USD ?? 0 : (currencyTypeName == CurrencyTypeName.EURO) ? s.CP_Euro ?? 0 : s.CP_GBP ?? 0,
ProductImages = dataContext.ProductImages.Where(x => x.ProductID == s.Id).Select(s1 => new Model.ProductImage
{
Id = s1.Id,
GalleryImageURL = s1.GalleryImageURL,
ImageURL = s1.ImageURL,
ThumbImageURL = s1.ThumbImageURL,
Sequences = s1.Sequences ?? 0
}).OrderBy(o => o.Sequences).ToList(),
Rating = ratings.Where(w1 => w1.ProductId == s.Id).Count() > 0 ? ratings.Where(w1 => w1.ProductId == s.Id).FirstOrDefault().Average : 0,
ReviewCount = ratings.Where(w1 => w1.ProductId == s.Id).Count() > 0 ? ratings.Where(w1 => w1.ProductId == s.Id).FirstOrDefault().ReviewCount : 0,
})
.ToList();
return(products);
}
}
catch
{
throw;
}
}
public JsonResult ChangeProductPicture(string picture)
{
SearchProductModel addProduct = new SearchProductModel();
addProduct.m_add_new_product = true;
addProduct.m_add_new_shipment = false;
addProduct.m_productPicture = picture;
return(Json(addProduct, JsonRequestBehavior.AllowGet));
}
public ActionResult _GetProductList(SearchProductModel model)
{
var query = _productRepository.GetProductList().Where(x => x.ProductSubCategoryId == model.SubCategoryId && x.Status == (int)Status.Active && x.IsDeleted == false);
if (!string.IsNullOrEmpty(model.Search))
{
query = query.Where(x => x.ProductName.Contains(model.Search));
}
model.getProductModel = query.ToList();
return(PartialView(model));
}
public async Task <PaginatedResult <Product> > SearchPublicAsync(SearchProductModel req)
{
// filter
var queryObject = QueryObject <Product> .Empty;
if (!string.IsNullOrWhiteSpace(req.Keyword))
{
var keyword = req.Keyword;
queryObject.And(new ProductQueryObjects.ContainsKeyword(keyword));
}
// filter by category
if (!string.IsNullOrWhiteSpace(req.ProductCategoryName))
{
var keyword = req.ProductCategoryName;
queryObject.And(new ProductQueryObjects.FilterByCategory(keyword));
}
// filter by Owner
if (!string.IsNullOrWhiteSpace(req.OwnerName))
{
var keyword = req.OwnerName;
queryObject.And(new ProductQueryObjects.FilterBySeller(keyword));
}
// filter by MinPrice & MaxPrice
if (req.MaxPrice == 0)
{
req.MaxPrice = decimal.MaxValue;
}
if (req.MinPrice < 0)
{
req.MinPrice = decimal.Zero;
}
queryObject.And(new ProductQueryObjects.FilterByPrice(req.MinPrice, req.MaxPrice));
// orderby
if (!req.Sort.Any())
{
req.Sort.Add(new SortItem {
FieldName = nameof(Product.IdentityKey)
});
}
req.Sort.ForEach(x => queryObject.AddOrderBy(x.FieldName, x.IsDescending));
// execute
var result = await _genericRepo.SearchAsync(queryObject, req.Pagination, x => x.Include(m => m.Category).Include(m => m.Owner).Include(m => m.Photos));
return(result);
}
public PartialViewResult SearchProduct(int?actid, SearchProductModel model)
{
var sindex = 0;
int.TryParse(Request["sindex"], out sindex);
model.pageindex = sindex > 0 ? sindex : 1;
var str = new StringBuilder(" 1=1 ");
str.AppendFormat(" AND NOT EXISTS(SELECT * FROM ProductActivity pa where pa.ProductID = p.ProductID and pa.ActID ={0})", actid);
var cfid = 0;
if (model.CF3 > 0)
{
cfid = model.CF3;
}
else if (model.CF2 > 0)
{
cfid = model.CF2;
}
else if (model.CF1 > 0)
{
cfid = model.CF1;
}
if (cfid > 0)
{
var cf = ClassificationBLL.Instance.Classification_Get(cfid);
if (!string.IsNullOrWhiteSpace(cf.Path))
{
str.AppendFormat(" AND EXISTS (SELECT 1 FROM ProductClassification AS pc WHERE pc.ProductID =p.ProductID AND pc.CFPath LIKE '{0}%')", cf.Path);
}
}
if (model.ProductID > 0)
{
str.AppendFormat(" AND p.ProductID={0} ", model.ProductID);
}
if (!string.IsNullOrWhiteSpace(model.ProductCode))
{
str.AppendFormat(" AND p.ProductCode='{0}'", model.ProductCode);
}
if (model.BrandID > 0)
{
str.AppendFormat(" AND p.BrandID={0} ", model.BrandID);
}
int recordCount = 0;
var productlist = ProductBLL.Instance.Product_GetList(model.pageindex, model.pagesize, "0", str.ToString(), out recordCount);
var paged = new PagedList <ProductInfo>(productlist, model.pageindex, model.pagesize, recordCount);
ViewBag.SearchProductList = paged;
ViewBag.ActID = actid;
return(PartialView("_PartialSearchProduct"));
}
private static bool ChechSerach(SearchProductModel model, Product product)
{
return(((model.Price == null) || ((double)model.Price < (double)product.Price)) &&
((model.PriceTo == null) || ((double)model.PriceTo > (double)product.Price)) &&
((model.RAM == null) || (model.RAM < product.RAM)) &&
((model.RAMTo == null) || (model.RAMTo > product.RAM)) &&
((model.Year == null) || (model.Year < product.Year)) &&
((model.YearTo == null) || (model.YearTo > product.Year)) &&
((model.Battery == null) || (model.Battery < product.Battery)) &&
((model.BatteryTo == null) || (model.BatteryTo > product.Battery)) &&
((model.Camera == null) || (model.Camera > product.Camera)) &&
((model.CameraTo == null) || (model.CameraTo < product.Camera)) &&
((model.Memory == null) || (model.Memory > product.Memory)) &&
((model.MemoryTo == null) || (model.MemoryTo < product.Memory)) &&
((model.Brand == "") || (product.Brand.IndexOf(model.Brand) != -1)));
}
public ActionResult SearchProductResults(SearchProductModel model)
{
SearchProductsViewModel returnModel = new SearchProductsViewModel();
var response = AsyncHelpers.RunSync <JObject>(() => ApiCall.CallApi("api/Admin/SearchProducts", User, null, true, false, null, "ProductName=" + model.ProductName + "", "ProductPrice=" + model.ProductPrice, "CategoryName=" + model.CategoryName + "", "StoreId=" + Global.StoreId, "CatId=null"));
if (response is Error)
{
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, (response as Error).ErrorMessage));
}
else
{
returnModel = response.GetValue("Result").ToObject <SearchProductsViewModel>();
}
returnModel.SetSharedData(User);
return(PartialView("_SearchProductResults", returnModel));
}
public static async Task <List <Product> > SearchProduct(SearchProductModel searchProductModel)
{
Uri siteUri = new Uri("http://192.168.6.30:5002/api/Products/Search/");
using (HttpClient client = new HttpClient())
{
var content = JsonConvert.SerializeObject(searchProductModel);
var buffer = System.Text.Encoding.UTF8.GetBytes(content);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
var response = client.PostAsync(siteUri, byteContent).Result;
var res = response.Content.ReadAsStringAsync().Result;
var products = JsonConvert.DeserializeObject <List <Product> >(res);
return(products);
}
}
public void ProductService_Search_Test()
{
var model = new SearchProductModel
{
PagedIndex = 0,
PagedSize = 10,
//LanguageId = 1,
ProductId = 1
};
var result = this._productService.Search(model);
Assert.IsTrue(result.IsValid);
if (model.ProductId.HasValue)
{
Assert.IsTrue(result.Data != null);
}
}
public IActionResult Search(SearchProductModel form)
{
try
{
// form.code = form.code.ToLower().Trim() ?? "";
form.name = form.name.ToLower().Trim() ?? "";
var data = _db.Product
.Include(p => p.Type).Include(p => p.Manufacturer).Include(p => p.Category)
.Where(d =>
// d.Barcode.ToLower().Contains(form.code) &&
d.Name.ToLower().Contains(form.name))
.Select(d => new ProductModel(d));
return(Ok(new { Success = true, Data = data }));
}
catch (Exception e)
{
_logger.logError(e);
}
return(Ok(new { Success = false }));
}
public ActionResult NewProduct()
{
SearchProductModel addProduct = new SearchProductModel();
addProduct.m_add_new_product = true;
addProduct.m_add_new_shipment = false;
using (var searchPhrase = new WH01Entities())
{
var copiedProductsResult = from i in searchPhrase.PRODUCT_DESCRIPTION
where i.prodctCopied == true
select i;
addProduct.copiedProducts = new Dictionary <long, string>();
foreach (PRODUCT_DESCRIPTION pdesc in copiedProductsResult)
{
addProduct.copiedProducts.Add(pdesc.productID, pdesc.PRODUCT.productName);
}
}
return(View("NewProduct", addProduct));
}
public ActionResult SearchProduct()
{
SearchProductModel returnModel = new SearchProductModel();
var responseStores = AsyncHelpers.RunSync <JObject>(() => ApiCall.CallApi("api/GetAllStores", User, GetRequest: true));
if (responseStores == null || responseStores is Error)
{
}
else
{
var Stores = responseStores.GetValue("Result").ToObject <List <StoreBindingModel> >();
IEnumerable <SelectListItem> selectList = from store in Stores
select new SelectListItem
{
Selected = false,
Text = store.Name,
Value = store.Id.ToString()
};
Stores.Insert(0, new StoreBindingModel {
Id = 0, Name = "All"
});
returnModel.StoreOptions = new SelectList(selectList);
}
returnModel.SetSharedData(User);
//returnModel. returnModel.StoreId
if (returnModel.Role == RoleTypes.SubAdmin)
{
returnModel.StoreId = (returnModel as BaseViewModel).StoreId;
}
return(PartialView("_SearchProduct", returnModel));
}
public JsonResult PopulateCopiedProduct(long?productid)
{
SearchProductModel addProduct = new SearchProductModel();
addProduct.m_add_new_product = true;
addProduct.m_add_new_shipment = false;
if (productid != null)
{
using (var searchCopiedProduct = new WH01Entities())
{
var cptoadd = (from j in searchCopiedProduct.PRODUCT_DESCRIPTION_DETAIL
where j.PRODUCT_DESCRIPTION.PRODUCT.productID == productid
select new SearchProductModel()
{
m_productName = j.PRODUCT_DESCRIPTION.PRODUCT.productName,
m_productDescriptionLong = j.PRODUCT_DESCRIPTION.productDescLong,
m_productColor = j.productColor,
m_productPrice = j.productPrice,
m_productSize = j.productSize,
m_productWeight = j.productWeight,
m_productSerialNumber = j.PRODUCT_DESCRIPTION.PRODUCT.productSerialNumber
}).SingleOrDefault();
addProduct.m_productName = cptoadd.m_productName;
addProduct.m_productDescriptionLong = cptoadd.m_productDescriptionLong;
addProduct.m_productColor = cptoadd.m_productColor;
addProduct.m_productPrice = cptoadd.m_productPrice;
addProduct.m_productSize = cptoadd.m_productSize;
addProduct.m_productWeight = cptoadd.m_productWeight;
addProduct.m_productSerialNumber = cptoadd.m_productSerialNumber;
}
}
return(Json(addProduct, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> ProductList(DataSourceRequest command, ProductSearchViewModel model)
{
var categoryIds = model.SearchCategoryId > 0 ? new List <int> {
model.SearchCategoryId
} : null;
////include subcategories
//if (model.SearchIncludeSubCategories && model.SearchCategoryId > 0)
// categoryIds.AddRange(GetChildCategoryIds(model.SearchCategoryId));
bool?overridePublished = null;
if (model.SearchPublishedId == 1)
{
overridePublished = true;
}
else if (model.SearchPublishedId == 2)
{
overridePublished = false;
}
SearchProductModel searchmodel = new SearchProductModel
{
categoryIds = categoryIds,
manufacturerId = model.SearchManufacturerId,
storeId = model.SearchStoreId,
vendorId = model.SearchVendorId,
warehouseId = model.SearchWarehouseId,
productType = model.SearchProductTypeId > 0 ? (ProductType?)model.SearchProductTypeId : null,
keywords = model.SearchProductName,
pageIndex = command.Page - 1,
pageSize = command.PageSize,
showHidden = true,
overridePublished = overridePublished
};
TEBApiResponse apiResponse = await Post <SearchProductModel>("/Product/SearchProducts", searchmodel);
if (apiResponse.IsSuccess)
{
try
{
List <Product> listproducts = JsonConvert.DeserializeObject <List <Product> >(Convert.ToString(apiResponse.Data));
PagedList <Product> products = new PagedList <Product>(listproducts, 0, 10);
var gridModel = new DataSourceResult();
gridModel.Data = products.Select(x =>
{
var productModel = ProductMapping.ModelToView(x); // x.ToModel();
//little performance optimization: ensure that "FullDescription" is not returned
productModel.FullDescription = "";
////picture
//var defaultProductPicture = _pictureService.GetPicturesByProductId(x.Id, 1).FirstOrDefault();
//productModel.PictureThumbnailUrl = _pictureService.GetPictureUrl(defaultProductPicture, 75, true);
////product type
//productModel.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)
// productModel.StockQuantityStr = x.GetTotalStockQuantity().ToString();
return(productModel);
});
gridModel.Total = products.TotalCount;
return(Json(gridModel));
}
catch (Exception ex)
{
throw;
}
}
return(Json(0));
}
public static async Task <List <Product> > SearchProduct(SearchProductModel searchProductModel)
{
return(ProductDataBase.Select(a => a.Value).Where(a => ChechSerach(searchProductModel, a)).ToList());
}
