public void PreencheComponentesExpansiveis(int idFormVersao, List<FormularioComponente> listaComponentes, int idProjeto)
{
var _listaComponentesExpansiveis = listaComponentes.Where(l => l.IsExpansivel);
if (_listaComponentesExpansiveis != null)
{
List<ComponenteExpansao> novaListaComponenteExpansao = new List<ComponenteExpansao>();
ComponenteExpansao _ComponenteExpansao;
using (SqlConnection cn = new SqlConnection(helper.ConnectionString))
{
string sql = "select * from PC_Formulario_Componentes_FCP inner join PC_Componente_Expansao_CEX on FCP_ID = CEX_FCP_ID where FCP_FRV_ID = @FCP_FRV_ID and CEX_IS_ATIVO = 1 AND CEX_PRJ_ID = @CEX_PRJ_ID";
SqlParameter[] param = {
new SqlParameter("@FCP_FRV_ID", idFormVersao),
new SqlParameter("@CEX_PRJ_ID", idProjeto),
};
cn.Open();
try
{
SqlDataReader reader = helper.ExecuteReader(CommandType.Text, sql, param);
while (reader.Read())
{
_ComponenteExpansao = new ComponenteExpansao();
_ComponenteExpansao.Id = Convert.ToInt32(reader["CEX_ID"]);
_ComponenteExpansao.IdFormularioComponente = Convert.ToInt32(reader["CEX_FCP_ID"]);
_ComponenteExpansao.Ordem = Convert.ToInt32(reader["CEX_ORDEM"]);
_ComponenteExpansao.IdProjeto = Convert.ToInt32(reader["CEX_PRJ_ID"]);
novaListaComponenteExpansao.Add(_ComponenteExpansao);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
cn.Close();
}
}
foreach (var item in _listaComponentesExpansiveis.ToList())
{
item.ListaComponenteExpansao.AddRange(novaListaComponenteExpansao.Where(e => e.IdFormularioComponente == item.Id));
}
}
}
public int gravarComponenteExpansao(ComponenteExpansao componenteExpansao)
{
int idRetorno = 0;
using (SqlConnection cn = new SqlConnection(helper.ConnectionString))
{
cn.Open();
//Drop
try
{
string sql = "insert into PC_Componente_Expansao_CEX OUTPUT Inserted.CEX_ID values (@CEX_FCP_ID, @CEX_PRJ_ID, @CEX_ORDEM, 1)";
SqlParameter[] param = {
new SqlParameter("@CEX_FCP_ID", componenteExpansao.IdFormularioComponente),
new SqlParameter("@CEX_PRJ_ID", componenteExpansao.IdProjeto),
new SqlParameter("@CEX_ORDEM", componenteExpansao.Ordem)
};
object ret = helper.ExecuteScalar(CommandType.Text, sql, param);
if (ret != null)
idRetorno = Convert.ToInt32(ret);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
cn.Close();
}
}
return idRetorno;
}
public ActionResult CriaComponenteExpansao(int idComponente, int ordemForm, int ordemCompForm)
{
Data.DB _db = new Data.DB();
ComponenteExpansao model = new ComponenteExpansao();
model.Elementos = _db.getComponenteElementos(idComponente);
model.Ordem = ordemForm;
model.OrdemComponenteForm = ordemCompForm;
foreach (var elemento in model.Elementos)
{
if (elemento.IdTipoElemento == 5 || elemento.IdTipoElemento == 7) //combo || radio
elemento.Valores = _db.getFormElementoValores(elemento.Id);
}
return PartialView("ComponenteExpansao", model);
}