Advertisement
Guest User

Untitled

a guest
May 29th, 2015
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.73 KB | None | 0 0
  1. using (MySqlConnection con = new MySqlConnection(snippets.MakeMySqlConnectionString()))
  2. {
  3. string query = "INSERT INTO `RecycleRush_Northbay_Pits`(`EntryID`,`UniqueID`,`Author`,`Time_Created`,`Team_Number`,`Team_Name`,`Drive_Train`,-`Number_Of_Robots`,`Can_It_Manipulate_Totes`,`Can_It_Manipulate_Bins`,`Can_It_Manipulate_Litter`,`Needs_Special_Starting_Position`,`Special_Starting_Position`,`Max_Stack_Height`,`Max_Bin_On_Stack_Height`,`Human_Tote_Loading`,`Human_Litter_Loading`,`Human_Litter_Throwing`,`Does_It_have_A_Ramp`,`Comments`,`Front_Picture`,`Left_Side_Picture`,`Left_Isometric_Picture`,`Other_Picture`)VALUES(@EntryID,@UniqueID,@Author,@Time_Created,@TeamNumber,@Team_Name,@Drive_Train,@Number_Of_Robots,@Can_It_Manipulate_Totes,@Can_It_Manipulate_Bins,@Can_It_Manipulate_Litter,@Needs_Special_Starting_Position,@Special_Starting_Position,@Max_Stack_Height,@Max_Bin_On_Stack_Height,@Human_Tote_Loading,@Human_Litter_Loading,@Human_Litter_Throwing,@Does_It_have_A_Ramp,@Comments,@Front_Picture,@Left_Side_Picture,@Left_Isometric_Picture,@Other_Picture);";
  4. using (MySqlCommand cmd = new MySqlCommand(query, con))
  5. {
  6. cmd.Parameters.AddWithValue("@EntryID", GetNumberOfRowsInPitEntry());
  7. cmd.Parameters.AddWithValue("@UniqueID", pitScout.UniqueID);
  8. cmd.Parameters.AddWithValue("@Author", pitScout.Author);
  9. cmd.Parameters.AddWithValue("@Time_Created`", pitScout.Time_Created);
  10. cmd.Parameters.AddWithValue("@Team_Number", pitScout.Team_Number);
  11. cmd.Parameters.AddWithValue("@Team_Name", pitScout.Team_Name);
  12. cmd.Parameters.AddWithValue("@Drive_Train", pitScout.Drive_Train);
  13. cmd.Parameters.AddWithValue("@Number_Of_Robots", pitScout.Number_Of_Robots);
  14. cmd.Parameters.AddWithValue("@Can_It_Manipulate_Totes", pitScout.Can_It_Manipulate_Totes);
  15. cmd.Parameters.AddWithValue("@Can_It_Manipulate_Bins", pitScout.Can_It_Manipulate_Bins);
  16. cmd.Parameters.AddWithValue("@Can_It_Manipulate_Litter", pitScout.Can_It_Manipulate_Litter);
  17. cmd.Parameters.AddWithValue("@Needs_Special_Starting_Position", pitScout.Needs_Special_Starting_Position);
  18. cmd.Parameters.AddWithValue("@Special_Starting_Position", pitScout.Special_Starting_Position);
  19. cmd.Parameters.AddWithValue("@Max_Stack_Height", pitScout.Max_Stack_Height);
  20. cmd.Parameters.AddWithValue("@Max_Bin_On_Stack_Height", pitScout.Max_Bin_On_Stack_Height);
  21. cmd.Parameters.AddWithValue("@Human_Tote_Loading", pitScout.Human_Tote_Loading);
  22. cmd.Parameters.AddWithValue("@Human_Litter_Loading", pitScout.Human_Litter_Loading);
  23. cmd.Parameters.AddWithValue("@Human_Litter_Throwing", pitScout.Human_Litter_Throwing);
  24. cmd.Parameters.AddWithValue("@Does_It_have_A_Ramp", pitScout.Does_It_have_A_Ramp);
  25. cmd.Parameters.AddWithValue("@Comments", pitScout.Comments);
  26. cmd.Parameters.AddWithValue("@Front_Picture", pitScout.Front_Picture);
  27. cmd.Parameters.AddWithValue("@Left_Side_Picture", pitScout.Left_Side_Picture);
  28. cmd.Parameters.AddWithValue("@Left_Isometric_Picture", pitScout.Left_Isometric_Picture);
  29. cmd.Parameters.AddWithValue("@Other_Picture", pitScout.Other_Picture);
  30. con.Open();
  31. cmd.ExecuteNonQuery();
  32. con.Close();
  33. }
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement