public Result<List<OnlineShoppingCart.Model.Product>> GetProductList_GenericSearch(string productInfo, int categoryID) { var result = new Result<List<OnlineShoppingCart.Model.Product>>(); result.Data = new List<Model.Product>(); using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var listProd = (from prod in entity.Products.Include("ProductCategories") where (((productInfo == null || productInfo.Trim() == "") || prod.ProductCode.Contains(productInfo) || prod.ProductName.Contains(productInfo) || prod.ProductDescription.Contains(productInfo) || prod.Brand.Contains(productInfo) || prod.Model.Contains(productInfo))) && (categoryID == prod.CategoryId) select new OnlineShoppingCart.Model.Product { ID = prod.Id, ProductCode = prod.ProductCode, ProductName = prod.ProductName, ProductDescription = prod.ProductDescription, CategoryID = prod.CategoryId, CategoryName = prod.ProductCategory.Category, Brand = prod.Brand, Model = prod.Model, UnitPrice = prod.UnitPrice, SKU = prod.SKU, CurrentStock = prod.CurrentStock, IsActive = prod.IsActive, CreatedOn = prod.CreatedOn, UpdatedOn = prod.UpdatedOn, CreatedByUserID = prod.CreatedByUserId, UpdatedByUserID = prod.UpdatedByUserId }).ToList(); if (listProd == null) { result.Success = false; result.Data = null; result.Message = "No product found for given search criteria"; } else { foreach (var _product in listProd) { DAL.ProductImage productImage = new ProductImage(); var resultProductImageList = productImage.GetListProductImageFilePath(_product.ID); if (resultProductImageList.Success) _product.ProductImageInfoList = resultProductImageList.Data; result.Data.Add(_product); } result.Success = true; } } return result; }
public ValidationResult_OSC PostProductImageInfo([FromBody] List<OnlineShoppingCart.Model.ProductImageInfo> lstProductImageInfo) { var result = new ValidationResult_OSC(); //validate that string path is not empty bool listNotValid = lstProductImageInfo.Any(cus => String.IsNullOrWhiteSpace(cus.ImageFilePath)); if (listNotValid) { result.AddMessage("One or more image path are empty."); return result; } ProductImage productImageDAL = new ProductImage(); result = productImageDAL.AddListProductImageFilePath(lstProductImageInfo); return result; }
public Result<List<OnlineShoppingCart.Model.Product>> GetAllProduct() { var result = new Result<List<OnlineShoppingCart.Model.Product>>(); result.Data = new List<Model.Product>(); using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var listProd = entity.Products.ToList(); if (listProd == null) { result.Success = false; result.Data = null; result.Message = "No product found"; } else { foreach (var it in listProd) { OnlineShoppingCart.Model.Product _product = null; it.ConvertToBusinessObject(out _product); DAL.ProductImage productImage = new ProductImage(); var resultProductImageList = productImage.GetListProductImageFilePath(_product.ID); if (resultProductImageList.Success) _product.ProductImageInfoList = resultProductImageList.Data; result.Data.Add(_product); } result.Success = true; } } return result; }
public Result<OnlineShoppingCart.Model.Product> GetProduct(int id) { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var result = new Result<OnlineShoppingCart.Model.Product>(); OnlineShoppingCart.DataAccess.SQL.Product _product = (from prod in entity.Products where prod.Id == id select prod).FirstOrDefault(); if (_product == null) { result.Success = false; result.Data = null; result.Message = "No product found"; } else { OnlineShoppingCart.Model.Product _productModel = null; _product.ConvertToBusinessObject(out _productModel); DAL.ProductImage productImage = new ProductImage(); var resultProductImageList = productImage.GetListProductImageFilePath(_productModel.ID); if (resultProductImageList.Success) _productModel.ProductImageInfoList = resultProductImageList.Data; result.Data = _productModel; } return result; } }