public int Purchase_Item(int User_ID, Item_Master Item)
{
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
SqlCommand cmd = new SqlCommand("SP_PurchaseItem", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("User_ID", User_ID);
cmd.Parameters.AddWithValue("Item_ID", Item.Item_ID);
cmd.Parameters.AddWithValue("Item_Name", Item.Item_Name);
cmd.Parameters.AddWithValue("Item_Price", Item.Item_Price);
cmd.Parameters.AddWithValue("Bonus_Point", Item.Bonus_Point);
con.Open();
int i = cmd.ExecuteNonQuery();
return(i);
}
}
