//public IEnumerable<Order> GetAllOrders() //{ // return GetOrders(); //} public IEnumerable <Order> GetAllOrders() { using (productdbseaEntities ent = new productdbseaEntities()) { string regionName; regionName = System.Environment.GetEnvironmentVariable("REGION_NAME"); if (regionName != null) { HttpContext.Current.Response.Headers.Add("Web-Region-Name", regionName); } string sqlServerName = ent.Database.SqlQuery <string>("SELECT @@SERVERNAME").FirstOrDefault(); if (sqlServerName != null) { HttpContext.Current.Response.Headers.Add("DB-Server-Name", sqlServerName); } var orders = ent.Orders.ToList(); int count = 0; if (orders != null) { count = orders.Count; } HttpContext.Current.Response.Headers.Add("Total-Records", count.ToString()); return(orders); } }
public HttpResponseMessage Add(string productCode, int quantity) { string sqlServerName = null; using (productdbseaEntities ent = new productdbseaEntities()) { Order order = new Order() { ProductCode = productCode, Quantity = quantity, OrderDateTime = DateTime.Now }; ent.Orders.Add(order); ent.SaveChanges(); sqlServerName = ent.Database.SqlQuery <string>("SELECT @@SERVERNAME").FirstOrDefault(); } string regionName; regionName = System.Environment.GetEnvironmentVariable("REGION_NAME"); HttpResponseMessage resp = new HttpResponseMessage(); resp.StatusCode = HttpStatusCode.Created; if (regionName != null) { resp.Headers.Add("Web-Region-Name", regionName); } if (sqlServerName != null) { resp.Headers.Add("DB-Server-Name", sqlServerName); } return(resp); }