Add Other Methods To Repository

Repository Setup:

1. • Created a repository interface and its implementation (SQLServerRegionRepository).
   • Defined methods (GetByIdAsync, CreateAsync, UpdateAsync, and DeleteAsync) to handle CRUD operations for Region.
2. Implementation Details:
   • GetByIdAsync: Retrieves a single entity by its ID using FirstOrDefaultAsync.
   • CreateAsync: Adds a new entity using AddAsync and saves changes with SaveChangesAsync.
   • UpdateAsync: Updates an existing entity by first checking its existence, then modifying properties, and saving changes.
   • DeleteAsync: Removes an entity by ID if it exists, using Remove and SaveChangesAsync.
3. Controller Refactor:
   • Replaced direct database context (DbContext) calls in the controller with calls to the repository methods.
   • Ensured methods like GetByIdAsync, CreateAsync, UpdateAsync, and DeleteAsync in the repository are asynchronous.
   • Properly mapped Data Transfer Objects (DTOs) to domain models before sending them to the repository and vice versa.
4. Additional Notes:
   • Adopted nullable annotations to account for scenarios where an entity might not be found.
   • Updated naming conventions to reflect asynchronous methods (e.g., appending Async to method names).
   • Utilized LINQ expressions for querying the database.

This approach encapsulates data access logic within the repository, adhering to the Single Responsibility Principle and improving code maintainability and testability.