private void DeleteSale(DataGridViewRow row)
{
var salesId = (int)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));
}
}
}
private void newSalesButton_Click(object sender, EventArgs e)
{
var personId = (int)peopleComboBox.SelectedValue;
var regionId = (int)regionComboBox.SelectedValue;
var sale = new Sale
{
Amount = newAmountNumericUpDown.Value,
Date = newDateDateTimePicker.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 salesDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 1)
{
var salesId = (int)salesDataGridView.Rows[e.RowIndex].Cells[0].Value;
var amount = (decimal)salesDataGridView.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();
}
}
}
}