private bool IsPageExists(string pagename) { var paramCol = new List <KeyValuePair <string, object> >(); paramCol.Add(new KeyValuePair <string, object>("@PortalID", -1)); paramCol.Add(new KeyValuePair <string, object>("@PageName", pagename)); // paramCol.Add(new KeyValuePair<string, object>("@PageName", pagename)); return(sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckPaymentPage]", paramCol, "@IsExist")); }
private bool IsPageExists(string pagename) { SQLHandler sqlH = new SQLHandler(); var paramCol = new List<KeyValuePair<string, object>>(); paramCol.Add(new KeyValuePair<string, object>("@PortalID", -1)); paramCol.Add(new KeyValuePair<string, object>("@PageName", pagename)); // paramCol.Add(new KeyValuePair<string, object>("@PageName", pagename)); return sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckPaymentPage]", paramCol, "@IsExist"); }
public static bool IsShippingLabelCreated(int orderId, AspxCommonInfo commonInfo) { List <KeyValuePair <string, object> > paraMeter = new List <KeyValuePair <string, object> >(); paraMeter.Add(new KeyValuePair <string, object>("@OrderID", orderId)); paraMeter.Add(new KeyValuePair <string, object>("@PortalId", commonInfo.StoreID)); paraMeter.Add(new KeyValuePair <string, object>("@StoreId", commonInfo.StoreID)); SQLHandler sqLh = new SQLHandler(); bool isCreated = sqLh.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckLabelExist]", paraMeter, "@IsCreated"); return(isCreated); }
public static bool SerialNumberExist(string serialNumber) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > Parameter = new List <KeyValuePair <string, object> >(); Parameter.Add(new KeyValuePair <string, object>("@GoogleSerialNumber", serialNumber)); return(sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_GoogleSerialNumberExists]", Parameter, "@IsExists")); } catch (Exception ex) { throw ex; } }
public bool CheckKitComponentExist(string ComponentName, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@ComponentName", ComponentName)); bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CheckKitComponentExist", parameterCollection, "@IsComponentExist"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckTaxClassUniqueness(AspxCommonInfo aspxCommonObj, string taxItemClassName) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@TaxClassName", taxItemClassName)); SQLHandler sqlh = new SQLHandler(); bool isUnique = sqlh.ExecuteNonQueryAsBool("[usp_Aspx_CheckTaxClassUniqueness]", parameter, "@IsUnique"); return isUnique; } catch (Exception e) { throw e; } }
public bool CheckCatalogRuleExist(AspxCommonInfo aspxCommonObj) { try { bool isExist = false; SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > paramList = CommonParmBuilder.GetParamSP(aspxCommonObj); isExist = sqlHandler.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCatalogRuleExist]", paramList, "@IsExist"); return(isExist); } catch (Exception e) { throw e; } }
/// <summary> /// Connects to database and checks for message template uniqueness. /// </summary> /// <param name="messageTempTypeName">Message template type name.</param> /// <param name="portalID">Portal ID.</param> /// <returns>Returns true if messasge template type is unique.</returns> public bool CheckMessgeTemplateUnique(string messageTempTypeName, int portalID) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > ParaMeter = new List <KeyValuePair <string, object> >(); ParaMeter.Add(new KeyValuePair <string, object>("@MsgTemplateTypeName", messageTempTypeName)); ParaMeter.Add(new KeyValuePair <string, object>("@PortalID", portalID)); return(sqlH.ExecuteNonQueryAsBool("[usp_MsgTempTypeUniquenessCheck]", ParaMeter, "@IsUnique")); } catch (Exception e) { throw e; } }
public static bool CheckBrandUniqueness(string brandName, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@BrandName", brandName)); SQLHandler sqlH = new SQLHandler(); bool isUnique = sqlH.ExecuteNonQueryAsBool("usp_Aspx_CheckBrandUniqueness", parameter, "@isUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckTaxClassUniqueness(AspxCommonInfo aspxCommonObj, string taxItemClassName) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@TaxClassName", taxItemClassName)); SQLHandler sqlh = new SQLHandler(); bool isUnique = sqlh.ExecuteNonQueryAsBool("[usp_Aspx_CheckTaxClassUniqueness]", parameter, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckUniqueSKUCode(string sku, int itemId, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@SKU", sku)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", itemId)); bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_ItemSKUCodeUniquenessCheck", parameterCollection, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckCatalogPriorityUniqueness(int catalogPriceRuleID, int priority, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@CatalogPriceRuleID", catalogPriceRuleID)); parameterCollection.Add(new KeyValuePair <string, object>("@Priority", priority)); bool isUnique = sqlH.ExecuteNonQueryAsBool("[usp_Aspx_CatalogPriorityUniquenessCheck]", parameterCollection, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckUniqueName(string catName, int catId, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@CategoryName", catName)); parameterCollection.Add(new KeyValuePair <string, object>("@CategoryID", catId)); bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CategoryNameUniquenessCheck", parameterCollection, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckUniquenessForDisplayOrderForCurrency(AspxCommonInfo aspxCommonObj, int value, int currencyID) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > Parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); Parameter.Add(new KeyValuePair <string, object>("@Value", value)); Parameter.Add(new KeyValuePair <string, object>("@CurrencyID", currencyID)); bool isUnique = sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckUniquenessForDisplayOrderForCurrency]", Parameter, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckUniqueName(string catName, int catId, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryName", catName)); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", catId)); bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CategoryNameUniquenessCheck", parameterCollection, "@IsUnique"); return isUnique; } catch (Exception e) { throw e; } }
//---------------- Added for unique name check --------------------- public static bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeName", attrbuteUniqueObj.AttributeName)); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeID", attrbuteUniqueObj.AttributeID)); bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckCouponTypeUniqueness(AspxCommonInfo aspxCommonObj, int couponTypeId, string couponType) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > Parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); Parameter.Add(new KeyValuePair <string, object>("@CouponTypeID", couponTypeId)); Parameter.Add(new KeyValuePair <string, object>("@CouponType", couponType)); bool isUnique = sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCouponTypeUniquness]", Parameter, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool IsPurchaseActive(AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID)); parameter.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName)); return(sqlH.ExecuteNonQueryAsBool("usp_Aspx_RewardPointsIsPurchaseActive", parameter, "@IsActive")); } catch (Exception ex) { throw ex; } }
public static bool CheckCouponStatusUniqueness(AspxCommonInfo aspxCommonObj, int couponStatusId, string couponStatusName) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> Parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); Parameter.Add(new KeyValuePair<string, object>("@CouponStatusId", couponStatusId)); Parameter.Add(new KeyValuePair<string, object>("@CouponStatusName", couponStatusName)); bool isUnique = sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCouponStatusUniquness]", Parameter, "@IsUnique"); return isUnique; } catch (Exception e) { throw e; } }
public static bool GetModuleInstallationInfo(string moduleFriendlyName, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >(); parameterCollection.Add(new KeyValuePair <string, object>("@ModuleFriendlyName", moduleFriendlyName)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); bool isInstalled = sqlH.ExecuteNonQueryAsBool("[usp_Aspx_IsModuleInstaled]", parameterCollection, "@IsInstalled"); return(isInstalled); } catch (Exception e) { throw e; } }
public static bool CheckRemainingDownload(int itemId, int orderItemId, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", itemId)); parameterCollection.Add(new KeyValuePair <string, object>("@OrderItemID", orderItemId)); bool isRemain = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CheckRemainingDownloadForCustomer", parameterCollection, "@IsRemainDowload"); return(isRemain); } catch (Exception e) { throw e; } }
public static bool CheckExisting(AspxCommonInfo aspxCommonObj, int storeAccesskeyId, string accessData) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@StoreAccessKeyID", storeAccesskeyId)); parameter.Add(new KeyValuePair <string, object>("@StoreAccessData", accessData)); bool isUnique = sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckExistingStoreAccess]", parameter, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool RewardPointsGeneralSettingsIsActive(AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >(); parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName)); bool IsActive = sqlH.ExecuteNonQueryAsBool("[usp_Aspx_RewardPointsGeneralSettingsIsActive]", parameterCollection, "@IsActive"); return(IsActive); } catch (Exception e) { throw e; } }
public bool CheckCatalogRuleExist(int iPortalID, int iStoreID) { try { bool isExist = false; SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >(); paramList.Add(new KeyValuePair <string, object>("@PortalID", iPortalID)); paramList.Add(new KeyValuePair <string, object>("@StoreID", iPortalID)); isExist = sqlHandler.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCatalogRuleExist]", paramList, "@IsExist"); return(isExist); } catch (Exception e) { throw e; } }
internal bool CheckUniquenessNotification(int portalID, string notificationName) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >(); param.Add(new KeyValuePair <string, object>("@PortalID", portalID)); param.Add(new KeyValuePair <string, object>("@NotificationName", notificationName)); SQLHandler sagesql = new SQLHandler(); try { return(sagesql.ExecuteNonQueryAsBool("[dbo].[usp_AdminNotification_CheckUniqueness]", param, "@output")); } catch { throw; } }
public static bool CheckCartPricePriorityUniqueness(int cartPriceRuleID, int priority, int portalID) { try { SQLHandler Sq = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >(); parameterCollection.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleID)); parameterCollection.Add(new KeyValuePair <string, object>("@Priority", priority)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", portalID)); bool isUnique = Sq.ExecuteNonQueryAsBool("[usp_Aspx_CartPricePriorityUniquenessCheck]", parameterCollection, "@IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public bool UpdateCartAnonymoususertoRegistered(int storeID, int portalID, int customerID, string sessionCode) { try { List <KeyValuePair <string, object> > ParaMeter = new List <KeyValuePair <string, object> >(); ParaMeter.Add(new KeyValuePair <string, object>("@StoreID", storeID)); ParaMeter.Add(new KeyValuePair <string, object>("@PortalID", portalID)); ParaMeter.Add(new KeyValuePair <string, object>("@CustomerID", customerID)); ParaMeter.Add(new KeyValuePair <string, object>("@SessionCode", sessionCode)); SQLHandler sqlH = new SQLHandler(); return(sqlH.ExecuteNonQueryAsBool("usp_Aspx_UpdateCartAnonymoususertoRegistered", ParaMeter, "@IsUpdate")); } catch (Exception ex) { throw ex; } }
public static bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > Parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); Parameter.Add(new KeyValuePair <string, object>("@StoreBranchID", providerUniqueInfo.StoreBranchID)); Parameter.Add(new KeyValuePair <string, object>("@EmployeeID", providerUniqueInfo.EmployeeID)); Parameter.Add(new KeyValuePair <string, object>("@EmployeeName", providerUniqueInfo.EmployeeName)); bool isSPUnique = sqlH.ExecuteNonQueryAsBool("[usp_Aspx_ServiceProviderUniqunessCheck]", Parameter, "@IsUnique"); return(isSPUnique); } catch (Exception e) { throw e; } }
//---------------- Added for unique name check --------------------- public bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >(); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeName", attrbuteUniqueObj.AttributeName)); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeID", attrbuteUniqueObj.AttributeID)); parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName)); return(sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique")); } catch (Exception ex) { throw ex; } }
//---------------- Added for unique name check --------------------- public bool CheckUniqueName(string attributeName, int attributeId, int storeId, int portalId, string cultureName) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >(); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeName", attributeName)); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeID", attributeId)); parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", storeId)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", portalId)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", cultureName)); return(sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique")); } catch (Exception ex) { throw ex; } }
public bool CheckUniqueName(string catName, int catId, int storeId, int portalId, string cultureName) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>(); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryName", catName)); parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", catId)); parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeId)); parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalId)); parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", cultureName)); return sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CategoryNameUniquenessCheck", parameterCollection, "@IsUnique"); } catch (Exception ex) { throw ex; } }
public bool CheckUniqueSKUCode(string sku, int itemId, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >(); parameterCollection.Add(new KeyValuePair <string, object>("@SKU", sku)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", itemId)); parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName)); return(sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_ItemSKUCodeUniquenessCheck", parameterCollection, "@IsUnique")); } catch (Exception ex) { throw ex; } }
/// <summary> /// Connects to database and deletes list entry. /// </summary> /// <param name="EntryId">List entry ID.</param> /// <param name="DeleteChild">Set true if have to delete child entries.</param> /// <param name="Culture">Current culture.</param> /// <returns>Returns true if list is deleted</returns> public bool DeleteListEntry(int EntryId, bool DeleteChild, string Culture) { string sp = "[dbo].[sp_ListEntryDeleteByID]"; SQLHandler sagesql = new SQLHandler(); try { List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >(); ParamCollInput.Add(new KeyValuePair <string, object>("@EntryID", EntryId)); ParamCollInput.Add(new KeyValuePair <string, object>("@DeleteChild", DeleteChild)); ParamCollInput.Add(new KeyValuePair <string, object>("@Culture", Culture)); return(sagesql.ExecuteNonQueryAsBool(sp, ParamCollInput, "@IsExist")); } catch (Exception ex) { throw ex; } }
public bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo) { try { SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > Parameter = new List <KeyValuePair <string, object> >(); Parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID)); Parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID)); Parameter.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName)); Parameter.Add(new KeyValuePair <string, object>("@StoreBranchID", providerUniqueInfo.StoreBranchID)); Parameter.Add(new KeyValuePair <string, object>("@EmployeeID", providerUniqueInfo.EmployeeID)); Parameter.Add(new KeyValuePair <string, object>("@EmployeeName", providerUniqueInfo.EmployeeName)); return(sqlH.ExecuteNonQueryAsBool("[usp_Aspx_ServiceProviderUniqunessCheck]", Parameter, "@IsUnique")); } catch (Exception ex) { throw ex; } }
public bool CheckEmailAddress(string email,int storeID, int portalID) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID)); parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID)); parameter.Add(new KeyValuePair<string, object>("@Email", email)); //parameter.Add(new KeyValuePair<string, object>("@IsExist", 0)); return sqlH.ExecuteNonQueryAsBool("usp_Aspx_CheckEmailIsAdmin", parameter, "@IsExist"); } catch (Exception ex) { throw ex; } }
public static bool CheckCurrencyCodeUniqueness(AspxCommonInfo aspxCommonObj, string currencyCode, int currencyID) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> Parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); Parameter.Add(new KeyValuePair<string, object>("@CurrencyCode", currencyCode)); Parameter.Add(new KeyValuePair<string, object>("@CurrencyID", currencyID)); bool isUnique = sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCurrCodeUniqueness]", Parameter, "@IsUnique"); return isUnique; } catch (Exception e) { throw e; } }
public bool CheckCouponTypeUniqueness(int storeId, int portalId, string cultureName, int couponTypeId, string couponType) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> Parameter = new List<KeyValuePair<string, object>>(); Parameter.Add(new KeyValuePair<string, object>("@StoreID", storeId)); Parameter.Add(new KeyValuePair<string, object>("@PortalID", portalId)); Parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName)); Parameter.Add(new KeyValuePair<string, object>("@CouponTypeID", couponTypeId)); Parameter.Add(new KeyValuePair<string, object>("@CouponType", couponType)); return sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCouponTypeUniquness]", Parameter, "@IsUnique"); } catch (Exception ex) { throw ex; } }
public bool CheckCatalogRuleExist(int iPortalID, int iStoreID) { try { bool isExist = false; SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>(); paramList.Add(new KeyValuePair<string, object>("@PortalID", iPortalID)); paramList.Add(new KeyValuePair<string, object>("@StoreID", iPortalID)); isExist = sqlHandler.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCatalogRuleExist]", paramList, "@IsExist"); return isExist; } catch (Exception e) { throw e; } }
public static bool CheckUniquenessForDisplayOrder(AspxCommonInfo aspxCommonObj, int value, int shippingMethodID) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> Parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); Parameter.Add(new KeyValuePair<string, object>("@Value", value)); Parameter.Add(new KeyValuePair<string, object>("@ShippingMethodID", shippingMethodID)); bool isUnique= sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckUniquenessForDisplayOrder]", Parameter, "@IsUnique"); return isUnique; } catch (Exception e) { throw e; } }
public static bool CheckBrandUniqueness(string brandName, AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@BrandName", brandName)); SQLHandler sqlH = new SQLHandler(); bool isUnique= sqlH.ExecuteNonQueryAsBool("usp_Aspx_CheckBrandUniqueness", parameter, "@isUnique"); return isUnique; } catch (Exception e) { throw e; } }
public static bool CheckCatalogPriorityUniqueness(int catalogPriceRuleID, int priority, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", catalogPriceRuleID)); parameterCollection.Add(new KeyValuePair<string, object>("@Priority", priority)); bool isUnique = sqlH.ExecuteNonQueryAsBool("[usp_Aspx_CatalogPriorityUniquenessCheck]", parameterCollection, "@IsUnique"); return isUnique; } catch (Exception e) { throw e; } }
public bool CheckCatalogRuleExist(AspxCommonInfo aspxCommonObj) { try { bool isExist = false; SQLHandler sqlHandler = new SQLHandler(); List<KeyValuePair<string, object>> paramList = CommonParmBuilder.GetParamSP(aspxCommonObj); isExist = sqlHandler.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCatalogRuleExist]", paramList, "@IsExist"); return isExist; } catch (Exception e) { throw e; } }
public static bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@AttributeName", attrbuteUniqueObj.AttributeName)); parameterCollection.Add(new KeyValuePair<string, object>("@AttributeID", attrbuteUniqueObj.AttributeID)); bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique"); return isUnique; } catch (Exception e) { throw e; } }
public bool CheckUniqueCostVariantName(string costVariantName, int costVariantId, int storeId, int portalId) { try { SQLHandler Sq = new SQLHandler(); List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@CostVariantName", costVariantName)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@CostVariantID", costVariantId)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeId)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalId)); return Sq.ExecuteNonQueryAsBool("usp_ASPX_CostVariantUniquenessCheck", ParaMeterCollection, "@IsUnique"); } catch (Exception ex) { throw ex; } }
public bool CheckCartPricePriorityUniqueness(int cartPriceRuleID, int priority, int portalID) { try { SQLHandler Sq = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>(); parameterCollection.Add(new KeyValuePair<string, object>("@CartPriceRuleID", cartPriceRuleID)); parameterCollection.Add(new KeyValuePair<string, object>("@Priority", priority)); parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID)); return Sq.ExecuteNonQueryAsBool("[usp_Aspx_CartPricePriorityUniquenessCheck]", parameterCollection, "@IsUnique"); } catch (Exception ex) { throw ex; } }
public bool CheckExisting(int storeId, int portalId, int storeAccesskeyId, string accessData) { try { var sqlH = new SQLHandler(); var parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@StoreID", storeId)); parameter.Add(new KeyValuePair<string, object>("@PortalID", portalId)); parameter.Add(new KeyValuePair<string, object>("@StoreAccessKeyID", storeAccesskeyId)); parameter.Add(new KeyValuePair<string, object>("@StoreAccessData", accessData)); return sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckExistingStoreAccess]", parameter, "@IsUnique"); } catch (Exception ex) { throw ex; } }
public static bool IsShippingLabelCreated(int orderId, AspxCommonInfo commonInfo) { List<KeyValuePair<string, object>> paraMeter = new List<KeyValuePair<string, object>>(); paraMeter.Add(new KeyValuePair<string, object>("@OrderID", orderId)); paraMeter.Add(new KeyValuePair<string, object>("@PortalId", commonInfo.StoreID)); paraMeter.Add(new KeyValuePair<string, object>("@StoreId", commonInfo.StoreID)); SQLHandler sqLh = new SQLHandler(); bool isCreated = sqLh.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckLabelExist]", paraMeter, "@IsCreated"); return isCreated; }
public bool CheckTaxUniqueness(int storeID, int portalID, int value, int taxRuleID) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> Parameter = new List<KeyValuePair<string, object>>(); Parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID)); Parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID)); Parameter.Add(new KeyValuePair<string, object>("@Value", value)); Parameter.Add(new KeyValuePair<string, object>("@TaxRuleID", taxRuleID)); return sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckUniquenessForTaxRuleDisplayOrder]", Parameter, "@IsUnique"); } catch (Exception ex) { throw ex; } }
//---------------- Added for unique name check --------------------- public bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>(); parameterCollection.Add(new KeyValuePair<string, object>("@AttributeName", attrbuteUniqueObj.AttributeName)); parameterCollection.Add(new KeyValuePair<string, object>("@AttributeID", attrbuteUniqueObj.AttributeID)); parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName)); return sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique"); } catch (Exception ex) { throw ex; } }
public bool CheckUniqueSKUCode(string sku, int itemId, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>(); parameterCollection.Add(new KeyValuePair<string, object>("@SKU", sku)); parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemId)); parameterCollection.Add(new KeyValuePair<string, object>("@StoreID",aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair<string, object>("@PortalID",aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair<string, object>("@CultureName",aspxCommonObj.CultureName)); return sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_ItemSKUCodeUniquenessCheck", parameterCollection, "@IsUnique"); } catch (Exception ex) { throw ex; } }
public static bool CheckExisting(AspxCommonInfo aspxCommonObj, int storeAccesskeyId, string accessData) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@StoreAccessKeyID", storeAccesskeyId)); parameter.Add(new KeyValuePair<string, object>("@StoreAccessData", accessData)); bool isUnique= sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckExistingStoreAccess]", parameter, "@IsUnique"); return isUnique; } catch (Exception e) { throw e; } }
public bool CheckRemainingDownload(int itemId, int orderItemId, int storeId, int portalId, string userName) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>(); parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemId)); parameterCollection.Add(new KeyValuePair<string, object>("@OrderItemID", orderItemId)); parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeId)); parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalId)); parameterCollection.Add(new KeyValuePair<string, object>("@UserName", userName)); return sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CheckRemainingDownloadForCustomer", parameterCollection, "@IsRemainDowload"); } catch (Exception ex) { throw ex; } }
public bool CheckCatalogPriorityUniqueness(int CatalogPriceRuleID, int Priority, int StoreID, int PortalID) { try { SQLHandler Sq = new SQLHandler(); List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", CatalogPriceRuleID)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@Priority", Priority)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@StoreID", StoreID)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); return Sq.ExecuteNonQueryAsBool("[usp_ASPX_CatalogPriorityUniquenessCheck]", ParaMeterCollection, "@IsUnique"); } catch (Exception ex) { throw ex; } }
public static bool CheckRemainingDownload(int itemId, int orderItemId, AspxCommonInfo aspxCommonObj) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemId)); parameterCollection.Add(new KeyValuePair<string, object>("@OrderItemID", orderItemId)); bool isRemain = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CheckRemainingDownloadForCustomer", parameterCollection, "@IsRemainDowload"); return isRemain; } catch (Exception e) { throw e; } }
public bool UpdateCartAnonymoususertoRegistered(int storeID, int portalID, int customerID, string sessionCode) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID)); parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID)); parameter.Add(new KeyValuePair<string, object>("@SessionCode", sessionCode)); SQLHandler sqlH = new SQLHandler(); return sqlH.ExecuteNonQueryAsBool("usp_Aspx_UpdateCartAnonymoususertoRegistered", parameter, "@IsUpdate"); } catch (Exception ex) { throw ex; } }
public bool CheckMessgeTokenUnique(string messageTempTokenName, int messageTemplateTypeID, int portalID) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> ParaMeter = new List<KeyValuePair<string, object>>(); ParaMeter.Add(new KeyValuePair<string, object>("@MsgTemplateTokenName", messageTempTokenName)); ParaMeter.Add(new KeyValuePair<string, object>("@MsgTemplateTypeID", messageTemplateTypeID)); ParaMeter.Add(new KeyValuePair<string, object>("@PortalID", portalID)); return sqlH.ExecuteNonQueryAsBool("[usp_MsgTempTokenUniquenessCheck]", ParaMeter, "@IsUnique"); } catch (Exception e) { throw e; } }
public bool CheckDownloadableItemOnly(int storeID, int portalID, int customerID, string sessionCode) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID)); parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID)); parameter.Add(new KeyValuePair<string, object>("@SessionCode", sessionCode)); SQLHandler sqlH = new SQLHandler(); return sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckForDownloadableItemsInCart]", parameter, "@IsAllDownloadable"); } catch (Exception ex) { throw ex; } }
public bool CheckCreditCard(int storeID, int portalID, string creditCardNo) { try { SQLHandler sqlH = new SQLHandler(); List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID)); parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID)); parameter.Add(new KeyValuePair<string, object>("@CreditCard", creditCardNo)); //parameter.Add(new KeyValuePair<string, object>("@IsExist", 0)); return sqlH.ExecuteNonQueryAsBool("usp_Aspx_CheckCreditCardBlackList", parameter, "@IsExist"); } catch (Exception ex) { throw ex; } }
public bool CheckUniqueSKUCode(string SKU, int itemId, int storeId, int portalId, string cultureName) { try { SQLHandler Sq = new SQLHandler(); List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@SKU", SKU)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemId)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeId)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalId)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@CultureName", cultureName)); return Sq.ExecuteNonQueryAsBool("dbo.usp_ASPX_ItemSKUCodeUniquenessCheck", ParaMeterCollection, "@IsUnique"); } catch (Exception ex) { throw ex; } }