49 lines
1.2 KiB
C#
49 lines
1.2 KiB
C#
|
using Microsoft.EntityFrameworkCore;
|
||
|
|
using Renis.Database;
|
||
|
|
using Renis.Database.Models;
|
||
|
|
|
||
|
|
namespace Renis.Repositories;
|
||
|
|
|
||
|
|
public class UserPolisRepository(ApplicationContext db) : IUserPolisRepository
|
||
|
|
{
|
||
|
|
private readonly ApplicationContext _db = db;
|
||
|
|
|
||
|
|
public async Task<bool> AddUserPolis(UserPolis userPolis)
|
||
|
|
{
|
||
|
|
_db.UserPolises.Add(userPolis);
|
||
|
|
return await Save();
|
||
|
|
}
|
||
|
|
|
||
|
|
public async Task<bool> UpdateUserPolis(UserPolis userPolis)
|
||
|
|
{
|
||
|
|
_db.UserPolises.Update(userPolis);
|
||
|
|
return await Save();
|
||
|
|
}
|
||
|
|
|
||
|
|
public async Task<bool> DeleteUserPolis(UserPolis userPolis)
|
||
|
|
{
|
||
|
|
_db.UserPolises.Remove(userPolis);
|
||
|
|
return await Save();
|
||
|
|
}
|
||
|
|
|
||
|
|
public async Task<UserPolis?> GetUserPolisById(long id)
|
||
|
|
{
|
||
|
|
return await _db.UserPolises.FirstOrDefaultAsync(x => x.Id == id);
|
||
|
|
}
|
||
|
|
|
||
|
|
public async Task<UserPolis?> GetUserPolisByUserIdAndPolisId(long userId, long polisId)
|
||
|
|
{
|
||
|
|
return await _db.UserPolises.FirstOrDefaultAsync(x => x.UserId == userId && x.PolisId == polisId);
|
||
|
|
}
|
||
|
|
|
||
|
|
public IQueryable<UserPolis> GetUserPolises()
|
||
|
|
{
|
||
|
|
return _db.UserPolises.AsQueryable();
|
||
|
|
}
|
||
|
|
|
||
|
|
public async Task<bool> Save()
|
||
|
|
{
|
||
|
|
return await _db.SaveChangesAsync() > 0;
|
||
|
|
}
|
||
|
|
}
|