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) { OracleHandler sqlH = new OracleHandler(); 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("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)); OracleHandler sqLh = new OracleHandler(); bool isCreated = sqLh.ExecuteNonQueryAsBool("usp_Aspx_CheckLabelExist", paraMeter, "IsCreated"); return(isCreated); }
public static bool SerialNumberExist(string serialNumber) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > Parameter = new List <KeyValuePair <string, object> >(); Parameter.Add(new KeyValuePair <string, object>("GoogleSerialNumber", serialNumber)); return(sqlH.ExecuteNonQueryAsBool("usp_Aspx_GoogleSerialNumberExists", Parameter, "IsExists")); } catch (Exception ex) { throw ex; } }
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)); OracleHandler sqlH = new OracleHandler(); 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)); OracleHandler sqlh = new OracleHandler(); bool isUnique = sqlh.ExecuteNonQueryAsBool("usp_Aspx_CheckTaxClassUniqueness", parameter, "IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public bool CheckKitComponentExist(string ComponentName, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("ComponentName", ComponentName)); bool isUnique = sqlH.ExecuteNonQueryAsBool("usp_Aspx_CheckKitComponentExist", parameterCollection, "IsComponentExist"); return(isUnique); } catch (Exception e) { throw e; } }
public bool CheckCatalogRuleExist(AspxCommonInfo aspxCommonObj) { try { bool isExist = false; OracleHandler sqlHandler = new OracleHandler(); List <KeyValuePair <string, object> > paramList = CommonParmBuilder.GetParamSP(aspxCommonObj); isExist = sqlHandler.ExecuteNonQueryAsBool("usp_Aspx_CheckCatalogRuleExist", paramList, "IsExist"); return(isExist); } catch (Exception e) { throw e; } }
public static bool CheckCouponTypeUniqueness(AspxCommonInfo aspxCommonObj, int couponTypeId, string couponType) { try { OracleHandler sqlH = new OracleHandler(); 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 CheckRemainingDownload(int itemId, int orderItemId, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); 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("usp_Aspx_CheckRemainingDownloadForCustomer", parameterCollection, "IsRemainDowload"); return(isRemain); } catch (Exception e) { throw e; } }
//---------------- Added for unique name check --------------------- public static bool CheckUniqueCostVariantName(string costVariantName, int costVariantId, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("CostVariantName", costVariantName)); parameterCollection.Add(new KeyValuePair <string, object>("CostVariantID", costVariantId)); bool isUnique = sqlH.ExecuteNonQueryAsBool("usp_Aspx_CostVariantUniquenessCheck", parameterCollection, "IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckExisting(AspxCommonInfo aspxCommonObj, int storeAccesskeyId, string accessData) { try { OracleHandler sqlH = new OracleHandler(); 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("usp_Aspx_CheckExistingStoreAccess", parameter, "IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckCurrencyCodeUniqueness(AspxCommonInfo aspxCommonObj, string currencyCode, int currencyID) { try { OracleHandler sqlH = new OracleHandler(); 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("usp_Aspx_CheckCurrCodeUniqueness", Parameter, "IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool GetModuleInstallationInfo(string moduleFriendlyName, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); 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 CheckCatalogPriorityUniqueness(int catalogPriceRuleID, int priority, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); 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 CheckShippingProviderUniqueness(AspxCommonInfo aspxCommonObj, int shippingProviderId, string shippingProviderName) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > Parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); Parameter.Add(new KeyValuePair <string, object>("ShippingProviderID", shippingProviderId)); Parameter.Add(new KeyValuePair <string, object>("ShippingProviderName", shippingProviderName)); bool isUnique = sqlH.ExecuteNonQueryAsBool("usp_Aspx_CheckShippingProviderUniquness", Parameter, "IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckUniquenessForDisplayOrder(AspxCommonInfo aspxCommonObj, int value, int shippingMethodID) { try { OracleHandler sqlH = new OracleHandler(); 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("usp_Aspx_CheckUniquenessForDisplayOrder", Parameter, "IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); 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("usp_Aspx_AttributeUniquenessCheck", parameterCollection, "IsUnique"); return(isUnique); } catch (Exception e) { throw e; } }
public static bool IsPurchaseActive(AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); 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)); //usp_Aspx_RewardPointsIsPurchaseActive return(sqlH.ExecuteNonQueryAsBool("usp_Aspx_RewardPointsIsPurchas", parameter, "IsActive")); } catch (Exception ex) { throw ex; } }
public static bool RewardPointsGeneralSettingsIsActive(AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); 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 static bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo) { try { OracleHandler sqlH = new OracleHandler(); 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; } }
public static bool CheckCartPricePriorityUniqueness(int cartPriceRuleID, int priority, int portalID) { try { OracleHandler Sq = new OracleHandler(); 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 CheckUniqueName(string catName, int catId, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); 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", aspxCommonObj.StoreID)); parameterCollection.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID)); parameterCollection.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName)); return(sqlH.ExecuteNonQueryAsBool("usp_Aspx_CategoryNameUniquenessCheck", parameterCollection, "IsUnique")); } catch (Exception ex) { throw ex; } }
public static 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)); OracleHandler sqlH = new OracleHandler(); bool isUpdate = sqlH.ExecuteNonQueryAsBool("usp_Aspx_UpdateCartAnonymousUserToRegistered", parameter, "IsUpdate"); return(isUpdate); } catch (Exception e) { throw e; } }