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;
}
