// POST api/<controller> public void Post(YouTubeWebApi value) { var db = new AdventureDbContainer(); db.YouTubeWebApi.AddObject(new YouTubeWebApi { Name = value.Name, Department = value.Department }); db.SaveChanges(); }
// GET api/<controller>/5 public MySalesOrderHeader GetSalesOrder(int id) { var db = new AdventureDbContainer(); var dbOrder = db.SalesOrderHeaders.FirstOrDefault(c=>c.SalesOrderID ==id); var myOrder = new MySalesOrderHeader(); myOrder.OrderDate = dbOrder.OrderDate; myOrder.Po = dbOrder.PurchaseOrderNumber; myOrder.TotalDue = dbOrder.TotalDue; return myOrder; }
// GET api/<controller> public List<MySalesOrderHeader> GetAllSalesOrders() { var db = new AdventureDbContainer(); List<MySalesOrderHeader> myList = new List<MySalesOrderHeader>(); foreach (var salesOrder in db.SalesOrderHeaders.Take(3).ToList()) { myList.Add(new MySalesOrderHeader { OrderDate = salesOrder.OrderDate, Po = salesOrder.PurchaseOrderNumber, TotalDue = salesOrder.TotalDue }); } return myList; }