public static void AddUpdateLastPrice(LastPrice lastPrice) { if (IsLastPriceExists(lastPrice)) UpdateLastPrice(lastPrice); else AddLastPrice(lastPrice); }
private static bool IsLastPriceExists(LastPrice lastPrice) { return SQLDataAccess.ExecuteScalar<int>( "SELECT COUNT(*) FROM [Customers].[LastPrice] WHERE [ProductId] = @ProductId AND [CustomerId] = @CustomerId", CommandType.Text, new SqlParameter("@ProductId", lastPrice.ProductId), new SqlParameter("@CustomerId", lastPrice.CustomerId)) > 0; }
private static void UpdateLastPrice(LastPrice lastPrice) { SQLDataAccess.ExecuteNonQuery( "UPDATE [Customers].[LastPrice] SET [ProductArtNo] = @ProductArtNo, [ProductPrice] = @ProductPrice, [PriceType] = @PriceType WHERE [ProductId] = @ProductId AND [CustomerId] = @CustomerId", CommandType.Text, new SqlParameter("@ProductPrice", lastPrice.ProductPrice), new SqlParameter("@PriceType", lastPrice.PriceType.HasValue ? lastPrice.PriceType.ToString() : (object)DBNull.Value), new SqlParameter("@ProductArtNo", lastPrice.ProductArtNo), new SqlParameter("@ProductId", lastPrice.ProductId), new SqlParameter("@CustomerId", lastPrice.CustomerId) ); }
private static void AddLastPrice(LastPrice lastPrice) { SQLDataAccess.ExecuteNonQuery( "INSERT INTO [Customers].[LastPrice] ([ProductId], [CustomerId], [ProductArtNo], [ProductPrice], [PriceType]) VALUES (@ProductId, @CustomerId, @ProductArtNo, @ProductPrice, @PriceType)", CommandType.Text, new SqlParameter("@ProductPrice", lastPrice.ProductPrice), new SqlParameter("@PriceType", lastPrice.PriceType.HasValue ? lastPrice.PriceType.ToString() : (object)DBNull.Value), new SqlParameter("@ProductArtNo", lastPrice.ProductArtNo), new SqlParameter("@ProductId", lastPrice.ProductId), new SqlParameter("@CustomerId", lastPrice.CustomerId) ); }