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 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 = new List<CatalogPriceRule>();
lstCatalogPriceRule = DataSourceHelper.FillCollection<CatalogPriceRule>(dtCatalogPricingRule);
List<CatalogPriceRuleCondition> lstCatalogPriceRuleCondition = new List<CatalogPriceRuleCondition>();
lstCatalogPriceRuleCondition = DataSourceHelper.FillCollection<CatalogPriceRuleCondition>(dtCatalogPriceRuleCondition);
List<CatalogPriceRuleRole> lstCatalogPriceRuleRole = new List<CatalogPriceRuleRole>();
lstCatalogPriceRuleRole = DataSourceHelper.FillCollection<CatalogPriceRuleRole>(dtCatalogPriceRuleRoles);
List<CatalogConditionDetail> lstCatalogConditionDetail = new List<CatalogConditionDetail>();
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<CartPricingRuleAttributeInfo> GetCartPricingRuleAttributes(int storeID, int portalID, string userName, string cultureName)
{
try
{
List<CartPricingRuleAttributeInfo> lst = new List<CartPricingRuleAttributeInfo>();
PriceRuleSqlProvider priceRuleProvider = new PriceRuleSqlProvider();
lst = priceRuleProvider.GetCartPricingRuleAttributes(portalID, storeID, userName, cultureName);
return lst;
}
catch (Exception ex)
{
throw ex;
}
}
public List<PricingRuleAttributeInfo> GetPricingRuleAttributes(int storeID, int portalID, string userName, string cultureName)
{
try
{
List<PricingRuleAttributeInfo> portalRoleCollection = new List<PricingRuleAttributeInfo>();
PriceRuleSqlProvider priceRuleController = new PriceRuleSqlProvider();
portalRoleCollection = priceRuleController.GetPricingRuleAttributes(portalID, storeID, userName, cultureName);
return portalRoleCollection;
}
catch (Exception ex)
{
throw ex;
}
}
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 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 = new List<CartPriceRule>();
lstCartPriceRule = DataSourceHelper.FillCollection<CartPriceRule>(dtCartPricingRule);
List<RuleCondition> lstRuleConditions = new List<RuleCondition>();
lstRuleConditions = DataSourceHelper.FillCollection<RuleCondition>(dtRuleConditions);
List<CartPriceRuleRole> lstCartPriceRuleRole = new List<CartPriceRuleRole>();
lstCartPriceRuleRole = DataSourceHelper.FillCollection<CartPriceRuleRole>(dtCartPriceRuleRoles);
List<CartPriceRuleStore> lstCartPriceRuleStore = new List<CartPriceRuleStore>();
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 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 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 SaveCatalogPricingRule(CatalogPricingRuleInfo objCatalogPricingRuleInfo, Int32 storeID, Int32 portalID, string userName, string culture, object parentID)
{
int catalogPriceRuleID = -1;
PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider();
catalogPriceRuleID = priceRuleSqlProvider.CatalogPriceRuleAdd(objCatalogPricingRuleInfo.CatalogPriceRule, storeID, portalID, userName, culture);
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, storeID,
portalID, userName, culture);
count++;
}
int catalogPriceRuleRoleID = -1;
foreach (CatalogPriceRuleRole catalogPriceRuleRole in objCatalogPricingRuleInfo.CatalogPriceRuleRoles)
{
catalogPriceRuleRole.CatalogPriceRuleID = catalogPriceRuleID;
catalogPriceRuleRoleID = priceRuleSqlProvider.CatalogPriceRuleRoleAdd(catalogPriceRuleRole, storeID, portalID, userName, culture);
}
}
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();
}
}