BusinessScaffold 1.0.1

BusinessScaffold Library

A .NET library for business order management operations with Entity Framework integration.

Features

• Order creation and management (CreateTestOrd, CreateMovOrd, UpdateTestOrd)
• Article record creation with LINQ and raw SQL approaches
• Support for multiple table types: artprotc, artproxtc, lotcprotc
• Stored procedure execution
• Tab number management (GetTabNuma, UpdateTabNuma)
• Built-in dependency injection support

Installation

As a NuGet Package

Build the project and reference the generated .dll file in your projects.

As a Project Reference

Add a project reference to your solution.

Usage

1. Add to Dependency Injection

using BusinessScaffold;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;

var host = Host.CreateDefaultBuilder(args)
    .ConfigureServices((context, services) =>
    {
        // Method 1: With connection string
        services.AddBusinessScaffold(connectionString);
        
        // Method 2: With custom DbContext configuration
        services.AddBusinessScaffold(options => 
            options.UseSqlServer(connectionString));
    })
    .Build();

2. Inject and Use the Repository

using businessScaffold;

public class YourService
{
    private readonly IOrdRepository _ordRepository;

    public YourService(IOrdRepository ordRepository)
    {
        _ordRepository = ordRepository;
    }

    public async Task ProcessOrder()
    {
        const string codditt = "COMPANY";
        const string tipork = "R";
        const short anno = 2025;
        const string serie = " ";
        
        // Get next order number
        var numOrd = await _ordRepository.GetTabNuma(tipork, serie, anno, codditt);
        
        // Create test order
        await _ordRepository.CreateTestOrd(codditt, tipork, 4010001, anno, serie, numOrd);
        
        // Add articles
        var articles = new List<ArticoToAdd>
        {
            new() { Codditt = codditt, Codart = "ART001", Prezzo = 10.00m }
        };
        await _ordRepository.CreateMovOrd(codditt, tipork, anno, serie, numOrd, articles);
        
        // Create article records
        await _ordRepository.CreateArtprotcRecordsRawSql(codditt, tipork, anno, serie, numOrd);
        await _ordRepository.CreateArtproxtcRecordsRawSql(codditt, tipork, anno, serie, numOrd);
        await _ordRepository.CreateLotcprotcRecordsRawSql(codditt, tipork, anno, serie, numOrd);
        
        // Update tab number
        await _ordRepository.UpdateTabNuma(tipork, serie, anno, codditt, numOrd);
    }
}

Available Methods

IOrdRepository Interface

• CreateTestOrd - Creates a test order
• UpdateTestOrd - Updates an existing test order
• CreateMovOrd - Creates order movements for articles
• RunStoreProcedure1 - Executes a stored procedure
• CreateArtprotcRecords - Creates artprotc records using LINQ
• CreateArtprotcRecordsRawSql - Creates artprotc records using raw SQL
• CreateArtproxtcRecordsRawSql - Creates artproxtc records using raw SQL
• CreateLotcprotcRecordsRawSql - Creates lotcprotc records using raw SQL
• GetTabNuma - Gets the next tab number
• UpdateTabNuma - Updates the tab number

Article Tables

The library supports three types of article tables:

1. artprotc - Article records with magazine support
2. artproxtc - Article records without magazine (simplified)
3. lotcprotc - Article records with lot, commercial category, and location support

Configuration

Make sure your appsettings.json contains the database connection string:

{
  "ConnectionStrings": {
    "CubezellaContext": "Server=your-server;Database=your-db;Trusted_Connection=true;"
  }
}

Requirements

• .NET 9.0
• Entity Framework Core 9.0.4
• SQL Server

License

[Your License Here]