public void Insert(FormularioModelView t)
{
using (TransactionScope scope = new TransactionScope())
{
var formularioDomain = FormularioMapper.FormularioDomainToFormularioModelView(t);
var _forma = new FormularioDomain()
{
DataVencimentoFim = formularioDomain.DataVencimentoFim,
DataVencimentoInicio = formularioDomain.DataVencimentoInicio,
DescricaoFormulario = formularioDomain.DescricaoFormulario,
NomeFormulario = formularioDomain.NomeFormulario
};
_db.FormularioRepositorio.Insert(_forma);
_db.Commit();
var idFormulario = _forma.IdFormulario;
foreach (var formularioCampo in formularioDomain.FormularioCampoes)
{
var _formularioCampo = new FormularioCampoDomain
{
IdFormulario = idFormulario,
IdTipoCampo = formularioCampo.IdTipoCampo,
IdTipoValorCampo = formularioCampo.IdTipoValorCampo,
DescricaoCampo = formularioCampo.DescricaoCampo
};
_db.FormularioCampoRepositorio.Insert(_formularioCampo);
_db.Commit();
var idFormularioCampo = _formularioCampo.IdFormularioCampo;
foreach (var valorCampo in formularioCampo.ValorCampoes)
{
var _valorCampo = new ValorCampoDomain
{
IdFormularioCampo = idFormularioCampo,
ValorCampo = valorCampo.ValorCampo
};
_db.ValorCampoRepositorio.Insert(_valorCampo);
}
_db.Commit();
}
scope.Complete();
}
}
public int Insert(ValorCampoDomain t)
{
using (var db = GetConnection())
{
DynamicParameters p = new DynamicParameters();
p.AddDynamicParams(
new
{
IdTipoCampo = t.IdTipoCampo,
IdFormulario = t.IdFormulario,
ValorCampo = t.ValorCampo
});
int resultado = db.Execute("sp_valor_campo_Inserir", p, commandType: CommandType.StoredProcedure);
return(0);
}
}
public void Insert(FormularioModelView t)
{
using (TransactionScope scope = new TransactionScope())
{
var formularioDomain = FormlarioMapper.FormularioDomainToFormularioModelView(t);
var idFormulario = _formularioRepository.Insert(formularioDomain);
foreach (var formularioCampo in formularioDomain.FormularioCampos)
{
formularioCampo.FormularioDomain = new FormularioDomain()
{
IdFormulario = idFormulario
};
_formularioCamposRepository.Insert(formularioCampo);
if (formularioCampo.ValoresCombobox != null && formularioCampo.ValoresCombobox.Count > 0)
{
ValorCampoDomain valorCampoDomain = null;
foreach (var item in formularioCampo.ValoresCombobox)
{
valorCampoDomain = new ValorCampoDomain()
{
IdFormulario = idFormulario, IdTipoCampo = formularioCampo.TipoCampo.IdTipoCampo, ValorCampo = item
};
_valorCampoRepository.Insert(valorCampoDomain);
}
}
else
{
var valorCampoDomain = new ValorCampoDomain()
{
IdFormulario = idFormulario, IdTipoCampo = formularioCampo.TipoCampo.IdTipoCampo, ValorCampo = formularioCampo.ValorCampo
};
_valorCampoRepository.Insert(valorCampoDomain);
}
}
scope.Complete();
}
}
public void Update(ValorCampoDomain t)
{
throw new NotImplementedException();
}
public async Task <FormularioDomain> GetById(int id)
{
FormularioDomain formualrio;
using (var db = GetConnection())
{
try
{
DynamicParameters p = new DynamicParameters();
p.AddDynamicParams(new
{
idFormulario = id
});
formualrio = new FormularioDomain();
Func <FormularioDomain, FormularioCampoDomain, TipoCampoDomain, TipoValorCampoDomain, ValorCampoDomain, FormularioDomain> mapper = ((f, fc, tc, tvc, vc) =>
{
if (vc == null)
{
vc = new ValorCampoDomain();
}
if (fc == null)
{
fc = new FormularioCampoDomain();
}
//fc.Add(tc);
//fc.TipoValorCampo = tvc;
//if (fc.ValorCampos == null || fc.ValorCampos.Count == 0)
//{
// fc.ValorCampos = new List<ValorCampoDomain>();
//}
//fc.ValorCampos.Add(vc);
if (f.FormularioCampos == null || f.FormularioCampos.Count == 0)
{
f.FormularioCampos = new List <FormularioCampoDomain>();
}
f.FormularioCampos.Add(fc);
return(f);
});
var query = db.Query <FormularioDomain, FormularioCampoDomain, TipoCampoDomain, TipoValorCampoDomain, ValorCampoDomain, FormularioDomain>
("sp_get_formulario_by_id", mapper, param: p, commandType: CommandType.StoredProcedure, splitOn: "DescricaoCampo,NomeTipoCampo,NomeTipoValorCampo,ValorCampo");
formualrio = query.FirstOrDefault();
}
catch (Exception ex)
{
throw;
}
}
return(formualrio);
}
