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