public static void UpdatePaymentMethod(AspxCommonInfo aspxCommonObj, PaymentGateWayBasicInfo updatePaymentObj) { try { var fileObj = new FileHelperController(); updatePaymentObj.DestinationUrl = updatePaymentObj.DestinationUrl.Substring(updatePaymentObj.DestinationUrl.LastIndexOf("Module")); updatePaymentObj.LogoUrl = fileObj.MoveFile(updatePaymentObj.LogoUrl, updatePaymentObj.DestinationUrl, updatePaymentObj.OldLogoUrl); if (updatePaymentObj.LogoUrl == "Modules/AspxCommerce/AspxPaymentGateWayManagement/Logos/") { updatePaymentObj.LogoUrl = ""; } List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@PaymentGatewayTypeID", updatePaymentObj.PaymentGateWayID)); parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", updatePaymentObj.IsActive)); parameterCollection.Add(new KeyValuePair <string, object>("@IsUse", updatePaymentObj.IsUse)); parameterCollection.Add(new KeyValuePair <string, object>("@PaymentGatewayTypeName", updatePaymentObj.PaymentGatewayName)); parameterCollection.Add(new KeyValuePair <string, object>("@LogoUrl", updatePaymentObj.LogoUrl)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_UpdatePaymentMethod", parameterCollection); } catch (Exception e) { throw e; } }
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 { OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_StoreLocatorLocationUpdate", parameterCollection); return(true); } catch (Exception e) { return(false); throw e; } }
public static void DeleteCouponUser(string couponUserID, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CouponUserID", couponUserID)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteCouponUser", parameter); }
public static bool SaveChangesCategoryTree(string categoryIDs, AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@CategoryIDs", categoryIDs)); sqlHandler.ExecuteNonQuery("dbo.usp_Aspx_CategoryTreeUpdate", parameterCollection); return(true); }
public static void DeleteUserProductReview(int itemID, int itemReviewID, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ItemID", itemID)); parameter.Add(new KeyValuePair <string, object>("ItemReviewID", itemReviewID)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteUserProductReview", parameter); }
public static bool CheckReviewByUser(int itemID, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@ItemID", itemID)); SQLHandler sqlH = new SQLHandler(); bool isReviewExist = sqlH.ExecuteNonQueryAsGivenType <bool>("usp_Aspx_CheckReviewAlreadyExist", parameter, "@IsReviewAlreadyExist"); return(isReviewExist); }
public static bool CheckReviewByUser(int itemID, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ItemID", itemID)); OracleHandler sqlH = new OracleHandler(); //bool isReviewExist= sqlH.ExecuteNonQueryAsGivenType<bool>("usp_Aspx_CheckReviewAlreadyExist", parameter, "IsReviewAlreadyExist"); string isReviewExist = sqlH.ExecuteNonQueryAsGivenType <string>("usp_Aspx_CheckReviewAlreadyExi", parameter, "IsReviewAlreadyExist"); return(Convert.ToBoolean(isReviewExist.ToString())); }
public static void ClearWishList(AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_ClearWishItem", parameter); } catch (Exception e) { throw e; } }
public static void InsertNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo insertNotificationObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("itemId", insertNotificationObj.ItemID)); parameter.Add(new KeyValuePair <string, object>("costVariantValuesIds", insertNotificationObj.VariantID)); parameter.Add(new KeyValuePair <string, object>("itemSKU", insertNotificationObj.ItemSKU)); parameter.Add(new KeyValuePair <string, object>("customer", aspxCommonObj.UserName)); parameter.Add(new KeyValuePair <string, object>("email", insertNotificationObj.Email)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_InsertNotification", parameter); }
public static void SaveWishItems(SaveWishListInfo saveWishListInfo, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@ItemID", saveWishListInfo.ItemID)); parameter.Add(new KeyValuePair <string, object>("@WishItemID", 0)); parameter.Add(new KeyValuePair <string, object>("@CostVariantValueIDs", saveWishListInfo.CostVariantValueIDs)); parameter.Add(new KeyValuePair <string, object>("@IP", saveWishListInfo.IP)); parameter.Add(new KeyValuePair <string, object>("@CountryName", saveWishListInfo.CountryName)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_SaveWishItems", parameter); }
//-----------------delete multiple shipping methods---------------------- public static void DeleteShippings(string shippingMethodIds, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("ShippingMethodIDs", shippingMethodIds)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteShippingMethods", parameterCollection); } catch (Exception e) { throw e; } }
//---------------Delete multiple weight Depandencies -------------------------- public static void DeleteWeightDependencies(string shippingProductWeightIds, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ShippingProductWeightIDs", shippingProductWeightIds)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteShippingWeightDependencies", parameter); } catch (Exception e) { throw e; } }
public static void DeleteStoreBranches(string storeBranchIds, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > Parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); Parameter.Add(new KeyValuePair <string, object>("StoreBranchIDs", storeBranchIds)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteStoreBranches", Parameter); } catch (Exception e) { throw e; } }
public static void DeleteNotification(string notificationID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > ParaMeter = CommonParmBuilder.GetParamSPU(aspxCommonObj); ParaMeter.Add(new KeyValuePair <string, object>("notificationID", notificationID)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteNotification", ParaMeter); } catch (Exception e) { throw e; } }
//------------------------ single Cost Variants management------------------------ public static void DeleteSingleCostVariant(string costVariantID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("CostVariantID", costVariantID)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteSingleCostVariants", parameter); } catch (Exception e) { throw e; } }
public static void DeleteUserOwnTag(string itemTagID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ItemTagID", itemTagID)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteUserOwnTag", parameter); } catch (Exception e) { throw e; } }
public static void DeletePaymentMethod(string paymentGatewayID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@PaymentGatewayTypeID", paymentGatewayID)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeletePaymentMethodName", parameterCollection); } catch (Exception e) { throw e; } }
public static void DeleteCouponType(string IDs, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CouponTypeID", IDs)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteCouponType", parameter); } catch (Exception e) { throw e; } }
public static CouponVerificationInfo VerifyUserCoupon(decimal totalCost, string couponCode, string itemIds, string cartItemIds, AspxCommonInfo aspxCommonObj, int appliedCount) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@totalCost", totalCost)); parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponCode)); parameter.Add(new KeyValuePair <string, object>("@ItemIDs", itemIds)); parameter.Add(new KeyValuePair <string, object>("@CartItemIDs", cartItemIds)); parameter.Add(new KeyValuePair <string, object>("@AppliedCount", appliedCount)); SQLHandler sqlH = new SQLHandler(); CouponVerificationInfo lstCoupVeri = sqlH.ExecuteAsObject <CouponVerificationInfo>("[usp_Aspx_VerifyCouponCode]", parameter); return(lstCoupVeri); }
public static void DeleteCustomerDownloadableItem(string orderItemID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("OrderItemID", orderItemID)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteCustomerDownloadableItem", parameterCollection); } catch (Exception e) { throw e; } }
//-----------------Delete Email list -------------------------------- public static void DeleteReferToFriendEmailUser(string emailAFriendIDs, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@EmailAFriendID", emailAFriendIDs)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteReferToFriendUser", parameter); } catch (Exception e) { throw e; } }
public static void DeleteViewedItems(string viewedItems, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ViewedItems", viewedItems)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteMultipleViewedItems", parameter); } 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)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_GetUserProductReviewUpdate", parameter); }
public static void DeleteItemRatingCriteria(string IDs, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("CriteriaID", IDs)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_DeleteItemRatingCriteria", parameter); } catch (Exception e) { throw e; } }
public static void AddTagsOfItem(string itemSKU, string tags, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("itemSKU", itemSKU)); parameter.Add(new KeyValuePair <string, object>("Tags", tags)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_AddTagsOfItem", parameter); } catch (Exception e) { throw e; } }
public static List <ItemQuantityDiscountInfo> GetItemQuantityDiscountsByItemID(int itemId, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("ItemID", itemId)); List <ItemQuantityDiscountInfo> lstIQtyDiscount = sqlH.ExecuteAsList <ItemQuantityDiscountInfo>("usp_Aspx_GetQuantityDiscountByItemID", parameter); return(lstIQtyDiscount); } catch (Exception e) { throw e; } }
/// <summary> /// To update, delete Attribute Set only if it is NOT SystemUsed Type /// </summary> /// <returns></returns> public static void UpdateAttributeSetIsActive(int attributeSetId, AspxCommonInfo aspxCommonObj, bool isActive) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", attributeSetId)); parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", isActive)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("dbo.usp_Aspx_UpdateAttributeSetIsActiveByAttributeSetID", parameterCollection); } catch (Exception e) { throw e; } }
public static void AddComparedItems(string IDs, string CostVarinatIds, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@ItemIDs", IDs)); parameter.Add(new KeyValuePair <string, object>("@CostVarinatIds", CostVarinatIds)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_AddComparedItems", parameter); } catch (Exception e) { throw e; } }
//------------------------delete quantity discount------------------ public static void DeleteItemQuantityDiscount(int quantityDiscountID, int itemID, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("QuantityDiscountID", quantityDiscountID)); parameter.Add(new KeyValuePair <string, object>("ItemID", itemID)); sqlH.ExecuteNonQuery("usp_Aspx_DeleteItemQuantityDiscounts", parameter); } catch (Exception e) { throw e; } }
public static void UpdateWishList(string wishItemID, string comment, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@WishItemID", wishItemID)); parameter.Add(new KeyValuePair <string, object>("@Comment", comment)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_UpdateWishItem", parameter); } catch (Exception e) { throw e; } }