public ValidationResult_OSC DeleteCategory(int categoryId) { var result = new ValidationResult_OSC(); try { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var category = (from prodCat in entity.ProductCategories where prodCat.Id == categoryId select prodCat).First(); entity.ProductCategories.Remove(category); entity.SaveChanges(); result.Success = true; result.Message = "Product deleted successfully"; return result; } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; return result; } }
public Result<List<OnlineShoppingCart.Model.ProductCategory>> GetAllCategoryList() { var result = new Result<List<OnlineShoppingCart.Model.ProductCategory>>(); result.Data = new List<Model.ProductCategory>(); using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var listProdCat = new List<DataAccess.SQL.ProductCategory>(); listProdCat = entity.ProductCategories.ToList(); if (listProdCat == null || listProdCat.Count == 0) { result.Success = false; result.Data = null; result.Message = "No product category found"; } else { foreach (var prodCat in listProdCat) { OnlineShoppingCart.Model.ProductCategory _productCategory = null; prodCat.ConvertToBusinessObject(out _productCategory); result.Data.Add(_productCategory); } result.Success = true; } } return result; }
public ValidationResult_OSC AddListProductImageFilePath(List<OnlineShoppingCart.Model.ProductImageInfo> lstProductImageInfo) { var result = new ValidationResult_OSC(); try { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { foreach (var productImageInfo in lstProductImageInfo) { OnlineShoppingCart.DataAccess.SQL.ProductImageFilePath _product = new DataAccess.SQL.ProductImageFilePath { ProductId = productImageInfo.ProductId, ImageFilePath = productImageInfo.ImageFilePath, IsIndexImage = productImageInfo.IsIndexImage }; entity.ProductImageFilePaths.Add(_product); } entity.SaveChanges(); result.Success = true; result.Message = "Product image path information inserted successfully"; } return result; } catch (Exception ex) { result.Success = false; result.Message = ex.Message; return result; } }
public ValidationResult_OSC AddCategory(OnlineShoppingCart.Model.ProductCategory category) { var result = new ValidationResult_OSC(); try { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { OnlineShoppingCart.DataAccess.SQL.ProductCategory _category = new DataAccess.SQL.ProductCategory { Category = category.Category, IsActive = category.IsActive, CreatedOn = category.CreatedOn, UpdatedOn = category.UpdatedOn, CreatedByUserId = category.CreatedByUserID, UpdatedByUserId = category.UpdatedByUserID }; entity.ProductCategories.Add(_category); entity.SaveChanges(); result.Success = true; result.returnValue = Convert.ToString(_category.Id); result.Message = "Product category inserted successfully"; } return result; } catch (Exception ex) { result.Success = false; result.Message = ex.Message; return result; } }
public Result<List<OnlineShoppingCart.Model.ProductImageInfo>> GetListProductImageFilePath(int productId) { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var result = new Result<List<OnlineShoppingCart.Model.ProductImageInfo>>(); List<OnlineShoppingCart.DataAccess.SQL.ProductImageFilePath> lstProductImageFilePath = (from prod in entity.ProductImageFilePaths where prod.ProductId == productId select prod).ToList(); if (lstProductImageFilePath == null || lstProductImageFilePath.Count == 0) { result.Success = false; result.Data = null; result.Message = "No product image path information found"; } else { result.Data = new List<Model.ProductImageInfo>(); foreach (var productImageFilePath in lstProductImageFilePath) { OnlineShoppingCart.Model.ProductImageInfo productImageInfo = null; productImageFilePath.ConvertToBusinessObject(out productImageInfo); result.Data.Add(productImageInfo); } } return result; } }
public ValidationResult_OSC DeletProduct(int productId) { var result = new ValidationResult_OSC(); try { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var product = (from t in entity.Products where t.Id == productId select t).First(); entity.Products.Remove(product); entity.SaveChanges(); result.Success = true; result.Message = "Product deleted successfully"; return result; } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; return result; } }
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 AddProduct(OnlineShoppingCart.Model.Product product) { var result = new ValidationResult_OSC(); try { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { OnlineShoppingCart.DataAccess.SQL.Product _product = new DataAccess.SQL.Product { Model = product.Model, ProductCode = product.ProductCode, ProductName = product.ProductName, ProductDescription = product.ProductDescription, CategoryId = product.CategoryID, Brand = product.Brand, UnitPrice = product.UnitPrice, SKU = product.SKU, CurrentStock = product.CurrentStock, IsActive = product.IsActive, CreatedOn = product.CreatedOn, UpdatedOn = product.UpdatedOn, CreatedByUserId = product.CreatedByUserID, UpdatedByUserId = product.UpdatedByUserID }; entity.Products.Add(_product); entity.SaveChanges(); result.Success = true; result.returnValue = Convert.ToString(_product.Id); result.Message = "Product inserted successfully"; } return result; } catch (Exception ex) { result.Success = false; result.Message = ex.Message; return result; } }
public ValidationResult_OSC UpdateCategory(OnlineShoppingCart.Model.ProductCategory category) { var result = new ValidationResult_OSC(); try { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var _category = (from prodCat in entity.ProductCategories where prodCat.Id == category.ID select prodCat).First(); _category.Category = category.Category; _category.IsActive = category.IsActive; _category.CreatedOn = category.CreatedOn; _category.UpdatedOn = category.UpdatedOn; _category.CreatedByUserId = category.CreatedByUserID; _category.UpdatedByUserId = category.UpdatedByUserID; entity.SaveChanges(); result.Success = true; result.Message = "Product category updated successfully"; return result; } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; return result; } }
public Result<OnlineShoppingCart.Model.ProductCategory> GetCategory(int id) { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var result = new Result<OnlineShoppingCart.Model.ProductCategory>(); OnlineShoppingCart.DataAccess.SQL.ProductCategory _productCategory = (from prod in entity.ProductCategories where prod.Id == id select prod).FirstOrDefault(); if (_productCategory == null) { result.Success = false; result.Data = null; result.Message = "No product category found."; } else { OnlineShoppingCart.Model.ProductCategory _productCatModel = null; _productCategory.ConvertToBusinessObject(out _productCatModel); result.Data = _productCatModel; } 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 ValidationResult_OSC UpdateProduct(OnlineShoppingCart.Model.Product product) { var result = new ValidationResult_OSC(); try { using (OnlineShoppingCartEntities entity = new OnlineShoppingCartEntities()) { var _p = (from t in entity.Products where t.Id == product.ID select t).First(); _p.Model = product.Model; _p.ProductCode = product.ProductCode; _p.ProductName = product.ProductName; _p.ProductDescription = product.ProductDescription; _p.CategoryId = product.CategoryID; _p.Brand = product.Brand; _p.UnitPrice = product.UnitPrice; _p.SKU = product.SKU; _p.CurrentStock = product.CurrentStock; _p.IsActive = product.IsActive; _p.CreatedOn = product.CreatedOn; _p.UpdatedOn = product.UpdatedOn; _p.CreatedByUserId = product.CreatedByUserID; _p.UpdatedByUserId = product.UpdatedByUserID; entity.SaveChanges(); result.Success = true; result.Message = "Product updated successfully"; return result; } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; 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; } }