public List <modelocrud> buscarCelulas(int?id) { Select_padrao = "select * from Celula as C " + " inner join MinisterioCelula as MICE on C.IdCelula=MICE.CelulaId" + " inner join Ministerio as M on MICE.MinisterioId=M.IdMinisterio" + $" where MICE.MinisterioId='{id}'"; List <modelocrud> modelos = new List <modelocrud>(); var conecta = bd.obterconexao(); conecta.Open(); SqlCommand comando = new SqlCommand(Select_padrao, conecta); SqlDataReader dr = comando.ExecuteReader(); if (dr.HasRows == false) { bd.obterconexao().Close(); return(modelos); } var lista = new MinisterioCelula().recuperar(null).OfType <MinisterioCelula>().ToList(); while (dr.Read()) { var m = lista.First(i => i.CelulaId == int.Parse(Convert.ToString(dr["CelulaId"]))); modelos.Add(m); } dr.Close(); bd.obterconexao().Close(); return(modelos); }
public List <modelocrud> recuperarMinisterios(int?id) { var select = "select * from Ministerio as m inner join " + " MinisterioCelula as mice on m.IdMinisterio=mice.MinisterioId inner join Celula as c" + $" on mice.CelulaId=c.IdCelula where mice.CelulaId='{id}' "; List <modelocrud> modelos = new List <modelocrud>(); var conecta = bd.obterconexao(); conecta.Open(); SqlCommand comando = new SqlCommand(select, conecta); SqlDataReader dr = comando.ExecuteReader(); if (dr.HasRows == false) { bd.obterconexao().Close(); return(modelos); } var lista = new MinisterioCelula().recuperar(null).OfType <MinisterioCelula>().ToList(); while (dr.Read()) { var m = lista.First(i => i.MinisterioId == int.Parse(Convert.ToString(dr["MinisterioId"]))); modelos.Add(m); } dr.Close(); bd.obterconexao().Close(); return(modelos); }