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