public GroupUserLink GetById(int Id)
{
using (var context = new GFDbContext())
{
return(context.GroupUserLinks.SingleOrDefault(gu => gu.Id == Id));
}
}
public ICollection <Event> GetByGroupId(int GroupId)
{
using (var context = new GFDbContext())
{
return(context.Events.Where(e => e.GroupId == GroupId).ToList());
}
}
public JoinRequestStatus GetById(int joinRequestStatusId)
{
using (var context = new GFDbContext())
{
return(context.JoinRequestStatuses.Single(ms => ms.Id == joinRequestStatusId));
}
}
public Event GetById(int eventId)
{
using (var context = new GFDbContext())
{
return(context.Events.Single(e => e.Id == eventId));
}
}
public User GetById(string userId)
{
using (var context = new GFDbContext())
{
return(context.Users.Single(u => u.Id == userId));
}
}
public ICollection <GroupUserLink> GetByGroupId(int groupId)
{
using (var context = new GFDbContext())
{
return(context.GroupUserLinks.Where(gu => gu.GroupId == groupId).ToList());
}
}
public ICollection <GroupUserLink> GetByUserId(string userId)
{
using (var context = new GFDbContext())
{
return(context.GroupUserLinks.Where(gu => gu.UserId == userId).ToList());
}
}
public Group GetById(int groupId)
{
using (var context = new GFDbContext())
{
var group = context.Groups.Include(g => g.Events).SingleOrDefault(g => g.Id == groupId);
return(group);
}
}
public ICollection <JoinRequestStatus> GetAll()
{
using (var context = new GFDbContext())
{
var alljrs = context.JoinRequestStatuses.ToList();
return(alljrs);
}
}
public ICollection <Group> GetAll()
{
using (var context = new GFDbContext())
{
var allGroups = context.Groups.ToList();
return(allGroups);
}
}
public Event Create(Event newEvent)
{
using (var context = new GFDbContext())
{
context.Events.Add(newEvent);
context.SaveChanges();
return(newEvent);
}
}
public Group Create(Group newGroup)
{
using (var context = new GFDbContext())
{
context.Groups.Add(newGroup);
context.SaveChanges();
return(newGroup);
}
}
public User Create(User newUser)
{
using (var context = new GFDbContext())
{
context.Users.Add(newUser);
context.SaveChanges();
return(newUser);
}
}
public GroupUserLink Create(GroupUserLink newGroupUserLink)
{
using (var context = new GFDbContext())
{
context.GroupUserLinks.Add(newGroupUserLink);
context.SaveChanges();
return(newGroupUserLink);
}
}
public User Update(User updatedUser)
{
using (var context = new GFDbContext())
{
var existingUser = GetById(updatedUser.Id);
context.Entry(existingUser).CurrentValues.SetValues(updatedUser);
context.SaveChanges();
return(existingUser);
}
}
public GroupUserLink Update(GroupUserLink updatedGroupUserLink)
{
using (var context = new GFDbContext())
{
var existingGroupUserLink = GetById(updatedGroupUserLink.Id);
context.Entry(existingGroupUserLink).CurrentValues.SetValues(updatedGroupUserLink);
context.SaveChanges();
return(existingGroupUserLink);
}
}
public Event Update(Event updatedEvent)
{
using (var context = new GFDbContext())
{
var existingEvent = GetById(updatedEvent.Id);
context.Entry(existingEvent).CurrentValues.SetValues(updatedEvent);
context.SaveChanges();
return(existingEvent);
}
}
public Group Update(Group Group)
{
using (var context = new GFDbContext())
{
var existingGroup = GetById(Group.Id);
context.Update(Group);
context.SaveChanges();
return(Group);
}
}
public bool DeleteById(int groupId)
{
using (var context = new GFDbContext())
{
var group = GetById(groupId);
context.Remove(group);
context.SaveChanges();
if (GetById(groupId) == null)
{
return(true);
}
return(false);
}
}
public bool DeleteById(int eventId)
{
using (var context = new GFDbContext())
{
var GFevent = GetById(eventId);
context.Remove(GFevent);
context.SaveChanges();
if (GetById(eventId) == null)
{
return(true);
}
return(false);
}
}
public bool DeleteById(string userId)
{
using (var context = new GFDbContext())
{
var user = GetById(userId);
context.Remove(user);
context.SaveChanges();
if (GetById(userId) == null)
{
return(true);
}
return(false);
}
}
