private void btnSum_Click(object sender, EventArgs e) { try { AccountingDb = new AccountingEntities1(); double money = AccountingDb.Invoice.Where(c => c.Client.Contains(txtSum.Text)).Sum(c => c.Money); MessageBox.Show(string.Format("Сума на всех счетах клиента {0} равна {1}", txtSum.Text, money.ToString())); } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\n\r"); } }
private void btnSelect_Click(object sender, EventArgs e) { try { AccountingDb = new AccountingEntities1(); AccountingDb.Invoice.Load(); AccountingDataView.DataSource = AccountingDb.Invoice.Local.ToBindingList(); } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\n\r"); } }
private void btnDelete_Click(object sender, EventArgs e) { try { int id = Convert.ToInt32(AccountingDataView.CurrentRow.Cells[0].Value); AccountingDb = new AccountingEntities1(); Invoice client = AccountingDb.Invoice.Find(id); AccountingDb.Invoice.Remove(client); AccountingDb.SaveChanges(); MessageBox.Show("Выбраная строка удалена. Нажмите Select что бы обновить список"); } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\n\r"); } }
private void btnSearch_Click(object sender, EventArgs e) { try { AccountingDb = new AccountingEntities1(); var search = from c in AccountingDb.Invoice where c.Client == txtSearch.Text select c; var bindingList = search.ToList(); AccountingDataView.DataSource = bindingList; } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\n\r"); } }
private void btnInsert_Click(object sender, EventArgs e) { try { AccountingDB = new AccountingEntities1(); Invoice Client = new Invoice(); Client.Client = txtName.Text; Client.Date = txtDate.Text; Client.Money = Convert.ToDouble(txtMoney.Text); AccountingDB.Invoice.Add(Client); AccountingDB.SaveChanges(); MessageBox.Show(string.Format("Клиент {0} добавлен в базу данных", txtName.Text)); } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\r\n"); } }
private void btnUpdate_Click(object sender, EventArgs e) { AccountingDB = new AccountingEntities1(); if (txtOldName.Text != string.Empty) { try { Invoice client = AccountingDB.Invoice.First(c => c.Client == txtOldName.Text); if (txtNewDate.Text != string.Empty) { client.Date = txtNewDate.Text; } if (txtNewName.Text != string.Empty) { client.Client = txtNewName.Text; } if (txtNewMoney.Text != string.Empty) { client.Money = Convert.ToDouble(txtNewMoney.Text); } AccountingDB.SaveChanges(); MessageBox.Show(string.Format("Данные о пользователе {0} обновлены успешоно!!!", txtOldName.Text)); } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\r\n"); } } else if (txtID.Text != string.Empty) { try { int id = Convert.ToInt32(txtID.Text); Invoice client = AccountingDB.Invoice.First(c => c.ID == id); if (txtNewDate.Text != string.Empty) { client.Date = txtNewDate.Text; } if (txtNewName.Text != string.Empty) { client.Client = txtNewName.Text; } if (txtNewMoney.Text != string.Empty) { client.Money = Convert.ToDouble(txtNewMoney.Text); } AccountingDB.SaveChanges(); MessageBox.Show(string.Format("Данные о пользователе с ID {0} обновлены успешоно!!!", txtID.Text)); } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\r\n"); } } else if (txtID.Text != string.Empty && txtOldName.Text != string.Empty) { try { int id = Convert.ToInt32(txtID.Text); Invoice client = AccountingDB.Invoice.First(c => c.ID == id); if (txtNewDate.Text != string.Empty) { client.Date = txtNewDate.Text; } if (txtNewName.Text != string.Empty) { client.Client = txtNewName.Text; } if (txtNewMoney.Text != string.Empty) { client.Money = Convert.ToDouble(txtNewMoney.Text); } AccountingDB.SaveChanges(); MessageBox.Show(string.Format("Данные о пользователе {0} обновлены успешоно!!!", txtOldName.Text)); } catch (Exception ex) { MessageBox.Show(ex.ToString() + "\r\n"); } } else { MessageBox.Show("Введите имя или ID пользователя!!!"); } }