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