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