public FormSubmittedDto SaveForm(FormSubmittedDto formSubmittedDto)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var formSubmitted = new FormSubmitted()
{
FormId = formSubmittedDto.FormId,
MemberId = formSubmittedDto.MemberId,
WizarStepId = formSubmittedDto.WizarStepId,
DateCreated = DateTime.Now
};
_context.FormSubmitted.Add(formSubmitted);
_context.SaveChanges();
foreach (var answer in formSubmittedDto.SubmittedAnswers)
{
answer.FormSubmittedId = formSubmitted.FormSubmittedId;
_context.FormSubmittedAnswer.Add(answer);
_context.SaveChanges();
}
transaction.Commit();
var formSaved = _mapper.Map <FormSubmittedDto>(formSubmitted);
return(formSaved ?? null);
}
catch (Exception)
{
throw;
}
}
}
private void OnFormSubmitted()
{
frm_GetDatabaseConnectionPropertiesEventArgs args = new frm_GetDatabaseConnectionPropertiesEventArgs()
{
DataBaseType = cbx_DatabaseType.SelectedItem.ToString(),
ServerAddress = txt_ServerAddress.Text,
DatabaseName = txt_DatabaseName.Text,
UserName = txt_DatabaseUserName.Text,
Password = txt_DatabaseUserPassword.Text
};
FormSubmitted?.Invoke(this, args);
}
