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