private void newSalebutton1_Click(object sender, EventArgs e) { var personId = (int)PeoplecomboBox1.SelectedValue; var regionId = (int)RegioncomboBox1.SelectedValue; var sale = new Sale { Amount = newAmountnumericUpDown1.Value, Date = newDatedateTimePicker1.Value, PersonId = personId, RegionId = regionId }; using (var context = new SalesContext()) { context.Sales.Add(sale); var result = context.SaveChanges(); MessageBox.Show(string.Format("{0} sales created", result)); GetSales(); } }
private void SalesdataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 1) { var SalesId = (int)SalesdataGridView1.Rows[e.RowIndex].Cells[0].Value; var amount = (decimal)SalesdataGridView1.Rows[e.RowIndex].Cells[1].Value; using (var context = new SalesContext()) { var sale = context.Sales.SingleOrDefault(p => p.Id == SalesId); if (sale != null) { sale.Amount = amount; var result = context.SaveChanges(); MessageBox.Show(string.Format("{0} sales Updated", result)); GetSales(); } } } }
private void SalesdataGridView1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { if (MessageBox.Show("Are you sure you want to delete this sale?", "Delete", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No) { e.Cancel = true; return; } var SalesId = (int)e.Row.Cells[0].Value; using (var context = new SalesContext()) { var sale = context.Sales.SingleOrDefault(p => p.Id == SalesId); if (sale != null) { context.Sales.Remove(sale); var result = context.SaveChanges(); MessageBox.Show(string.Format("{0} sales deleted", result)); } } }