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