public async System.Threading.Tasks.Task <META_FIELD> CreateAndSaveAsync(META_FIELD mETA_FIELD, string userName) { mETA_FIELD = Create(mETA_FIELD, userName); db.META_FIELD.Add(mETA_FIELD); await db.SaveChangesAsync(); return(mETA_FIELD); }
public async Task <IHttpActionResult> PostMETA_FIELD(META_FIELD mETA_FIELD) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } mETA_FIELD = await new MetaFieldRepo().CreateAndSaveAsync(mETA_FIELD, User.Identity.Name); return(CreatedAtRoute("DefaultApi", new { id = mETA_FIELD.META_FIELD_ID }, mETA_FIELD)); }
public META_FIELD Create(META_FIELD mETA_FIELD, string userName) { mETA_FIELD.DB_NAME = Helper.cleanDBName(mETA_FIELD.DB_NAME); mETA_FIELD.CREATED_BY = userName; mETA_FIELD.UPDATED_BY = userName; mETA_FIELD.STATUS = "NEW"; return(mETA_FIELD); }
public async Task <IHttpActionResult> GetMETA_FIELD(long id) { META_FIELD mETA_FIELDs = await db.META_FIELD.FindAsync(id); if (mETA_FIELDs == null) { return(NotFound()); } return(Ok(mETA_FIELDs)); }
public async Task <IHttpActionResult> DeleteMETA_FIELD(long id) { META_FIELD mETA_FIELD = await db.META_FIELD.FindAsync(id); if (mETA_FIELD == null) { return(NotFound()); } mETA_FIELD.STATUS = "[deleted]" + mETA_FIELD.STATUS; db.Entry(mETA_FIELD).State = EntityState.Modified; try { await db.SaveChangesAsync(); return(Ok(new { success = true })); } catch (DbEntityValidationException ex) { return(Ok(new { success = false })); } }
public async Task <IHttpActionResult> PutMETA_FIELD(long id, META_FIELD model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } META_FIELD metafeldDB = await db.META_FIELD.FindAsync(id); if (metafeldDB == null) { return(NotFound()); } if (metafeldDB.STATUS.Trim() == "NEW") { metafeldDB.DB_NAME = model.DB_NAME; metafeldDB.DB_NULL = 1;//model.DB_NULL; } if (metafeldDB.STATUS.Trim() == "NEW" || (metafeldDB.FORM_TYPE != "v-datepicker" & metafeldDB.FORM_TYPE != "v-checkbox")) { metafeldDB.FORM_TYPE = model.FORM_TYPE; } metafeldDB.GRID_NAME = model.GRID_NAME; metafeldDB.GRID_SHOW = model.GRID_SHOW; metafeldDB.GRID_FORMAT = model.GRID_FORMAT; metafeldDB.FORM_NAME = model.FORM_NAME; metafeldDB.FORM_SOURCE = model.FORM_SOURCE; metafeldDB.FORM_OPTIONAL = model.FORM_OPTIONAL; metafeldDB.IS_FILTER = model.IS_FILTER; metafeldDB.UPDATED_BY = User.Identity.Name; metafeldDB.UPDATED_DATE = DateTime.Now; if (!string.IsNullOrEmpty(model.JSON_DATA)) { metafeldDB.JSON_DATA = model.JSON_DATA; } db.Entry(metafeldDB).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException ex) { if (!META_FIELDExists(id)) { return(NotFound()); } else { throw; } } catch (DbEntityValidationException ex) { } return(StatusCode(HttpStatusCode.NoContent)); }