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