2024-11-08 08:08:54 +00:00
|
|
|
|
using data.RemoteData;
|
|
|
|
|
using Data.LocalData;
|
|
|
|
|
using Data.Models;
|
|
|
|
|
using Data.RemoteData.DAO;
|
|
|
|
|
using System;
|
|
|
|
|
using System.Collections.Generic;
|
|
|
|
|
using System.Linq;
|
|
|
|
|
using System.Text;
|
|
|
|
|
using System.Threading.Tasks;
|
|
|
|
|
|
|
|
|
|
namespace Data.Repository
|
|
|
|
|
{
|
|
|
|
|
public class SQLGroupRepositoryImpl:IGroupRepository
|
|
|
|
|
{
|
|
|
|
|
private readonly RemoteDataBaseContext _remoteDataBaseContext;
|
|
|
|
|
|
|
|
|
|
public SQLGroupRepositoryImpl(RemoteDataBaseContext remoteDataBaseContext) {
|
|
|
|
|
_remoteDataBaseContext = remoteDataBaseContext;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public bool AddGroup(GroupLocalEntity newGroup)
|
|
|
|
|
{
|
2024-11-08 08:29:02 +00:00
|
|
|
|
GroupDao groupDao = new GroupDao { GroupName = newGroup.Name };
|
2024-11-08 08:08:54 +00:00
|
|
|
|
var result = _remoteDataBaseContext.Group.Add(groupDao);
|
|
|
|
|
if (result != null) {
|
|
|
|
|
_remoteDataBaseContext.SaveChanges();
|
|
|
|
|
return true; }
|
|
|
|
|
return false;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public List<GroupLocalEntity> GetAllGroup()
|
|
|
|
|
{
|
|
|
|
|
return _remoteDataBaseContext.Group.Select(group => new GroupLocalEntity{
|
|
|
|
|
Id = group.Id,
|
2024-11-08 08:29:02 +00:00
|
|
|
|
Name = group.GroupName}
|
2024-11-08 08:08:54 +00:00
|
|
|
|
).ToList();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public List<GroupLocalEntity> GetAllGroups() => LocalStaticData.groups;
|
|
|
|
|
|
|
|
|
|
public GroupLocalEntity GetGroupById(int groupID)
|
|
|
|
|
{
|
|
|
|
|
throw new NotImplementedException();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public bool RemoveGroupById(int groupID)
|
|
|
|
|
{
|
|
|
|
|
throw new NotImplementedException();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public bool UpdateGroupById(int groupID, GroupLocalEntity updatedGroup)
|
|
|
|
|
{
|
|
|
|
|
throw new NotImplementedException();
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
}
|