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