public IActionResult GetStyleProductList(SearchProductListModel searchModel) { try { string scheme = this.Request.Scheme; scheme += "://" + this.Request.Host + this.Request.PathBase; StyleCampaignList styleCampaignList = new StyleCampaignList(); if (searchModel.pageNo <= 0) { searchModel.pageNo = 1; } styleCampaignList = iStyleCampaign.GetStyleCampaignList(DBHelper.ParseString((int)ProductCategoryEnum.Styles), searchModel.searchString, searchModel.pageNo, searchModel.limit, searchModel.CategoryTypeId, scheme, searchModel.column, searchModel.direction); if (styleCampaignList != null) { return(Ok(ResponseHelper.Success(styleCampaignList))); } else { return(Ok(ResponseHelper.Error(MessageConstants.DataNotFound))); } } catch (Exception ex) { LogHelper.ExceptionLog(ex.Message + " ::::: " + ex.StackTrace); return(Ok(ResponseHelper.Error(ex.Message))); } }
/// <summary> /// Gets the style campaign list. /// </summary> /// <param name="productCategoryId">The product category identifier.</param> /// <param name="searchText">The search text.</param> /// <param name="pageNo">The page no.</param> /// <param name="recordPerPage">The record per page.</param> /// <param name="productCategoryTypeId">The product category type identifier.</param> /// <param name="hostingPath">The hosting path.</param> /// <param name="column">The column.</param> /// <param name="direction">The direction.</param> /// <returns></returns> /// <exception cref="NotImplementedException"></exception> public StyleCampaignList GetStyleCampaignList(string productCategoryId, string searchText, int pageNo, int recordPerPage, string productCategoryTypeId, string hostingPath, string column, string direction) { StyleCampaignList styleCampaignListModel = new StyleCampaignList(); try { SqlParameter[] parameters = new SqlParameter[7]; parameters[0] = new SqlParameter("PRODUCTCATEGORYID", productCategoryId); parameters[1] = new SqlParameter("SEARCHSTRING", searchText); parameters[2] = new SqlParameter("PAGENO", pageNo); parameters[3] = new SqlParameter("RECORDPERPAGE", recordPerPage); parameters[4] = new SqlParameter("PRODUCTCATEGORYTYPEID", productCategoryTypeId); parameters[5] = new SqlParameter("COLUMN", column); parameters[6] = new SqlParameter("DIRECTION", direction); DataSet dataSet = DBHelper.GetDataTable("GETPRODUCTSLIST", parameters, DBHelper.ParseString(settings.Value.AppDbContext)); if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count > 0) { DataTable dtProduct = dataSet.Tables[0]; DataTable dtCategory = dataSet.Tables[1]; DataTable dtProductCategory = dataSet.Tables[2]; DataTable dtTotal = dataSet.Tables[3]; DataTable dtPopular = new DataTable(); if (dataSet.Tables.Count > 4) { dtPopular = dataSet.Tables[4]; } List <StyleCampaignProductList> ProductList = new List <StyleCampaignProductList>(); List <ProductCategoryListModel> productCategoryList = new List <ProductCategoryListModel>(); if (dtProduct != null && dtProduct.Rows.Count > 0) { if (dtPopular == null || dtPopular.Rows.Count <= 0) { foreach (DataRow item in dtProduct.Rows) { string category = string.Empty; DataRow[] drCategory = dtProductCategory.Select("ProductFK='" + DBHelper.ParseString(item["ProductId"]) + "'"); if (drCategory != null && drCategory.Length > 0) { foreach (var cat in drCategory) { category += DBHelper.ParseString(cat["CategoryType"]) + ","; } category = category.TrimEnd(','); } string image = string.Empty; if (!string.IsNullOrWhiteSpace(DBHelper.ParseString(item["Image"]))) { image = hostingPath + Constants.ProductImagesPath.Replace(@"\", "/") + "/" + DBHelper.ParseString(item["Image"]); } else { image = hostingPath + Constants.NoImageAvaliablePath.Replace(@"\", "/"); } ProductList.Add(new StyleCampaignProductList { Category = category, Image = image, Price = DBHelper.ParseString(item["Price"]), ProductId = DBHelper.ParseString(item["ProductId"]), ProductName = DBHelper.ParseString(item["ProductName"]), ProductColorId = DBHelper.ParseString(item["ProductColorId"]), }); } } else { foreach (DataRow popular in dtProduct.Rows) { DataRow[] item = dtProduct.Select("ProductId='" + popular["ProductId"] + "'"); if (item != null && item.Length > 0) { string category = string.Empty; DataRow[] drCategory = dtProductCategory.Select("ProductFK='" + DBHelper.ParseString(item[0]["ProductId"]) + "'"); if (drCategory != null && drCategory.Length > 0) { foreach (var cat in drCategory) { category += DBHelper.ParseString(cat["CategoryType"]) + ","; } category = category.TrimEnd(','); } string image = string.Empty; if (!string.IsNullOrWhiteSpace(DBHelper.ParseString(item[0]["Image"]))) { image = hostingPath + Constants.ProductImagesPath.Replace(@"\", "/") + "/" + DBHelper.ParseString(item[0]["Image"]); } else { image = hostingPath + Constants.NoImageAvaliablePath.Replace(@"\", "/"); } ProductList.Add(new StyleCampaignProductList { Category = category, Image = image, Price = DBHelper.ParseString(item[0]["Price"]), ProductId = DBHelper.ParseString(item[0]["ProductId"]), ProductName = DBHelper.ParseString(item[0]["ProductName"]), ProductColorId = DBHelper.ParseString(item[0]["ProductColorId"]), }); } } } } if (dtCategory != null && dtCategory.Rows.Count > 0) { foreach (DataRow item in dtCategory.Rows) { productCategoryList.Add(new ProductCategoryListModel { Name = DBHelper.ParseString(item["CategoryType"]), ProductCategoryId = DBHelper.ParseInt64(DBHelper.ParseString(item["ProductCategoryTypeId"])) }); } } if (!string.IsNullOrWhiteSpace(productCategoryTypeId)) { string[] splitted = productCategoryTypeId.Split(','); if (splitted != null && splitted.Length > 0) { DataRow[] drfind = dtCategory.Select("ProductCategoryTypeId='" + splitted[0] + "'"); if (drfind != null && drfind.Length > 0) { StyleCampaignDetailModel campaignDetailModel = new StyleCampaignDetailModel(); campaignDetailModel.CampaignId = DBHelper.ParseString(drfind[0]["ProductCategoryTypeId"]); campaignDetailModel.CampaignName = DBHelper.ParseString(drfind[0]["CategoryType"]); string image = string.Empty; if (string.IsNullOrWhiteSpace(DBHelper.ParseString(drfind[0]["Image"]))) { image = hostingPath + "/" + Constants.NoImageAvaliablePath.Replace(@"\", "/"); } else { image = hostingPath + Constants.ProductCategoryTypeImagesPath.Replace(@"\", "/") + "/" + DBHelper.ParseString(drfind[0]["Image"]); } campaignDetailModel.CampaignImage = image; styleCampaignListModel.CampaignModel = campaignDetailModel; } } } styleCampaignListModel.ProductLists = ProductList; styleCampaignListModel.CategoryList = productCategoryList; styleCampaignListModel.TotalProducts = DBHelper.ParseString(dtTotal.Rows.Count); return(styleCampaignListModel); } else { return(null); } } catch (Exception ex) { LogHelper.ExceptionLog(ex.Message + " ::::: " + ex.StackTrace); throw ex; } }