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