public void AtualizaFilePathImagemBannerPrincipal(int idBannerPrincipal, string filePath)
 {
     try
     {
         using (var context = new CirculoNegocioEntities())
         {
             tbBannerPrincipal banner = (from p in context.tbBannerPrincipals where p.id == idBannerPrincipal select p).First();
             banner.imagemFilePath = filePath;
             context.SaveChanges();
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
        private tbBannerPrincipal CastBannerPrincipal(BannerPrincipalEntity banner)
        {
            tbBannerPrincipal tb = new tbBannerPrincipal();

            tb.Ativo     = banner.Ativo;
            tb.dataAte   = banner.dataAte;
            tb.dataDe    = banner.dataDe;
            tb.estado    = banner.estado;
            tb.idCliente = banner.idCliente;
            tb.responsavelUltimaAlteracao = banner.responsavelUltimaAlteracao;
            tb.DataUltimaAlteracao        = banner.DataUltimaAlteracao;
            tb.Descricao = banner.Descricao;
            tb.Rodape1   = banner.Rodape1;
            tb.Rodape2   = banner.Rodape2;

            return(tb);
        }
        public bool DeletaBannerPrincipal(int id)
        {
            try
            {
                using (var context = new CirculoNegocioEntities())
                {
                    tbBannerPrincipal delete = (from p in context.tbBannerPrincipals where p.id == id select p).First();
                    context.tbBannerPrincipals.DeleteObject(delete);
                    context.SaveChanges();
                }

                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
        public int InsereBannerPrincipal(BannerPrincipalEntity banner)
        {
            int idBannerPrincipal = 0;

            try
            {
                using (var context = new CirculoNegocioEntities())
                {
                    tbBannerPrincipal tb = CastBannerPrincipal(banner);
                    context.tbBannerPrincipals.AddObject(tb);
                    context.SaveChanges();

                    idBannerPrincipal = tb.id;
                }


                return(idBannerPrincipal);
            }
            catch (Exception)
            {
                return(0);
            }
        }