public static int CartPriceRuleAdd(CartPriceRule cartPriceRule, SqlTransaction tran, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter =CommonParmBuilder.GetParamPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@CartPriceRuleName", cartPriceRule.CartPriceRuleName));
parameter.Add(new KeyValuePair<string, object>("@CartPriceRuleDescription", cartPriceRule.CartPriceRuleDescription));
parameter.Add(new KeyValuePair<string, object>("@Apply", cartPriceRule.Apply));
parameter.Add(new KeyValuePair<string, object>("@Value", cartPriceRule.Value));
parameter.Add(new KeyValuePair<string, object>("@ApplytoShippingAmount", cartPriceRule.ApplytoShippingAmount));
parameter.Add(new KeyValuePair<string, object>("@DiscountQuantity", cartPriceRule.DiscountQuantity));
parameter.Add(new KeyValuePair<string, object>("@DiscountStep", cartPriceRule.DiscountStep));
parameter.Add(new KeyValuePair<string, object>("@FreeShipping", cartPriceRule.FreeShipping));
parameter.Add(new KeyValuePair<string, object>("@IsFurtherProcessing", cartPriceRule.IsFurtherProcessing));
parameter.Add(new KeyValuePair<string, object>("@FromDate", cartPriceRule.FromDate));
parameter.Add(new KeyValuePair<string, object>("@ToDate", cartPriceRule.ToDate));
parameter.Add(new KeyValuePair<string, object>("@Priority", cartPriceRule.Priority));
parameter.Add(new KeyValuePair<string, object>("@IsActive", cartPriceRule.IsActive));
try
{
SQLHandler sqlH = new SQLHandler();
if (cartPriceRule.CartPriceRuleID > 0)
DeleteCartPricingRuleForEdit(tran, cartPriceRule.CartPriceRuleID, aspxCommonObj.PortalID);
int cartPRID= sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_CartPriceRuleAdd", parameter, "@CartPriceRuleID");
return cartPRID;
}
catch (Exception e)
{
throw e;
}
}
public static void DeleteSearchTerm(string Ids, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@SearchTermID", Ids));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_DeleteSearchTerm", parameter);
}
public DataSet GetAdvanceSearchDataSet(string prefix, bool isActive, AspxCommonInfo aspxCommonObj, int CategoryID, bool IsGiftCard)
{
try
{
DataSet objHDSetting = new DataSet();
if (!CacheHelper.Get("AdvanceSearchDataSet" + aspxCommonObj.StoreID.ToString() + aspxCommonObj.PortalID.ToString() + "_" + aspxCommonObj.CultureName, out objHDSetting))
{
int itemID = 0;
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", CategoryID));
parameterCollection.Add(new KeyValuePair<string, object>("@IsGiftCard", IsGiftCard));
parameterCollection.Add(new KeyValuePair<string, object>("@Prefix", prefix));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive));
parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemID));
parameterCollection.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
objHDSetting = sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_AdvanceSearch]", parameterCollection);
}
return objHDSetting;
}
catch (Exception e)
{
throw e;
}
}
public List<CategoryInfo> GetAllCategoryForSearch(string prefix, bool isActive, AspxCommonInfo aspxCommonObj)
{
try
{
int itemID = 0;
List<CategoryInfo> catList = new List<CategoryInfo>();
if (!CacheHelper.Get("CategoryForSearch" + aspxCommonObj.StoreID.ToString() + aspxCommonObj.PortalID.ToString() +"_" + aspxCommonObj.CultureName, out catList))
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@Prefix", prefix));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive));
parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemID));
SQLHandler sqlH = new SQLHandler();
catList = sqlH.ExecuteAsList<CategoryInfo>("dbo.usp_Aspx_GetCategoryList",
parameterCollection);
CacheHelper.Add(catList, "CategoryForSearch" + aspxCommonObj.StoreID.ToString() + aspxCommonObj.PortalID.ToString() + "_" + aspxCommonObj.CultureName);
}
return catList;
}
catch (Exception e)
{
throw e;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
GetPortalCommonInfo(out StoreID, out PortalID, out UserName, out CultureName);
AspxCommonInfo aspxCommonObj = new AspxCommonInfo(StoreID, PortalID, UserName, CultureName);
if (!IsPostBack)
{
IncludeJs("WishItems", "/js/DateTime/date.js", "/js/jquery.tipsy.js", "/Modules/AspxCommerce/AspxWishList/js/WishItems.js");
IncludeCss("WishItemsCss", "/Modules/AspxCommerce/AspxWishList/css/WishItems.css");
userFriendlyURL = IsUseFriendlyUrls;
GetWishListItemsSettig(aspxCommonObj);
StoreSettingConfig ssc = new StoreSettingConfig();
ssc.GetStoreSettingParamThree(StoreSetting.DefaultProductImageURL, StoreSetting.ShowItemImagesInWishList,StoreSetting.ModuleCollapsible, out NoImageWishItemPath, out ShowWishedItemImage, out ModuleCollapsible, StoreID, PortalID, CultureName);
}
if (NoOfRecentAddedWishItems > 0)
{
BindMyWishList(aspxCommonObj);
}
IncludeLanguageJS();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public void AddUpdateCoupons(CouponSaveObj couponSaveObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@CouponID", couponSaveObj.CouponID));
parameter.Add(new KeyValuePair<string, object>("@CouponTypeID", couponSaveObj.CouponTypeID));
parameter.Add(new KeyValuePair<string, object>("@CouponCode", couponSaveObj.CouponCode));
parameter.Add(new KeyValuePair<string, object>("@CouponAmount", couponSaveObj.CouponAmount));
parameter.Add(new KeyValuePair<string, object>("@IsPercentage", couponSaveObj.IsPercentage));
parameter.Add(new KeyValuePair<string, object>("@ValidateFrom", couponSaveObj.ValidateFrom));
parameter.Add(new KeyValuePair<string, object>("@ValidateTo", couponSaveObj.ValidateTo));
parameter.Add(new KeyValuePair<string, object>("@IsActive", couponSaveObj.IsActive));
parameter.Add(new KeyValuePair<string, object>("@SettingIDs", couponSaveObj.SettingIDs));
parameter.Add(new KeyValuePair<string, object>("@SettingValues", couponSaveObj.SettingValues));
parameter.Add(new KeyValuePair<string, object>("@PortalUser_UserName", couponSaveObj.PortalUser_UserName));
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>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateCoupons", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public static void RewardPointsSaveUpdateNewRule(RewardPointsCommonInfo rewardPointsCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@RewardPointSettingsID",
rewardPointsCommonObj.RewardPointSettingsID));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleName", rewardPointsCommonObj.RewardRuleName));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleID", rewardPointsCommonObj.RewardRuleID));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleType", rewardPointsCommonObj.RewardRuleType));
parameter.Add(new KeyValuePair<string, object>("@RewardPoints", rewardPointsCommonObj.RewardPoints));
parameter.Add(new KeyValuePair<string, object>("@PurchaseAmount", rewardPointsCommonObj.PurchaseAmount));
parameter.Add(new KeyValuePair<string, object>("@IsActive", rewardPointsCommonObj.IsActive));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@CulturName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveUpdateNewRule", parameter);
}
catch (Exception e)
{
throw e;
}
}
public bool ChangePassword(AspxCommonInfo aspxCommonObj, string newPassword, string retypePassword)
{
MembershipController m = new MembershipController();
try
{
if (newPassword != "" && retypePassword != "" && newPassword == retypePassword && aspxCommonObj.UserName != "")
{
UserInfo sageUser = m.GetUserDetails(aspxCommonObj.PortalID, aspxCommonObj.UserName);
// Guid userID = (Guid)member.ProviderUserKey;
string password, passwordSalt;
PasswordHelper.EnforcePasswordSecurity(m.PasswordFormat, newPassword, out password, out passwordSalt);
UserInfo user = new UserInfo(sageUser.UserID, password, passwordSalt, m.PasswordFormat);
m.ChangePassword(user);
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void RewardPointsSaveGeneralSettings(GeneralSettingsCommonInfo generalSettingobj,
AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@RewardPoints", generalSettingobj.RewardPoints));
parameter.Add(new KeyValuePair<string, object>("@RewardAmount", generalSettingobj.RewardExchangeRate));
parameter.Add(new KeyValuePair<string, object>("@AddOrderStatusID", generalSettingobj.AddOrderStatusID));
parameter.Add(new KeyValuePair<string, object>("@SubOrderStatusID", generalSettingobj.SubOrderStatusID));
parameter.Add(new KeyValuePair<string, object>("@RewardPointsExpiresInDays",
generalSettingobj.RewardPointsExpiresInDays));
parameter.Add(new KeyValuePair<string, object>("@MinRedeemBalance", generalSettingobj.MinRedeemBalance));
parameter.Add(new KeyValuePair<string, object>("@BalanceCapped", generalSettingobj.BalanceCapped));
parameter.Add(new KeyValuePair<string, object>("@IsActive", generalSettingobj.IsActive));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@CulturName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveGeneralSettings", parameter);
}
catch (Exception e)
{
throw e;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
GetPortalCommonInfo(out StoreID, out PortalID, out CustomerID, out UserName, out CultureName, out SessionCode);
AspxCommonInfo aspxCommonObj = new AspxCommonInfo(StoreID, PortalID, UserName, CultureName, CustomerID, SessionCode);
if (!IsPostBack)
{
modulePath = this.AppRelativeTemplateSourceDirectory;
ServicePath = ResolveUrl(modulePath);
hst = AppLocalized.getLocale(modulePath);
IncludeJs("ItemsCompare", "/js/jquery.cookie.js",
"/Modules/AspxCommerce/AspxCompareItems/js/ItemsCompare.js");
IncludeCss("ItemsCompare", "/Modules/AspxCommerce/AspxCompareItems/css/module.css");
StoreSettingConfig ssc = new StoreSettingConfig();
DefaultImagePath = ssc.GetStoreSettingsByKey(StoreSetting.DefaultProductImageURL, StoreID, PortalID, CultureName);
}
IncludeLanguageJS();
CompareItems(aspxCommonObj);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public void GetSpecialItemSetting()
{
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = StoreID;
aspxCommonObj.PortalID = PortalID;
aspxCommonObj.CultureName = CultureName;
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
SpecialItemsController sic = new SpecialItemsController();
SpecialItemsSettingInfo lstSpecialSetting = sic.GetSpecialItemsSetting(aspxCommonObj);
if (lstSpecialSetting != null)
{
object obj = new
{
IsEnableSpecialItems = lstSpecialSetting.IsEnableSpecialItems,
NoOfItemShown = lstSpecialSetting.NoOfItemShown,
NoOfItemInRow = lstSpecialSetting.NoOfItemInRow,
IsEnableSpecialItemsRss = lstSpecialSetting.IsEnableSpecialItemsRss,
SpecialItemsRssCount = lstSpecialSetting.SpecialItemsRssCount,
SpecialItemsRssPageName = lstSpecialSetting.SpecialItemsRssPageName,
SpecialItemsDetailPageName = lstSpecialSetting.SpecialItemsDetailPageName,
SpecialItemModulePath = SpecialItemModulePath
};
Settings = json_serializer.Serialize(obj);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string UserName = string.Empty;
GetPortalCommonInfo(out StoreID, out PortalID, out UserName, out CultureName);
AspxCommonInfo aspxCommonObj = new AspxCommonInfo(StoreID, PortalID, UserName, CultureName);
if (!IsPostBack)
{
StoreSettingConfig ssc = new StoreSettingConfig();
MainCurrency = ssc.GetStoreSettingsByKey(StoreSetting.MainCurrency, StoreID, PortalID, CultureName);
if (Session["CurrencyCode"] != null && Session["CurrencyCode"].ToString() != "")
{
SelectedCurrency = Session["CurrencyCode"].ToString();
}
else
{
SelectedCurrency = MainCurrency;
}
IncludeJs("Currencyconversion", "/js/FancyDropDown/fancyDropDown.js");//
IncludeCss("Currencyconversion", "/Templates/" + TemplateName + "/css/FancyDropDown/fancy.css", "/Modules/AspxCommerce/AspxCurrencyConverter/css/module.css");
}
IncludeLanguageJS();
BindCurrencyList(aspxCommonObj);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void GetRssFeedContens(AspxCommonInfo aspxCommonObj, string pageURL, int count)
{
try
{
string[] path = pageURL.Split('?');
string pagepath = path[0];
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ContentType = "text/xml";
XmlTextWriter rssXml = new XmlTextWriter(HttpContext.Current.Response.OutputStream, Encoding.UTF8);
rssXml.WriteStartDocument();
rssXml.WriteStartElement("rss");
rssXml.WriteAttributeString("version", "2.0");
rssXml.WriteStartElement("channel");
rssXml.WriteElementString("link", pagepath);
rssXml.WriteElementString("title", getLocale("AspxCommerce Services"));
GetItemRssFeedContents(aspxCommonObj, rssXml, pageURL,count);
rssXml.WriteEndElement();
rssXml.WriteEndElement();
rssXml.WriteEndDocument();
rssXml.Flush();
rssXml.Close();
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int StoreID, PortalID;
string UserName, CultureName;
GetPortalCommonInfo(out StoreID, out PortalID, out UserName, out CultureName);
AspxCommonInfo aspxCommonObj = new AspxCommonInfo(StoreID, PortalID, UserName, CultureName);
if (!IsPostBack)
{
string templateName = TemplateName;
IncludeJs("MegaCategoryView", "/js/jquery.cookie.js", "/Modules/AspxCommerce/AspxMegaCategory/js/hoverIntent.js",
"/Modules/AspxCommerce/AspxMegaCategory/js/jquery.dcverticalmegamenu.1.3.js",
"/Modules/AspxCommerce/AspxMegaCategory/js/jquery.dcmegamenu.1.3.3.js",
"/Modules/AspxCommerce/AspxMegaCategory/js/jquery.dcjqaccordion.2.7.js");
IncludeCss("MegaCategoryView", "/Templates/" + templateName + "/css/MegaMenu/dcverticalmegamenu.css",
"/Templates/" + templateName + "/css/MegaMenu/dcmegamenu.css", "/Modules/AspxCommerce/AspxMegaCategory/css/module.css");
StoreSettingConfig ssc = new StoreSettingConfig();
ssc.GetStoreSettingParamTwo(StoreSetting.DefaultProductImageURL, StoreSetting.NewCategoryRss, out NoImageCategoryDetailPath,
out CategoryRss, StoreID, PortalID, CultureName);
if (CategoryRss.ToLower() == "true")
{
RssFeedUrl = ssc.GetStoreSettingsByKey(StoreSetting.RssFeedURL, StoreID, PortalID, CultureName);
}
}
GetMegaCategorySetting(aspxCommonObj);
GetCategoryMenuList(aspxCommonObj);
IncludeLanguageJS();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public static List<PricingRuleAttributeInfo> GetPricingRuleAttributes(AspxCommonInfo aspxCommonObj)
{
SQLHandler sqlHandler = new SQLHandler();
List<KeyValuePair<string, object>> paramList = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
List<PricingRuleAttributeInfo> lstPriceRuleAttr = sqlHandler.ExecuteAsList<PricingRuleAttributeInfo>("usp_Aspx_GetPricingRuleAttr", paramList);
return lstPriceRuleAttr;
}
private void BindItemImageGallery(AspxCommonInfo aspxCommonObj)
{
SageFrameRoute parentPage = (SageFrameRoute)this.Page;
string itemSKU = parentPage.Key;
string costCombination = string.Empty;
AspxCoreController obj = new AspxCoreController();
ItemCommonInfo objItemInfo = obj.GetItemInfoFromSKU(itemSKU, aspxCommonObj);
if (objItemInfo != null)
{
ItemID = objItemInfo.ItemID;
ItemTypeID = objItemInfo.ItemTypeID;
}
if (ItemTypeID == 3)
{
List<GiftCardInfo> lstItemGallery = obj.GetGiftCardThemeImagesByItem(ItemID, aspxCommonObj);
BindGiftGallery(lstItemGallery,aspxCommonObj);
}
else
{
List<VariantCombination> lstItemCombination = obj.GetCostVariantCombinationbyItemSku(itemSKU, aspxCommonObj);
if (lstItemCombination != null && lstItemCombination.Count > 0)
{
costCombination = lstItemCombination[0].CombinationID.ToString();
}
else
{
costCombination = "0";
}
List<ItemsInfoSettings> lstItemGallery = obj.GetItemsImageGalleryInfoBySKU(itemSKU, aspxCommonObj, costCombination);
BindGallery(lstItemGallery, aspxCommonObj);
}
}
public static void NotificationSaveUpdateSettings(NotificationSettingsInfo saveUpdateInfo, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@AllActive", saveUpdateInfo.AllActive));
parameterCollection.Add(new KeyValuePair<string, object>("@UserNotificationActive", saveUpdateInfo.UserNotificationActive));
parameterCollection.Add(new KeyValuePair<string, object>("@UserNotificationCount", saveUpdateInfo.UserNotificationCount));
parameterCollection.Add(new KeyValuePair<string, object>("@SubscriptionNotificationActive ", saveUpdateInfo.SubscriptionNotificationActive));
parameterCollection.Add(new KeyValuePair<string, object>("@SubscriptionNotificationCount", saveUpdateInfo.SubscriptionNotificationCount));
parameterCollection.Add(new KeyValuePair<string, object>("@OutofStockNotificationActive", saveUpdateInfo.OutofStockNotificationActive));
parameterCollection.Add(new KeyValuePair<string, object>("@OutofStockNotificationCount", saveUpdateInfo.OutofStockNotificationCount));
parameterCollection.Add(new KeyValuePair<string, object>("@ItemsLowStockNotificationActive", saveUpdateInfo.ItemsLowStockNotificationActive));
parameterCollection.Add(new KeyValuePair<string, object>("@ItemsLowStockCount", saveUpdateInfo.ItemsLowStockCount));
parameterCollection.Add(new KeyValuePair<string, object>("@OrdersNotificationAtive", saveUpdateInfo.OrdersNotificationAtive));
parameterCollection.Add(new KeyValuePair<string, object>("@OrdersNotificationCount", saveUpdateInfo.OrdersNotificationCount));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_NotificationSaveUpdateSettings]", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// To Get Parameter Having @StoreID,@PortalID
/// </summary>
/// <param name="aspxCommonObj"></param>
/// <returns></returns>
public static List<KeyValuePair<string, object>> GetParamSP(AspxCommonInfo aspxCommonObj)
{
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));
return ParaMeter;
}
public static int SaveCatalogPricingRule(CatalogPricingRuleInfo objCatalogPricingRuleInfo, AspxCommonInfo aspxCommonObj, List<int> parentID)
{
int catalogPriceRuleID = -1;
catalogPriceRuleID = AspxCatalogPriceRuleProvider.CatalogPriceRuleAdd(objCatalogPricingRuleInfo.CatalogPriceRule, aspxCommonObj);
if (catalogPriceRuleID > 0)
{
int count = 0;
int cpID = 0;
int catalogConditionID = 0;
List<int> lstParent = parentID;//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 = AspxCatalogPriceRuleProvider.CatalogPriceRuleConditionAdd(catalogPriceRuleCondition, aspxCommonObj);
count++;
}
int catalogPriceRuleRoleID = -1;
foreach (CatalogPriceRuleRole catalogPriceRuleRole in objCatalogPricingRuleInfo.CatalogPriceRuleRoles)
{
catalogPriceRuleRole.CatalogPriceRuleID = catalogPriceRuleID;
catalogPriceRuleRoleID = AspxCatalogPriceRuleProvider.CatalogPriceRuleRoleAdd(catalogPriceRuleRole, aspxCommonObj);
}
}
return 1;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
base.GetPortalCommonInfo(out storeID, out portalID, out customerID, out userName, out cultureName, out sessionCode);
aspxCommonObj = new AspxCommonInfo(storeID, portalID, userName, cultureName, customerID, sessionCode);
StoreSettingConfig ssc = new StoreSettingConfig();
ssc.GetStoreSettingParamTwo(StoreSetting.ShoppingCartURL,
StoreSetting.ShowAddToCartButton,
out ShoppingCartURL,
out AllowAddToCart,
storeID,
portalID,
cultureName
);
GetUserRecentActivity(aspxCommonObj);
GetAddressBookDetails(aspxCommonObj);
GetAllCountry();
// IncludeJs("AccountUserDashboard", "/Modules/AspxCommerce/AspxUserDashBoard/js/userdashboard.js");
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public static bool UpdateStoreLocation(AspxCommonInfo aspxCommonObj, string storeName, String storeDescription, string streetName, string localityName, string city, string state, string country, string zip, double latitude, double longitude)
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@StoreName", storeName));
parameterCollection.Add(new KeyValuePair<string, object>("@StoreDescription", storeDescription));
parameterCollection.Add(new KeyValuePair<string, object>("@StreetName", streetName));
parameterCollection.Add(new KeyValuePair<string, object>("@LocalityName", localityName));
parameterCollection.Add(new KeyValuePair<string, object>("@City", city));
parameterCollection.Add(new KeyValuePair<string, object>("@State", state));
parameterCollection.Add(new KeyValuePair<string, object>("@Country", country));
parameterCollection.Add(new KeyValuePair<string, object>("@ZIP", zip));
parameterCollection.Add(new KeyValuePair<string, object>("@Latitude", latitude));
parameterCollection.Add(new KeyValuePair<string, object>("@Longitude", longitude));
try
{
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_StoreLocatorLocationUpdate", parameterCollection);
return true;
}
catch (Exception e)
{
return false;
throw e;
}
}
public void AddUpdateUserAddress(AddressInfo addressObj,AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@AddressID", addressObj.AddressID));
parameter.Add(new KeyValuePair<string, object>("@CustomerID", aspxCommonObj.CustomerID));
parameter.Add(new KeyValuePair<string, object>("@FirstName", addressObj.FirstName));
parameter.Add(new KeyValuePair<string, object>("@LastName", addressObj.LastName));
parameter.Add(new KeyValuePair<string, object>("@Email", addressObj.Email));
parameter.Add(new KeyValuePair<string, object>("@Company", addressObj.Company));
parameter.Add(new KeyValuePair<string, object>("@Address1", addressObj.Address1));
parameter.Add(new KeyValuePair<string,object>("@Address2",addressObj.Address2));
parameter.Add(new KeyValuePair<string, object>("@City", addressObj.City));
parameter.Add(new KeyValuePair<string, object>("@State", addressObj.State));
parameter.Add(new KeyValuePair<string, object>("@Zip", addressObj.Zip));
parameter.Add(new KeyValuePair<string, object>("@Phone", addressObj.Phone));
parameter.Add(new KeyValuePair<string, object>("@Mobile", addressObj.Mobile));
parameter.Add(new KeyValuePair<string, object>("@Fax", addressObj.Fax));
parameter.Add(new KeyValuePair<string, object>("@WebSite", addressObj.Website));
parameter.Add(new KeyValuePair<string, object>("@Country", addressObj.Country));
parameter.Add(new KeyValuePair<string, object>("@IsDefaultShipping", addressObj.DefaultShipping));
parameter.Add(new KeyValuePair<string, object>("@IsDefaultBilling", addressObj.DefaultBilling));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateUserAddress", parameter);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
SageFrameConfig pagebase = new SageFrameConfig();
GetPortalCommonInfo(out StoreID, out PortalID, out CustomerID, out UserName, out CultureName);
if (!IsPostBack)
{
IncludeCss("ShoppingBagHeader", "/Templates/" + TemplateName + "/css/PopUp/style.css",
"/Templates/" + TemplateName + "/css/MessageBox/style.css",
"/Modules/AspxCommerce/AspxShoppingBagHeader/css/module.css");
IncludeJs("ShoppingBagHeader", "/js/PopUp/custom.js", "/js/MessageBox/jquery.easing.1.3.js",
"/js/MessageBox/alertbox.js",
"/Modules/AspxCommerce/AspxShoppingBagHeader/js/ShoppingBag.js", "/js/Session.js");
UserModuleID = SageUserModuleID;
if (HttpContext.Current.Session.SessionID != null)
{
SessionCode = HttpContext.Current.Session.SessionID.ToString();
}
StoreSettingConfig ssc = new StoreSettingConfig();
ssc.GetStoreSettingParamEight(StoreSetting.ShowMiniShoppingCart, StoreSetting.ShowAddToCartButton,
StoreSetting.AllowMultipleShippingAddress, StoreSetting.MinimumCartSubTotalAmount, StoreSetting.AllowAnonymousCheckOut,
StoreSetting.ShoppingCartURL,StoreSetting.SingleCheckOutURL, StoreSetting.AllowRealTimeNotifications,
out ShowMiniShopCart, out AllowAddToCart, out AllowMultipleAddChkOut, out MinCartSubTotalAmount, out AllowAnonymousCheckOut,
out ShoppingCartURL, out SingleAddressChkOutURL, out AllowRealTimeNotifications, StoreID, PortalID, CultureName);
AspxCommonInfo aspxCommonObj = new AspxCommonInfo(StoreID, PortalID,CultureName);
BagType = AspxShoppingBagController.GetShoppingBagSetting(aspxCommonObj);
}
IncludeLanguageJS();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void GetMegaCategorySetting()
{
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
aspxCommonObj.CultureName = GetCurrentCultureName;
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
MegaCategoryController objCat = new MegaCategoryController();
MegaCategorySettingInfo megaCatSetting = objCat.GetMegaCategorySetting(aspxCommonObj);
if (megaCatSetting != null)
{
object obj = new {
ModeOfView = megaCatSetting.ModeOfView,
NoOfColumn = megaCatSetting.NoOfColumn,
ShowCatImage = megaCatSetting.ShowCategoryImage,
ShowSubCatImage = megaCatSetting.ShowSubCategoryImage,
Speed = megaCatSetting.Speed,
Effect = megaCatSetting.Effect,
EventMega = megaCatSetting.EventMega,
Direction = megaCatSetting.Direction,
MegaModulePath = MegaModulePath
};
Settings = json_serializer.Serialize(obj);
}
}
public void GetServiceItemSetting()
{
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = StoreID;
aspxCommonObj.PortalID = PortalID;
aspxCommonObj.CultureName = CultureName;
ServiceItemController objService = new ServiceItemController();
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
List<ServiceItemSettingInfo> lstServiceSetting = objService.GetServiceItemSetting(aspxCommonObj);
if (lstServiceSetting != null && lstServiceSetting.Count > 0)
{
foreach (var serviceSetting in lstServiceSetting)
{
object obj = new
{
IsEnableService = serviceSetting.IsEnableService,
ServiceCategoryInARow = serviceSetting.ServiceCategoryInARow,
ServiceCategoryCount = serviceSetting.ServiceCategoryCount,
IsEnableServiceRss = serviceSetting.IsEnableServiceRss,
ServiceRssCount = serviceSetting.ServiceRssCount,
ServiceRssPage = serviceSetting.ServiceRssPage,
ServiceDetailsPage = serviceSetting.ServiceDetailsPage,
ServiceItemDetailPage = serviceSetting.ServiceItemDetailsPage,
BookAnAppointmentPage = serviceSetting.BookAnAppointmentPage,
AppointmentSuccessPage = serviceSetting.AppointmentSuccessPage
};
Settings = json_serializer.Serialize(obj);
}
}
}
private void GetAllCategoryForSearch(AspxCommonInfo aspxCommonObj, string modulePath, string pageExtension)
{
bool isActive = true;
string prefix = "---";
List<CategoryInfo> lstCategory = AspxSearchController.GetAllCategoryForSearch(prefix, isActive, aspxCommonObj);
if (lstCategory != null && lstCategory.Count > 0)
{
Elements = new StringBuilder();
Elements.Append("<select id=\"sfSimpleSearchCategory\">");
Elements.Append("<option value=\"0\" ><a href=\"#\"><span class=\"value\" category=\"--All Category--\">");
Elements.Append(getLocale("--All Category--"));
Elements.Append("</span></a></option>");
foreach (CategoryInfo item in lstCategory)
{
Elements.Append("<option value=\"");
Elements.Append(item.CategoryID);
Elements.Append("\" isGiftCard=\"");
Elements.Append(item.IsChecked);
Elements.Append("\"><a href=\"#\"><span class=\"value\" category=\"");
Elements.Append(item.LevelCategoryName);
Elements.Append("\">");
Elements.Append(item.LevelCategoryName);
Elements.Append("</span></a></option>");
}
Elements.Append("</select>");
litSSCat.Text = Elements.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpContext.Current.Response.Cache.SetAllowResponseInBrowserHistory(false);
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Cache.SetNoStore();
Response.Cache.SetExpires(DateTime.Now);
Response.Cache.SetValidUntilExpires(true);
GetPortalCommonInfo(out StoreID, out PortalID, out CustomerID, out UserName, out CultureName, out SessionCode);
aspxCommonObj = new AspxCommonInfo(StoreID, PortalID, UserName, CultureName, CustomerID, SessionCode);
UserModuleIDCart = int.Parse(SageUserModuleID);
try
{
CartModulePath = ResolveUrl(this.AppRelativeTemplateSourceDirectory);
SageFrameConfig pagebase = new SageFrameConfig();
string template = TemplateName;
StoreSettingConfig ssc = new StoreSettingConfig();
ssc.GetStoreSettingParamNine(StoreSetting.DefaultProductImageURL,
StoreSetting.AllowMultipleShippingAddress,
StoreSetting.ShowItemImagesInCart,
StoreSetting.MinimumCartSubTotalAmount,
StoreSetting.AllowOutStockPurchase,
StoreSetting.MultiCheckOutURL,
StoreSetting.AllowShippingRateEstimate,
StoreSetting.AllowCouponDiscount,
StoreSetting.AllowRealTimeNotifications,
out NoImageMyCartPath,
out AllowMultipleAddShipping,
out ShowItemImagesOnCart,
out MinCartSubTotalAmount,
out AllowOutStockPurchase,
out MultipleAddressChkOutURL,
out AllowShippingRateEstimate,
out AllowCouponDiscount,
out AllowRealTimeNotifications,
StoreID,
PortalID,
CultureName
);
if (!IsPostBack)
{
IncludeCss("MyCart", "/Templates/" + template + "/css/GridView/tablesort.css",
"/Templates/" + template + "/css/MessageBox/style.css",
"/Templates/", template, "/css/ToolTip/tooltip.css",
"/Modules/AspxCommerce/AspxCart/css/module.css");
IncludeJs("MyCart","/Modules/AspxCommerce/AspxCart/js/MyCart.js", "/js/encoder.js", "/js/MessageBox/alertbox.js", "/js/jquery.easing.1.3.js", "/js/jquery.tipsy.js", "/js/Session.js");
}
DisplayCartItems(template);
IncludeLanguageJS();
CouponInfo();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
DataTable resultsData = new DataTable();
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
aspxCommonObj.CultureName = GetCurrentCultureName;
StoreSettingConfig ssc = new StoreSettingConfig();
string CurrencyCode = ssc.GetStoreSettingsByKey(StoreSetting.MainCurrency, GetStoreID, GetPortalID, CultureName);
string CurrencySymbol = StoreSetting.GetSymbolFromCurrencyCode(CurrencyCode, GetStoreID, GetPortalID);
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@CurrencySymbol", CurrencySymbol));
parameter.Add(new KeyValuePair<string, object>("@GiftCardType", _csvGiftCardHiddenCsv.Value));
string filename = "MyReport_GiftCardItems" + "_" + DateTime.Now.ToString("M_dd_yyyy_H_M_s") + ".xls";
string filePath = HttpContext.Current.Server.MapPath(ResolveUrl(this.AppRelativeTemplateSourceDirectory)) + filename;
ExportLargeData excelLdata = new ExportLargeData();
excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_GetGiftCardReportsForExport]", parameter, resultsData);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public void BindCurrencyList(AspxCommonInfo aspxCommonObj)
{
string aspxRootPath = ResolveUrl("~/");
List<CurrencyInfo> lstCurrency = AspxCurrencyController.BindCurrencyList(aspxCommonObj);
if (lstCurrency != null && lstCurrency.Count > 0)
{
StringBuilder options = new StringBuilder();
options.Append("<select id=\"ddlCurrency\" class=\"makeMeFancy\">");
foreach (CurrencyInfo item in lstCurrency)
{
if (item.CurrencyCode == SelectedCurrency)
{
options.Append("<option selected=\"selected\" data-icon=\"");
options.Append(aspxRootPath);
options.Append("images/flags/");
options.Append(item.BaseImage);
options.Append("\" data-html-text=\"");
options.Append(item.CurrencySymbol);
options.Append("-");
options.Append(item.CurrencyCode);
options.Append("\" region=");
options.Append(item.Region);
options.Append(" value=\"");
options.Append(item.CurrencyCode);
options.Append("\" >");
options.Append(item.CurrencySymbol);
options.Append("-");
options.Append(item.CurrencyCode);
options.Append("</option>");
}
else
{
options.Append("<option data-icon=\"");
options.Append(aspxRootPath);
options.Append("images/flags/");
options.Append(item.BaseImage);
options.Append("\" data-html-text=\"");
options.Append(item.CurrencySymbol);
options.Append("-");
options.Append(item.CurrencyCode);
options.Append("\" region=");
options.Append(item.Region);
options.Append(" value=\"");
options.Append(item.CurrencyCode);
options.Append("\" >");
options.Append(item.CurrencySymbol);
options.Append("-");
options.Append(item.CurrencyCode);
options.Append("</option>");
}
}
options.Append("</select>");
litCurrency.Text = options.ToString();
}
}
public static void ImageBuilder(string imageFile, ImageType type, bool IsInTempFolder,AspxCommonInfo aspxCommonObj)
{
try
{
bool disposeSource = true;
bool addFileExtensions = true;
string tempFolder = string.Empty;
string filename = imageFile;
bool isExistImage = false;
var resizeSetings = new ResizeSettings();
resizeSetings.Format = "jpg";
resizeSetings.Mode = FitMode.Max;
switch (type)
{
case ImageType.Large:
{
isExistImage = CheckIfImageExists(ImageType.Large, filename);
if (!(isExistImage))
{
ImageSettings imgStng=new ImageSettings(aspxCommonObj);
resizeSetings.MaxWidth = imgStng.itemLargeThumbNailWidth;
resizeSetings.MaxHeight = imgStng.itemLargeThumbNailHeight;
copyOriginalImageToRespectives(ImageType.Large, filename, resizeSetings,disposeSource, addFileExtensions);
}
break;
}
case ImageType.Medium:
{
isExistImage = CheckIfImageExists(ImageType.Medium, filename);
if (!(isExistImage))
{
ImageSettings imgStng = new ImageSettings(aspxCommonObj);
resizeSetings.MaxWidth = imgStng.itemMediumThumbNailWidth;
resizeSetings.MaxHeight = imgStng.itemMediumThumbNailHeight;
copyOriginalImageToRespectives(ImageType.Medium, filename, resizeSetings, disposeSource, addFileExtensions);
}
break;
}
case ImageType.Small:
{
isExistImage = CheckIfImageExists(ImageType.Medium, filename);
if (!(isExistImage))
{
ImageSettings imgStng = new ImageSettings(aspxCommonObj);
resizeSetings.MaxWidth = imgStng.itemSmallThumbNailWidth;
resizeSetings.MaxHeight = imgStng.itemSmallThumbNailHeight;
copyOriginalImageToRespectives(ImageType.Medium, filename, resizeSetings, disposeSource, addFileExtensions);
}
break;
}
}
}
catch
{
}
}
public static List <ItemReviewDetailsInfo> GetItemRatingByReviewID(int itemReviewID, AspxCommonInfo aspxCommonObj)
{
try
{
OracleHandler sqlH = new OracleHandler();
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemReviewID", itemReviewID));
List <ItemReviewDetailsInfo> lstItemRVDetail = sqlH.ExecuteAsList <ItemReviewDetailsInfo>("usp_Aspx_GetItemReviewDetails", parameter);
return(lstItemRVDetail);
}
catch (Exception e)
{
throw e;
}
}
public List <ShippingMethodInfo> GetShippingMethods(int offset, int limit, ShippingMethodInfoByProvider shippingMethodObj, AspxCommonInfo aspxCommonObj)
{
List <ShippingMethodInfo> shipping;
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair <string, object>("@ShippingMethodName", shippingMethodObj.ShippingMethodName));
parameterCollection.Add(new KeyValuePair <string, object>("@DeliveryTime", shippingMethodObj.DeliveryTime));
parameterCollection.Add(new KeyValuePair <string, object>("@WeightLimitFrom", shippingMethodObj.WeightLimitFrom));
parameterCollection.Add(new KeyValuePair <string, object>("@WeightLimitTo", shippingMethodObj.WeightLimitTo));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", shippingMethodObj.IsActive));
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));
shipping = sqlH.ExecuteAsList <ShippingMethodInfo>("usp_Aspx_BindShippingMethodInGrid", parameterCollection);
return(shipping);
}
public void SaveAndUpdateShippings(int shippingMethodID, string shippingMethodName, string imagePath, string alternateText, int displayOrder, string deliveryTime,
decimal weightLimitFrom, decimal weightLimitTo, int shippingProviderID, bool isActive, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@ShippingMethodID", shippingMethodID));
parameter.Add(new KeyValuePair <string, object>("@ShippingMethodName", shippingMethodName));
parameter.Add(new KeyValuePair <string, object>("@ImagePath", imagePath));
parameter.Add(new KeyValuePair <string, object>("@AlternateText", alternateText));
parameter.Add(new KeyValuePair <string, object>("@DisplayOrder", displayOrder));
parameter.Add(new KeyValuePair <string, object>("@DeliveryTime", deliveryTime));
parameter.Add(new KeyValuePair <string, object>("@WeightLimitFrom", weightLimitFrom));
parameter.Add(new KeyValuePair <string, object>("@WeightLimitTo", weightLimitTo));
parameter.Add(new KeyValuePair <string, object>("@ShippingProviderID", shippingProviderID));
parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("@IsActive", isActive));
parameter.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateShippingMethods", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
//--------------------------get customer class----------------
public static List <TaxManageRulesInfo> GetTaxRules(int offset, int limit, TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("RuleName", taxRuleDataObj.TaxManageRuleName));
parameter.Add(new KeyValuePair <string, object>("RoleName", taxRuleDataObj.RoleName));
parameter.Add(new KeyValuePair <string, object>("ItemClassName", taxRuleDataObj.TaxItemClassName));
parameter.Add(new KeyValuePair <string, object>("RateTitle", taxRuleDataObj.TaxRateTitle));
parameter.Add(new KeyValuePair <string, object>("SearchPriority", taxRuleDataObj.Priority));
parameter.Add(new KeyValuePair <string, object>("SearchDisplayOrder", taxRuleDataObj.DisplayOrder));
OracleHandler sqlh = new OracleHandler();
List <TaxManageRulesInfo> lstTaxManage = sqlh.ExecuteAsList <TaxManageRulesInfo>("usp_Aspx_GetTaxManageRules", parameter);
return(lstTaxManage);
}
catch (Exception e)
{
throw e;
}
}
//-------------------save item tax class--------------------
public static void SaveAndUpdateTaxItemClass(int taxItemClassID, string taxItemClassName, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("TaxItemClassID", taxItemClassID));
parameter.Add(new KeyValuePair <string, object>("TaxItemClassName", taxItemClassName));
OracleHandler sqlh = new OracleHandler();
sqlh.ExecuteNonQuery("usp_Aspx_SaveAndUpdateTaxItemClass", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static List <RatingLatestInfo> GetRecentItemReviewsAndRatings(int offset, int limit, AspxCommonInfo aspxCommonObj)
{
try
{
OracleHandler sqlH = new OracleHandler();
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
List <RatingLatestInfo> lstRatingNew = sqlH.ExecuteAsList <RatingLatestInfo>("usp_Aspx_GetRecentReviewsAndRatings", parameter);
return(lstRatingNew);
}
catch (Exception e)
{
throw e;
}
}
public static int AddItemstoCart(int itemID, decimal itemPrice, int itemQuantity, bool isItemPage, AspxCommonInfo aspxCommonObj)
{
try
{
var cartobj = new CartManageSQLProvider();
StoreSettingConfig ssc = new StoreSettingConfig();
if (cartobj.CheckItemCart(itemID, aspxCommonObj.StoreID, aspxCommonObj.PortalID, "0@"))
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamNoCID(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("Price", itemPrice));
parameter.Add(new KeyValuePair <string, object>("Quantity", itemQuantity));
OracleHandler sqlH = new OracleHandler();
int i;
if (isItemPage)
{
i = sqlH.ExecuteNonQueryAsGivenType <int>("usp_Aspx_CheckCostVariantForItemDetail", parameter, "IsExist");
}
else
{
// i = sqlH.ExecuteNonQueryAsGivenType<int>("usp_Aspx_CheckCostVariantForItem", parameter, "IsExist");
i = sqlH.ExecuteNonQueryAsGivenType <int>("usp_Aspx_CheckCostVariantForIt", parameter, "IsExist");
}
return(i);
}
else
{
if (bool.Parse(ssc.GetStoreSettingsByKey(StoreSetting.AllowOutStockPurchase, aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName)))
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamNoCID(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("Price", itemPrice));
parameter.Add(new KeyValuePair <string, object>("Quantity", itemQuantity));
parameter.Add(new KeyValuePair <string, object>("isItemPage", isItemPage));
OracleHandler sqlH = new OracleHandler();
int i;
if (isItemPage)
{
i = sqlH.ExecuteNonQueryAsGivenType <int>("usp_Aspx_CheckCostVariantForItemDetail", parameter, "IsExist");
}
else
{
i = sqlH.ExecuteNonQueryAsGivenType <int>("usp_Aspx_CheckCostVariantForIt", parameter, "IsExist");
}
//i = sqlH.ExecuteNonQueryAsGivenType<int>("usp_Aspx_CheckCostVariantForItem", parameter, "IsExist");
return(i);
}
else
{
return(2);
}
}
}
catch (Exception e)
{
throw e;
}
}
public static bool CheckItemOutOfStock(int itemID, string costVariantsValueIDs, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("CostVariantsValueIDs", costVariantsValueIDs));
OracleHandler sqlH = new OracleHandler();
string i = sqlH.ExecuteNonQueryAsGivenType <string>("usp_Aspx_CheckItemOutOfStock", parameter, "IsOutOfStock");
return(Convert.ToBoolean(i));
}
catch (Exception ex)
{
throw ex;
}
}
public static void ReturnSaveUpdate(ReturnSaveUpdateInfo ReturnSaveUpdateObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetFParamNoU(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@OrderID", ReturnSaveUpdateObj.OrderID));
parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", ReturnSaveUpdateObj.ItemID));
parameterCollection.Add(new KeyValuePair <string, object>("@ItemName", ReturnSaveUpdateObj.ItemName));
parameterCollection.Add(new KeyValuePair <string, object>("@CostVariantValueIDs", ReturnSaveUpdateObj.CostVariantIDs));
parameterCollection.Add(new KeyValuePair <string, object>("@CostVariant", ReturnSaveUpdateObj.CostVariants));
parameterCollection.Add(new KeyValuePair <string, object>("@Quantity", ReturnSaveUpdateObj.Quantity));
parameterCollection.Add(new KeyValuePair <string, object>("@ReturnProductStatusID", ReturnSaveUpdateObj.ProductStatusID));
parameterCollection.Add(new KeyValuePair <string, object>("@ReturnReasonID", ReturnSaveUpdateObj.ReturnReasonID));
parameterCollection.Add(new KeyValuePair <string, object>("@OtherDetails", ReturnSaveUpdateObj.OtherDetails));
parameterCollection.Add(new KeyValuePair <string, object>("@ReturnShippingAddressID", ReturnSaveUpdateObj.ReturnShippingAddressID));
parameterCollection.Add(new KeyValuePair <string, object>("@AddedBy", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_ReturnSaveUpdate", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
public static List <MyOrderListForReturnInfo> GetMyOrderListForReturn(int orderID, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPCtC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@OrderID", orderID));
SQLHandler sqlH = new SQLHandler();
List <MyOrderListForReturnInfo> lstMyOrder = sqlH.ExecuteAsList <MyOrderListForReturnInfo>("usp_Aspx_GetMyOrdersForReturn", parameter);
return(lstMyOrder);
}
catch (Exception e)
{
throw e;
}
}
public static List <ShareWishListItemInfo> GetShareWishListItemByID(int sharedWishID, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@SharedWishID", sharedWishID));
SQLHandler sqlH = new SQLHandler();
List <ShareWishListItemInfo> lstShareWishItem = sqlH.ExecuteAsList <ShareWishListItemInfo>("[dbo].[usp_Aspx_GetShareWishListByID]", parameter);
return(lstShareWishItem);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateUserProductReview(ItemReviewBasicInfo productReviewObj, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemID", productReviewObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("@ItemReviewID", productReviewObj.ItemReviewID));
parameter.Add(new KeyValuePair <string, object>("@RatingIDs", productReviewObj.RatingIDs));
parameter.Add(new KeyValuePair <string, object>("@RatingValues", productReviewObj.RatingValues));
parameter.Add(new KeyValuePair <string, object>("@ReviewSummary", productReviewObj.ReviewSummary));
parameter.Add(new KeyValuePair <string, object>("@Review", productReviewObj.Review));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_GetUserProductReviewUpdate", parameter);
}
//--------------------bind ShareWishList Email in Grid--------------------------
public static List <ShareWishListItemInfo> GetAllShareWishListItemMail(int offset, int limit, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
SQLHandler sqlH = new SQLHandler();
List <ShareWishListItemInfo> lstShareWishItem = sqlH.ExecuteAsList <ShareWishListItemInfo>("[dbo].[usp_Aspx_GetShareWishListMailDetailGrid]", parameter);
return(lstShareWishItem);
}
catch (Exception e)
{
throw e;
}
}
//---------------User Item Reviews and Ratings-----------------------
public static List <UserRatingInformationInfo> GetUserReviewsAndRatings(int offset, int limit, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
SQLHandler sqlH = new SQLHandler();
List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetUserItemReviews", parameter);
return(bind);
}
catch (Exception e)
{
throw e;
}
}
public static int AddItemstoCartFromDetail(AddItemToCartInfo AddItemToCartObj, AspxCommonInfo aspxCommonObj, GiftCard giftCardDetail, CartKit kitInfo)
{
try
{
StoreSettingConfig ssc = new StoreSettingConfig();
if (AspxCartController.CheckItemCart(AddItemToCartObj.ItemID, aspxCommonObj.StoreID, aspxCommonObj.PortalID, AddItemToCartObj.CostVariantIDs))
{
decimal cartItemId = 0;
if (AddItemToCartObj.IsKitItem)
{
//if kit type
//logic
// serialize
// kitInfo.Data into string and save it db and also description
//++price and weight will be from kit info it contains total configured price and weight
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
string kitconfigureddata = json_serializer.Serialize(kitInfo.Data);
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", AddItemToCartObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("Price", kitInfo.Price));
parameter.Add(new KeyValuePair <string, object>("Weight", kitInfo.Weight));
parameter.Add(new KeyValuePair <string, object>("Quantity", AddItemToCartObj.Quantity));
parameter.Add(new KeyValuePair <string, object>("CostVariantsValueIDs", AddItemToCartObj.CostVariantIDs));
parameter.Add(new KeyValuePair <string, object>("KitDescription", kitInfo.Description));
parameter.Add(new KeyValuePair <string, object>("KitData", kitconfigureddata));
OracleHandler sqlH = new OracleHandler();
//cartItemId = sqlH.ExecuteAsScalar<int>("usp_Aspx_AddToCart", parameter);
cartItemId = sqlH.ExecuteAsScalar <decimal>("usp_Aspx_AddToCart", parameter);
}
else
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", AddItemToCartObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("Price", AddItemToCartObj.Price));
parameter.Add(new KeyValuePair <string, object>("Weight", AddItemToCartObj.Weight));
parameter.Add(new KeyValuePair <string, object>("Quantity", AddItemToCartObj.Quantity));
parameter.Add(new KeyValuePair <string, object>("CostVariantsValueIDs", AddItemToCartObj.CostVariantIDs));
parameter.Add(new KeyValuePair <string, object>("KitDescription", null));
parameter.Add(new KeyValuePair <string, object>("KitData", null));
OracleHandler sqlH = new OracleHandler();
cartItemId = sqlH.ExecuteAsScalar <decimal>("usp_Aspx_AddToCart", parameter);
}
if (AddItemToCartObj.IsGiftCard == true && giftCardDetail != null)
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("CartItemId", cartItemId));
param.Add(new KeyValuePair <string, object>("ItemId", AddItemToCartObj.ItemID));
param.Add(new KeyValuePair <string, object>("GiftCardTypeId", giftCardDetail.GiftCardTypeId));
param.Add(new KeyValuePair <string, object>("GiftCardGraphicsId", giftCardDetail.GraphicThemeId));
param.Add(new KeyValuePair <string, object>("Amount", giftCardDetail.Price));
param.Add(new KeyValuePair <string, object>("GiftCardCode", giftCardDetail.GiftCardCode));
param.Add(new KeyValuePair <string, object>("RecipientName", giftCardDetail.RecipientName));
param.Add(new KeyValuePair <string, object>("RecipientEmail", giftCardDetail.RecipientEmail));
param.Add(new KeyValuePair <string, object>("SenderName", giftCardDetail.SenderName));
param.Add(new KeyValuePair <string, object>("SenderEmail", giftCardDetail.SenderEmail));
param.Add(new KeyValuePair <string, object>("Messege", giftCardDetail.Messege));
param.Add(new KeyValuePair <string, object>("StoreId", aspxCommonObj.StoreID));
param.Add(new KeyValuePair <string, object>("PortalId", aspxCommonObj.PortalID));
param.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName));
param.Add(new KeyValuePair <string, object>("UserName", aspxCommonObj.UserName));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddGiftCard", param);
}
return(1);
}
else
{
if (bool.Parse(ssc.GetStoreSettingsByKey(StoreSetting.AllowOutStockPurchase, aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName)))
{
int cartItemId = 0;
if (AddItemToCartObj.IsKitItem)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", AddItemToCartObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("Price", AddItemToCartObj.Price));
parameter.Add(new KeyValuePair <string, object>("Weight", AddItemToCartObj.Weight));
parameter.Add(new KeyValuePair <string, object>("Quantity", AddItemToCartObj.Quantity));
parameter.Add(new KeyValuePair <string, object>("CostVariantsValueIDs", AddItemToCartObj.CostVariantIDs));
parameter.Add(new KeyValuePair <string, object>("KitDescription", null));
parameter.Add(new KeyValuePair <string, object>("KitData", null));
OracleHandler sqlH = new OracleHandler();
cartItemId = sqlH.ExecuteAsScalar <int>("usp_Aspx_AddToCart", parameter);
}
else
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", AddItemToCartObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("Price", AddItemToCartObj.Price));
parameter.Add(new KeyValuePair <string, object>("Weight", AddItemToCartObj.Weight));
parameter.Add(new KeyValuePair <string, object>("Quantity", AddItemToCartObj.Quantity));
parameter.Add(new KeyValuePair <string, object>("CostVariantsValueIDs", AddItemToCartObj.CostVariantIDs));
parameter.Add(new KeyValuePair <string, object>("KitDescription", null));
parameter.Add(new KeyValuePair <string, object>("KitData", null));
OracleHandler sqlH = new OracleHandler();
cartItemId = sqlH.ExecuteAsScalar <int>("usp_Aspx_AddToCart", parameter);
}
if (AddItemToCartObj.IsGiftCard == true && giftCardDetail != null)
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("CartItemId", cartItemId));
param.Add(new KeyValuePair <string, object>("ItemId", AddItemToCartObj.ItemID));
param.Add(new KeyValuePair <string, object>("GiftCardTypeId", giftCardDetail.GiftCardTypeId));
param.Add(new KeyValuePair <string, object>("GiftCardGraphicsId", giftCardDetail.GraphicThemeId));
param.Add(new KeyValuePair <string, object>("Amount", giftCardDetail.Price));
param.Add(new KeyValuePair <string, object>("GiftCardCode", giftCardDetail.GiftCardCode));
param.Add(new KeyValuePair <string, object>("RecipientName", giftCardDetail.RecipientName));
param.Add(new KeyValuePair <string, object>("RecipientEmail", giftCardDetail.RecipientEmail));
param.Add(new KeyValuePair <string, object>("SenderName", giftCardDetail.SenderName));
param.Add(new KeyValuePair <string, object>("SenderEmail", giftCardDetail.SenderEmail));
param.Add(new KeyValuePair <string, object>("Messege", giftCardDetail.Messege));
param.Add(new KeyValuePair <string, object>("StoreId", aspxCommonObj.StoreID));
param.Add(new KeyValuePair <string, object>("PortalId", aspxCommonObj.PortalID));
param.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName));
param.Add(new KeyValuePair <string, object>("UserName", aspxCommonObj.UserName));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddGiftCard", param);
}
return(1);
}
else
{
return(2);
}
}
}
catch (Exception e)
{
throw e;
}
}
public List <ShippingMethodInfoByProvider> GetShippingMethodsByProvider(int offset, int limit, int shippingProviderId, AspxCommonInfo aspxCommonObj)
{
var sqlH = new SQLHandler();
var parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair <string, object>("@ShippingProviderId", shippingProviderId));
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));
var shipping = sqlH.ExecuteAsList <ShippingMethodInfoByProvider>("usp_Aspx_GetShippingMethodbyProvider", parameterCollection);
return(shipping);
}
public static List <SearchTermInfo> GetSearchStatistics(int count, string commandName, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("Count", count));
parameter.Add(new KeyValuePair <string, object>("CommandName", commandName));
OracleHandler sqlH = new OracleHandler();
List <SearchTermInfo> lstSearchTerm = sqlH.ExecuteAsList <SearchTermInfo>("usp_Aspx_GetSearchTermStatistics", parameter);
return(lstSearchTerm);
}
public static void ReturnShippingAddressSaveUpdate(AddressBasicInfo addressObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetFParamNoU(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@OrderID", addressObj.OrderID));
parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", addressObj.ItemID));
parameterCollection.Add(new KeyValuePair <string, object>("@CostVariantValueIDs", addressObj.CostVariantIDs));
parameterCollection.Add(new KeyValuePair <string, object>("@AddressID", addressObj.AddressID));
parameterCollection.Add(new KeyValuePair <string, object>("@FirstName", addressObj.FirstName));
parameterCollection.Add(new KeyValuePair <string, object>("@LastName", addressObj.LastName));
parameterCollection.Add(new KeyValuePair <string, object>("@Company", addressObj.Company));
parameterCollection.Add(new KeyValuePair <string, object>("@Address1", addressObj.Address1));
parameterCollection.Add(new KeyValuePair <string, object>("@Address2", addressObj.Address2));
parameterCollection.Add(new KeyValuePair <string, object>("@City", addressObj.City));
parameterCollection.Add(new KeyValuePair <string, object>("@State", addressObj.State));
parameterCollection.Add(new KeyValuePair <string, object>("@Country", addressObj.Country));
parameterCollection.Add(new KeyValuePair <string, object>("@Zip", addressObj.Zip));
parameterCollection.Add(new KeyValuePair <string, object>("@Email", addressObj.Email));
parameterCollection.Add(new KeyValuePair <string, object>("@Phone", addressObj.Phone));
parameterCollection.Add(new KeyValuePair <string, object>("@Mobile", addressObj.Mobile));
parameterCollection.Add(new KeyValuePair <string, object>("@AddedBy", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_ReturnShippingAddressSaveUpdate", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
//--------------customer tax classes------------------
public static List <TaxCustomerClassInfo> GetTaxCustomerClassDetails(int offset, int limit, string className, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("ClassName", className));
OracleHandler sqlh = new OracleHandler();
List <TaxCustomerClassInfo> lstTaxCtClass = sqlh.ExecuteAsList <TaxCustomerClassInfo>("usp_Aspx_GetTaxCustomerClass", parameter);
return(lstTaxCtClass);
}
catch (Exception e)
{
throw e;
}
}
public static List <MyReturnListInfo> GetMyReturnsList(int offset, int limit, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPCtC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
SQLHandler sqlH = new SQLHandler();
List <MyReturnListInfo> lstMyReturn = sqlH.ExecuteAsList <MyReturnListInfo>("[usp_Aspx_GetMyReturnsList]", parameter);
return(lstMyReturn);
}
catch (Exception e)
{
throw e;
}
}
public static List <StoreTaxesInfo> GetStoreSalesTaxes(int offset, int limit, TaxDateData taxDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("TaxManageRuleName", taxDataObj.taxRuleName));
OracleHandler sqlh = new OracleHandler();
if (taxDataObj.monthly == true)
{
return(sqlh.ExecuteAsList <StoreTaxesInfo>("usp_Aspx_GetTaxRuleForStoreTaxReport", parameter));
}
if (taxDataObj.weekly == true)
{
return(sqlh.ExecuteAsList <StoreTaxesInfo>("usp_Aspx_GetTaxDetailsByCurrentMonth", parameter));
}
if (taxDataObj.hourly == true)
{
return(sqlh.ExecuteAsList <StoreTaxesInfo>("usp_Aspx_GetTaxReportDetailsBy24hours", parameter));
}
else
{
return(new List <StoreTaxesInfo>());
}
}
catch (Exception e)
{
throw e;
}
}
public static List <ReturnItemsInfo> GetMyReturnsDetails(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFParamNoSCode(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ReturnID", returnDetailObj.ReturnID));
parameter.Add(new KeyValuePair <string, object>("@OrderID", returnDetailObj.OrderID));
SQLHandler sqlh = new SQLHandler();
List <ReturnItemsInfo> info = sqlh.ExecuteAsList <ReturnItemsInfo>("usp_Aspx_GetMyReturnsDetails", parameter);
return(info);
}
catch (Exception e)
{
throw e;
}
}
//--------------tax rates------------------
public static List <TaxRateInfo> GetTaxRateDetails(int offset, System.Nullable <int> limit, TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("TaxName", taxRateDataObj.TaxName));
parameter.Add(new KeyValuePair <string, object>("SearchCountry", taxRateDataObj.Country));
parameter.Add(new KeyValuePair <string, object>("SerachState", taxRateDataObj.State));
parameter.Add(new KeyValuePair <string, object>("Zip", taxRateDataObj.Zip));
OracleHandler sqlh = new OracleHandler();
List <TaxRateInfo> lstTaxRate = sqlh.ExecuteAsList <TaxRateInfo>("usp_Aspx_GetTaxRates", parameter);
return(lstTaxRate);
}
catch (Exception e)
{
throw e;
}
}
public static List <ReturnDetailsInfo> GetReturnDetails(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, RetunDetailsBasicInfo returnDetailObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
parameter.Add(new KeyValuePair <string, object>("@ReturnID", returnDetailObj.ReturnID));
parameter.Add(new KeyValuePair <string, object>("@OrderID", returnDetailObj.OrderID));
parameter.Add(new KeyValuePair <string, object>("@UserName", returnDetailObj.CustomerName));
parameter.Add(new KeyValuePair <string, object>("@StatusName", returnDetailObj.ReturnStatus));
parameter.Add(new KeyValuePair <string, object>("@DateAdded", returnDetailObj.DateAdded));
parameter.Add(new KeyValuePair <string, object>("@DateModified", returnDetailObj.DateModified));
SQLHandler sqlH = new SQLHandler();
List <ReturnDetailsInfo> info = sqlH.ExecuteAsList <ReturnDetailsInfo>("usp_Aspx_GetReturnDetails", parameter);
return(info);
}
catch (Exception e)
{
throw e;
}
}
//-------------------------UserDashBoard/User Downloadable Items------------------------------
public static List <DownloadableItemsByCustomerInfo> GetCustomerDownloadableItems(int offset, int limit, string sku, string name, AspxCommonInfo aspxCommonObj, bool isActive)
{
try
{
List <DownloadableItemsByCustomerInfo> ml;
SQLHandler Sq = new SQLHandler();
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair <string, object>("@SKU", sku));
parameterCollection.Add(new KeyValuePair <string, object>("@Name", name));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", isActive));
ml = Sq.ExecuteAsList <DownloadableItemsByCustomerInfo>("dbo.usp_Aspx_GetCustomerDownloadableItems", parameterCollection);
return(ml);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateDownloadCount(int itemID, int orderItemID, string downloadIP, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("@OrderItemID", orderItemID));
parameter.Add(new KeyValuePair <string, object>("@DownloadIP", downloadIP));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_UpdateDownloadCount", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static List <ReturnsShippingInfo> GetMyReturnsShippingMethod(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetFullParam(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ReturnID", returnDetailObj.ReturnID));
parameter.Add(new KeyValuePair <string, object>("@OrderID", returnDetailObj.OrderID));
SQLHandler sqlh = new SQLHandler();
List <ReturnsShippingInfo> info;
info = sqlh.ExecuteAsList <ReturnsShippingInfo>("usp_Aspx_GetShippingMethodByTotalWeightForReturn", parameter);
return(info);
}
catch (Exception e)
{
throw e;
}
}
//---------------------update rating/ review Items From User DashBoard-----------------------
public static void UpdateItemRatingByUser(ItemReviewBasicInfo updateItemRatingObj, AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ReviewSummary", updateItemRatingObj.ReviewSummary));
parameter.Add(new KeyValuePair <string, object>("@Review", updateItemRatingObj.Review));
parameter.Add(new KeyValuePair <string, object>("@ItemReviewID", updateItemRatingObj.ItemReviewID));
parameter.Add(new KeyValuePair <string, object>("@ItemID", updateItemRatingObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("@UserBy", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_UpdateItemRatingByUser", parameter);
}
catch (Exception e)
{
throw e;
}
}
//-----------User DashBoard/Recent History-------------------
public static List <UserRecentCompareInfo> GetUserRecentlyComparedItems(int offset, int limit, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
SQLHandler sqlH = new SQLHandler();
List <UserRecentCompareInfo> lstUserRCompare = sqlH.ExecuteAsList <UserRecentCompareInfo>("usp_Aspx_GetUserRecentlyComparedItems", parameter);
return(lstUserRCompare);
}
catch (Exception e)
{
throw e;
}
}
public static List <RetunReportInfo> GetReturnReport(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, ReturnReportBasicInfo returnReportObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
parameter.Add(new KeyValuePair <string, object>("@ReturnStatus", returnReportObj.ReturnStatus));
SQLHandler sqlh = new SQLHandler();
if (returnReportObj.Monthly == true)
{
return(sqlh.ExecuteAsList <RetunReportInfo>("usp_Aspx_GetReturnReport", parameter));
}
if (returnReportObj.Weekly == true)
{
return(sqlh.ExecuteAsList <RetunReportInfo>("usp_Aspx_GetReturnReportByCurrentMonth", parameter));
}
if (returnReportObj.Hourly == true)
{
return(sqlh.ExecuteAsList <RetunReportInfo>("usp_Aspx_GetReturnReportBy24hours", parameter));
}
else
{
return(new List <RetunReportInfo>());
}
}
catch (Exception e)
{
throw e;
}
}
