Desarrolla Sistemas en C# .Net - 4 capas con SQL Server

Develop robust desktop information management systems with C# .NET and SQL Server. This course guides you through building a scalable and maintainable application using the latest .NET Framework. Learn to leverage SQL Server with stored procedures for efficient data communication.

• Technology Stack:

  • C# .NET: Master the C# programming language for building powerful desktop applications.
  • SQL Server: Utilize SQL Server as a robust database management system.
  • Stored Procedures: Implement stored procedures for secure and efficient data access.
  • Windows Forms: Design user-friendly interfaces with Windows Forms.
  • Microsoft Visual Studio 2019/2022: Work with the industry-standard IDE (Visual Studio 2022 is also supported).
  • Layered Architecture: Understand and implement a robust, scalable, and maintainable layered project architecture.

• Project: Complete Purchase and Sales Management System

  Build a comprehensive desktop application from scratch, featuring:

  • CRUD Operations: Implement Create, Read, Update, and Delete operations for independent and relational tables.
  • Master-Detail Tables: Manage data with master-detail relationships.
  • Access Control: Implement user roles and permissions for secure access.
  • Reporting & Queries: Generate custom queries and reports.

• Key Modules:

  • Warehouse (Almacén) Module:

    • Item Management: Manage items with categories, barcodes, names, stock levels, selling prices, descriptions, and images.
    • Barcode Generation: Generate and print barcodes.
    • Category Management: Organize items with a hierarchical category system.

  • Purchases (Compras) Module:

    • Supplier Management: Manage supplier information (name, type, document number, address, email, phone).
    • Receipts (Ingresos): Manage incoming stock with details like supplier, date, document type (Invoice, Ticket), document number, and tax. Include item selection, quantity, purchase price, and selling price.
    • PDF & Report Export: Export purchase documents and reports in PDF format.

  • Sales (Ventas) Module:

    • Customer Management: Manage customer information (name, type, document number, address, email, phone).
    • Sales Transactions: Manage sales with customer details, date, document type (Invoice, Ticket), document number, tax, item selection, quantity, selling price, and discounts.
    • PDF & Report Export: Export sales documents and reports in PDF format.

  • Access Control Module:

    • Roles: Define roles (Administrator, Seller, Warehouse Staff) with specific permissions.
    • Users: Manage user accounts with details like name, document number, address, phone, email, job title, encrypted login, and assigned role.

  • Reporting:

    • Sales Inquiry: Search for sales within specified date ranges.
    • Export Formats: Export reports in PDF, Word, and Excel formats.

This course provides practical skills for developing powerful and efficient desktop applications using C# .NET, empowering you to build custom solutions for data management and business operations.