Exemple #1
0
        public int Modificar(object Obj)
        {
            BO.MetodoPagoBO Bo  = (BO.MetodoPagoBO)Obj;
            SqlCommand      Cmd = new SqlCommand("UPDATE [dbo].[MetodoPago]SET [TipoPago] = @TipoPago WHERE IdMetodoPago=@IdMetodoPago");

            Cmd.Parameters.Add("@IdTipoUsuario", SqlDbType.Int).Value = Bo.IdMetodoPago;
            Cmd.Parameters.Add("@TipoPago", SqlDbType.VarChar).Value  = Bo.TipoPago;
            Cmd.CommandType = CommandType.Text;
            return(OConexion.EjecutarSQL(Cmd));
        }
Exemple #2
0
        public int Agregar(object Obj)
        {
            BO.MetodoPagoBO oMetodo = (BO.MetodoPagoBO)Obj;
            SqlCommand      Cmd     = new SqlCommand("INSERT INTO [dbo].[MetodoPago]([TipoPago],[FechaRegistroMetPago],[StatusMetPago]) VALUES(@TipoPago,@FechaRegistroMetPago,@StatusMetPago)");

            //@TipoPago,@FechaRegistroMetPago,@StatusMetPago
            Cmd.Parameters.Add("@TipoPago", SqlDbType.VarChar).Value = oMetodo.TipoPago;
            Cmd.Parameters.Add("@FechaRegistroMetPago", SqlDbType.DateTime).Value = DateTime.Now.Date;
            Cmd.Parameters.Add("@StatusMetPago", SqlDbType.Bit).Value             = 1;
            Cmd.CommandType = CommandType.Text;
            return(OConexion.EjecutarSQL(Cmd));
        }