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