private void deleteBtn_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult msgBoxResult = MessageBox.Show("Do you want to delete order?",
"Order has been deleted",
MessageBoxButton.YesNo,
MessageBoxImage.Warning,
MessageBoxResult.No);
if (msgBoxResult == MessageBoxResult.Yes)
{
ShopMenegmentDBEntities _db = new ShopMenegmentDBEntities();
var r = from o in _db.Orders
where o.Id == this.updateOrderId
select o;
Order order = r.SingleOrDefault();
if (order != null)
{
_db.Orders.Remove(order);
_db.SaveChanges();
}
}
}
private void insertOrdBtn_Click(object sender, RoutedEventArgs e)
{
ShopMenegmentDBEntities _db = new ShopMenegmentDBEntities();
Order newOrder = new Order()
{
CustomerName = txtName.Text,
CustomerSurname = txtSurname.Text,
Product = txtProduct.Text
};
_db.Orders.Add(newOrder);
_db.SaveChanges();
}
private void updateBtn_Click(object sender, RoutedEventArgs e)
{
ShopMenegmentDBEntities _db = new ShopMenegmentDBEntities();
var r = from o in _db.Orders
where o.Id == this.updateOrderId
select o;
Order order = r.SingleOrDefault();
if (order != null)
{
order.CustomerName = this.txtNameUpdate.Text;
order.CustomerSurname = this.txtSurnameUpdate.Text;
order.Product = this.txtProductUpdate.Text;
}
_db.SaveChanges();
}
public ShopManagmentSystemWPF()
{
InitializeComponent();
ShopMenegmentDBEntities _db = new ShopMenegmentDBEntities();
var orders = from o in _db.Orders
select o;
foreach (var item in orders)
{
Console.WriteLine(item.CustomerName);
Console.WriteLine(item.CustomerSurname);
Console.WriteLine(item.Product);
}
this.gridOfOrders.ItemsSource = orders.ToList();
}
private void reloadDataBtn_Click(object sender, RoutedEventArgs e)
{
ShopMenegmentDBEntities _db = new ShopMenegmentDBEntities();
this.gridOfOrders.ItemsSource = _db.Orders.ToList();
}
