public async Task <IHttpActionResult> PutMinisterioCelula(int id, MinisterioCelula ministerioCelula)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != ministerioCelula.IdMinisterioCelula)
            {
                return(BadRequest());
            }

            db.Entry(ministerioCelula).State = EntityState.Modified;

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!MinisterioCelulaExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Пример #2
0
        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);
        }
Пример #3
0
        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);
        }
        public async Task <IHttpActionResult> GetMinisterioCelula(int id)
        {
            MinisterioCelula ministerioCelula = await db.MinisterioCelula.FindAsync(id);

            if (ministerioCelula == null)
            {
                return(NotFound());
            }

            return(Ok(ministerioCelula));
        }
        public async Task <IHttpActionResult> PostMinisterioCelula(MinisterioCelula ministerioCelula)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.MinisterioCelula.Add(ministerioCelula);
            await db.SaveChangesAsync();

            return(CreatedAtRoute("DefaultApi", new { id = ministerioCelula.IdMinisterioCelula }, ministerioCelula));
        }
        public async Task <IHttpActionResult> DeleteMinisterioCelula(int id)
        {
            MinisterioCelula ministerioCelula = await db.MinisterioCelula.FindAsync(id);

            if (ministerioCelula == null)
            {
                return(NotFound());
            }

            db.MinisterioCelula.Remove(ministerioCelula);
            await db.SaveChangesAsync();

            return(Ok(ministerioCelula));
        }
Пример #7
0
        public async Task <IHttpActionResult> DeleteMinisterioCelula(int id)
        {
            MinisterioCelula ministerioCelula = await db.MinisterioCelula.FindAsync(id);

            if (ministerioCelula == null)
            {
                return(NotFound());
            }

            db.MinisterioCelula.Remove(ministerioCelula);
            await db.SaveChangesAsync();

            db.DadoExcluido.Add(new DadoExcluido {
                Entidade = ministerioCelula.GetType().Name, IdDado = id
            });
            await db.SaveChangesAsync();

            return(Ok(ministerioCelula));
        }