public IHttpActionResult PutCATALOG(int id, CATALOG cATALOG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != cATALOG.CATA_ID) { return(BadRequest()); } db.Entry(cATALOG).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CATALOGExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public When_reading_from_example_file_cd_catalog() { var readAllText = File.OpenRead(Path.Combine(Environment.CurrentDirectory, "..\\..\\..\\ExamplesFiles\\cd_catalog.xml")); var xmlSerializer = new XmlSerializer(typeof(CATALOG)); root = (CATALOG)xmlSerializer.Deserialize(readAllText); }
public IHttpActionResult GetCATALOG(int id) { CATALOG cATALOG = db.CATALOGs.Find(id); if (cATALOG == null) { return(NotFound()); } return(Ok(cATALOG)); }
public IHttpActionResult PostCATALOG(CATALOG cATALOG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.CATALOGs.Add(cATALOG); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = cATALOG.CATA_ID }, cATALOG)); }
public IHttpActionResult DeleteCATALOG(int id) { CATALOG cATALOG = db.CATALOGs.Find(id); if (cATALOG == null) { return(NotFound()); } db.CATALOGs.Remove(cATALOG); db.SaveChanges(); return(Ok(cATALOG)); }
public IQueryable <CatalogCustom> PutCATALOG(CATALOG cATALOG) { int id = cATALOG.CATA_ID; db.Entry(cATALOG).State = EntityState.Modified; db.SaveChanges(); return(from c in db.CATALOGs join y1 in db.YEARs on c.YEAR_START_ID equals y1.YEAR_ID join y2 in db.YEARs on c.YEAR_END_ID equals y2.YEAR_ID where c.CATA_ID == id select new CatalogCustom() { CATA_ID = c.CATA_ID, YEAR_START_ID = y1.YEAR_ID, YEAR_START = y1.YEAR1, YEAR_END_ID = y2.YEAR_ID, YEAR_END = y2.YEAR1, NOTE = c.NOTE, STATUS = c.STATUS }); }