// PUT: api/Category/5
public HttpResponseMessage Put(int id, [FromBody] Category value)
{
try
{
using (EshopEntities db = new EshopEntities())
{
Category s = db.Categories.SingleOrDefault(b => b.CategoryID == id);
if (s != null)
{
s.CategoryID = id;
s.CategoryName = value.CategoryName;
s.Description = value.Description;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// PUT: api/EditOrder/5
public HttpResponseMessage EditOrder(int id, [FromBody] Order order)
{
try
{
using (EshopEntities db = new EshopEntities())
{
Order s = db.Orders.SingleOrDefault(b => b.OrderID == id);
if (s != null)
{
s.OrderID = id;
s.CustomerID = order.CustomerID;
s.OrderDate = order.OrderDate;
s.ShipAddress = order.ShipAddress;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// PUT: api/Product/5
public HttpResponseMessage Put(int id, [FromBody] Product value)
{
try
{
using (EshopEntities db = new EshopEntities())
{
Product s = db.Products.SingleOrDefault(b => b.ProductID == id);
if (s != null)
{
s.ProductID = id;
s.CategoryID = value.CategoryID;
s.UnitPrice = value.UnitPrice;
s.ProductName = value.ProductName;
s.Quantity = value.Quantity;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public List <Customer> GetCustomerByAddress(string address)
{
using (EshopEntities db = new EshopEntities())
{
List <Customer> listcus = new List <Customer>();
listcus = db.Customers.Where(s => s.Address.Contains(address)).ToList();
return(listcus);
}
}
// GET: api/GetOrderByID/5
public HttpResponseMessage GetOrderByID(int id)
{
using (EshopEntities db = new EshopEntities())
{
Order o = db.Orders.SingleOrDefault(x => x.OrderID == id);
if (o != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, o));
}
else
{
return(null);
}
}
}
// GET: api/GetAllOrders
public HttpResponseMessage GetAllOrders()
{
using (EshopEntities db = new EshopEntities())
{
var result = db.Orders.ToList();
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result.ToList()));
}
else
{
return(null);
}
}
}
// GET: api/Product/5
public ProductDTO Get(int id)
{
using (EshopEntities db = new EshopEntities())
{
Product c = db.Products.SingleOrDefault(x => x.ProductID == id);
if (c != null)
{
return(new ProductDTO(c.ProductID, c.CategoryID, c.ProductName, c.UnitPrice, c.Quantity));
}
else
{
return(null);
}
}
}
// GET: api/Category/5
public CategoryDTO Get(int id)
{
using (EshopEntities db = new EshopEntities())
{
Category c = db.Categories.SingleOrDefault(x => x.CategoryID == id);
if (c != null)
{
return(new CategoryDTO(c.CategoryID, c.CategoryName, c.Description));
}
else
{
return(null);
}
}
}
// GET: api/GetCustomerByID/5
public HttpResponseMessage GetCustomerByID(int id)
{
using (EshopEntities db = new EshopEntities())
{
Customer c = db.Customers.SingleOrDefault(x => x.CustomerID == id);
if (c != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, c));
}
else
{
return(null);
}
}
}
// POST: api/AddOrder
public HttpResponseMessage AddOrder([FromBody] Order order)
{
try
{
using (EshopEntities db = new EshopEntities())
{
db.Orders.Add(order);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// POST: api/Product
public HttpResponseMessage Post([FromBody] Product value)
{
try
{
using (EshopEntities db = new EshopEntities())
{
db.Products.Add(value);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
// DELETE: api/DeleteOrder/5
public HttpResponseMessage DeleteOrder(int id)
{
try
{
using (EshopEntities db = new EshopEntities())
{
Order o = db.Orders.SingleOrDefault(x => x.OrderID == id);
db.Orders.Remove(o);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
