public void AddPassajira(Passenger2DBContext db) { foreach (var pass in db.Passengers) { sqlConnection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand("INSERT INTO Information VALUES (@Familia, @Name, @Otchestvo, @Document, @Nomer, @Grazdanstvo, @Compania, @Class, @StrOtpr, @DateTime, @StrPrib)", sqlConnection); command.Parameters.AddWithValue("@Id", pass.ID); command.Parameters.AddWithValue("@Familia", pass.Lastname); command.Parameters.AddWithValue("@Name", pass.Firstname); command.Parameters.AddWithValue("@Otchestvo", pass.Middlename); command.Parameters.AddWithValue("@Document", pass.Document); command.Parameters.AddWithValue("@Nomer", pass.SerialNumber); command.Parameters.AddWithValue("@Grazdanstvo", pass.Citizenship); command.Parameters.AddWithValue("@Compania", pass.Company); command.Parameters.AddWithValue("@Class", pass.Class); command.Parameters.AddWithValue("@StrOtpr", pass.ContryCityFrom); command.Parameters.AddWithValue("@DateTime", pass.DateTimeFrom); command.Parameters.AddWithValue("@StrPrib", pass.ContryCityTo); //command.Parameters.Add("@UserId", SqlDbType.Int).Value = pass.ID; sqlConnection.Open(); command.ExecuteNonQuery(); sqlConnection.Close(); } }
public void button13_Click(object sender, EventArgs e) { try { Passenger2DBContext db = new Passenger2DBContext(); Passenger2 passenger = new Passenger2() { ID = UserId.GlobalUserId, Middlename = textBox3.Text, Firstname = textBox2.Text, Lastname = textBox1.Text, Document = comboBox2.Text, SerialNumber = textBox4.Text, Citizenship = textBox5.Text, Company = comboBox3.Text, Class = comboBox1.Text, ContryCityFrom = textBox8.Text, DateTimeFrom = dateTimePicker1.Text, ContryCityTo = textBox10.Text }; var exists = Note.CheckPassExist(passenger); if (exists) { MessageBox.Show("Такой пассажир уже существует!"); Close(); return; } db.Passengers.Add(passenger); db.SaveChanges(); Note.AddPassajira(db); Owner.dataGridView1.DataSource = NotePass.getNotes(UserId.GlobalUserId); } catch (DbEntityValidationException exc) { var messages = exc.EntityValidationErrors.First().ValidationErrors .Select(err => $"Field {err.PropertyName}: {err.ErrorMessage}"); MessageBox.Show(string.Join("\n", messages)); } //foreach (DataGridViewRow row in dataGridView1.SelectedRows) //{ // if (row.Index != e.RowIndex & !row.IsNewRow) // { // if (row.Cells[0].Value.ToString() == e.FormattedValue.ToString()) // { // dataGridView1.Rows[e.RowIndex].ErrorText = // "Такой пассажир и данные o вылетe уже в таблице есть!"; // return; // } // } //DataRow row = ds.Tables[0].NewRow(); // добавляем новую строку в DataTable //ds.Tables[0].Rows.Add(row); // } // dataGridView1.Rows[e.RowIndex].ErrorText = string.Empty; }