public static int AddItemstoCart(int itemID, decimal itemPrice, int itemQuantity, bool isItemPage, 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();
int i;
if (isItemPage)
{
i = sqlH.ExecuteNonQueryAsGivenType <int>("usp_Aspx_CheckCostVariantForItemDetail", parameter, "@IsExist");
}
else
{
i = sqlH.ExecuteNonQueryAsGivenType <int>("usp_Aspx_CheckCostVariantForItem", parameter, "@IsExist");
}
return(i);
}
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));
parameter.Add(new KeyValuePair <string, object>("@isItemPage", isItemPage));
SQLHandler sqlH = new SQLHandler();
int i;
if (isItemPage)
{
i = sqlH.ExecuteNonQueryAsGivenType <int>("usp_Aspx_CheckCostVariantForItemDetail", parameter, "@IsExist");
}
else
{
i = sqlH.ExecuteNonQueryAsGivenType <int>("usp_Aspx_CheckCostVariantForItem", parameter, "@IsExist");
}
return(i);
}
else
{
return(2);
}
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Connects to database and saves module control.
/// </summary>
/// <param name="ModuleDefID">Module's definition ID.</param>
/// <param name="ControlKey">Control's key.</param>
/// <param name="ControlTitle">Control's title.</param>
/// <param name="ControlSrc">Control's source.</param>
/// <param name="IconFile">Control's icon file.</param>
/// <param name="ControlType">Control's type.</param>
/// <param name="DisplayOrder">Control's display order.</param>
/// <param name="HelpUrl">Controls help URL.</param>
/// <param name="SupportsPartialRendering">Set true if the controls need to have partial rendering.</param>
/// <param name="IsActive">Set true if the control is active.</param>
/// <param name="AddedOn">Control adde date.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Control added user's name.</param>
/// <returns>Returns registered ModuleControlID.</returns>
public int AddModuleCoontrols(int?ModuleDefID, string ControlKey, string ControlTitle, string ControlSrc, string IconFile, int ControlType, int DisplayOrder, string HelpUrl, bool SupportsPartialRendering, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
string sp = "[dbo].[sp_ModuleControlsAdd]";
SQLHandler sagesql = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleDefID", ModuleDefID));
ParamCollInput.Add(new KeyValuePair <string, object>("@ControlKey", ControlKey));
ParamCollInput.Add(new KeyValuePair <string, object>("@ControlTitle", ControlTitle));
ParamCollInput.Add(new KeyValuePair <string, object>("@ControlSrc", ControlSrc));
ParamCollInput.Add(new KeyValuePair <string, object>("@IconFile", IconFile));
ParamCollInput.Add(new KeyValuePair <string, object>("@ControlType", ControlType));
ParamCollInput.Add(new KeyValuePair <string, object>("@DisplayOrder", DisplayOrder));
ParamCollInput.Add(new KeyValuePair <string, object>("@HelpUrl", HelpUrl));
ParamCollInput.Add(new KeyValuePair <string, object>("@SupportsPartialRendering", SupportsPartialRendering));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", AddedBy));
int MCID = sagesql.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@ModuleControlID");
return(MCID);
}
catch (Exception)
{
throw;
}
}
public static int AddNewLetterSubscribers(string Email, string ClientIP, bool IsActive, string AddedBy, DateTime AddedOn, int PortalID)
{
string sp = "[dbo].[sp_NewLetterSubscribersAdd]";
SQLHandler sagesql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@Email", Email));
ParamCollInput.Add(new KeyValuePair<string, object>("@ClientIP", ClientIP));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
int NSID = sagesql.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@NewLetterSubscribersID");
return NSID;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and adds message template.
/// </summary>
/// <param name="MessageTemplateTypeID">Message template type ID.</param>
/// <param name="Subject">Email subject.</param>
/// <param name="Body">Email body.</param>
/// <param name="MailFrom">Email from.</param>
/// <param name="IsActive">Set true if email is active</param>
/// <param name="AddedOn">Message added date.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Message added by.</param>
/// <param name="CurrentCulture">Culture name.</param>
/// <returns>Returns message template ID</returns>
public int AddMessageTemplate(int MessageTemplateTypeID, string Subject, string Body, string MailFrom, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy, string CurrentCulture)
{
try
{
string sp = "[dbo].[sp_MessageTemplateAdd]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@MessageTemplateTypeID", MessageTemplateTypeID));
ParamCollInput.Add(new KeyValuePair <string, object>("@Subject", Subject));
ParamCollInput.Add(new KeyValuePair <string, object>("@Body", Body));
ParamCollInput.Add(new KeyValuePair <string, object>("@MailFrom", MailFrom));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", AddedBy));
ParamCollInput.Add(new KeyValuePair <string, object>("@CurrentCulture", CurrentCulture));
return(SQLH.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@MessageTemplateID"));
}
catch (Exception)
{
throw;
}
}
public static int AddNewList(ListInfo objList)
{
string sp = "[dbo].[usp_ListEntryAdd]";
SQLHandler sagesql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ListName", objList.ListName));
ParamCollInput.Add(new KeyValuePair<string, object>("@Value", objList.Value));
ParamCollInput.Add(new KeyValuePair<string, object>("@Text", objList.Text));
ParamCollInput.Add(new KeyValuePair<string, object>("@ParentID", objList.ParentID));
ParamCollInput.Add(new KeyValuePair<string, object>("@Level", objList.Level));
ParamCollInput.Add(new KeyValuePair<string, object>("@CurrencyCode", objList.CurrencyCode));
ParamCollInput.Add(new KeyValuePair<string, object>("@DisplayLocale", objList.DisplayLocale));
ParamCollInput.Add(new KeyValuePair<string, object>("@EnableDisplayOrder", objList.EnableDisplayOrder));
ParamCollInput.Add(new KeyValuePair<string, object>("@DefinitionID", objList.DefinitionID));
ParamCollInput.Add(new KeyValuePair<string, object>("@Description", objList.Description));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", objList.PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", objList.IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", objList.AddedBy));
ParamCollInput.Add(new KeyValuePair<string, object>("@Culture", objList.Culture));
int ListID = sagesql.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@ListID");
return ListID;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and adds new list.
/// </summary>
/// <param name="objList">Object of class ListInfo.</param>
/// <returns>Returns entry ID if the list is insterted successfully.</returns>
public int AddNewList(ListInfo objList)
{
string sp = "[dbo].[usp_ListEntryAdd]";
SQLHandler sagesql = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ListName", objList.ListName));
ParamCollInput.Add(new KeyValuePair <string, object>("@Value", objList.Value));
ParamCollInput.Add(new KeyValuePair <string, object>("@Text", objList.Text));
ParamCollInput.Add(new KeyValuePair <string, object>("@ParentID", objList.ParentID));
ParamCollInput.Add(new KeyValuePair <string, object>("@Level", objList.Level));
ParamCollInput.Add(new KeyValuePair <string, object>("@CurrencyCode", objList.CurrencyCode));
ParamCollInput.Add(new KeyValuePair <string, object>("@DisplayLocale", objList.DisplayLocale));
ParamCollInput.Add(new KeyValuePair <string, object>("@EnableDisplayOrder", objList.EnableDisplayOrder));
ParamCollInput.Add(new KeyValuePair <string, object>("@DefinitionID", objList.DefinitionID));
ParamCollInput.Add(new KeyValuePair <string, object>("@Description", objList.Description));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", objList.PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", objList.IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", objList.AddedBy));
ParamCollInput.Add(new KeyValuePair <string, object>("@Culture", objList.Culture));
int ListID = sagesql.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@ListID");
return(ListID);
}
catch (Exception)
{
throw;
}
}
public static int AddNewLetterSubscribers(string Email, string ClientIP, bool IsActive, string AddedBy, DateTime AddedOn, int PortalID)
{
string sp = "[dbo].[sp_NewLetterSubscribersAdd]";
SQLHandler sagesql = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@Email", Email));
ParamCollInput.Add(new KeyValuePair <string, object>("@ClientIP", ClientIP));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", AddedBy));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
int NSID = sagesql.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@NewLetterSubscribersID");
return(NSID);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and adds user's profile.
/// </summary>
/// <param name="Name">User's name.</param>
/// <param name="PropertyTypeID">Property type ID.</param>
/// <param name="DataType">Data type.</param>
/// <param name="IsRequired">Set true if profile is required.</param>
/// <param name="IsActive">Set true if profile is active.</param>
/// <param name="AddedOn">Profile added date.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Profile added user's name.</param>
/// <returns>Returns ProfileID</returns>
public int AddProfile(string Name, int PropertyTypeID, string DataType, bool IsRequired, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
try
{
string sp = "[dbo].[sp_ProfileAdd]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@Name", Name));
ParamCollInput.Add(new KeyValuePair <string, object>("@PropertyTypeID", PropertyTypeID));
ParamCollInput.Add(new KeyValuePair <string, object>("@DataType", DataType));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsRequired", IsRequired));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", AddedBy));
int PID = SQLH.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@ProfileID");
return(PID);
}
catch (Exception)
{
throw;
}
}
public static bool CheckReviewByUser(int itemID, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemID", itemID));
SQLHandler sqlH = new SQLHandler();
bool isReviewExist = sqlH.ExecuteNonQueryAsGivenType <bool>("usp_Aspx_CheckReviewAlreadyExist", parameter, "@IsReviewAlreadyExist");
return(isReviewExist);
}
public static bool CheckUniqueCouponCode(string couponCode, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponCode));
SQLHandler sqlH = new SQLHandler();
bool isExists = sqlH.ExecuteNonQueryAsGivenType <bool>("dbo.usp_Aspx_CheckUniqueCouponCode", parameter, "@IsExist");
return(isExists);
}
//------------------------------Add to Cart--------------------------
public static bool CheckItemCart(int itemID, int storeID, int portalID, string costvarids)
{
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>("@ItemCostVariantIDs", costvarids));
SQLHandler sqlH = new SQLHandler();
bool isAllowed= sqlH.ExecuteNonQueryAsGivenType<bool>("[usp_Aspx_CheckCostVarintQuantityInCart]", parameter, "@IsAllowAddtoCart");
return isAllowed;
}
//------------------------------Add to Cart--------------------------
public static bool CheckItemCart(int itemID, int storeID, int portalID, string costvarids)
{
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>("@ItemCostVariantIDs", costvarids));
SQLHandler sqlH = new SQLHandler();
bool isAllowed= sqlH.ExecuteNonQueryAsGivenType<bool>("[usp_Aspx_CheckCostVarintQuantityInCart]", parameter, "@IsAllowAddtoCart");
return isAllowed;
}
public bool CheckCart(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();
return sqlH.ExecuteNonQueryAsGivenType<bool>("[usp_Aspx_CheckCart]", parameter, "@IsExist");
}
public bool CheckCart(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();
return(sqlH.ExecuteNonQueryAsGivenType <bool>("[usp_Aspx_CheckCart]", parameter, "@IsExist"));
}
//Cart Item Qty Discount Calculations
public static decimal GetDiscountQuantityAmount(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetFullParam(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
decimal qtyDiscount= sqlH.ExecuteNonQueryAsGivenType<decimal>("usp_Aspx_GetItemQuantityDiscountAmount", parameter, "@QtyDiscount");
return qtyDiscount;
}
catch (Exception e)
{
throw e;
}
}
public static bool CheckAddressAlreadyExist(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPSCt(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
bool isExist = sqlH.ExecuteNonQueryAsGivenType <bool>("usp_Aspx_CheckForMultipleAddress", parameter, "@IsExist");
return(isExist);
}
catch (Exception e)
{
throw e;
}
}
public static bool CheckUniqueCouponCode(string couponCode, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@CouponCode", couponCode));
SQLHandler sqlH = new SQLHandler();
bool isExists = sqlH.ExecuteNonQueryAsGivenType<bool>("dbo.usp_Aspx_CheckUniqueCouponCode", parameter, "@IsExist");
return isExists;
}
catch (Exception ex)
{
throw ex;
}
}
public static bool CheckIfItemIsGrouped(int itemID, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ItemID", itemID));
SQLHandler sqlH = new SQLHandler();
bool isGrouped = sqlH.ExecuteNonQueryAsGivenType<bool>("usp_Aspx_CheckIfGroupedItem", parameter, "@IsGrouped");
return isGrouped;
}
catch (Exception ex)
{
throw ex;
}
}
public static bool CheckIfItemIsGrouped(int itemID, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemID", itemID));
SQLHandler sqlH = new SQLHandler();
bool isGrouped = sqlH.ExecuteNonQueryAsGivenType <bool>("usp_Aspx_CheckIfGroupedItem", parameter, "@IsGrouped");
return(isGrouped);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool CheckItemOutOfStock(int itemID, string costVariantsValueIDs, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("@CostVariantsValueIDs", costVariantsValueIDs));
SQLHandler sqlH = new SQLHandler();
bool i = sqlH.ExecuteNonQueryAsGivenType <bool>("usp_Aspx_CheckItemOutOfStock", parameter, "@IsOutOfStock");
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
public bool CheckWishItems(int ID, string costVariantValueIDs, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemID", ID));
parameter.Add(new KeyValuePair <string, object>("@CostVariantValueIDs", costVariantValueIDs));
SQLHandler sqlH = new SQLHandler();
bool isExist = sqlH.ExecuteNonQueryAsGivenType <bool>("[usp_Aspx_CheckWishItems]", parameter, "@IsExist");
return(isExist);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Connects to database and inserts folder and returns its ID.
/// </summary>
/// <param name="folder">Object of Folder Class.</param>
/// <returns>FolderID if the folder is inserted succesfully</returns>
public static int AddFolderReturnFolderID(Folder folder)
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalId", folder.PortalId));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@ParentFolderID", folder.ParentID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@FolderPath", folder.FolderPath));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@StorageLocation", folder.StorageLocation));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UniqueId", folder.UniqueId));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@VersionGuid", folder.VersionGuid));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@IsActive", folder.IsActive));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@AddedBy", folder.AddedBy));
SQLHandler sagesql = new SQLHandler();
int FolderID = sagesql.ExecuteNonQueryAsGivenType <int>("[usp_FileManagerAddFolderRetFolderID]", ParaMeterCollection, "@FolderID");
return(FolderID);
}
//-------------------------Update Customer Account Information----------------------------------------
public static int UpdateCustomer(AspxCommonInfo aspxCommonObj, string firstName, string lastName, string email)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUCt(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@FirstName", firstName));
parameterCollection.Add(new KeyValuePair <string, object>("@LastName", lastName));
parameterCollection.Add(new KeyValuePair <string, object>("@Email", email));
SQLHandler sqlh = new SQLHandler();
int errorCode = sqlh.ExecuteNonQueryAsGivenType <int>("dbo.usp_Aspx_UpdateCustomer", parameterCollection, "@ErrorCode");
return(errorCode);
}
catch (Exception)
{
throw;
}
}
public static int AddFolderReturnFolderID(Folder folder)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalId", folder.PortalId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ParentFolderID", folder.ParentID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FolderPath", folder.FolderPath));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@StorageLocation", folder.StorageLocation));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UniqueId", folder.UniqueId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@VersionGuid", folder.VersionGuid));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", folder.IsActive));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedBy", folder.AddedBy));
SQLHandler sagesql = new SQLHandler();
int FolderID = sagesql.ExecuteNonQueryAsGivenType<int>("[usp_FileManagerAddFolderRetFolderID]", ParaMeterCollection, "@FolderID");
return FolderID;
}
//-------------------------Update Customer Account Information----------------------------------------
public static int UpdateCustomer(AspxCommonInfo aspxCommonObj, string firstName, string lastName, string email)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUCt(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@FirstName", firstName));
parameterCollection.Add(new KeyValuePair<string, object>("@LastName", lastName));
parameterCollection.Add(new KeyValuePair<string, object>("@Email", email));
SQLHandler sqlh = new SQLHandler();
int errorCode = sqlh.ExecuteNonQueryAsGivenType<int>("dbo.usp_Aspx_UpdateCustomer", parameterCollection, "@ErrorCode");
return errorCode;
}
catch (Exception)
{
throw;
}
}
public bool CheckWishItems(int ID, string costVariantValueIDs, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ItemID", ID));
parameter.Add(new KeyValuePair<string, object>("@CostVariantValueIDs", costVariantValueIDs));
SQLHandler sqlH = new SQLHandler();
bool isExist = sqlH.ExecuteNonQueryAsGivenType<bool>("[usp_Aspx_CheckWishItems]", parameter, "@IsExist");
return isExist;
}
catch (Exception e)
{
throw e;
}
}
public static string GetStoreSettingValueByKey(string settingKey, int storeID, int portalID, string cultureName)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@SettingKey", settingKey));
parameter.Add(new KeyValuePair <string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair <string, object>("@CultureName", cultureName));
SQLHandler sqlH = new SQLHandler();
string setValue = sqlH.ExecuteNonQueryAsGivenType <string>("usp_Aspx_GetStoreSettingValueBYKey", parameter, "@SettingValue");
return(setValue);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool CheckOutOfStock(int itemID, int storeID, int portalID, string itemCostVariantIDs)
{
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>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@ItemCostVariantIDs", itemCostVariantIDs));
SQLHandler sqlH = new SQLHandler();
bool isOutStock= sqlH.ExecuteNonQueryAsGivenType<bool>("[dbo].[usp_Aspx_CheckOutOfStockForCostVariants]", parameter, "@IsOutOfStock");
return isOutStock;
}
catch (Exception e)
{
throw e;
}
}
public static bool AddtoCart(int itemID, int storeID, int portalID, string userName, string cultureName)
{
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>("@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();
bool isExist = sqlH.ExecuteNonQueryAsGivenType <bool>("usp_Aspx_CheckCostVariantForItem", parameter, "@IsExist");
return(isExist);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Connects to database and counts adsense settings
/// </summary>
/// <param name="UserModuleID">userModuleID</param>
/// <param name="PortalID">portalID</param>
/// <returns>counts of adsense settings </returns>
public int CountAdsenseSettings(int UserModuleID, int PortalID)
{
try
{
string sp = "[dbo].[sp_AdSenseSettingsCount]";
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>("@PortalID", PortalID));
int UserModuleCount = sagesql.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@UserModuleCount");
return(UserModuleCount);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and adds message template token
/// </summary>
/// <param name="messageTokenID">Message token ID</param>
/// <param name="messageTemplateTypeID">Message template type ID</param>
/// <param name="name">Message template type name</param>
/// <param name="isActive">Set true if message template</param>
/// <param name="addedOn">Message template added date</param>
/// <param name="portalID">Portal ID</param>
/// <param name="addedBy">Message template adding user's name</param>
/// <returns>returns message token ID</returns>
public int MessageTemplateTokenAdd(int messageTokenID, int messageTemplateTypeID, string name, bool isActive, DateTime addedOn, int portalID, string addedBy)
{
try
{
string sp = "[dbo].[usp_MessageTemplateTokenAdd]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@MessageTemplateTypeID", messageTemplateTypeID));
ParamCollInput.Add(new KeyValuePair <string, object>("@Name", name));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", isActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedOn", addedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", portalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", addedBy));
return(SQLH.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@messageTokenID"));
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Connects to database and adds message template type.
/// </summary>
/// <param name="Name">Template type name.</param>
/// <param name="IsActive">Set true if message template type is active.</param>
/// <param name="AddedOn">Template type added date.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Template type added user's name.</param>
/// <returns>Returns message template type ID</returns>
public int AddMessageTemplateType(string Name, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
try
{
string sp = "[dbo].[sp_MessageTemplateTypeAdd]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@Name", Name));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", AddedBy));
return(SQLH.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@MessageTemplateTypeID"));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and counts adsense settings
/// </summary>
/// <param name="UserModuleID">userModuleID</param>
/// <param name="PortalID">portalID</param>
/// <returns>counts of adsense settings </returns>
public int CountAdsenseSettings(int UserModuleID, int PortalID)
{
try
{
string sp = "[dbo].[sp_AdSenseSettingsCount]";
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>("@PortalID", PortalID));
int UserModuleCount = sagesql.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@UserModuleCount");
return UserModuleCount;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and checks for unique module Control
/// </summary>
/// <param name="ModuleControlID">Module control ID </param>
/// <param name="ModuleDefID">Module Definition</param>
/// <param name="ControlType">Control type</param>
/// <param name="PortalID">Portal ID</param>
/// <param name="isEdit">Set true is the cotrol edit is true</param>
/// <returns>Returns count of module control type</returns>
public int CheckUnquieModuleControlsControlType(int ModuleControlID, int ModuleDefID, int ControlType, int PortalID, bool isEdit)
{
string sp = "[dbo].[sp_CheckUnquieModuleControlsControlType]";
SQLHandler sagesql = new SQLHandler();
try
{
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleControlID", ModuleControlID));
ParamCollInput.Add(new KeyValuePair <string, object>("@ModuleDefID", ModuleDefID));
ParamCollInput.Add(new KeyValuePair <string, object>("@ControlType", ControlType));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@isEdit", isEdit));
int Count = sagesql.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@Count");
return(Count);
}
catch (Exception)
{
throw;
}
}
public static bool AddtoCart(int itemID, int storeID, int portalID, string userName, string cultureName)
{
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>("@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();
bool isExist= sqlH.ExecuteNonQueryAsGivenType<bool>("usp_Aspx_CheckCostVariantForItem", parameter, "@IsExist");
return isExist;
}
catch (Exception e)
{
throw e;
}
}
public int AddItem(int itemID, int itemTypeID, int attributeSetID, int taxRuleID, int storeID, int portalID, string userName, string culture, bool isActive, bool isModified,
string sku, string activeFrom, string activeTo, string hidePrice, string isHideInRSS, string isHideToAnonymous,
string categoriesIDs, string relatedItemsIDs, string upSellItemsIDs, string crossSellItemsIDs, string downloadItemsValue, bool updateFlag)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", itemID));
parameterCollection.Add(new KeyValuePair <string, object>("@ItemTypeID", itemTypeID));
parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", attributeSetID));
parameterCollection.Add(new KeyValuePair <string, object>("@SKU", sku));
parameterCollection.Add(new KeyValuePair <string, object>("@TaxRuleID", taxRuleID));
parameterCollection.Add(new KeyValuePair <string, object>("@ActiveFrom", activeFrom));
parameterCollection.Add(new KeyValuePair <string, object>("@ActiveTo", activeTo));
parameterCollection.Add(new KeyValuePair <string, object>("@HidePrice", hidePrice));
parameterCollection.Add(new KeyValuePair <string, object>("@HideInRSSFeed", isHideInRSS));
parameterCollection.Add(new KeyValuePair <string, object>("@HideToAnonymous", isHideToAnonymous));
//For Static tabs
parameterCollection.Add(new KeyValuePair <string, object>("@CategoriesIDs", categoriesIDs));
parameterCollection.Add(new KeyValuePair <string, object>("@RelatedItemsIDs", relatedItemsIDs));
parameterCollection.Add(new KeyValuePair <string, object>("@UpSellItemsIDs", upSellItemsIDs));
parameterCollection.Add(new KeyValuePair <string, object>("@CrossSellItemsIDs", crossSellItemsIDs));
parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", storeID));
parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", portalID));
parameterCollection.Add(new KeyValuePair <string, object>("@UserName", userName));
parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", culture));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", isActive));
parameterCollection.Add(new KeyValuePair <string, object>("@IsModified", isModified));
parameterCollection.Add(new KeyValuePair <string, object>("@DownloadInfos", downloadItemsValue));
parameterCollection.Add(new KeyValuePair <string, object>("@UpdateFlag", updateFlag));
SQLHandler sqlH = new SQLHandler();
return(sqlH.ExecuteNonQueryAsGivenType <int>("dbo.usp_Aspx_ItemAddUpdate", parameterCollection, "@NewItemID"));
}
catch (Exception e)
{
throw e;
}
}
public int AddItem(ItemsInfo.ItemSaveBasicInfo itemObj, AspxCommonInfo aspxCommonObj, bool isActive, bool isModified,
string sku, string activeFrom, string activeTo, string hidePrice, string isHideInRSS, string isHideToAnonymous,
bool updateFlag)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@ItemID", itemObj.ItemId));
parameterCollection.Add(new KeyValuePair <string, object>("@ItemTypeID", itemObj.ItemTypeId));
parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", itemObj.AttributeSetId));
parameterCollection.Add(new KeyValuePair <string, object>("@SKU", sku));
parameterCollection.Add(new KeyValuePair <string, object>("@TaxRuleID", itemObj.TaxRuleId));
parameterCollection.Add(new KeyValuePair <string, object>("@ActiveFrom", activeFrom));
parameterCollection.Add(new KeyValuePair <string, object>("@ActiveTo", activeTo));
parameterCollection.Add(new KeyValuePair <string, object>("@HidePrice", hidePrice));
parameterCollection.Add(new KeyValuePair <string, object>("@HideInRSSFeed", isHideInRSS));
parameterCollection.Add(new KeyValuePair <string, object>("@HideToAnonymous", isHideToAnonymous));
//For Static tabs
parameterCollection.Add(new KeyValuePair <string, object>("@CategoriesIDs", itemObj.CategoriesIds));
parameterCollection.Add(new KeyValuePair <string, object>("@RelatedItemsIDs", itemObj.RelatedItemsIds));
parameterCollection.Add(new KeyValuePair <string, object>("@UpSellItemsIDs", itemObj.UpSellItemsIds));
parameterCollection.Add(new KeyValuePair <string, object>("@CrossSellItemsIDs", itemObj.CrossSellItemsIds));
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));
parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", isActive));
parameterCollection.Add(new KeyValuePair <string, object>("@IsModified", isModified));
parameterCollection.Add(new KeyValuePair <string, object>("@DownloadInfos", itemObj.DownloadItemsValue));
parameterCollection.Add(new KeyValuePair <string, object>("@UpdateFlag", updateFlag));
SQLHandler sqlH = new SQLHandler();
return(sqlH.ExecuteNonQueryAsGivenType <int>("dbo.usp_Aspx_ItemAddUpdate", parameterCollection, "@NewItemID"));
}
catch (Exception e)
{
throw e;
}
}
public int HtmlTextAdd(string UserModuleID, string Content, string CultureName, bool IsAllowedToComment, bool IsModified, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UserModuleID", UserModuleID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@Content", Content));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@CultureName", CultureName));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@IsAllowedToComment", IsAllowedToComment));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@IsModified", IsModified));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@AddedOn", AddedOn));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@AddedBy", AddedBy));
SQLHandler Sq = new SQLHandler();
return(Sq.ExecuteNonQueryAsGivenType <int>("dbo.sp_HtmlTextAdd", ParaMeterCollection, "@HTMLTextID"));
}
catch (Exception e)
{
throw e;
}
}
public static string UpdateTaskHistoryNextStartDate(int ScheduleID)
{
// DateTime NextStart
List <KeyValuePair <string, object> > ParameterCollection = new List <KeyValuePair <string, object> >();
ParameterCollection.Add(new KeyValuePair <string, object>("@ScheduleID", ScheduleID));
string NextStart;
try
{
SQLHandler sagesql = new SQLHandler();
NextStart = sagesql.ExecuteNonQueryAsGivenType <string>("usp_ScheduleHistoryNextStartUpdate", ParameterCollection, "@ResultNextStart");
return(NextStart);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and adds portal modules.
/// </summary>
/// <param name="PortalID">Portal ID.</param>
/// <param name="ModuleID">Module ID.</param>
/// <param name="IsActive">Set true if the portal module is active.</param>
/// <param name="AddedOn">Portal module added date.</param>
/// <param name="AddedBy">Portal module added user's name.</param>
/// <returns>Returns portal's module ID.</returns>
public int AddPortalModules(int?PortalID, int?ModuleID, bool IsActive, DateTime AddedOn, string AddedBy)
{
string sp = "[dbo].[sp_PortalModulesAdd]";
SQLHandler sagesql = 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>("@ModuleID", ModuleID));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", AddedBy));
int pmID = sagesql.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@PortalModuleID");
return(pmID);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and adds user profile detail.
/// </summary>
/// <param name="Username">User's name.</param>
/// <param name="ProfileID">Profile ID.</param>
/// <param name="Value">Value.</param>
/// <param name="IsActive">Set true if the profile is active.</param>
/// <param name="AddedOn">Profile added user's name.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Added user's name.</param>
/// <returns>Returns UserProfileID</returns>
public int AddUserProfile(string Username, int ProfileID, string Value, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
try
{
string sp = "[dbo].[sp_UserProfileAdd]";
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@UserName", Username));
ParamCollInput.Add(new KeyValuePair <string, object>("@ProfileID", ProfileID));
ParamCollInput.Add(new KeyValuePair <string, object>("@Value", Value));
ParamCollInput.Add(new KeyValuePair <string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair <string, object>("@AddedBy", AddedBy));
int PVID = SQLH.ExecuteNonQueryAsGivenType <int>(sp, ParamCollInput, "@UserProfileID");
return(PVID);
}
catch (Exception)
{
throw;
}
}
public decimal GetDiscountQuantityAmount(int storeID, int portalID, string userName, int customerID, string sessionCode)
{
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
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>("@CustomerID", customerID));
parameter.Add(new KeyValuePair<string, object>("@SessionCode", sessionCode));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteNonQueryAsGivenType<decimal>("usp_Aspx_GetItemQuantityDiscountAmount", parameter, "@QtyDiscount");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and adds HTML Text.
/// </summary>
/// <param name="UserModuleID">userModuleID</param>
/// <param name="Content">Content</param>
/// <param name="CultureName">Culture name</param>
/// <param name="IsAllowedToComment">Set true if comment is allowed.</param>
/// <param name="IsModified">Set true if the HTML text is modified.</param>
/// <param name="IsActive">Set true if the HTML text is active.</param>
/// <param name="AddedOn">Added date</param>
/// <param name="PortalID">portalID</param>
/// <param name="AddedBy">HTML text added user's name</param>
/// <returns>Returns 1 if inserted succesfully</returns>
public int HtmlTextAdd(string UserModuleID, string Content, string CultureName, bool IsAllowedToComment, bool IsModified, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
try
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UserModuleID", UserModuleID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Content", Content));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@CultureName", CultureName));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsAllowedToComment", IsAllowedToComment));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsModified", IsModified));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
SQLHandler Sq = new SQLHandler();
return Sq.ExecuteNonQueryAsGivenType<int>("dbo.sp_HtmlTextAdd", ParaMeterCollection, "@HTMLTextID");
}
catch (Exception e)
{
throw e;
}
}
public int CategoryAddUpdate(CategoryInfo categoryInfo,string selectedItems, List<CategoryAttributeInfo> listCA, string userName, string culture)
{
SQLHandler sqlHandler = new SQLHandler();
int categoryID = 0;
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", categoryInfo.CategoryID));
parameterCollection.Add(new KeyValuePair<string, object>("@SelectedItems", selectedItems));
parameterCollection.Add(new KeyValuePair<string, object>("@ParentID", categoryInfo.ParentID));
parameterCollection.Add(new KeyValuePair<string, object>("@IsShowInSearch", categoryInfo.IsShowInSearch));
parameterCollection.Add(new KeyValuePair<string, object>("@IsShowInCatalog", categoryInfo.IsShowInCatalog));
parameterCollection.Add(new KeyValuePair<string, object>("@IsShowInMenu", categoryInfo.IsShowInMenu));
parameterCollection.Add(new KeyValuePair<string, object>("@ActiveFrom", categoryInfo.ActiveFrom));
parameterCollection.Add(new KeyValuePair<string, object>("@ActiveTo", categoryInfo.ActiveTo));
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", categoryInfo.StoreID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", categoryInfo.PortalID));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", true));
parameterCollection.Add(new KeyValuePair<string, object>("@UserName", userName));
parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", culture));
try
{
categoryID = sqlHandler.ExecuteNonQueryAsGivenType<int>("dbo.usp_Aspx_CategoryAddUpdate", parameterCollection, "@NewCategoryID");
int inputTypeID;
int validationTypeID;
string valueType = string.Empty;
foreach (CategoryAttributeInfo ca in listCA)
{
parameterCollection.Clear();
inputTypeID = ca.InputTypeID;
validationTypeID = ca.ValidationTypeID;
if (inputTypeID == 1)
{
if (validationTypeID == 3)
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.DecimalValue));
valueType = "DECIMAL";
}
else if (validationTypeID == 5)
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.IntValue));
valueType = "INT";
}
else
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.NvarcharValue));
valueType = "NVARCHAR";
}
}
else if (inputTypeID == 2)
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.TextValue));
valueType = "TEXT";
}
else if (inputTypeID == 3)
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.DateValue));
valueType = "DATE";
}
else if (inputTypeID == 4)
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.BooleanValue));
valueType = "Boolean";
}
else if (inputTypeID == 5 || inputTypeID == 6 || inputTypeID == 9 || inputTypeID == 10 || inputTypeID == 11 || inputTypeID == 12)
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.OptionValues));
valueType = "OPTIONS";
}
else if (inputTypeID == 7)
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.DecimalValue));
valueType = "DECIMAL";
}
else if (inputTypeID == 8)
{
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeValue", ca.FileValue));
valueType = "FILE";
}
parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", categoryID));
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeID", ca.AttributeID));
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", categoryInfo.StoreID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", categoryInfo.PortalID));
parameterCollection.Add(new KeyValuePair<string, object>("@UserName", userName));
parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", culture));
sqlHandler.ExecuteNonQuery("dbo.usp_Aspx_CategoryAttributesValue" + valueType + "AddUpdate", parameterCollection);
}
}
catch (Exception ex)
{
throw ex;
}
return categoryID;
}
public static string UpdateTaskHistoryNextStartDate(int ScheduleID)
{
// DateTime NextStart
List<KeyValuePair<string, object>> ParameterCollection = new List<KeyValuePair<string, object>>();
ParameterCollection.Add(new KeyValuePair<string, object>("@ScheduleID", ScheduleID));
string NextStart;
try
{
SQLHandler sagesql = new SQLHandler();
NextStart = sagesql.ExecuteNonQueryAsGivenType<string>("usp_ScheduleHistoryNextStartUpdate", ParameterCollection, "@ResultNextStart");
return NextStart;
}
catch (Exception)
{
throw;
}
}
public int AddMessageTemplateType(string Name, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
try
{
string sp = "[dbo].[sp_MessageTemplateTypeAdd]";
SQLHandler SQLH = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@Name", Name));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
return SQLH.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@MessageTemplateTypeID");
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and checks for unique module Control
/// </summary>
/// <param name="ModuleControlID">Module control ID </param>
/// <param name="ModuleDefID">Module Definition</param>
/// <param name="ControlType">Control type</param>
/// <param name="PortalID">Portal ID</param>
/// <param name="isEdit">Set true is the cotrol edit is true</param>
/// <returns>Returns count of module control type</returns>
public int CheckUnquieModuleControlsControlType(int ModuleControlID, int ModuleDefID, int ControlType, int PortalID, bool isEdit)
{
string sp = "[dbo].[sp_CheckUnquieModuleControlsControlType]";
SQLHandler sagesql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ModuleControlID", ModuleControlID));
ParamCollInput.Add(new KeyValuePair<string, object>("@ModuleDefID", ModuleDefID));
ParamCollInput.Add(new KeyValuePair<string, object>("@ControlType", ControlType));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@isEdit", isEdit));
int Count = sagesql.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@Count");
return Count;
}
catch (Exception)
{
throw;
}
}
public int UpdateCustomer(int storeID, int portalID, int customerID, string userName, string firstName, string lastName, string email)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@UserName", userName));
parameterCollection.Add(new KeyValuePair<string, object>("@FirstName", firstName));
parameterCollection.Add(new KeyValuePair<string, object>("@LastName", lastName));
parameterCollection.Add(new KeyValuePair<string, object>("@Email", email));
parameterCollection.Add(new KeyValuePair<string, object>("@CustomerID", customerID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeID));
SQLHandler sqlh = new SQLHandler();
int errorCode = sqlh.ExecuteNonQueryAsGivenType<int>("dbo.usp_Aspx_UpdateCustomer", parameterCollection, "@ErrorCode");
return errorCode;
}
catch (Exception)
{
throw;
}
}
public bool CheckReviewByIP(int itemID, int storeID, int portalID, string userIP)
{
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>("@UserIP", userIP));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteNonQueryAsGivenType<bool>("usp_Aspx_CheckReviewAlreadyExist", parameter, "@IsReviewAlreadyExist");
}
public bool CheckWishItems(int ID, int storeID, int portalID, string userName)
{
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@ItemID", ID));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", userName));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteNonQueryAsGivenType<bool>("[usp_Aspx_CheckWishItems]", parameter, "@IsExist");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and adds portal modules.
/// </summary>
/// <param name="PortalID">Portal ID.</param>
/// <param name="ModuleID">Module ID.</param>
/// <param name="IsActive">Set true if the portal module is active.</param>
/// <param name="AddedOn">Portal module added date.</param>
/// <param name="AddedBy">Portal module added user's name.</param>
/// <returns>Returns portal's module ID.</returns>
public int AddPortalModules(int? PortalID, int? ModuleID, bool IsActive, DateTime AddedOn, string AddedBy)
{
string sp = "[dbo].[sp_PortalModulesAdd]";
SQLHandler sagesql = 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>("@ModuleID", ModuleID));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
int pmID = sagesql.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@PortalModuleID");
return pmID;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and saves module control.
/// </summary>
/// <param name="ModuleDefID">Module's definition ID.</param>
/// <param name="ControlKey">Control's key.</param>
/// <param name="ControlTitle">Control's title.</param>
/// <param name="ControlSrc">Control's source.</param>
/// <param name="IconFile">Control's icon file.</param>
/// <param name="ControlType">Control's type.</param>
/// <param name="DisplayOrder">Control's display order.</param>
/// <param name="HelpUrl">Controls help URL.</param>
/// <param name="SupportsPartialRendering">Set true if the controls need to have partial rendering.</param>
/// <param name="IsActive">Set true if the control is active.</param>
/// <param name="AddedOn">Control adde date.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Control added user's name.</param>
/// <returns>Returns registered ModuleControlID.</returns>
public int AddModuleCoontrols(int? ModuleDefID, string ControlKey, string ControlTitle, string ControlSrc, string IconFile, int ControlType, int DisplayOrder, string HelpUrl, bool SupportsPartialRendering, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
string sp = "[dbo].[sp_ModuleControlsAdd]";
SQLHandler sagesql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ModuleDefID", ModuleDefID));
ParamCollInput.Add(new KeyValuePair<string, object>("@ControlKey", ControlKey));
ParamCollInput.Add(new KeyValuePair<string, object>("@ControlTitle", ControlTitle));
ParamCollInput.Add(new KeyValuePair<string, object>("@ControlSrc", ControlSrc));
ParamCollInput.Add(new KeyValuePair<string, object>("@IconFile", IconFile));
ParamCollInput.Add(new KeyValuePair<string, object>("@ControlType", ControlType));
ParamCollInput.Add(new KeyValuePair<string, object>("@DisplayOrder", DisplayOrder));
ParamCollInput.Add(new KeyValuePair<string, object>("@HelpUrl", HelpUrl));
ParamCollInput.Add(new KeyValuePair<string, object>("@SupportsPartialRendering", SupportsPartialRendering));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
int MCID = sagesql.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@ModuleControlID");
return MCID;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and adds user's profile.
/// </summary>
/// <param name="Name">User's name.</param>
/// <param name="PropertyTypeID">Property type ID.</param>
/// <param name="DataType">Data type.</param>
/// <param name="IsRequired">Set true if profile is required.</param>
/// <param name="IsActive">Set true if profile is active.</param>
/// <param name="AddedOn">Profile added date.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Profile added user's name.</param>
/// <returns>Returns ProfileID</returns>
public int AddProfile(string Name, int PropertyTypeID, string DataType, bool IsRequired, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy)
{
try
{
string sp = "[dbo].[sp_ProfileAdd]";
SQLHandler SQLH = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@Name", Name));
ParamCollInput.Add(new KeyValuePair<string, object>("@PropertyTypeID", PropertyTypeID));
ParamCollInput.Add(new KeyValuePair<string, object>("@DataType", DataType));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsRequired", IsRequired));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
int PID = SQLH.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@ProfileID");
return PID;
}
catch (Exception)
{
throw;
}
}
public bool CheckCustomerCartExist(int customerID, int storeID, int portalID)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteNonQueryAsGivenType<bool>("usp_Aspx_CheckCartExists", parameter, "@IsCartExist");
}
public bool AddItemstoCart(int itemID, decimal itemPrice, int itemQuantity, int storeID, int portalID, string userName, int custometID, string sessionCode, string cultureName)
{
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>("@Price", itemPrice));
parameter.Add(new KeyValuePair<string, object>("@Quantity", itemQuantity));
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>("@SessionCode", sessionCode));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteNonQueryAsGivenType<bool>("usp_Aspx_CheckCostVariantForItem", parameter, "@IsExist");
}
catch (Exception ex)
{
throw ex;
}
}
public string GetStoreSettingValueByKey(string settingKey, int storeID, int portalID, string cultureName)
{
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@SettingKey", settingKey));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteNonQueryAsGivenType<string>("usp_Aspx_GetStoreSettingValueBYKey", parameter, "@SettingValue");
}
catch (Exception ex)
{
throw ex;
}
}
public int AddMessageTemplate(int MessageTemplateTypeID, string Subject, string Body, string MailFrom, bool IsActive, DateTime AddedOn, int PortalID, string AddedBy, string CurrentCulture)
{
try
{
string sp = "[dbo].[sp_MessageTemplateAdd]";
SQLHandler SQLH = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@MessageTemplateTypeID", MessageTemplateTypeID));
ParamCollInput.Add(new KeyValuePair<string, object>("@Subject", Subject));
ParamCollInput.Add(new KeyValuePair<string, object>("@Body", Body));
ParamCollInput.Add(new KeyValuePair<string, object>("@MailFrom", MailFrom));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", IsActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", AddedBy));
ParamCollInput.Add(new KeyValuePair<string, object>("@CurrentCulture", CurrentCulture));
return SQLH.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@MessageTemplateID");
}
catch (Exception)
{
throw;
}
}
public bool CheckAddressAlreadyExist(int storeID, int portalID, int customerID, string sessionCode)
{
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@SessionCode", sessionCode));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteNonQueryAsGivenType<bool>("usp_Aspx_CheckForMultipleAddress", parameter, "@IsExist");
}
catch (Exception ex)
{
throw ex;
}
}
public int MessageTemplateTokenAdd(int messageTokenID, int messageTemplateTypeID, string name, bool isActive, DateTime addedOn, int portalID, string addedBy)
{
try
{
string sp = "[dbo].[usp_MessageTemplateTokenAdd]";
SQLHandler SQLH = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@MessageTemplateTypeID", messageTemplateTypeID));
ParamCollInput.Add(new KeyValuePair<string, object>("@Name", name));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", isActive));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", addedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", portalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", addedBy));
return SQLH.ExecuteNonQueryAsGivenType<int>(sp, ParamCollInput, "@messageTokenID");
}
catch(Exception e)
{
throw e;
}
}
public int AddItem(int itemID, int itemTypeID, int attributeSetID, int taxRuleID, int storeID, int portalID, string userName, string culture, bool isActive, bool isModified,
string sku, string activeFrom, string activeTo, string hidePrice, string isHideInRSS, string isHideToAnonymous,
string categoriesIDs, string relatedItemsIDs, string upSellItemsIDs, string crossSellItemsIDs, string downloadItemsValue, bool updateFlag)
{
try
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ItemTypeID", itemTypeID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", attributeSetID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@SKU", sku));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@TaxRuleID", taxRuleID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ActiveFrom", activeFrom));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ActiveTo", activeTo));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@HidePrice", hidePrice));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@HideInRSSFeed", isHideInRSS));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@HideToAnonymous", isHideToAnonymous));
//For Static tabs
ParaMeterCollection.Add(new KeyValuePair<string, object>("@CategoriesIDs", categoriesIDs));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@RelatedItemsIDs", relatedItemsIDs));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UpSellItemsIDs", upSellItemsIDs));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@CrossSellItemsIDs", crossSellItemsIDs));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UserName", userName));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@CultureName", culture));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsModified", isModified));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@DownloadInfos", downloadItemsValue));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UpdateFlag", updateFlag));
SQLHandler Sq = new SQLHandler();
return Sq.ExecuteNonQueryAsGivenType<int>("dbo.usp_ASPX_ItemAddUpdate", ParaMeterCollection, "@NewItemID");
}
catch (Exception e)
{
throw e;
}
}