public List<AttributeFormInfo> GetItemFormAttributesValuesByItemID(int itemID, int attributeSetID, int itemTypeID, int storeID, int portalID, string userName, string culture) { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); List<AttributeFormInfo> frmItemAttributes = obj.GetItemAttributesValuesByItemID(itemID, attributeSetID, itemTypeID, storeID, portalID, userName, culture); return frmItemAttributes; }
public void UpdateItemIsActiveByItemID(int itemId, int storeId, int portalId, string userName, bool isActive) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); obj.UpdateItemIsActive(itemId, storeId, portalId, userName, isActive); } catch (Exception ex) { throw ex; } }
public void DeleteItemByItemID(string itemId, int storeId, int portalId, string userName) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); obj.DeleteSingleItem(itemId, storeId, portalId, userName); } catch (Exception ex) { throw ex; } }
public List<AttributeFormInfo> GetItemFormAttributesByitemSKUOnly(string itemSKU, int storeID, int portalID, string userName, string culture) { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); List<AttributeFormInfo> frmItemFieldList = obj.GetItemFormAttributesByItemSKUOnly(itemSKU, storeID, portalID, userName, culture); return frmItemFieldList; }
public List<CostVariantInfo> GetCostVariantsOptionsList(int itemId, int storeId, int portalId, string cultureName) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.GetAllCostVariantOptions(itemId, storeId, portalId, cultureName); } catch (Exception ex) { throw ex; } }
public int SaveUpdateItemAndAttributes(int itemID, int itemTypeID, int attributeSetID, int storeID, int portalID, string userName, string culture, int taxClassID, string categoriesIDs, string relatedItemsIDs, string upSellItemsIDs, string crossSellItemsIDs, string downloadItemsValue, AspxNameValue[] formVars) { bool isModified = false; bool updateFlag = false; if (itemID > 0) { isModified = true; updateFlag = true; } StoreSettingConfig ssc = new StoreSettingConfig(); int itemLargeThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageSize, storeID, portalID, culture)); int itemMediumThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageSize, storeID, portalID, culture)); int itemSmallThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageSize, storeID, portalID, culture)); int _attributeID = 0; int _inputTypeID = 0; int _ValidationTypeID = 8; int _attributeSetGroupID = 0; bool _isIncludeInPriceRule = false; bool _isIncludeInPromotions = false; int _displayOrder = 0; string sku = ""; string activeFrom = ""; string activeTo = ""; string hidePrice = ""; string isHideInRSS = ""; string isHideToAnonymous = ""; bool toInsertIntoDB = true; bool isFormValid = true; string imageVar = string.Empty; int imageCounterFirst = 0; ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); for (int i = 0; i < formVars.Length; i++) { string attribValue = formVars[i].value; //string jsonResult = formVars[i].name.Replace('%', '_'); string jsonResult = formVars[i].name.Replace('-', ' '); string[] jsonVar = jsonResult.Split('_'); FormValidation formValidation = new FormValidation(); if (jsonVar.Length > 1) { _attributeID = Int32.Parse(jsonVar[0]); _inputTypeID = Int32.Parse(jsonVar[1]); _ValidationTypeID = Int32.Parse(jsonVar[2]); _attributeSetGroupID = Int32.Parse(jsonVar[4]); _isIncludeInPriceRule = bool.Parse(jsonVar[5]); _isIncludeInPromotions = bool.Parse(jsonVar[6]); _displayOrder = Int32.Parse(jsonVar[7]); //Save To Database 1. [aspx_Items] 2. Others if (_attributeID == 4) { sku = formVars[i].value; } else if (_attributeID == 22) { activeFrom = formVars[i].value; } else if (_attributeID == 23) { activeTo = formVars[i].value; } else if (_attributeID == 26) { hidePrice = formVars[i].value; } else if (_attributeID == 27) { isHideInRSS = formVars[i].value; } else if (_attributeID == 28) { isHideToAnonymous = formVars[i].value; } if (itemID == 0 && updateFlag == false) { itemID = obj.AddItem(itemID, itemTypeID, attributeSetID, taxClassID, storeID, portalID, userName, culture, true, isModified, sku, activeFrom, activeTo, hidePrice, isHideInRSS, isHideToAnonymous, categoriesIDs, relatedItemsIDs, upSellItemsIDs, crossSellItemsIDs, downloadItemsValue, updateFlag); } else if (itemID > 0 && i == formVars.Length - 1) { itemID = obj.AddItem(itemID, itemTypeID, attributeSetID, taxClassID, storeID, portalID, userName, culture, true, isModified, sku, activeFrom, activeTo, hidePrice, isHideInRSS, isHideToAnonymous, categoriesIDs, relatedItemsIDs, upSellItemsIDs, crossSellItemsIDs, downloadItemsValue, updateFlag); } if (itemID > 0) { if (_inputTypeID == 1) { if (_ValidationTypeID == 3) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_ValidationTypeID == 5) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } } else if (_inputTypeID == 2) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 3) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { if (!string.IsNullOrEmpty(formVars[i].value)) { attribValue = formVars[i].value; } } else { isFormValid = false; break; } } else if (_inputTypeID == 4) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { if (!string.IsNullOrEmpty(formVars[i].value)) { attribValue = formVars[i].value; } } else { isFormValid = false; break; } } else if (_inputTypeID == 5 || _inputTypeID == 6 || _inputTypeID == 9 || _inputTypeID == 10 || _inputTypeID == 11 || _inputTypeID == 12) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 7) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 8) { if (imageCounterFirst % 2 == 0) { toInsertIntoDB = false; if (!string.IsNullOrEmpty(formVars[i].value) && formVars[i].value.ToLower() != "undefined") { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { imageVar = attribValue; } else { isFormValid = false; break; } } else { imageVar = ""; } } else { toInsertIntoDB = true; if (attribValue != imageVar) { //_imageVar = _imageVar.Replace("../", ""); imageVar = imageVar.Replace("/", "\\"); //attribValue = attribValue.Replace("../", ""); attribValue = attribValue.Replace("/", "\\"); string tempFolder = @"Upload\temp"; FileHelperController fileObj = new FileHelperController(); attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar, itemLargeThumbNailSize, itemMediumThumbNailSize, itemSmallThumbNailSize, @"Modules\AspxCommerce\AspxItemsManagement\uploads\", itemID, "item_"); } } imageCounterFirst++; } } if (isFormValid && toInsertIntoDB) { obj.SaveUpdateItemAttributes(itemID, attributeSetID, storeID, portalID, userName, culture, true, isModified, attribValue, _attributeID, _inputTypeID, _ValidationTypeID, _attributeSetGroupID, _isIncludeInPriceRule, _isIncludeInPromotions, _displayOrder); } } } return itemID; }
public List<ItemsInfo> GetItemsList(int offset, int limit, string sku, string name, string itemType, string attributesetName, string visibility, System.Nullable<bool> isActive, int storeId, int portalId, string userName, string cultureName) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.GetAllItems(offset, limit, sku, name, itemType, attributesetName, visibility, isActive, storeId, portalId, userName, cultureName); } catch (Exception ex) { throw ex; } }
public void DeleteImageContents(Int32 itemID) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); obj.DeleteItemImageByItemID(itemID); } catch (Exception ex) { throw ex; } }
public ItemBasicDetailsInfo GetItemBasicInfoByitemSKU(string itemSKU, int storeID, int portalID, string userName, string culture) { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); ItemBasicDetailsInfo frmItemAttributes = obj.GetItemBasicInfo(itemSKU, storeID, portalID, userName, culture); return frmItemAttributes; }
public List<AttributeFormInfo> GetItemDetailsByitemSKU(string itemSKU, int attributeSetID, int itemTypeID, int storeID, int portalID, string userName, string culture) { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); List<AttributeFormInfo> frmItemAttributes = obj.GetItemDetailsInfoByItemSKU(itemSKU, attributeSetID, itemTypeID, storeID, portalID, userName, culture); return frmItemAttributes; }
public List<LatestItemsInfo> GetLatestItemsList(int storeId, int portalId, string userName, string cultureName, int count) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.GetLatestItemsByCount(storeId, portalId, userName, cultureName, count); } catch (Exception ex) { throw ex; } }
public List<TaxRulesInfo> GetAllTaxRules(int storeID, int portalID, bool isActive) { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); List<TaxRulesInfo> lstTaxManageRule = obj.GetAllTaxRules(storeID, portalID, isActive); return lstTaxManageRule; }
public int SaveUpdateItemAndAttributes(ItemsInfo.ItemSaveBasicInfo itemObj, AspxCommonInfo aspxCommonObj) { bool isModified = false; bool updateFlag = false; int storeId = aspxCommonObj.StoreID; int portalId = aspxCommonObj.PortalID; string culture = aspxCommonObj.CultureName; string userName = aspxCommonObj.UserName; if (itemObj.ItemId > 0) { isModified = true; updateFlag = true; } StoreSettingConfig ssc = new StoreSettingConfig(); int itemLargeThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageSize, storeId, portalId, culture)); int itemMediumThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageSize, storeId, portalId, culture)); int itemSmallThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageSize, storeId, portalId, culture)); int _attributeID = 0; int _inputTypeID = 0; int _ValidationTypeID = 8; int _attributeSetGroupID = 0; bool _isIncludeInPriceRule = false; bool _isIncludeInPromotions = false; int _displayOrder = 0; string sku = ""; string activeFrom = ""; string activeTo = ""; string hidePrice = ""; string isHideInRSS = ""; string isHideToAnonymous = ""; bool toInsertIntoDB = true; bool isFormValid = true; string imageVar = string.Empty; int imageCounterFirst = 0; ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); var formVars = JSONHelper.Deserialise <List <AspxNameValue> >(itemObj.FormVars); // for (int i = 0; i < formVars.Length; i++) for (int i = 0; i < formVars.Count; i++) { string attribValue = formVars[i].value; //string jsonResult = formVars[i].name.Replace('%', '_'); string jsonResult = formVars[i].name.Replace('-', ' '); string[] jsonVar = jsonResult.Split('_'); FormValidation formValidation = new FormValidation(); if (jsonVar.Length > 1) { _attributeID = Int32.Parse(jsonVar[0]); _inputTypeID = Int32.Parse(jsonVar[1]); _ValidationTypeID = Int32.Parse(jsonVar[2]); _attributeSetGroupID = Int32.Parse(jsonVar[4]); _isIncludeInPriceRule = bool.Parse(jsonVar[5]); _isIncludeInPromotions = bool.Parse(jsonVar[6]); _displayOrder = Int32.Parse(jsonVar[7]); //Save To Database 1. [aspx_Items] 2. Others if (_attributeID == 4) { sku = formVars[i].value; } else if (_attributeID == 22) { activeFrom = formVars[i].value; } else if (_attributeID == 23) { activeTo = formVars[i].value; } else if (_attributeID == 26) { hidePrice = formVars[i].value; } else if (_attributeID == 27) { isHideInRSS = formVars[i].value; } else if (_attributeID == 28) { isHideToAnonymous = formVars[i].value; } if (itemObj.ItemId == 0 && updateFlag == false) { itemObj.ItemId = obj.AddItem(itemObj, aspxCommonObj, true, isModified, sku, activeFrom, activeTo, hidePrice, isHideInRSS, isHideToAnonymous, updateFlag); } else if (itemObj.ItemId > 0 && i == (formVars.Count - 1)) { itemObj.ItemId = obj.AddItem(itemObj, aspxCommonObj, true, isModified, sku, activeFrom, activeTo, hidePrice, isHideInRSS, isHideToAnonymous, updateFlag); } if (itemObj.ItemId > 0) { if (_inputTypeID == 1) { if (_ValidationTypeID == 3) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_ValidationTypeID == 5) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } } else if (_inputTypeID == 2) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 3) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { if (!string.IsNullOrEmpty(formVars[i].value)) { attribValue = formVars[i].value; } } else { isFormValid = false; break; } } else if (_inputTypeID == 4) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { if (!string.IsNullOrEmpty(formVars[i].value)) { attribValue = formVars[i].value; } } else { isFormValid = false; break; } } else if (_inputTypeID == 5 || _inputTypeID == 6 || _inputTypeID == 9 || _inputTypeID == 10 || _inputTypeID == 11 || _inputTypeID == 12) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 7) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 8) { if (imageCounterFirst % 2 == 0) { toInsertIntoDB = false; if (!string.IsNullOrEmpty(formVars[i].value) && formVars[i].value.ToLower() != "undefined") { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { imageVar = attribValue; } else { isFormValid = false; break; } } else { imageVar = ""; } } else { toInsertIntoDB = true; if (attribValue != imageVar) { //_imageVar = _imageVar.Replace("../", ""); imageVar = imageVar.Replace("/", "\\"); //attribValue = attribValue.Replace("../", ""); attribValue = attribValue.Replace("/", "\\"); string tempFolder = @"Upload\temp"; FileHelperController fileObj = new FileHelperController(); attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar, itemLargeThumbNailSize, itemMediumThumbNailSize, itemSmallThumbNailSize, @"Modules\AspxCommerce\AspxItemsManagement\uploads\", itemObj.ItemId, "item_"); } } imageCounterFirst++; } } if (isFormValid && toInsertIntoDB) { obj.SaveUpdateItemAttributes(itemObj.ItemId, itemObj.AttributeSetId, aspxCommonObj, true, isModified, attribValue, _attributeID, _inputTypeID, _ValidationTypeID, _attributeSetGroupID, _isIncludeInPriceRule, _isIncludeInPromotions, _displayOrder); } } } if (itemObj.ItemTypeId == 1 || itemObj.ItemTypeId == 2) { obj.InsertBrandMapping(itemObj.ItemId, itemObj.BrandId, storeId, portalId, userName, culture); } if (itemObj.ItemVideoIDs != "" || updateFlag == true) { obj.InsertAndUpdateItemVideos(itemObj.ItemId, itemObj.ItemVideoIDs, aspxCommonObj); } return(itemObj.ItemId); }
public List<CategoryInfo> GetCategoryList(string prefix, bool isActive, string cultureName, Int32 storeID, Int32 portalID, string userName, int itemId) { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); List<CategoryInfo> catList = obj.GetCategoryList(prefix, isActive, cultureName, storeID, portalID, userName, itemId); return catList; }
public List<LowStockItemsInfo> GetLowStockItemsList(int offset, System.Nullable<int> limit, string sku, string name, System.Nullable<bool> isActive, int storeId, int portalId, string userName, string cultureName, int lowStock) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.GetAllLowStockItems(offset, limit, sku, name, isActive, storeId, portalId, userName, cultureName, lowStock); } catch (Exception ex) { throw ex; } }
public bool CheckUniqueItemSKUCode(string SKU, int itemId, int storeId, int portalId, string cultureName) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.CheckUniqueSKUCode(SKU, itemId, storeId, portalId, cultureName); } catch (Exception ex) { throw ex; } }
public List<OrderItemsGroupByItemIDInfo> GetOrderedItemsList(int offset, System.Nullable<int> limit, string name, int storeId, int portalId, string userName, string cultureName) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.GetOrderedItemsList(offset, limit, name, storeId, portalId, userName, cultureName); } catch (Exception ex) { throw ex; } }
public List<ItemsInfo> GetCrossSellItemsList(int offset, int limit, int storeId, int portalId, int selfItemId, string userName, string culture) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.GetCrossSellItemsByItemID(offset, limit, storeId, portalId, selfItemId, userName, culture); } catch (Exception ex) { throw ex; } }
public List<DownLoadableItemGetInfo> GetDownLoadableItemsList(int offset, System.Nullable<int> limit, string sku, string name, int storeId, int portalId, string userName, string cultureName, System.Nullable<bool> CheckUser) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.GetDownLoadableItemsList(offset, limit, sku, name, storeId, portalId, userName, cultureName, CheckUser); } catch (Exception ex) { throw ex; } }
public int SaveUpdateItemAndAttributes(ItemsInfo.ItemSaveBasicInfo itemObj, AspxCommonInfo aspxCommonObj) { bool isModified = false; bool updateFlag = false; int storeId = aspxCommonObj.StoreID; int portalId = aspxCommonObj.PortalID; string culture = aspxCommonObj.CultureName; string userName = aspxCommonObj.UserName; if (itemObj.ItemId > 0) { isModified = true; updateFlag = true; } StoreSettingConfig ssc = new StoreSettingConfig(); int itemLargeThumbNailHeight = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageHeight, storeId, portalId, culture)); int itemLargeThumbNailWidth = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageWidth, storeId, portalId, culture)); int itemMediumThumbNailHeight = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageHeight, storeId, portalId, culture)); int itemMediumThumbNailWidth = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageWidth, storeId, portalId, culture)); int itemSmallThumbNailHeight = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageHeight, storeId, portalId, culture)); int itemSmallThumbNailWidth = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageWidth, storeId, portalId, culture)); int _attributeID = 0; int _inputTypeID = 0; int _ValidationTypeID = 8; int _attributeSetGroupID = 0; bool _isIncludeInPriceRule = false; bool _isIncludeInPromotions = false; int _displayOrder = 0; string sku = ""; string activeFrom = ""; string activeTo = ""; string hidePrice = ""; string isHideInRSS = ""; string isHideToAnonymous = ""; bool toInsertIntoDB = true; bool isFormValid = true; string imageVar = string.Empty; int imageCounterFirst = 0; ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); var formVars = JSONHelper.Deserialise<List<AspxNameValue>>(itemObj.FormVars); // for (int i = 0; i < formVars.Length; i++) for (int i = 0; i < formVars.Count; i++) { string attribValue = formVars[i].value; //string jsonResult = formVars[i].name.Replace('%', '_'); string jsonResult = formVars[i].name.Replace('-', ' '); string[] jsonVar = jsonResult.Split('_'); FormValidation formValidation = new FormValidation(); if (jsonVar.Length > 1) { _attributeID = Int32.Parse(jsonVar[0]); _inputTypeID = Int32.Parse(jsonVar[1]); _ValidationTypeID = Int32.Parse(jsonVar[2]); _attributeSetGroupID = Int32.Parse(jsonVar[4]); _isIncludeInPriceRule = bool.Parse(jsonVar[5]); _isIncludeInPromotions = bool.Parse(jsonVar[6]); _displayOrder = Int32.Parse(jsonVar[7]); //Save To Database 1. [aspx_Items] 2. Others if (_attributeID == 4) { sku = formVars[i].value; } else if (_attributeID == 22) { activeFrom = formVars[i].value; } else if (_attributeID == 23) { activeTo = formVars[i].value; } else if (_attributeID == 26) { hidePrice = formVars[i].value; } else if (_attributeID == 27) { isHideInRSS = formVars[i].value; } else if (_attributeID == 28) { isHideToAnonymous = formVars[i].value; } if (itemObj.ItemId == 0 && updateFlag == false) { itemObj.ItemId = obj.AddItem(itemObj, aspxCommonObj, true, isModified, sku, activeFrom, activeTo, hidePrice, isHideInRSS, isHideToAnonymous, updateFlag); } else if (itemObj.ItemId > 0 && i == (formVars.Count - 1)) { itemObj.ItemId = obj.AddItem(itemObj, aspxCommonObj, true, isModified, sku, activeFrom, activeTo, hidePrice, isHideInRSS, isHideToAnonymous, updateFlag); } if (itemObj.ItemId > 0) { if (_inputTypeID == 1) { if (_ValidationTypeID == 3) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_ValidationTypeID == 5) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } } else if (_inputTypeID == 2) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 3) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { if (!string.IsNullOrEmpty(formVars[i].value)) { attribValue = formVars[i].value; } } else { isFormValid = false; break; } } else if (_inputTypeID == 4) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { if (!string.IsNullOrEmpty(formVars[i].value)) { attribValue = formVars[i].value; } } else { isFormValid = false; break; } } else if (_inputTypeID == 5 || _inputTypeID == 6 || _inputTypeID == 9 || _inputTypeID == 10 || _inputTypeID == 11 || _inputTypeID == 12) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 7) { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { attribValue = formVars[i].value; } else { isFormValid = false; break; } } else if (_inputTypeID == 8) { if (imageCounterFirst % 2 == 0) { toInsertIntoDB = false; if (!string.IsNullOrEmpty(formVars[i].value) && formVars[i].value.ToLower() != "undefined") { if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value)) { imageVar = attribValue; } else { isFormValid = false; break; } } else { imageVar = ""; } } else { toInsertIntoDB = true; if (attribValue != imageVar) { //_imageVar = _imageVar.Replace("../", ""); imageVar = imageVar.Replace("/", "\\"); //attribValue = attribValue.Replace("../", ""); attribValue = attribValue.Replace("/", "\\"); string tempFolder = @"Upload\temp"; FileHelperController fileObj = new FileHelperController(); attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar, itemLargeThumbNailHeight, itemLargeThumbNailWidth, itemMediumThumbNailHeight, itemMediumThumbNailWidth, itemSmallThumbNailHeight, itemSmallThumbNailWidth, @"Modules\AspxCommerce\AspxItemsManagement\uploads\", itemObj.ItemId, "item_"); } } imageCounterFirst++; } } if (isFormValid && toInsertIntoDB) { obj.SaveUpdateItemAttributes(itemObj.ItemId, itemObj.AttributeSetId, aspxCommonObj, true, isModified, attribValue, _attributeID, _inputTypeID, _ValidationTypeID, _attributeSetGroupID, _isIncludeInPriceRule, _isIncludeInPromotions, _displayOrder); } } } if (itemObj.ItemTypeId == 1 || itemObj.ItemTypeId == 2) { obj.InsertBrandMapping(itemObj.ItemId, itemObj.BrandId, storeId, portalId, userName, culture); } if (itemObj.ItemVideoIDs != "" || updateFlag == true) obj.InsertAndUpdateItemVideos(itemObj.ItemId, itemObj.ItemVideoIDs, aspxCommonObj); return itemObj.ItemId; }
public List<MostViewedItemsInfo> GetMostViewedItemsList(int offset, int limit, string name, int storeId, int portalId, string userName, string cultureName) { try { ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider(); return obj.GetAllMostViewedItems(offset, limit, name, storeId, portalId, userName, cultureName); } catch (Exception ex) { throw ex; } }