private void GetSales()
{
var personId = (int)PeoplecomboBox1.SelectedValue;
var regionId = (int)RegioncomboBox1.SelectedValue;
using (var context = new SalesContext())
{
saleBindingSource.DataSource = context.Sales
.Where(s => s.PersonId == personId &&
s.RegionId == regionId)
.OrderBy(s => s.Date)
.ToList();
}
}
private void GetLists()
{
using (var context = new SalesContext())
{
salesPersonBindingSource.DataSource = context.People
.Where(e => e.Active)
.OrderBy(e => e.FirstName)
.ThenBy(e => e.LastName)
.ToList();
salesRegionBindingSource.DataSource = context.Regions
.Where(e => e.Active)
.OrderBy(e => e.Name)
.ToList();
}
}
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 salesTaregetbutton1_Click(object sender, EventArgs e)
{
var personId = (int)PeoplecomboBox1.SelectedValue;
using (var context = new SalesContext())
{
var person = context.People.SingleOrDefault(p => p.Id == personId);
if (person != null)
{
MessageBox.Show(string.Format("{0} has a sales target of {1:c}",
person.FullName, person.SalesTarget));
}
}
}
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));
}
}
}
