Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.91 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using System.Data;
  7. using MySql.Data.MySqlClient;
  8.  
  9. namespace BD_Kursovaya
  10. {
  11. class DriversAndAvtoTables
  12. {
  13.  
  14. public static kursachEntities context = new kursachEntities();
  15. private MySqlDataAdapter dataAdapter;
  16. public static string connectionString = context.Database.Connection.ConnectionString;
  17.  
  18.  
  19. public static void InsertAuto(string name, string numbDL, string dateDL, string GovNumb, string Mark, string colour, string year, string clss)
  20. {
  21.  
  22. try
  23. {
  24. using (MySqlConnection con = new MySqlConnection())
  25. {
  26. con.ConnectionString = connectionString;
  27. con.Open();
  28.  
  29. DateTime thisDay = DateTime.Today;
  30. string workers_id = "NULL";
  31. int classes = 1;
  32. if (clss == "Standart") { classes = 1; }
  33. if (clss == "Van") { classes = 2; }
  34. if (clss == "Luxe") { classes = 3; }
  35.  
  36.  
  37. string sql = string.Format("Insert Into workers" +
  38. "( Name, Started_work, Fired ) Values(@Name, @Started_work, @Fired)");
  39.  
  40. string sql1 = string.Format("Insert Into drivers" +
  41. "(workers_id, DL_number, DL_date) Values(@workers_id, @DL_number, @DL_date)");
  42.  
  43. string sql2 = string.Format("Insert Into avto" +
  44. "(Gov_number, Mark, Colour, Year, Class) Values(@Gov_number, @Mark, @Colour, @Year, @Class)");
  45.  
  46.  
  47.  
  48.  
  49. using (MySqlCommand cmd = new MySqlCommand(sql, con))
  50.  
  51. {
  52. // Добавить параметры
  53. cmd.Parameters.AddWithValue("@Name", name);
  54. cmd.Parameters.AddWithValue("@Started_work", thisDay);
  55. cmd.Parameters.AddWithValue("@Fired", 0);
  56.  
  57. cmd.ExecuteNonQuery();
  58. }
  59.  
  60. using (MySqlCommand cmd = new MySqlCommand(string.Format("SELECT * FROM workers"), con))
  61. {
  62. MySqlDataReader dr = cmd.ExecuteReader();
  63. while (dr.Read())
  64. {
  65. if (dr["Name"].ToString() == name)
  66. {
  67. workers_id = dr["id"].ToString();
  68. }
  69. else { workers_id = "NULL"; }
  70. }
  71. }
  72.  
  73. using (MySqlCommand cmd = new MySqlCommand(sql1, con))
  74. {
  75. // Добавить параметры
  76. cmd.Parameters.AddWithValue("@workers_id", workers_id);
  77. cmd.Parameters.AddWithValue("@DL_number", numbDL);
  78. cmd.Parameters.AddWithValue("@DL_date", dateDL);
  79.  
  80. cmd.ExecuteNonQuery();
  81. }
  82.  
  83.  
  84. using (MySqlCommand cmd = new MySqlCommand(sql2, con))
  85.  
  86. {
  87. // Добавить параметры
  88. cmd.Parameters.AddWithValue("@Gov_number", GovNumb);
  89. cmd.Parameters.AddWithValue("@Mark", Mark);
  90. cmd.Parameters.AddWithValue("@Colour", colour);
  91. cmd.Parameters.AddWithValue("@Year", year);
  92. cmd.Parameters.AddWithValue("@Class", classes);
  93.  
  94. cmd.ExecuteNonQuery();
  95. }
  96.  
  97. con.Close();
  98. }
  99. }
  100. catch (Exception ex) { }
  101. }
  102. }
  103. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement