示例#1
0
        public static UserModuleInfo GetUserModuleDetails(int UserModuleID, int PortalID)
        {
            UserModuleInfo objUserModule       = new UserModuleInfo();
            string         StoredProcedureName = "usp_UserModulesGetDetails";
            List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >
            {
                new KeyValuePair <string, object>(
                    "UserModuleID", UserModuleID),
                new KeyValuePair <string, object>(
                    "PortalID", PortalID)
            };

            try
            {
                //SQLHandler sagesql = new SQLHandler();
                OracleHandler sagesql = new OracleHandler();
                objUserModule = sagesql.ExecuteAsObject <UserModuleInfo>(StoredProcedureName, ParaMeterCollection);
                objUserModule.LSTUserModulePermission = GetModulePermission(UserModuleID, PortalID);
            }
            catch (Exception e)
            {
                throw e;
            }


            return(objUserModule);
        }
示例#2
0
        public static CartExistInfo CheckCustomerCartExist(AspxCommonInfo aspxCommonObj)
        {
            List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPSCt(aspxCommonObj);
            OracleHandler sqlH         = new OracleHandler();
            CartExistInfo objCartExist = sqlH.ExecuteAsObject <CartExistInfo>("usp_Aspx_CheckCartExists", parameter);

            return(objCartExist);
        }
        /// <summary>
        /// 根据Mo编号获取,LOt和MO信息
        /// </summary>
        /// <param name="MO"></param>
        /// <returns></returns>
        public LotMoEntity GetMoEntityByMoOrder(string MO_ORDER)
        {
            LotMoEntity lotMoEntity = new LotMoEntity();
            string strSql = string.Format(@"SELECT LM.LOT_NUMBER LOT_NO,LM.LINE_NAME,LM.MO MO_ORDER,LM.MO_SEQ MO_NO,TO_CHAR(LM.MO_START_TIME,'YYYY/MM/dd') CREATE_TIME,LM.SHIFT FROM SFISM4.R_WIP_LOT_MO_LOG_T LM WHERE LM.MO=:MO_ORDER");
            DBParameter oracleParamets = new DBParameter();
            oracleParamets.Clear();
            oracleParamets.Add(":MO_ORDER", OracleDbType.Varchar2, MO_ORDER);
            try
            {
                lotMoEntity = dbHander.ExecuteAsObject<LotMoEntity>(strSql, CommandType.Text, oracleParamets.GetParameters());
            }
            catch (Exception ex)
            {

                this.logHandler.Error(MethodBase.GetCurrentMethod().Name, "Call GetMoEntityByMo Fail: " + ex.Message);
            }
            return lotMoEntity;
        }
        private WareHouseAddress GetWareHouseAddress(int storeId, int portalId)
        {
            var sqlHandler = new OracleHandler();
            var paramList  = new List <KeyValuePair <string, object> >();

            paramList.Add(new KeyValuePair <string, object>("StoreID", storeId));
            paramList.Add(new KeyValuePair <string, object>("PortalID", portalId));
            var cl = sqlHandler.ExecuteAsObject <WareHouseAddress>("usp_Aspx_GetActiveWareHouse", paramList);

            return(cl);
        }
