/
weeny
/
database
Обзор
Документация
Войти
/
weeny
/
database
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
UserRepository.cs
59 строк
2 KB
weeny
create: build.bat, DatabaseProject.csproj, DatabaseService.cs, Program.cs, ProgramExamples.cs, README.md, UserRepository.cs
01 июн 2026, 20:14
Верифицирован
01 июн 2026, 20:14
7de0d86
Код
Авторство
О чём код?
using Microsoft.Data.Sqlite; using Dapper; using System.Data; using System.Collections.Generic; public class UserRepository { private readonly DatabaseService _dbService; public UserRepository(DatabaseService dbService) { _dbService = dbService; } public void CreateUser(User user) { var sql = @" INSERT INTO Users (Name, Email, Age) VALUES (@Name, @Email, @Age)"; _dbService.Execute(sql, user); } public User? GetUserById(int id) { var sql = "SELECT * FROM Users WHERE Id = @Id"; return _dbService.QueryFirstOrDefault<User>(sql, new { Id = id }); } public List<User> GetAllUsers() { var sql = "SELECT * FROM Users ORDER BY CreatedAt DESC"; return _dbService.Query<User>(sql); } public bool UpdateUser(User user) { var sql = @" UPDATE Users SET Name = @Name, Email = @Email, Age = @Age WHERE Id = @Id"; var affected = _dbService.Execute(sql, user); return affected > 0; } public bool DeleteUser(int id) { var sql = "DELETE FROM Users WHERE Id = @Id"; var affected = _dbService.Execute(sql, new { Id = id }); return affected > 0; } public List<User> GetUsersByAge(int minAge, int maxAge) { var sql = "SELECT * FROM Users WHERE Age BETWEEN @MinAge AND @MaxAge ORDER BY Age"; return _dbService.Query<User>(sql, new { MinAge = minAge, MaxAge = maxAge }); } }