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);
}
}
void IService1.DeleteAlbum(int albumID) // DeleteAlbum
{
try
{
using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
{
tblAlbum albumToDelete = (from r in context.tblAlbums where r.AlbumID == albumID select r).First();
context.tblAlbums.Remove(albumToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
// ADD , EDIT I DELETE ZA ALBUM
vwAlbum IService1.AddAlbum(vwAlbum album) // AddAlbum
{
try
{
using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
{
if (album.AlbumID == 0)
{ // ZA ADD
tblAlbum newAlbum = new tblAlbum();
newAlbum.GenreID = album.GenreID;
newAlbum.ArtistID = album.ArtistID;
newAlbum.Title = album.Title;
newAlbum.Price = album.Price;
newAlbum.Storage = album.Storage;
context.tblAlbums.Add(newAlbum);
context.SaveChanges();
album.AlbumID = newAlbum.AlbumID;
return(album);
}
else
{ // ZA EDIT
tblAlbum albumToEdit = (from r in context.tblAlbums where r.AlbumID == album.AlbumID select r).First();
albumToEdit.GenreID = album.GenreID;
albumToEdit.ArtistID = album.ArtistID;
albumToEdit.Title = album.Title;
albumToEdit.Price = album.Price;
albumToEdit.Storage = album.Storage;
context.Entry(albumToEdit).State = EntityState.Modified;
context.SaveChanges();
return(album);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}