public ActionResult Get()
{
using (Models.AdventureWorks2019Context db = new Models.AdventureWorks2019Context())
{
var salesHeader = (from salesHeader19 in db.SalesOrderHeaders
select salesHeader19).ToList();
return(Ok(salesHeader));
}
//return new String[] { "Ferney", "Yuliana", "Maria Alejandra" };
}
public ActionResult Get(int id)
{
using (Models.AdventureWorks2019Context db = new Models.AdventureWorks2019Context())
{
var customer = (from customers19 in db.Customers
where customers19.CustomerId == id
select customers19).ToList();
return(Ok(customer));
}
}
[HttpGet] //Obtención de datos
public ActionResult Get()
{
using (Models.AdventureWorks2019Context db = new Models.AdventureWorks2019Context())
{
var customers = (from customers19 in db.Customers
select customers19).ToList();
return(Ok(customers));
}
//return new String[] { "Ferney", "Yuliana", "Maria Alejandra" };
}
[HttpPut] //Edicion de datos
public ActionResult Put([FromBody] Models.ModelRequest.CustomerRequest model)
{
using (Models.AdventureWorks2019Context db = new Models.AdventureWorks2019Context())
{
Models.Customer customer = db.Customers.Find(model.customerId);
customer.PersonId = model.personID;
customer.StoreId = model.storeId;
customer.TerritoryId = model.territoryId;
db.Entry(customer).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
return(Ok());
}
[HttpPost] //Inserción de datos
public ActionResult Post([FromBody] Models.ModelRequest.CustomerRequest model)
{
using (Models.AdventureWorks2019Context db = new Models.AdventureWorks2019Context())
{
Models.Customer customer = new Models.Customer();
customer.PersonId = model.personID;
customer.StoreId = model.storeId;
customer.TerritoryId = model.territoryId;
db.Customers.Add(customer);
db.SaveChanges();
}
return(Ok());
}
