public void AddInfoPerson(TextBox name, TextBox surname, MaskedTextBox phone, MaskedTextBox number, TextBox info, MaskedTextBox pay) { if (name.Text != "" && surname.Text != "") { using (WG_db connect = new WG_db()) { var obj = connect.people.Where((x) => x.name == name.Text && x.surname == surname.Text).FirstOrDefault(); if (obj == null) { people people = new people(); people.name = name.Text; people.surname = surname.Text; people.phone = phone.Text; people.namber = number.Text; people.note = info.Text; people.summa = int.Parse(pay.Text); people.payment_date = DateTime.Now.ToShortDateString(); connect.people.Add(people); connect.SaveChanges(); } else { MessageBox.Show("Запись есть в базе!!!"); } } } else { MessageBox.Show("Поля Имя и Фамилия обязательны к заполнению"); } }
private people VerifyDate(string name, string surname) { using (WG_db connect = new WG_db()) { var obj = (from x in connect.people where x.name == name && x.surname == surname select x).FirstOrDefault(); return(obj); } }
public void ShowDriver(ComboBox comboBox) { try { using (WG_db connect = new WG_db()) { comboBox.DataSource = connect.workers.Select((x) => x.name).ToList(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void ShowAll() { try { using (WG_db connect = new WG_db()) { _dataGridView.DataSource = connect.people.ToList(); ColumnName(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void EditInfo() { EditPersonWorm ePerson = new EditPersonWorm(); try { int index = _dataGridView.SelectedRows[0].Index + 1; using (WG_db connect = new WG_db()) { people people = connect.people.Find(index); if (people != null) { ePerson.textBox1.Text = people.name; ePerson.textBox2.Text = people.surname; ePerson.textBox3.Text = people.note; ePerson.maskedTextBox1.Text = people.phone; ePerson.maskedTextBox2.Text = people.namber; ePerson.maskedTextBox3.Text = people.summa.ToString(); if (ePerson.ShowDialog() == DialogResult.Cancel) { return; } if (VerifyDate(ePerson.textBox1.Text, ePerson.textBox2.Text) == null || VerifyDate(ePerson.textBox1.Text, ePerson.textBox2.Text).id == people.id) { people.name = ePerson.textBox1.Text; people.surname = ePerson.textBox2.Text; people.note = ePerson.textBox3.Text; people.phone = ePerson.maskedTextBox1.Text; people.namber = ePerson.maskedTextBox2.Text; people.summa = int.Parse(ePerson.maskedTextBox3.Text); connect.SaveChanges(); ShowAll(); MessageBox.Show("Запись успешно обновлена."); } else { MessageBox.Show("Ошибка. Такая запись уже есть в базе!!!."); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public CleaningWorks(DataGridView dataGridView, Label clean, Label pay, Label itog, MaskedTextBox maskedTextBox, DateTimePicker dateTimePicker, TextBox textBox, ComboBox comboBox) { SingleConnection.NewConnection(); _connect = new WG_db(); _connect.cleaning_works.Load(); _cleanTable = new DataTable(); _dataGridView = dataGridView; _maskedTextBox = maskedTextBox; _dateTimePicker = dateTimePicker; _textBox = textBox; _comboBox = comboBox; _cleansumm = clean; _paysumm = pay; _itogsumm = itog; Summ(); }