public static List <UserRatingInformationInfo> GetAllItemReviewsList(int offset, System.Nullable <int> limit, UserRatingBasicInfo itemReviewObj, 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>("@ItemID", itemReviewObj.ItemID)); parameter.Add(new KeyValuePair <string, object>("@UserName", itemReviewObj.UserName)); parameter.Add(new KeyValuePair <string, object>("@StatusName", itemReviewObj.Status)); parameter.Add(new KeyValuePair <string, object>("@ItemName", itemReviewObj.ItemName)); SQLHandler sqlH = new SQLHandler(); List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetItemWiseReviewsList", parameter); return(bind); } catch (Exception e) { throw e; } }
public static List <Notification> GetNotificationList(int offset, int limit, GetAllNotificationInfo getAllNotificationObj, AspxCommonInfo aspxCommonObj) { 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>("itemSKU", getAllNotificationObj.ItemSKU)); ParaMeter.Add(new KeyValuePair <string, object>("mailStatus", getAllNotificationObj.MailStatus)); ParaMeter.Add(new KeyValuePair <string, object>("itemStatus", getAllNotificationObj.ItemStatus)); ParaMeter.Add(new KeyValuePair <string, object>("customer", getAllNotificationObj.Customer)); OracleHandler sqLH = new OracleHandler(); List <Notification> lstNotification = sqLH.ExecuteAsList <Notification>("usp_Aspx_GetNotificationList", ParaMeter); return(lstNotification); } 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)); SQLHandler sqlh = new SQLHandler(); List <TaxRateInfo> lstTaxRate = sqlh.ExecuteAsList <TaxRateInfo>("usp_Aspx_GetTaxRates", parameter); return(lstTaxRate); } catch (Exception e) { throw e; } }
public static List <CouponInfo> BindAllCouponDetails(int offset, int limit, GetCouponDetailsInfo couponDetailObj, 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)); parameter.Add(new KeyValuePair <string, object>("@CouponTypeID", couponDetailObj.CouponTypeID)); parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponDetailObj.CouponCode)); parameter.Add(new KeyValuePair <string, object>("@ValidateFrom", couponDetailObj.ValidateFrom)); parameter.Add(new KeyValuePair <string, object>("@ValidateTo", couponDetailObj.ValidateTo)); SQLHandler sqlH = new SQLHandler(); List <CouponInfo> lstCoupon = sqlH.ExecuteAsList <CouponInfo>("usp_Aspx_GetCouponDetails", parameter); return(lstCoupon); } catch (Exception ex) { throw ex; } }
public static List <ItemBasicDetailsInfo> GetShoppingOptionsItemsResultByBrandAndPrice(int offset, int limit, string brandIDs, decimal priceFrom, decimal priceTo, int SortBy, 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)); parameter.Add(new KeyValuePair <string, object>("@brandIDs", brandIDs)); parameter.Add(new KeyValuePair <string, object>("@priceFrom", priceFrom)); parameter.Add(new KeyValuePair <string, object>("@priceTo", priceTo)); parameter.Add(new KeyValuePair <string, object>("@SortBy", SortBy)); SQLHandler sqlH = new SQLHandler(); List <ItemBasicDetailsInfo> lstItemBasicDet = sqlH.ExecuteAsList <ItemBasicDetailsInfo>("usp_Aspx_GetShoppingOptionsItemsResultByBrandAndPrice", parameter); return(lstItemBasicDet); } catch (Exception e) { throw e; } }
/// <summary> /// To update, add Attribute Group /// </summary> /// <returns></returns> public static void UpdateAttributeGroup(AttributeSaveInfo attributeSaveObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("AttributeSetID", attributeSaveObj.AttributeSetID)); parameterCollection.Add(new KeyValuePair <string, object>("GroupName", attributeSaveObj.GroupName)); parameterCollection.Add(new KeyValuePair <string, object>("IsActive", attributeSaveObj.IsActive)); parameterCollection.Add(new KeyValuePair <string, object>("IsModified", attributeSaveObj.IsModified)); parameterCollection.Add(new KeyValuePair <string, object>("GroupID", attributeSaveObj.GroupID)); parameterCollection.Add(new KeyValuePair <string, object>("AliasName", attributeSaveObj.AliasName)); parameterCollection.Add(new KeyValuePair <string, object>("UpdateFlag", attributeSaveObj.Flag)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_AttributeGroupAddUpdate", parameterCollection); } catch (Exception e) { throw e; } }
public List <ServiceCoreAvailableTime> GetServiceAvailableTime(GetServiceCoreAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("CategoryID", getServiceTimeObj.CategoryID)); parameter.Add(new KeyValuePair <string, object>("BranchID", getServiceTimeObj.BranchID)); parameter.Add(new KeyValuePair <string, object>("EmployeeID", getServiceTimeObj.EmployeeID)); parameter.Add(new KeyValuePair <string, object>("ServiceDateID", getServiceTimeObj.ServiceDateID)); parameter.Add(new KeyValuePair <string, object>("ServiceDate", getServiceTimeObj.ServiceDate)); parameter.Add(new KeyValuePair <string, object>("ItemID", getServiceTimeObj.ItemID)); OracleHandler sqlh = new OracleHandler(); List <ServiceCoreAvailableTime> lstServTime = sqlh.ExecuteAsList <ServiceCoreAvailableTime>("usp_Aspx_GetServiceTime", parameter); return(lstServTime); } catch (Exception e) { throw e; } }
private static void IssueGiftCard(int giftCardId, int?orderID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@GiftCardId", giftCardId)); parameter.Add(new KeyValuePair <string, object>("@GiftCardCode", GetGiftCardKey())); parameter.Add(new KeyValuePair <string, object>("@IsActive", true)); parameter.Add(new KeyValuePair <string, object>("@OrderID", orderID)); parameter.Add(new KeyValuePair <string, object>("@GiftCardPinCode", GetGiftPinCode())); parameter.Add(new KeyValuePair <string, object>("@AddedBy", aspxCommonObj.UserName)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_IssueGiftCard ", parameter); } catch (Exception e) { throw e; } }
public static List <StoreAccessInfo> LoadStoreAccessCreditCards(int offset, int limit, string search, System.Nullable <DateTime> startDate, System.Nullable <DateTime> endDate, System.Nullable <bool> status, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); 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>("Search", search)); parameter.Add(new KeyValuePair <string, object>("StartDate", startDate)); parameter.Add(new KeyValuePair <string, object>("EndDate", endDate)); parameter.Add(new KeyValuePair <string, object>("Status", status)); List <StoreAccessInfo> lstStoreAccess = sqlH.ExecuteAsList <StoreAccessInfo>("usp_Aspx_GetStoreAccessCreditCard", parameter); return(lstStoreAccess); } catch (Exception e) { throw e; } }
public static List <ServiceManageInfo> GetServiceEmployeeDetails(int offset, int limit, AspxCommonInfo aspxCommonObj, int serviceId, int employeeId, int branchID, string itemName) { 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)); parameter.Add(new KeyValuePair <string, object>("ServiceID", serviceId)); parameter.Add(new KeyValuePair <string, object>("ServiceEmployeeID", employeeId)); parameter.Add(new KeyValuePair <string, object>("BranchID", branchID)); parameter.Add(new KeyValuePair <string, object>("ItemName", itemName)); OracleHandler sqlh = new OracleHandler(); List <ServiceManageInfo> list = sqlh.ExecuteAsList <ServiceManageInfo>("usp_Aspx_GetServiceEmployeeDetails", parameter); return(list); } catch (Exception e) { throw e; } }
public static List <GetOrderdetailsByPaymentGatewayIDInfo> GetOrderDetailsbyPayID(int offset, int limit, PaymentGateWayBasicInfo bindOrderObj, 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)); parameter.Add(new KeyValuePair <string, object>("@BillToName", bindOrderObj.BillToName)); parameter.Add(new KeyValuePair <string, object>("@ShipToName", bindOrderObj.ShipToName)); parameter.Add(new KeyValuePair <string, object>("@OrderStatusAliasName", bindOrderObj.OrderStatusName)); parameter.Add(new KeyValuePair <string, object>("@PaymentGatewayTypeID", bindOrderObj.PaymentGateWayID)); SQLHandler sqlH = new SQLHandler(); List <GetOrderdetailsByPaymentGatewayIDInfo> lstOrderDetail = sqlH.ExecuteAsList <GetOrderdetailsByPaymentGatewayIDInfo>("usp_Aspx_GetOrderDetailsByPaymentGetwayID", parameter); return(lstOrderDetail); } catch (Exception e) { throw e; } }
public static void AddUpdatePaymentGateWaySettings(int paymentGatewaySettingValueID, int paymentGatewayID, string settingKeys, string settingValues, bool isActive, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@PaymentGatewaySettingValueID", paymentGatewaySettingValueID)); parameterCollection.Add(new KeyValuePair <string, object>("@PaymentGatewayTypeID", paymentGatewayID)); parameterCollection.Add(new KeyValuePair <string, object>("@SettingKeys", settingKeys)); parameterCollection.Add(new KeyValuePair <string, object>("@SettingValues ", settingValues)); parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", isActive)); parameterCollection.Add(new KeyValuePair <string, object>("@UpdatedBy", aspxCommonObj.UserName)); parameterCollection.Add(new KeyValuePair <string, object>("@AddedBy", aspxCommonObj.UserName)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_GetPaymentGatewaySettingsSaveUpdate", parameterCollection); } catch (Exception e) { throw e; } }
public static List <ServiceAvailableTimeInfo> GetServiceAvailableTime(GetServiceAvailableTimeInfo getServiceTimeObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CategoryID", getServiceTimeObj.CategoryID)); parameter.Add(new KeyValuePair <string, object>("@BranchID", getServiceTimeObj.BranchID)); parameter.Add(new KeyValuePair <string, object>("@EmployeeID", getServiceTimeObj.EmployeeID)); parameter.Add(new KeyValuePair <string, object>("@ServiceDateID", getServiceTimeObj.ServiceDateID)); parameter.Add(new KeyValuePair <string, object>("@ServiceDate", getServiceTimeObj.ServiceDate)); parameter.Add(new KeyValuePair <string, object>("@ItemID", getServiceTimeObj.ItemID)); SQLHandler sqlh = new SQLHandler(); List <ServiceAvailableTimeInfo> lstServTime = sqlh.ExecuteAsList <ServiceAvailableTimeInfo>("[dbo].[usp_Aspx_GetServiceTime]", parameter); return(lstServTime); } catch (Exception e) { throw e; } }
public static void ReturnUpdate(RetunDetailsBasicInfo returnDetailObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamNoCID(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair <string, object>("OrderID", returnDetailObj.OrderID)); parameter.Add(new KeyValuePair <string, object>("ReturnActionID", returnDetailObj.ReturnActionID)); parameter.Add(new KeyValuePair <string, object>("ReturnStatusID", returnDetailObj.ReturnStatusID)); parameter.Add(new KeyValuePair <string, object>("ShippingMethodID", returnDetailObj.shippingMethodID)); parameter.Add(new KeyValuePair <string, object>("ShippingCost", returnDetailObj.ShippingCost)); parameter.Add(new KeyValuePair <string, object>("OtherPostalCharges", returnDetailObj.OtherPostalCharges)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_ReturnUpdate", parameter); } catch (Exception e) { throw e; } }
public static List <ShippingMethodInfo> GetShippingMethods(int offset, int limit, ShippingMethodInfoByProvider shippingMethodObj, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); 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)); List <ShippingMethodInfo> shipping = sqlH.ExecuteAsList <ShippingMethodInfo>("usp_Aspx_BindShippingMethodInGrid", parameterCollection); return(shipping); } catch (Exception e) { throw e; } }
public static void AddUpDateWareHouse(WareHouseAddress wareHouse, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj); paramCol.Add(new KeyValuePair <string, object>("WareHouseID", wareHouse.WareHouseID)); paramCol.Add(new KeyValuePair <string, object>("IsPrimary", wareHouse.IsPrimary)); paramCol.Add(new KeyValuePair <string, object>("Name", wareHouse.Name)); paramCol.Add(new KeyValuePair <string, object>("StreetAddress1", wareHouse.StreetAddress1)); paramCol.Add(new KeyValuePair <string, object>("StreetAddress2", wareHouse.StreetAddress2)); paramCol.Add(new KeyValuePair <string, object>("City", wareHouse.City)); paramCol.Add(new KeyValuePair <string, object>("Country", wareHouse.Country)); paramCol.Add(new KeyValuePair <string, object>("State", wareHouse.State)); paramCol.Add(new KeyValuePair <string, object>("PostalCode", wareHouse.PostalCode)); paramCol.Add(new KeyValuePair <string, object>("Phone", wareHouse.Phone)); paramCol.Add(new KeyValuePair <string, object>("Fax", wareHouse.Fax)); paramCol.Add(new KeyValuePair <string, object>("Email", wareHouse.Email)); paramCol.Add(new KeyValuePair <string, object>("AddedBy", aspxCommonObj.UserName)); OracleHandler sageSQL = new OracleHandler(); sageSQL.ExecuteNonQuery("usp_Aspx_InsertUpdateAspx_WareHouse", paramCol); }
public static List <OrderStatusListInfo> AddUpdateOrderStatus(AspxCommonInfo aspxCommonObj, SaveOrderStatusInfo SaveOrderStatusObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@OrderStatusID", SaveOrderStatusObj.OrderStatusID)); parameter.Add(new KeyValuePair <string, object>("@OrderStatusAliasName", SaveOrderStatusObj.OrderStatusAliasName)); parameter.Add(new KeyValuePair <string, object>("@AliasToolTip", SaveOrderStatusObj.AliasToolTip)); parameter.Add(new KeyValuePair <string, object>("@AliasHelp", SaveOrderStatusObj.AliasHelp)); parameter.Add(new KeyValuePair <string, object>("@IsSystem", SaveOrderStatusObj.IsSystemUsed)); parameter.Add(new KeyValuePair <string, object>("@IsActive", SaveOrderStatusObj.IsActive)); parameter.Add(new KeyValuePair <string, object>("@IsReduceQuantity", SaveOrderStatusObj.IsReduceInQuantity)); SQLHandler sqlH = new SQLHandler(); List <OrderStatusListInfo> lstOrderStat = sqlH.ExecuteAsList <OrderStatusListInfo>("[dbo].[usp_Aspx_OrderStatusAddUpdate]", parameter); return(lstOrderStat); } catch (Exception e) { throw e; } }
public static void InsertNewBrand(string prevFilePath, AspxCommonInfo aspxCommonObj, BrandInfo brandInsertObj, string imagePath) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@BrandID", brandInsertObj.BrandID)); parameter.Add(new KeyValuePair <string, object>("@BrandName", brandInsertObj.BrandName)); parameter.Add(new KeyValuePair <string, object>("@Branddescription", brandInsertObj.BrandDescription)); parameter.Add(new KeyValuePair <string, object>("@BrandImgUrl", imagePath)); parameter.Add(new KeyValuePair <string, object>("@isShowInSlider", brandInsertObj.IsShowInSlider)); parameter.Add(new KeyValuePair <string, object>("@IsFeatured", brandInsertObj.IsFeatured)); parameter.Add(new KeyValuePair <string, object>("@FeaturedFrom", brandInsertObj.FeaturedFrom)); parameter.Add(new KeyValuePair <string, object>("@FeaturedTo", brandInsertObj.FeaturedTo)); SQLHandler sqLh = new SQLHandler(); sqLh.ExecuteNonQuery("usp_Aspx_InsertAndUpdateBrand", parameter); } catch (Exception e) { throw e; } }
//-------------------save and update tax rules-------------------------------------- public static void SaveAndUpdateTaxRule(TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@TaxManageRuleID", taxRuleDataObj.TaxManageRuleID)); parameter.Add(new KeyValuePair <string, object>("@TaxManageRuleName", taxRuleDataObj.TaxManageRuleName)); parameter.Add(new KeyValuePair <string, object>("@RoleID", taxRuleDataObj.RoleID)); parameter.Add(new KeyValuePair <string, object>("@RoleName", taxRuleDataObj.RoleName)); parameter.Add(new KeyValuePair <string, object>("@TaxItemClassID", taxRuleDataObj.TaxItemClassID)); parameter.Add(new KeyValuePair <string, object>("@TaxRateID", taxRuleDataObj.TaxRateID)); parameter.Add(new KeyValuePair <string, object>("@Priority", taxRuleDataObj.Priority)); parameter.Add(new KeyValuePair <string, object>("@DisplayOrder", taxRuleDataObj.DisplayOrder)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateTaxRules", parameter); } catch (Exception e) { throw e; } }
//----------------- save and update tax rates-------------------------- public static void SaveAndUpdateTaxRates(TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@TaxRateID", taxRateDataObj.TaxRateID)); parameter.Add(new KeyValuePair <string, object>("@TaxRateTitle", taxRateDataObj.TaxRateTitle)); parameter.Add(new KeyValuePair <string, object>("@TaxCountryCode", taxRateDataObj.Country)); parameter.Add(new KeyValuePair <string, object>("@TaxStateCode", taxRateDataObj.State)); parameter.Add(new KeyValuePair <string, object>("@ZipPostCode", taxRateDataObj.Zip)); parameter.Add(new KeyValuePair <string, object>("@IsZipPostRange", taxRateDataObj.IsZipPostRange)); parameter.Add(new KeyValuePair <string, object>("@TaxRateValue", taxRateDataObj.TaxRateValue)); parameter.Add(new KeyValuePair <string, object>("@RateType", taxRateDataObj.RateType)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_SaveAndUpdateTaxRates", parameter); } catch (Exception e) { throw e; } }
public static List <CouponUserInfo> GetCouponUserDetails(int offset, int?limit, GetCouponUserDetailInfo couponUserObj, AspxCommonInfo aspxCommonObj, string userName) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@UserName", userName)); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponUserObj.CouponCode)); parameter.Add(new KeyValuePair <string, object>("@CouponStatusID", couponUserObj.CouponStatusID)); parameter.Add(new KeyValuePair <string, object>("@ValidFrom", couponUserObj.ValidFrom)); parameter.Add(new KeyValuePair <string, object>("@ValidTo", couponUserObj.ValidTo)); SQLHandler sqlH = new SQLHandler(); List <CouponUserInfo> lstCoupUser = sqlH.ExecuteAsList <CouponUserInfo>("usp_Aspx_CouponUserDetails", parameter); return(lstCoupUser); } catch (Exception ex) { throw ex; } }
//-------------------------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; OracleHandler Sq = new OracleHandler(); 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>("usp_Aspx_GetCustomerDownloadableItems", parameterCollection); return(ml); } catch (Exception e) { throw e; } }
public static int AddItemstoCart(int itemID, decimal itemPrice, int itemQuantity, 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)); SQLHandler sqlH = new SQLHandler(); bool i = sqlH.ExecuteNonQueryAsGivenType <bool>("usp_Aspx_CheckCostVariantForItem", parameter, "@IsExist"); return(i ? 1 : 0); } 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)); SQLHandler sqlH = new SQLHandler(); bool i = sqlH.ExecuteNonQueryAsGivenType <bool>("usp_Aspx_CheckCostVariantForItem", parameter, "@IsExist"); return(i ? 1 : 0); } else { return(2); } } } catch (Exception e) { throw e; } }
public void UpdateItemRating(ItemReviewBasicInfo ratingManageObj, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("RatingCriteriaValue", ratingManageObj.ItemRatingCriteria)); parameter.Add(new KeyValuePair <string, object>("StatusID", ratingManageObj.StatusID)); parameter.Add(new KeyValuePair <string, object>("ReviewSummary", ratingManageObj.ReviewSummary)); parameter.Add(new KeyValuePair <string, object>("Review", ratingManageObj.Review)); parameter.Add(new KeyValuePair <string, object>("ItemReviewID", ratingManageObj.ItemReviewID)); parameter.Add(new KeyValuePair <string, object>("ViewFromIP", ratingManageObj.ViewFromIP)); parameter.Add(new KeyValuePair <string, object>("ViewFromCountry", ratingManageObj.viewFromCountry)); parameter.Add(new KeyValuePair <string, object>("ItemID", ratingManageObj.ItemID)); parameter.Add(new KeyValuePair <string, object>("UserBy", aspxCommonObj.UserName)); sqlH.ExecuteNonQuery("usp_Aspx_UpdateItemRating", 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)); SQLHandler sqlh = new SQLHandler(); List <TaxManageRulesInfo> lstTaxManage = sqlh.ExecuteAsList <TaxManageRulesInfo>("usp_Aspx_GetTaxManageRules", parameter); return(lstTaxManage); } catch (Exception e) { throw e; } }
public int SaveKit(Kit kit, AspxCommonInfo commonInfo) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(commonInfo); // parameter.Add(new KeyValuePair<string, object>("@ID", kit.ID)); parameter.Add(new KeyValuePair <string, object>("KitID", kit.KitID)); parameter.Add(new KeyValuePair <string, object>("KitName", kit.KitName)); parameter.Add(new KeyValuePair <string, object>("Price", kit.Price)); parameter.Add(new KeyValuePair <string, object>("Quantity", kit.Quantity)); parameter.Add(new KeyValuePair <string, object>("Weight", kit.Weight)); parameter.Add(new KeyValuePair <string, object>("KitComponentID", kit.KitComponentID)); OracleHandler sqLh = new OracleHandler(); int kitComponentID = sqLh.ExecuteAsScalar <int>("usp_Aspx_AddUpdateKit", parameter); return(kitComponentID); } catch (Exception ex) { throw ex; } }
private void SaveItemKitConfig(ItemKit kitconfig, int itemId, AspxCommonInfo commonInfo) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(commonInfo); parameter.Add(new KeyValuePair <string, object>("KitComponentID", kitconfig.KitComponentID)); parameter.Add(new KeyValuePair <string, object>("KitComponentOrder", kitconfig.KitComponentOrder)); parameter.Add(new KeyValuePair <string, object>("Price", kitconfig.Price)); parameter.Add(new KeyValuePair <string, object>("Quantity", kitconfig.Quantity)); parameter.Add(new KeyValuePair <string, object>("Weight", kitconfig.Weight)); parameter.Add(new KeyValuePair <string, object>("IsDefault", kitconfig.IsDefault)); parameter.Add(new KeyValuePair <string, object>("KitID", kitconfig.KitID)); parameter.Add(new KeyValuePair <string, object>("KitOrder", kitconfig.KitOrder)); parameter.Add(new KeyValuePair <string, object>("ItemID", itemId)); OracleHandler sqLh = new OracleHandler(); sqLh.ExecuteNonQuery("usp_Aspx_MapKitToItem", parameter); } catch (Exception ex) { throw ex; } }
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)); OracleHandler sqlH = new OracleHandler(); List <ReturnDetailsInfo> info = sqlH.ExecuteAsList <ReturnDetailsInfo>("usp_Aspx_GetReturnDetails", parameter); return(info); } catch (Exception e) { throw e; } }
public static void InsertNewCurrency(AspxCommonInfo aspxCommonObj, CurrencyInfo currencyInsertObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CurrencyID", currencyInsertObj.CurrencyID)); parameter.Add(new KeyValuePair <string, object>("@CurrencyName", currencyInsertObj.CurrencyName)); parameter.Add(new KeyValuePair <string, object>("@CurrencyCode", currencyInsertObj.CurrencyCode)); parameter.Add(new KeyValuePair <string, object>("@CurrencySymbol", currencyInsertObj.CurrencySymbol)); parameter.Add(new KeyValuePair <string, object>("@CountryName", currencyInsertObj.CountryName)); parameter.Add(new KeyValuePair <string, object>("@Region", currencyInsertObj.Region)); parameter.Add(new KeyValuePair <string, object>("@ConversionRate", currencyInsertObj.ConversionRate)); parameter.Add(new KeyValuePair <string, object>("@DisplayOrder", currencyInsertObj.DisplayOrder)); parameter.Add(new KeyValuePair <string, object>("@BaseImage", currencyInsertObj.BaseImage)); parameter.Add(new KeyValuePair <string, object>("@IsActive", currencyInsertObj.IsActive)); SQLHandler sqLh = new SQLHandler(); sqLh.ExecuteNonQuery("[usp_Aspx_AddUpdateCurrency]", parameter); } catch (Exception e) { throw e; } }
public static List <GiftCardReport> GetGiftCardReport(int offset, int?limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj); paramCol.Add(new KeyValuePair <string, object>("@offset", offset)); paramCol.Add(new KeyValuePair <string, object>("@limit", limit)); paramCol.Add(new KeyValuePair <string, object>("@FromDate", objGiftcard.FromDate)); paramCol.Add(new KeyValuePair <string, object>("@ToDate", objGiftcard.ToDate)); paramCol.Add(new KeyValuePair <string, object>("@SKU", objGiftcard.SKU)); paramCol.Add(new KeyValuePair <string, object>("@ItemName", objGiftcard.ItemName)); paramCol.Add(new KeyValuePair <string, object>("@GiftCardType", objGiftcard.GiftCardType)); SQLHandler sqlHl = new SQLHandler(); List <GiftCardReport> lstGiftCard = sqlHl.ExecuteAsList <GiftCardReport>("[dbo].[usp_Aspx_GetGiftCardReports]", paramCol); return(lstGiftCard); } catch (Exception e) { throw e; } }