public IHttpActionResult PuttblAssetDef(decimal id, tblAssetDef tblAssetDef) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblAssetDef.ad_id) { return(BadRequest()); } db.Entry(tblAssetDef).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblAssetDefExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GettblAssetDef(decimal id) { tblAssetDef tblAssetDef = db.tblAssetDefs.Find(id); if (tblAssetDef == null) { return(NotFound()); } return(Ok(tblAssetDef)); }
public tblAssetDef Get(string name) { try { tblAssetDef adef = db.tblAssetDefs.Where(x => x.ad_name == name).FirstOrDefault(); return(adef); } catch (Exception ex) { Log.Debug(ex.Message); throw; } }
public IHttpActionResult DeletetblAssetDef(decimal id) { tblAssetDef tblAssetDef = db.tblAssetDefs.Find(id); if (tblAssetDef == null) { return(NotFound()); } db.tblAssetDefs.Remove(tblAssetDef); db.SaveChanges(); return(Ok(tblAssetDef)); }
public List <tblAssetType> Get(string name) { try { tblAssetDef adef = db.tblAssetDefs.Where(x => x.ad_name == name).FirstOrDefault(); List <tblAssetType> typeList = db.tblAssetTypes.Where(x => x.at_id == adef.ad_type_id).ToList(); return(typeList); } catch (Exception ex) { Log.Debug(ex.Message); List <tblAssetType> list = new List <tblAssetType>(); return(list); } }
public IHttpActionResult PosttblAssetDef(tblAssetDef tblAssetDef) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblAssetDefs.Add(tblAssetDef); db.SaveChanges(); } catch (Exception ex) { Log.Debug(ex.Message); } return(CreatedAtRoute("DefaultApi", new { id = tblAssetDef.ad_id }, tblAssetDef)); }