示例#5
0
        /// <summary>
        /// To Save Attribute
        /// </summary>
        /// <returns></returns>
        public static AttributeFormInfo SaveAttribute(AttributesGetByAttributeIdInfo attributeToInsert, AttributeConfig config)
        {
            try
            {
                List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
                parameterCollection.Add(new KeyValuePair <string, object>("AttributeID", attributeToInsert.AttributeID));
                parameterCollection.Add(new KeyValuePair <string, object>("AttributeName", attributeToInsert.AttributeName));
                parameterCollection.Add(new KeyValuePair <string, object>("InputTypeID", attributeToInsert.InputTypeID));

                parameterCollection.Add(new KeyValuePair <string, object>("DefaultValue", attributeToInsert.DefaultValue));
                parameterCollection.Add(new KeyValuePair <string, object>("Length", attributeToInsert.Length));
                parameterCollection.Add(new KeyValuePair <string, object>("AliasName", attributeToInsert.AliasName));
                parameterCollection.Add(new KeyValuePair <string, object>("AliasToolTip", attributeToInsert.AliasToolTip));
                parameterCollection.Add(new KeyValuePair <string, object>("AliasHelp", attributeToInsert.AliasHelp));
                parameterCollection.Add(new KeyValuePair <string, object>("DisplayOrder", attributeToInsert.DisplayOrder));

                parameterCollection.Add(new KeyValuePair <string, object>("IsUnique", attributeToInsert.IsUnique));
                parameterCollection.Add(new KeyValuePair <string, object>("IsRequired", attributeToInsert.IsRequired));
                parameterCollection.Add(new KeyValuePair <string, object>("ShowInAdvanceSearch", attributeToInsert.ShowInAdvanceSearch));
                parameterCollection.Add(new KeyValuePair <string, object>("ShowInComparison", attributeToInsert.ShowInComparison));
                parameterCollection.Add(new KeyValuePair <string, object>("IsIncludeInPriceRule", attributeToInsert.IsIncludeInPriceRule));
                parameterCollection.Add(new KeyValuePair <string, object>("IsEnableEditor", attributeToInsert.IsEnableEditor));
                parameterCollection.Add(new KeyValuePair <string, object>("IsShowInItemDetail", attributeToInsert.IsShowInItemDetail));
                parameterCollection.Add(new KeyValuePair <string, object>("IsShowInItemListing", attributeToInsert.IsShowInItemListing));


                parameterCollection.Add(new KeyValuePair <string, object>("IsUseInFilter", attributeToInsert.IsUseInFilter));
                parameterCollection.Add(new KeyValuePair <string, object>("IsActive", attributeToInsert.IsActive));
                parameterCollection.Add(new KeyValuePair <string, object>("IsModified", attributeToInsert.IsModified));
                parameterCollection.Add(new KeyValuePair <string, object>("ValidationTypeID", attributeToInsert.ValidationTypeID));

                parameterCollection.Add(new KeyValuePair <string, object>("StoreID", attributeToInsert.StoreID));
                parameterCollection.Add(new KeyValuePair <string, object>("PortalID", attributeToInsert.PortalID));
                parameterCollection.Add(new KeyValuePair <string, object>("UserName", attributeToInsert.AddedBy));
                parameterCollection.Add(new KeyValuePair <string, object>("CultureName", attributeToInsert.CultureName));

                parameterCollection.Add(new KeyValuePair <string, object>("ItemTypes", attributeToInsert.ItemTypes));
                parameterCollection.Add(new KeyValuePair <string, object>("UpdateFlag", attributeToInsert.Flag));
                parameterCollection.Add(new KeyValuePair <string, object>("IsUsedInConfigItem", attributeToInsert.IsUsedInConfigItem));
                parameterCollection.Add(new KeyValuePair <string, object>("SaveOptions", attributeToInsert.SaveOptions));
                parameterCollection.Add(new KeyValuePair <string, object>("attrValId", attributeToInsert.AttributeValueID));

                //config
                parameterCollection.Add(new KeyValuePair <string, object>("GroupID", config.GroupID));
                parameterCollection.Add(new KeyValuePair <string, object>("AttributeSetID", config.AttributeSetID));
                OracleHandler sqlH = new OracleHandler();
                return(sqlH.ExecuteAsObject <AttributeFormInfo>("usp_Aspx_AttributeAddOnTime", parameterCollection));
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public static ShippingLabelInfo GetShippingLabelInfo(int orderId, AspxCommonInfo commonInfo)
        {
            List <KeyValuePair <string, object> > paraMeter = new List <KeyValuePair <string, object> >();

            paraMeter.Add(new KeyValuePair <string, object>("OrderID", orderId));
            paraMeter.Add(new KeyValuePair <string, object>("PortalId", commonInfo.StoreID));
            paraMeter.Add(new KeyValuePair <string, object>("StoreId", commonInfo.StoreID));
            OracleHandler     sqLh = new OracleHandler();
            ShippingLabelInfo obj  = sqLh.ExecuteAsObject <ShippingLabelInfo>("usp_Aspx_GetShippingLabelInfo", paraMeter);

            return(obj);
        }
示例#7
0
        private static WareHouseAddress GetWareHouseAddress(int storeId, int portalId)
        {
            OracleHandler OracleHandler = new OracleHandler();
            List <KeyValuePair <string, object> > paramList = new List <KeyValuePair <string, object> >();

            paramList.Add(new KeyValuePair <string, object>("StoreID", storeId));
            paramList.Add(new KeyValuePair <string, object>("PortalID", portalId));
            //WareHouseAddress objWareHouse = OracleHandler.ExecuteAsObject<WareHouseAddress>("[usp_Aspx_GetActiveWareHouse]", paramList);
            WareHouseAddress objWareHouse = OracleHandler.ExecuteAsObject <WareHouseAddress>("usp_Aspx_GetActiveWareHouse", paramList);

            return(objWareHouse);
        }
示例#8
0
 public static StoreQuickStaticsInfo GetStoreQuickStatics(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         OracleHandler sqlH = new OracleHandler();
         return(sqlH.ExecuteAsObject <StoreQuickStaticsInfo>("usp_Aspx_GetStoreQuickStatics", parameter));;
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static NotificationGetAllInfo NotificationGetAll(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
         OracleHandler          sqlH     = new OracleHandler();
         NotificationGetAllInfo listInfo = sqlH.ExecuteAsObject <NotificationGetAllInfo>("usp_Aspx_NotificationGetAll", parameterCollection);
         return(listInfo);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
        public CouponVerificationInfo VerifyUserCoupon(decimal totalCost, string couponCode, AspxCommonInfo aspxCommonObj, int appliedCount)
        {
            List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();

            parameter.Add(new KeyValuePair <string, object>("totalCost", totalCost));
            parameter.Add(new KeyValuePair <string, object>("CouponCode", couponCode));
            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>("AppliedCount", appliedCount));
            OracleHandler sqlH = new OracleHandler();

            return(sqlH.ExecuteAsObject <CouponVerificationInfo>("usp_Aspx_VerifyCouponCode", parameter));
        }
 public static SearchSettingInfo GetSearchSetting(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         OracleHandler     sqlHandle        = new OracleHandler();
         SearchSettingInfo objSearchSetting = sqlHandle.ExecuteAsObject <SearchSettingInfo>("usp_Aspx_GetSearchSettings", parameterCollection);
         return(objSearchSetting);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public BrandSettingInfo GetBrandSetting(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         OracleHandler    sqlH = new OracleHandler();
         BrandSettingInfo view =
             sqlH.ExecuteAsObject <BrandSettingInfo>("usp_Aspx_BrandSettingGet", paramCol);
         return(view);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static ItemCommonInfo GetItemInfoFromSKU(string SKU, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
         parameter.Add(new KeyValuePair <string, object>("SKU", SKU));
         OracleHandler  sqlH    = new OracleHandler();
         ItemCommonInfo lstItem = sqlH.ExecuteAsObject <ItemCommonInfo>("usp_Aspx_GetItemInfoFromSKU", parameter);
         return(lstItem);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static StoreSettingInfo GetAllStoreSettings(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         OracleHandler    sqlH = new OracleHandler();
         StoreSettingInfo DefaultStoreSettings;
         DefaultStoreSettings = sqlH.ExecuteAsObject <StoreSettingInfo>("usp_Aspx_GetAllStoreSettings", parameter);
         return(DefaultStoreSettings);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static OrderStatusListInfo GetOrderStatusDetailByOrderStatusID(AspxCommonInfo aspxCommonObj, int OrderStatusID)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         parameter.Add(new KeyValuePair <string, object>("OrderStatusID", OrderStatusID));
         OracleHandler       sqlH         = new OracleHandler();
         OrderStatusListInfo lstOrderStat = sqlH.ExecuteAsObject <OrderStatusListInfo>("usp_Aspx_GetOrderStatusDetailByOrderStatusID", parameter);
         return(lstOrderStat);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public SpecialItemsSettingInfo GetSpecialItemsSetting(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         OracleHandler           sqlH         = new OracleHandler();
         SpecialItemsSettingInfo objHDSetting = new SpecialItemsSettingInfo();
         objHDSetting = sqlH.ExecuteAsObject <SpecialItemsSettingInfo>("usp_Aspx_SpecialItemsSettingsG", parameterCollection);
         return(objHDSetting);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
示例#17
0
 public CompareItemsSettingInfo GetCompareItemsSetting(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         OracleHandler           sqlH = new OracleHandler();
         CompareItemsSettingInfo objItemCompareSetting = new CompareItemsSettingInfo();
         objItemCompareSetting = sqlH.ExecuteAsObject <CompareItemsSettingInfo>("usp_Aspx_CompareItemSettingGet", parameterCollection);
         return(objItemCompareSetting);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
示例#18
0
 public static Vefification VerifyGiftCard(string giftcardCode, string pinCode, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
         parameter.Add(new KeyValuePair <string, object>("@GiftCardCode", giftcardCode));
         parameter.Add(new KeyValuePair <string, object>("@GiftCardPinCode", Encrypt(pinCode)));
         OracleHandler sqlH      = new OracleHandler();
         Vefification  objVerify = sqlH.ExecuteAsObject <Vefification>("usp_Aspx_VerifyGiftCard", parameter);
         return(objVerify);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public UsersInfo GetUserDetails(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         OracleHandler sqlH = new OracleHandler();
         List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
         parameter.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
         parameter.Add(new KeyValuePair <string, object>("UserName", aspxCommonObj.UserName));
         UsersInfo lstStatus = sqlH.ExecuteAsObject <UsersInfo>("usp_Aspx_GetUserDetails", parameter);
         return(lstStatus);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
        public YouMayAlsoLikeSettingInfo GetYouMayAlsoLikeSetting(AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
                OracleHandler             sqlH = new OracleHandler();
                YouMayAlsoLikeSettingInfo view =
                    sqlH.ExecuteAsObject <YouMayAlsoLikeSettingInfo>("USP_ASPX_YOUMAYALSOLIKESETTING", paramCol);
                //sqlH.ExecuteAsObject<YouMayAlsoLikeSettingInfo>("usp_Aspx_YouMayAlsoLikeSettingGet", paramCol);

                return(view);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#21
0
 public static UspsSetting GetSetting(int providerId, AspxCommonInfo commonInfo)
 {
     try
     {
         List <KeyValuePair <string, object> > paraMeter = new List <KeyValuePair <string, object> >();
         paraMeter.Add(new KeyValuePair <string, object>("StoreID", commonInfo.StoreID));
         paraMeter.Add(new KeyValuePair <string, object>("PortalID", commonInfo.PortalID));
         paraMeter.Add(new KeyValuePair <string, object>("ShippingProviderID", providerId));
         var         sqLh    = new OracleHandler();
         UspsSetting setting = sqLh.ExecuteAsObject <UspsSetting>("usp_Aspx_GetUSPSShippingProviderSetting", paraMeter);
         return(setting);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
示例#22
0
 public ItemsCompareInfo GetItemDetailsForCompare(int ItemID, AspxCommonInfo aspxCommonObj, string costVariantValueIDs)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
         parameter.Add(new KeyValuePair <string, object>("ItemID", ItemID));
         parameter.Add(new KeyValuePair <string, object>("CostVariantValueIDs", costVariantValueIDs));
         OracleHandler    sqlH           = new OracleHandler();
         ItemsCompareInfo objItemDetails = sqlH.ExecuteAsObject <ItemsCompareInfo>("usp_Aspx_GetItemDetailsForComp", parameter);
         //ItemsCompareInfo objItemDetails = sqlH.ExecuteAsObject<ItemsCompareInfo>("usp_Aspx_GetItemDetailsForCompare", parameter);
         return(objItemDetails);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        public static MenuManagerInfo GetMenuItemDetails(int MenuItemID)
        {
            List<MenuManagerInfo> lstPages = new List<MenuManagerInfo>();
            string StoredProcedureName = "usp_MenuMgrGetMenuItemDetails";
            List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
            ParaMeterCollection.Add(new KeyValuePair<string, object>("MenuItemID", MenuItemID));

            try
            {
                OracleHandler sagesql = new OracleHandler();
                return (sagesql.ExecuteAsObject<MenuManagerInfo>(StoredProcedureName, ParaMeterCollection));
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public static ModuleMessageInfo GetModuleMessage(int ModuleID, string Culture)
        {
            try
            {
                //SQLHandler SQLH = new SQLHandler();
                OracleHandler SQLH = new OracleHandler();
                List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
                ParamCollInput.Add(new KeyValuePair <string, object>("ModuleID", ModuleID));
                ParamCollInput.Add(new KeyValuePair <string, object>("Culture", Culture));

                return(SQLH.ExecuteAsObject <ModuleMessageInfo>("usp_ModuleMessageGet", ParamCollInput));
            }
            catch (Exception)
            {
                throw;
            }
        }
 public static CustomerGeneralInfo CustomerIDGetByUsername(string userName, int portalID, int storeID)
 {
     try
     {
         List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
         ParaMeterCollection.Add(new KeyValuePair <string, object>("UserName", userName));
         ParaMeterCollection.Add(new KeyValuePair <string, object>("PortalID", portalID));
         ParaMeterCollection.Add(new KeyValuePair <string, object>("StoreID", storeID));
         OracleHandler       sqlH         = new OracleHandler();
         CustomerGeneralInfo sageCustInfo = sqlH.ExecuteAsObject <CustomerGeneralInfo>("usp_Aspx_CustomerIDGetByUserna", ParaMeterCollection);
         return(sageCustInfo);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
示例#26
0
 private static ShippingProvider GetProviderInfo(int providerId, int storeId, int portalId)
 {
     try
     {
         var paraMeter = new List <KeyValuePair <string, object> >
         {
             new KeyValuePair <string, object>("StoreId", storeId),
             new KeyValuePair <string, object>("PortalId", portalId),
             new KeyValuePair <string, object>("ShippingProviderId", providerId)
         };
         var sqLh = new OracleHandler();
         return(sqLh.ExecuteAsObject <ShippingProvider>("usp_Aspx_GetShippingProviderInfo", paraMeter));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        public PopularTagsSettingKeyPair GetPopularTagsSettingValueByKey(AspxCommonInfo aspxCommonObj, string settingKey)
        {
            PopularTagsSettingKeyPair popularTagsSettingKeyPair;

            try
            {
                List <KeyValuePair <string, object> > paramSPC = CommonParmBuilder.GetParamSPC(aspxCommonObj);
                paramSPC.Add(new KeyValuePair <string, object>("@SettingKey", settingKey));
                OracleHandler             sQLHandler = new OracleHandler();
                PopularTagsSettingKeyPair popularTagsSettingKeyPair1 = new PopularTagsSettingKeyPair();
                popularTagsSettingKeyPair = sQLHandler.ExecuteAsObject <PopularTagsSettingKeyPair>("[dbo].[usp_Aspx_PopularTagsSettingValueGetBYKey]", paramSPC);
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(popularTagsSettingKeyPair);
        }
示例#28
0
        public static ImageGalleryInfo GetGallerySettingValues(int userModuleID, AspxCommonInfo aspxCommonObj)
        {
            List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();

            try
            {
                parameterCollection.Add(new KeyValuePair <string, object>("UserModuleID", userModuleID));
                parameterCollection.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
                parameterCollection.Add(new KeyValuePair <string, object>("Culture", aspxCommonObj.CultureName));
                OracleHandler    sagesql    = new OracleHandler();
                ImageGalleryInfo infoObject = sagesql.ExecuteAsObject <ImageGalleryInfo>("usp_Aspx_GetGallerySettings]", parameterCollection);
                return(infoObject);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
示例#29
0
        public static ItemCartInfo CheckItemQuantityInCart(int itemID, AspxCommonInfo aspxCommonObj, string itemCostVariantIDs)
        {
            try
            {
                List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPSCt(aspxCommonObj);
                parameter.Add(new KeyValuePair <string, object>("ItemID", itemID));
                parameter.Add(new KeyValuePair <string, object>("iv_ItemCostVariantIDs", itemCostVariantIDs));
                OracleHandler sqlH        = new OracleHandler();
                ItemCartInfo  itemCartObj = sqlH.ExecuteAsObject <ItemCartInfo>("usp_Aspx_CheckCustomerQuantity", parameter);
                //ItemCartInfo itemCartObj = sqlH.ExecuteAsObject<ItemCartInfo>("usp_Aspx_CheckCustomerQuantityInCart", parameter);

                return(itemCartObj);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public static List <ProviderShippingMethod> GetProviderRemainingMethod(int shippingProviderId, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List <KeyValuePair <string, object> > paramCol = new List <KeyValuePair <string, object> >();
                paramCol.Add(new KeyValuePair <string, object>("ShippingProviderId", shippingProviderId));
                paramCol.Add(new KeyValuePair <string, object>("StoreId", aspxCommonObj.StoreID));
                paramCol.Add(new KeyValuePair <string, object>("PortalId", aspxCommonObj.PortalID));
                OracleHandler    sqlHl        = new OracleHandler();
                ShippingProvider providerInfo = sqlHl.ExecuteAsObject <ShippingProvider>("usp_Aspx_GetProviderAssemblyInfo",
                                                                                         paramCol);

                var obj1 =
                    (Dictionary <string, string>)
                    DynamicUtility.InvokeMethodAsObject(providerInfo.AssemblyName, providerInfo.ShippingProviderNamespace,
                                                        providerInfo.ShippingProviderClass, "GetAvailableServiceMethod");
                List <ShippingMethodInfo> storeMethod = AspxShipMethodMgntController.GetStoreProvidersAvailableMethod(shippingProviderId, aspxCommonObj);
                var services = obj1.Select(method => new ProviderShippingMethod()
                {
                    ShippingMethodCode = method.Key,
                    ShippingMethodName = method.Value
                }).ToList();

                var filterdmethods = new List <ProviderShippingMethod>();

                foreach (ShippingMethodInfo shippingMethod in storeMethod)
                {
                    foreach (var providerShippingMethod in services)
                    {
                        if (providerShippingMethod.ShippingMethodName == shippingMethod.ShippingMethodName)
                        {
                            services.Remove(providerShippingMethod);
                            break;
                        }
                    }
                }

                return(services);
            }
            catch (Exception e)
            {
                throw e;
            }
        }