// Но его можно сконфигурировать для работы с БД
//private void Button5_Click(object sender, EventArgs e)
//{
// using (SqlConnection sql = new SqlConnection(Connection))
// {
// // Показывает данные из таблицы
// sql.Open();
// SqlDataAdapter sqlData = new SqlDataAdapter("SELECT Addressees FROM Documents", sql);
// DataTable table = new DataTable();
// int v = sqlData.Fill(table);
// dataGridView3.DataSource = table;
// dataGridView3.Refresh();
// sql.Close();
// }
//}
//private void Button19_Click(object sender, EventArgs e) // Удаление данных из таблицы
//{
// var index = dataGridView3.CurrentCell.RowIndex;
// dataGridView3.Rows.RemoveAt(index);
// dataGridView3.Refresh();
// MessageBox.Show("Обьект из базы удален");
//}
//[Obsolete]
//private void button22_Click(object sender, EventArgs e)
//{
// using (var sql = new SqlConnection(Connection))
// {
// sql.Open();
// cmd = new SqlCommand("insert into Documents(RecipientsNNN) values(@RecipientsNNN)", sql);
// cmd.Parameters.Add(@"RecipientsNNN", textBox5.Text);
// if (textBox5.Text != null)
// textBox5.Text = " ";
// button22.Refresh();
// dataGridView4.Refresh();
// MessageBox.Show("Объект добавлен");
// cmd.ExecuteNonQuery();
// sql.Close();
// }
//}
//private void Button23_Click(object sender, EventArgs e)
//{
// using (var sqlConnection = new SqlConnection(Connection))
// {
// sqlConnection.Open();
// var sqlData = new SqlDataAdapter("select RecipientsNNN from Documents", sqlConnection);
// var table = new DataTable();
// sqlData.Fill(table);
// dataGridView4.DataSource = table;
// dataGridView4.Refresh();
// sqlConnection.Close();
// }
//}
//private void Button21_Click(object sender, EventArgs e)
//{
// int index = dataGridView4.CurrentCell.RowIndex;
// dataGridView4.Rows.RemoveAt(index);
// dataGridView4.Refresh();
// MessageBox.Show("Объект из базы удален");
//}
//public void textBox8_TextChanged(object sender, EventArgs e)
//{
// ShowAdressInform();
//}
//public void ShowAdressInform()
//{
// dataGridView6.DataSource = db.Documents.Where(p => p.Addressees.Contains(textBox8.Text));
//}
//[Obsolete]
//private void button17_Click_1(object sender, EventArgs e)
//{
// using (var sql = new SqlConnection(Connection))
// {
// sql.Open();
// cmd = new SqlCommand("insert into Documents(CustomsPost)values(@CustomsPost)", sql);
// cmd.Parameters.Add(@"CustomsPost", textBox10.Text);
// MessageBox.Show("Done");
// if (textBox10.Text != null)
// textBox10.Text = " ";
// button18.Refresh();
// dataGridView5.Refresh();
// cmd.ExecuteNonQuery();
// sql.Close();
// }
//}
//private void Button18_Click(object sender, EventArgs e)
//{
// using (var sq = new SqlConnection(Connection))
// {
// sq.Open();
// dataGridView5.Refresh();
// var data = new SqlDataAdapter("SELECT CustomsPost FROM Documents", sq);
// var dt = new DataTable();
// data.Fill(dt);
// dataGridView5.Width = 200;
// dataGridView5.DataSource = dt;
// sq.Close();
// }
//}
//private void button24_Click(object sender, EventArgs e)
//{
// var index = dataGridView5.CurrentCell.RowIndex;
// dataGridView5.Rows.RemoveAt(index);
// dataGridView5.Refresh();
// MessageBox.Show("Объект из базы удален");
//}
//[Obsolete]
//private void button25_Click(object sender, EventArgs e)
//{
// //using (SqlConnection sqll = new SqlConnection(Connection))
// // {
// //sqll.Open();
// //cmd = new SqlCommand("insert into Documents(NotificationType)values(@NotificationType)", sqll);
// //cmd.Parameters.Add(@"NotificationType", textBox8.Text);
// //if (textBox8.Text != null)
// // MessageBox.Show("Done");
// //cmd.ExecuteNonQuery();
// //sqll.Close();
// //}
//}
#endregion
private void Button26_Click(object sender, EventArgs e)
{
var FulForm = new FullInformation();
var result = FulForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
var documents = new Documents();
documents.Entry = FulForm.checkBox1.Checked;
documents.Exit = FulForm.checkBox2.Checked;
documents.CargoPlacement = FulForm.checkBox3.Checked;
documents.Sacrifieces = FulForm.checkBox4.Checked;
documents.ThemachineTP = FulForm.checkBox5.Checked;
documents.NumberTC = FulForm.textBox1.Text;
documents.Tyre = FulForm.checkBox6.Checked;
documents.TimeEvents = FulForm.checkBox7.Checked;
documents.DescriptionCargo = FulForm.textBox2.Text;
documents.Recipient = FulForm.textBox3.Text;
documents.TheconditionSeals = FulForm.checkBox8.Checked;
documents.ContentState = FulForm.checkBox9.Checked;
documents.RadiationControl = FulForm.checkBox10.Checked;
documents.PhoneNumberDrive = FulForm.textBox4.Text;
documents.Addressees = FulForm.textBox8.Text;
documents.RecipientsNNN = FulForm.textBox5.Text;
documents.CustomsPost = FulForm.textBox10.Text;
documents.TimeTransmissionDocumentsDriver = FulForm.dateTimePicker1.Value.Date;
documents.NotificationType = FulForm.textBox6.Text;
db.Documents.Add(documents);
db.SaveChanges();
MessageBox.Show("Done");
}
private void Button5_Click(object sender, EventArgs e)
{
if (dataGridView3.SelectedRows.Count > 0)
{
var index = dataGridView3.SelectedRows[0].Index;
var converted = int.TryParse(dataGridView3[0, index].Value.ToString(), out var id);
if (converted == false)
{
return;
}
var documents = db.Documents.Find(id);
var useInform = new FullInformation();
useInform.textBox10.Text = documents.CustomsPost;
useInform.textBox5.Text = documents.RecipientsNNN;
useInform.textBox5.Text = documents.Addressees;
useInform.checkBox1.Checked = documents.Entry;
useInform.checkBox2.Checked = documents.Exit;
useInform.checkBox3.Checked = documents.CargoPlacement;
useInform.checkBox4.Checked = documents.Sacrifieces;
useInform.checkBox5.Checked = documents.ThemachineTP;
useInform.textBox1.Text = documents.NumberTC;
useInform.checkBox6.Checked = documents.Tyre;
useInform.checkBox7.Checked = documents.TimeEvents;
useInform.textBox2.Text = documents.DescriptionCargo;
useInform.textBox3.Text = documents.Recipient;
useInform.textBox6.Text = documents.NotificationType;
useInform.checkBox8.Checked = documents.TheconditionSeals;
useInform.checkBox9.Checked = documents.RadiationControl;
useInform.textBox4.Text = documents.PhoneNumberDrive;
useInform.dateTimePicker1.Format = DateTimePickerFormat.Custom;
documents.TimeTransmissionDocumentsDriver.ToLongDateString();
var result = useInform.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
documents.CustomsPost = useInform.textBox10.Text;
documents.RecipientsNNN = useInform.textBox5.Text;
documents.Addressees = useInform.textBox5.Text;
documents.Entry = useInform.checkBox1.Checked;
documents.Exit = useInform.checkBox2.Checked;
documents.CargoPlacement = useInform.checkBox3.Checked;
documents.Sacrifieces = useInform.checkBox4.Checked;
documents.ThemachineTP = useInform.checkBox5.Checked;
documents.NumberTC = useInform.textBox1.Text;
documents.Tyre = useInform.checkBox6.Checked;
documents.TimeEvents = useInform.checkBox7.Checked;
documents.DescriptionCargo = useInform.textBox2.Text;
documents.Recipient = useInform.textBox3.Text;
documents.NotificationType = useInform.textBox6.Text;
documents.TheconditionSeals = useInform.checkBox8.Checked;
documents.RadiationControl = useInform.checkBox9.Checked;
documents.PhoneNumberDrive = useInform.textBox4.Text;
documents.TimeTransmissionDocumentsDriver = useInform.dateTimePicker1.Value.Date;
db.SaveChanges();
dataGridView3.Refresh();
MessageBox.Show("Данные обновленны");
}
}