EngramaCoreStandar 1.0.7

Engrama Core

A comprehensive library of functions and processes designed to simplify software development. Access databases, integrate with APIs, generate documents, and handle JSON—everything required for day-to-day operations, conveniently available in a single NuGet package.

Instalations

To install Engrama Core in your .NET API, follow these steps

• In Program.cs, add the following line:

using EngramaCoreStandar.Extensions;

builder.Services.AddEngramaDependenciesAPI();

How to use it ?

• In your controller, add the following parameter to the constructor:

[ApiController]
[Route("api/[controller]")]
public class QuickRequestController : ControllerBase
{
	private readonly IDapperManagerHelper managerHelper;

	public QuickRequestController(IDapperManagerHelper managerHelper)
	{
		this.managerHelper = managerHelper;
	}
}

• In your endpoint, add the following code to call the stored procedure in the database: This is only an example — use your own procedure and attributes.

[HttpPost("PostCallDB")]
public async Task<IActionResult> PostTestTable([FromBody] PostModelTestTable postModel)
{

   //The tool need one class to send at the procedure and other class the one will receive the data. (Request and resutl)
	var DAOmodel = new spGetTestTable.Request();
	var result = await managerHelper.GetAllAsync<spGetTestTable.Result, spGetTestTable.Request>(DAOmodel, "");


	if (result.Ok)
	{
		return Ok(result.Data);
	}
	return BadRequest(result);
}
public class PostModelTestTable
{

}

public class spGetTestTable
{
	public class Request : SpRequest
	{
		public string StoredProcedure { get => "spGetTestTable"; }
	}
	public class Result : DbResult
	{
		public bool bResult { get; set; }
		public string vchMessage { get; set; }
		public int iIdTest_Table { get; set; }
		public string vchName { get; set; }
		public string vchEmail { get; set; }
		public DateTime dtRegistered { get; set; }
	}
}

Documentation

Discover how Engrama Core and Engrama Tools work by following our YouTube channel. Watch our tutorials to make the most of these powerful tools Canal de Youtube Use our documentation to implement the NuGet package and take full advantage of all the tools Engrama Core offers. Engrama Documentacion

Characteristics

• Perform database queries efficiently
• Integrate with APIs seamlessly
• Send emails with ease
• Read and create Excel files effortlessly
• Implement JWT authentication securely
• Utilize robust logging mechanisms
• Read and generate PDF documents
• Use variable extensions to streamline validations and simplify functions

Engrama Tools

• Engrama tools

A web application built to fully leverage the capabilities of EngramaCore. By analyzing the database, it provides the essential code to facilitate database queries seamlessly from the service layer to the architecture layer, along with numerous additional tools and features.

🔗 Links

🛠 Skills

• C#
• SQL
• .NET Core
• Blazor (Opcional)
• Visual Studio 2022

Authors

• @IscMagdaleno

Comments

For any questions or feedback, don't hesitate to reach out to us at engramahelper@gmail.com.