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;
}
}