public ActionResult <Record> Get(int id)
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
return(context.Records.First(b => b.Id == id));
}
}
public IActionResult Post([FromBody] Genre newGenres)
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
context.Genres.Add(newGenres);
context.SaveChanges();
}
return(Created("/Genres", newGenres));
}
public IActionResult Post([FromBody] User newUser)
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
context.Users.Add(newUser);
context.SaveChanges();
}
return(Created("/User", newUser));
}
public ActionResult <User> Get(int id)
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
return(context.Users
.Include(user => user.Orders)
.First(b => b.Id == id));
}
}
public IActionResult Delete(int id)
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
Record toRemove = context.Records.First(u => u.Id == id);
context.Records.Remove(toRemove);
context.SaveChanges();
}
return(Ok());
}
public IEnumerable <Order> Get()
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
return(context.Orders
.Include(order => order.Cart)
.ThenInclude(cart => cart.Record)
.ToList());
}
}
public IActionResult Delete(int id)
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
Genre RemoveGenres = context.Genres.First(u => u.Id == id);
context.Genres.Remove(RemoveGenres);
context.SaveChanges();
}
return(Ok());
}
public ActionResult <Genre> Get(int id)
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
return(context.Genres
.Include(genre => genre.ProductsInGenre)
.ThenInclude(pig => pig.Record)
.First(b => b.Id == id));
}
}
public IActionResult Delete(int id)
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
User RemoveUser = context.Users.First(u => u.Id == id);
context.Users.Remove(RemoveUser);
context.SaveChanges();
}
return(Ok());
}
public IActionResult Put(int id, [FromBody] Genre newGenres)
{
//valideringtest
using (RecordStoreContexts context = new RecordStoreContexts())
{
Genre toUpdate = context.Genres.First(u => u.Id == id);
toUpdate.Name = newGenres.Name;
context.SaveChanges();
}
return(Ok());
}
public IEnumerable <RecordViewModel> Get()
{
using (RecordStoreContexts context = new RecordStoreContexts())
{
List <Record> records = context.Records
.Include(records => records.ProductsInGenre)
.ThenInclude(ProductsInGenre => ProductsInGenre.Genre)
.ToList();
List <RecordViewModel> viewModels = _mapper.Map <List <RecordViewModel> >(records);
return(viewModels);
}
}
public IActionResult Put(int id, [FromBody] User newUser)
{
//valideringtest
using (RecordStoreContexts context = new RecordStoreContexts())
{
User toUpdate = context.Users.First(u => u.Id == id);
toUpdate.FirstName = newUser.FirstName;
toUpdate.LastName = newUser.LastName;
toUpdate.Email = newUser.Email;
context.SaveChanges();
}
return(Ok());
}
public IActionResult Post([FromBody] RecordViewModel newRecord)
{
Record record = _mapper.Map <Record>(newRecord);
foreach (ProductsInGenre ProductsInGenre in record.ProductsInGenre)
{
ProductsInGenre.Genre = null;
}
using (RecordStoreContexts context = new RecordStoreContexts())
{
context.Records.Add(record);
context.SaveChanges();
}
return(Created("/Record", record));
}
public IActionResult Put(int id, [FromBody] Record newRecord)
{
//validering
using (RecordStoreContexts context = new RecordStoreContexts())
{
Record toUpdate = context.Records.First(u => u.Id == id);
toUpdate.Artist = newRecord.Artist;
toUpdate.Album = newRecord.Album;
toUpdate.Image = newRecord.Image;
toUpdate.Info = newRecord.Info;
toUpdate.Price = newRecord.Price;
context.SaveChanges();
}
return(Ok());
}
public IActionResult Post([FromBody] OrderViewModel newOrder)
{
Order order = _mapper.Map <Order>(newOrder);
using (RecordStoreContexts context = new RecordStoreContexts())
{
User userExists = context.Users.FirstOrDefault(User => User.Email == newOrder.Email);
int userId = 0;
if (userExists == null)
{
User u = new User();
u.FirstName = newOrder.FirstName;
u.LastName = newOrder.LastName;
u.Email = newOrder.Email;
context.Users.Add(u);
context.SaveChanges();
userId = u.Id;
}
else
{
userId = userExists.Id;
}
Order o = new Order();
o.Created = DateTime.Now;
o.UserId = userId;
context.Orders.Add(o);
context.SaveChanges();
foreach (Cart cart in order.Cart)
{
Cart c = new Cart();
c.RecordId = cart.RecordId;
c.OrderId = o.Id;
context.Carts.Add(c);
context.SaveChanges();
}
return(Created("/Order", o));
}
}