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