public bool CheckUniqueAttributeName(string attributeName, int attributeId, int storeId, int portalId, string cultureName) { try { AttributeSqlProvider obj = new AttributeSqlProvider(); return obj.CheckUniqueName(attributeName, attributeId, storeId, portalId, cultureName); } catch (Exception ex) { throw ex; } }
public bool IsUnique(Int32 storeID, Int32 portalID, Int32 itemID, Int32 attributeID, Int32 attributeType, string attributeValue) { try { AttributeSqlProvider attributeSqlProvider = new AttributeSqlProvider(); /* 1 TextField 2 TextArea 3 Date 4 Boolean 5 MultipleSelect 6 DropDown 7 Price 8 File 9 Radio 10 RadioButtonList 11 CheckBox 12 CheckBoxList */ bool isUnique = false; switch (attributeType) { case 1: isUnique = attributeSqlProvider.CheckUniquenessNvarchar(1, storeID, portalID, attributeID, attributeValue); break; case 2: isUnique = attributeSqlProvider.CheckUniquenessText(1, storeID, portalID, attributeID, attributeValue); break; case 3: isUnique = attributeSqlProvider.CheckUniquenessDate(1, storeID, portalID, attributeID, DateTime.Parse(attributeValue)); break; case 4: isUnique = attributeSqlProvider.CheckUniquenessBoolean(1, storeID, portalID, attributeID, bool.Parse(attributeValue)); break; case 5: isUnique = attributeSqlProvider.CheckUniquenessInt(1, storeID, portalID, attributeID, Int32.Parse(attributeValue)); break; case 6: isUnique = attributeSqlProvider.CheckUniquenessInt(1, storeID, portalID, attributeID, Int32.Parse(attributeValue)); break; case 7: isUnique = attributeSqlProvider.CheckUniquenessDecimal(1, storeID, portalID, attributeID, decimal.Parse(attributeValue)); break; case 8: isUnique = attributeSqlProvider.CheckUniquenessFile(1, storeID, portalID, attributeID, attributeValue); break; case 9: isUnique = attributeSqlProvider.CheckUniquenessInt(1, storeID, portalID, attributeID, Int32.Parse(attributeValue)); break; case 10: isUnique = attributeSqlProvider.CheckUniquenessInt(1, storeID, portalID, attributeID, Int32.Parse(attributeValue)); break; case 11: isUnique = attributeSqlProvider.CheckUniquenessInt(1, storeID, portalID, attributeID, Int32.Parse(attributeValue)); break; case 12: isUnique = attributeSqlProvider.CheckUniquenessInt(1, storeID, portalID, attributeID, Int32.Parse(attributeValue)); break; } return isUnique; } catch (Exception ex) { ErrorHandler errHandler = new ErrorHandler(); errHandler.LogWCFException(ex); return false; } }