public IHttpActionResult PuttblAssetDefinition(int id, tblAssetDefinition tblAssetDefinition) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblAssetDefinition.assetId) { return(BadRequest()); } db.Entry(tblAssetDefinition).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblAssetDefinitionExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public List <tblAssetType> GetTblAssetTypes(string name) { db.Configuration.ProxyCreationEnabled = true; tblAssetDefinition assetdef = db.tblAssetDefinitions.Where(x => x.assetName == name).FirstOrDefault(); List <tblAssetType> typelist = db.tblAssetTypes.Where(x => x.assetTypeId == assetdef.assetType).ToList(); return(typelist); }
public IHttpActionResult GettblAssetDefinition(int id) { tblAssetDefinition tblAssetDefinition = db.tblAssetDefinitions.Find(id); if (tblAssetDefinition == null) { return(NotFound()); } return(Ok(tblAssetDefinition)); }
public IHttpActionResult DeletetblAssetDefinition(int id) { tblAssetDefinition tblAssetDefinition = db.tblAssetDefinitions.Find(id); if (tblAssetDefinition == null) { return(NotFound()); } db.tblAssetDefinitions.Remove(tblAssetDefinition); db.SaveChanges(); return(Ok(tblAssetDefinition)); }
public int PosttblAssetDefinition(tblAssetDefinition tblAssetDefinition) { tblAssetDefinition asset = new tblAssetDefinition(); asset = db.tblAssetDefinitions.Where(x => x.assetName == tblAssetDefinition.assetName && x.assetType == tblAssetDefinition.assetType && x.assetClass == tblAssetDefinition.assetClass).FirstOrDefault(); if (asset == null) { db.tblAssetDefinitions.Add(tblAssetDefinition); db.SaveChanges(); return(0); } else { return(1); } }