BLL.Metas.Editar C# (CSharp) Method

Editar() public method

public Editar ( ) : bool
return bool
        public override bool Editar()
        {
            bool retorno = false;
            StringBuilder comando = new StringBuilder();

            try
            {
                retorno = conexion.Ejecutar(String.Format("update Metas set Descripcion = '{0}', UsuarioId = {1} where MetaId = {2}", this.Descripcion, this.UsuarioId, this.MetaId));
                if (retorno)
                {
                    retorno = conexion.Ejecutar(String.Format("delete from MetasDetalle where MetaId = {0}", this.MetaId));
                    foreach (var pro in metas)
                    {
                        comando.AppendLine(String.Format("insert into MetasDetalle(MetaId,TipoIngresoId,Monto) values({0},{1},{2})", this.MetaId, pro.TipoIngresoId, pro.Monto));
                    }

                    retorno = conexion.Ejecutar(comando.ToString());
                }
            }
            catch (Exception)
            {
                retorno = false;
            }

            return retorno;
        }

Usage Example

        public void EditarTest()
        {
            Metas meta = new Metas();
            meta.MetaId = 21;
            meta.Descripcion = "Mi Meta";
            meta.UsuarioId = 1;
            meta.AgregarMetas(21, 1, 200);

            Assert.IsTrue(meta.Editar());
        }
All Usage Examples Of BLL.Metas::Editar