public HttpResponseMessage Get(int id)
{
try
{
using (ProductCatalogDA.CATALOGEntities db = new ProductCatalogDA.CATALOGEntities())
{
var product = from entity in db.Products where entity.ProductID == id
select new
{
Name = entity.Name,
ProductID = entity.ProductID,
Size = entity.Size,
UnitPrize = entity.UnitPrice,
StockQuantity = entity.StockQuantity,
Brand = entity.Brand.Name,
CreationDate = entity.CreationDate,
ChangeDate = entity.ChangeDate
};
string jsonContent = new JavaScriptSerializer().Serialize(product);
return Request.CreateResponse(HttpStatusCode.OK, jsonContent);
}
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message.ToString());
}
}
public HttpResponseMessage Post([FromBody] ProductCatalogDA.Product product)
{
try
{
using (ProductCatalogDA.CATALOGEntities db = new ProductCatalogDA.CATALOGEntities())
{
db.Products.Add(product);
db.SaveChanges();
return Request.CreateResponse(HttpStatusCode.OK, "Operation Sucessful");
}
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message.ToString());
}
}
public HttpResponseMessage Put([FromBody] ProductCatalogDA.Product product)
{
try
{
using (ProductCatalogDA.CATALOGEntities db = new ProductCatalogDA.CATALOGEntities())
{
product.ChangeDate = DateTime.Now;
db.Products.Attach(product);
var entry = db.Entry(product);
entry.Property(e => e.BrandID).IsModified = true;
entry.Property(e => e.ChangeDate).IsModified = true;
entry.Property(e => e.Name).IsModified = true;
entry.Property(e => e.Size).IsModified = true;
entry.Property(e => e.StockQuantity).IsModified = true;
entry.Property(e => e.UnitPrice).IsModified = true;
// other changed properties
db.SaveChanges();
return Request.CreateResponse(HttpStatusCode.OK, "Operation Sucessful");
}
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message.ToString());
}
}
