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