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)); }
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)); }