C# code for how
to maintain the product Price history from the site admin
Indroduction
Now
I will explain how to maintain
the product Price history from the site admin.Let me explain the scenario like
“We have a
all the product with essential details in the website. But today the product price is some amount like
10 k after two month the site admin want to increase or change the product price and also the site admin want to maintain a entire price update history
in database not only last price history..That
situation will go for below code”
Use
the below C# code and Stored Procedure
Stored Procedure
Create procedure [dbo].[sp_pricehistory]
@upc bigint,
@pricedate date,
@changedprice money
AS
BEGIN
--Price update
history start
if exists (select PM_Invbuylist
from
Product_Master where PM_Invbuylist=@changedprice and
PM_UPC =@upc)
begin
print 'not insert'
return -1
end
else
begin
print 'insert'
DECLARE @oldpricey
money
SELECT @oldpricey
= (select PM_Invbuylist
from dbo.Product_Master
where PM_UPC=@upc)
print @oldpricey
insert into Price_History
(
PM_UPC,
PM_Pricechangedate,
PM_Changedprice
)
values
(
@upc,
@pricedate,
@oldpricey
)
end
END
C# code to execute the stored procedure and changed price will stored or maintain in
the other table
/// <summary>
/// price history maintenence
/// </summary>
/// <param
name="upc"></param>
/// <param
name="date"></param>
/// <param
name="price"></param>
public void price_history(long
upc, string date, string
price)
{
if
(CONNECTION.State == ConnectionState.Closed)
{
CONNECTION.Open();
}
SqlCommand
cmd = new SqlCommand("sp_pricehistory", CONNECTION);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@upc", upc);
cmd.Parameters.AddWithValue("@pricedate", DateTime.Today.ToString());
cmd.Parameters.AddWithValue("@changedprice", price);
cmd.ExecuteNonQuery();
}
I hope this will helpful for you! thanks
