Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Data;
- using MySql.Data.MySqlClient;
- namespace BD_Kursovaya
- {
- class DriversAndAvtoTables
- {
- public static kursachEntities context = new kursachEntities();
- private MySqlDataAdapter dataAdapter;
- public static string connectionString = context.Database.Connection.ConnectionString;
- public static void InsertAuto(string name, string numbDL, string dateDL, string GovNumb, string Mark, string colour, string year, string clss)
- {
- try
- {
- using (MySqlConnection con = new MySqlConnection())
- {
- con.ConnectionString = connectionString;
- con.Open();
- DateTime thisDay = DateTime.Today;
- string workers_id = "NULL";
- int classes = 1;
- if (clss == "Standart") { classes = 1; }
- if (clss == "Van") { classes = 2; }
- if (clss == "Luxe") { classes = 3; }
- string sql = string.Format("Insert Into workers" +
- "( Name, Started_work, Fired ) Values(@Name, @Started_work, @Fired)");
- string sql1 = string.Format("Insert Into drivers" +
- "(workers_id, DL_number, DL_date) Values(@workers_id, @DL_number, @DL_date)");
- string sql2 = string.Format("Insert Into avto" +
- "(Gov_number, Mark, Colour, Year, Class) Values(@Gov_number, @Mark, @Colour, @Year, @Class)");
- using (MySqlCommand cmd = new MySqlCommand(sql, con))
- {
- // Добавить параметры
- cmd.Parameters.AddWithValue("@Name", name);
- cmd.Parameters.AddWithValue("@Started_work", thisDay);
- cmd.Parameters.AddWithValue("@Fired", 0);
- cmd.ExecuteNonQuery();
- }
- using (MySqlCommand cmd = new MySqlCommand(string.Format("SELECT * FROM workers"), con))
- {
- MySqlDataReader dr = cmd.ExecuteReader();
- while (dr.Read())
- {
- if (dr["Name"].ToString() == name)
- {
- workers_id = dr["id"].ToString();
- }
- else { workers_id = "NULL"; }
- }
- }
- using (MySqlCommand cmd = new MySqlCommand(sql1, con))
- {
- // Добавить параметры
- cmd.Parameters.AddWithValue("@workers_id", workers_id);
- cmd.Parameters.AddWithValue("@DL_number", numbDL);
- cmd.Parameters.AddWithValue("@DL_date", dateDL);
- cmd.ExecuteNonQuery();
- }
- using (MySqlCommand cmd = new MySqlCommand(sql2, con))
- {
- // Добавить параметры
- cmd.Parameters.AddWithValue("@Gov_number", GovNumb);
- cmd.Parameters.AddWithValue("@Mark", Mark);
- cmd.Parameters.AddWithValue("@Colour", colour);
- cmd.Parameters.AddWithValue("@Year", year);
- cmd.Parameters.AddWithValue("@Class", classes);
- cmd.ExecuteNonQuery();
- }
- con.Close();
- }
- }
- catch (Exception ex) { }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement