public void SaveBannerContent(SageBannerInfo obj)
{
try
{
List<KeyValuePair<string, object>> param = new List<KeyValuePair<string, object>>();
param.Add(new KeyValuePair<string, object>("@Caption", obj.Caption));
param.Add(new KeyValuePair<string, object>("@ImagePath", obj.ImagePath));
param.Add(new KeyValuePair<string, object>("@ReadMorePage", obj.ReadMorePage));
param.Add(new KeyValuePair<string, object>("@LinkToImage", obj.LinkToImage));
param.Add(new KeyValuePair<string, object>("@UserModuleID", obj.UserModuleID));
param.Add(new KeyValuePair<string, object>("@BannerID", obj.BannerID));
param.Add(new KeyValuePair<string, object>("@ImageID", obj.ImageID));
param.Add(new KeyValuePair<string, object>("@ReadButtonText", obj.ReadButtonText));
param.Add(new KeyValuePair<string, object>("@NavigationImage", obj.NavigationImage));
param.Add(new KeyValuePair<string, object>("@Description", obj.Description));
param.Add(new KeyValuePair<string, object>("@PortalID", obj.PortalID));
param.Add(new KeyValuePair<string, object>("@CultureCode", obj.CultureCode));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_SageBannerSaveBannerContent", param);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connect to database and save Suspended IP.
/// </summary>
/// <param name="IpAddress">IpAddress</param>
public void SaveSuspendedIP(string IpAddress)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IpAddress", IpAddress));
SQLHandler sageSQL = new SQLHandler();
sageSQL.ExecuteNonQuery("usp_SaveSuspendedIP", ParaMeterCollection);
}
public static void RewardPointsSaveUpdateNewRule(RewardPointsCommonInfo rewardPointsCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@RewardPointSettingsID",
rewardPointsCommonObj.RewardPointSettingsID));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleName", rewardPointsCommonObj.RewardRuleName));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleID", rewardPointsCommonObj.RewardRuleID));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleType", rewardPointsCommonObj.RewardRuleType));
parameter.Add(new KeyValuePair<string, object>("@RewardPoints", rewardPointsCommonObj.RewardPoints));
parameter.Add(new KeyValuePair<string, object>("@PurchaseAmount", rewardPointsCommonObj.PurchaseAmount));
parameter.Add(new KeyValuePair<string, object>("@IsActive", rewardPointsCommonObj.IsActive));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@CulturName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveUpdateNewRule", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static void RewardPointsSaveGeneralSettings(GeneralSettingsCommonInfo generalSettingobj,
AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@RewardPoints", generalSettingobj.RewardPoints));
parameter.Add(new KeyValuePair<string, object>("@RewardAmount", generalSettingobj.RewardExchangeRate));
parameter.Add(new KeyValuePair<string, object>("@AddOrderStatusID", generalSettingobj.AddOrderStatusID));
parameter.Add(new KeyValuePair<string, object>("@SubOrderStatusID", generalSettingobj.SubOrderStatusID));
parameter.Add(new KeyValuePair<string, object>("@RewardPointsExpiresInDays",
generalSettingobj.RewardPointsExpiresInDays));
parameter.Add(new KeyValuePair<string, object>("@MinRedeemBalance", generalSettingobj.MinRedeemBalance));
parameter.Add(new KeyValuePair<string, object>("@BalanceCapped", generalSettingobj.BalanceCapped));
parameter.Add(new KeyValuePair<string, object>("@IsActive", generalSettingobj.IsActive));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@CulturName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveGeneralSettings", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void AddUpdateCoupons(int couponID, int couponTypeID, string couponCode, string couponAmount, string validateFrom, string validateTo,
string isActive, int storeID, int portalID, string cultureName, string userName, string settingIDs, string settingValues, string portalUser_UserName)
{
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@CouponID", couponID));
parameter.Add(new KeyValuePair<string, object>("@CouponTypeID", couponTypeID));
parameter.Add(new KeyValuePair<string, object>("@CouponCode", couponCode));
parameter.Add(new KeyValuePair<string, object>("@CouponAmount", couponAmount));
parameter.Add(new KeyValuePair<string, object>("@ValidateFrom", validateFrom));
parameter.Add(new KeyValuePair<string, object>("@ValidateTo", validateTo));
parameter.Add(new KeyValuePair<string, object>("@IsActive", isActive));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", userName));
parameter.Add(new KeyValuePair<string, object>("@SettingIDs", settingIDs));
parameter.Add(new KeyValuePair<string, object>("@SettingValues", settingValues));
parameter.Add(new KeyValuePair<string, object>("@portalUser_UserName", portalUser_UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateCoupons", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertLog(int logTypeID, int severity, string message, string exception, string clientIPAddress, string pageURL, bool isActive, int portalID, string addedBy)
{
string sp = "[dbo].[sp_LogInsert]";
SQLHandler sagesql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@LogTypeID", logTypeID));
ParamCollInput.Add(new KeyValuePair<string, object>("@Severity", severity));
ParamCollInput.Add(new KeyValuePair<string, object>("@Message", message));
ParamCollInput.Add(new KeyValuePair<string, object>("@Exception", exception));
ParamCollInput.Add(new KeyValuePair<string, object>("@ClientIPAddress", clientIPAddress));
ParamCollInput.Add(new KeyValuePair<string, object>("@PageURL", pageURL));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", isActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", portalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", addedBy));
return sagesql.ExecuteNonQuery(sp, ParamCollInput, "@LogID");
}
catch (Exception)
{
throw;
}
}
public static void AddFile(ATTFile file)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalId", file.PortalId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UniqueId", file.UniqueId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@VersionGuid", file.VersionGuid));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FileName", file.FileName));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Extension", file.Extension));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Size", file.Size));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ContentType", file.ContentType));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Folder", file.Folder));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FolderId", file.FolderId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", file.IsActive));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedBy", file.AddedBy));
if (file.StorageLocation == 2)
{
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Content", file.Content));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_FileManagerAddDatabaseFile", ParaMeterCollection);
}
else
{
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_FileManagerAddFile", ParaMeterCollection);
}
}
public static void DeleteSearchTerm(string Ids, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@SearchTermID", Ids));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_DeleteSearchTerm", parameter);
}
public void AddUpdateUserAddress(AddressInfo addressObj,AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@AddressID", addressObj.AddressID));
parameter.Add(new KeyValuePair<string, object>("@CustomerID", aspxCommonObj.CustomerID));
parameter.Add(new KeyValuePair<string, object>("@FirstName", addressObj.FirstName));
parameter.Add(new KeyValuePair<string, object>("@LastName", addressObj.LastName));
parameter.Add(new KeyValuePair<string, object>("@Email", addressObj.Email));
parameter.Add(new KeyValuePair<string, object>("@Company", addressObj.Company));
parameter.Add(new KeyValuePair<string, object>("@Address1", addressObj.Address1));
parameter.Add(new KeyValuePair<string,object>("@Address2",addressObj.Address2));
parameter.Add(new KeyValuePair<string, object>("@City", addressObj.City));
parameter.Add(new KeyValuePair<string, object>("@State", addressObj.State));
parameter.Add(new KeyValuePair<string, object>("@Zip", addressObj.Zip));
parameter.Add(new KeyValuePair<string, object>("@Phone", addressObj.Phone));
parameter.Add(new KeyValuePair<string, object>("@Mobile", addressObj.Mobile));
parameter.Add(new KeyValuePair<string, object>("@Fax", addressObj.Fax));
parameter.Add(new KeyValuePair<string, object>("@WebSite", addressObj.Website));
parameter.Add(new KeyValuePair<string, object>("@Country", addressObj.Country));
parameter.Add(new KeyValuePair<string, object>("@IsDefaultShipping", addressObj.DefaultShipping));
parameter.Add(new KeyValuePair<string, object>("@IsDefaultBilling", addressObj.DefaultBilling));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateUserAddress", parameter);
}
public static int CartPriceRuleAdd(CartPriceRule cartPriceRule, SqlTransaction tran, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter =CommonParmBuilder.GetParamPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@CartPriceRuleName", cartPriceRule.CartPriceRuleName));
parameter.Add(new KeyValuePair<string, object>("@CartPriceRuleDescription", cartPriceRule.CartPriceRuleDescription));
parameter.Add(new KeyValuePair<string, object>("@Apply", cartPriceRule.Apply));
parameter.Add(new KeyValuePair<string, object>("@Value", cartPriceRule.Value));
parameter.Add(new KeyValuePair<string, object>("@ApplytoShippingAmount", cartPriceRule.ApplytoShippingAmount));
parameter.Add(new KeyValuePair<string, object>("@DiscountQuantity", cartPriceRule.DiscountQuantity));
parameter.Add(new KeyValuePair<string, object>("@DiscountStep", cartPriceRule.DiscountStep));
parameter.Add(new KeyValuePair<string, object>("@FreeShipping", cartPriceRule.FreeShipping));
parameter.Add(new KeyValuePair<string, object>("@IsFurtherProcessing", cartPriceRule.IsFurtherProcessing));
parameter.Add(new KeyValuePair<string, object>("@FromDate", cartPriceRule.FromDate));
parameter.Add(new KeyValuePair<string, object>("@ToDate", cartPriceRule.ToDate));
parameter.Add(new KeyValuePair<string, object>("@Priority", cartPriceRule.Priority));
parameter.Add(new KeyValuePair<string, object>("@IsActive", cartPriceRule.IsActive));
try
{
SQLHandler sqlH = new SQLHandler();
if (cartPriceRule.CartPriceRuleID > 0)
DeleteCartPricingRuleForEdit(tran, cartPriceRule.CartPriceRuleID, aspxCommonObj.PortalID);
int cartPRID= sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_CartPriceRuleAdd", parameter, "@CartPriceRuleID");
return cartPRID;
}
catch (Exception e)
{
throw e;
}
}
public static int AddNewSchedule(Schedule objSchedule)
{
int id = 0;
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ScheduleName", objSchedule.ScheduleName));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FullNameSpace", objSchedule.FullNamespace));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@StartDate", objSchedule.StartDate));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@EndDate", objSchedule.EndDate));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@StartHour", objSchedule.StartHour));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@StartMin", objSchedule.StartMin));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@RepeatWeeks", objSchedule.RepeatWeeks));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@RepeatDays", objSchedule.RepeatDays));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@WeekOfMonth", objSchedule.WeekOfMonth));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@EveryHour", objSchedule.EveryHours));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@EveryMin", objSchedule.EveryMin));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ObjectDependencies", objSchedule.ObjectDependencies));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@RetryTimeLapse", objSchedule.RetryTimeLapse));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@RetryFrequencyUnit", objSchedule.RetryFrequencyUnit));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AttachToEvent", objSchedule.AttachToEvent));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@CatchUpEnabled", objSchedule.CatchUpEnabled));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Servers", objSchedule.Servers));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsEnable", objSchedule.IsEnable));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@RunningMode", (int)objSchedule.RunningMode));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AssemblyFileName", objSchedule.AssemblyFileName));
try
{
SQLHandler sagesql = new SQLHandler();
id = sagesql.ExecuteNonQuery("usp_SchedulerAddJob", ParaMeterCollection, "@ScheduleID");
}
catch (Exception)
{
throw;
}
return id;
}
public static void NotificationSaveUpdateSettings(NotificationSettingsInfo saveUpdateInfo, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@AllActive", saveUpdateInfo.AllActive));
parameterCollection.Add(new KeyValuePair<string, object>("@UserNotificationActive", saveUpdateInfo.UserNotificationActive));
parameterCollection.Add(new KeyValuePair<string, object>("@UserNotificationCount", saveUpdateInfo.UserNotificationCount));
parameterCollection.Add(new KeyValuePair<string, object>("@SubscriptionNotificationActive ", saveUpdateInfo.SubscriptionNotificationActive));
parameterCollection.Add(new KeyValuePair<string, object>("@SubscriptionNotificationCount", saveUpdateInfo.SubscriptionNotificationCount));
parameterCollection.Add(new KeyValuePair<string, object>("@OutofStockNotificationActive", saveUpdateInfo.OutofStockNotificationActive));
parameterCollection.Add(new KeyValuePair<string, object>("@OutofStockNotificationCount", saveUpdateInfo.OutofStockNotificationCount));
parameterCollection.Add(new KeyValuePair<string, object>("@ItemsLowStockNotificationActive", saveUpdateInfo.ItemsLowStockNotificationActive));
parameterCollection.Add(new KeyValuePair<string, object>("@ItemsLowStockCount", saveUpdateInfo.ItemsLowStockCount));
parameterCollection.Add(new KeyValuePair<string, object>("@OrdersNotificationAtive", saveUpdateInfo.OrdersNotificationAtive));
parameterCollection.Add(new KeyValuePair<string, object>("@OrdersNotificationCount", saveUpdateInfo.OrdersNotificationCount));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_NotificationSaveUpdateSettings]", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
public void SaveTransactionLog(TransactionLogInfo tinfo)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@TransactionID", tinfo.TransactionID));
parameterCollection.Add(new KeyValuePair<string, object>("@PaymentGateWayID", tinfo.PaymentGatewayID));
parameterCollection.Add(new KeyValuePair<string, object>("@PayerEmail", tinfo.PayerEmail));
parameterCollection.Add(new KeyValuePair<string, object>("@RecieverEmail", tinfo.RecieverEmail));
parameterCollection.Add(new KeyValuePair<string, object>("@TotalAmount", tinfo.TotalAmount));
parameterCollection.Add(new KeyValuePair<string, object>("@CurrencyCode", tinfo.CurrencyCode));
parameterCollection.Add(new KeyValuePair<string, object>("@PaymentStatus", tinfo.PaymentStatus));
parameterCollection.Add(new KeyValuePair<string, object>("@OrderID", tinfo.OrderID));
parameterCollection.Add(new KeyValuePair<string, object>("@CustomerID", tinfo.CustomerID));
parameterCollection.Add(new KeyValuePair<string, object>("@SessionCode", tinfo.SessionCode));
parameterCollection.Add(new KeyValuePair<string, object>("@ResponseCode", tinfo.ResponseCode));
parameterCollection.Add(new KeyValuePair<string, object>("@ResponseReasonText", tinfo.ResponseReasonText));
parameterCollection.Add(new KeyValuePair<string, object>("@AuthCode", tinfo.AuthCode));
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", tinfo.StoreID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", tinfo.PortalID));
parameterCollection.Add(new KeyValuePair<string, object>("@AddedBy", tinfo.AddedBy));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_SaveTransactionLog", parameterCollection);
}
catch (Exception ex)
{
throw ex;
}
}
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
{
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_StoreLocatorLocationUpdate", parameterCollection);
return true;
}
catch (Exception e)
{
return false;
throw e;
}
}
public void AddUpdateUserAddress(int addressID, int customerID, string firstName, string lastName, string email, string company,
string address1, string address2, string city, string state, string zip, string phone, string mobile,
string fax,string webSite,string countryName, bool isDefaultShipping, bool isDefaultBilling, int storeID, int portalID, string userName, string cultureName)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@AddressID", addressID));
parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID));
parameter.Add(new KeyValuePair<string, object>("@FirstName", firstName));
parameter.Add(new KeyValuePair<string, object>("@LastName", lastName));
parameter.Add(new KeyValuePair<string, object>("@Email", email));
parameter.Add(new KeyValuePair<string, object>("@Company", company));
parameter.Add(new KeyValuePair<string, object>("@Address1", address1));
parameter.Add(new KeyValuePair<string,object>("@Address2",address2));
parameter.Add(new KeyValuePair<string, object>("@City", city));
parameter.Add(new KeyValuePair<string, object>("@State", state));
parameter.Add(new KeyValuePair<string, object>("@Zip", zip));
parameter.Add(new KeyValuePair<string, object>("@Phone", phone));
parameter.Add(new KeyValuePair<string, object>("@Mobile", mobile));
parameter.Add(new KeyValuePair<string, object>("@Fax", fax));
parameter.Add(new KeyValuePair<string, object>("@WebSite", webSite));
parameter.Add(new KeyValuePair<string, object>("@Country", countryName));
parameter.Add(new KeyValuePair<string, object>("@IsDefaultShipping", isDefaultShipping));
parameter.Add(new KeyValuePair<string, object>("@IsDefaultBilling", isDefaultBilling));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", userName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateUserAddress", parameter);
}
public void AddUpdateSageFrameSearchSetting(SageFrameSearchSettingInfo objSearchSettingInfo, int PortalID, string CultureName, string AddedBy)
{
try
{
string SettingKeys = string.Empty;
string SettingValues = string.Empty;
//Pre pare Key value for the save;
SettingKeys = "SearchButtonType#SearchButtonText#SearchButtonImage#SearchResultPerPage#SearchResultPageName#MaxSearchChracterAllowedWithSpace";
SettingValues = objSearchSettingInfo.SearchButtonType.ToString() + "#" + objSearchSettingInfo.SearchButtonText + "#" +
objSearchSettingInfo.SearchButtonImage + "#" + objSearchSettingInfo.SearchResultPerPage.ToString() +
"#" + objSearchSettingInfo.SearchResultPageName +
"#" + objSearchSettingInfo.MaxSearchChracterAllowedWithSpace.ToString();
List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>();
ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingKeys", SettingKeys));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingValues", SettingValues));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@CultureName", CultureName));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID.ToString()));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@AddedBy", AddedBy));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("dbo.sp_SageFrameSearchSettingValueAddUpdate", ParaMeterCollection);
}
catch (Exception e)
{
throw e;
}
}
public void SaveLinks(List<CDNInfo> objInfo)
{
SQLHandler sagesql = new SQLHandler();
string sp = "[dbo].[usp_CDNSaveLink]";
foreach (CDNInfo cdn in objInfo)
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@URL", cdn.URL));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsJS", cdn.IsJS));
ParamCollInput.Add(new KeyValuePair<string, object>("@URLOrder", cdn.URLOrder));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", cdn.PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@Mode", cdn.Mode));
try
{
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
}
public void SaveAndUpdateSpecialItemsSetting(AspxCommonInfo aspxCommonObj, SpecialItemsSettingKeyPairInfo specialObj)
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@SettingKeys", specialObj.SettingKey));
parameterCollection.Add(new KeyValuePair<string, object>("@SettingValues", specialObj.SettingValue));
SQLHandler sqlhandle = new SQLHandler();
sqlhandle.ExecuteNonQuery("[dbo].[usp_Aspx_SpecialItemsSettingsUpdate]", parameterCollection);
}
public static void AddUpdateSearchTerm(bool? hasData, string searchTerm, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@HasData", hasData));
parameter.Add(new KeyValuePair<string, object>("@SearchTerm", searchTerm));
SQLHandler sqlh = new SQLHandler();
sqlh.ExecuteNonQuery("usp_Aspx_AddUpdateSearchTerm", parameter);
}
public void ContactUsDeleteByID(int contactUsID, int portalID, string deletedBy)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ContactUsID", contactUsID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@DeletedBy", deletedBy));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("sp_ContactUsDeletebyID", ParaMeterCollection);
}
public static void SetHeaderSetting(string headerType, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
parameterCollection.Add(new KeyValuePair<string, object>("@HeaderType", headerType));
SQLHandler sqlhandle = new SQLHandler();
sqlhandle.ExecuteNonQuery("[usp_Aspx_UpdateHeaderSettings]", parameterCollection);
}
public static void DeleteWareHouse(int wareHouseId, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSP(aspxCommonObj);
paramCol.Add(new KeyValuePair<string, object>("@WareHouseID", wareHouseId));
SQLHandler sageSQL = new SQLHandler();
sageSQL.ExecuteNonQuery("[usp_Aspx_DeleteAspx_WareHouse]", paramCol);
}
public void AddUpdateSearchTerm(string searchTerm, int storeID, int portalID, string userName, string cultureName)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@SearchTerm", searchTerm));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", userName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
SQLHandler sqlh = new SQLHandler();
sqlh.ExecuteNonQuery("usp_Aspx_AddUpdateSearchTerm", parameter);
}
public void AddToCart(int itemID, int storeID, int portalID, string userName, string cultureName)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@ItemID", itemID));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", userName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddToCart", parameter);
}
public void DeleteAddressBookDetails(int addressID, int storeID, int portalID, string userName, string cultureName)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@AddressID", addressID));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", userName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_DeleteAddressBook", parameter);
}
public void DeleteSearchTerm(string Ids, int storeID, int portalID,string userName, string cultureName)
{
List<KeyValuePair<string, object>> ParaMeter = new List<KeyValuePair<string, object>>();
ParaMeter.Add(new KeyValuePair<string, object>("@SearchTermID", Ids));
ParaMeter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
ParaMeter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
ParaMeter.Add(new KeyValuePair<string, object>("@UserName", userName));
ParaMeter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
SQLHandler sqLH = new SQLHandler();
sqLH.ExecuteNonQuery("usp_ASPX_DeleteSearchTerm", ParaMeter);
}
public void DeleteAddressBookDetails(int addressID,AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@AddressID", addressID));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_DeleteAddressBook", parameter);
}
public void AddUpdateSearchTerm(string searchTerm,AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@SearchTerm", searchTerm));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlh = new SQLHandler();
sqlh.ExecuteNonQuery("usp_Aspx_AddUpdateSearchTerm", parameter);
}
public void ContactUsAdd(string name, string email, string message, bool isActive, int portalID, string addedBy)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Name", name));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Email", email));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Message", message));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedBy", addedBy));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("sp_ContactUsAdd", ParaMeterCollection);
}
public void ExecuteModuleDataCleanupScript()
{
try
{
SQLHandler SQLH = new SQLHandler();
SQLH.ExecuteNonQuery("[dbo].[usp_sagecleanup]");
}
catch (Exception)
{
throw;
}
}
public static int AddBillingAddress(OrderDetailsCollection orderData, SqlTransaction tran)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@CustomerID", orderData.ObjOrderDetails.CustomerID));
parameter.Add(new KeyValuePair <string, object>("@SessionCode", orderData.ObjOrderDetails.SessionCode));
parameter.Add(new KeyValuePair <string, object>("@FirstName", orderData.ObjBillingAddressInfo.FirstName));
parameter.Add(new KeyValuePair <string, object>("@LastName", orderData.ObjBillingAddressInfo.LastName));
parameter.Add(new KeyValuePair <string, object>("@Email", orderData.ObjBillingAddressInfo.EmailAddress));
parameter.Add(new KeyValuePair <string, object>("@Company", orderData.ObjBillingAddressInfo.CompanyName));
parameter.Add(new KeyValuePair <string, object>("@Address1", orderData.ObjBillingAddressInfo.Address));
parameter.Add(new KeyValuePair <string, object>("@Address2", orderData.ObjBillingAddressInfo.Address2));
parameter.Add(new KeyValuePair <string, object>("@City", orderData.ObjBillingAddressInfo.City));
parameter.Add(new KeyValuePair <string, object>("@State", orderData.ObjBillingAddressInfo.State));
parameter.Add(new KeyValuePair <string, object>("@Country", orderData.ObjBillingAddressInfo.Country));
parameter.Add(new KeyValuePair <string, object>("@Zip", orderData.ObjBillingAddressInfo.Zip));
parameter.Add(new KeyValuePair <string, object>("@Phone", orderData.ObjBillingAddressInfo.Phone));
parameter.Add(new KeyValuePair <string, object>("@Mobile", orderData.ObjBillingAddressInfo.Mobile));
parameter.Add(new KeyValuePair <string, object>("@Fax", orderData.ObjBillingAddressInfo.Fax));
parameter.Add(new KeyValuePair <string, object>("@WebSite", orderData.ObjBillingAddressInfo.WebSite));
parameter.Add(new KeyValuePair <string, object>("@UserName", orderData.ObjBillingAddressInfo.EmailAddress));
parameter.Add(new KeyValuePair <string, object>("@IsDefault", orderData.ObjBillingAddressInfo.IsDefaultBilling));
parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID));
parameter.Add(new KeyValuePair <string, object>("@CultureName", orderData.ObjCommonInfo.CultureName));
parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy));
SQLHandler sqlH = new SQLHandler();
int billingAddressID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure,
"usp_Aspx_BillingAddress", parameter,
"@UserBillingAddressID");
return(billingAddressID);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdatePortal(int PortalID, string PortalName, bool IsParent, string UserName)
{
string sp = "[dbo].[sp_PortalUpdate]";
SQLHandler SQLH = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalName", PortalName));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsParent", IsParent));
ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", UserName));
SQLH.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception ex)
{
throw ex;
}
}
public static void CreateLog(int giftcardId, int storeId, int portalId, decimal amount, string userName)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@GiftCardId", giftcardId));
parameter.Add(new KeyValuePair <string, object>("@Amount", amount));
parameter.Add(new KeyValuePair <string, object>("@UsedAmount", 0));
parameter.Add(new KeyValuePair <string, object>("@Balance", amount));
parameter.Add(new KeyValuePair <string, object>("@Note", "Created by User:"******"@StoreId", storeId));
parameter.Add(new KeyValuePair <string, object>("@PortalId", portalId));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_LogGiftCardHistory ", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static void AddModuleMessage(ModuleMessageInfo objModuleMessage)
{
try
{
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleID", objModuleMessage.ModuleID));
ParamCollInput.Add(new KeyValuePair <string, object>("@Message", objModuleMessage.Message));
ParamCollInput.Add(new KeyValuePair <string, object>("@Culture", objModuleMessage.Culture));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", objModuleMessage.IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@MessageType", objModuleMessage.MessageType));
ParamCollInput.Add(new KeyValuePair <string, object>("@MessageMode", objModuleMessage.MessageMode));
ParamCollInput.Add(new KeyValuePair <string, object>("@MessagePosition", objModuleMessage.MessagePosition));
SQLH.ExecuteNonQuery("[dbo].[usp_ModuleMessageAdd]", ParamCollInput);
}
catch (Exception)
{
throw;
}
}
//-------------------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;
}
}
internal int SaveSEOMetaTag(int pageID, DataTable metaTagTable, string seoValue, int portalID, string userName)
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@PageID", pageID));
param.Add(new KeyValuePair <string, object>("@SEOValue", seoValue));
param.Add(new KeyValuePair <string, object>("@MetaTagTable", metaTagTable));
param.Add(new KeyValuePair <string, object>("@PortalID", portalID));
param.Add(new KeyValuePair <string, object>("@UserName", userName));
SQLHandler sagesql = new SQLHandler();
try
{
return(sagesql.ExecuteNonQuery("[dbo].[usp_SEO_SaveSEOMetaValues]", param, "@output"));
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// Connects to database and adds or updates the adsense setting name and values
/// </summary>
/// <param name="UserModuleID">userModuleID</param>
/// <param name="SettingName">Setting key</param>
/// <param name="SettingValue">Setting value</param>
/// <param name="IsActive">Set true if the adsense is active</param>
/// <param name="PortalID">portalID</param>
/// <param name="UpdatedBy">the user who us updating the value in database</param>
/// <param name="UpdateFlag"> Update flag</param>
public void AddUpdateAdSense(int UserModuleID, string SettingName, string SettingValue, bool IsActive, int PortalID, string UpdatedBy, bool UpdateFlag)
{
try
{
string sp = "[dbo].[sp_AdSenseAddUpdate]";
SQLHandler sagesql = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@UserModuleID", UserModuleID));
ParamCollInput.Add(new KeyValuePair <string, object>("@SettingName", SettingName));
ParamCollInput.Add(new KeyValuePair <string, object>("@SettingValue", SettingValue));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@UpdatedBy", UpdatedBy));
ParamCollInput.Add(new KeyValuePair <string, object>("@UpdateFlag", UpdateFlag));
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
//----------------- 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 void CartPriceRuleRoleAdd(CartPriceRuleRole cartPriceRuleRole, SqlTransaction tran, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleRole.CartPriceRuleID));
parameter.Add(new KeyValuePair <string, object>("@RoleID", cartPriceRuleRole.RoleID));
parameter.Add(new KeyValuePair <string, object>("@IsActive", true));
parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlH = new SQLHandler();
try
{
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[dbo].[usp_Aspx_CartPriceRuleRoleAdd]", parameter);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Connects to database and updates profile display order only if it is active .
/// </summary>
/// <param name="ProfileID">Profile ID.</param>
/// <param name="DisplayOrder">Display order.</param>
/// <param name="IsActive">Set true if profile is active.</param>
/// <param name="UpdatedOn">Profile updated date.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="Username">User's name.</param>
public void UpdateProfileDisplayOrderAndIsActiveOnly(int ProfileID, int DisplayOrder, bool IsActive, DateTime UpdatedOn, int PortalID, string Username)
{
try
{
string sp = "[dbo].[sp_ProfileUpdateDisplayOrderAndIsActiveOnly]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ProfileID", ProfileID));
ParamCollInput.Add(new KeyValuePair <string, object>("@DisplayOrder", DisplayOrder));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@UpdatedOn", UpdatedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@UpdatedBy", Username));
SQLH.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
public int UpdateSettings(WebBuilderInfo objWebBuilder)
{
int webbuilderID = 0;
try
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@PortalID", objWebBuilder.PortalID));
param.Add(new KeyValuePair <string, object>("@UserModuleID", objWebBuilder.UserModuleID));
param.Add(new KeyValuePair <string, object>("@Culture", objWebBuilder.Culture));
param.Add(new KeyValuePair <string, object>("@Settings", objWebBuilder.Settings));
param.Add(new KeyValuePair <string, object>("@PageName", objWebBuilder.PageName));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("[dbo].[usp_WebBuilder_UpdateSettings]", param);
}
catch
{
throw;
}
return(webbuilderID);
}
public static void UpdatePortalModules(string ModuleIDs, string IsActives, int PortalID, string UpdatedBy)
{
string sp = "[dbo].[sp_PortalModulesUpdate]";
SQLHandler SQLH = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleIDs", ModuleIDs));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActives", IsActives));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@UpdatedBy", UpdatedBy));
SQLH.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and saves URL loading order of CDN links
/// </summary>
/// <param name="objOrder"> List of CDNInfo objects</param>
public void SaveOrder(List <CDNInfo> objOrder)
{
SQLHandler sagesql = new SQLHandler();
string sp = "[dbo].[usp_CDNSaveOrder]";
foreach (CDNInfo cdn in objOrder)
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@URLID", cdn.URLID));
ParamCollInput.Add(new KeyValuePair <string, object>("@URLOrder", cdn.URLOrder));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", cdn.PortalID));
try
{
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
}
public void SaveUserAgentMode(string AgentMode, int PortalID, string UserName, DateTime ChangeDate, bool IsActive)
{
string sp = "[dbo].[usp_UserAgentSaveType]";
SQLHandler sagesql = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@AgentMode", AgentMode));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@ChangedBy", UserName));
ParamCollInput.Add(new KeyValuePair <string, object>("@ChangedDate", ChangeDate));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
try
{
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
public void HtmlCommentUpdate(object HTMLCommentID, string Comment, bool IsApproved, bool IsActive, bool IsModified, DateTime UpdatedOn, int PortalID, string UpdatedBy)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@HTMLCommentID", HTMLCommentID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@Comment", Comment));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@IsApproved", IsApproved));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@IsModified", IsModified));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UpdatedOn", UpdatedOn));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UpdatedBy", UpdatedBy));
SQLHandler sq = new SQLHandler();
sq.ExecuteNonQuery("dbo.sp_HtmlCommentUpdate", ParaMeterCollection);
}
catch (Exception e)
{
throw e;
}
}
public static void OrderTaxRuleMapping(int itemID, int orderID, int taxManageRuleID, decimal taxSubTotal, int storeID, int portalID, string addedBy, string costVariantValueIDs)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("@OrderID", orderID));
parameter.Add(new KeyValuePair <string, object>("@TaxManageRuleID", taxManageRuleID));
parameter.Add(new KeyValuePair <string, object>("@TaxSubTotal", taxSubTotal));
parameter.Add(new KeyValuePair <string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair <string, object>("@AddedBy", addedBy));
parameter.Add(new KeyValuePair <string, object>("@CostVariantsValueIDs", costVariantValueIDs));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_OrderTaxRuleMapping", parameter);
}
catch (Exception e)
{
throw e;
}
}
//public List<ItemsInfoSettings> ReturnItemsList(int portalID, int storeID, string userName, string culture)
//{
// List<ItemsInfoSettings> itemsInfo = new List<ItemsInfoSettings>();
// List<KeyValuePair<string, object>> paramCollection = new List<KeyValuePair<string, object>>();
// paramCollection.Add(new KeyValuePair<string, object>("@StoreID", storeID));
// paramCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID));
// paramCollection.Add(new KeyValuePair<string, object>("@UserName", userName));
// paramCollection.Add(new KeyValuePair<string, object>("@Culture", culture));
// SQLHandler sageSql = new SQLHandler();
// itemsInfo = sageSql.ExecuteAsList<ItemsInfoSettings>("[dbo].[usp_Aspx_GetAllItemsName]", paramCollection);
// return itemsInfo;
//}
public void SaveImageSettings(int itemID, string imgName, string isActive, string imageType, string description, string displayOrder)
{
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", itemID));
parameterCollection.Add(new KeyValuePair <string, object>("@PathList", imgName));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", isActive));
parameterCollection.Add(new KeyValuePair <string, object>("@ImageType", imageType));
parameterCollection.Add(new KeyValuePair <string, object>("@AlternateText", description));
parameterCollection.Add(new KeyValuePair <string, object>("@DisplayOrder", displayOrder));
try
{
SQLHandler sageSql = new SQLHandler();
sageSql.ExecuteNonQuery("[dbo].[usp_Aspx_InsertUpdateImageSettings]", parameterCollection);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update menu.
/// </summary>
/// <param name="lstMenuPermissions">List of MenuPermissionInfo class.</param>
/// <param name="MenuID">MenuID</param>
/// <param name="MenuName">Menu name.</param>
/// <param name="MenuType">Menu type.</param>
/// <param name="IsDefault">true if default menu.</param>
/// <param name="PortalID">PortalID</param>
public static void UpdateMenu(List <MenuPermissionInfo> lstMenuPermissions, int MenuID, string MenuName, string MenuType, bool IsDefault, int PortalID)
{
string sp = "[dbo].[usp_MenuMgrUpdateMenu]";
SQLHandler sagesql = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@MenuName", MenuName));
ParamCollInput.Add(new KeyValuePair <string, object>("@MenuType", MenuType));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsDefault", IsDefault));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@MenuID", MenuID));
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
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;
}
}
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));
SQLHandler sageSQL = new SQLHandler();
sageSQL.ExecuteNonQuery("[usp_Aspx_InsertUpdateAspx_WareHouse]", paramCol);
}
internal int AddUpdatePerformanceCounterItem(int performanceID, int userModuleID, int mTypeAttributeMapID)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PerformanceCounterID", performanceID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UserModuleID", userModuleID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@MediaTypeAttributeMapID", mTypeAttributeMapID));
string outputParam = "@ReturnCode";
SQLHandler sagesql = new SQLHandler();
int result = sagesql.ExecuteNonQuery(SPName.AddUpdatePerformanceCounter, ParaMeterCollection, outputParam);
return(result);
}
catch (Exception)
{
return(-1);
}
}
internal int SavePageRating(int userModuleID, int portalID, string pageName, double ratingPoint, string userName)
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@PageName", pageName));
param.Add(new KeyValuePair <string, object>("@RatingPoint", ratingPoint));
param.Add(new KeyValuePair <string, object>("@UserModuleID", userModuleID));
param.Add(new KeyValuePair <string, object>("@PortalID", portalID));
param.Add(new KeyValuePair <string, object>("@UserName", userName));
SQLHandler sagesql = new SQLHandler();
try
{
return(sagesql.ExecuteNonQuery("[dbo].[usp_Rating_SavePageRating]", param, "@output"));
}
catch
{
throw;
}
}
public static void AddUpdateCouponSettingKey(int ID, string settingKey, int validationTypeID, string isActive, int storeID, int portalID, string cultureName, string userName)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@ID", ID));
parameter.Add(new KeyValuePair <string, object>("@SettingKey", settingKey));
parameter.Add(new KeyValuePair <string, object>("@ValidationTypeID", validationTypeID));
parameter.Add(new KeyValuePair <string, object>("@IsActive", isActive));
parameter.Add(new KeyValuePair <string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair <string, object>("@CultureName", cultureName));
parameter.Add(new KeyValuePair <string, object>("@UserName", userName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateCouponSettingKey", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void CartPriceRuleStoreAdd(CartPriceRuleStore cartPriceRuleStore, SqlTransaction tran, Int32 portalID, string userName, string culture)
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleStore.CartPriceRuleID));
parameter.Add(new KeyValuePair <string, object>("@StoreID", cartPriceRuleStore.StoreID));
parameter.Add(new KeyValuePair <string, object>("@IsActive", true));
parameter.Add(new KeyValuePair <string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair <string, object>("@Username", userName));
parameter.Add(new KeyValuePair <string, object>("@CultureName", culture));
try
{
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_CartPriceRuleStoreAdd", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static void RewardPointsDeleteNewsLetter(RewardPointsNLCommonInfo rewardPointsInfo,
AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@RewardRuleID", rewardPointsInfo.RewardRuleID));
parameterCollection.Add(new KeyValuePair <string, object>("@CustomerID", aspxCommonObj.CustomerID));
parameterCollection.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsDeleteNewsLetter", parameterCollection);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connect to database and sort menu.
/// </summary>
/// <param name="MenuItemID">MenuItemID</param>
/// <param name="ParentID">Menu item parent ID.</param>
/// <param name="BeforeID">Previous MenuItemID.</param>
/// <param name="AfterID">Next MenuItemID.</param>
/// <param name="PortalID">PortalID</param>
public static void SortMenu(int MenuItemID, int ParentID, int BeforeID, int AfterID, int PortalID)
{
string sp = "[dbo].[usp_MenuMgrSortMenu]";
SQLHandler sagesql = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@MenuItemID", MenuItemID));
ParamCollInput.Add(new KeyValuePair <string, object>("@ParentID", ParentID));
ParamCollInput.Add(new KeyValuePair <string, object>("@BeforeID", BeforeID));
ParamCollInput.Add(new KeyValuePair <string, object>("@AfterID", AfterID));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and updates extension
/// </summary>
/// <param name="objInfo">ModuleInfo object</param>
public void UpdateExtension(ModuleInfo objInfo)
{
string sp = "[dbo].[sp_ExtensionUpdate]";
SQLHandler sagesql = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleID", objInfo.ModuleID));
ParamCollInput.Add(new KeyValuePair <string, object>("@FolderName", objInfo.FolderName));
ParamCollInput.Add(new KeyValuePair <string, object>("@BusinessControllerClass", objInfo.BusinessControllerClass));
ParamCollInput.Add(new KeyValuePair <string, object>("@Dependencies", objInfo.dependencies));
ParamCollInput.Add(new KeyValuePair <string, object>("@Permissions", objInfo.permissions));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsPortable", objInfo.IsPortable));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsSearchable", objInfo.IsSearchable));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsUpgradable", objInfo.IsUpgradable));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsPremium", objInfo.isPremium));
ParamCollInput.Add(new KeyValuePair <string, object>("@PackageName", objInfo.PackageName));
ParamCollInput.Add(new KeyValuePair <string, object>("@PackageDescription", objInfo.PackageDescription));
ParamCollInput.Add(new KeyValuePair <string, object>("@Version", objInfo.Version));
ParamCollInput.Add(new KeyValuePair <string, object>("@License", objInfo.License));
ParamCollInput.Add(new KeyValuePair <string, object>("@ReleaseNotes", objInfo.ReleaseNotes));
ParamCollInput.Add(new KeyValuePair <string, object>("@Owner", objInfo.Owner));
ParamCollInput.Add(new KeyValuePair <string, object>("@Organization", objInfo.Organization));
ParamCollInput.Add(new KeyValuePair <string, object>("@Url", objInfo.URL));
ParamCollInput.Add(new KeyValuePair <string, object>("@Email", objInfo.Email));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", objInfo.PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", objInfo.Username));
sagesql.ExecuteNonQuery(sp, ParamCollInput);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and adds or updates SageFrame search
/// </summary>
/// <param name="objInfo">Object of SageFrameSearchProcedureInfo class.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Search added user's name.</param>
public void SageFrameSearchProcedureAddUpdate(SageFrameSearchProcedureInfo objInfo, int PortalID, string AddedBy)
{
try
{
List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >();
ParaMeterCollection.Add(new KeyValuePair <string, string>("@SageFrameSearchProcedureID", objInfo.SageFrameSearchProcedureID.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@SageFrameSearchTitle", objInfo.SageFrameSearchTitle));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@SageFrameSearchProcedureName", objInfo.SageFrameSearchProcedureName.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@SageFrameSearchProcedureExecuteAs", objInfo.SageFrameSearchProcedureExecuteAs));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@IsActive", objInfo.IsActive.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@AddedOn", objInfo.AddedOn.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", PortalID.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@AddedBy", AddedBy));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("dbo.sp_SageFrameSearchProcedureAddUpdate", ParaMeterCollection);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateOrderDetails(OrderDetailsCollection orderData)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@TransactionID", orderData.ObjOrderDetails.TransactionID));
parameter.Add(new KeyValuePair <string, object>("@OrderStatusID", orderData.ObjOrderDetails.OrderStatusID));
parameter.Add(new KeyValuePair <string, object>("@ResponseCode", orderData.ObjOrderDetails.ResponseCode));
parameter.Add(new KeyValuePair <string, object>("@ResponseReasonCode", orderData.ObjOrderDetails.ResponseReasonCode));
parameter.Add(new KeyValuePair <string, object>("@ResponseReasonText", orderData.ObjOrderDetails.ResponseReasonText));
parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID));
parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy));
parameter.Add(new KeyValuePair <string, object>("@OrderID", orderData.ObjOrderDetails.OrderID));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_UpdateOrderDetails]", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void MenuPageUpdate(string MenuIDs, SqlTransaction tran, int pageID)
{
try
{
string[] menuArr = MenuIDs.Split(',');
List <KeyValuePair <string, object> > ParaMeterColl = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("@MenuIDs",
MenuIDs),
new KeyValuePair <string, object>("@PageID",
pageID)
};
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[dbo].[usp_PageManagerMenuPageUpdate]",
ParaMeterColl);
}
catch (Exception ex)
{
throw ex;
}
}