private async Task SetupForm(DBFormInstance form) { DBCustomForm oCustom = await GetCustomForm(form.CustomFormID); form.CustomFormTypeTitle = oCustom?.Title; form.StatusText = fldFormCapCommon.StatusList[form.Status]; }
public async Task <int> DeleteForm(string FormID) { DBFormInstance oForm = await GetForm(FormID); if (oForm != null) { foreach (var field in oForm.Fields) { await AsyncDb.DeleteAsync(field.Value); } foreach (var attach in oForm.Attachments) { await AsyncDb.DeleteAsync(attach); } return(await AsyncDb.DeleteAsync(oForm)); } else { return(-1); } }
public async Task <int> SaveForm(DBFormInstance form) { try { if (await GetForm(form.FormInstanceID) != null) { return(await AsyncDb.UpdateAsync(form)); } else { return(await AsyncDb.InsertAsync(form)); } //save attachments too from form.Attachments } catch (Exception ex) { //Insights.Report(ex); throw; } }
public async Task <DBFormInstance> GetForm(string FormID) { DBFormInstance form = await AsyncDb.Table <DBFormInstance>().Where(x => x.FormInstanceID == FormID).FirstOrDefaultAsync(); if (form != null) { await SetupForm(form); List <DBFormField> _fields = await AsyncDb.Table <DBFormField>().Where(fld => fld.FormInstanceID == form.FormInstanceID).ToListAsync(); form.Fields = new Dictionary <string, DBFormField>(); foreach (DBFormField field in _fields) { form.Fields.Add(field.FieldName, field); } List <DBFormInstanceAttachment> _attachments = await AsyncDb.Table <DBFormInstanceAttachment>().Where(fld => fld.FormInstanceID == form.FormInstanceID).ToListAsync(); foreach (DBFormInstanceAttachment attach in _attachments) { form.Attachments.Add(attach); } } return(form); }
public Task <GenericResponse <bool> > UploadForm(DBFormInstance Form, string FileGUID) { throw new NotImplementedException(); }