예제 #1
0
        vwOrder IService1.AddOrder(vwOrder order) // AddOrder
        {
            try
            {
                using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
                {
                    if (order.OrderID == 0)
                    {   // ZA ADD
                        tblAlbum albumToEdit = (from r in context.tblAlbums where r.AlbumID == order.AlbumID select r).First();
                        //albumToEdit.GenreID = album.GenreID;
                        //albumToEdit.ArtistID = album.ArtistID;
                        //albumToEdit.Title = album.Title;
                        //albumToEdit.Price = album.Price;
                        albumToEdit.Storage -= order.NumberOfPieces;
                        context.Entry(albumToEdit).State = EntityState.Modified;
                        context.SaveChanges();

                        tblOrder newOrder = new tblOrder();
                        newOrder.EmployeeID     = order.EmployeeID;
                        newOrder.AlbumID        = order.AlbumID;
                        newOrder.CustomerID     = order.CustomerID;
                        newOrder.OrderDate      = order.OrderDate;
                        newOrder.TotalPrice     = order.TotalPrice;
                        newOrder.NumberOfPieces = order.NumberOfPieces;
                        context.tblOrders.Add(newOrder);
                        context.SaveChanges();
                        order.OrderID = newOrder.OrderID;
                        return(order);
                    }
                    else
                    {   // ZA EDIT
                        int      numberOfPieces = (int)(from x in context.vwOrders where x.OrderID == order.OrderID select x.NumberOfPieces).First();
                        tblAlbum albumToEdit    = (from r in context.tblAlbums where r.AlbumID == order.AlbumID select r).First();

                        albumToEdit.Storage = (albumToEdit.Storage + numberOfPieces) - order.NumberOfPieces;
                        context.Entry(albumToEdit).State = EntityState.Modified;
                        context.SaveChanges();

                        tblOrder orderToEdit = (from r in context.tblOrders where r.OrderID == order.OrderID select r).First();
                        orderToEdit.EmployeeID     = order.EmployeeID;
                        orderToEdit.AlbumID        = order.AlbumID;
                        orderToEdit.CustomerID     = order.CustomerID;
                        orderToEdit.OrderDate      = order.OrderDate;
                        orderToEdit.TotalPrice     = order.TotalPrice;
                        orderToEdit.NumberOfPieces = order.NumberOfPieces;
                        //orderToEdit.OrderID = order.OrderID;
                        context.Entry(orderToEdit).State = EntityState.Modified;
                        context.SaveChanges();
                        return(order);
                    }
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
                return(null);
            }
        }
예제 #2
0
 void IService1.DeleteOrder(int orderID) // DeleteOrder
 {
     try
     {
         using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
         {
             tblOrder orderToDelete = (from r in context.tblOrders where r.OrderID == orderID select r).First();
             context.tblOrders.Remove(orderToDelete);
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
     }
 }