Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
31
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.76 KB | None | 0 0
  1. private static void EndOwnershipForTeam(long assetId, int teamId)
  2. {
  3. const string storedProcedureName = @"up_RemoveAssetOwnershipFromTeam";
  4.  
  5. using (var connection = new SqlConnection("context connection=true"))
  6. using (var command = new SqlCommand(storedProcedureName, connection))
  7. {
  8. command.Parameters.AddWithValue("assetId", assetId);
  9. command.Parameters.AddWithValue("teamId", teamId);
  10.  
  11. connection.Open();
  12. command.ExecuteNonQuery();
  13. }
  14. }
  15.  
  16. up_RemoveAssetOwnershipFromTeam
  17.  
  18. // option 1
  19. private static void EndOwnershipForTeam(long assetId, int teamId)
  20. {
  21. const string storedProcedureName = @"up_RemoveAssetOwnershipFromTeam";
  22.  
  23. using (var connection = new SqlConnection("context connection=true"))
  24. using (var command = new SqlCommand(storedProcedureName, connection))
  25. {
  26. command.CommandType = CommandType.StoredProcedure;
  27. command.Parameters.AddWithValue("assetId", assetId);
  28. command.Parameters.AddWithValue("teamId", teamId);
  29.  
  30. connection.Open();
  31. command.ExecuteNonQuery();
  32. }
  33. }
  34.  
  35. // option 2
  36. private static void EndOwnershipForTeam(long assetId, int teamId)
  37. {
  38. const string sql = @"exec up_RemoveAssetOwnershipFromTeam @assetId, @teamId";
  39.  
  40. using (var connection = new SqlConnection("context connection=true"))
  41. using (var command = new SqlCommand(sql, connection))
  42. {
  43. command.Parameters.AddWithValue("@assetId", assetId);
  44. command.Parameters.AddWithValue("@teamId", teamId);
  45.  
  46. connection.Open();
  47. command.ExecuteNonQuery();
  48. }
  49. }
  50.  
  51. command.Parameters.AddWithValue("assetId", assetId);
  52. command.Parameters.AddWithValue("teamId", teamId);
  53.  
  54. command.Parameters.AddWithValue("@assetId", assetId);
  55. command.Parameters.AddWithValue("@teamId", teamId);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement