/// <summary>
/// delete user wish list
/// </summary>
/// <param name="userWishList">WishListDAO</param>
/// <returns></returns>
public int DeleteWishList(WishListDAO userWishList)
{
Database database = null;
DbCommand deleteCommand = null;
try
{
database = DatabaseFactory.CreateDatabase();
deleteCommand = database.GetStoredProcCommand("uspDeleteWishList");
database.AddInParameter(deleteCommand, "userId", DbType.String, userWishList.UserId);
database.AddInParameter(deleteCommand, "productId", DbType.String, userWishList.ProductId);
return database.ExecuteNonQuery(deleteCommand);
}
catch (SqlException ex)
{
SpencerLogger.Error("UserDetailsDatabaseService->DeleteWishList()", ex);
throw new BaseException("DBDelete");
}
catch (Exception ex)
{
SpencerLogger.Error("UserDetailsDatabaseService->DeleteWishList()", ex);
throw new BaseException("DBDelete");
}
finally
{
if (deleteCommand.Connection.State == System.Data.ConnectionState.Open)
deleteCommand.Connection.Close();
database = null;
}
}
/// <summary>
/// insert user wish list
/// </summary>
/// <param name="userWishList">WishListDAO</param>
/// <returns></returns>
public int AddToWishList(WishListDAO userWishList)
{
Database database = null;
DbCommand insertCommand = null;
try
{
database = DatabaseFactory.CreateDatabase();
insertCommand = database.GetStoredProcCommand("uspAddToWishList");
database.AddInParameter(insertCommand, "userId", DbType.String, userWishList.UserId);
database.AddInParameter(insertCommand, "productId", DbType.String, userWishList.ProductId);
return(database.ExecuteNonQuery(insertCommand));
}
catch (SqlException ex)
{
SpencerLogger.Error("UserDetailsDatabaseService->AddToWishList()", ex);
throw new BaseException("DBInsert");
}
catch (Exception ex)
{
SpencerLogger.Error("UserDetailsDatabaseService->AddToWishList()", ex);
throw new BaseException("DBInsert");
}
finally
{
if (insertCommand.Connection.State == System.Data.ConnectionState.Open)
{
insertCommand.Connection.Close();
}
database = null;
}
}
/// <summary>
/// delete user wish list
/// </summary>
/// <param name="userWishList">WishListDAO</param>
/// <returns></returns>
public int DeleteWishList(WishListDAO userWishList)
{
IWishListDatabaseService wishListDatabaseService = null;
try
{
wishListDatabaseService = DBDelegateFactory.Current.WishListDatabaseService;
return wishListDatabaseService.DeleteWishList(userWishList);
}
finally
{
wishListDatabaseService = null;
}
}
/// <summary>
/// delete user wish list
/// </summary>
/// <param name="userWishList">WishListDAO</param>
/// <returns></returns>
public int DeleteWishList(WishListDAO userWishList)
{
IWishListDatabaseService wishListDatabaseService = null;
try
{
wishListDatabaseService = DBDelegateFactory.Current.WishListDatabaseService;
return(wishListDatabaseService.DeleteWishList(userWishList));
}
finally
{
wishListDatabaseService = null;
}
}
