public SqlCommand UP__Table__Account__Delete(SqlConnection connection = null, SqlTransaction transaction = null)
        {
            SqlCommand cmd = new SqlCommand()
            {
                Connection  = connection,
                CommandType = CommandType.StoredProcedure,
                CommandText = @"[customer].[UP__Table__Account__Delete]",
                Transaction = transaction,
            };

            SqlParameter[] pa = new SqlParameter[]
            {
                ParameterFactory.ReturnValueParameter(),
                           ParameterFactory.PrimaryKeyParameter(parameterName: "@pAccountID", sourceColumn: "AccountID", forInsert: false),
                ParameterFactory.RowVersionParameter(forInsert: false),
            };

            cmd.Parameters.AddRange(pa);

            return(cmd);
        }
        public SqlCommand UP__Table__Customer__Insert(SqlConnection connection = null, SqlTransaction transaction = null)
        {
            SqlCommand cmd = new SqlCommand()
            {
                Connection  = connection,
                CommandType = CommandType.StoredProcedure,
                CommandText = @"[customer].[UP__Table__Customer__Insert]",
                Transaction = transaction,
            };

            SqlParameter[] pa = new SqlParameter[]
            {
                ParameterFactory.ReturnValueParameter(),
                           ParameterFactory.PrimaryKeyParameter(parameterName: "@pCustomerID", sourceColumn: "CustomerID", forInsert: true),
                ParameterFactory.RowVersionParameter(forInsert: true),
                ParameterFactory.NVarCharCodeParameter(),
                ParameterFactory.NVarCharEntityNameParameter(parameterName: "@pCustomer", sourceColumn: "Customer"),
                ParameterFactory.BitParameter(parameterName: "@pActive", sourceColumn: "Active"),
            };

            cmd.Parameters.AddRange(pa);

            return(cmd);
        }
Esempio n. 3
0
 public CommandFactory()
 {
     ParameterFactory = new ParameterFactory();
 }