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