public void ClearWishList(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_ClearWishItem", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void DeleteWishItem(string wishItemID, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@WishItemID", wishItemID));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_DeleteWishItem", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void AddComparedItems(string IDs, string CostVarinatIds, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemIDs", IDs));
parameter.Add(new KeyValuePair <string, object>("CostVarinatIds", CostVarinatIds));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddComparedItems", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static void AddNewUser(RealTimeNotificationInfo realTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("ConnectionID", realTimeObj.ConnectionId));
parameterCollection.Add(new KeyValuePair <string, object>("SessionCode", realTimeObj.SessionId));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("Aspx_AddOnlineUser", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
public static List <OnlineUsersInfo> GetOnlineUserList(AspxCommonInfo aspxCommonObj, string sessionID)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("SessionCode", sessionID));
OracleHandler sqlH = new OracleHandler();
List <OnlineUsersInfo> lstUsers = sqlH.ExecuteAsList <OnlineUsersInfo>("Aspx_GetOnlineUsers", parameterCollection);
return(lstUsers);
}
catch (Exception e)
{
throw e;
}
}
public void UpdateWishList(string wishItemID, string comment, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("WishItemID", wishItemID));
parameter.Add(new KeyValuePair <string, object>("Comment", comment));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_UpdateWishItem", parameter);
}
catch (Exception e)
{
throw e;
}
}
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 void SaveWishItems(SaveWishListInfo saveWishListInfo, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemID", saveWishListInfo.ItemID));
parameter.Add(new KeyValuePair <string, object>("@WishItemID", 0));
parameter.Add(new KeyValuePair <string, object>("@CostVariantValueIDs", saveWishListInfo.CostVariantValueIDs));
parameter.Add(new KeyValuePair <string, object>("@IP", saveWishListInfo.IP));
parameter.Add(new KeyValuePair <string, object>("@CountryName", saveWishListInfo.CountryName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_SaveWishItems", parameter);
}
catch (Exception e)
{
throw e;
}
}