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()); }