internal bool IsValid()
{
return
(!string.IsNullOrEmpty(ProposalId) &&
Passenger1.IsValid() &&
(Passenger2 == null || Passenger2.IsValid()) &&
(Passenger3 == null || Passenger3.IsValid()) &&
(Passenger4 == null || Passenger4.IsValid()));
}
public bool CheckPassExist(Passenger2 pass)
{
sqlConnection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(
@"Select *
From Information
Where Familia = @Familia
and Name = @Name
and Otchestvo = @Otchestvo
and Document = @Document
and Nomer = @Nomer
and Grazdanstvo = @Grazdanstvo
and Compania = @Compania
and Class = @Class
and StrOtpr = @StrOtpr
and DateTime = @DateTime
and StrPrib = @StrPrib", sqlConnection);
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();
var result = command.ExecuteScalar();
return(Convert.ToBoolean(result));
}
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;
}
