public List <PortalRole> GetPortalRoles(int portalID, bool isAll, string userName) { string rolePrefix = string.Empty; PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); List <PortalInfo> portalInfoList = priceRuleSqlProvider.GetPortalSeoName(portalID, userName); if (portalInfoList.Count > 0) { rolePrefix = portalInfoList[0].SEOName.Trim() + "_"; } List <PortalRole> portalRoleList = priceRuleSqlProvider.GetPortalRoles(portalID, isAll, userName); foreach (PortalRole pr in portalRoleList) { bool isSystemRole = false; foreach (string sysRole in SystemSetting.SYSTEM_ROLES) { if (sysRole.ToLower() == pr.RoleName.ToLower()) { isSystemRole = true; } } if (!isSystemRole) { pr.RoleName = pr.RoleName.Replace(rolePrefix, ""); } } return(portalRoleList); }
public List <CatalogPriceRulePaging> GetCatalogPricingRules(string ruleName, System.Nullable <DateTime> startDate, System.Nullable <DateTime> endDate, System.Nullable <bool> isActive, Int32 storeID, Int32 portalID, string userName, string culture, int offset, int limit) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); List <CatalogPriceRulePaging> lstCatalogPriceRule = priceRuleSqlProvider.GetCatalogPricingRules(ruleName, startDate, endDate, isActive, storeID, portalID, userName, culture, offset, limit); return(lstCatalogPriceRule); }
public List<PortalRole> GetPortalRoles(int portalID, bool isAll, string userName) { string rolePrefix = string.Empty; PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); List<PortalStoreInfo> portalInfoList = priceRuleSqlProvider.GetPortalSeoName(portalID, userName); if (portalInfoList.Count > 0) { rolePrefix = portalInfoList[0].SEOName.Trim() + "_"; } List<PortalRole> portalRoleList = priceRuleSqlProvider.GetPortalRoles(portalID, isAll, userName); foreach (PortalRole pr in portalRoleList) { bool isSystemRole = false; foreach (string sysRole in SystemSetting.SYSTEM_ROLES) { if (sysRole.ToLower() == pr.RoleName.ToLower()) { isSystemRole = true; } } if (!isSystemRole) { pr.RoleName = pr.RoleName.Replace(rolePrefix, ""); } } return portalRoleList; }
public CatalogPricingRuleInfo GetCatalogPricingRule(Int32 catalogPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); DataSet ds = new DataSet(); ds = priceRuleSqlProvider.GetCatalogPricingRule(catalogPriceRuleID, storeID, portalID, userName, culture); DataTable dtCatalogPricingRule = ds.Tables[0]; DataTable dtCatalogPriceRuleCondition = ds.Tables[1]; DataTable dtCatalogConditionDetails = ds.Tables[2]; DataTable dtCatalogPriceRuleRoles = ds.Tables[3]; List <CatalogPriceRule> lstCatalogPriceRule; lstCatalogPriceRule = DataSourceHelper.FillCollection <CatalogPriceRule>(dtCatalogPricingRule); List <CatalogPriceRuleCondition> lstCatalogPriceRuleCondition; lstCatalogPriceRuleCondition = DataSourceHelper.FillCollection <CatalogPriceRuleCondition>(dtCatalogPriceRuleCondition); List <CatalogPriceRuleRole> lstCatalogPriceRuleRole; lstCatalogPriceRuleRole = DataSourceHelper.FillCollection <CatalogPriceRuleRole>(dtCatalogPriceRuleRoles); List <CatalogConditionDetail> lstCatalogConditionDetail; lstCatalogConditionDetail = DataSourceHelper.FillCollection <CatalogConditionDetail>(dtCatalogConditionDetails); CatalogPricingRuleInfo catalogPricingRuleInfo = new CatalogPricingRuleInfo(); CatalogPriceRule catalogPriceRule = lstCatalogPriceRule[0]; catalogPricingRuleInfo.CatalogPriceRule = catalogPriceRule; List <CatalogPriceRuleCondition> lstCPRC = new List <CatalogPriceRuleCondition>(); foreach (CatalogPriceRuleCondition catalogPriceRuleCondition in lstCatalogPriceRuleCondition) { List <CatalogConditionDetail> lstCCD = new List <CatalogConditionDetail>(); foreach (CatalogConditionDetail catalogConditionDetail in lstCatalogConditionDetail) { if (catalogPriceRuleCondition.CatalogPriceRuleConditionID == catalogConditionDetail.CatalogPriceRuleConditionID) { lstCCD.Add(catalogConditionDetail); } } catalogPriceRuleCondition.CatalogConditionDetail = lstCCD; lstCPRC.Add(catalogPriceRuleCondition); } catalogPricingRuleInfo.CatalogPriceRuleConditions = lstCPRC; List <CatalogPriceRuleRole> lstCPRR = new List <CatalogPriceRuleRole>(); foreach (CatalogPriceRuleRole catalogPriceRuleRole in lstCatalogPriceRuleRole) { if (catalogPriceRuleRole.CatalogPriceRuleID == catalogPriceRule.CatalogPriceRuleID) { lstCPRR.Add(catalogPriceRuleRole); } } catalogPricingRuleInfo.CatalogPriceRuleRoles = lstCPRR; return(catalogPricingRuleInfo); }
public List <CatalogPriceRulePaging> GetCatalogPricingRules(string ruleName, System.Nullable <DateTime> startDate, System.Nullable <DateTime> endDate, System.Nullable <bool> isActive, AspxCommonInfo aspxCommonObj, int offset, int limit) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); List <CatalogPriceRulePaging> lstCatalogPriceRule = priceRuleSqlProvider.GetCatalogPricingRules(ruleName, startDate, endDate, isActive, aspxCommonObj, offset, limit); return(lstCatalogPriceRule); }
public int SaveCatalogPricingRule(CatalogPricingRuleInfo objCatalogPricingRuleInfo, AspxCommonInfo aspxCommonObj, object parentID) { int catalogPriceRuleID = -1; PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); catalogPriceRuleID = priceRuleSqlProvider.CatalogPriceRuleAdd(objCatalogPricingRuleInfo.CatalogPriceRule, aspxCommonObj); if (catalogPriceRuleID > 0) { int count = 0; int cpID = 0; int catalogConditionID = 0; List <object> lstParent = new JavaScriptSerializer().ConvertToType <List <object> >(parentID); foreach (CatalogPriceRuleCondition catalogPriceRuleCondition in objCatalogPricingRuleInfo.CatalogPriceRuleConditions) { if (count == 1 && catalogConditionID > 1) { cpID = catalogConditionID - 1; } catalogPriceRuleCondition.ParentID = cpID + int.Parse(lstParent[count].ToString()); catalogPriceRuleCondition.CatalogPriceRuleID = catalogPriceRuleID; catalogConditionID = priceRuleSqlProvider.CatalogPriceRuleConditionAdd(catalogPriceRuleCondition, aspxCommonObj); count++; } int catalogPriceRuleRoleID = -1; foreach (CatalogPriceRuleRole catalogPriceRuleRole in objCatalogPricingRuleInfo.CatalogPriceRuleRoles) { catalogPriceRuleRole.CatalogPriceRuleID = catalogPriceRuleID; catalogPriceRuleRoleID = priceRuleSqlProvider.CatalogPriceRuleRoleAdd(catalogPriceRuleRole, aspxCommonObj); } } return(1); }
public CatalogPricingRuleInfo GetCatalogPricingRule(Int32 catalogPriceRuleID,AspxCommonInfo aspxCommonObj) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); DataSet ds = new DataSet(); ds = priceRuleSqlProvider.GetCatalogPricingRule(catalogPriceRuleID,aspxCommonObj); DataTable dtCatalogPricingRule = ds.Tables[0]; DataTable dtCatalogPriceRuleCondition = ds.Tables[1]; DataTable dtCatalogConditionDetails = ds.Tables[2]; DataTable dtCatalogPriceRuleRoles = ds.Tables[3]; List<CatalogPriceRule> lstCatalogPriceRule; lstCatalogPriceRule = DataSourceHelper.FillCollection<CatalogPriceRule>(dtCatalogPricingRule); List<CatalogPriceRuleCondition> lstCatalogPriceRuleCondition; lstCatalogPriceRuleCondition = DataSourceHelper.FillCollection<CatalogPriceRuleCondition>(dtCatalogPriceRuleCondition); List<CatalogPriceRuleRole> lstCatalogPriceRuleRole; lstCatalogPriceRuleRole = DataSourceHelper.FillCollection<CatalogPriceRuleRole>(dtCatalogPriceRuleRoles); List<CatalogConditionDetail> lstCatalogConditionDetail; lstCatalogConditionDetail = DataSourceHelper.FillCollection<CatalogConditionDetail>(dtCatalogConditionDetails); CatalogPricingRuleInfo catalogPricingRuleInfo = new CatalogPricingRuleInfo(); CatalogPriceRule catalogPriceRule = lstCatalogPriceRule[0]; catalogPricingRuleInfo.CatalogPriceRule = catalogPriceRule; List<CatalogPriceRuleCondition> lstCPRC = new List<CatalogPriceRuleCondition>(); foreach (CatalogPriceRuleCondition catalogPriceRuleCondition in lstCatalogPriceRuleCondition) { List<CatalogConditionDetail> lstCCD = new List<CatalogConditionDetail>(); foreach (CatalogConditionDetail catalogConditionDetail in lstCatalogConditionDetail) { if (catalogPriceRuleCondition.CatalogPriceRuleConditionID == catalogConditionDetail.CatalogPriceRuleConditionID) { lstCCD.Add(catalogConditionDetail); } } catalogPriceRuleCondition.CatalogConditionDetail = lstCCD; lstCPRC.Add(catalogPriceRuleCondition); } catalogPricingRuleInfo.CatalogPriceRuleConditions = lstCPRC; List<CatalogPriceRuleRole> lstCPRR = new List<CatalogPriceRuleRole>(); foreach (CatalogPriceRuleRole catalogPriceRuleRole in lstCatalogPriceRuleRole) { if (catalogPriceRuleRole.CatalogPriceRuleID == catalogPriceRule.CatalogPriceRuleID) { lstCPRR.Add(catalogPriceRuleRole); } } catalogPricingRuleInfo.CatalogPriceRuleRoles = lstCPRR; return catalogPricingRuleInfo; }
public int CatalogPriceRuleConditionAdd(CatalogPriceRuleCondition catalogPriceRuleCondition, Int32 storeID, Int32 portalID, string userName, string culture) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleID", catalogPriceRuleCondition.CatalogPriceRuleID)); sqlCommand.Parameters.Add(new SqlParameter("@IsAll", catalogPriceRuleCondition.IsAll)); sqlCommand.Parameters.Add(new SqlParameter("@IsTrue", catalogPriceRuleCondition.IsTrue)); sqlCommand.Parameters.Add(new SqlParameter("@ParentID", catalogPriceRuleCondition.ParentID)); sqlCommand.Parameters.Add(new SqlParameter("@IsActive", true)); sqlCommand.Parameters.Add(new SqlParameter("@StoreID", storeID)); sqlCommand.Parameters.Add(new SqlParameter("@PortalID", portalID)); sqlCommand.Parameters.Add(new SqlParameter("@Username", userName)); sqlCommand.Parameters.Add(new SqlParameter("@CultureName", culture)); sqlCommand.CommandText = "usp_Aspx_CatalogPriceRuleConditionAdd"; sqlCommand.CommandType = CommandType.StoredProcedure; SqlConnection sqlConnection = new SqlConnection(ConnectionString); try { sqlCommand.Connection = sqlConnection; sqlConnection.Open(); object val = sqlCommand.ExecuteScalar(); if (Convert.ToInt16(val) > 0) { int catalogConditionDetailID = -1; PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); foreach (CatalogConditionDetail catalogConditionDetail in catalogPriceRuleCondition.CatalogConditionDetail) { if (catalogConditionDetail != null) { catalogConditionDetail.CatalogPriceRuleConditionID = Convert.ToInt16(val); catalogConditionDetail.CatalogPriceRuleID = catalogPriceRuleCondition.CatalogPriceRuleID; catalogConditionDetailID = priceRuleSqlProvider.CatalogConditionDetailAdd(catalogConditionDetail, storeID, portalID, userName, culture); if (!(catalogConditionDetailID > 0)) { } } } } return(Convert.ToInt16(val)); } catch (Exception e) { throw e; } finally { sqlConnection.Close(); } }
public int SaveCartPricingRule(CartPricingRuleInfo objCartPriceRule, Int32 storeID, Int32 portalID, string userName, string culture, object parentID) { SQLHandler sqlH = new SQLHandler(); SqlTransaction tran; tran = (SqlTransaction)sqlH.GetTransaction(); PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); try { int cartPriceRuleID = -1; cartPriceRuleID = priceRuleSqlProvider.CartPriceRuleAdd(objCartPriceRule.CartPriceRule, tran, portalID, userName, culture); priceRuleSqlProvider.RuleConditionAdd(objCartPriceRule.LstRuleCondition, cartPriceRuleID, parentID, tran, portalID, userName, culture); foreach (CartPriceRuleRole cartPriceRuleRole in objCartPriceRule.LstCartPriceRuleRoles) { cartPriceRuleRole.CartPriceRuleID = cartPriceRuleID; priceRuleSqlProvider.CartPriceRuleRoleAdd(cartPriceRuleRole, tran, portalID, userName, culture); } foreach (CartPriceRuleStore cartPriceRuleStore in objCartPriceRule.LstCartPriceRuleStores) { cartPriceRuleStore.CartPriceRuleID = cartPriceRuleID; priceRuleSqlProvider.CartPriceRuleStoreAdd(cartPriceRuleStore, tran, portalID, userName, culture); } tran.Commit(); return(cartPriceRuleID); } catch (SqlException sqlEX) { tran.Rollback(); throw new ArgumentException(sqlEX.Message); } catch (Exception ex) { tran.Rollback(); throw ex; } }
public int CartPriceRuleDelete(int cartPriceRuleID, AspxCommonInfo aspxCommonObj) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); return priceRuleSqlProvider.CartPriceRuleDelete(cartPriceRuleID,aspxCommonObj); }
public int SaveCartPricingRule(CartPricingRuleInfo objCartPriceRule, AspxCommonInfo aspxCommonObj, object parentID) { SQLHandler sqlH = new SQLHandler(); SqlTransaction tran; tran = (SqlTransaction) sqlH.GetTransaction(); PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); try { int cartPriceRuleID = -1; cartPriceRuleID = priceRuleSqlProvider.CartPriceRuleAdd(objCartPriceRule.CartPriceRule, tran,aspxCommonObj); priceRuleSqlProvider.RuleConditionAdd(objCartPriceRule.LstRuleCondition,cartPriceRuleID,parentID, tran,aspxCommonObj); foreach (CartPriceRuleRole cartPriceRuleRole in objCartPriceRule.LstCartPriceRuleRoles) { cartPriceRuleRole.CartPriceRuleID = cartPriceRuleID; priceRuleSqlProvider.CartPriceRuleRoleAdd(cartPriceRuleRole, tran,aspxCommonObj); } foreach (CartPriceRuleStore cartPriceRuleStore in objCartPriceRule.LstCartPriceRuleStores) { cartPriceRuleStore.CartPriceRuleID = cartPriceRuleID; priceRuleSqlProvider.CartPriceRuleStoreAdd(cartPriceRuleStore, tran,aspxCommonObj); } tran.Commit(); return cartPriceRuleID; } catch (SqlException sqlEX) { tran.Rollback(); throw new ArgumentException(sqlEX.Message); } catch (Exception ex) { tran.Rollback(); throw ex; } }
public int SaveCatalogPricingRule(CatalogPricingRuleInfo objCatalogPricingRuleInfo, AspxCommonInfo aspxCommonObj, object parentID) { int catalogPriceRuleID = -1; PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); catalogPriceRuleID = priceRuleSqlProvider.CatalogPriceRuleAdd(objCatalogPricingRuleInfo.CatalogPriceRule, aspxCommonObj); if (catalogPriceRuleID > 0) { int count = 0; int cpID = 0; int catalogConditionID = 0; List<object> lstParent = new JavaScriptSerializer().ConvertToType<List<object>>(parentID); foreach (CatalogPriceRuleCondition catalogPriceRuleCondition in objCatalogPricingRuleInfo.CatalogPriceRuleConditions) { if (count == 1 && catalogConditionID > 1) cpID = catalogConditionID - 1; catalogPriceRuleCondition.ParentID = cpID + int.Parse(lstParent[count].ToString()); catalogPriceRuleCondition.CatalogPriceRuleID = catalogPriceRuleID; catalogConditionID = priceRuleSqlProvider.CatalogPriceRuleConditionAdd(catalogPriceRuleCondition, aspxCommonObj); count++; } int catalogPriceRuleRoleID = -1; foreach (CatalogPriceRuleRole catalogPriceRuleRole in objCatalogPricingRuleInfo.CatalogPriceRuleRoles) { catalogPriceRuleRole.CatalogPriceRuleID = catalogPriceRuleID; catalogPriceRuleRoleID = priceRuleSqlProvider.CatalogPriceRuleRoleAdd(catalogPriceRuleRole,aspxCommonObj); } } return 1; }
public int CatalogPriceRuleConditionAdd(CatalogPriceRuleCondition catalogPriceRuleCondition, Int32 storeID, Int32 portalID, string userName, string culture) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleID", catalogPriceRuleCondition.CatalogPriceRuleID)); sqlCommand.Parameters.Add(new SqlParameter("@IsAll", catalogPriceRuleCondition.IsAll)); sqlCommand.Parameters.Add(new SqlParameter("@IsTrue", catalogPriceRuleCondition.IsTrue)); sqlCommand.Parameters.Add(new SqlParameter("@ParentID", catalogPriceRuleCondition.ParentID)); sqlCommand.Parameters.Add(new SqlParameter("@IsActive", true)); sqlCommand.Parameters.Add(new SqlParameter("@StoreID", storeID)); sqlCommand.Parameters.Add(new SqlParameter("@PortalID", portalID)); sqlCommand.Parameters.Add(new SqlParameter("@Username", userName)); sqlCommand.Parameters.Add(new SqlParameter("@CultureName", culture)); sqlCommand.CommandText = "usp_Aspx_CatalogPriceRuleConditionAdd"; sqlCommand.CommandType = CommandType.StoredProcedure; SqlConnection sqlConnection = new SqlConnection(ConnectionString); try { sqlCommand.Connection = sqlConnection; sqlConnection.Open(); object val = sqlCommand.ExecuteScalar(); if (Convert.ToInt16(val) > 0) { int catalogConditionDetailID = -1; PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); foreach (CatalogConditionDetail catalogConditionDetail in catalogPriceRuleCondition.CatalogConditionDetail) { if (catalogConditionDetail != null) { catalogConditionDetail.CatalogPriceRuleConditionID = Convert.ToInt16(val); catalogConditionDetail.CatalogPriceRuleID = catalogPriceRuleCondition.CatalogPriceRuleID; catalogConditionDetailID = priceRuleSqlProvider.CatalogConditionDetailAdd(catalogConditionDetail, storeID, portalID, userName, culture); if (!(catalogConditionDetailID > 0)) { } } } } return Convert.ToInt16(val); } catch (Exception e) { throw e; } finally { sqlConnection.Close(); } }
public int CartPriceMultipleRulesDelete(string cartRulesIds, int storeID, int portalID, string userName, string culture) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); return(priceRuleSqlProvider.CartPriceRulesMultipleDelete(cartRulesIds, storeID, portalID, userName, culture)); }
public int CartPriceRuleDelete(int cartPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); return(priceRuleSqlProvider.CartPriceRuleDelete(cartPriceRuleID, portalID, storeID, userName, culture)); }
public int CartPriceMultipleRulesDelete(string cartRulesIds, AspxCommonInfo aspxCommonObj) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); return(priceRuleSqlProvider.CartPriceRulesMultipleDelete(cartRulesIds, aspxCommonObj)); }
public int CartPriceRuleDelete(int cartPriceRuleID, AspxCommonInfo aspxCommonObj) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); return(priceRuleSqlProvider.CartPriceRuleDelete(cartPriceRuleID, aspxCommonObj)); }
public int CartPriceMultipleRulesDelete(string cartRulesIds, AspxCommonInfo aspxCommonObj) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); return priceRuleSqlProvider.CartPriceRulesMultipleDelete(cartRulesIds,aspxCommonObj); }
public CartPricingRuleInfo GetCartPriceRules(Int32 cartPriceRuleID, AspxCommonInfo aspxCommonObj) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); CartPricingRuleInfo cartPricingRuleInfo = new CartPricingRuleInfo(); DataSet ds = new DataSet(); ds = priceRuleSqlProvider.GetCartPriceRule(cartPriceRuleID,aspxCommonObj); DataTable dtCartPricingRule = ds.Tables[0]; DataTable dtRuleConditions = ds.Tables[1]; DataTable dtCartPriceRuleRoles = ds.Tables[2]; DataTable dtCartPriceRuleStores = ds.Tables[3]; List<CartPriceRule> lstCartPriceRule; lstCartPriceRule = DataSourceHelper.FillCollection<CartPriceRule>(dtCartPricingRule); List<RuleCondition> lstRuleConditions; lstRuleConditions = DataSourceHelper.FillCollection<RuleCondition>(dtRuleConditions); List<CartPriceRuleRole> lstCartPriceRuleRole; lstCartPriceRuleRole = DataSourceHelper.FillCollection<CartPriceRuleRole>(dtCartPriceRuleRoles); List<CartPriceRuleStore> lstCartPriceRuleStore; lstCartPriceRuleStore = DataSourceHelper.FillCollection<CartPriceRuleStore>(dtCartPriceRuleStores); cartPricingRuleInfo.CartPriceRule = lstCartPriceRule[0]; List<RuleCondition> lstRC = new List<RuleCondition>(); foreach (RuleCondition rc in lstRuleConditions) { RuleCondition objRC = new RuleCondition(); objRC.ParentID = rc.ParentID; objRC.RuleConditionID = rc.RuleConditionID; objRC.RuleConditionType = rc.RuleConditionType; objRC.CartPriceRuleID = rc.CartPriceRuleID; if (rc.RuleConditionType.ToUpper().Trim() == "PAC".ToUpper().Trim()) { objRC.LstProductAttributeRuleConditions = priceRuleSqlProvider.GetCartPriceProductAttributeConditions(rc.RuleConditionID, aspxCommonObj.PortalID); objRC.LstProductAttributeRuleConditions[0].LstCartConditionDetails = priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID,rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName); lstRC.Add(objRC); } else if (rc.RuleConditionType.ToUpper().Trim() == "PS".ToUpper().Trim()) { objRC.LstProductSublectionRuleConditions = priceRuleSqlProvider.GetCartPriceSubSelections(rc.RuleConditionID, aspxCommonObj.PortalID); objRC.LstProductSublectionRuleConditions[0].LstCartConditionDetails = priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName); lstRC.Add(objRC); } else if (rc.RuleConditionType.ToUpper().Trim() == "CC".ToUpper().Trim()) { objRC.LstCartPriceRuleConditions = priceRuleSqlProvider.GetCartPriceRuleConditions(rc.RuleConditionID, aspxCommonObj.PortalID); objRC.LstCartPriceRuleConditions[0].LstCartConditionDetails = priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName); lstRC.Add(objRC); } } cartPricingRuleInfo.LstRuleCondition = lstRC; cartPricingRuleInfo.LstCartPriceRuleRoles = lstCartPriceRuleRole; cartPricingRuleInfo.LstCartPriceRuleStores = lstCartPriceRuleStore; return cartPricingRuleInfo; }
public CartPricingRuleInfo GetCartPriceRules(Int32 cartPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); CartPricingRuleInfo cartPricingRuleInfo = new CartPricingRuleInfo(); DataSet ds = new DataSet(); ds = priceRuleSqlProvider.GetCartPriceRule(cartPriceRuleID, portalID, userName, culture); DataTable dtCartPricingRule = ds.Tables[0]; DataTable dtRuleConditions = ds.Tables[1]; DataTable dtCartPriceRuleRoles = ds.Tables[2]; DataTable dtCartPriceRuleStores = ds.Tables[3]; List <CartPriceRule> lstCartPriceRule; lstCartPriceRule = DataSourceHelper.FillCollection <CartPriceRule>(dtCartPricingRule); List <RuleCondition> lstRuleConditions; lstRuleConditions = DataSourceHelper.FillCollection <RuleCondition>(dtRuleConditions); List <CartPriceRuleRole> lstCartPriceRuleRole; lstCartPriceRuleRole = DataSourceHelper.FillCollection <CartPriceRuleRole>(dtCartPriceRuleRoles); List <CartPriceRuleStore> lstCartPriceRuleStore; lstCartPriceRuleStore = DataSourceHelper.FillCollection <CartPriceRuleStore>(dtCartPriceRuleStores); cartPricingRuleInfo.CartPriceRule = lstCartPriceRule[0]; List <RuleCondition> lstRC = new List <RuleCondition>(); foreach (RuleCondition rc in lstRuleConditions) { RuleCondition objRC = new RuleCondition(); objRC.ParentID = rc.ParentID; objRC.RuleConditionID = rc.RuleConditionID; objRC.RuleConditionType = rc.RuleConditionType; objRC.CartPriceRuleID = rc.CartPriceRuleID; if (rc.RuleConditionType.ToUpper().Trim() == "PAC".ToUpper().Trim()) { objRC.LstProductAttributeRuleConditions = priceRuleSqlProvider.GetCartPriceProductAttributeConditions(rc.RuleConditionID, portalID); objRC.LstProductAttributeRuleConditions[0].LstCartConditionDetails = priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, portalID, userName); lstRC.Add(objRC); } else if (rc.RuleConditionType.ToUpper().Trim() == "PS".ToUpper().Trim()) { objRC.LstProductSublectionRuleConditions = priceRuleSqlProvider.GetCartPriceSubSelections(rc.RuleConditionID, portalID); objRC.LstProductSublectionRuleConditions[0].LstCartConditionDetails = priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, portalID, userName); lstRC.Add(objRC); } else if (rc.RuleConditionType.ToUpper().Trim() == "CC".ToUpper().Trim()) { objRC.LstCartPriceRuleConditions = priceRuleSqlProvider.GetCartPriceRuleConditions(rc.RuleConditionID, portalID); objRC.LstCartPriceRuleConditions[0].LstCartConditionDetails = priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, portalID, userName); lstRC.Add(objRC); } } cartPricingRuleInfo.LstRuleCondition = lstRC; cartPricingRuleInfo.LstCartPriceRuleRoles = lstCartPriceRuleRole; cartPricingRuleInfo.LstCartPriceRuleStores = lstCartPriceRuleStore; return(cartPricingRuleInfo); }
public List<CatalogPriceRulePaging> GetCatalogPricingRules(string ruleName, System.Nullable<DateTime> startDate, System.Nullable<DateTime> endDate, System.Nullable<bool> isActive, AspxCommonInfo aspxCommonObj, int offset, int limit) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); List<CatalogPriceRulePaging> lstCatalogPriceRule = priceRuleSqlProvider.GetCatalogPricingRules(ruleName, startDate, endDate,isActive,aspxCommonObj, offset, limit); return lstCatalogPriceRule; }
public List<PricingRuleAttributeInfo> GetPricingRuleAttributes(int storeID, int portalID, string userName, string cultureName) { try { List<PricingRuleAttributeInfo> portalRoleCollection; PriceRuleSqlProvider priceRuleController = new PriceRuleSqlProvider(); portalRoleCollection = priceRuleController.GetPricingRuleAttributes(portalID, storeID, userName, cultureName); return portalRoleCollection; } catch (Exception ex) { throw ex; } }
public int CartPriceMultipleRulesDelete(string cartRulesIds, int storeID, int portalID, string userName, string culture) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); return priceRuleSqlProvider.CartPriceRulesMultipleDelete(cartRulesIds, storeID, portalID, userName, culture); }
public List<CatalogPriceRulePaging> GetCatalogPricingRules(string ruleName, System.Nullable<DateTime> startDate, System.Nullable<DateTime> endDate, System.Nullable<bool> isActive, Int32 storeID, Int32 portalID, string userName, string culture, int offset, int limit) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); List<CatalogPriceRulePaging> lstCatalogPriceRule = priceRuleSqlProvider.GetCatalogPricingRules(ruleName, startDate, endDate,isActive, storeID, portalID, userName, culture, offset, limit); return lstCatalogPriceRule; }
public List<CartPricingRuleAttributeInfo> GetCartPricingRuleAttributes(int storeID, int portalID, string userName, string cultureName) { try { List<CartPricingRuleAttributeInfo> lst; PriceRuleSqlProvider priceRuleProvider = new PriceRuleSqlProvider(); lst = priceRuleProvider.GetCartPricingRuleAttributes(portalID, storeID, userName, cultureName); return lst; } catch (Exception ex) { throw ex; } }
public int CartPriceRuleDelete(int cartPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture) { PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider(); return priceRuleSqlProvider.CartPriceRuleDelete(cartPriceRuleID, portalID,storeID, userName, culture); }