public SqlCommand UP__Table__Account__Update(SqlConnection connection = null, SqlTransaction transaction = null)
{
SqlCommand cmd = new SqlCommand()
{
Connection = connection,
CommandType = CommandType.StoredProcedure,
CommandText = @"[customer].[UP__Table__Account__Update]",
Transaction = transaction,
};
SqlParameter[] pa = new SqlParameter[]
{
ParameterFactory.ReturnValueParameter(),
ParameterFactory.PrimaryKeyParameter(parameterName: "@pAccountID", sourceColumn: "AccountID", forInsert: false),
ParameterFactory.RowVersionParameter(forInsert: false),
ParameterFactory.ForeignKeyParameter(parameterName: "@pCustomerID", sourceColumn: "CustomerID"),
ParameterFactory.NVarCharCodeParameter(),
ParameterFactory.NVarCharEntityNameParameter(parameterName: "@pAccount", sourceColumn: "Account"),
ParameterFactory.BitParameter(parameterName: "@pActive", sourceColumn: "Active"),
};
cmd.Parameters.AddRange(pa);
return(cmd);
}
public SqlCommand UP__Table__Customer__Delete(SqlConnection connection = null, SqlTransaction transaction = null)
{
SqlCommand cmd = new SqlCommand()
{
Connection = connection,
CommandType = CommandType.StoredProcedure,
CommandText = @"[customer].[UP__Table__Customer__Delete]",
Transaction = transaction,
};
SqlParameter[] pa = new SqlParameter[]
{
ParameterFactory.ReturnValueParameter(),
ParameterFactory.PrimaryKeyParameter(parameterName: "@pCustomerID", sourceColumn: "CustomerID", forInsert: false),
ParameterFactory.RowVersionParameter(forInsert: false),
};
cmd.Parameters.AddRange(pa);
return(cmd);
}