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