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