public IActionResult Post([FromBody] Tag tag)
{
// TODO: Add data validation
db.Tags.Add(tag);
db.SaveChanges();
return(Ok(tag.ID));
}
public IActionResult Post([FromBody] Location location)
{
// TODO: Add data validation
int parentQuery = Convert.ToInt32(HttpContext.Request.Query["Parent"]);
location.Parent = db.Locations.Find(parentQuery);
db.Locations.Add(location);
db.SaveChanges();
return(Ok(location.ID));
}
public IActionResult Post([FromBody] ItemField itemField)
{
// TODO: Add data validation
int categoryQuery = Convert.ToInt32(HttpContext.Request.Query["Category"]);
itemField.Category = db.Categories.Find(categoryQuery);
db.ItemFields.Add(itemField);
db.SaveChanges();
return(Ok(itemField.ID));
}
public IActionResult Post([FromBody] Category category)
{
int parentQuery = Convert.ToInt32(HttpContext.Request.Query["Parent"]);
// TODO: Add data validation
category.Parent = db.Categories.Find(parentQuery);
db.Categories.Add(category);
db.SaveChanges();
return(Ok(category.ID));
}
public IActionResult Post([FromBody] Item item)
{
// TODO: Add data validation
int categoryQuery = Convert.ToInt32(HttpContext.Request.Query["Category"]);
int locationQuery = Convert.ToInt32(HttpContext.Request.Query["Location"]);
item.Category = db.Categories.Find(categoryQuery);
item.Location = db.Locations.Find(locationQuery);
db.Items.Add(item);
db.SaveChanges();
return(Ok(item.ID));
}
public IActionResult Post([FromBody] ItemTag tag)
{
// TODO: Add data validation
int itemQuery = Convert.ToInt32(HttpContext.Request.Query["Item"]);
int tagQuery = Convert.ToInt32(HttpContext.Request.Query["Tag"]);
tag.Item = db.Items.Find(itemQuery);
tag.Tag = db.Tags.Find(tagQuery);
db.ItemTags.Add(tag);
db.SaveChanges();
return(Ok(tag.ID));
}
public IActionResult Post([FromBody] ItemFieldValue value)
{
// TODO: Add data validation
int itemQuery = Convert.ToInt32(HttpContext.Request.Query["Item"]);
int itemFieldQuery = Convert.ToInt32(HttpContext.Request.Query["ItemField"]);
value.Item = db.Items.Find(itemQuery);
value.ItemField = db.ItemFields.Find(itemFieldQuery);
db.ItemFieldValues.Add(value);
db.SaveChanges();
return(Ok(value.ID));
}
public void Post([FromBody] ItemTag tag)
{
// TODO: Add data validation
using (var dataContext = new APIDBContext())
{
dataContext.ItemTags.Add(tag);
dataContext.SaveChanges();
}
}
public void Post([FromBody] ItemAttachment attachment)
{
// TODO: Add data validation
using (var dataContext = new APIDBContext())
{
dataContext.ItemAttachments.Add(attachment);
dataContext.SaveChanges();
}
}
public void Post([FromBody] ItemFieldValue value)
{
// TODO: Add data validation
using (var dataContext = new APIDBContext())
{
dataContext.ItemFieldValues.Add(value);
dataContext.SaveChanges();
}
}
public void Post([FromBody] Category category)
{
// TODO: Add data validation
using (var dataContext = new APIDBContext())
{
dataContext.Categories.Add(category);
dataContext.SaveChanges();
}
}
public void PostChild(int id, [FromBody] Category category)
{
using (var dataContext = new APIDBContext())
{
category.Parent = dataContext.Categories.Find(id);
dataContext.Categories.Add(category);
dataContext.SaveChanges();
}
}
public void PostChild(int id, [FromBody] Location location)
{
using (var dataContext = new APIDBContext())
{
location.Parent = dataContext.Locations.Find(id);
dataContext.Locations.Add(location);
dataContext.SaveChanges();
}
}
public void Post([FromBody] Location location)
{
// TODO: Add data validation
using (var dataContext = new APIDBContext())
{
dataContext.Locations.Add(location);
dataContext.SaveChanges();
}
}
public void Put(int id, [FromBody] Category category)
{
// TODO: Add data validation
category.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.Categories.Update(category);
dataContext.SaveChanges();
}
}
public void Put(int id, [FromBody] ItemAttachment attachment)
{
// TODO: Add data validation
attachment.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.ItemAttachments.Update(attachment);
dataContext.SaveChanges();
}
}
public void Put(int id, [FromBody] ItemFieldValue value)
{
// TODO: Add data validation
value.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.ItemFieldValues.Update(value);
dataContext.SaveChanges();
}
}
public void Put(int id, [FromBody] ItemTag tag)
{
// TODO: Add data validation
tag.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.ItemTags.Update(tag);
dataContext.SaveChanges();
}
}
public void Put(int id, [FromBody] Location location)
{
// TODO: Add data validation
location.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.Locations.Update(location);
dataContext.SaveChanges();
}
}
public User Create(User user, string password)
{
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
_context.Users.Add(user);
_context.SaveChanges();
//Al crear un usuario se crea un programador con el mismo ID
Programador programador = new Programador();
_context.Programadores.Add(programador);
_context.SaveChanges();
return(user);
}
public void Delete(int id)
{
Category category = new Category();
category.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.Categories.Remove(category);
dataContext.SaveChanges();
}
}
public void Delete(int id)
{
ItemAttachment attachment = new ItemAttachment();
attachment.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.ItemAttachments.Remove(attachment);
dataContext.SaveChanges();
}
}
public void Delete(int id)
{
ItemField itemField = new ItemField();
itemField.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.ItemFields.Remove(itemField);
dataContext.SaveChanges();
}
}
public void Delete(int id)
{
Location location = new Location();
location.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.Locations.Remove(location);
dataContext.SaveChanges();
}
}
public void Delete(int id)
{
ItemFieldValue value = new ItemFieldValue();
value.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.ItemFieldValues.Remove(value);
dataContext.SaveChanges();
}
}
public void Delete(int id)
{
ItemTag tag = new ItemTag();
tag.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.ItemTags.Remove(tag);
dataContext.SaveChanges();
}
}
public void Post([FromBody] ItemField itemField)
{
// TODO: Add data validation
using (var dataContext = new APIDBContext())
{
int categoryQuery = Convert.ToInt32(HttpContext.Request.Query["Category"]);
itemField.Category = dataContext.Categories.Find(categoryQuery);
dataContext.ItemFields.Add(itemField);
dataContext.SaveChanges();
}
}
public IActionResult Delete(int id)
{
Item item = new Item();
item.ID = id;
using (var dataContext = new APIDBContext())
{
dataContext.Items.Remove(item);
dataContext.SaveChanges();
return(Ok());
}
}
public ActionResult <Concert> DeleteConcert(int id)
{
var concertInDb = _context.Concert.FirstOrDefault(a => a.Id == id);
if (concertInDb == null)
{
return(NotFound());
}
_context.Remove(concertInDb);
_context.SaveChanges();
return(Ok(concertInDb));
}
public IActionResult Post([FromBody] Item item)
{
// TODO: Add data validation
using (var dataContext = new APIDBContext())
{
int categoryQuery = Convert.ToInt32(HttpContext.Request.Query["Category"]);
int locationQuery = Convert.ToInt32(HttpContext.Request.Query["Location"]);
item.Category = dataContext.Categories.Find(categoryQuery);
item.Location = dataContext.Locations.Find(locationQuery);
dataContext.Items.Add(item);
dataContext.SaveChanges();
return(Ok(item));
}
}