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